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 |