GC_VAT_SPN_VW

(SQL View)
 Index Back

Spanish Input VAT Info

Spanish Input VAT Information

SELECT DISTINCT A.PROCESS_INSTANCE ,C.TAX_CD_VAT , C.TAX_CD_VAT_PCT , C.TAX_BASIS_AMT_BSE , C.TAX_AMT_GROSS_BSE , C.TAX_AMT_RCVRY_BSE ,C.TAX_AMT_RBT_BSE ,C.VAT_TXN_SOURCE ,HDR.DESCRSHORT FROM PS_VAT_RPT_INST1 A , PS_VAT_RPT_INST2 B , PS_VAT_TXN_TBL C , PS_VENDOR D , PS_VAT_XREF_VCHR E , PS_VOUCHER F , PS_VAT_USE_TBL G , PS_VCHR_ACCTG_LINE H ,PS_VAT_ENTITY VE ,PS_VAT_ENT_RGSTRN VR ,PS_TAX_HEADER_TBL HDR WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND C.VAT_ENTITY=VE.VAT_ENTITY AND A.VAT_RPT_ID = B.VAT_RPT_ID AND B.VAT_ENTITY = C.VAT_ENTITY AND C.VAT_ENTITY=VR.VAT_ENTITY AND VR.COUNTRY='ESP' AND B.COUNTRY_VAT_RPTG = C.COUNTRY_VAT_RPTG AND B.VAT_DCMNT_ID = C.VAT_DCMNT_ID AND B.LINE_NBR = C.LINE_NBR AND B.UNPOST_SEQ = C.UNPOST_SEQ AND D.SETID = F.VENDOR_SETID AND D.VENDOR_ID = F.VENDOR_ID AND C.SETID=HDR.SETID AND C.TAX_CD_VAT=HDR.TAX_CD AND C.VAT_ENTITY = E.VAT_ENTITY AND C.COUNTRY_VAT_RPTG = E.COUNTRY_VAT_RPTG AND C.VAT_DCMNT_ID = E.VAT_DCMNT_ID AND C.LINE_NBR = E.LINE_NBR AND C.UNPOST_SEQ = E.UNPOST_SEQ AND E.BUSINESS_UNIT = F.BUSINESS_UNIT AND E.VOUCHER_ID = F.VOUCHER_ID AND E.VAT_ENTITY = F.VAT_ENTITY AND G.VAT_USE_ID = H.VAT_USE_ID AND G.EFFDT = ( SELECT MAX(G_ED.EFFDT) FROM PS_VAT_USE_TBL G_ED WHERE G.SETID = G_ED.SETID AND G.VAT_USE_ID = G_ED.VAT_USE_ID AND G_ED.EFFDT <= %CurrentDateIn) AND F.BUSINESS_UNIT = H.BUSINESS_UNIT AND F.VOUCHER_ID = H.VOUCHER_ID AND G.EFF_STATUS = 'A' AND B.VAT_RPT_LINE_NBR <> 7

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
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 TAX_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Basis Amount - Base
5 TAX_AMT_GROSS_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Tax Amount - Base
6 TAX_AMT_RCVRY_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Recovery Amount - Base
7 TAX_AMT_RBT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Rebate Amount - Base
8 VAT_TXN_SOURCE Character(6) VARCHAR2(6) NOT NULL VAT Transaction Source
9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description