使用XML 管理亚马逊订单5——检索付款详情

检索付款详情 — 结算报告

描述

结算报告提供结算周期内所有的财务交易信息。结算周期因卖家协议而异。结算报告包括结算周期内所有的订单和盘点信息,显示了支付到您银行账户的款项详情。

注意:您的银行账户一般会在结算报告生成后的 4 天内收到款项。

词典

元素描述
【结算日期】结算信息的容器,包括以下要素:

亚马逊结算编号

亚马逊为结算提供的唯一编号

总金额

支付到您银行账户的金额

开始日期

结算周期的第一天

结束日期

结算周期的一天

存款日期

支付日期

【亚马逊订单编号】亚马逊为订单提供的唯一编号,用于识别整个订单,不论订单中各种商品的数量是多少
【卖家订单编号】由卖家提供的可选订单编号。第一步是在确认上传数据中建立【卖家订单编号】。亚马逊会将【卖家订单编号】映射到【亚马逊订单编号】上,之后您就可以对后续关于该订单的上传数据使用您自己的编号(【卖家订单编号】)。查看基础 XSD 以了解定义。
【配送编号】
【运费】
【商城名称】

下单网站的名称(例如 Amazon.com)

【配送】订单配送信息的容器,包括以下要素:

    【卖家配送编号】 - 卖家为配送提供的唯一编号(亚马逊不使用)

    【发放日期】 - 发放到您付款账户的日期

    商品容器:

    亚马逊订单商品编码

    亚马逊为订单内商品提供的唯一编号

    卖家订单商品编号

    卖家为订单内商品提供的可选编号。如果在确认上传数据中建立了匹配,那么它就可以用于订单处理。

    SKU

    特定卖家为特定商品提供的唯一编号

    数量

    购买的数量(单个商品)

    商品价格
    商品费用
    促销
    卖家促销编号

    卖家用于追踪指定促销的编号

    类型

    促销类型

    金额

    存入到您的付款账户或从您的付款账户扣除的金额

    直接付款
    订单费

    盘点容器:

    亚马逊订单商品编码

    亚马逊为订单内商品提供的唯一编号

    卖家订单商品编号

    卖家为订单内商品提供的可选编号。如果在确认上传数据中建立了匹配,那么它就可以用于订单处理。

    SKU

    特定卖家为特定商品提供的唯一编号

    商品价格盘点

    买家将获得的商品退款金额,按类型分类。查看基础 XSD 以了解类型的定义。全部金额均为所有商品的对应费用总和,而非单价。金额已签收:向买家退还正数金额,从买家收取负数金额(例如重新入库费)。

    商品费用盘点
    促销盘点
    卖家促销编号

    卖家用于追踪指定促销的编号

    类型

    促销类型

    金额

    存入到您的付款账户或从您的付款账户扣除的盘点金额

    直接付款
    订单费用盘点

    其他费用容器:

    亚马逊订单商品编码

    亚马逊为订单内商品提供的唯一编号

    卖家订单商品编号

    卖家为订单内商品提供的可选编号。如果在确认上传数据中建立了匹配,那么它就可以用于订单处理。

    商城名称

    下单网站的名称(例如 Amazon.com)

    卖家配送编号

    卖家为配送提供的唯一编号(亚马逊不使用)

    发放日期

    发放到您付款账户的日期

    金额

    存入到您的付款账户或从您的付款账户扣除的其他费用金额

    原因描述

    其他交易容器:

    亚马逊订单商品编码

    亚马逊为订单内商品提供的唯一编号

    卖家订单商品编号

    卖家为订单内商品提供的可选编号。如果在确认上传数据中建立了匹配,那么它就可以用于订单处理。

    商城名称

    下单网站的名称(例如 Amazon.com)

    卖家配送编号

    卖家为配送提供的唯一编号(亚马逊不使用)

    交易类型
    交易编号
    发放日期

    发放到您付款账户的日期

    金额

    存入到您的付款账户或从您的付款账户扣除的其他交易金额

    原因描述
    费用

    杂项容器:

    发放日期

    发放到您付款账户的日期

    金额

    存入到您付款账户的杂项费用金额

XSD

https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_1_9/SettlementReport.xsd

