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
Delete - Delete an Order
Viewed 1152 times since Tue, Jul 3, 2012
Job Costing Link at Delivery Notes and Invoices
Viewed 1197 times since Tue, Jul 3, 2012
Database Profiles
Viewed 1446 times since Wed, Jul 4, 2012
SOP Order Call-Off
Viewed 1340 times since Tue, Jul 3, 2012
Order Utilities
Viewed 1094 times since Tue, Jul 3, 2012
Outstanding Orders Report
Viewed 1162 times since Tue, Jul 3, 2012
Print Stock Picking Sheet / Delivery Due Listing - Application User Facilities
Viewed 1425 times since Wed, Jul 4, 2012
Delivery Notes / Goods Received Notes - Application User Facilities
Viewed 1420 times since Wed, Jul 4, 2012
Revalue All Currency Orders
Viewed 1118 times since Tue, Jul 3, 2012
Sales Order Authorisation
Viewed 1993 times since Tue, Jun 12, 2012