Mapping Data Between cXML and Net.Commerce

Net.Commerce and cXML both have standard data elements. Net.Commerce data elements are defined in standard DB2 tables, while cXML data elements are defined in the cXML Document Type Definition (DTD) file. As data from both cXML and Net.Commerce are defined based on a standard, you can easily map cXML data to Net.Commerce data.

Following is an example of mapping of an OrderRequest and a PunchOutOrderMessage from cXML to Net.Commerce. Columns A through H represent the cXML data, and columns J through L represent Net.Commerce data. Because the mapping is defined in a spreadsheet that does not fit vertically in one figure, the mapping is presented below in two separate figures.

Following is an example of some extension tables that a client may require in a punchout scenario. This example addresses only the standard Net.Commerce tables mapped to cXML and vice versa. Because the tables are defined in a spreadsheet that is wider than this page, they are presented below in three separate figures.