USAGE_INV_TEOA

(SQL Table)
Index Back

CCU Audit Detail Table

CCU audit detail table for USAGE_INV

# 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