VAT_RCVRBT_AET(SQL Table) |
Index Back |
---|---|
VAT Recovery/Rebate Def Temp |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
3 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
4 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
6 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |
7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
9 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
10 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Tax Code |
11 | EFFDT | Date(10) | DATE | Effective Date |
12 | CHARTFIELD_PR1_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 1 Value |
13 | CHARTFIELD_PR2_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 2 Value |
14 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
15 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
16 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
17 | VAT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a VAT calculation error has been found. This field is maintained by the system.
N=No Error O=VAT Amount Calculation Error |
18 | VAT_RCVRY_RT_ITM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Item VAT Recovery Rate |
19 | ROW_RETURNED | Character(1) | VARCHAR2(1) NOT NULL | An internal work field utilized in position tree processing. |