FS_ALLC_OUT_AET(SQL Table) |
Index Back |
---|---|
FS ALLC - Output state recordFS 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. " |