GROUP_IDAR_WC_PERGIDFVW(SQL View) |
Index Back |
|---|---|
Posting Err Group ID View |
| SELECT a.group_id FROM ps_group_control a , PS_PENDING_ITEM b WHERE a.group_bu=b.group_bu AND a.group_id=b.group_id AND a.post_status='E' AND b.posted_flag<>'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |