Converting Customer Information

This section discusses how to convert customer information.

Consider writing a conversion program that reads records from the existing system and inserts them into the appropriate PeopleSoft customer tables. When creating a program, you have complete control over the conversion, and you can run it directly on most servers. Many customers write their conversion programs using Structured Query Report.

Alternatively, consider using the full synchronization Customer XML message to move existing customer data to the PeopleSoft tables.

Note: When you begin to test the conversion program, consider converting customers in batches. You can rerun the program for a batch of customers without affecting other customers.

You can also use these customer Component Interfaces to load data in the component tables:

  • CUSTOMER_MAIN_CI: Loads main customer information, customer teams, addresses.

  • CUSTOMER_BILLTO_CI: Loads bill-to related information such as bill-to options, customer correspondence, customer credit.

  • CUSTOMER_SOLDTO_CI: Loads sold-to related information such as sold to options, product catalogs, customer hierarchy, brokers.

  • CUSTOMER_SHIPTO_CI: Loads ship-to related information such as ship-to options, customer exception calendars, carrier account information, indirect customers.

  • CUSTOMER_MISC_CI: Loads miscellaneous information such customer group, standard industry codes, VAT information, notes, attachments, messages.

  • CUSTOMER_REGION_CI: Loads region codes.

These Component Interfaces can also be used. The CUSTOMER Component Interface is used with EIP messaging to load specific customer information to setting up a customer. The CUSTOMER_GENERAL Component Interface uses all of the records within the Customer component.

These records contain fields that are relevant to converting customer data:

  • CUSTOMER

  • CUST_ADDRESS

  • CUST_ADDR_SEQ

  • CUST_ATT

  • CUST_BILLTO

  • CUST_BROKER

  • CUST_CGRP_LNK

  • CUST_CREDIT

  • CUST_CRSPD

  • CUST_CRSPD_REM

  • CUST_EXEMPT

  • CUST_EXEMPT_DTL

  • CUST_GROUP_TBL

  • CUST_HIERARCHY

  • CUST_ID_NBRS

  • CUST_INDIRECT

  • CUST_MSG

  • CUST_NOTE

  • CUST_NOTE_DOC

  • CUST_NOTE_KEYWD

  • CUST_OPTION

  • CUST_PM_CHANNEL

  • CUST_REGN_TYPE

  • CUST_SHEX_BLK

  • CUST_SHEX_DT

  • CUST_SHIPTO

  • CUST_SHIPTO_OPT

  • CUST_SIC_CODES

  • CUST_SOLDTO_OPT

  • CUST_TEAM

  • CUST_VAT_EXCPTN

  • CUST_VAT_REG

You can use the data dictionary in conjunction with the information in PeopleSoft Application Designer on these fields:

  • Datatype.

  • Length.

  • Required or not.

  • List of values (translate values).

  • Validation tables.