The creditor main client details are recorded in CR_Main1 and auxiliary table CR_Main2. CR_Purchases records details of purchases invoices created from the Purchases main menu. CR_BatchPayment and CR_BatchPayLines are the tables that store cheque payments for purchase and creditor invoices.
CR_BatchTrans and CR_BatchTranLines records all other the creditor transactions sourced from the Creditor Transaction Form Tab and Creditor menu options - Purchases and Payments.
As creditor transactions - other payments, discounts, debit and credit journals and notes are activated, the table CR_Trans is updated with this information. As payments and credits are recorded and allocated, CR_TransAlloc is used to record these allocations. Cheque payments recorded in CR_BatchPayment are automatically allocated to the originating purchase invoice or creditor invoice.
Current balances are stored and aged with End of Period processing in CR_Main1.
Additional creditor specific details are stored in:
Copyright © 2012 Jiwa Financials. All rights reserved.