GROUP_TYPEAR_WC_GRPT_F_VW(SQL View) |
Index Back |
|---|---|
Group Type View |
| SELECT DISTINCT GROUP_TYPE , DESCR FROM PS_GROUP_TYPE_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |