Transaction Processing Tables
These tables store information from product transactions:
Table |
Description |
---|---|
P. O. Detail Ledger File - Flexible Version (F43199) |
Stores detail information for each purchase order line (item number, price, quantity ordered, and so forth). |
Purchase Order Receiver File (F43121) |
Stores details about the volume of product received. |
Sales Order Header File (F4201) |
Stores the header information for each sales order (sales order number, customer number, shipment date, default shipping locations, and so forth). |
Sales Order Detail File (F4211) |
Stores detail information for each sales order line (item number, quantity ordered, price, and so forth). |
Item Ledger File (F4111) |
Stores history information for all inventory transactions. Any change to the bulk inventory is recorded in this table. Some examples are purchase order receipt and inventory adjustment. |
Bulk Product Transaction File (F41511) |
Stores supplemental information that pertains to bulk transactions only, such as temperature and density information, ambient and standard volumes, tank dip information, weighbridge information, and so forth. |
Gain/Loss Transactions File (F41512) |
Tracks all gains and losses for analysis and reconciliations. Information used in the four-point analysis is tracked with a separate table. |
Multi-Meter Readings (F41515) |
Stores information regarding opening and closing meter readings. |