SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
Set Control Field: SETID
CUSTOMER_GROUPCWB_CUSTGRP_PDT(SQL View) |
Index Back |
|---|---|
CWB CustGroupCollection Customer Group + Promise Date Options setup |
| SELECT DISTINCT A.SETID , A.CUST_ID , A.CUSTOMER_GROUP FROM PS_CUST_CGRP_LNK A ,PS_PROMISE_DT_OPT B WHERE A.SETID = B.SETID AND A.CUSTOMER_GROUP = B.CUSTOMER_GROUP AND A.CUST_GRP_TYPE = 'COLL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table:
SP_SETID_NONVW
|
| 2 | 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. |
| 3 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |