|
Accounts Receivable tables |
  
|
|
Accounts Receivable tables |
|
Customer
Each Customer has a record in the Customer table.
CustomerContact
Each Customer Contact has a record in the CustomerContact table.
CustomerDefault
Specifies default values for fields when adding or importing Customers.
CustomerGroup
Each Customer Group has a record in the CustomerGroup table.
CustomerImport
Customer Import table.
ArSubledger
Specifies eligible Receivables Subledger Control Accounts in the General Ledger. Each Subledger Control Account has a record in this table.
ArTrans
Master records for Receivables transactions. Each transaction has one record in this table.
ArTransDetail
Detail records for all Receivables transactions. Each transaction has one or more records in this table. These records specify the amounts distributed to particular General Ledger Accounts (and JobID when applicable if Job Costing is installed).
ArApply
Cash Application records specifying how Payments (Credits) were applied to Invoices (Debits) or vice versa.
ArType
Receivables transaction types. Each type has one record in this table.
ArTypeDetail
Frequently used General Ledger AccountIDs that are provided as defaults when entering transactions of this ArType.
ArEntry, ArEntryDetail
Transaction entry tables.
ArImport, ArImportDetail
Transaction import tables.
ArRecur, ArRecurDetail
Recurring transaction tables.
Compressing transaction tables
Options | Compress...
This option in the Receivable transactions maintenance task is only available to the System Administrator. Before selecting this option be sure that you have a full current backup.
Use this option to delete eligible Accounts Receivable transactions that are on or before a cutoff Date that you specify.
Eligible transactions are those:
| • | whose transaction date is on or before that cutoff date |
| • | whose Balance is zero |
| • | that do not apply to any transactions whose transaction date is after the cutoff date |
| • | that have been posted to the General Ledger if it is installed |