Trans Mandatory - Stock Control

TRANSACTION-TYPE X (1) Identifies the type of transaction

TRANSACTION DATE D, E Holds the date the transaction was entered ‘as at’.

STOCK CODE X (16) Holds the stock code the transaction was entered for

QUANTITY K, L, M Holds the quantity the transaction was entered for.

COST PRICE K, L, M Holds the cost price the transaction was issued/received at

SELLING PRICE K, L, M Holds the selling price of sales issues (and assembly builds where sold at cost)

ANALYSIS N, T Used as the basis of the transaction analysis report.

REFERENCE X (6) Holds the transaction reference.

DESCRIPTION X (30) Holds the transaction description (as opposed to the stock description the transaction is for).

NEXT-TRANSACTION Y (6) Holds the record number of the next transaction for this stock record.

STOCK-RECORD-NO Y (6) Holds the record number in the Stock file of the stock item this transaction is for.

WHICH-PRICE X (1) The Which Price / Price No used for this transaction.

OLD COST/PRICE K, L, M Recorded on Cost/Price Change transactions this is the price prior to the change. The ‘new’ price is recorded in cost price or selling price as appropriate.

COST-RECALC ? Flag set when transaction has been used in calculating the Period B/F Values as part of the Recalculation of Stock Cost Values procedure.

ORDER REFERENCE X (16) Holds the sales/purchase/works order reference (as appropriate) that was used to generate this stock transaction.

ORDER ENTRY-NO N Holds the entry number of the sales/purchase/works order that generated this stock transaction.