Name Type Description
Order Code X, Y Up to 16 characters
Entry Number N Detail line number within order
Detail Status X Detail status:– A—active, C—complete, D— deleted, H—held, F-Forward and Q-Quote
Next Detail Record Y, N Record number of next detail line in order
Account Code X Customer/supplier account code
Stock Code X Stock code, or may be blank
Order Quantity L, K, M, * Order quantity in stock-keeping units (even if ordered in packs — see below)
Invoiced Quantity L, K, M Quantity invoiced so far in stock-keeping units
Price (Cost) each L, K, M, * Unit price agreed
Line Discount % L, K, M, * Percentage discount to be given on order line, regardless of whether price taken from discount matrix or not
Line Discount Amt L, K, * Value of discount given on this line
Tax Code X VAT code
Order Record No Y, N Record number of order header in order header file
Detail Value L, K, * Total value of order detail entry, after discount, normally excluding VAT
Invoiced Value L, K, * Total value invoiced so far, excluding VAT
Work Quantity L, K, M The action quantity keyed for this order detail in the last document produced.Although necessary as an internal value, in some circumstances you may want to use it in a document or report
Article ID: 1576
Created On: Wed, Jul 4, 2012 at 11:01 AM
Last Updated On: Mon, Jun 12, 2023 at 4:51 PM
Online URL: https://kb.datafile.co.uk/article/detail-mandatory-1576.html