El mensaje Report_NC_PurchaseOrder es un mensaje de salida que contiene detalles de pedido para un pedido completado. El sistema de mensajería de salida de WebSphere Commerce genera este mensaje utilizando la plantilla de composición OrderCreateXML.jsp y envía sus datos a una cola de mensajes de salida, donde un sistema de fondo recibe el mensaje. Esta aplicación recibe el mensaje y continúa cualquier proceso de gestión de fondo que sea necesario para completar la tarea especificada para el pedido. Utilice Report_NC_PurchaseOrder para realizar el proceso de pedido de los pedidos que se inician en el sistema WebSphere Commerce, pero que también requieren algún trabajo adicional o de fondo por parte de otro sistema.
El mensaje Report_NC_PurchaseOrder utiliza el formato de mensaje XML y va a continuación de Report_NC_PO_10.dtd.
El archivo DTD consta de un conjunto de elementos XML. El mensaje contiene información de pedido, comprador, facturación, comerciante y de envío. Los datos siguientes describen el archivo Report_NC_PO_10.dtd, que se utiliza para el mensaje Report_NC_PurchaseOrder:
El formato y el fuente de los valores de elementos XML se describen en la tabla siguiente. Para consultar una descripción de la columna de base de datos, siga el enlace con su tabla asociada. Todos los campos son opcionales a menos que se indique lo contrario. La longitud del valor del código del mensaje XML para campos de base de datos de tipo INT, BIGINT y DOUBLE debe ser CHAR(10), CHAR(19) y CHAR(16) respectivamente.
Nivel | Elemento XML | Comentario | Nombre de tabla | Nombre de columna |
---|---|---|---|---|
1 | ReportPO Header |
Obligatorio | 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 | Obligatorio | N/A | N/A |
1.5.A1 | currency | Atributo | ORDERS | CURRENCY |
1.5.1 | TotalNet Price |
Obligatorio | ORDERS | TOTALPRODUCT |
1.5.2 | TaxInfo | N/A | N/A | |
1.5.2.1 | Monetary Amount |
Obligatorio | ORDERS | TOTALTAX |
1.5.2.1.A1 | currency | Atributo | 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 |
Obligatorio | ORDERS | TOTALSHIPPING |
1.5.4 | TotalTaxOn ShippingPrice |
Obligatorio | 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 | Obligatorio | N/A | N/A |
1.8.2.1 | AddressLine | Obligatorio; primera aparición repetida | ADDRESS | ADDRESS1 |
1.8.2.1 | AddressLine | segunda aparición repetida | ADDRESS | ADDRESS2 |
1.8.2.1 | AddressLine | tercera aparición repetida | ADDRESS | ADDRESS3 |
1.8.2.2 | City | Obligatorio | ADDRESS | CITY |
1.8.2.3 | State | Obligatorio | ADDRESS | STATE |
1.8.2.4 | Zip | Obligatorio | ADDRESS | ZIPCODE |
1.8.2.5 | Country | Obligatorio | ADDRESS | COUNTRY |
1.8.3 | ContactPerson Name |
Obligatorio | 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 | Obligatorio | 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 | Obligatorio | N/A | N/A |
1.8.4.1 | Telephone | primera aparición repetida | ADDRESS | PHONE1 |
1.8.4.1 | Telephone | segunda aparición repetida | ADDRESS | PHONE2 |
1.8.4.2 | primera aparición repetida | ADDRESS | EMAIL1 | |
1.8.4.2 | segunda aparición repetida | ADDRESS | EMAIL2 | |
1.8.4.3 | Fax | ADDRESS | FAX1 | |
1.9 | MerchantInfo | N/A | N/A | |
1.9.1 | OrgName | Obligatorio | STOREENTDS | DISPLAYNAME |
1.9.2 | OrgID | primera aparición repetida | N/A | N/A |
1.9.2.A1 | type | atributo | ORDERS | STOREENT_ID |
1.9.3 | Address | Obligatorio | N/A | N/A |
1.9.3.1 | AddressLine | Obligatorio; primera aparición repetida | STADDRESS | ADDRESS1 |
1.9.3.1 | AddressLine | segunda aparición repetida | STADDRESS | ADDRESS2 |
1.9.3.1 | AddressLine | tercera aparición repetida | STADDRESS | ADDRESS3 |
1.9.3.2 | City | Obligatorio | STADDRESS | CITY |
1.9.3.3 | State | Obligatorio | STADDRESS | STATE |
1.9.3.4 | Zip | Obligatorio | STADDRESS | ZIPCODE |
1.9.3.5 | Country | Obligatorio | 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 | Obligatorio | 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 | Obligatorio | N/A | N/A |
1.9.7.1 | Telephone | primera aparición repetida | STADDRESS | PHONE1 |
1.9.7.1 | Telephone | segunda aparición repetida | STADDRESS | PHONE2 |
1.9.7.2 | primera aparición repetida | STADDRESS | EMAIL1 | |
1.9.7.3 | segunda aparición repetida | STADDRESS | EMAIL2 | |
1.9.7.4 | Fax | STADDRESS | FAX1 | |
1.10 | BuyOrgInfo | N/A | N/A | |
1.10.1 | OrgName | Obligatorio | ADDRESS | ORGNAME |
1.10.2 | OrgID | primera aparición repetida; | N/A | N/A |
1.10.2.A1 | type | Atributo; | N/A | N/A |
1.10.3 | Address | N/A | N/A | |
1.10.3.1 | AddressLine | Obligatorio; primera aparición repetida | N/A | N/A |
1.10.3.1 | AddressLine | segunda aparición repetida | N/A | N/A |
1.10.3.1 | AddressLine | tercera aparición repetida | N/A | N/A |
1.10.3.2 | City | Obligatorio | N/A | N/A |
1.10.3.3 | State | Obligatorio | N/A | N/A |
1.10.3.4 | Zip | Obligatorio | N/A | N/A |
1.10.3.5 | Country | Obligatorio | 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 | primera aparición repetida | N/A | N/A |
1.10.5.1 | Telephone | segunda aparición repetida | N/A | N/A |
1.10.5.2 | primera aparición repetida | N/A | N/A | |
1.10.5.2 | segunda aparición repetida | 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 |
Obligatorio | N/A | N/A |
1.11.1.1 | Title | N/A | N/A | |
1.11.1.2 | FullName | Obligatorio | N/A | N/A |
1.11.1.3 | LastName | Obligatorio | 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 | Obligatorio | N/A | N/A |
1.11.3.1 | AdddressLine | Obligatorio; primera aparición repetida | N/A | N/A |
1.11.3.1 | AdddressLine | segunda aparición repetida | N/A | N/A |
1.11.3.1 | AdddressLine | tercera aparición repetida | N/A | N/A |
1.11.3.2 | City | Obligatorio | N/A | N/A |
1.11.3.3 | State | Obligatorio | N/A | N/A |
1.11.3.4 | Zip | Obligatorio | N/A | N/A |
1.11.3.5 | Country | Obligatorio | N/A | N/A |
1.11.4 | ContactInfo | N/A | N/A | |
1.11.4.1 | Telephone | primera aparición repetida | N/A | N/A |
1.11.4.1 | Telephone | segunda aparición repetida | N/A | N/A |
1.11.4.2 | primera aparición repetida | N/A | N/A | |
1.11.4.2 | segunda aparición repetida | 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 | primera aparición repetida | ORDERS | MEMBER_ID |
1.12.1.A1 | type | Obligatorio; atributo | N/A | N/A |
1.12.1 | RequisitionerID | segunda aparición repetida | USERREG | LOGONID |
1.12.1.A2 | type | Obligatorio; atributo | 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 | Obligatorio; primera aparición repetida | ADDRESS | ADDRESS1 |
1.12.3.1 | AddressLine | segunda aparición repetida | ADDRESS | ADDRESS2 |
1.12.3.1 | AddressLine | tercera aparición repetida | ADDRESS | ADDRESS3 |
1.12.3.2 | City | Obligatorio | ADDRESS | CITY |
1.12.3.3 | State | Obligatorio | ADDRESS | STATE |
1.12.3.4 | Zip | Obligatorio | ADDRESS | ZIPCODE |
1.12.3.5 | Country | Obligatorio | ADDRESS | COUNTRY |
1.12.4 | ContactPerson Name |
N/A | N/A | |
1.12.4.1 | Title | ADDRESS | PERSONTITLE | |
1.12.4.2 | FullName | Obligatorio | N/A | N/A |
1.12.4.3 | LastName | Obligatorio | 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 | Obligatorio | N/A | N/A |
1.12.5.1 | Telephone | primera aparición repetida | ADDRESS | PHONE1 |
1.12.5.1 | Telephone | segunda aparición repetida | ADDRESS | PHONE2 |
1.12.5.2 | primera aparición repetida | ADDRESS | EMAIL1 | |
1.12.5.2 | segunda aparición repetida | 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 | Atributo | 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 | Atributo | N/A | N/A |
1.16.3 | BudgetCode | Obligatorio | N/A | N/A |
1.16.4 | Description | N/A | N/A | |
1.16.5 | Calculation Code |
Obligatorio | N/A | N/A |
1.17.2 | OrderCustomer Field |
primera aparición repetida | ORDERS | FIELD1 |
1.17.2 | OrderCustomer Field |
primera aparición repetida | ORDERS | FIELD2 |
1.17.2 | OrderCustomer Field |
segunda aparición repetida | ORDERS | FIELD3 |
1.18 | UserData | N/A | N/A | |
2 | ReportPOItem | Obligatorio; primera aparición repetida | 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 |
Obligatorio | 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 | Obligatorio | ORDERITEMS | PRICE |
2.8.A1 | currency | Atributo | ORDERITEMS | CURRENCY |
2.9 | TaxInfo | primera aparición repetida | N/A | N/A |
2.9.1 | Monetary Amount |
primera aparición repetida | N/A | N/A |
2.9.1.A1 | currency | atributo | 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 |
Obligatorio | 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 |
Obligatorio | N/A | N/A |
2.15.1.1 | Title | N/A | N/A | |
2.15.1.2 | FullName | Obligatorio | N/A | N/A |
2.15.1.3 | LastName | Obligatorio | 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 |
no soportado para esta versión. | N/A | N/A |
2.15.3 | Address | N/A | N/A | |
2.15.3.1 | AddressLine | Obligatorio; primera aparición repetida | ADDRESS | ADDRESS1 |
2.15.3.1 | AddressLine | segunda aparición repetida | ADDRESS | ADDRESS2 |
2.15.3.1 | AddressLine | tercera aparición repetida | ADDRESS | ADDRESS3 |
2.15.3.2 | City | Obligatorio | ADDRESS | CITY |
2.15.3.3 | State | Obligatorio | ADDRESS | STATE |
2.15.3.4 | Zip | Obligatorio | ADDRESS | ZIPCODE |
2.15.3.5 | Country | Obligatorio | ADDRESS | COUNTRY |
2.15.4 | ContactInfo | Obligatorio | N/A | N/A |
2.15.4.1 | Telephone | primera aparición repetida | ADDRESS | PHONE1 |
2.15.4.1 | Telephone | segunda aparición repetida | ADDRESS | PHONE2 |
2.15.4.2 | primera aparición repetida | ADDRESS | EMAIL1 | |
2.15.4.2 | segunda aparición repetida | 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 | Obligatorio | SHIPMODE | CARRIER |
2.16.2 | Method | Obligatorio | SHIPMODE | CODE |
2.17 | ShipStatus | ORDERITEMS | STATUS | |
2.18 | DateTime Reference |
Obligatorio | N/A | N/A |
2.18.1 | PlacedDate | Obligatorio | 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 |
primera aparición repetida | 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 | Atributo | N/A | N/A |
2.20.3 | BudgetCode | Obligatorio | N/A | N/A |
2.20.4 | Description | N/A | N/A | |
2.20.5 | Calculation Code |
Obligatorio | N/A | N/A |
2.21 | Service Allowance Charge |
primera aparición repetida | N/A | N/A |
2.21.1 | Allowance ChargeCode |
Obligatorio | 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 | Atributo | N/A | N/A |
2.21.3 | Description | N/A | N/A | |
2.21.4 | Calculation Code |
Obligatorio | N/A | N/A |
2.22 | ItemShipping Schedule |
N/A | N/A | |
2.22.1 | Quantity | Obligatorio | N/A | N/A |
2.22.2 | ShipDate Reference |
Obligatorio | 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 |
primera aparición repetida | ORDERITEMS | FIELD1 |
2.23 | ItemCustomer Field |
segunda aparición repetida | ORDERITEMS | FIELD2 |
2.24 | UserData | N/A | N/A |
![]() |