ITEM_ACT_SGP_VW (SQL View)	Index Back
Posted Sub Groups

ITEM_ACT_SGP_VW

(SQL View)

Posted Sub Groups

SELECT DISTINCT a.group_bu , a.group_id , a.sub_group_id , a.business_unit , a.cust_id , a.post_dt , a.group_type , a.accounting_dt FROM PS_ITEM_ACTIVITY a WHERE a.sub_group_id <> 0

# 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.
Default Value: OPR_DEF_TBL_AR.GROUP_BU
Prompt Table: SP_BUARGR_NONVW

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.
Prompt Table: GROUP_CONTROL

3 SUB_GROUP_ID Number(6,0) INTEGER NOT NULL Sub Group ID

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW

5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT

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

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

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

#	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. Default Value: OPR_DEF_TBL_AR.GROUP_BU Prompt Table: SP_BUARGR_NONVW
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. Prompt Table: GROUP_CONTROL
3	SUB_GROUP_ID	Number(6,0)	INTEGER NOT NULL	Sub Group ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
5	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_SRCH_VW Set Control Field: BUSINESS_UNIT
6	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
7	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.
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple