GROUP_INQ_VW

(SQL View)
Index Back

Group Control Inquiry View


SELECT GROUP_BU, GROUP_ID, GROUP_TYPE FROM PS_GROUP_CONTROL

# 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 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.