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.
Article ID: 530
Created On: Tue, Jun 19, 2012 at 12:10 PM
Last Updated On: Thu, Jun 22, 2023 at 10:48 PM
Online URL: https://kb.datafile.co.uk/article/trans-mandatory-stock-control-530.html