sgrRelColetaseEntregas
Collection and delivery 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. |
| dtinicio | datetime | Yes | Start date for the search. |
| dtfim | datetime | Yes | End date for the search. |
| license plate | string | No | License plate (7 characters). |
| type | string | No | Type of report selected. Filter by the pickups and deliveries made in the period ('R') or those planned ('P') |
METHOD RETURN:
If the parameters are filled in correctly, the ReturnDataset property will display
| Field | Type | Description |
|---|---|---|
| CDDOC | integer | Document code |
| CDVIAG | integer | Shipment authorization number |
| NRPLACACAVALO | char(7) | Horse license plate |
| DSNAME | string | Recipient company name |
| TYPE OF OPERATION | string | Type of operation (Transfer, Collection, Delivery or Collection/Delivery) |
| DTREALIZED | datetime | Date performed |
| DTCHEGADACLI | datetime | Customer arrival date |
| DTSAIDACLI | datetime | Departure date at client |
| PREVCHEGADACLI | datetime | Expected date of arrival at customer |
| PREVSAIDACLI | datetime | Expected date of departure at client |