GL_XMLP_AET_H

(SQL Table)
Index Back

PS/Financials XMLP State Rec

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
5 AS_OF_DATE Date(10) DATE As of Date
6 KK_SOURCE_TRAN Character(10) VARCHAR2(10) NOT NULL Source Transaction Type
7 KK_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.
9 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
10 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
11 SEPARATE_DRCR Character(1) VARCHAR2(1) NOT NULL Enable Separate Debit/Credit
12 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID