VAT_DFLTS_TEO2(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 |