ITA_VAT_RPT7_VW

(SQL View)
 Index Back

SELECT A.INVOICE_ID ,A.VENDOR_ID ,A.TAX_CD_VAT_PCT ,A.PROCESS_INSTANCE ,A.VAT_ENTITY ,%Round(SUM(A.TAX_BASIS_AMT_TXN),1) ,%Round(SUM(A.TAX_AMT_GROSS_TXN),1) ,%Round(SUM(A.TAX_TRANS_AMT_TXN),1) ,%Round(SUM(A.TAX_AMT_RCVRY_TXN),1) ,A.VOUCHER_ID ,A.ITA_NATURA ,A.ITA_IMPORTO ,B.VCHR_SRC ,A.PROGRESSIVE_ID 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.INVOICE_ID ,A.VENDOR_ID , A.TAX_CD_VAT_PCT ,A.PROCESS_INSTANCE ,A.VAT_ENTITY ,A.VOUCHER_ID ,A.ITA_NATURA,A.ITA_IMPORTO ,B.VCHR_SRC ,A.PROGRESSIVE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 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.
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 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.

Prompt Table: VAT_ENTITY

6 TAX_BASIS_AMT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Transaction
7 TAX_AMT_GROSS_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Transaction
8 TAX_TRANS_AMT_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Transaction Amt - Transact
9 TAX_AMT_RCVRY_TXN Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amt - Transaction
10 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
11 ITA_NATURA Character(4) VARCHAR2(4) NOT NULL Natura
12 ITA_IMPORTO Signed Number(28,3) DECIMAL(26,3) NOT NULL Importo
13 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
14 PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID