GLRCN_AR_DD (SQL View)	Index Back
GLRCN - Direct Debit Control

GLRCN_AR_DD

(SQL View)

GLRCN - Direct Debit Control

SELECT DD_BU ,DD_ID ,DD_STATUS ,CUST_ID , DD_CURRENCY ,DD_AMT ,CURRENCY_CD ,DD_AMT_BASE ,ACCOUNTING_DT ,BUSINESS_UNIT_GL ,PMT_STATUS FROM PS_DD_CONTROL WHERE DD_STATUS IN ('A','N', 'P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDS_NONVW

2 DD_ID Character(15) VARCHAR2(15) NOT NULL Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
Prompt Table: DD_CONTROL

3 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

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.

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

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

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 DD_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a direct debit in the base currency of the business unit to which it is posted. This field is maintained by the Direct debit generation process.

9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date

10 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW
2	DD_ID	Character(15)	VARCHAR2(15) NOT NULL	Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process. Prompt Table: DD_CONTROL
3	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
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.
5	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.
6	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.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	DD_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a direct debit in the base currency of the business unit to which it is posted. This field is maintained by the Direct debit generation process.
9	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple Default Value: %date
10	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
11	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