GROUP_PAY_VW (SQL View)	Index Back
Posted Info for Pymnt Groups

GROUP_PAY_VW

(SQL View)

Posted Info for Pymnt Groups

SELECT group_bu , group_id , post_status , post_action , post_dt , posted_total , control_currency FROM PS_GROUP_CONTROL WHERE group_type='P'

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

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 POST_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
%=All
C=Complete
E=Errors
N=Not Posted

4 POST_ACTION Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View

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

6 POSTED_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.

7 CONTROL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.

#	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.
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	POST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program. %=All C=Complete E=Errors N=Not Posted
4	POST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled. A=Do Not Post B=Balance Only Now D=Delete This Group Now E=Delete ALL Accounting Entries G=Generate GL Distribution I=Balance and Post Later L=Batch Standard N=Batch Priority V=View
5	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
6	POSTED_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total.
7	CONTROL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.