WS_CONTROL_GRPS

(SQL Table)
Index Back

Match Groups on Maint WS

This table is used on the Maintenance Worksheet to create match groups.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WS_BU Character(5) VARCHAR2(5) NOT NULL Worksheet Business Unit
2 WS_ID Character(15) VARCHAR2(15) NOT NULL Worksheet ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 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.
5 WS_FLD_MATCH Character(1) VARCHAR2(1) NOT NULL Field Match
F=Field
V=Value
6 ITEM_REF_FIELD Character(18) VARCHAR2(18) NOT NULL Item Reference Field
7 ITEM_OPERATOR Character(4) VARCHAR2(4) NOT NULL DM Item Operator
==Equal
BTW=In Between
LIKE=Like Comparison
8 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
9 LITERAL Character(30) VARCHAR2(30) NOT NULL Literal
10 THRU_ITEM_ID Character(30) VARCHAR2(30) NOT NULL Used as search criteria for Deduction Manger and Manual Resolution Worksheet.
11 OFFSET_REF_FLD Character(18) VARCHAR2(18) NOT NULL Offset Reference Field
12 OFFSET_OPERATOR Character(4) VARCHAR2(4) NOT NULL DM Offset Operator
==Equal
BTW=In Between
LIKE=Like Comparison
13 OFFSET_ID Character(30) VARCHAR2(30) NOT NULL Offset ID Number
14 THRU_OFFSET_ID Character(30) VARCHAR2(30) NOT NULL Thru Offset Id Number