Navigation:  Accounts Payable > Technical References >   Accounts Payable tables

Supplier

Each Supplier has a record in the Supplier table.

 

SupplierContact

Each Supplier Contact has a record in the SupplierContact table.

 

SupplierDefault

Specifies default values for fields when adding or importing Suppliers.

 

SupplierGroup

Each Supplier Group has a record in the SupplierGroup table.

 

SupplierImport

Supplier Import table.

 

ApSubledger

Specifies eligible Accounts Payable Subledger Control Accounts in the General Ledger. Each Subledger Control Account has a record in this table.

 

ApTrans

Master records for Accounts Payable transactions. Each transaction has one record in this table.

 

ApTransDetail

Detail records for all Accounts Payable transactions. Each transaction has one or more records in this table. These records specify the amounts distributed to particular General Ledger Accounts. When Job Costing is installed they may also specify the JobID and CostID.

 

ApTransCheckDetail

Check voucher details for system generated Accounts Payable Checks.

 

ApApply

Cash Application records specifying how Payments (Debits) were applied to Invoices (Credits) or vice versa.

 

ApType

Accounts Payable transaction types. Each transaction type has one record in this table.

 

ApTypeDetail

Frequently used General Ledger AccountIDs that are provided as defaults when entering transactions for an ApType.

 

ApEntry, ApEntryDetail

Transaction entry tables.

 

ApImport, ApImportDetail

Transaction import tables.

 

ApRecur, ApRecurDetail

Recurring transaction tables.

 

Compressing transaction tables

 

Options | Compress...

This option in the Payable 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 to delete eligible Accounts Payable transactions that are on or before a cutoff Date that you specify.

 

Eligible transactions are those: