SL/PL-ACCOUNT X (10) Holds the sales/purchase account code for which this transaction was generated.
NOMINAL CODE X (16) Holds the nominal code. Typically this is the sales (or purchase depending on type) nominal code recorded on the stock record unless amended via the Order Processing/Invoicing system.
USER-1 Any Stock Transaction Header item (see System Profiles)
USER-2 Any Stock Transaction Detail item (see System Profiles)
TAX-CODE X (1) Holds the VAT code for the generated transaction. Usually the default code recorded on the Stock file unless amended via the Order Processing/Invoice systems or overridden with EC/Exempt codes based on the customer/supplier.
TAX-AMOUNT K, L Holds the tax amount applicable for the transaction.
PACK-QUANTITY N Holds the pack quantity of the stock item (copied from stock record at time of transaction generation).
DISCOUNT-RATE K, L Holds the (line) discount rate applied to this transaction when generated within the order processing / invoicing systems.
DISCOUNT-AMNT K, L Holds the (line) discount value given for this transaction within the order processing / invoicing systems.
TFR-STOCK CODE X (16) A Stock Transfer generates two type ‘7’ transactions per transfer.This item contains the ‘other’ side (either from/to depending on negative/positive state of the qty value) of the transfer for enquiry. For assembly transaction then the component type ‘9’ transactions have the assembly stock code recorded here.
PRICE-PER-FACTOR N Holds the price per (or cost per on goods in) at which the stock item was issued (received).
CURRENCY-CODE X (3) If generated via the Order Processing/Invoicing systems and the Foreign Currency accessory is in use then this is the currency than the stock transaction was generated in.
CURRENCY-RATE M This is the exchange rate the transaction was generated at.
CURRENCY-COST/PRICE K, L, M This is the currency value the transaction was generated at.
PERIOD-NUMBER N This is the period number the transaction was generated in.
WEEK-NUMBER N This is the week number (if appropriate) the transaction was generated in.
Article ID: 531
Created On: Tue, Jun 19, 2012 at 12:11 PM
Last Updated On: Thu, Jun 22, 2023 at 10:47 PM
Online URL: https://kb.datafile.co.uk/article/transaction-optional-stock-control-531.html