EO_CURRENCY_DTL(SQL Table) |
Index Back |
|---|---|
CCU Audit Detail Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | KEY1_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 1 Field Value |
| 3 | KEY2_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 2 Field Value |
| 4 | KEY3_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 3 Field Value |
| 5 | KEY4_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 4 Field Value |
| 6 | KEY5_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 5 Field Value |
| 7 | KEY6_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Created by MLE |
| 8 | KEY7_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 7 Field Value |
| 9 | KEY8_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 8 Field Value |
| 10 | KEY9_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 9 Field Value |
| 11 | KEY10_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 10 Field Value |
| 12 | KEY11_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 11 Field Value |
| 13 | KEY12_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 12 Field Value |
| 14 | KEY13_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 13 Field Value |
| 15 | KEY14_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 14 Field Value |
| 16 | KEY15_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 15 Field Value |
| 17 | KEY16_FLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | Key 16 Field Value |
| 18 | KEY1_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 1 Field Name |
| 19 | KEY2_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 2 Field Name |
| 20 | KEY3_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 3 Field Name |
| 21 | KEY4_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 4 Field Name |
| 22 | KEY5_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 5 Field Name |
| 23 | KEY6_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 6 Field Name |
| 24 | KEY7_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 7 Field Name |
| 25 | KEY8_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 8 Field Name |
| 26 | KEY9_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 9 Field Name |
| 27 | KEY10_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 10 Field Name |
| 28 | KEY11_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 11 Field Name |
| 29 | KEY12_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 12 Field Name |
| 30 | KEY13_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 13 Field Name |
| 31 | KEY14_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Key 14 Field Name |
| 32 | KEY15_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Created by MLE |
| 33 | KEY16_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Created by MLE |
| 34 | PROC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Uniquely identifies a Currency Conversion Process Group |
| 35 | RULE_INSTNC_NBR | Number(3,0) | SMALLINT NOT NULL | Rule Occurrence Number |
| 36 | FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | From Currency |
| 37 | TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Revalue Currency |
| 38 | ASOF_DT | Date(10) | DATE | As of Date |
| 39 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 40 | FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value |
| 41 | RT_MULT_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Rate Multiplier Field Name |
| 42 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 43 | RT_DIV_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Rate Divisor Field Name |
| 44 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 45 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 46 | EO_AUDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Audit Flag
1=Before 2=After |
| 47 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 48 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 49 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 50 | EXCEPTION_INFO | Character(35) | VARCHAR2(35) NOT NULL | Exception Process Information |