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.