Using the Data Dictionary

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.