sgrRelColetaEntregaAlertasTemperatura
Temperature Alerts 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. |
METHOD RETURN:
ReturnDataset: If the parameters are filled in correctly, the dataset will display:
| Field | Type | Description |
|---|---|---|
| CDVIAG | integer | Shipment authorization number |
| CDTRANSP | integer | Carrier code |
| CARRIER | string | Carrier name |
| NRPLACACAVALO | char(7) | Horse license plate |
| NRFLEET | char(7) | Fleet number |
| CDVEIC | integer | Vehicle code |
| DTINITIAL | datetime | Initial date (filter) |
| DTFINAL | datetime | End date (filter) |
| DTINI | datetime | Trip start date |
| DTFIM | datetime | End date of trip |
| MINTrip | integer | Trip time (in minutes) |
| CDTPSENSTEMP1 | integer | Sensor type code 1 |
| TIPOSEN1 | string | Name of sensor type 1 |
| CDTPSENSTEMP2 | integer | Sensor type code 2 |
| TIPOSEN2 | string | Name of sensor type 2 |
| CDTPSENSTEMP3 | integer | Sensor type code 3 |
| TIPOSEN3 | string | Sensor type name 3 |
| CDTPSENSTEMP4 | integer | Sensor type code 4 |
| TIPOSEN4 | string | Sensor type name 4 |
| CDTPSENSTEMP5 | integer | Sensor type code 5 |
| TIPOSEN5 | string | Sensor type name 5 |
| MINACIMA1 | decimal(15,2) | Upper tolerance (sensor 1) |
| MINIDEAL1 | decimal(15,2) | Optimum temperature value (sensor 1) |
| MINLOW1 | decimal(15,2) | Lower tolerance (sensor 1) |
| MINIMA2 | decimal(15,2) | Upper tolerance (sensor 2) |
| MINIDEAL2 | decimal(15,2) | Optimum temperature value (sensor 2) |
| MINLOW2 | decimal(15,2) | Lower tolerance (sensor 2) |
| MINACIMA3 | decimal(15,2) | Upper tolerance (sensor 3) |
| MINIDEAL3 | decimal(15,2) | Optimum temperature value (sensor 3) |
| MINLOW3 | decimal(15,2) | Lower tolerance (sensor 3) |
| MINACIMA4 | decimal(15,2) | Upper tolerance (sensor 4) |
| MINIDEAL4 | decimal(15,2) | Optimum temperature value (sensor 4) |
| MINLOW4 | decimal(15,2) | Lower tolerance (sensor 4) |
| MINACIMA5 | decimal(15,2) | Upper tolerance (sensor 5) |
| MINIDEAL5 | decimal(15,2) | Optimum temperature value (sensor 5) |
| MINLOW5 | decimal(15,2) | Lower tolerance (sensor 5) |
| MINIMUM | decimal(15,2) | Upper tolerance (average) |
| MINIDEAL | decimal(15,2) | Optimum temperature value (average) |
| MINOWER | decimal(15,2) | Lower tolerance (average) |