BI_VAT_RPT_VW (SQL View)	Index Back
VAT Transactions

BI_VAT_RPT_VW

(SQL View)

VAT Transactions

SELECT DISTINCT(INVOICE) , PROCESS_INSTANCE ,VAT_ENTITY ,COUNTRY_VAT_RPTG ,BILL_TO_CUST_ID ,INVOICE_DT ,BI_RPT_INV_STATUS 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

3 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

4 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country

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

6 INVOICE_DT Date(10) DATE Invoice Date

7 BI_RPT_INV_STATUS Character(4) VARCHAR2(4) NOT NULL Invoice Status
A=Accepted
DP=Deadline Passed
FD=Failed Delivery
G=Generated
R=Rejected
RC=Received
RF=Refused
T=Transmitted
U=Undeliverable

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	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
4	COUNTRY_VAT_RPTG	Character(3)	VARCHAR2(3) NOT NULL	VAT Reporting Country
5	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUST_BI_A2_VW
6	INVOICE_DT	Date(10)	DATE	Invoice Date
7	BI_RPT_INV_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Invoice Status A=Accepted DP=Deadline Passed FD=Failed Delivery G=Generated R=Rejected RC=Received RF=Refused T=Transmitted U=Undeliverable