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
Database Profiles
Viewed 1446 times since Wed, Jul 4, 2012
Apply Delivery Charge if Below Minimum Order Value
Viewed 1865 times since Wed, Jun 13, 2012
Order Entry - Alternative Title for Price/Cost
Viewed 1410 times since Fri, Oct 26, 2012
Purchase Order Authorisation
Viewed 2007 times since Tue, Jun 12, 2012
Header Optional 2
Viewed 1356 times since Wed, Jul 4, 2012
Order Acknowledgements / Purchase Orders - Application User Facilities
Viewed 1304 times since Wed, Jul 4, 2012
Transaction / Detail Enquiries
Viewed 1844 times since Wed, Jul 4, 2012
Security and User Manager
Viewed 1486 times since Wed, Jul 4, 2012
Assembly Components as Quick Form
Viewed 1393 times since Fri, Nov 22, 2013
Order Entry
Viewed 1177 times since Tue, Jul 3, 2012