ITA_VCHR_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 ,A.PROGRESSIVE_ID ,B.VOUCHER_STYLE ,B.VCHR_SRC ,B.COUNTRY_LOC_SELLER ,C.EU_MEMBER_sTATE FROM PS_ITA_VAT_RPT_TBL A ,PS_VOUCHER B ,PS_COUNTRY_TBL C 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 AND B.COUNTRY_LOC_sELLER = C.COUNTRY AND A.COUNTRY = C.COUNTRY |
| # | 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 | PROGRESSIVE_ID | Character(5) | VARCHAR2(5) NOT NULL | Progressive ID |
| 9 | 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 |
| 10 | VCHR_SRC | Character(4) | VARCHAR2(4) NOT NULL | Voucher Source |
| 11 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
| 12 | EU_MEMBER_STATE | Character(1) | VARCHAR2(1) NOT NULL | EU Member State |