CNAO_BAL_STG(SQL Table) |
Index Back |
|---|---|
CNAO GL Bal Staging RecCNAO GL Bal Staging 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
Prompt Table: SP_BU_GL_NONVW |
| 3 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table: LED_GRP_LED_TBL |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 5 | ACCOUNTING_PERIOD |
Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 6 | CNAO_ACCOUNT |
Character(20) | VARCHAR2(20) NOT NULL | CNAO Account |
| 7 | SUBSDRY_ITEM_01 |
Character(30) | VARCHAR2(30) NOT NULL | Customer Subsidiary Item |
| 8 | SUBSDRY_ITEM_02 |
Character(25) | VARCHAR2(25) NOT NULL | Supplier Subsidiary |
| 9 | SUBSDRY_ITEM_03 |
Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 3 |
| 10 | SUBSDRY_ITEM_04 |
Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 4 |
| 11 | SUBSDRY_ITEM_05 |
Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 5 |
| 12 | SUBSDRY_ITEM_06 |
Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 6 |
| 13 | FOREIGN_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL |
Foreign Currency Code
Prompt Table: FRGN_CURR_VW |
| 14 | SUBSDRY_ITEM_07 | Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 7 |
| 15 | SUBSDRY_ITEM_08 | Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 8 |
| 16 | SUBSDRY_ITEM_09 | Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 9 |
| 17 | SUBSDRY_ITEM_10 | Character(25) | VARCHAR2(25) NOT NULL | Subsidiary Item 10 |
| 18 | SUBSDRY_ITEM_11 | Character(30) | VARCHAR2(30) NOT NULL | Subsidiary Item 11 |
| 19 | SUBSDRY_ITEM_12 | Character(30) | VARCHAR2(30) NOT NULL | Subsidiary Item 12 |
| 20 | SUBSDRY_ITEM_13 | Character(20) | VARCHAR2(20) NOT NULL | Subsidiary Item 13 |
| 21 | SUBSDRY_ITEM_14 | Character(20) | VARCHAR2(20) NOT NULL | Subsidiary Item 14 |
| 22 | SUBSDRY_ITEM_15 | Character(20) | VARCHAR2(20) NOT NULL | Subsidiary Item 15 |
| 23 | BAL_DIRECTION_BEG | Character(2) | VARCHAR2(2) NOT NULL |
Direction of Begin Balance
CR=CR DR=DR |
| 24 | BAL_DIRECTION_END | Character(2) | VARCHAR2(2) NOT NULL |
Direction of End Balance
CR=CR DR=DR |
| 25 | FOREIGN_BEG_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign Begin Bal |
| 26 | MONETARY_BEG_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary Begin Bal |
| 27 | FOREIGN_AMT_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Debit Amount |
| 28 | FOREIGN_AMT_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Credit Amount |
| 29 | MONETARY_AMT_DR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base DR Amount |
| 30 | MONETARY_AMT_CR | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base CR Amount |
| 31 | FOREIGN_END_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Foreign End Balance |
| 32 | MONETARY_END_BAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Monetary End Bal |