GRP_PPLAN_VW (SQL View)	Index Back
Group payment plan view

GRP_PPLAN_VW

(SQL View)

Group payment plan view

SELECT DISTINCT P.GROUP_BU , P.GROUP_ID , P.BUSINESS_UNIT , P.PAYMENT_PLAN FROM PS_PENDING_ITEM P , PS_GROUP_CONTROL G WHERE P.GROUP_BU = G.GROUP_BU AND P.GROUP_ID = G.GROUP_ID AND P.PAYMENT_PLAN <> ' '

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 PAYMENT_PLAN Character(15) VARCHAR2(15) NOT NULL Payment Plan

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	PAYMENT_PLAN	Character(15)	VARCHAR2(15) NOT NULL	Payment Plan