BI_NATURA_VW

(SQL View)

SELECT A.VAT_ENTITY ,A.INVOICE ,A.PROCESS_INSTANCE ,A.TAX_CD_VAT_PCT ,B.VAT_APPLICABILITY ,B.VAT_TREATMENT ,B.COUNTRY_VAT_BILLFR ,A.BI_PROGRESSIVE_ID FROM PS_BI_VAT_RPT_TBL A ,PS_BI_VAT_TX_VW B WHERE A.INVOICE = B.INVOICE

# 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.
Prompt Table: VAT_ENTITY

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

4 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.

5 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

6 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

7 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

8 BI_PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID

#	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. Prompt Table: VAT_ENTITY
2	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	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.
5	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
6	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
7	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
8	BI_PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID