New Generalized Codes
The conversion validates that the data required in Generalized Codes exists. Generalized Code Master (code_mstr) table entries are created for the following items:
• Each state code on Employee Records (emp_mstr.emp_state) and other address records (ad_mstr.ad_state) must exist in generalized codes with a code_fldname value of ad_state.
• Each customer type (cm_mstr.cm_type) must exist in Generalized Codes with a code_fldname value of cm_type.
• Each county code on Addresses Records (ad_mstr.ad_county) must exist in Generalized Codes with a code_fldname value of ad_county.
• Each tax class on address records (ad_mstr.ad_txc) must exist in Generalized Codes with a code_fldname value of ad_txc.
• Each voucher type (vo_mstr.vo_type) must exist in Generalized Codes with a code_fldname value of vo_type.
• Each supplier type (vd_mstr.vd_type) must exist in Generalized Codes with a code_fldname value of vd_type.