UPG_VAT_PR_TMP

(SQL Table)
Index Back

Upgrade temp table

Use for PS_VAT_DF_CD_PR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 STATE Character(6) VARCHAR2(6) NOT NULL State
3 SORT_SEQ_NUM Character(1) VARCHAR2(1) NOT NULL Sort Sequence Number
4 VAT_RULE_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL VAT Rule Seq Number
5 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
8 VAT_APPLICABLE Character(1) VARCHAR2(1) NOT NULL VAT Applicable
E=Exempt
O=Outside of Scope of VAT
T=Taxable
9 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID
10 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.