UPG_BI_VAT_XWLK(SQL Table) |
Index Back |
---|---|
Billing VAT Crosswalk UpgradeBilling VAT Crosswalk Upgrade Table to map VAT_TREATMENT_SAL to VAT_TREATMENT from prior releases to 8.8. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | VAT_TREATMENT_SAL | Character(3) | VARCHAR2(3) NOT NULL |
Describes the VAT Treatment that will be applied to this sales event. VAT treatment determines the accounting and processing that will be performed by the system. VAT treatments correspond to real world events. For example: domestic sale Distance EC Sale Export Sale.
DDS=Domestic VAT - Distance Sale DOM=Domestic VAT EUS=Intra-EU Sale EUT=Intra-EU Sale Simplification EXP=Export OOS=Outside the Scope of VAT |
2 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |