As a sales order is created and saved, the gross details of the order are recorded in SO_Main - debtor id, gross sales order total, including stock on back order, and current history number. The table SO_History is updated with the snapshot version total of the order, delivery address and courier charges and any cash payments received with that version of the order. SO_HistoryPayments is updated with the payments received on each snapshot of the sales order. SO_Lines records specific details about each line on that version of the order, including part number and details, quantity ordered, delivered, previously delivered and still on back order, and the line total. SO_LineDetails keeps track of cost, pricing and quantity details of each order line. SO_LineExtra maintains the details of non-inventory items recorded on a sales order.
The table SO_CashSale records name and address details for data in the Cash form tab of the sales order. SO_Run records the run number and user details as each Process Sales Order is run.
Copyright © 2012 Jiwa Financials. All rights reserved.