Table 170 - Order Note (Detailed billing)
- This article introduces the billing integration layout fields.
- To carry out this integration, you must send the information together with:
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=170 (3) | Yes | 3.14 | |
| 2 | Customer code (codCliente) | Integer (10) | Yes | 3.14 | |
| 3 | Price List Code (codListaPreco) | Text (20) | No | 3.14 | |
| 4 | Branch Code (codFilial) | Text (15) | No | 3.14 | |
| 5 | Order Code (codPedido) | Text (20) | Yes | 3.14 | |
| 6 | Payment Condition Code (codCondicaoPagamento) | Text (20) | No | 3.14 | |
| 7 | Carrier Code (codTransportadora) | Text (20) | No | 3.14 | |
| 8 | Status Code (codStatus) | Text (20) | Yes | 3.14 | |
| 9 | ERP Order Number (numPedidoERP) | Text (20) | Yes | 3.14 | |
| 10 | Order Purchase Order (orderDeCompra) | Text (50) | No | 3.14 | |
| 11 | NF Date (dataNF) | DateTime | Yes | 3.14 | |
| 12 | NF Number (numeroNF) | Text (20) | Yes | 3.14 | |
| 13 | NF Value (valorNF) | Decimal (15.2) | Yes | 3.14 | |
| 14 | Quantity of Order Items (qtdeItens) | Decimal | No | 3.14 | |
| 15 | Invoiced Quantity (qtdeFaturado) | Decimal | No | 3.14 | |
| 16 | Quantity Canceled (qtdeCancelado) | Decimal | No | 3.14 | |
| 17 | Seller’s commission (commission) | Decimal (15.2) | No | 3.14 | |
| 18 | Issuance date (dataEmissao) | DateTime | No | 3.14 | |
| 19 | Balance (balance) | Decimal | No | 3.58 | |
| 20 | Seller Code (codVendedor) | Integer (10) | No | 3.58 | |
| 21 | Address (address) | Text (255) | No | 3.58 |
Registration Example:
170|120|1|1|87900|3|1|1|78888900||2020-06-01|233342|30|28|2|29.00||2020-05-28|