PP_DST_MAX_VW (SQL View)	Index Back
Payment Predictor Internal

PP_DST_MAX_VW

(SQL View)

Payment Predictor Internal

select group_bu, group_id, max(dst_seq_num) from PS_PENDING_DST group by group_bu, group_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

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

3 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
2	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.
3	DST_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Distribution Sequence