Report_NC_PurchaseOrder 訊息是一種出埠訊息,其中包含已完成訂單的訂單明細。 WebSphere Commerce 出埠傳訊系統會使用 OrderCreateXML.jsp 撰寫範本產生此訊息, 並將其資料送到出埠訊息佇列中, 供後端系統接收訊息。此應用程式會取得該訊息, 並繼續執行任何必要的後端商業程序,以針對該訂單完成指定的作業。Report_NC_PurchaseOrder 可讓您從 WebSphere Commerce 系統開始進行訂單的處理, 不過仍需要一個個別系統來執行一些額外或後端的工作。
Report_NC_PurchaseOrder 訊息採用 XML 訊息格式且遵循 Report_NC_PO_10.dtd。
DTD 檔由一組 XML 元素組成。訊息中包含訂單、購物者、帳單、 商家以及出貨資訊。下列資料說明用於 Report_NC_PurchaseOrder 訊息上的 Report_NC_PO_10.dtd:
下表說明 XML 元素值的格式與來源。有關資料庫直欄的說明, 請依循其相關表格的鏈結進行。所有欄位皆為選用的(除非另有註明)。 在 XML 訊息中,INT、BIGINT 與 DOUBLE 類型之資料庫欄位的標籤值長度分別是 CHAR (10)、CHAR(19) 與 CHAR(16)。
層次 | XML 元素 | 備註 | 表格名稱 | 直欄名稱 |
---|---|---|---|---|
1 | ReportPO Header |
必要 | 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 | 必要 | N/A | N/A |
1.5.A1 | 貨幣 | 屬性 | ORDERS | CURRENCY |
1.5.1 | TotalNet Price |
必要 | ORDERS | TOTALPRODUCT |
1.5.2 | TaxInfo | N/A | N/A | |
1.5.2.1 | Monetary Amount |
必要 | ORDERS | TOTALTAX |
1.5.2.1.A1 | 貨幣 | 屬性 | 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 |
必要 | ORDERS | TOTALSHIPPING |
1.5.4 | TotalTaxOn ShippingPrice |
必要 | 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 | 必要 | N/A | N/A |
1.8.2.1 | AddressLine | 必須輸入;第一次重複出現 | ADDRESS | ADDRESS1 |
1.8.2.1 | AddressLine | 第二次重複出現 | ADDRESS | ADDRESS2 |
1.8.2.1 | AddressLine | 第三次重複出現 | ADDRESS | ADDRESS3 |
1.8.2.2 | City | 必要 | ADDRESS | CITY |
1.8.2.3 | State | 必要 | ADDRESS | STATE |
1.8.2.4 | Zip | 必要 | ADDRESS | ZIPCODE |
1.8.2.5 | Country | 必要 | ADDRESS | COUNTRY |
1.8.3 | ContactPerson Name |
必要 | 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 | 必要 | 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 | 必要 | N/A | N/A |
1.8.4.1 | Telephone | 第一次重複出現 | ADDRESS | PHONE1 |
1.8.4.1 | Telephone | 第二次重複出現 | ADDRESS | PHONE2 |
1.8.4.2 | 第一次重複出現 | ADDRESS | EMAIL1 | |
1.8.4.2 | 第二次重複出現 | ADDRESS | EMAIL2 | |
1.8.4.3 | Fax | ADDRESS | FAX1 | |
1.9 | MerchantInfo | N/A | N/A | |
1.9.1 | OrgName | 必要 | STOREENTDS | DISPLAYNAME |
1.9.2 | OrgID | 第一次重複出現 | N/A | N/A |
1.9.2.A1 | type | 屬性 | ORDERS | STOREENT_ID |
1.9.3 | Address | 必要 | N/A | N/A |
1.9.3.1 | AddressLine | 必須輸入;第一次重複出現 | STADDRESS | ADDRESS1 |
1.9.3.1 | AddressLine | 第二次重複出現 | STADDRESS | ADDRESS2 |
1.9.3.1 | AddressLine | 第三次重複出現 | STADDRESS | ADDRESS3 |
1.9.3.2 | City | 必要 | STADDRESS | CITY |
1.9.3.3 | State | 必要 | STADDRESS | STATE |
1.9.3.4 | Zip | 必要 | STADDRESS | ZIPCODE |
1.9.3.5 | Country | 必要 | 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 | 必要 | 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 | 必要 | N/A | N/A |
1.9.7.1 | Telephone | 第一次重複出現 | STADDRESS | PHONE1 |
1.9.7.1 | Telephone | 第二次重複出現 | STADDRESS | PHONE2 |
1.9.7.2 | 第一次重複出現 | STADDRESS | EMAIL1 | |
1.9.7.3 | 第二次重複出現 | STADDRESS | EMAIL2 | |
1.9.7.4 | Fax | STADDRESS | FAX1 | |
1.10 | BuyOrgInfo | N/A | N/A | |
1.10.1 | OrgName | 必要 | ADDRESS | ORGNAME |
1.10.2 | OrgID | 第一次重複出現 | N/A | N/A |
1.10.2.A1 | type | 屬性 | N/A | N/A |
1.10.3 | Address | N/A | N/A | |
1.10.3.1 | AddressLine | 必須輸入;第一次重複出現 | N/A | N/A |
1.10.3.1 | AddressLine | 第二次重複出現 | N/A | N/A |
1.10.3.1 | AddressLine | 第三次重複出現 | N/A | N/A |
1.10.3.2 | City | 必要 | N/A | N/A |
1.10.3.3 | State | 必要 | N/A | N/A |
1.10.3.4 | Zip | 必要 | N/A | N/A |
1.10.3.5 | Country | 必要 | 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 | 第一次重複出現 | N/A | N/A |
1.10.5.1 | Telephone | 第二次重複出現 | N/A | N/A |
1.10.5.2 | 第一次重複出現 | N/A | N/A | |
1.10.5.2 | 第二次重複出現 | 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 |
必要 | N/A | N/A |
1.11.1.1 | Title | N/A | N/A | |
1.11.1.2 | FullName | 必要 | N/A | N/A |
1.11.1.3 | LastName | 必要 | 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 | 必要 | N/A | N/A |
1.11.3.1 | AdddressLine | 必須輸入;第一次重複出現 | N/A | N/A |
1.11.3.1 | AdddressLine | 第二次重複出現 | N/A | N/A |
1.11.3.1 | AdddressLine | 第三次重複出現 | N/A | N/A |
1.11.3.2 | City | 必要 | N/A | N/A |
1.11.3.3 | State | 必要 | N/A | N/A |
1.11.3.4 | Zip | 必要 | N/A | N/A |
1.11.3.5 | Country | 必要 | N/A | N/A |
1.11.4 | ContactInfo | N/A | N/A | |
1.11.4.1 | Telephone | 第一次重複出現 | N/A | N/A |
1.11.4.1 | Telephone | 第二次重複出現 | N/A | N/A |
1.11.4.2 | 第一次重複出現 | N/A | N/A | |
1.11.4.2 | 第二次重複出現 | N/A | N/A | |
1.11.4.3 | Fax | N/A | N/A | |
1.11.5 | 備註 | N/A | N/A | |
1.12 | Requisitioner Info |
N/A | N/A | |
1.12.1 | RequisitionerID | 第一次重複出現 | ORDERS | MEMBER_ID |
1.12.1.A1 | type | 必須輸入;屬性 | N/A | N/A |
1.12.1 | RequisitionerID | 第二次重複出現 | USERREG | LOGONID |
1.12.1.A2 | type | 必須輸入;屬性 | 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 | 必須輸入;第一次重複出現 | ADDRESS | ADDRESS1 |
1.12.3.1 | AddressLine | 第二次重複出現 | ADDRESS | ADDRESS2 |
1.12.3.1 | AddressLine | 第三次重複出現 | ADDRESS | ADDRESS3 |
1.12.3.2 | City | 必要 | ADDRESS | CITY |
1.12.3.3 | State | 必要 | ADDRESS | STATE |
1.12.3.4 | Zip | 必要 | ADDRESS | ZIPCODE |
1.12.3.5 | Country | 必要 | ADDRESS | COUNTRY |
1.12.4 | ContactPerson Name |
N/A | N/A | |
1.12.4.1 | Title | ADDRESS | PERSONTITLE | |
1.12.4.2 | FullName | 必要 | N/A | N/A |
1.12.4.3 | LastName | 必要 | 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 | 必要 | N/A | N/A |
1.12.5.1 | Telephone | 第一次重複出現 | ADDRESS | PHONE1 |
1.12.5.1 | Telephone | 第二次重複出現 | ADDRESS | PHONE2 |
1.12.5.2 | 第一次重複出現 | ADDRESS | EMAIL1 | |
1.12.5.2 | 第二次重複出現 | 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 | 貨幣 | 屬性 | 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 | 信用 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 | 貨幣 | 屬性 | N/A | N/A |
1.16.3 | BudgetCode | 必要 | N/A | N/A |
1.16.4 | 說明 | N/A | N/A | |
1.16.5 | 計算 Code |
必要 | N/A | N/A |
1.17.2 | OrderCustomer Field |
第一次重複出現 | ORDERS | FIELD1 |
1.17.2 | OrderCustomer Field |
第一次重複出現 | ORDERS | FIELD2 |
1.17.2 | OrderCustomer Field |
第二次重複出現 | ORDERS | FIELD3 |
1.18 | UserData | N/A | N/A | |
2 | ReportPOItem | 必須輸入;第一次重複出現 | 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 |
必要 | 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 | 必要 | ORDERITEMS | PRICE |
2.8.A1 | 貨幣 | 屬性 | ORDERITEMS | CURRENCY |
2.9 | TaxInfo | 第一次重複出現 | N/A | N/A |
2.9.1 | Monetary Amount |
第一次重複出現 | N/A | N/A |
2.9.1.A1 | 貨幣 | 屬性 | 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 |
必要 | 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 |
必要 | N/A | N/A |
2.15.1.1 | Title | N/A | N/A | |
2.15.1.2 | FullName | 必須輸入 | N/A | N/A |
2.15.1.3 | LastName | 必要 | 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 |
本版不支援 | N/A | N/A |
2.15.3 | Address | N/A | N/A | |
2.15.3.1 | AddressLine | 必須輸入;第一次重複出現 | ADDRESS | ADDRESS1 |
2.15.3.1 | AddressLine | 第二次重複出現 | ADDRESS | ADDRESS2 |
2.15.3.1 | AddressLine | 第三次重複出現 | ADDRESS | ADDRESS3 |
2.15.3.2 | City | 必要 | ADDRESS | CITY |
2.15.3.3 | State | 必要 | ADDRESS | STATE |
2.15.3.4 | Zip | 必要 | ADDRESS | ZIPCODE |
2.15.3.5 | Country | 必要 | ADDRESS | COUNTRY |
2.15.4 | ContactInfo | 必要 | N/A | N/A |
2.15.4.1 | Telephone | 第一次重複出現 | ADDRESS | PHONE1 |
2.15.4.1 | Telephone | 第二次重複出現 | ADDRESS | PHONE2 |
2.15.4.2 | 第一次重複出現 | ADDRESS | EMAIL1 | |
2.15.4.2 | 第二次重複出現 | ADDRESS | EMAIL2 | |
2.15.4.3 | Fax | ADDRESS | FAX1 | |
2.15.5 | 備註 | ORDERITEMS | COMMENTS | |
2.16 | Shipping CarrierInfo |
N/A | N/A | |
2.16.1 | Carrier | 必要 | SHIPMODE | CARRIER |
2.16.2 | Method | 必要 | SHIPMODE | CODE |
2.17 | ShipStatus | ORDERITEMS | STATUS | |
2.18 | DateTime Reference |
必要 | N/A | N/A |
2.18.1 | PlacedDate | 必要 | 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 |
第一次重複出現 | 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 | 貨幣 | 屬性 | N/A | N/A |
2.20.3 | BudgetCode | 必要 | N/A | N/A |
2.20.4 | 說明 | N/A | N/A | |
2.20.5 | 計算 Code |
必須輸入 | N/A | N/A |
2.21 | Service Allowance Charge |
第一次重複出現 | N/A | N/A |
2.21.1 | Allowance ChargeCode |
必要 | 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 | 貨幣 | 屬性 | N/A | N/A |
2.21.3 | 說明 | N/A | N/A | |
2.21.4 | 計算 Code |
必要 | N/A | N/A |
2.22 | ItemShipping Schedule |
N/A | N/A | |
2.22.1 | Quantity | 必須輸入 | N/A | N/A |
2.22.2 | ShipDate Reference |
必要 | 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 |
第一次重複出現 | ORDERITEMS | FIELD1 |
2.23 | ItemCustomer Field |
第二次重複出現 | ORDERITEMS | FIELD2 |
2.24 | UserData | N/A | N/A |
![]() |