VAT_ALGO_TMP6(SQL Table) |
Index Back |
---|---|
VAT Algorithm temp tableVAT Algorithm temp table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
2 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
3 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
4 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
5 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
6 | COUNTRY_VAT_SHIPTO | Character(3) | VARCHAR2(3) NOT NULL | Ship To VAT Rgstrn Country |
7 | COUNTRY_VAT_SUPPLY | Character(3) | VARCHAR2(3) NOT NULL | VAT Place of Supply Country |
8 | DROP_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Drop Ship
N=No Y=Yes |
9 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
10 | 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
Y/N Table Edit |
11 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
12 | VOUCHER_STYLE | Character(4) | VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher |