DD_ITEMSQMC_VW (SQL View)	Index Back
DD Item Temp View Used to count the number of Direct Credit items that have the same key values for DD Format of 'M' (Multiple) which do not permit netting of debit and credit items.

DD_ITEMSQMC_VW

(SQL View)

DD Item Temp View

Used to count the number of Direct Credit items that have the same key values for DD Format of 'M' (Multiple) which do not permit netting of debit and credit items.

SELECT DISTINCT F1.PROCESS_INSTANCE , F1.AUTONUM_SETID , F1.DD_BU , F1.CUST_ID , F1.DUE_DT , F1.DD_FORMAT , F1.DD_CURRENCY , F1.DD_NET_DR_CR_FLG FROM PS_DD_ITEM_TAO2 F1 WHERE F1.DD_FORMAT='M' AND F1.MAX_REMITTANCE_NBR=0 AND F1.DD_NET_DR_CR_FLG='N' AND F1.BAL_AMT < 0 AND F1.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 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

5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

6 DD_FORMAT Character(1) VARCHAR2(1) NOT NULL Direct Debit Format
L=Multiple Item Lines per Item
M=Multiple Items / Direct Debit
S=One Item per Direct Debit

7 DD_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process.

8 DD_NET_DR_CR_FLG Character(1) VARCHAR2(1) NOT NULL Net Debit/Credit Amounts?

#	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	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
5	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6	DD_FORMAT	Character(1)	VARCHAR2(1) NOT NULL	Direct Debit Format L=Multiple Item Lines per Item M=Multiple Items / Direct Debit S=One Item per Direct Debit
7	DD_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process.
8	DD_NET_DR_CR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Net Debit/Credit Amounts?