GLRN_RECON_VW

(SQL View)
 Index Back

Account Recon Table

Account Reconciliation table - one row for each recon unit of work

SELECT A. GLRN_SET , A. GLRN_RULE , A. BUSINESS_UNIT , A. AS_OF_DATE , A. SEQUENCE_NBR_9 , A. PERIOD_END_DT , A. GLRN_UNIT_OF_RECON , A. ACCOUNT , A. ALTACCT , A. DEPTID , %subrec(CF12_AN_SBR,A) , A. PROJECT_ID , A. KEY_CHAR_30_01 , A. KEY_CHAR_30_02 , A. KEY_CHAR_30_03 , A. KEY_CHAR_30_04 , A. KEY_CHAR_30_05 , A. START_DATE , A. DUE_DATE , A. COMPLETE_DATE , A. CALC_NET_AMT , A. EXPECTED_AMT , A. CURRENCY_CD , A. BASE_AMT , A. BASE_CURRENCY , A. GLRN_RECON_STATUS , A. GLRN_REASON_CD , A. PROCESS_INSTANCE , CASE WHEN %DateIn(DUE_DATE) >= %CurrentDateIn THEN 'N' WHEN %DateIn(DUE_DATE) < %CurrentDateIn THEN 'Y' END FROM PS_GLRN_RECON_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GLRN_SET Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Set
2 GLRN_RULE Character(20) VARCHAR2(20) NOT NULL Account Reconciliation Rule ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 AS_OF_DATE Date(10) DATE As of Date
5 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence
6 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
7 GLRN_UNIT_OF_RECON Character(2) VARCHAR2(2) NOT NULL 2-Char Unit of Reconciliation
8 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
9 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
12 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
13 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
14 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
15 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
16 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
17 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
18 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
19 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
20 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
21 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
22 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
23 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
24 KEY_CHAR_30_01 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 01
25 KEY_CHAR_30_02 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 02
26 KEY_CHAR_30_03 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 03
27 KEY_CHAR_30_04 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 04
28 KEY_CHAR_30_05 Character(30) VARCHAR2(30) NOT NULL Key Char(30) 05
29 START_DATE Date(10) DATE Start Date for Gen Standing PO
30 DUE_DATE Date(10) DATE Delivery Due Date from PO
31 COMPLETE_DATE Date(10) DATE To save the task execution complete date
32 CALC_NET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Calculated net amount
33 EXPECTED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Expected amount
34 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
35 BASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus
36 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
37 GLRN_RECON_STATUS Character(1) VARCHAR2(1) NOT NULL Reconciliation Status
38 GLRN_REASON_CD Character(2) VARCHAR2(2) NOT NULL Status Change reason code
39 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
40 PAST_DUE_FLG Character(1) VARCHAR2(1) NOT NULL Past Due Flag

Y/N Table Edit