VAT_DFLTS_TEO1(SQL Table) |
Index Back |
---|---|
CCU TEO temp tableCCU 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 |