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.