Skip to main content

sgrRetornaReservasCliente

Returns the customer's bookings for a given period.

SoapAction

PARAMETERS

FieldTypeRequired?Description
dtStartdatetimeYesstart date for the search.
dtEnddatetimeYesend date for the search.
cdCliintegerYesCustomer code, returned by the sgrListaEmpresasUsuario method.
keyaccessstringYesKey returned by the sgrLogin method.

METHOD RETURN:

ReturnDataset: If the parameters are correct, the property will display:

FieldTypeDescription
CDVIAGintegerShipment authorization number
CDMONITintegerMonitoring code
NRPLACAchar(8)Vehicle license plate number
TRAILER1char(8)TRAILER1 license plate number
TRUCK2char(8)TRUCK2 license plate number
NRCPFMOTstringdriver's CPF
DSMOTstringDriver's name
FLSITUATIONsmallintTrip status
DSFLSITUATIONstringSituation
CDTRANSPintegerCarrier code
DSNAMEstringCarrier name
DSOBSOPERATIONstringRemarks on the operation
CDCIDORIGintegerOrigin city code
DSNOMECIDORIGstringName of city of origin
CDCIDDESTintegerDestination city code
DSNOMECIDDESTstringDestination city name
NRCONTROLEPROGRAMMING1stringField for free use by the client
NRCONTROLEPROGRAMACAO2stringField for free use by the client
NRCONTROLEPROGRAMACAO3stringField for customer's free use
NRCONTROLEPROGRAMMING4stringField for customer's free use
NRCONTROLEPROGRAMMING5stringField for customer's free use
NRCONTROLEPROGRAMMING6stringField for free use by client
DTINCLdatetimeReservation inclusion date
VEHICLE CHARACTERISTICSstringVehicle characteristics
DSALVOstringTarget name
DSNOMEDESTINATIOstringRecipient's name
DTPREVORIGstringExpected date and time of departure
DTPREVCHEGADAstringEstimated date and time of arrival
DTULTPOSstringDate and time of last position
PROGRAMMERINCLUSIONstringUser who made the reservation

ReturnDescription: If there is an error when executing the method, the property will display:

ErrorDescription
Period entered longer than 60 daysYou 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.