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) |