ITA_NATURA_VW

(SQL View)

SELECT A.VAT_ENTITY ,A.VOUCHER_ID ,a.invoice_id ,A.ITEM ,A.PROCESS_INSTANCE ,A.TAX_CD_VAT_PCT ,A.VAT_APPLICABILITY ,A.VAT_TREATMENT ,A.COUNTRY_VAT_BILLFR ,A.PHYSICAL_NATURE ,A.PROGRESSIVE_ID ,B.EU_MEMBER_STATE FROM PS_ITA_VAT_RPT_TBL A ,PS_COUNTRY_TBL B WHERE A.COUNTRY = B.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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

4 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

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

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

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 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

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

10 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

11 PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID

12 EU_MEMBER_STATE Character(1) VARCHAR2(1) NOT NULL EU Member State

#	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	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	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.
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	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
9	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
10	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
11	PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID
12	EU_MEMBER_STATE	Character(1)	VARCHAR2(1) NOT NULL	EU Member State