Understanding Deletion of Customer Master Records

When you delete a customer master record, the system verifies that no transactions exist for that customer in these tables. If a transaction exists, you cannot delete the customer master record; you must first delete the records from these tables, and then delete the customer master record:

Table	Description
F0150	Address Organization Structure Master
F03B11	Customer Ledger
F03B13	Receipts Header
F03B29	Credit Insurance
F0411	Accounts Payable Ledger
F060116	Employee Master Information
F08901	Participant file
F0911	Account Ledger
F0902	Account Balances (if the address book number is used as a subledger)
F1501B	Lease Master Header File
F1797	S/WM Address Book Information
F4013	Order Processing Cross Reference File
F4102	Item Branch File
F4211	Sales Order Detail File
F4311	Purchase Order Detail File
F4801	Work Order Master File
F5201	Contract Master File

If posted invoices or sales orders exist that prevent you from deleting the customer master record, you can prevent the entry of new transactions in the system by using these methods:

• Invoices: Activate the Hold Invoices field (HDAR) on the Customer Master Revision form to prevent new A/R invoices from being entered for the customer.

• Sales Orders: Update the Hold Orders Code field on the Billing Information form to prevent sales orders from being entered.

  See "Setting Up Customer Information, Setting Up Customer Billing Instructions" in the JD Edwards EnterpriseOne Applications Sales Order Management Implementation Guide.

When you delete a customer record, the system deletes the record from the F03012 table and from the following tables:

Table	Description
F0030	Bank Transit Master
F0101	Address Book Master
F01092	Supplemental Data Base - Code
F01093	Supplemental Data Base - Narrative
F0111	Address Book - Who's Who
F0115	Address Book - Contact Phone Numbers
F0116	Address by Date
F01815	AB Word Search Master Table
F0401	Supplier Master