Table 17 - Order Item
- This article presents the fields of the ordered item integration layout. To better understand the concept behind ordered items, see our article on Requested Concept.
- To carry out this integration, you must send the information along with Table 16 - Order
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=17 (2) | Yes | 1.0 | |
| 2 | Demander internal #489829 | Integer | No | 1.0 | Field of internal use of Demander Ignore it when importing to ERP When sending to Demander, send empty. |
| 3 | Product Code (codProduto) | Text (30) | Yes | 1.0 | |
| 4 | Order Code (codPedido) | Integer | Yes | 1.0 | |
| 5 | Item Discount Percentage (percentualDesconto) | Decimal | No | 1.0 | |
| 6 | Item Add Percentage (percentualAcrescimo) | Decimal | No | 1.0 | |
| 7 | Total Value Discount Products (valorTotalProdutosComDesconto) | Decimal | Yes | 1.0 | Total Value of Products already with Discount, but without IPI or ICMS ST. (Former field valorTotaltem) |
| 8 | Unit Value without Discount (valorUnitarioSemDesconto) | Decimal | Yes | 1.0 | Unit Value without Discount, is the List Price of the Product |
| 9 | Unit Value with Discount (valorUnitarioComDesconto) | Decimal | No | 1.0 | Unit value already with Discount (But without IPI and ICMS ST) |
| 10 | Quantity of Units (qty) | Decimal | Yes | 1.0 | |
| 11 | Order Identifier (Table 16) (idPedido) | Integer | No | 2.5 | As of version 2.5, the need to register a number range per seller was eliminated. The order code may repeat, for example, there may be two sellers with codPedido 451, so the ERP can handle this during import, idPedido was added, which is the unique order identifier in each Order Item record. |
| 12 | Note (note) | Text | No | 2.6 | Item Observations |
| 13 | Total IPI Value (valorTotalIPI) | Decimal | Yes | 2.13 | Total IPI value calculated for the Order item |
| 14 | Total Value ICMS ST (valorTotal_ICMS_ST) | Decimal | Yes | 2.13 | Total value of ICMS ST calculated for the Order item |
| 15 | Total Value of the Item with Taxes (valorTotalComImpostos) | Decimal | Yes | 2.13 | Total Value of the Item (Total Value Products with Discount[Field7]+IPI[Field13]+ICMS ST[Field14]+Additional Tax[Field31]) |
| 16 | Unit Value with Taxes (valorUnitarioComImpostos) | Decimal | Yes | 2.13 | Value per Unit (Value Total Products with Discount[Campo7]+IPI[Campo13]+ICMS ST[Campo14]) |
| 17 | Prorated Discount Value (valorTotalDescontoRateado) | Decimal | Yes | 2.21 | Discount Value at order level that was prorated for this item |
| 18 | Total Value of Products without Apportionment (valorProdutosSemRateioDesconto) | Decimal | Yes | 2.21 | Total Value of Products (without taxes) before apportionment. Equivalent to valorTotalProdutosComDesconto-valorTotalRateado |
| 19 | Unit Sales Value without Apportionment (valorUnitarioSemRateioDesconto) | Decimal | Yes | 2.21 | Unit Sales Value (without taxes) before Apportionment at Order Level. Equivalent to valorProdutosSemRateioDesconto/qty |
| 20 | QuantityCanceled (qtdeCancelado) | Decimal | No | 2.22 | Send here the quantity of the product that was cancelled, for example, the seller placed an order for 100 units, only had 80 in stock and the remaining 20 were cancelled, so I sent here “20”, and in the Quantity field, continue sending 100. |
| 21 | Invoiced Quantity (qtdeFaturado) | Decimal | No | 2.22 | Send here the quantity of the product that was invoiced, for example, the seller placed an order for 100 units, if 80 units have already been invoiced to date. 100 requested, send 80 in this field. In the Quantity field, continue sending 100. The sum of the canceled quantity and invoiced quantity cannot be greater than the quantity (of the item) |
| 22 | Transferred Flex Value (Credit or Debit) (valorFlexMovimentado) | Decimal | No | 2.22 | Send the credit or debit amount generated by this item in this field. (If you generated a Flex debit, send a negative amount) |
| 23 | Value Products without Discount/Addition to the payment condition (valorTotalProdutosSemPercCondPag) | Decimal | No | 2.24 | Total value of the products, without discount/interest on the payment condition, or any other discount or increase or tax amount. Equivalent to ListaPrecoProduto.valorUnitario o Number of the price option used (see Table 13, field 15). The count starts at 1 (one); If no price is set, we send “0”. To return the order to Demander, you can leave this field empty. |
| 25 | Date and Time of insertion of the item into the order (dataHoraCadastro) | DateTime | No | 2.28 | Informs dataHora that the item was inserted in the Order |
| 26 | Commission Percentage (percComissao) | Decimal | No | 2.35 | Commission Percentage stipulated for this order item. |
| 27 | Commission Amount (valorTotalComissao) | Decimal | No | 2.35 | Total Commission amount for this item. |
| 28 | Quantity per Pack (qtdeEmbalagem) | Decimal | No | 2.47 | Informs the quantity per package that the product had at the time of sale. |
| 29 | Used the discount table (usouTabelaDesconto) | Boolean | No | 3.0 | Whether the order item used the order discount table |
| 30 | Price list unit value (valorUnitarioListaPreco) | Decimal | No | 3.1 | |
| 31 | Additional fee amount (valorTaxaAdicional) | Decimal | No | 3.3 | Amount of the additional fee as shown in table 42 – Taxation configuration |
| 32 | Amount to be deducted from the commission calculation base (valorAbaterBCComissao) | Decimal | No | 3.4 | Value of linked order items that will decrease from the seller’s commission calculation base. |
| 33 | Commission percentage excluding bonuses (percComissaoBonificada) | Decimal | No | 3.5 | This field is related to the functionality of deducting the commission from the main order and bonus requests, it is calculated at the time of exporting the Demander web to the ERP, there is no physical field in the Demander to record this information, but even so, it has to be sent in the order integration, tip: if you don’t use the functionality in question, send this field empty. |
| 34 | Gross Weight (pesoBruto) | Double | No | 3.10 | Total gross weight of the item |
| 35 | Net Weight (pesoLiquido) | Double | No | 3.10 | Total net weight of the item |
| 36 | Cubage (cubbing) | Double | No | 3.10 | Total cubing of the item |
| 37 | Shipping Value (valorFrete) | Double | No | 3.14 | In this field the “Order Shipping Value” is apportioned.. NOTE: A rule of 3 is used based on the “Total Value of the Order Item”. |
| 38 | Suggested Shipping (freteSugerido) | Double | No | 3.38 | |
| 39 | Contribution margin percentage (percMargemContribuicao) | Decimal | No | 3.38 | |
| 40 | Replacement cost of sale (custoReposicaoNaVenda) | Decimal | No | 3.38 | Pass the total cost of the item in question, example: if the cost of the merchandise is R$10.00 and 3 units were sold, the cost to be passed in this field is R$30.00 |
| 41 | Unit sales value without discount on discount (valorUnitarioSemDescontoSobreDesconto) | Decimal | No | 3.56 | |
| 42 | Percentage discount entered (percDescontoDigitado) | Decimal | No | 3.56 | |
| 43 | Demander Internal #118512 (jsonDescontosAcrescimos) | Text | No | 4.37 | When returning to Demander, send it empty. See here the structureof the json sent in this field. |
| 44 | Total value of Own ICMS (valorTotalICMSProprio) | Decimal | No | 4.46 | Total Value of Own ICMS of the item |
| 45 | IPI Rate (aliquotaIPI) | Decimal | No | 4.49 | |
| 46 | ICMS Rate (aliquotaICMS) | Decimal | No | 4.49 | |
| 47 | ICMS ST Rate (aliquotaIcmsST) | Decimal | No | 4.49 | |
| 48 | Redispatch Unit Value (valorUnitarioRedespacho) | Decimal (15.2) | No | 4.49 |
Registration Example:
17||11002|00026120|0|0|44.03|6.29|6.29|7|||2.21|0|46.24|6.605714 28571429|0|44.03|6.29|0.00|7|0||||0|0|0|0|0|0|0|0|1.05|0.63|||||