Table 14 - Visit without sales
- This article presents the fields of the non-sales visit integration layout. To better understand the concept behind non-sale visits, see our article on No-sale Visit Concept.
| Order | Field Description | Format and Size | Required | Version | Note |
| 1 | Table Identifier (IDENTIFICADOR) | FIXO=14 (2) | Yes | 1.0 | |
| 2 | Visit Code without Sale (code) | Integer (10) | Yes | 1.0 | Unique identifier of the visit without sales on Demander. |
| 3 | Customer Code (codCliente) | Text (20) | Yes | 1.0 | |
| 4 | Reason Code (codMotivo) | Integer (10) | Yes | 1.0 | |
| 5 | Seller Code (codVendedor) | Integer (10) | Yes | 1.0 | |
| 6 | Date and Time (dataHora) | DateTime | No | 1.0 | |
| 7 | Notes from Visit without Sale (observation) | Text (2000) | No | 1.0 | |
| 8 | Latitude (latitude) | Text (50) | No | 2.28 | |
| 9 | Longitude (longitude) | Text (50) | No | 2.28 | |
| 10 | Capture information GPS (provider) | Text (50) | No | 2.28 | |
| 11 | UniqueID Customer (uniqueIdCliente) | Text (50) | No | 3.4 | |
| 12 | Performed (performed) | Integer (1) | No | 3.4 | |
| 13 | Location Accuracy (precisaoGPS) | Decimal | No | 2.44 | Accuracy of captured position in meters |
| 14 | Customer’s CPF or CNPJ (cpfCnpjCliente) | Text (18) | No | 3.4 |