Name Type Description
Description line 1 X Maximum 48 characters
Description line 2 X, & Maximum 48 characters
Description only ? If Y, then quantity and price values omitted on document for this line
Price per factor N, T, C See also Price Per Qty in stock control Database Profiles. Copied from stock file
Delivered Quantity L, K, M Total quantity delivered so far
Pack quantity N, T, C See also Pack quantity in stock control Database Profiles. Copied from stock file
Split Quantity M Represents order quantity in packs and units; integer portion the packs ordered, and decimals (treated as a four-digit number) the spare units
Work-Qty-Pack L, K, M The last document action quantity entered, but only if entered in terms of packs and units, as per the Split quantity above
Surcharge Amt L, K, M, * Extra amount charged when pack is broken to supply item
Cost per factor N, T, C SOP Only. See also Cost Per Qty in stock control. Copied from stock file and used to determine cost value when updating sales ledger and stock control
Goods Value L, K, * Value of order line excluding discount
Extra Text: First X } Allow any number of text fields to be entered on
Extra Text: Last X } order detail and printed on documents below
} description fields. Max 48 characters
Pack Mult N, K SOP Only – POP equivalent on Detail Optional 3 See also Pack Multiplier in stock control Database Profiles. Copied from stock file
On Back Order ? If Y then delivery note left outstanding quantity on back order
Price Matrix Date D, E SOP Only. Used with the discount matrix where a special price expires on a certain date. The price expiration date is copied to this field
Job Reference X, Y POP Only – SOP equivalent on Detail Optional 3. Job code if this order detail is linked to job costing. Set as secondary index if job ledger enquiry to link to purchase orders.
Job Code Analysis X, Y POP Only – SOP equivalent on Detail Optional 3. Cost code if this order detail is linked to job costing.
Job Category X, Y, N, T POP Only. Cost code category if this order detail is linked to job costing.
Article ID: 1578
Created On: Wed, Jul 4, 2012 at 11:02 AM
Last Updated On: Mon, Jun 12, 2023 at 3:15 PM
Online URL: https://kb.datafile.co.uk/article/detail-optional-2-1578.html