Batch Mandatory - Batch Tracking

BATCH NUMBER X (32) The prime index of the batch file holding the batch code itself.

STOCK CODE X (32) Holds the stock code that the batch/serial item belongs to.

STOCK RECORD NO Y (6) Holds the record number within the stock database of the stock code that the batch/serial item belongs to.

NEXT BATCH Y (6) Holds the record number of the next batch/serial item for the stock code that this batch item belongs to.

ORIGINAL QUANTITY K, L, M Holds the quantity originally purchased/built when this batch record created.

PHYSICAL QUANTITY K, L, M Holds the quantity currently physically available.

ON-ORDER QUANTITY K, L, M Holds the quantity on-order through Bill of Materials and Purchase Order Processing.

RESERVED QUANTITY K, L, M Holds the quantity reserved through Bill of Materials and Sales Order Processing

FREE QUANTITY * A calculation of Physical plus On-Order less Reserved

COST PRICE K, L, M Holds the cost price the batch was received/built at

PREV BATCH Y (6) Holds the record number of the previous batch/serial item for the stock code that this batch item belongs to