Home » Categories » Solutions by Business Process » E-Business » XML

Purchase Order Detail (POD)

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
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Credit Control Manager / Additional Options
Viewed 2703 times since Mon, Jun 11, 2012
Processing Commands
Viewed 1487 times since Mon, Jul 9, 2012
Call XML Option From Application Menu
Viewed 1270 times since Tue, Jul 10, 2012
Formatting XML Files With “White Space”
Viewed 2446 times since Mon, Jul 9, 2012
Specific Trading Partner Notes - Spicers
Viewed 3725 times since Tue, Jul 10, 2012
File Generation Numbers
Viewed 1295 times since Mon, Jul 9, 2012
Application Considerations - Sales Order Processing
Viewed 1781 times since Tue, Jul 10, 2012
Foreign Currency
Viewed 1230 times since Mon, Jul 9, 2012
Trading Partners from S/L
Viewed 1221 times since Thu, Jul 5, 2012
Accumulator File
Viewed 1759 times since Mon, Jul 9, 2012