BI_VAT_RPL4_VW

(SQL View)

SELECT INVOICE ,BILL_TO_CUST_ID ,PROCESS_INSTANCE ,BI_PROGRESSIVE_ID ,VAT_ENTITY ,TAX_CD_VAT_PCT ,BI_NATURA ,SUM(VAT_BASIS_AMT ) ,SUM(VAT_AMT ) FROM PS_BI_VAT_RPT_TBL GROUP BY INVOICE ,BILL_TO_CUST_ID ,PROCESS_INSTANCE ,BI_PROGRESSIVE_ID ,VAT_ENTITY ,TAX_CD_VAT_PCT ,BI_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 BI_PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID

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_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 BI_NATURA Character(4) VARCHAR2(4) NOT NULL Natura

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

#	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	BI_PROGRESSIVE_ID	Character(5)	VARCHAR2(5) NOT NULL	Progressive ID
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_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	BI_NATURA	Character(4)	VARCHAR2(4) NOT NULL	Natura
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_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.