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
Status – Amend an Order Status
Viewed 673 times since Tue, Jul 3, 2012
Forms – Define a Quick Form (Diamond and Premier only)
Viewed 840 times since Tue, Jul 3, 2012
Set Application Code Formats
Viewed 1336 times since Tue, Jul 3, 2012
Copy Items
Viewed 1432 times since Wed, Jul 4, 2012
Report on Order Status
Viewed 1201 times since Tue, Jul 3, 2012
Complementary Stock Items
Viewed 1514 times since Fri, Nov 22, 2013
Audit Pointers and Balances
Viewed 1320 times since Wed, Jul 4, 2012
Omit Values on Delivery Note
Viewed 2082 times since Tue, Jun 12, 2012
Cleardown Options
Viewed 1091 times since Tue, Jul 3, 2012
POP Accessories
Viewed 1145 times since Tue, Jul 3, 2012