Establishing Edit Table Values

The PeopleSoft system provides a number of tables that affect customer processing. You should set up these tables before you convert customers. When you convert data, the values that you use for certain fields should match the values in these tables.

Customer Set Controls

Customer set controls establish rules that apply to every customer in a SetID. You can enable the system to autonumber customer IDs. If you do, the system automatically assigns a customer ID to each customer that is unique within the SetID as you enter customers online.

When using customer autonumbering, you may have to set the value of the last customer ID that you assign after converting the customers to ensure that you do not duplicate customer numbers. To update autonumbering, access the Automatic Numbering page and enter a customer ID as the field in the appropriate SetID.

Dun & Bradstreet

To import Dun & Bradstreet (DB) numbers into CUST_ID_NBRS, you must set up the DB numbers beforehand on the Dun and Bradstreet page.

For information about importing Dun & Bradstreet reports in bulk by type using the Data Export Import Utility, see PeopleSoft Receivables: Obtaining Dun & Bradstreet Information for a Customer.

VAT Registration Data

If you are importing VAT registration data into CUST_VAT_REG, you must set up the customer VAT countries beforehand on the VAT Country Definition page.

See PeopleSoft Global Options and Reports: Understanding VAT