<?xmlversion="1.0"?><!-Revision="$Revision:#9$"--><!-SettlementReportVersion="3.1"--><xsd:schemaxmlns:xsd="http://www.w3.org/2001/XMLSchema"elementFormDefault="qualified"><xsd:includeschemaLocation="amzn-base.xsd"/><xsd:elementname="SettlementReport"><xsd:complexType><xsd:sequence><xsd:elementname="SettlementData"><xsd:complexType><xsd:sequence><xsd:elementname="AmazonSettlementID"type="IDNumber"/><xsd:elementname="TotalAmount"type="CurrencyAmount"/><xsd:elementname="StartDate"type="xsd:dateTime"/><xsd:elementname="EndDate"type="xsd:dateTime"/><xsd:elementname="DepositDate"type="xsd:dateTime"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="Order"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderID"/><xsd:elementref="MerchantOrderID"minOccurs="0"/><xsd:elementname="ShipmentID"minOccurs="0"/><xsd:elementname="ShipmentFees"type="AmazonFees"minOccurs="0"maxOccurs="unbounded"/><xsd:elementref="MarketplaceName"/><xsd:elementname="Fulfillment"><xsd:complexType><xsd:sequence><xsd:elementref="MerchantFulfillmentID"minOccurs="0"/><xsd:elementname="PostedDate"type="xsd:dateTime"/><xsd:elementname="Item"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderItemCode"/><xsd:elementref="MerchantOrderItemID"minOccurs="0"/><xsd:elementref="SKU"/><xsd:elementname="Quantity"type="xsd:positiveInteger"/><xsd:elementname="ItemPrice"type="BuyerPrice"/><xsd:elementname="ItemFees"type="AmazonFees"minOccurs="0"/><xsd:elementname="Promotion"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="MerchantPromotionID"/><xsd:elementname="Type"type="StringNotNull"/><xsd:elementname="Amount"type="CurrencyAmount"/></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="DirectPayment"type="DirectPaymentType"minOccurs="0"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="OrderFee"type="AmazonFees"minOccurs="0"maxOccurs="unbounded"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="Adjustment"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderID"/><xsd:elementref="MerchantOrderID"minOccurs="0"/><xsd:elementname="AdjustmentID"type="StringNotNull"minOccurs="0"/><xsd:elementref="MarketplaceName"/><xsd:elementname="Fulfillment"><xsd:complexType><xsd:sequence><xsd:elementref="MerchantFulfillmentID"minOccurs="0"/><xsd:elementname="PostedDate"type="xsd:dateTime"/><xsd:elementname="AdjustedItem"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderItemCode"/><xsd:elementref="MerchantOrderItemID"minOccurs="0"/><xsd:elementname="MerchantAdjustmentItemID"type="StringNotNull"minOccurs="0"/><xsd:elementref="SKU"/><xsd:elementname="ItemPriceAdjustments"type="BuyerPrice"/><xsd:elementname="ItemFeeAdjustments"type="AmazonFees"minOccurs="0"/><xsd:elementname="PromotionAdjustment"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="MerchantPromotionID"/><xsd:elementname="Type"type="StringNotNull"/><xsd:elementname="Amount"type="CurrencyAmount"/></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="DirectPayment"type="DirectPaymentType"minOccurs="0"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="OrderFeeAdjustment"type="AmazonFees"minOccurs="0"maxOccurs="unbounded"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="OtherFee"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderID"minOccurs="0"/><xsd:elementref="MerchantOrderID"minOccurs="0"/><xsd:elementref="MarketplaceName"/><xsd:elementref="MerchantFulfillmentID"minOccurs="0"/><xsd:elementname="PostedDate"type="xsd:dateTime"/><xsd:elementname="Amount"type="CurrencyAmount"/><xsd:elementname="ReasonDescription"type="StringNotNull"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="OtherTransaction"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementref="AmazonOrderID"minOccurs="0"/><xsd:elementref="MerchantOrderID"minOccurs="0"/><xsd:elementref="MarketplaceName"minOccurs="0"/><xsd:elementref="MerchantFulfillmentID"minOccurs="0"/><xsd:elementname="TransactionType"type="StringNotNull"/><xsd:elementname="TransactionID"type="StringNotNull"minOccurs="0"/><xsd:elementname="PostedDate"type="xsd:dateTime"/><xsd:elementname="Amount"type="CurrencyAmount"/><xsd:elementname="ReasonDescription"type="StringNotNull"minOccurs="0"/><xsd:elementname="Fees"type="AmazonFees"minOccurs="0"/></xsd:sequence></xsd:complexType></xsd:element><xsd:elementname="MiscEvent"minOccurs="0"maxOccurs="unbounded"><xsd:complexType><xsd:sequence><xsd:elementname="PostedDate"type="xsd:dateTime"/><xsd:elementname="Amount"type="CurrencyAmount"/></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema>

示例

