Report_NC_PurchaseOrder message
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 HCL Commerce genera este mensaje utilizando la plantilla de composición OrderCreateXML.jsp y envía los 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 los pedidos que empiezan con el sistema de HCL Commerce pero que también requieren algún trabajo de programa de fondo o adicional por parte de un sistema distinto.
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, cliente, 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 una 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 | Obligatoria | 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 | Obligatoria | N/A | N/A |
1.5.A1 | currency | Atributo | ORDERS | CURRENCY |
1.5.1 | TotalNet Price | Obligatoria | ORDERS | TOTALPRODUCT |
1.5.2 | TaxInfo | N/A | N/A | |
1.5.2.1 | Monetary Amount | Obligatoria | 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 | Obligatoria | ORDERS | TOTALSHIPPING |
1.5.4 | TotalTaxOn ShippingPrice | Obligatoria | 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 | Dirección | Obligatoria | 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 | Obligatoria | ADDRESS | CITY |
1.8.2.3 | Estado | Obligatoria | ADDRESS | STATE |
1.8.2.4 | Zip | Obligatoria | ADDRESS | ZIPCODE |
1.8.2.5 | Country | Obligatoria | ADDRESS | COUNTRY |
1.8.3 | ContactPerson Name | Obligatoria | N/A | N/A |
1.8.3.1 | Título | N/A | N/A | |
1.8.3.2 | FullName | N/A | N/A | |
1.8.3.3 | LastName | Obligatoria | 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 | Obligatoria | 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 | Correo electrónico | primera aparición repetida | ADDRESS | EMAIL1 |
1.8.4.2 | Correo electrónico | segunda aparición repetida | ADDRESS | EMAIL2 |
1.8.4.3 | Fax | ADDRESS | FAX1 | |
1.9 | MerchantInfo | N/A | N/A | |
1.9.1 | OrgName | Obligatoria | STOREENTDS | DISPLAYNAME |
1.9.2 | OrgID | primera aparición repetida | N/A | N/A |
1.9.2.A1 | tipo | atributo | ORDERS | STOREENT_ID |
1.9.3 | Dirección | Obligatoria | 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 | Obligatoria | STADDRESS | CITY |
1.9.3.3 | Estado | Obligatoria | STADDRESS | STATE |
1.9.3.4 | Zip | Obligatoria | STADDRESS | ZIPCODE |
1.9.3.5 | Country | Obligatoria | 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 | Título | STADDRESS | PERSONTITLE | |
1.9.6.2 | FullName | N/A | N/A | |
1.9.6.3 | LastName | Obligatoria | 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 | Obligatoria | 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 | Correo electrónico | primera aparición repetida | STADDRESS | EMAIL1 |
1.9.7.3 | Correo electrónico | segunda aparición repetida | STADDRESS | EMAIL2 |
1.9.7.4 | Fax | STADDRESS | FAX1 | |
1.10 | BuyOrgInfo | N/A | N/A | |
1.10.1 | OrgName | Obligatoria | ADDRESS | ORGNAME |
1.10.2 | OrgID | primera aparición repetida; | N/A | N/A |
1.10.2.A1 | tipo | Atributo; | N/A | N/A |
1.10.3 | Dirección | 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 | Obligatoria | N/A | N/A |
1.10.3.3 | Estado | Obligatoria | N/A | N/A |
1.10.3.4 | Zip | Obligatoria | N/A | N/A |
1.10.3.5 | Country | Obligatoria | 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 | Correo electrónico | primera aparición repetida | N/A | N/A |
1.10.5.2 | Correo electrónico | 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 | Obligatoria | N/A | N/A |
1.11.1.1 | Título | N/A | N/A | |
1.11.1.2 | FullName | Obligatoria | N/A | N/A |
1.11.1.3 | LastName | Obligatoria | 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 | Dirección | Obligatoria | 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 | Obligatoria | N/A | N/A |
1.11.3.3 | Estado | Obligatoria | N/A | N/A |
1.11.3.4 | Zip | Obligatoria | N/A | N/A |
1.11.3.5 | Country | Obligatoria | 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 | Correo electrónico | primera aparición repetida | N/A | N/A |
1.11.4.2 | Correo electrónico | segunda aparición repetida | N/A | N/A |
1.11.4.3 | Fax | N/A | N/A | |
1.11.5 | Comentario | 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 | tipo | Obligatorio; atributo | N/A | N/A |
1.12.1 | RequisitionerID | segunda aparición repetida | USERREG | LOGONID |
1.12.1.A2 | tipo | Obligatorio; atributo | N/A | N/A |
1.12.2 | Requisitioner Group | N/A | N/A | |
1.12.3 | Dirección | 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 | Obligatoria | ADDRESS | CITY |
1.12.3.3 | Estado | Obligatoria | ADDRESS | STATE |
1.12.3.4 | Zip | Obligatoria | ADDRESS | ZIPCODE |
1.12.3.5 | Country | Obligatoria | ADDRESS | COUNTRY |
1.12.4 | ContactPerson Name | N/A | N/A | |
1.12.4.1 | Título | ADDRESS | PERSONTITLE | |
1.12.4.2 | FullName | Obligatoria | N/A | N/A |
1.12.4.3 | LastName | Obligatoria | 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 | Obligatoria | 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 | Correo electrónico | primera aparición repetida | ADDRESS | EMAIL1 |
1.12.5.2 | Correo electrónico | 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 | Fecha de caducidad | 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 | Método | 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 | Obligatoria | N/A | N/A |
1.16.4 | Descripción: | N/A | N/A | |
1.16.5 | Calculation Code | Obligatoria | 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 | Obligatoria | CATENTRY | PARTNUMBER |
2.5 | Nombre del fabricante | N/A | N/A | |
2.6 | Manufacturer URL | N/A | N/A | |
2.7 | Manufacturer PartNumber | N/A | N/A | |
2.8 | ItemUnitPrice | Obligatoria | 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 | Obligatoria | 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 | Obligatoria | N/A | N/A |
2.15.1.1 | Título | N/A | N/A | |
2.15.1.2 | FullName | Obligatoria | N/A | N/A |
2.15.1.3 | LastName | Obligatoria | 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 | Dirección | 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 | Obligatoria | ADDRESS | CITY |
2.15.3.3 | Estado | Obligatoria | ADDRESS | STATE |
2.15.3.4 | Zip | Obligatoria | ADDRESS | ZIPCODE |
2.15.3.5 | Country | Obligatoria | ADDRESS | COUNTRY |
2.15.4 | ContactInfo | Obligatoria | 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 | Correo electrónico | primera aparición repetida | ADDRESS | EMAIL1 |
2.15.4.2 | Correo electrónico | segunda aparición repetida | ADDRESS | EMAIL2 |
2.15.4.3 | Fax | ADDRESS | FAX1 | |
2.15.5 | Comentario | ORDERITEMS | COMMENTS | |
2.16 | Shipping CarrierInfo | N/A | N/A | |
2.16.1 | Carrier | Obligatoria | SHIPMODE | CARRIER |
2.16.2 | Método | Obligatoria | SHIPMODE | CODE |
2.17 | ShipStatus | ORDERITEMS | STATUS | |
2.18 | DateTime Reference | Obligatoria | N/A | N/A |
2.18.1 | PlacedDate | Obligatoria | ORDERITEMS | LASTCREATE |
2.18.2 | PlacedTime | ORDERITEMS | LASTCREATE | |
2.18.3 | LastUpdate Date | ORDERITEMS | LASTUPDATE | |
2.18.4 | Hora de última modificación | 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 | Obligatoria | N/A | N/A |
2.20.4 | Descripción: | N/A | N/A | |
2.20.5 | Calculation Code | Obligatoria | N/A | N/A |
2.21 | Service Allowance Charge | primera aparición repetida | N/A | N/A |
2.21.1 | Allowance ChargeCode | Obligatoria | 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 | Descripción: | N/A | N/A | |
2.21.4 | Calculation Code | Obligatoria | N/A | N/A |
2.22 | ItemShipping Schedule | N/A | N/A | |
2.22.1 | Cantidad | Obligatoria | N/A | N/A |
2.22.2 | ShipDate Reference | Obligatoria | 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 |