VAT_DFLTS_TEO2

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for VAT_DEFAULTS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 VAT_DRIVER Character(15) VARCHAR2(15) NOT NULL VAT Driver
3 VAT_DRIVER_KEY1 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key1
4 VAT_DRIVER_KEY2 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key2
5 VAT_DRIVER_KEY3 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key3
6 VAT_DRIVER_KEY4 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key4
7 VAT_DRIVER_KEY5 Character(30) VARCHAR2(30) NOT NULL VAT Driver Key5
8 VAT_DEFAULT_TYPE Character(10) VARCHAR2(10) NOT NULL VAT Default Type
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 EFFDT Date(10) DATE NOT NULL Effective Date
13 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
14 VAT_VALUE_CHAR Character(50) VARCHAR2(50) NOT NULL VAT Value Character
15 VAT_VALUE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Value Numeric
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
18 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
19 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code