jagomart
digital resources
picture1_Sales Report In Excel Free Template 32359 | Bisg Sales Report Elements X


 113x       Filetype XLS       File size 0.09 MB       Source: bisg.org


File: Sales Report In Excel Free Template 32359 | Bisg Sales Report Elements X
sheet 1 sales reporting template xml bisg sales report message version 11 published 19 december 2012 instructionswhat follows are final recommendations for best practice sales report elements this version includes ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
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 Karen: 1 = mandatory; single occurrence 0-1 = discretionary; can still only occur once 0-n = discretionary but repeatable 1-n = mandatory but repeatable Cardinality 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>









The words contained in this file might help you see if this file matches what you are looking for:

...Sheet sales reporting template xml bisg report message version published december instructionswhat follows are final recommendations for best practice elements this includes the encoding which is compatible with editeur editx a flat file of these also available on website wwwbisgorg element description composite data karen mandatory single occurrence discretionary can still only occur once n but repeatable cardinality format big picture note start tags shown that below and to right inserted between end containing example colored red detail level c lt salesreport quot gt header number or string by may be referred d salesreportnumber sr date generated optionally time generation yyyymmdd yyyymmddthhmmss interpreted as local party iso datetime see issuedatetime function indicates whether original duplicate test purposes code purposecode type line item details individual transactions aggregates product price point salesreporttypecode byproduct used value must correspond in onix list usually...

no reviews yet
Please Login to review.