1 ORDER-REF X 10
3 ACCOUNT X 10
4 DATE-INPUT D/E
31 DATE-REQUIRED D/E The date by which the goods are required (can be blank,
which will mean as soon as possible)
38 EXTRA-TEXT-1 X )
… ) Typically delivery instructions (not delivery address)
42 EXTRA-TEXT-5 X )
Examples of Extra Items to Add
Item Name Type Size Description
56 BACK-ORDER? ? Set to Y if order to be back-ordered if insufficient stock at the supplier
57 CONTRACT-REF X 14 Where orders are placed under a contract with the supplier
58 SALES-ORDER X 10 Should it be required to send the originating sales order …
59 CUST-REF X 14 … and the end-user customer reference
60 SOH-DEL-CODE X 30 Address code from originating sales order (B2B).
61 SOH-DEL-NAME X 30 Customer for this order (B2B)
62 DIRECT-DEL? ? 1 Set to Y where for direct delivery from supplier
The following data items are typical of those required by order response and invoice
transactions to hold values for reporting differences
140 XML_NETGOODS K 10 Total of net goods from invoice, for checking
141 XML_SETTDISC K 10 Settlement discount on invoice
142 XML_TAX K 10 Tax value from invoice
143 XML_SURCHARGE K 10 Financial (non-taxable) extra charge
144 XML_ADDITIONS K 10 Extra (taxable) charges, such as delivery
145 XML_DEL-REF X 12 Delivery note number (not necessarily response no)
146 XML_DEL-DATE D Delivery dated
147 XML_INV-REF X 12 Invoice number
148 XML_INV-DATE D Invoice date
149 XML_TAX-DATE D Tax date if different
The following data items are used to guide the process of creating XML order files.
150 XML_SEND ? 1 Set to Y to indicate this order is to be sent as XML.
Generally copied from account data item
151 XML_SENT ? 1 Set Y when XML order file generated
152 XML_SEND-DT D Date XML order generated
153 XML_FLGN N 4 A file sequence number (file generation number) if orders
sent within a batch file
154 XML_BATCH-ID N 4 Used by POP documents. Holds code for POP document
to be used when processing response or invoice
155 XML_RESP-DATE E 10 Date of XML order response
156 XML_RESP-NO X 6 Order response number
157 XML_ERROR X 5 Error code returned in order response
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.
Item Name Type Size Description
158 ADDED-BY X 6
159 ADDED-ON D 8
160 ADDED-AT N 4
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.
Article ID: 1879 Created On: Tue, Jul 10, 2012 at 3:43 PM Last Updated On: Thu, Jun 22, 2023 at 4:36 PM