<?xmlversion="1.0"encoding="UTF-8"?><SettlementReport><SettlementData><AmazonSettlementID>5024267331</AmazonSettlementID><TotalAmountcurrency="USD">-58.73</TotalAmount><StartDate>2008-11-28T14:47:05+00:00</StartDate><EndDate>2008-12-26T14:45:14+00:00</EndDate><DepositDate>2008-12-28T14:45:14+00:00</DepositDate></SettlementData><Order><AmazonOrderID>105-6982537-6258888</AmazonOrderID><ShipmentID>DqWG0</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19084441555</MerchantFulfillmentID><PostedDate>2008-12-15T19:33:04+00:00</PostedDate><Item><AmazonOrderItemCode>13350774331938</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>102-4226580-9099444</AmazonOrderID><ShipmentID>DtVS</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19089363182</MerchantFulfillmentID><PostedDate>2008-12-15T21:43:08+00:00</PostedDate><Item><AmazonOrderItemCode>00806662376130</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component><Component><Type>Shipping</Type><Amountcurrency="USD">0.01</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>002-6239589-9267444</AmazonOrderID><ShipmentID>Dx9K03plR</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19083904842</MerchantFulfillmentID><PostedDate>2008-12-15T22:31:38+00:00</PostedDate><Item><AmazonOrderItemCode>31454552568346</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item><Item><AmazonOrderItemCode>66480775952306</AmazonOrderItemCode><SKU>U1410</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item><Item><AmazonOrderItemCode>34282312709418</AmazonOrderItemCode><SKU>U1411</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>105-6517412-1452222</AmazonOrderID><ShipmentID>DBwP0npwR</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19085579472</MerchantFulfillmentID><PostedDate>2008-12-18T14:34:54+00:00</PostedDate><Item><AmazonOrderItemCode>65536901305826</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>002-8437726-3624222</AmazonOrderID><ShipmentID>DHww0qpvR</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19085714592</MerchantFulfillmentID><PostedDate>2008-12-18T14:34:54+00:00</PostedDate><Item><AmazonOrderItemCode>28647667911362</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>002-8325573-8322666</AmazonOrderID><ShipmentID>DB9r0gp1R</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19083705712</MerchantFulfillmentID><PostedDate>2008-12-18T14:34:54+00:00</PostedDate><Item><AmazonOrderItemCode>06849903846282</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>1</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.02</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.01</Amount></Fee></ItemFees></Item></Fulfillment></Order><Order><AmazonOrderID>103-6428709-2012222</AmazonOrderID><ShipmentID>Dv9Y04ptR</ShipmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19083802582</MerchantFulfillmentID><PostedDate>2008-12-18T14:34:54+00:00</PostedDate><Item><AmazonOrderItemCode>62939279608258</AmazonOrderItemCode><SKU>U1409</SKU><Quantity>3</Quantity><ItemPrice><Component><Type>Principal</Type><Amountcurrency="USD">0.45</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">0.06</Amount></Component></ItemPrice><ItemFees><Fee><Type>Commission</Type><Amountcurrency="USD">-0.03</Amount></Fee></ItemFees></Item></Fulfillment></Order><Adjustment><AmazonOrderID>002-6239589-9267444</AmazonOrderID><AdjustmentID>0WT7-KYP1-GB7H-A0ZA-8Y7W</AdjustmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19083904842</MerchantFulfillmentID><PostedDate>2008-12-19T15:06:37+00:00</PostedDate><AdjustedItem><AmazonOrderItemCode>34282312709418</AmazonOrderItemCode><SKU>U1411</SKU><ItemPriceAdjustments><Component><Type>Principal</Type><Amountcurrency="USD">-0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">-0.02</Amount></Component></ItemPriceAdjustments><ItemFeeAdjustments><Fee><Type>Commission</Type><Amountcurrency="USD">0.01</Amount></Fee></ItemFeeAdjustments></AdjustedItem></Fulfillment></Adjustment><Adjustment><AmazonOrderID>105-6982537-6258666</AmazonOrderID><AdjustmentID>04XM-3VWM-6DD9-SZQB-GZXG</AdjustmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19084441572</MerchantFulfillmentID><PostedDate>2008-12-19T15:06:34+00:00</PostedDate><AdjustedItem><AmazonOrderItemCode>13350774331938</AmazonOrderItemCode><SKU>U1409</SKU><ItemPriceAdjustments><Component><Type>Principal</Type><Amountcurrency="USD">-0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">-0.02</Amount></Component></ItemPriceAdjustments><ItemFeeAdjustments><Fee><Type>Commission</Type><Amountcurrency="USD">0.01</Amount></Fee></ItemFeeAdjustments></AdjustedItem></Fulfillment></Adjustment><Adjustment><AmazonOrderID>102-4226580-9099444</AmazonOrderID><AdjustmentID>0PZG-3CA0-XDE6-9Y2X-HQD6</AdjustmentID><MarketplaceName>Amazon.com</MarketplaceName><Fulfillment><MerchantFulfillmentID>MFNMFN19089363182</MerchantFulfillmentID><PostedDate>2008-12-19T15:06:56+00:00</PostedDate><AdjustedItem><AmazonOrderItemCode>00806662376130</AmazonOrderItemCode><SKU>U1409</SKU><ItemPriceAdjustments><Component><Type>Principal</Type><Amountcurrency="USD">-0.15</Amount></Component><Component><Type>Tax</Type><Amountcurrency="USD">-0.02</Amount></Component><Component><Type>Shipping</Type><Amountcurrency="USD">-0.01</Amount></Component></ItemPriceAdjustments><ItemFeeAdjustments><Fee><Type>Commission</Type><Amountcurrency="USD">0.01</Amount></Fee></ItemFeeAdjustments></AdjustedItem></Fulfillment></Adjustment><OtherTransaction><TransactionType>SubscriptionFee</TransactionType><PostedDate>2008-12-21T14:50:45+00:00</PostedDate><Amountcurrency="USD">-59.99</Amount></OtherTransaction></SettlementReport>

文章来源:亚马逊官方网站

免责声明:本站所有文章和图片均来自用户分享和网络收集,文章和图片版权归原作者及原出处所有,仅供学习与参考,请勿用于商业用途,如果损害了您的权利,请联系网站客服处理。