Report_NC_PurchaseOrder message

The Report_NC_PurchaseOrder message is an outbound message that contains order details for a completed order. The WebSphere Commerce outbound messaging system generates this message using the OrderCreateXML.jsp composition template and sends its data to an outbound message queue, where a back-end system receives the message. This application takes the message and continues any back-end business processes required to complete the specified task for the order. Use Report_NC_PurchaseOrder to fulfill the order process of orders that begin with the WebSphere Commerce system, but also require some additional or back-end work by a separate system.

The Report_NC_PurchaseOrder message uses the XML message format and follows Report_NC_PO_10.dtd.

The DTD file consists of a set of XML elements. The message contains order, customer, billing, merchant, and shipping information. The following data describes Report_NC_PO_10.dtd, which is used for the Report_NC_PurchaseOrder message:

The format and the source of the XML element values are described in the following table. For a description of the database column, follow the link to its associated table. All fields are optional unless otherwise noted. The tag value length in the XML message for database fields of type INT, BIGINT and DOUBLE should be CHAR (10), CHAR(19), and CHAR(16) respectively.

Level XML Element Comment Table Name Column Name
1 ReportPO Header Mandatory N/A N/A
1.1 OrderNumber ByBuyer N/A N/A
1.2 OrderNumber ByMerchant ORDERS ORMORDER
1.3 OrderNumber ByNC ORDERS ORDERS_ID
1.4 DateTime Reference N/A N/A
1.4.1 PlacedDate ORDERS TIMEPLACED
1.4.2 PlacedTime ORDERS TIMEPLACED
1.4.3 LastUpdate Date N/A N/A
1.4.4 LatestUpdate Time N/A N/A
1.5 TotalPriceInfo Mandatory N/A N/A
1.5.A1 currency Attribute ORDERS CURRENCY
1.5.1 TotalNet Price Mandatory ORDERS TOTALPRODUCT
1.5.2 TaxInfo N/A N/A
1.5.2.1 Monetary Amount Mandatory ORDERS TOTALTAX
1.5.2.1.A1 currency Attribute ORDERS CURRENCY
1.5.2.2 TaxType N/A N/A
1.5.2.3 Percentage N/A N/A
1.5.2.4 TaxExemption StatusType N/A N/A
1.5.2.5 TaxExemption Number N/A N/A
1.5.2.6 TaxJurisdiction Code N/A N/A
1.5.2.7 TaxJurisdiction CodeType N/A N/A
1.5.3 Total ShippingPrice Mandatory ORDERS TOTALSHIPPING
1.5.4 TotalTaxOn ShippingPrice Mandatory ORDERS TOTALTAXSHIPPING
1.6 Instruction N/A N/A
1.7 ShipStatus ORDERS STATUS
1.8 BillToInfo N/A N/A
1.8.1 OrgName N/A N/A
1.8.2 Address Mandatory N/A N/A
1.8.2.1 AddressLine Mandatory; first repeated occurrence ADDRESS ADDRESS1
1.8.2.1 AddressLine second repeated occurrence ADDRESS ADDRESS2
1.8.2.1 AddressLine third repeated occurrence ADDRESS ADDRESS3
1.8.2.2 City Mandatory ADDRESS CITY
1.8.2.3 State Mandatory ADDRESS STATE
1.8.2.4 Zip Mandatory ADDRESS ZIPCODE
1.8.2.5 Country Mandatory ADDRESS COUNTRY
1.8.3 ContactPerson Name Mandatory N/A N/A
1.8.3.1 Title N/A N/A
1.8.3.2 FullName N/A N/A
1.8.3.3 LastName Mandatory ADDRESS LASTNAME
1.8.3.4 FirstName ADDRESS FIRSTNAME
1.8.3.5 MiddleName ADDRESS MIDDLENAME
1.8.3.6 AlternateName ADDRESS NICKNAME
1.8.4 ContactInfo Mandatory N/A N/A
1.8.4.1 Telephone first repeated occurrence ADDRESS PHONE1
1.8.4.1 Telephone second repeated occurrence ADDRESS PHONE2
1.8.4.2 Email first repeated occurrence ADDRESS EMAIL1
1.8.4.2 Email second repeated occurrence ADDRESS EMAIL2
1.8.4.3 Fax ADDRESS FAX1
1.9 MerchantInfo N/A N/A
1.9.1 OrgName Mandatory STOREENTDS DISPLAYNAME
1.9.2 OrgID first repeated occurrence N/A N/A
1.9.2.A1 type attribute ORDERS STOREENT_ID
1.9.3 Address Mandatory N/A N/A
1.9.3.1 AddressLine Mandatory; first repeated occurrence STADDRESS ADDRESS1
1.9.3.1 AddressLine second repeated occurrence STADDRESS ADDRESS2
1.9.3.1 AddressLine third repeated occurrence STADDRESS ADDRESS3
1.9.3.2 City Mandatory STADDRESS CITY
1.9.3.3 State Mandatory STADDRESS STATE
1.9.3.4 Zip Mandatory STADDRESS ZIPCODE
1.9.3.5 Country Mandatory STADDRESS COUNTRY
1.9.4 URL N/A N/A
1.9.5 Telephone STADDRESS PHONE1
1.9.6 ContactPerson Name N/A N/A
1.9.6.1 Title STADDRESS PERSONTITLE
1.9.6.2 FullName N/A N/A
1.9.6.3 LastName Mandatory STADDRESS LASTNAME
1.9.6.4 FirstName STADDRESS FIRSTNAME
1.9.6.5 MiddleName STADDRESS MIDDLENAME
1.9.6.6 AlternateName N/A N/A
1.9.7 ContactInfo Mandatory N/A N/A
1.9.7.1 Telephone first repeated occurrence STADDRESS PHONE1
1.9.7.1 Telephone second repeated occurrence STADDRESS PHONE2
1.9.7.2 Email first repeated occurrence STADDRESS EMAIL1
1.9.7.3 Email second repeated occurrence STADDRESS EMAIL2
1.9.7.4 Fax STADDRESS FAX1
1.10 BuyOrgInfo N/A N/A
1.10.1 OrgName Mandatory ADDRESS ORGNAME
1.10.2 OrgID first repeated occurrence; N/A N/A
1.10.2.A1 type Attribute; N/A N/A
1.10.3 Address N/A N/A
1.10.3.1 AddressLine Mandatory; first repeated occurrence N/A N/A
1.10.3.1 AddressLine second repeated occurrence N/A N/A
1.10.3.1 AddressLine third repeated occurrence N/A N/A
1.10.3.2 City Mandatory N/A N/A
1.10.3.3 State Mandatory N/A N/A
1.10.3.4 Zip Mandatory N/A N/A
1.10.3.5 Country Mandatory N/A N/A
1.10.4 URL N/A N/A
1.10.5 ContactInfo N/A N/A
1.10.5.1 Telephone first repeated occurrence N/A N/A
1.10.5.1 Telephone second repeated occurrence N/A N/A
1.10.5.2 Email first repeated occurrence N/A N/A
1.10.5.2 Email second repeated occurrence N/A N/A
1.10.5.3 Fax N/A N/A
1.11 ShipToInfo N/A N/A
1.11.1 ContactPerson Name Mandatory N/A N/A
1.11.1.1 Title N/A N/A
1.11.1.2 FullName Mandatory N/A N/A
1.11.1.3 LastName Mandatory N/A N/A
1.11.1.4 FirstName N/A N/A
1.11.1.5 MiddleName N/A N/A
1.11.1.6 AlternateName N/A N/A
1.11.2 OfficeAddress Line N/A N/A
1.11.3 Address Mandatory N/A N/A
1.11.3.1 AdddressLine Mandatory; first repeated occurrence N/A N/A
1.11.3.1 AdddressLine second repeated occurrence N/A N/A
1.11.3.1 AdddressLine third repeated occurrence N/A N/A
1.11.3.2 City Mandatory N/A N/A
1.11.3.3 State Mandatory N/A N/A
1.11.3.4 Zip Mandatory N/A N/A
1.11.3.5 Country Mandatory N/A N/A
1.11.4 ContactInfo N/A N/A
1.11.4.1 Telephone first repeated occurrence N/A N/A
1.11.4.1 Telephone second repeated occurrence N/A N/A
1.11.4.2 Email first repeated occurrence N/A N/A
1.11.4.2 Email second repeated occurrence N/A N/A
1.11.4.3 Fax N/A N/A
1.11.5 Comment N/A N/A
1.12 Requisitioner Info N/A N/A
1.12.1 RequisitionerID first repeated occurrence ORDERS MEMBER_ID
1.12.1.A1 type Mandatory; attribute N/A N/A
1.12.1 RequisitionerID second repeated occurrence USERREG LOGONID
1.12.1.A2 type Mandatory; attribute N/A N/A
1.12.2 Requisitioner Group N/A N/A
1.12.3 Address N/A N/A
1.12.3.1 AddressLine Mandatory; first repeated occurrence ADDRESS ADDRESS1
1.12.3.1 AddressLine second repeated occurrence ADDRESS ADDRESS2
1.12.3.1 AddressLine third repeated occurrence ADDRESS ADDRESS3
1.12.3.2 City Mandatory ADDRESS CITY
1.12.3.3 State Mandatory ADDRESS STATE
1.12.3.4 Zip Mandatory ADDRESS ZIPCODE
1.12.3.5 Country Mandatory ADDRESS COUNTRY
1.12.4 ContactPerson Name N/A N/A
1.12.4.1 Title ADDRESS PERSONTITLE
1.12.4.2 FullName Mandatory N/A N/A
1.12.4.3 LastName Mandatory ADDRESS LASTNAME
1.12.4.4 FirstName ADDRESS FIRSTNAME
1.12.4.5 MiddleName ADDRESS MIDDLENAME
1.12.4.6 AlternateName N/A N/A
1.12.5 ContactInfo Mandatory N/A N/A
1.12.5.1 Telephone first repeated occurrence ADDRESS PHONE1
1.12.5.1 Telephone second repeated occurrence ADDRESS PHONE2
1.12.5.2 Email first repeated occurrence ADDRESS EMAIL1
1.12.5.2 Email second repeated occurrence ADDRESS EMAIL2
1.12.5.3 Fax ADDRESS FAX1
1.13 ShipDate Reference N/A N/A
1.13.1 Requested ShipDate N/A N/A
1.13.2 Scheduled ShipDate N/A N/A
1.13.3 Actual ShipDate N/A N/A
1.14 PCardInfo N/A N/A
1.14.1 Monetary Amount ORDPAYMTHD MAXAMOUNT
1.14.1.A1 currency Attribute ORDERS CURRENCY
1.14.2 CardType ORDPAYMTHD PAYMETHOD
1.14.3 CardNumber ORDPAYMTHD PAYDEVICE
1.14.4 Expiration Date ORDPAYMTHD ENDDATE
1.14.5 IssueDate ORDPAYMTHD STARTDATE
1.14.6 Credit Authorization Number N/A N/A
1.14.7 Customer Reference Number N/A N/A
1.15 Shipping CarrierInfo N/A N/A
1.15.1 Carrier N/A N/A
1.15.2 Method N/A N/A
1.16 BuyOrg Accounting Detail N/A N/A
1.16.1 Percentage N/A N/A
1.16.2 Monetary Amount N/A N/A
1.16.2.A1 currency Attribute N/A N/A
1.16.3 BudgetCode Mandatory N/A N/A
1.16.4 Description N/A N/A
1.16.5 Calculation Code Mandatory N/A N/A
1.17.2 OrderCustomer Field first repeated occurrence ORDERS FIELD1
1.17.2 OrderCustomer Field first repeated occurrence ORDERS FIELD2
1.17.2 OrderCustomer Field second repeated occurrence ORDERS FIELD3
1.18 UserData N/A N/A
2 ReportPOItem Mandatory; first repeated occurrence N/A N/A
2.1 ItemLine Number N/A N/A
2.2 ItemNumber ByNC ORDERITEMS ORDERITEMS_ID
2.3 ProductNumber ByBuyer N/A N/A
2.4 ProductNumber ByMerchant Mandatory CATENTRY PARTNUMBER
2.5 Manufacturer Name N/A N/A
2.6 Manufacturer URL N/A N/A
2.7 Manufacturer PartNumber N/A N/A
2.8 ItemUnitPrice Mandatory ORDERITEMS PRICE
2.8.A1 currency Attribute ORDERITEMS CURRENCY
2.9 TaxInfo first repeated occurrence N/A N/A
2.9.1 Monetary Amount first repeated occurrence N/A N/A
2.9.1.A1 currency attribute N/A N/A
2.9.2 TaxType N/A N/A
2.9.3 Percentage N/A N/A
2.9.4 TaxExemption StatusType N/A N/A
2.9.5 TaxExemption Number N/A N/A
2.9.6 TaxJurisdiction Code N/A N/A
2.9.7 TaxJurisdiction CodeType N/A N/A
2.10 ItemProduct Quantity Mandatory ORDERITEMS QUANTITY
2.11 UnitOf Measure N/A N/A
2.12 Classification N/A N/A
2.13 ItemProduct ShortDescription CATENTDESC SHORTDESCRIPTION
2.14 Instruction N/A N/A
2.15 ShipToInfo N/A N/A
2.15.1 ContactPerson Name Mandatory N/A N/A
2.15.1.1 Title N/A N/A
2.15.1.2 FullName Mandatory N/A N/A
2.15.1.3 LastName Mandatory ADDRESS LASTNAME
2.15.1.4 FirstName ADDRESS FIRSTNAME
2.15.1.5 MiddleName ADDRESS MIDDLENAME
2.15.1.6 AlternateName ADDRESS NICKNAME
2.15.2 Office AddressLine not supported for this version N/A N/A
2.15.3 Address N/A N/A
2.15.3.1 AddressLine Mandatory; first repeated occurrence ADDRESS ADDRESS1
2.15.3.1 AddressLine second repeated occurrence ADDRESS ADDRESS2
2.15.3.1 AddressLine third repeated occurrence ADDRESS ADDRESS3
2.15.3.2 City Mandatory ADDRESS CITY
2.15.3.3 State Mandatory ADDRESS STATE
2.15.3.4 Zip Mandatory ADDRESS ZIPCODE
2.15.3.5 Country Mandatory ADDRESS COUNTRY
2.15.4 ContactInfo Mandatory N/A N/A
2.15.4.1 Telephone first repeated occurrence ADDRESS PHONE1
2.15.4.1 Telephone second repeated occurrence ADDRESS PHONE2
2.15.4.2 Email first repeated occurrence ADDRESS EMAIL1
2.15.4.2 Email second repeated occurrence ADDRESS EMAIL2
2.15.4.3 Fax ADDRESS FAX1
2.15.5 Comment ORDERITEMS COMMENTS
2.16 Shipping CarrierInfo N/A N/A
2.16.1 Carrier Mandatory SHIPMODE CARRIER
2.16.2 Method Mandatory SHIPMODE CODE
2.17 ShipStatus ORDERITEMS STATUS
2.18 DateTime Reference Mandatory N/A N/A
2.18.1 PlacedDate Mandatory ORDERITEMS LASTCREATE
2.18.2 PlacedTime ORDERITEMS LASTCREATE
2.18.3 LastUpdate Date ORDERITEMS LASTUPDATE
2.18.4 LastUpdate Time ORDERITEMS LASTUPDATE
2.19 Product Measurement N/A N/A
2.20 BuyOrg Accounting Detail first repeated occurrence N/A N/A
2.20.1 Percentage N/A N/A
2.20.2 Monetary Amount N/A N/A
2.20.2.A1 currency Attribute N/A N/A
2.20.3 BudgetCode Mandatory N/A N/A
2.20.4 Description N/A N/A
2.20.5 Calculation Code Mandatory N/A N/A
2.21 Service Allowance Charge first repeated occurrence N/A N/A
2.21.1 Allowance ChargeCode Mandatory N/A N/A
2.21.2 Percentage N/A N/A
2.21.2 Monetary Amount N/A N/A
2.21.2.A1 currency Attribute N/A N/A
2.21.3 Description N/A N/A
2.21.4 Calculation Code Mandatory N/A N/A
2.22 ItemShipping Schedule N/A N/A
2.22.1 Quantity Mandatory N/A N/A
2.22.2 ShipDate Reference Mandatory N/A N/A
2.22.2.1 Requested ShipDate N/A N/A
2.22.2.1 Scheduled ShipDate N/A N/A
2.22.2.3 ActualShip Date N/A N/A
2.23 ItemCustomer Field first repeated occurrence ORDERITEMS FIELD1
2.23 ItemCustomer Field second repeated occurrence ORDERITEMS FIELD2
2.24 UserData N/A N/A