Populating Group Control Table Fields

The PS_GROUP_CONTROL table contains one row for each group that you enter into the system for billing interface or conversion purposes. This documentation uses the term group to mean a collection or batch of pending items that the billing system or conversion program produces and that PeopleSoft Receivables groups for control or processing purposes.

Some billing systems produce one group for each day. Other systems produce separate groups for debit memos, credit memos, or certain kinds of invoices. During conversion, you decide how many groups to create to bring in the activity that records open and closed items. PeopleSoft Receivables can receive an unlimited number of groups of various entry types and sizes.

Your interface or conversion program populates the group control table with external billing group information. The following table lists the appropriate values, along with the associated column name, for each field on PS_GROUP_CONTROL.

In the table, a field type is specified for each field; you use the field type to determine how to populate system-maintained fields and optional fields that you want to leave blank. To leave a field blank, enter a space for a character field, a null value or nothing for a date field, and a zero for a numeric field.

Note:

Use Application Designer to review the characteristics of each field in more detail.

Column	Field Name	Field Type	Optional/Conditional/Required	Field Description
1	GROUP_BU	Character	Required	Associate each group with a PeopleSoft Receivables business unit.
2	GROUP_ID	Character	Required	Provide a group identifier for each group.
3	OPRID	Character	Optional	Enter the User ID of the person who entered the group. This value is used in group inquiry and processing pages.
4	ASSN_OPRID	Character	Optional	Enter the User ID of the person who is responsible for processing the group. This value is used in group inquiry and processing pages.
5	BUSINESS_UNIT	Character	Optional	Set the value to be the same as GROUP_BU.
6	GROUP_TYPE	Character	Required	Select the value that you established in the Group Type table for this type of group. Do not use D, F, M, P, T, or U. Draft, overdue charge, maintenance, payment, transfer, and unpost groups use these values. Also, do not use C or R, because the Claim Settlement Process for AR process (PO_CLMSTL_AR) uses these values for claim items entered in PeopleSoft Purchasing and PeopleSoft Order Management.
7	BAL_STATUS	Character	Required	The default value is N (out of balance). The Receivables Update process automatically balances all external groups and sets the value to I (in balance) during initial processing, provided that the entered amount and count that it calculates are equal to the control amount and count that you provide.
8	EDIT_STATUS	Character	Required	Indicates whether or not the group has been edited. Groups entered online, for example, are E because less editing occurs during the Receivables Update process for these groups. The default value is N (not edited) for external groups.
9	POST_STATUS	Character	Required	Indicates whether the group is fully posted, not posted, or has errors that prevented some items from the Receivables Update process. The default value is N (not posted).
10	POST_ACTION	Character	Required	Indicates if the group is automatically set to be processed by the Receivables Update process. The field is populated with A (no action) if you want to review the contents online before the Receivables Update process. A is the default for online processing. The field value is L (batch standard) to post during the next Receivables Update process run.
11	CONTROL_AMT	Number	Optional	Enter the control amount. The control amount is the total amount of all items that are in the group in the entry currency of each item. For mixed currencies, this becomes a hash total. If the group has two items, one at 10.00 EUR and one at 10.00 USD, then the CONTROL_ AMOUNT is 20.00. To require a single currency for each group, refer to the CONTROL_ CURRENCY.
12	CONTROL_CNT	Number	Required	Enter the number of items in the group.
13	ENTERED_AMT	Number	Optional	The system calculates this value for you, so enter 0. When the Receivables Update process balances the group, the system updates this field with the total monetary amount of all pending items.
14	ENTERED_CNT	Number	Optional	The system calculates this value for you, so enter 0. When the Receivables Update process balances the group, this field is updated with the count of all pending items. Online groups have a default of 1.
15	POSTED_TOTAL	Number	Optional	The system calculates this value for you, so enter 0. This field is updated by the Receivables Update process with the total entered amount of all pending items in the group that are posted.
16	POSTED_COUNT	Number	Optional	The system calculates this value for you, so enter 0. This field is updated by the Receivables Update process with the total count of all pending items in the group that are posted.
17	GROUP_SEQ_NUM	Number	Optional	The system calculates this value for you, so enter 0. The system uses this value to assign sequence numbers for certain kinds of groups.
18	ORIGIN_ID	Character	Required	Enter an origin ID to represent where the group came from. Select a value from the origin IDs that you define for use as external billing origins on the PS_ORIGIN_TBL. To qualify, the origin type must be Billing, and the origin method must be External.
19	RECEIVED_DT	Date	Required	Indicates the date on which PeopleSoft Receivables received the group. From an interface or conversion perspective, RECEIVED_DT and ENTRY_DT are probably the same.
20	ENTRY_DT	Date	Required	The date that you enter the group into PeopleSoft Receivables. From an interface or conversion perspective, RECEIVED_DT and ENTRY_DT are probably the same.
21	POST_DT	Date	Optional	The system calculates this value for you, so set the value to null. This value is updated by the Receivables Update process with the most recent date that the group was posted.
22	ACCOUNTING_DT	Date	Required	Enter the accounting date that applies to the group. The Receivables Update process uses this date to determine if the group falls within the date range that is on the Receivables Update process request.
23	PROCESS_INSTANCE	Number	Optional	The system calculates this value for you, so enter 0. This value is updated by the Receivables Update process with the process instance that is used for a given execution of the process.
24	DST_BAL_STATUS	Character	Required	Enter I (in balance) if you provide your own PS_PENDING_DST rows. Otherwise, enter O (out of balance). The Pending Group Generator uses and updates this value.
25	GROUP_ID_ORIG	Character	Optional	Enter a value when you unpost a group during online processing.
26	DEPOSIT_BU	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
27	DEPOSIT_ID	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
28	PAYMENT_SEQ_NUM	Number	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
29	PAYMENT_ID	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
30	PAYMENT_CURRENCY	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
31	PYMT_RT_TYPE	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
32	PYMT_RATE_MULT	Number	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
33	PYMT_RATE_DIV	Number	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
34	CONTROL_CURRENCY	Character	Optional	If this field contains a value, all pending items in the group must have this currency as their entry currency. Select from the values on PS_CURRENCY_CD_TBL. If you enter a space, the pending items in the group may contain more than one entry currency.
35	FORMAT CURRENCY	Character	Required	Enter the currency code that controls the precision for this group's amount totals. Select from values on PS_CURRENCY_CD_TBL. If you provide a value for CONTROL_CURRENCY, use the same value here.
36	PAYMENT_AMT	Number	Optional	Enter a value when the group is created by a payment worksheet or by Payment Predictor.
37	ALLOW_DST	Character	Required	Tells the Pending Group Generator how to set the GL_DISTRIB_STATUS field for the PENDING_DST rows that it creates for this group. Set to Y to distribute the accounting entries to general ledger. This value sets GL_DISTRIB_STATUS = N. Set to N to prevent accounting entries from being distributed to the general ledger. This value sets GL_DISTRIB_STATUS = I.
38	CREATE_DST_BATCH	Character	Optional	This field is no longer used.
39	CASH_CNTRL_USE	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
40	BANK_SETID	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
41	BANK_CD	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
42	BANK_ACCT_KEY	Character	Optional	Enter a value when a payment worksheet or Payment Predictor creates the group.
43	UNPOST_REASON	Character	Optional	Enter the reason for unposting the group. Select one of the reason codes from the UNPOST_RSN_TBL table or enter a space.
44	WS_REASON	Character	Optional	Enter a reason that applies to all items in a maintenance group. Enter a value that you define in the PS_WS_REASON_TBL.
45	OPRID_APPROVED_BY	Character	Optional	Enter the User ID of the person who set the worksheet to post.