Develop > Controller layer > Integrate with back-end systems and external applications > Integration XML messages > Back-end integration messages

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	Ship 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	Ship 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

Related concepts

Order notification

Related tasks

Enable the Report_NC_PurchaseOrder message

+

Search Tips   |   Advanced Search