FS_ALLC_OUT_AET

(SQL Table)
Index Back

FS ALLC - Output state record

FS ALLC - Create Output state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 SQL_WHERE_001 Character(254) VARCHAR2(254) NOT NULL
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 RECNAME_SOURCE Character(15) VARCHAR2(15) NOT NULL Source Recname
5 RECNAME_TSUM_TAO Character(15) VARCHAR2(15) NOT NULL Target balance record name
6 RECNAME_TX_TAO Character(15) VARCHAR2(15) NOT NULL Translation Ledger line temp table
7 TARGET_RECNAME Character(15) VARCHAR2(15) NOT NULL Target Table Record Name
8 TOTAL_JRNL_LINES Number(12,0) DECIMAL(12) NOT NULL Total Journal Lines
9 TOTAL_JRNL Number(12,0) DECIMAL(12) NOT NULL Total Journals
10 BUDGET_JOURNAL Character(1) VARCHAR2(1) NOT NULL Commitment control budget journal flag.

Default Value: N

11 LAST_RESOURCE_ID Number(20,0) DECIMAL(20) NOT NULL Last Transaction ID
12 SQLROWS_POOL Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
13 SQLROWS_BASIS Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
14 SQLROWS_BSUM Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
15 SQLROWS_BSUM2 Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
16 SQLROWS_TARGET Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
17 SQLROWS_OFFSET Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
18 SQLROWS_TSUM Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
19 SQLROWS_OSUM Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
20 SQLROWS_TBAL Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
21 SQLROWS_TSEL_P Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
22 SQLROWS_TSEL_B Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
23 SQLROWS_BULED Number(12,0) DECIMAL(12) NOT NULL Used in GL Allocation AE programs (FS_ALLC)
24 SQLROWS_LOG Number(12,0) DECIMAL(12) NOT NULL Total Rows
25 SQLROWS_TAO Number(12,0) DECIMAL(12) NOT NULL Total Rows
26 TSUM_FLAG Character(1) VARCHAR2(1) NOT NULL Used in GL Allocations (FS_ALLC)
27 TRANSL_LEDGER Character(1) VARCHAR2(1) NOT NULL Currency Translation Ledger

Default Value: N

28 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. "