DD_ITEMSQS_VW (SQL View)	Index Back
Draft Item Temp View Used to count the number of Direct Credit items that have the same key values for DD Format of 'S' (Single), or 'M' (Multiple) that have max remittance number = 1.

DD_ITEMSQS_VW

(SQL View)

Draft Item Temp View

Used to count the number of Direct Credit items that have the same key values for DD Format of 'S' (Single), or 'M' (Multiple) that have max remittance number = 1.

SELECT A.PROCESS_INSTANCE , A.AUTONUM_SETID , A.DD_BU , A.BUSINESS_UNIT , A.CUST_ID , A.ITEM , A.ITEM_LINE FROM PS_DD_ITEM_TAO2 A WHERE A.DD_FORMAT='S' OR (A.DD_FORMAT = 'M' AND A.MAX_REMITTANCE_NBR = 1) OR (A.DD_FORMAT = 'L' AND A.ITEM_LINE = 0) AND A.DD_ID='0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 AUTONUM_SETID Character(5) VARCHAR2(5) NOT NULL Automatic Numbering Set ID

3 DD_BU Character(5) VARCHAR2(5) NOT NULL Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.

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

5 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.
Prompt Table: CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AUTONUM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Automatic Numbering Set ID
3	DD_BU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	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. Prompt Table: CUST_SRCH_VW Set Control Field: BUSINESS_UNIT
6	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. Prompt Table: DR_ITEM_ITEM_VW
7	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line