ITEMACTVAT_TEOA(SQL Table) |
Index Back |
---|---|
CCU Audit Detail TableCCU audit detail table for ITEM_ACT_VAT |
# | 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 |