VAT_TX_AR_DS_VW (SQL View)	Index Back
VAT Txn Loader View - AR Supplementary VAT Transaction Loader View. Retrieves information from ITEM_DST for the Direct Debit associated with the remittance

VAT_TX_AR_DS_VW

(SQL View)

VAT Txn Loader View - AR

Supplementary VAT Transaction Loader View. Retrieves information from ITEM_DST for the Direct Debit associated with the remittance

SELECT DISTINCT A.BUSINESS_UNIT , A.CUST_ID ,A.ITEM ,A.ITEM_LINE ,A.ITEM_SEQ_NUM ,B.DOC_TYPE ,B.DOC_SEQ_NBR ,B.DOC_SEQ_DATE ,A.ENTRY_TYPE ,A.ENTRY_USE_ID FROM PS_ITEM_ACTIVITY A , PS_ITEM_DST B , PS_BUS_UNIT_TBL_AR AR WHERE A.ITEM_SEQ_NUM=B.ITEM_SEQ_NUM AND A.ITEM_LINE=B.ITEM_LINE AND A.ENTRY_USE_ID = 'DD-02' AND A.BUSINESS_UNIT=AR.BUSINESS_UNIT AND A.ITEM= B.ITEM AND A.CUST_ID= B.CUST_ID AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND B.BUSINESS_UNIT_GL=AR.BUSINESS_UNIT_GL AND EXISTS( SELECT 'X' FROM PS_ITEM_ACTIVITY X WHERE X.BUSINESS_UNIT = B.BUSINESS_UNIT AND X.CUST_ID = B.CUST_ID AND X.ITEM = B.ITEM AND X.ITEM_LINE = B.ITEM_LINE AND X.ENTRY_USE_ID = 'DD-09')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

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

4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

5 ITEM_SEQ_NUM Number(3,0) SMALLINT NOT NULL Item Sequence Number

6 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

7 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

8 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

9 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.

10 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	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.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
6	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
7	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
8	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
9	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
10	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.