BI_VAT_RPL5_VW

(SQL View)

SELECT INVOICE ,BILL_TO_CUST_ID ,PROCESS_INSTANCE ,VAT_ENTITY ,BI_PROGRESSIVE_ID ,TAX_CD_VAT_PCT ,TAX_CD_VAT ,VAT_BASIS_AMT ,VAT_TRANS_AMT ,VAT_AMT ,BI_NATURA FROM PS_BI_VAT_RPT_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
Prompt Table: CUST_BI_A2_VW

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

4 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

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

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

8 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.

9 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.

10 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.

11 BI_NATURA Character(4) VARCHAR2(4) NOT NULL Natura

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
2	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUST_BI_A2_VW
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	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
5	BI_PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID
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	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. Prompt Table: VAT_HEADER_VW
8	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
9	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
10	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
11	BI_NATURA	Character(4)	VARCHAR2(4) NOT NULL	Natura