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
Order Acknowledgements
Viewed 1268 times since Tue, Jul 3, 2012
Remove Orders by Date
Viewed 1275 times since Tue, Jul 3, 2012
System Status - Application User Facilities
Viewed 1466 times since Wed, Jul 4, 2012
Order Entry - Minimum Order Values (SOP Only)
Viewed 46 times since Thu, Oct 24, 2024
System Status
Viewed 1250 times since Tue, Jul 3, 2012
Document Selection Criteria – User Defined Message
Viewed 12 times since Tue, Oct 22, 2024
Sales Order Batch Update
Viewed 1404 times since Tue, Jul 3, 2012
Replicate – Copy a Order (Excluding Compact)
Viewed 717 times since Tue, Jul 3, 2012
Order Detail Items to be Printed – Comma’s in Values
Viewed 15 times since Tue, Oct 15, 2024
Flag User-ID, Date and Time to Order Detail on Document Production
Viewed 2107 times since Wed, Jun 13, 2012