VAT_ADVPYFP_TAO

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VAT_ADVPAY_DEL_AP Character(1) VARCHAR2(1) NOT NULL VAT on Advance Payments in Payables when Declaration is at Delivery Time
2 VAT_ADVPAY_INV_AP Character(1) VARCHAR2(1) NOT NULL VAT on Advance Payments in Payables when Declaration is at Invoice Time
3 VAT_ADVPAY_PMT_AP Character(1) VARCHAR2(1) NOT NULL VAT on Advance Payments in Payables when Declaration is at Payment Time
4 VAT_ADVPAY_ACT_AP Character(1) VARCHAR2(1) NOT NULL VAT on Advance Payments in Payables when Declaration is at Accounting Date
5 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
6 VAT_ADVPAY_FLG Character(1) VARCHAR2(1) NOT NULL VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments