Home » Categories » Multiple Categories

Detail Mandatory

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

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Set Auto Expand Data Files
Viewed 2163 times since Wed, Jul 4, 2012
Change Status – Confirmation Items
Viewed 3493 times since Fri, Jun 19, 2020
Detail Optional 4
Viewed 2431 times since Wed, Jul 4, 2012
Order Entry - Column 1/2 Inputs as View-Only
Viewed 3153 times since Fri, Oct 26, 2012
Additional Document Copy Items
Viewed 444 times since Tue, Oct 15, 2024
Controls and Audit Manager
Viewed 2356 times since Wed, Jul 4, 2012
Compact & Audit Database
Viewed 2080 times since Wed, Jul 4, 2012
Order Entry
Viewed 1924 times since Tue, Jul 3, 2012
Replicate Orders – Retain Original Order Pricing
Viewed 292 times since Tue, Oct 15, 2024
Order Enquiry
Viewed 1821 times since Tue, Jul 3, 2012