PROCESS_INSTANCECOUNTRYSTATEEXPENSE_TYPE_SETIDEXPENSE_TYPEVAT_SETIDSETIDBUSINESS_UNITVAT_USE_IDTAX_CDEFFDTCHARTFIELD_PR1_VALCHARTFIELD_PR2_VALN=No Error
O=VAT Amount Calculation Error
VAT_DF_RRE_TMP(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 | EXPENSE_TYPE_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Expense Type SetID |
| 5 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 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 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 15 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
| 16 | 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 |