SETIDCNTRCT_IDSOLD_TO_CUST_IDCUSTOMER_GROUPSCON_CUST_CGRP(SQL Table) |
Index Back |
|---|---|
Buying Agreement CustomersPopulated by OMS2001.SQR and SCON_HDR_WRK.CNTRCT_ID SavePostChange Date Init. Issue # Description 02/08/01 JJM R-SGATIG-ZV65C Created Record and built table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | SOLD_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 4 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |