DD_CANCEL_VW (SQL View)	Index Back
Direct Debits for Cancellation

DD_CANCEL_VW

(SQL View)

Direct Debits for Cancellation

SELECT D.BNK_ID_NBR , D.DEPOSIT_ACCT_NUM , D.DD_BU , D.DD_ID , D.CUST_ID , D.DD_STATUS , D.POST_ACTION , D.DD_AMT , D.DD_CURRENCY , D.DD_DUE_DT , D.CREATE_DATE , D.BANK_SETID , D.BANK_CD , D.BANK_ACCT_KEY , D.DD_CANCEL_REASON , D.DD_CLEARING_METHOD , D.ENTRY_USE_ID , D.ENTRY_TYPE , D.GROUP_ID , D.DD_CANCEL_GROUP_ID , D.CASH_POST_DT , D.VAT_POST_DT , D.DD_AS_OF_DT , D.ITM_MULTIPLIER , D.CREATE_PEND_ITEMS , D.DOC_SEQ_DATE , D.ACCOUNTING_DT , D.ENTRY_EVENT , D.PMT_ID , D.PMT_STATUS , D.STL_THROUGH FROM PS_DD_CONTROL D WHERE %Sql(DD_EVENT_VOID, D.) AND D.PMT_STATUS IN ( 'N','E','H','L','PR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.

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

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 DD_ID Character(15) VARCHAR2(15) NOT NULL Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.

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.

6 DD_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted
C=Complete
E=Rejected
N=No Action
P=Pending
R=Remitted
Z=All

7 POST_ACTION Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View

8 DD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.

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 DD_DUE_DT Date(10) DATE Direct Debit Due Date

11 CREATE_DATE Date(10) DATE Creation Date

12 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

13 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

14 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank

15 DD_CANCEL_REASON Character(60) VARCHAR2(60) NOT NULL Cancel Reason

16 DD_CLEARING_METHOD Character(1) VARCHAR2(1) NOT NULL Clearing Method
B=Bank Recon
D=Due Date
N=None

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

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

19 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

20 DD_CANCEL_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Cancellation Group Id

21 CASH_POST_DT Date(10) DATE Cash Posted Date

22 VAT_POST_DT Date(10) DATE VAT Post Date

23 DD_AS_OF_DT Date(10) DATE Pending Item As of Date

24 ITM_MULTIPLIER Signed Number(2,0) DECIMAL(1) NOT NULL Posting Item Multiplier

25 CREATE_PEND_ITEMS Character(1) VARCHAR2(1) NOT NULL Create Pending Items
A=Do Not Post
L=Batch Standard
N=Batch Priority

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

27 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

28 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
Prompt Table: EE_AR_CODE1_VW

29 PMT_ID Character(15) VARCHAR2(15) NOT NULL Payment id

30 PMT_STATUS Character(2) VARCHAR2(2) NOT NULL Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process

31 STL_THROUGH Character(2) VARCHAR2(2) NOT NULL Settle through
01=Financial Gateway
02=Pay Cycle

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
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	DD_ID	Character(15)	VARCHAR2(15) NOT NULL	Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
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.
6	DD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process. A=Accepted C=Complete E=Rejected N=No Action P=Pending R=Remitted Z=All
7	POST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled. A=Do Not Post B=Balance Only Now D=Delete This Group Now E=Delete ALL Accounting Entries G=Generate GL Distribution I=Balance and Post Later L=Batch Standard N=Batch Priority V=View
8	DD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
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	DD_DUE_DT	Date(10)	DATE	Direct Debit Due Date
11	CREATE_DATE	Date(10)	DATE	Creation Date
12	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
14	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
15	DD_CANCEL_REASON	Character(60)	VARCHAR2(60) NOT NULL	Cancel Reason
16	DD_CLEARING_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Clearing Method B=Bank Recon D=Due Date N=None
17	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
18	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.
19	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
20	DD_CANCEL_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Cancellation Group Id
21	CASH_POST_DT	Date(10)	DATE	Cash Posted Date
22	VAT_POST_DT	Date(10)	DATE	VAT Post Date
23	DD_AS_OF_DT	Date(10)	DATE	Pending Item As of Date
24	ITM_MULTIPLIER	Signed Number(2,0)	DECIMAL(1) NOT NULL	Posting Item Multiplier
25	CREATE_PEND_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create Pending Items A=Do Not Post L=Batch Standard N=Batch Priority
26	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.
27	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
28	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event Prompt Table: EE_AR_CODE1_VW
29	PMT_ID	Character(15)	VARCHAR2(15) NOT NULL	Payment id
30	PMT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payment status C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process
31	STL_THROUGH	Character(2)	VARCHAR2(2) NOT NULL	Settle through 01=Financial Gateway 02=Pay Cycle