Understanding Customer Control Information
Depending on which products you have licensed (PeopleSoft Receivables, Billing, Order Management) you may have to populate all of the customer records.
Note: Required means that you must place a row in the table with correct default values, even if you not going to use any of the fields on these tables. The system uses rows in the required tables to access information online as well as for background processing.
This table lists customer control information and the required records for each application:
Table |
Description |
PeopleSoft Billing |
PeopleSoft Grants Management |
PeopleSoft Order Management |
PeopleSoft Receivables |
PeopleSoft Contracts Management |
---|---|---|---|---|---|---|
CUSTOMER |
Customer header |
X |
X |
X |
X |
X |
CUST_ADDRESS |
Customer address detail |
X |
X |
X |
X |
X |
CUST_ADDR_SEQ |
Customer address header |
X |
X |
X |
X |
X |
CUST_ATT |
Customer attachments Note: Only needed if using attachments. |
X |
||||
CUST_BILLTO |
Valid bill-to relationships |
X |
X (if customer is both a bill-to and sold-to customer) |
X (if customer is both a bill-to and sold-to customer |
X |
X |
CUST_BROKER |
Customer brokers |
|||||
CUST_CGRP_LNK |
Link for customers who are associated with various customer groups |
|||||
CUST_CREDIT |
Customer credit information |
X Note: If this customer is a bill-to customer, this is needed for credit checking. |
X |
|||
CUST_CRSPD |
Customer correspondence information |
X |
X |
X |
X |
|
CUST_CRSPD_REM |
Customer correspondence remit to |
X |
||||
CUST_EXEMPT |
Customer exemption status |
|||||
CUST_EXEMPT_DTL |
Customer exemption details |
|||||
CUST_GROUP_TBL |
Customer group table |
|||||
CUST_HIERARCHY |
Customer hierarchy |
|||||
CUST_ID_NBRS |
Customer ID numbers |
|||||
CUST_INDIRECT |
Indirect customers |
|||||
CUST_MSG |
Customer messages Note: Only needed if using messages. |
|||||
CUST_NOTE |
Customer notes Note: Only needed if using notes. |
|||||
CUST_NOTE_DOC |
Documents that notes are printed on. Note: Only needed if using notes. |
|||||
CUST_NOTE_KEYWD |
Customer notes key words for searching Note: Only needed if using notes. |
|||||
CUST_OPTION |
Bill-to customer options |
X |
X (if customer is a bill-to customer) |
X (if customer is a bill-to customer) |
X |
X (if customer is a bill-to customer) |
CUST_PM_CHANNEL |
Customer channel information |
|||||
CUST_REGN_TYPE |
Customer region code types |
|||||
CUST_SHEX_BLK |
Dates on which shipments are blocked |
|||||
CUST_SHEX_DT |
Dates and times when shipments are not received |
|||||
CUST_SHIPTO |
Valid ship-to relationships |
X (if customer is both a ship-to and sold-to customer) |
X (if customer is both a ship-to and sold-to customer) |
X |
||
CUST_SHIPTO_OPT |
Ship-to customer options |
X (if customer is a ship-to customer) |
X (if customer is a ship-to customer) |
|||
CUST_SIC_CODES |
Customer standard industry codes |
|||||
CUST_SOLDTO_OPT |
Sold-to customer options |
X (if customer is a sold-to customer) |
X (if customer is a sold-to customer) |
|||
CUST_TEAM |
Customer support teams |
X |
X |
X |
X |
X |
CUST_VAT_EXCPTN |
Customer value-added tax (VAT) exceptions |
X (if using VAT) |
X (if using VAT) |
X (if using VAT) |
X (if using VAT) |
|
CUST_VAT_REG |
Customer VAT registration |
X (if using VAT) |
X (if using VAT) |
X (if using VAT) |
X (if using VAT) |
Note: PeopleSoft Grants Management also requires the Sponsor Attribute Date (GM_SP_ATTRDT), Sponsor Attributes (GM_SP_ATTRIB), and Sponsor Letter of Credit Info (GM_SPNSR_LOC) tables.