Understanding the Date Effective Category Code Update Program

After you add date-effective category codes, you must run the Date Effective Category Code Update program (R03012A) to copy the values entered from the Customer Date Effective Category Codes table (F03012A) to the Customer Master by Line of Business table (F03012).

When you run the Date Effective Category Code Update program, the system compares the date that you enter in the processing option with the effective date entered for the category codes record. If the processing option date is on or after the effective date, the system updates the category code values in the customer records and changes the value of the Eff Used field to Y.

This table describes the meaning of the values in the Eff Used field:

Eff Used Value	Description
N	A new category codes record has been entered or an existing category codes record has been changed, but the Date Effective Category Code Update program has not been run. The customer master record has not been updated with the values in the category codes records.
Y	The Date Effective Category Code Update program has been run, and all values displayed have been updated to the customer master record.

The system also generates a report listing the customer master records that have been updated and the new values.

The system does not change the Eff Used field to N on previously used category codes when new effective-date category codes are used. This provides an audit trail of the updates that occurred in the past. The system maintains date effective category codes until you purge them.

To update category code values on invoices that have been previously entered for the customer, you must run the Update A/R from Address Book program (R03B802).