114x Filetype XLS File size 0.09 MB Source: bisg.org
Sheet 1: Sales Reporting Template XML
BISG SALES REPORT MESSAGE | VERSION 1.1 | PUBLISHED 19 DECEMBER 2012 | |||||||||||||||||||||
INSTRUCTIONS What follows are final recommendations for best practice sales report elements. This version includes the XML encoding, which is compatible with the EDItEUR EDItX Sales Report version 1.1. A flat file version of these elements is also available on the BISG website (www.bisg.org). |
||||||||||||||||||||||
Element | Description | Composite / Data |
|
Data format | XML format | |||||||||||||||||
Big picture | NOTE - For composite elements only the start tags are shown. Elements that are below and to the right are inserted between the start and end tags of the containing composite element. Data elements are shown with example data colored red. | |||||||||||||||||||||
Detail level 1 | ||||||||||||||||||||||
Detail level 2 | ||||||||||||||||||||||
Detail level 3 | ||||||||||||||||||||||
SALES REPORT MESSAGE | C | 1 | <SalesReport version="1.1"> | |||||||||||||||||||
HEADER | C | 1 | <Header> | |||||||||||||||||||
Sales report number | A number or string by which this report may be referred to. | D | 1 | String | HEADER | <SalesReportNumber>SR0000001</SalesReportNumber> | ||||||||||||||||
Date report generated | The date and optionally time of report generation. Format YYYYMMDD or YYYYMMDDTHHMMSS. Date and time are to be interpreted as local to the reporting party. | D | 1 | ISO 8601 Date or DateTime - see descrip-tion |
HEADER | <IssueDateTime>20120709</IssueDateTime> | ||||||||||||||||
Message function | Indicates whether this report is the original, a duplicate, or for test purposes only. | D | 1 | Code | HEADER | <PurposeCode>Test</PurposeCode> | ||||||||||||||||
Sales report type | Indicates whether the line item level of the report details individual transactions or aggregates transactions by product and price point. | D | 0-1 | Code | HEADER | <SalesReportTypeCode>ByProduct</SalesReportTypeCode> | ||||||||||||||||
Reporting price type | The price type used for reporting purposes. The code value must correspond to a price type in ONIX code list 58. Usually the RRP (recommended retail price) including or excluding sales tax. Must either be specified in the Header or on every Line item. | D | 0-1 | Code | HEADER | <ReportPriceQualifierCode>PublisherRPExcludingTax</ReportPriceQualifierCode> | ||||||||||||||||
Reporting currency | The currency in which all sales values are reported. | D | 1 | ISO Currency Code | HEADER | <CurrencyCode>USD</CurrencyCode> | ||||||||||||||||
Sales report period from | The date and optionally time that marks the start of the sales period being reported. Mandatory. Format YYYYMMDD or YYYYMMDDTHHMMSS. Date and time are to be interpreted as local to the reporting party. Must be used in conjunction with "Sales report period to." When the reporting period is a specific day (midnight to midnight local to reporting party), the 'from' and 'to' dates must be identical in their date parts and the time parts must either be '000000' and '235959' or be omitted. | C | 1 | ISO 8601 Date or DateTime - see descrip-tion |
HEADER | <DateCoded> <Date>20110703T000000</Date> <DateQualifierCode>SalesPeriodStart</DateQualifierCode> </DateCoded> |
||||||||||||||||
Sales report period to | The date and optionally time that marks the end of the sales period being reported. Mandatory. Format YYYYMMDD or YYYYMMDDTHHMMSS. Date and time are to be interpreted as local to the reporting party. Must be used in conjunction with "Sales report period to." When the reporting period is a specific day (midnight to midnight local to reporting party), the 'from' and 'to' dates must be identical in their date parts and the time parts must either be '000000' and '235959' or be omitted. | C | 1 | ISO 8601 Date or DateTime - see descrip-tion |
HEADER | <DateCoded> <Date>20120709T235959</Date> <DateQualifierCode>SalesPeriodEnd</DateQualifierCode> </DateCoded> |
||||||||||||||||
- | ||||||||||||||||||||||
Class of sale | The default class of sale for all items included in this report. Options are: '01' (Agency), '02' (Wholesale). | D | 0-1 | Code | HEADER | <ClassOfSaleCode>01</ClassOfSaleCode> | ||||||||||||||||
Sales territory | Territory into which all reported sales have been made. Mandatory unless specified for each line item. May contain multiple codes (separated by spaces) for multiple territories, in which case sales territory will usually also be specified for each line item. | D | 0-1 | ISO 3166-1 two-letter country code or ONIX code list 49 region code | HEADER | <TradingZone>US</TradingZone> | ||||||||||||||||
Publisher party | The publisher of all the products to which this report relates. More usually reported at the line item level, if at all. | C | 0-1 | HEADER | <PublisherParty> [see <ReportingParty> and <ReceivingParty> for structure details and content examples] </PublisherParty> |
|||||||||||||||||
Reporting party | The party responsible for delivering this sales report | C | 1 | HEADER | <ReportingParty> | |||||||||||||||||
Main party identifier | A unique identifier for the party. Usually mandatory, unless trading partners agree that a name is sufficient. | C | 0-1 | HEADER | <PartyID> | |||||||||||||||||
Identifier scheme | Indicates what identification scheme is used, e.g. 'GLN', 'SAN', 'Proprietary' | D | 1 | Code | HEADER | <PartyIDType>SAN</PartyIDType> | ||||||||||||||||
Scheme name | Name or description of a proprietary scheme. Mandatory if the sheme is 'Proprietary'. Otherwise omitted. | D | 0-1 | String | HEADER | |||||||||||||||||
Identifier value | The identifier. Must be consistent with the specified scheme. | D | 1 | String | HEADER | <Identifier>9999999</Identifier> </PartyID> |
||||||||||||||||
Additional party identifier | Any additional identifier for the party that needs to be included. May be repeated if there is more than only additional identifier. | C | 0-n | HEADER | <AdditionalPartyID> | |||||||||||||||||
Identifier scheme | Indicates what identification scheme is used, e.g. 'GLN', 'SAN', 'Proprietary' | D | 1 | Code | HEADER | <PartyIDType>Proprietary</PartyIDType> | ||||||||||||||||
Scheme name | Name or description of a proprietary scheme. Mandatory if the sheme is 'Proprietary'. | D | 0-1 | String | HEADER | <IDTypeName>Publisher's proprietary agent identification scheme</IDTypeName> | ||||||||||||||||
Identifier value | The identifier. Must be consistent with the specified scheme. | D | 1 | String | HEADER | <Identifier>Agent123</Identifier> </AdditionalPartyID> |
||||||||||||||||
Party name | The name of the reporting party. | D | 0-1 | String | HEADER | <PartyName>Name of agent</PartyName> | ||||||||||||||||
Address | The address of the party | C | 0-1 | HEADER | <PostalAddress> | |||||||||||||||||
Address line | A line of the address as normally formatted. Repeatable for each line of the address. | D | 1-n | String | HEADER | <AddressLine>1 Main Street</AddressLine> <AddressLine>Bookville</AddressLine> <AddressLine>State</AddressLine> <AddressLine>ZIP</AddressLine> </PostalAddress> |
||||||||||||||||
Communication detail | A communication method and address (number or locator) for the party, other than regular mail. Repeatable for each available method of communication, if any. | C | 0-n | HEADER | <CommunicationDetails> | |||||||||||||||||
Method of communication | Indicates the method of communication to be phone, fax, email or web | D | 1 | Code | HEADER | <CommunicationTypeCode>Phone</CommunicationTypeCode> | ||||||||||||||||
Number / locator | The address number or locator | D | 1 | String | HEADER | <CommunicationLocator>123-456-7890</CommunicationLocator> </CommunicationDetails> |
||||||||||||||||
Contact person | The name and communication details for a contact person for the party. Repeatable if there is more than one contact person. | C | 0-n | HEADER | <ContactPerson> | |||||||||||||||||
Person name | The name of the contact person. | D | 1 | String | HEADER | <PersonName>John Smith</PersonName> | ||||||||||||||||
Communication detail | A communication method and address (number or locator) for the contact person other than regular mail. Repeatable for each available method of communication, if any. | C | 0-n | HEADER | <CommunicationDetails> | |||||||||||||||||
Method of communication | Indicates the method of communication to be phone, fax, email or web | D | 1 | Code | HEADER | <CommunicationTypeCode>Email</CommunicationTypeCode> | ||||||||||||||||
Number / locator | The address number or locator | D | 1 | String | HEADER | <CommunicationLocator>j.smith@selling-agent.com</CommunicationLocator> </CommunicationDetails></ContactPerson></ReportingParty> |
||||||||||||||||
Receiving party | The party to whom this sales report is delivered / directed. | C | 1 | HEADER | <ReceivingParty> | |||||||||||||||||
Source party | A party providing sales data for this report, other than the reporting party. May be repeated when the report covers sales by multiple outlets. | C | 0-n | HEADER | <SellingAgentParty> [see <ReportingParty> and <ReceivingParty> for structure details and content examples] </SellingAgentParty> |
|||||||||||||||||
Main party identifier | A unique identifier for the party. Usually mandatory, unless trading partners agree that a name is sufficient. | C | 0-1 | HEADER | ||||||||||||||||||
Additional party identifier | Any additional identifier for the party that needs to be included. May be repeated if there is more than only additional identifier. | C | 0-n | HEADER | ||||||||||||||||||
Party name | The name of the source party. | D | 0-1 | String | HEADER | |||||||||||||||||
Address | The address of the party | C | 0-1 | HEADER | ||||||||||||||||||
Communication detail | A communication method and address (number or locator) for the party, other than regular mail. Repeatable for each available method of communication, if any. | C | 0-n | HEADER | ||||||||||||||||||
Contact person | The name and communication details for a contact person for the party. Repeatable if there is more than one contact person. | C | 0-n | HEADER | ||||||||||||||||||
Person name | The name of the contact person. | D | 1 | String | HEADER | |||||||||||||||||
Communication detail | A communication method and address (number or locator) for the contact person other than regular mail. Repeatable for each available method of communication, if any. | C | 0-n | HEADER | ||||||||||||||||||
Method of communication | Indicates the method of communication to be phone, fax, email or web | D | 1 | Code | HEADER | |||||||||||||||||
Number / locator | The address number or locator | D | 1 | String | HEADER | |||||||||||||||||
LINE ITEM | Depending upon the sales report type (Header line 14), each line item reports either on an individual transaction or on some aggregation of sales for a specified product at a specified price point, possibly further differentiated by any or all of: format, device type, class of sale and sales territory. | C | 1-n | <ItemDetail> | ||||||||||||||||||
Line item number | A serial number by which this line item may be referred to. | D | 1 | Integer | LINE | <LineNumber>1</LineNumber> | ||||||||||||||||
Product identifier / code | A unique identifier of the product. Mandatory | C | 1 | LINE | <ProductID> | |||||||||||||||||
Identifier scheme | Indicates what identification scheme is used. It is strongly recommended to use GTIN-13 in all cases, but other options include GTIN-14,UPC, SKU and Proprietary. | D | 1 | Code | LINE | <ProductIDType>EAN13</ProductIDType> | ||||||||||||||||
Scheme name | Name or description of a proprietary scheme. Mandatory if the sheme is 'Proprietary'. | D | 0-1 | String | LINE | |||||||||||||||||
Identifier | The identifier. Must be consistent with the specified scheme. | D | 1 | String | LINE | <Identifier>9781234567890</Identifier> </ProductID> |
||||||||||||||||
Alternative product identifier / code | Any other unique identifier of the product that needs to be reported. | C | 0-n | LINE | <ProductID> | |||||||||||||||||
Identifier scheme | Indicates what identification scheme is used. Options include GTIN-13, GTIN-14,UPC, SKU and Proprietary. | D | 1 | Code | LINE | <ProductIDType>Proprietary</ProductIDType> | ||||||||||||||||
Scheme name | Name or description of a proprietary scheme. Mandatory if the sheme is 'Proprietary'. | D | 0-1 | String | LINE | <IDTypeName>Agent's proprietary product ID scheme</IDTypeName> | ||||||||||||||||
Identifier | The identifier. Must be consistent with the specified scheme. | D | 1 | String | LINE | <Identifier>X12345</Identifier> </ProductID> |
||||||||||||||||
Product description | C | 1 | LINE | <ItemDescription> | ||||||||||||||||||
Product title | A title of the product for corroboration of the product identifier. Mandatory. | D | 1 | String | LINE | <Title>Title of product</Title> | ||||||||||||||||
Product author(s) | The author(s) of the product. If not available, indicate by including the string 'No author'. | D | 1 | String | LINE | <Author>A.N. Author</Author> | ||||||||||||||||
Other product description | Any other descriptive information that might be needed to corroborate the identification of the product. Included if required by trading partner agreement. | D | 0-1 | String | LINE | <OtherDetail>Blurb about the product…</OtherDetail> </ItemDescription> |
||||||||||||||||
Name or identifier of publisher | Included if reporting sales for more than one publisher. | C | 0-1 | LINE | <PublisherDetail> <PublisherName> <NameLine>Name of publisher (e.g. within a group)</NameLine> </PublisherName> </PublisherDetail> or <PublisherDetail> <PublisherID> <PublisherIDType>SAN</PublisherIDType> <Identifier>1234567</Identifier> <PublisherID> <PublisherDetail> |
|||||||||||||||||
Imprint | Imprint or brand name. | C | 0-1 | LINE | <ImprintDetail> <ImprintName>Imprint or brand name</ImprintName> </ImprintDetail> |
|||||||||||||||||
Format | A code value indicating the specific format of a product. It is strongly recommended that this be included for all digital products, in which case the appropriate ONIX product form detail code (ONIX code list 175) should be included. If used in reporting sales of physical products, the appropriate ONIX product form code (ONIX code list 150) should be used. When used, the entire quantity in this line item must be in the same format. | D | 0-1 | Code | LINE | <FormatCode>E101</FormatCode> | ||||||||||||||||
Device type | A code value indicating the specific type of device on which a digital product is designed to be readable. Code list to be defined. | D | 0-1 | Code | LINE | <DeviceType>XXX</DeviceType> | ||||||||||||||||
Gross sold quantity (units) | The quantity of product units sold. If the report type is by transaction (see Header line 14), this and other quantities reported must relate to the identified transaction; otherwise they must each be the aggregate quantity of units involved in all transactions during the reporting period for the specified product at the specified price point and meeting the other differentiating criteria for this line item (e.g. format, device type, class of sale, sales territory). Mandatory. | D | 1 | Integer | LINE | <GrossSoldQuantity>100</GrossSoldQuantity> | ||||||||||||||||
Returned / refunded quantity (units) | The quantity of units returned / refunded. | D | 1 | Integer | LINE | <RefundedQuantity>6</RefundedQuantity> | ||||||||||||||||
Net sold quantity (units) | The quantity of units sold, net of returns and refunds. May be negative if during the reporting period there were only returns at the specified price point. Only included if reporting aggregated sales in each line item. | D | 1 | Integer (positive or negative) | LINE | <NetSoldQuantity>94</NetSoldQuantity> | ||||||||||||||||
Non-sale disposal quantity | The quantity of units disposed of other than by sales.The method or type of disposal involved is specified below. May be repeated if more than one disposal type applies to this line item. | D | 0-n | LINE | <NonSaleDisposal> | |||||||||||||||||
Non-sale disposal type | The method or type of disposal in the case of non-sale quantities. Options include 'Review', 'Promotion', or a two-digit code '00' through '99' defined by trading partner agreement. | M | 1 | Code | LINE | <DisposalType>Review</DisposalType> | ||||||||||||||||
Non-sale quantity (units) | The quantity of units disposed of. | M | 1 | Integer | LINE | <DisposalQuantity>1</DisposalQuantity> | ||||||||||||||||
Transaction reference | If reporting individual sales transactions, a document reference or other (e.g. server log) reference specific to this sales transaction | D | 0-1 | String | LINE | <ReferenceCoded> | ||||||||||||||||
Reference type | Fixed value: 'ReportItemReferenceNumber' | D | 1 | Code | LINE | <ReferenceTypeCode>ReportItemReferenceNumber</ReferenceTypeCode> | ||||||||||||||||
Reference value | The transaction reference | D | 1 | String | LINE | <ReferenceNumber>T000012345</ReferenceNumber> | ||||||||||||||||
Reference date or date and time | Date and optionally time when the transaction associated with this line item was made. Mandatory if reporting transaction-level sales information. Format YYYYMMDD or YYYYMMDDTHHMMSS. Date and time are to be interpreted as local to the reporting party. | D | 0-1 | ISO 8601 date or date-time - see descrip-tion |
LINE | <ReferenceDate>20120709</ReferenceDate> or <ReferenceDateTime>20120709T120000</ReferenceDateTime> |
||||||||||||||||
</ReferenceCoded> | ||||||||||||||||||||||
Other line item reference | A reference to some other document that relates to this line item, or to a date and optionally time, or any combination of these. | C | 0-n | LINE | <ReferenceCoded> | |||||||||||||||||
Reference type | Indicates the type of document being referred to. Expected values include: 'SourcePartyReference', 'ReportingPartyReference', 'Proprietary' | D | 1 | Code | LINE | <ReferenceTypeCode>ReportingPartyReference</ReferenceTypeCode> | ||||||||||||||||
Reference type name | Name or description of a proprietary reference type Mandatory if the reference type is 'Proprietary'. | D | 0-1 | String | LINE | <ReferenceTypeName>name of proprietary scheme</ReferenceTypeName> [only included if preceding element has code value 'Proprietary'] |
||||||||||||||||
Reference value | The reference. Must be consistent with the specified reference type. Mandatory unless a reference date or date and time is included. | D | 0-1 | String | LINE | <ReferenceNumber>A0123456789</ReferenceNumber> | ||||||||||||||||
Reference date or date and time | A date or date and time used either as a reference or to supplement a document reference. Only to be used if needing to communicate a reference date/time that is not the transaction date/time (see next element). Format YYYYMMDD or YYYYMMDDTHHMMSS. Date and time are to be interpreted as local to the reporting party. | D | 0-1 | ISO 8601 date or date-time - see descrip-tion |
LINE | <ReferenceDate>20100709</ReferenceDate> or <ReferenceDateTime>20120709T120000</ReferenceDateTime> |
||||||||||||||||
</ReferenceCoded> | ||||||||||||||||||||||
Actual selling price detail (agency terms) | Details of the actual selling price per unit for this transaction or product. Mandatory when reporting sales under agency terms. | C | 0-1 | LINE | <PricingDetail> | |||||||||||||||||
Class of trade / sale | The class of sale for this line item. Options at line item level are: '01' (Agency), '02' (Wholesale), or a two-digit code '20' through '99' defined by trading partner agreement. May be repeated if the line item price detail covers more than one class of sale and doesn't differentiate between them. | D | 0-n | Code | LINE | <ClassOfSaleCode>01</ClassOfSaleCode> | ||||||||||||||||
Price | The basic sale price for the entire quantity of of the product reported sold in this line item, before any discount offered to the consumer by the reseller. | C | 1-n | LINE | <Price> | |||||||||||||||||
Price amount | The price amount in the currency specified. NOTE - This is a numeric value used for calculation purposes and should not include a currency symbol. The currency is indicated in the next element. |
D | 1 | Decimal | LINE | <MonetaryAmount>10.00</MonetaryAmount> | ||||||||||||||||
Currency | The currency of the advertised unit price. | D | 1 | ISO Currency Code | LINE | <CurrencyCode>USD</CurrencyCode | ||||||||||||||||
Price type | The type of unit price reported for this line item. When reporting sales under agency terms, the code value indicates whether the actual selling price excludes (code value 'SoldAtPriceExcludingTax') or includes (code value 'SoldAtPriceIncludingTax') sales tax. When reporting US sales under agency terms, it is strongly recommended that code value 'SoldAtPriceExcludingTax' always be used. | D | 1 | Code | LINE | <PriceQualifierCode>SoldAtPriceExcludingTax</PriceQualifierCode> </Price> |
||||||||||||||||
Price currency conversion rate | The rate of conversion between the price currency and the sales value reporting currency. | D | 0-1 | Decimal | LINE | <CurrencyConversionRate>1.00</CurrencyConversionRate> | ||||||||||||||||
</PricingDetail> | ||||||||||||||||||||||
List price and commission / discount detail (agency terms) | Details of the list price per unit for this transaction or product. Mandatory when reporting sales under agency terms. | C | 0-1 | LINE | <PricingDetail> | |||||||||||||||||
Class of trade / sale | The class of sale for this line item. Options at line item level are: '01' (Agency), '02' (Wholesale), or a two-digit code '20' through '99' defined by trading partner agreement. May be repeated if the line item price detail covers more than one class of sale and doesn't differentiate between them. | D | 0-n | Code | LINE | <ClassOfSaleCode>01</ClassOfSaleCode> | ||||||||||||||||
Price | The unit list price (recommended retail price) before any discount for the entire quantity of of the product reported sold in this line item. | C | 1-n | LINE | <Price> | |||||||||||||||||
Price amount | The price amount in the currency specified. NOTE - This is a numeric value used for calculation purposes and should not include a currency symbol. The currency is indicated in the next element. |
D | 1 | Decimal | LINE | <MonetaryAmount>10.00</MonetaryAmount> | ||||||||||||||||
Currency | The currency of the advertised unit price. | D | 1 | ISO Currency Code | LINE | <CurrencyCode>USD</CurrencyCode | ||||||||||||||||
Price type | The type of unit price reported for this line item. When reporting sales under agency terms, the code value indicates whether the list price excludes (code value 'PublishersRPExcludingTax') or includes (code value 'PublishersRPIncludingTax') sales tax. When reporting US sales, it is strongly recommended that code value 'PUblishersRPExcludingTax' always be used. | D | 1 | Code | LINE | <PriceQualifierCode>PublisherRPExcludingTax</PriceQualifierCode> </Price> |
||||||||||||||||
Commission or discount percentage | A percentage commission or discount applied to the list price in determining the value of sales to the publisher / supplier. When reporting sales under agency terms, the percentage commission charged by the selling agent or sub-agent. The source of the commission charge is the sub-agent specified for this line item, or if none, the agent reporting the sales. | D | 0-1 | Decimal | LINE | <CommissionDiscountPercentage>10</CommissionDiscountPercentage> | ||||||||||||||||
Price currency conversion rate | The rate of conversion between the price currency and the sales value reporting currency. | D | 0-1 | Decimal | LINE | <CurrencyConversionRate>1.00</CurrencyConversionRate> | ||||||||||||||||
</PricingDetail> | ||||||||||||||||||||||
Unit cost (catalog price) detail (wholesale terms) | Details of the cost price per unit to the reseller for this transaction or product. Use this format when reporting sales under wholesale terms. | C | 0-1 | LINE | <PricingDetail> | |||||||||||||||||
Class of trade / sale | The class of sale for this line item. Options at line item level are: '01' (Agency), '02' (Wholesale), or a two-digit code '20' through '99' defined by trading partner agreement. May be repeated if the line item price detail covers more than one class of sale and doesn't differentiate between them. | D | 0-n | Code | LINE | <ClassOfSaleCode>02</ClassOfSaleCode> | ||||||||||||||||
Price | The unit cost price before any wholesale discount for the entire quantity of the product reported sold in this line item. When reporting sales on wholesale terms, only the unit cost price should normally be reported, although the recommended retail price may also be reported. | C | 1-n | LINE | <Price> | |||||||||||||||||
Price amount | The price amount in the currency specified. NOTE - This is a numeric value used for calculation purposes and should not include a currency symbol. The currency is indicated in the next element. |
D | 1 | Decimal | LINE | <MonetaryAmount>10.00</MonetaryAmount> | ||||||||||||||||
Currency | The currency of the advertised unit price. | D | 1 | ISO Currency Code | LINE | <CurrencyCode>USD</CurrencyCode | ||||||||||||||||
Price type | The type of unit price reported for this line item. When reporting sales under agency terms, the code value indicates whether the list price excludes (code value 'PublishersRPExcludingTax') or includes (code value 'PublishersRPIncludingTax') sales tax. When reporting US sales, it is strongly recommended that code value 'PUblishersRPExcludingTax' always be used. | D | 1 | Code | LINE | <PriceQualifierCode>PublisherRPExcludingTax</PriceQualifierCode> </Price> |
||||||||||||||||
Wholesale discount percentage | A percentage discount applied to the catalog price in determining the value of sales to the publisher / supplier. | D | 0-1 | Decimal | LINE | <CommissionDiscountPercentage>10</CommissionDiscountPercentage> | ||||||||||||||||
</PricingDetail> | ||||||||||||||||||||||
Line sales values | C | 1 | LINE | <LineSalesAmounts> | ||||||||||||||||||
Gross sales value | Gross value of sales for this line item, excluding refunds. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | LINE | <GrossSalesAmount>900.00</GrossSalesAmount> | ||||||||||||||||
Return / refund value | Value of returns / refunds for this line item. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | LINE | <RefundedAmount>54.00</RefundedAmount> | ||||||||||||||||
Revenue before fee(s) | The net value of sales before any line item-specific fees are deducted. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | LINE | <NetSalesAmount>846.00</NetSalesAmount> | ||||||||||||||||
Fee(s) charged | A fee charged by the seller, intermediary or third party, to be taken into account in calculating the revenue due to the publisher. Repeatable if there is more than one type of fee. | C | 0-n | LINE | <SellerCharge> | |||||||||||||||||
Charge type | The type of fee being charged. Options include 'Commission', 'Handling', 'Packaging', 'Shipping', 'Printing' or a two-digit code '00' through '99' defined by trading partner agreement. | D | 1 | Code | LINE | <ChargeTypeCode>Commission</ChargeTypeCode> | ||||||||||||||||
Charge source | The party that is the source of the fee. Options include 'SourceParty', 'ReportingParty', 'FulfilmentAgent', or a two-digit code '00' through '99' defined by trading partner agreement. | D | 0-1 | Code | LINE | <ChargeSourceCode>SellingAgentParty</ChargeSourceCode> | ||||||||||||||||
Charge amount | The value of the fee charged. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | LINE | <MonetaryAmount>10.00</MonetaryAmount> | ||||||||||||||||
Charge amount type | Fixed for North American use to 'LineChargeExcludingTax' | D | 1 | Code | LINE | <ChargeQualifierCode>LineChargeExcludingTax</ChargeQualifierCode> </SellerCharge> |
||||||||||||||||
Revenue due | The net amount due. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | LINE | <LineAmountDueToPublisher> <MonetaryAmount>836.00</MonetaryAmount> </LineAmountDueToPublisher> or <LineAmountDueToSupplier> <MonetaryAmount>836.00</MonetaryAmount> </LineAmountDueToSupplier> |
||||||||||||||||
Selling agent/ sub-agent | If reporting on sales from multiple outlets, the name or identifier of the selling agent/sub-agent party that represents the sales outlet for this Line item. | C | 0-1 | LINE | <SellingAgentParty> <PartyName>Name of sales outlet</PartyName> </SellingAgentParty> or <SellingAgentParty> <PartyID> <PartyIDType>Proprietary</PartyIDType> <IDTypeName>Name of ID scheme</IDTypeName> <IDValue>Sales outlet / sub-agent identifier</IDValue> </PartyID> </SellingAgentParty> |
|||||||||||||||||
Sales territory | The sales territory into which the product in this Line item was sold. | D | 1 | ISO 3166-1 two-letter country code or ONIX code list 49 region code | LINE | <TradingZone>US</TradingZone> | ||||||||||||||||
</ItemDetail> | ||||||||||||||||||||||
TRAILER / SUMMARY | Totals of the quantities contained in this report, to enable the report to be checked for data integrity. | C | 1 | <Summary> | ||||||||||||||||||
Total number of line items | D | 1 | Integer | TRAILER | <NumberOfLines>1</NumberOfLines> | |||||||||||||||||
Total gross sale quantity | The sum of all gross sale quantities for all line items | D | 1 | Integer | TRAILER | <NumberOfGrossSalesUnits>100</NumberOfGrossSalesUnits> | ||||||||||||||||
Total returned / refunded sale quantity | The sum of all returned / refunded quantities for all line items | D | 1 | Integer | TRAILER | <NumberOfRefundedUnits>5</NumberOfRefundedUnits> | ||||||||||||||||
Total net sale quantity | The sum of all net sale quantities for all line items | D | 1 | Integer | TRAILER | <NumberOfNetSalesUnits>94</NumberOfNetSalesUnits> | ||||||||||||||||
Total non-sale disposal quantity | The sum of all non-sale disposal quantities for all line items | D | 0-1 | Integer | TRAILER | <NumberOfNonSaleUnits>1</NumberOfNonSaleUnits> | ||||||||||||||||
Total sales values | C | 1 | <TotalSalesAmounts> | |||||||||||||||||||
Total gross sales values | Total gross value of sales for all line items, excluding refunds. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | TRAILER | <TotalGrossSalesAmount>900.00</TotalGrossSalesAmount> | ||||||||||||||||
Total return / refund values | Total value of returns / refunds for all line items. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | TRAILER | <TotalRefundedSalesAmount>54.00</TotalRefundedSalesAmount> | ||||||||||||||||
Total revenues before fees | Total net value of sales for all line items before fees are deducted. The currency must be the same as the reporting currency specified in the Header. | D | 1 | Decimal | TRAILER | <TotalNetSalesAmount>846.00</TotalNetSalesAmount> | ||||||||||||||||
Total fees charged | Total value of the fees charged for all line items. The currency must be the same as the reporting currency specified in the Header. | D | 0-1 | Decimal | TRAILER | <TotalSellerChargeAmount>10.00</TotalSellerChargeAmount> </TotalSalesAmounts> |
||||||||||||||||
Total currency revenue due | The sum of all revenues due to the publisher (or supplier). The currency must be the same as the reporting currency specified in the Header. | C | 1 | Decimal | TRAILER | <TotalDueToPublisher> <MonetaryAmount>836.00</MonetaryAmount> </TotalDueToPublisher> or <TotalDueToSupplier> <MonetaryAmount>836.00</MonetaryAmount> </TotalDueToSupplier> |
||||||||||||||||
</Summary></SalesReport> |
no reviews yet
Please Login to review.