Skip to main content

sgrRelRotasCli

Customer route reports.

SoapAction

PARAMETERS

FieldTypeReq.Description
keyaccessstringYesKey returned by the sgrLogin method.
cdpasintegerYesPAS code, returned by the sgrListaPASUsuario method
cdclienteintegerYesCustomer code, returned by the sgrListaEmpresasPASUsuario method.
cdrouteintegerNoRoute code to be displayed in the report, returned by the sgrListRoutes method.
StretchesbooleanYesDisplay routes/stretches.
PtoSupportbooleanYesDisplay support points.
RouteSectionPointbooleanYesList routes/sections/support points.

METHOD RETURNS:

If the parameters are correct and Stretches = true, the ReturnDataset property of the sgrData object will display

FieldTypeDescription
DSNAMEstringCustomer name
DSROTAstringRoute name
VLSEQsmallintSection sequence
DSNAMEstringSection name
DSRODchar(7)Road code

For PtoSupport = true, ReturnDataset will display other fields:

FieldTypeDescription
DSNAMEstringCustomer name
CDROTAintegerRoute code
DSROTAstringRoute name
SEQ1integerSection sequence
CDTRECTIONintegerSection code
DSNOME1stringSection name
CDSUPPORTintegerSupport point code
DSFANTASIAchar(50)Commercial name of the support point
CDCIDintegerCity code
DSCITYstringCity name
DSSIGLAUFchar(2)State acronym
VLDISTTOTintegerCalculated total distance value
CDTIPOAPOIOintegerSupport type code
DSTIPOAPOIOstringSupport type name
VLSEQintegerSection sequence

When RouteSectionPoint = true, the returned table will show:

FieldTypeDescription
DSNAMEstringCustomer name
DSROTAstringRoute name
DSNAME1stringSection name
DSFANTASIAchar(50)Commercial name of the support point
DSTIPOAPOIOstringSupport type name
VLSEQintegerSection sequence
DSCITYstringCity name
DSSIGLAUFchar(2)State abbreviation