The debtor main client details are recorded in DB_Main1 and auxiliary table DB_Main2. DB_BatchTrans and DB_BatchTranLines records the debtor transactions sourced from the debtor Transaction Form Tab and Debtor menu options - Receipts and Invoices.
As sales orders and credit notes are processed by the Process Sales Orders run and debtor transactions - receipts, discounts, debit and credit journals and notes are activated, the table DB_Trans is updated with this information. As receipts are received and allocated, DB_TransAlloc is used to record these details. Current balances are stored and aged with End of Period processing in DB_Main1.
Additional debtor specific details are stored in:
DB_Budget - last, current and next years budget sales information
DB_Directors - director details if the client is a company
DB_DeliveryAddress - delivery addresses for stock
DB_Classification - classification details for collating and reporting information
CN_Contact – contact details of staff members for each debtor
CN_ContactPosition – lookup table for job title and descriptions
CN_Group and CN_GroupLink – group and group linking lookup details for selection for each debtor, creditor and contact record. Used for reporting and collating purposes
Copyright © 2012 Jiwa Financials. All rights reserved.