CCR_CRITERIA(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
Default Value: NEXT |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 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 Default Value: O |
| 8 | FROM_CUR_LED | Character(1) | VARCHAR2(1) NOT NULL |
Maintain Ledger in From Cur
Y/N Table Edit |
| 9 | ANALYSIS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
E=Error I=In Process N=New P=Processed V=Valid Default Value: N |