DD_CANCEL_LNX (SQL View)	Index Back
Direct Debit Cancel View To improve performance in multi language environments

DD_CANCEL_LNX

(SQL View)

Direct Debit Cancel View

To improve performance in multi language environments

SELECT DISTINCT A.SETID , A.BNK_ID_NBR , C.BANK_ACCOUNT_NUM , B.LANGUAGE_CD , E.DD_ID ,E.CUST_ID , E.DD_DUE_DT , E.CREATE_DATE , E.DD_CURRENCY , B.DESCR , D.DESCR FROM PS_BANK_CD_TBL A , PS_BANK_CD_LNX B , PS_BANK_ACCT_TBL C , PS_BANK_ACCT_LNX D , PS_DD_CONTROL E WHERE B.SETID = A.SETID AND B.BANK_CD = A.BANK_CD AND C.SETID = B.SETID AND C.BANK_CD = B.BANK_CD AND D.SETID = C.SETID AND D.BANK_CD = C.BANK_CD AND D.BANK_ACCT_KEY = C.BANK_ACCT_KEY AND D.LANGUAGE_CD = B.LANGUAGE_CD AND %Sql(DD_EVENT_VOID, E.) AND E.BNK_ID_NBR = A.BNK_ID_NBR AND E.DEPOSIT_ACCT_NUM = C.BANK_ACCOUNT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETBNK_NONVW

2 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table: BANK_IDALL_VW

3 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DD_ID Character(15) VARCHAR2(15) NOT NULL Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.

6 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

7 DD_DUE_DT Date(10) DATE Direct Debit Due Date

8 CREATE_DATE Date(10) DATE Creation Date

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

10 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETBNK_NONVW
2	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. Prompt Table: BANK_IDALL_VW
3	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DD_ID	Character(15)	VARCHAR2(15) NOT NULL	Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
6	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
7	DD_DUE_DT	Date(10)	DATE	Direct Debit Due Date
8	CREATE_DATE	Date(10)	DATE	Creation Date
9	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.
10	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description