sgrRelColetaEntregaListaEntregas
Delivery 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. |
| cdpaisorigemveic | string | No | Vehicle licensing country code. This code is returned by the sgrListCountries method. |
| nrplaca | string | No | Vehicle license plate (7 characters). |
| typorelatorio | string | No | Type of report selected. Filter by the pickups and deliveries made in the period ('R') or by those planned ('P'). |
| cddest | integer | No | Recipient code, returned by the sgrListaDestinatarios method. |
| nrfrota | string | No | Vehicle fleet number. |
METHOD RETURN:
If the parameters are filled in correctly, the ReturnDataset property will display:
| Field | Type | Description |
|---|---|---|
| CDTRANSP | integer | Carrier code |
| CARRIER | string | Carrier name |
| NRFLEET | char(7) | Fleet number |
| NRSEQ | integer | Delivery sequence |
| DTINITI | datetime | Start date (filter) |
| DTFIM | datetime | End date (filter) |
| CDVIAG | integer | Shipment authorization number |
| NRDOC | string | Document number |
| FLTPDOC | smallint | Document type code |
| DSDOCUMENT | string | Document type |
| NRPLACACAVALO | char(7) | Horse license plate |
| NRPLACACARRETA | char(7) | Trailer license plate 1 |
| NRPLACACARRETA2 | char(7) | Trailer plate 2 |
| VLVALUE | Money | Document value |
| FLSITUATION | smallint | Document status |
| DSSITUATION | string | Document situation (Description |
| FLTPOPER | smallint | Type of operation |
| DSTPOPER | string | Transaction type description |
| DTPREVISTA | datetime | Estimated delivery date |
| DTREALIZED | datetime | Realized delivery date |
| DSRUA | string | Delivery address |
| NRRUA | char(6) | Delivery address number |
| DSBAIRRO | string | Delivery neighborhood |
| NRCEP | char(8) | delivery zip code |
| DSNAME | string | Recipient's name |
| VLQTDEVOL | integer | Amount of cargo volume |
| VLQTDEPECAS | integer | Number of pieces of cargo |