sgrRelDesempenhoViagem
Trip performance 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. |
| dtinicio | datetime | Yes | Start date for the search. |
| dtfim | datetime | Yes | End date for the search. |
| cdtravel | integer | No | Boarding authorization number. |
| cdtransp | integer | No | Carrier company code. This code is returned by the sgrListaTransportadoras method. |
| nrplaca | string | No | Vehicle license plate (7 characters). |
METHOD RETURN:
If the parameters are filled in correctly, the ReturnDataset property will display:
| Field | Type | Description |
|---|---|---|
| DTREFINI | datetime | Start date |
| DTREFFIM | datetime | End date |
| CDVIAG | integer | Shipment authorization number |
| CDTRANSP | integer | Carrier code |
| CARRIER | string | Company name |
| CIDADEORIG | integer | City of origin |
| CIDADEDEST | integer | Destination city |
| CDPFJ | integer | Company code |
| DSNAME | string | Customer name |
| DTPREVINI | datetime | Estimated start date |
| DTPREVFIM | datetime | Estimated end date |
| DTINICIO | datetime | Start date |
| DTFIM | datetime | End date |
| DTPREVISTA | datetime | Estimated delivery date |
| HRINIWINDOW | datetime | Window start time |
| HRFIMWINDOW | datetime | Window end time |
| DT ARRIVAL | datetime | Arrival date |
| DT_UNLOAD | datetime | Unload start date |
| DT_ENDDISCHARGE | datetime | Discharge end date |
| DISCHARGE TIME | integer | Discharge time (days) |
| DTSAIDACLI | datetime | Exit date |
| NRPLACACAVALO | char(7) | Horse license plate. |
| MOTORIST | string | Driver's name |
| HR ARRIVAL | string | Arrival time |
| CIDDESTINATIO | integer | Destination city code |
| VLQTDEVOL | integer | Number of packages |
| VLQTDEPECAS | integer | Number of pieces |
| OUT OF WINDOW | integer | Indicates whether the arrival was made outside the window (1-YES, 0-NO) |