UPG_GFAPF04_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
6 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
9 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
10 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
12 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
13 EVENT_LINE Number(5,0) INTEGER NOT NULL Entry Event Line Number
14 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit
15 BUDGET_PERIOD Character(8) VARCHAR2(8) NOT NULL Budget Period
16 UPG_BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
17 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
18 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
19 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
20 BUDGET_REF_FLD Character(18) VARCHAR2(18) NOT NULL Field Name
21 BUDGET_REF_FLD2 Character(18) VARCHAR2(18) NOT NULL Field Name
22 COMPLETED_FLG Character(1) VARCHAR2(1) NOT NULL Completed
N=Not Completed
Y=Complete
23 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
24 BEGIN_DT Date(10) DATE Begin Date
25 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
26 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
27 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
28 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
29 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
30 TEMP_NBR1 Number(7,0) INTEGER NOT NULL Temporary Number