This appendix contains the following topics:
Information used in the Bulk Stock Management system is stored in master maintenance tables and transaction processing tables.
The following master maintenance tables store constants and setup information for the Bulk Stock Management System:
| Field | Explanation |
|---|---|
| Bulk Item Master (F41011) | Stores product information specific to bulk products. |
| Item Branch (F4102) | Stores item information specific to a depot (branch/plant). |
| Bulk Depot/Product Information (F41022) | Stores information specific to a depot and product for all bulk items. |
| Item Location (F41021) | Stores information for an item at a specific location. The main purpose of this table is to store inventory balances on an item/location level. The table also stores basic item information that is identical to information found in the Item Master table This information provides the default values for the Item Location table from the Item Master table. You can override the default values here. |
| Inventory Constants (F41001) | Stores various branch/plant constants. Each branch/plant represents a depot. |
| Unit of Measure Conversion Factors (F41002) | Stores unit of measure conversion information about each item of inventory stored in the depot. |
| Unit of Measure Conversion Factors - Standard (F41003) | Stores standard unit of measure conversion information. |
| Location Master (F4100) | Stores basic information about all warehouse and tank locations for each branch/plant. |
| Tank Master (F41500) | Stores structural information about the physical tank and information required for volume calculations. The system uses this table, in conjunction with the Tank Strapping table and the Default Tank Information table, to validate any products entered for bulk transactions. |
| Tank Strapping Table Maintenance (F41503) | Stores the gauging increments (physical dimensions) of the tank. This table is used in volume calculations. |
| Blend Category (F41501) | Stores information on the allowed blend categories for blending tanks. |
| Default Tank Information (F41508) | Stores the default temperature and density/gravity information used in conversion routines. |
| Meter Master (F41506) | Stores information concerning the flow meters in a depot. This table is required for processing and reconciliations. |
| Filling Line Master (F41507) | Identifies the filling lines to be used in the blending/filling cycle. |
| Allowed Products Matrix (F41505) | Identifies the product groups that can be contained in the tanks, and in what order they can be used. |
| Cost Ledger (F4105) | Stores the cost of products received into and sold out of the system. |
| Item Cost Components Add-Ons (F30026) | Defines the cost components to be updated when receiving product. |
| Location Detail (F4602) | Defines the locations used in warehousing to store product. |
| Lot Master (F4108) | Defines the detail lot locations that identify batches of product received. |
| Filling Category and Rates (F415017) | Stores the notes for filling categories. |
| Four-Point Analysis Maintenance (F41509) | Stores the volumes recorded at different points in the movement of products. |
| Four-Point Temperature Maintenance (F415091) | Stores the temperatures recorded at different points in the movement of products. |
The following tables record information from product transactions:
| Field | Explanation |
|---|---|
| Purchase Order Detail Ledger (F43199) | Stores detail information for each purchase order line (item number, price, quantity ordered, and so forth). |
| Purchase Order Receiver (F43121) | Stores the details of volume of product received. |
| Sales Order Header (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 (F4211) | Stores detail information for each sales order line (item number, quantity ordered, price, and so forth). |
| Item Ledger (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 Transactions (F41511) | Stores supplemental information that pertains to bulk transactions only, such as temperature/density information, ambient and standard volumes, tank dip information, Weighbridge information, and so forth. |
| Gain/Loss Transactions (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. |