sgrRetornaReservasCliente
Returns the customer's bookings for a given period.
PARAMETERS
Field | Type | Required? | Description |
---|---|---|---|
dtStart | datetime | Yes | start date for the search. |
dtEnd | datetime | Yes | end date for the search. |
cdCli | integer | Yes | Customer code, returned by the sgrListaEmpresasUsuario method. |
keyaccess | string | Yes | Key returned by the sgrLogin method. |
METHOD RETURN:
ReturnDataset: If the parameters are correct, the property will display:
Field | Type | Description |
---|---|---|
CDVIAG | integer | Shipment authorization number |
CDMONIT | integer | Monitoring code |
NRPLACA | char(8) | Vehicle license plate number |
TRAILER1 | char(8) | TRAILER1 license plate number |
TRUCK2 | char(8) | TRUCK2 license plate number |
NRCPFMOT | string | driver's CPF |
DSMOT | string | Driver's name |
FLSITUATION | smallint | Trip status |
DSFLSITUATION | string | Situation |
CDTRANSP | integer | Carrier code |
DSNAME | string | Carrier name |
DSOBSOPERATION | string | Remarks on the operation |
CDCIDORIG | integer | Origin city code |
DSNOMECIDORIG | string | Name of city of origin |
CDCIDDEST | integer | Destination city code |
DSNOMECIDDEST | string | Destination city name |
NRCONTROLEPROGRAMMING1 | string | Field for free use by the client |
NRCONTROLEPROGRAMACAO2 | string | Field for free use by the client |
NRCONTROLEPROGRAMACAO3 | string | Field for customer's free use |
NRCONTROLEPROGRAMMING4 | string | Field for customer's free use |
NRCONTROLEPROGRAMMING5 | string | Field for customer's free use |
NRCONTROLEPROGRAMMING6 | string | Field for free use by client |
DTINCL | datetime | Reservation inclusion date |
VEHICLE CHARACTERISTICS | string | Vehicle characteristics |
DSALVO | string | Target name |
DSNOMEDESTINATIO | string | Recipient's name |
DTPREVORIG | string | Expected date and time of departure |
DTPREVCHEGADA | string | Estimated date and time of arrival |
DTULTPOS | string | Date and time of last position |
PROGRAMMERINCLUSION | string | User who made the reservation |
ReturnDescription: If there is an error when executing the method, the property will display:
Error | Description |
---|---|
Period entered longer than 60 days | You need to decrease the interval between dates, and try again. |
There was an error searching for positions. | This error may be caused by an incorrect parameter, the field to be corrected will be indicated in the returnDataset property. This means you need to check the parameters and run the method again. It may also indicate a timeout or a dropped connection to the database. It is necessary to pass on the data entered, as well as the name of the method, the issue time and the customer code to the following e-mail address: [email protected] so that the error can be validated. |