sgrRelColetaEntregaDistanciaPercorrida
Delivery/Distance Traveled Report.
PARAMETERS
| Field | Type | Req. | Description |
|---|---|---|---|
| keyaccess | string | Yes | Key returned by the sgrLogin method. |
| cdpas | integer | Yes | PAS code, returned by the sgrListaPASUsuario method |
| cdcliente | integer | Yes | Customer code, returned by the sgrListaEmpresasPASUsuario method. |
| dstart | datetime | Yes | Start date for the search. |
| dtfinal | datetime | Yes | End date for the search. |
| cdtransp | integer | No | Transport company code. This code is returned by the sgrListaTransportadoras method. |
| cdpaisorigemveic | string | No | Parameter not used. Always send 0. |
| nrplate | string | No | Vehicle plate (7 characters). |
| visStores | Integer | No | Display stores. Always send 0. |
| nrfrota | string | No | Vehicle fleet number. |
METHOD RETURN:
If the parameters are filled in correctly, the ReturnDataset property will display:
| Field | Type | Description |
|---|---|---|
| DATAINITIAL | string | Initial date (filter) |
| DATAFINAL | string | End date (filter) |
| DTFIM | datetime | End date |
| CDTRANSP | integer | Carrier code |
| CARRIER | string | Carrier name |
| NOMELOJA | string | Store name |
| NRFLEET | char(7) | Fleet number |
| CDVIAG | integer | Shipment authorization number |
| NRPLACACAVALO | char(7) | Horse license plate |
| NRPLACACARRETA | char(7) | Trailer plate 1 |
| NRPLACACARRETA2 | char(7) | Trailer plate 2 |
| VLDISTPREV | float | Estimated distance |
| VLDISTREAL | decimal | Actual distance |
| DTPREVISTA | datetime | Estimated end date |