ITA_TAXAMT_VW(SQL View) |
Index Back |
|---|
| SELECT A.VAT_ENTITY ,A.VOUCHER_ID ,A.VAT_TXN_SOURCE ,A.PROCESS_INSTANCE ,A.PHYSICAL_NATURE ,A.VAT_TREATMENT ,A.VAT_APPLICABILITY ,B.VOUCHER_STYLE ,B.VCHR_SRC , A.TAX_CD_VAT_PCT ,%Round(sum(A.TAX_BASIS_AMT_TXN ),1) , %Round(sum(A.TAX_AMT_GROSS_TXN ),1) FROM PS_ITA_VAT_RPT_TBL A ,PS_VOUCHER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.INVOICE_ID = B.INVOICE_ID AND A.VAT_ENTITY = B.VAT_ENTITY GROUP BY A.VAT_ENTITY ,A.VOUCHER_ID ,A.VAT_TXN_SOURCE ,A.PROCESS_INSTANCE ,A.PHYSICAL_NATURE ,A.VAT_TREATMENT ,A.VAT_APPLICABILITY ,B.VOUCHER_STYLE ,B.VCHR_SRC , A.TAX_CD_VAT_PCT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 2 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | VAT_TXN_SOURCE | Character(6) | VARCHAR2(6) NOT NULL | VAT Transaction Source |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 6 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |
| 7 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 8 | 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 |
| 9 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 10 |  TAX_CD_VAT_PCT |
Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage. |
| 11 | TAX_BASIS_AMT_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Basis Amount - Transaction |
| 12 | TAX_AMT_GROSS_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Tax Amount - Transaction |