sgrListaAEporData
Returns a list of Shipment Authorizations by date.
PARAMETERS
| Field | Type | Req.? | Description |
|---|---|---|---|
| accesskey | string | Yes | Key returned by the sgrLogin method. |
| cdpas | integer | Yes | PAS code, returned by the sgrListaPASUsuario method |
| cdcliente | integer | Yes | Client code, returned by the sgrListaEmpresasPASUsuario method. |
| initialdata | datetime | Yes | Start date for the search. |
| finaldata | datetime | Yes | End date for the search. |
| type | integer | Yes | Enter 1 for the expected date, and 2 for the actual date. |
| plate | string | No | Vehicle plate number. |
| cdDest | integer | No | Recipient code, returned by the sgrListaDestinatarios method. |
METHOD RETURN:
ReturnDataset: If the parameters are valid, the dataset will display:
| Field | Type | Description |
|---|---|---|
| CDVIAG | integer | Boarding authorization number |
| NRPLACACAVALO | char(7) | Horse license plate |
| NRPLACACARRETA | char(7) | Trailer license plate |
| DESTINATARIO | string | Recipient |
| DTPREVINI | datetime | Trip start date |
| DTPREVFIM | datetime | Trip end date |
| DTINI | datetime | Trip start date |
| DTFIM | datetime | Trip end date |
| DSCIDORIGEM | string | Name of the city of origin |
| ESTADOORI | char(2) | State of origin (acronym) |
| DSCIDDESTINO | string | Name of the city of destination |
| ESTADODES | char(2) | Destination state (acronym) |
| NRCONTROLECARGA | string | Field for free use by the customer (20 characters). |
| FLSITUACAO | smallint | Trip status (code) |
| SITUACAO | string | Trip status description |
| NRCPFMOT1 | char(11) | Driver's CPF |
| MOTORISTA1 | string | Driver's name |
| CDOPEMISSOR | integer | AE issuing user code |
| OPEMISSOR | char(10) | AE issuing user |
ReturnDescription: If there is an error executing the method, the property will display:
| Error | Description |
|---|---|
| Invalid type! | Must be '1' to list by estimated start date or '2' for actual start date. |
| There are no Authorizations for the period entered! |