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.