PAYMENT_VW (SQL View)	Index Back
Unique Payments

PAYMENT_VW

(SQL View)

Unique Payments

SELECT DISTINCT p.deposit_bu , p.deposit_id , p.payment_seq_num , p.payment_id , p.entry_dt , p.post_dt FROM PS_PAYMENT p , ps_item_act_pay_vw i WHERE p.deposit_bu = i.deposit_bu AND p.deposit_id = i.deposit_id AND p.payment_seq_num = i.payment_seq_num

# 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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDS_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.
Prompt Table: DEPOSIT_CONTROL

3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
Prompt Table: PAYMENT_VW

4 PAYMENT_ID Character(15) VARCHAR2(15) NOT NULL Identifies a customer payment. This is usually a check number but may be some other identifying number.

5 ENTRY_DT Date(10) DATE Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).

6 POST_DT Date(10) DATE The Date a transaction was Posted.

#	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. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_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. Prompt Table: DEPOSIT_CONTROL
3	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. Prompt Table: PAYMENT_VW
4	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
5	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
6	POST_DT	Date(10)	DATE	The Date a transaction was Posted.