ANALYSIS_IDPrompt Table: BUS_UNIT_TBL_GL
Prompt Table: BUS_UNIT_TBL_GL
A=All Business Units
B=Between Range
E=Equal To
Prompt Table: CURRENCY_CD_TBL
C=Currency Conversion Utility
O=Online
CCR_TMP_CRIT(SQL Table) |
Index Back |
|---|---|
Ledger Analysis |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ANALYSIS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Analysis ID |
| 2 | AE_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Application Engine Status |
| 3 | FROM_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
From Business Unit
Prompt Table: BUS_UNIT_TBL_GL |
| 4 | TO_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit selection field
Prompt Table: BUS_UNIT_TBL_GL |
| 5 | SEL_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Selection
A=All Business Units B=Between Range E=Equal To |
| 6 | TO_CCR_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
To Currency
Prompt Table: CURRENCY_CD_TBL |
| 7 | ANALYSIS_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Origin
C=Currency Conversion Utility O=Online |
| 8 | FROM_CUR_LED | Character(1) | VARCHAR2(1) NOT NULL | Maintain Ledger in From Cur |