AR_WC_EXLP_VW (SQL View)	Index Back
Excel Payment View

AR_WC_EXLP_VW

(SQL View)

Excel Payment View

SELECT DISTINCT DEP.DEPOSIT_BU , DEP.DEPOSIT_ID , DEP.OPRID , DEP.CONTROL_CNT , DEP.CONTROL_AMT , DEP.ACCOUNTING_DT , DEP.BANK_CD , DEP.BANK_ACCT_KEY , DEP.RECEIVED_DT , DEP.PROCESS_INSTANCE FROM PS_DEPOSIT_EXCEL DEP , PS_BANK_CD_TBL BNK , PS_BANK_ACCT_TBL ACCT , PS_SET_CNTRL_REC SCR WHERE BNK.BANK_TYPE='E' AND ACCT.AR='Y' AND BNK.SETID=SCR.SETID AND SCR.SETCNTRLVALUE=DEP.DEPOSIT_BU AND SCR.RECNAME='BANK_CD_TBL' AND DEP.BANK_CD=BNK.BANK_CD AND BNK.SETID=ACCT.SETID AND BNK.BANK_CD=ACCT.BANK_CD AND DEP.BANK_ACCT_KEY=ACCT.BANK_ACCT_KEY AND DEP.ERROR_FLG= 'N' AND DEP.ERROR_FLG1= 'N' AND DEP.TYPE= 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Prompt Table: SP_BUARED_NONVW

2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW

4 CONTROL_CNT Number(6,0) INTEGER NOT NULL Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly

5 CONTROL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.

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

7 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: BANK_AR_BD_VW

8 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
Prompt Table: BANK_AR_D_VW

9 RECEIVED_DT Date(10) DATE NOT NULL Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Prompt Table: SP_BUARED_NONVW
2	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
4	CONTROL_CNT	Number(6,0)	INTEGER NOT NULL	Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
5	CONTROL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
6	ACCOUNTING_DT	Date(10)	DATE NOT NULL	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_AR_BD_VW
8	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 Prompt Table: BANK_AR_D_VW
9	RECEIVED_DT	Date(10)	DATE NOT NULL	Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
10	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance