Datafile Home \| KB Home \| Advanced Search

Purchase Order Detail (POD)

Article Number: 1880 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 4:35 PM

Datafile Software

Purchase Order Detail (POD)

Items Required

Item Name Type Size Description

2 ENTRY N 4 Line number in order
6 STOCK X 16 Your own stock code (see also 112 below)
7 ORDER-QTY K 10
9 COST K 10 Price from supplier
14 DETAIL-VALUE L 14
32 DESCRIPTION X 35
36 PACK-QTY N 4 Consumer units in single pack from supplier
80 POD-PRIME X 16 Used as the line reference, required for return processes

Examples of Extra Items to Add

Item Name Type Size Description
These items would be used when creating orders
110 DESCR-ONLY ? 1 These probably won’t be included in order
111 BACK-ORDER? ? 1 Set to Y to indicate this line is to be back-ordered
112 STOCK-ONLY = Use this instead of 6 if multi-location, to strip location
113 XML_PROD-ALT X 1 Can be used as a code to determine the supplier code
157 XML_SUPP X 4 To hold the 4-character supplier code such as KING
158 XML_SENT ? 1 Indicates this detail line has been sent. The date of sending will be the same as for the order header record

The following are examples of the items required for processing order responses and
invoices:

142 XML_DEL-QTY K 10 Quantity not going to be delivered at all
143 XML_STATUS1 X 5 Provides for up to two error codes (which will be supplier-
144 XML_STATUS2 X 5 specific if used).
145 XML_ACK-NARR X 30
146 XML_ACK-TEXT X 30
147 XML_INV-QTY K 10 Quantity on invoice
148 XML_PRODUCT X 16 New product code (where product superceded)
149 XML_QUANTITY K 10
150 XML_PRICE K 10 Price (new if from order response)
151 XML_PACK N 4 Pack size (new if from order response)
152 XML_VALUE L 14
153 XML_VAT-CODE X 1
154 XML_VAT-VALUE L 14
155 XML_RETAIL K 10 Recommended retail price
156 XML_DEL-QTY * 14 The quantity used by order response. Order quantity less that back-ordered and deleted (not available)

Where back orders are allowed, and the supplier will report them, typically additional
fields are crated to hold a number of these (up to 5, say) and the back-ordered quantities
accumulated and included in the calculation of item 156.

The following data items are assumed to be already present for date-time stamping
database records into the database, and have no particular bearing on XML.

158 ADDED-BY X 6
159 ADDED-ON D 8
160 ADDED-AT N 4

Custom Fields