sgrRelRotasCli
Customer route reports.
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. |
| cdroute | integer | No | Route code to be displayed in the report, returned by the sgrListRoutes method. |
| Stretches | boolean | Yes | Display routes/stretches. |
| PtoSupport | boolean | Yes | Display support points. |
| RouteSectionPoint | boolean | Yes | List routes/sections/support points. |
METHOD RETURNS:
If the parameters are correct and Stretches = true, the ReturnDataset property of the sgrData object will display
| Field | Type | Description |
|---|---|---|
| DSNAME | string | Customer name |
| DSROTA | string | Route name |
| VLSEQ | smallint | Section sequence |
| DSNAME | string | Section name |
| DSROD | char(7) | Road code |
For PtoSupport = true, ReturnDataset will display other fields:
| Field | Type | Description |
|---|---|---|
| DSNAME | string | Customer name |
| CDROTA | integer | Route code |
| DSROTA | string | Route name |
| SEQ1 | integer | Section sequence |
| CDTRECTION | integer | Section code |
| DSNOME1 | string | Section name |
| CDSUPPORT | integer | Support point code |
| DSFANTASIA | char(50) | Commercial name of the support point |
| CDCID | integer | City code |
| DSCITY | string | City name |
| DSSIGLAUF | char(2) | State acronym |
| VLDISTTOT | integer | Calculated total distance value |
| CDTIPOAPOIO | integer | Support type code |
| DSTIPOAPOIO | string | Support type name |
| VLSEQ | integer | Section sequence |
When RouteSectionPoint = true, the returned table will show:
| Field | Type | Description |
|---|---|---|
| DSNAME | string | Customer name |
| DSROTA | string | Route name |
| DSNAME1 | string | Section name |
| DSFANTASIA | char(50) | Commercial name of the support point |
| DSTIPOAPOIO | string | Support type name |
| VLSEQ | integer | Section sequence |
| DSCITY | string | City name |
| DSSIGLAUF | char(2) | State abbreviation |