DBF Integration Layout - Order
- This article presents the fields of the Order Items integration layout. To better understand the concept behind order items, see our article on Order Concept.
| Order | Field Description | Format and Size | Required | Version | Note | |
| 1 | Document Number Order(code) | Integer (11) | Yes | 4.58 | Same as Order Number. | |
| 2 | Payment Method Code(codForPag) | Text (20) | No | 4.58 | ||
| 3 | Payment Condition Code (codConPag) | Text (20) | No | 4.58 | ||
| 4 | Order Status Code (codStatus) | Integer (11) | No | 4.58 | Send status code. | |
| 5 | Branch Code (codFilial) | Integer (11) | No | 4.58 | ||
| 6 | Customer Code (codClient) | Integer (11) | Yes | 4.58 | New customers come with code “0”. | |
| 7 | Customer’s CPF/CNPJ (cpfCNPJCl) | Text (18) | Yes | 4.58 | With mask. EX:01.010.101/0001-72 | |
| 8 | Price List Code (codLisPre) | Text (20) | Yes | 4.58 | ||
| 9 | Seller Code (codVen) | Integer (11) | Yes | 4.58 | ||
| 10 | Code of the Issuing Seller (codVenEmi) | Integer (11) | Yes | 4.58 | Note: In this field the code of the seller who issued the order is exported, this field will be different from the codVendedor field in the following situation: The Sales Manager issues an order to a customer linked to a seller, codVendedorEmissor will be the sales manager, and codVendedor will be the seller code linked to the customer. | |
| 11 | Purchase Order Number (nOrdCompr) | Text (50) | No | 4.58 | ||
| 12 | Issuance Date (dataEmis) | Date | Yes | 4.58 | ||
| 13 | Emission Time (horaEmis) | Text (6) | Yes | 4.58 | ||
| 16 | Quantity of Items (qtdeItens) | Decimal (11.2) | No | 4.58 | ||
| 17 | Value of Products with Additional Discount (vPrCDeAcr) | Decimal (11.2) | No | 4.58 | Sales Value of Products, already with the value of Increase or Discount Granted (Former field valorTotal) /> | Value of the Products, without the value of the increase or Discount granted. Old field valorBruto. |
| 19 | Shipping Value (vFrete) | Decimal (11.2) | Yes | 4.58 | ||
| 20 | Total Order Value (vTotalPed) | Decimal (11.2) | Yes | 4.58 | Total Order Value (Product Value+Value Shipping+IPI+ICMS ST+Interest/Discount by Payment Method). | |
| 21 | IPI Value (vIPI) | Decimal (11.2) | Yes | 4.58 | Total IPI Value (Sum of IPI for each Item) | |
| 22 | ICMS ST Value (vICMS_ST) | Decimal (11.2) | Yes | 4.58 | Total Value of ICMS ST (Sum of Value dand ICMS ST) | |
| 23 | Total Commission Amount (vTotComis) | Decimal (11.2) | No | 4.58 | Total order commission amount calculated by Demander. | |
| 24 | Highlighted Discount (descDest) | Decimal (11.2) | No | 4.58 | ||
| 25 | Total Redispatch Value (vTotRedes) | Decimal (11.2) | No | 4.58 | ||
| 26 | Total Additional Fee (tTaxaAdic) | Decimal (11.2) | No | 4.58 | Total amount of the additional fee that will be charged; This value must be equal to the sum of field 31 of the order items. | |
| 27 | Gross Weight Ordered (pesoBruto) | Decimal (11.2) | No | 4.58 | Gross weight total order | |
| 28 | Net Order Weight (pesoLiqui) | Decimal (11.2) | No | 4.58 | Total Net Order Weight | |
| 29 | Cubbing (cubbing) | Decimal (11.2) | No | 4.58 | Total cubing of the order | |
| 30 | Margin Percentage Contribution (prMarCont) | Decimal (11.2) | No | 4.58 | ||
| 31 | Replacement Cost at Sale (cusRepVen) | Decimal (11.2) | No | 4.58 | ||
| 32 | Carrier Code (cTranspor) | Text (15) | No | 4.58 | Transporter code, records in Table 29 | |
| 33 | Redispatch code (cRedespac) | Text (15) | No | 4.58 | Redispatch carrier code, records in Table 29 | |
| 34 | Segment Code (cSegmento) | Integer (11) | No | 4.58 | Segment code used in the order. | |
| 35 | Discount Type Code (cTipoDesc) | Text (50) | No | 4.58 | Field referring to the discount type code used in the order. Type of discount is sent in Table 130 – Type of Discount | |
| 36 | Order Type Code (cTipoPedi) | Integer (11) | Yes | 4.58 | Code of records registered for the company in the ‘Order Types’ register. | |
| 37 | Delivery Estimate (prevEntre) | Date | No | 4.58 | ||
| 38 | Shipping Type (tipoFrete) | Integer (2) | No | 4.58 | Shipping Type Code. | |
| 39 | Originating Order Number (nPedOrig) | Integer (11) | No | 4.58 | If an order is linked to another, this field serves to identify the main order that gave rise to it. | |
| 40 | Customer Observation (obsCliente) | Text (254) | Yes | 4.58 | Whatever is entered in this field appears in the Order PDF Issue that is sent to the Customer. | |
| 41 | Observation (obs) | Text (254) | No | 4.58 |
Registration Example: