sgrRelRelacaoAutorizacaoEmbarqueV2
Shipment authorization 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. |
| nrAE | integer | No | Shipment authorization number. |
| cdCityOrigin | integer | No | Origin city code, returned by the sgrListCities method. |
| cdDestinationCity | integer | No | Destination city code, returned by the sgrListCities method. |
| cdMot1 | integer | No | Driver code, returned by the sgrConsultaPF method |
| cdCavalo | integer | No | Vehicle code, returned by the sgrConsultaVeic. method |
| cdCarreta1 | integer | No | Cart code, returned by the sgrConsultaVeic. method |
| cdCarreta2 | integer | No | Truck code, returned by the sgrConsultaVeic. |
| flAndamento | Boolean | No | Filter by shipments in progress. |
| flAwaitingIni | Boolean | No | Filter by shipments that are waiting to start. |
| flCompleted | Boolean | No | Filter by completed shipments. |
| flCanceled | Boolean | No | Filter by canceled shipments. |
| dtPrevStart | datetime | No | Start date for the search. |
| dtPrevEnd | datetime | No | End date for the search. |
| flVinicculo | string | No | Employee's relationship with the company. Send 'f' or 'F' for employee, 'a' or 'A' for aggregate, or 't' or 'T' for outsourced. |
METHOD RETURN:
ReturnDataset: If the parameters are filled in correctly, the property will display:
| Field | Type | Description |
|---|---|---|
| CUSTOMER | string | Customer name |
| DSCIDORIGDEST | string | Origin and destination cities |
| DRIVER | string | Driver's name and social security number |
| NRAE | integer | Shipment authorization number |
| NRPLACACAVALO | char(8) | Horse license plate |
| NRPLACACARRETA | char(8) | License plate of trailer |
| NRPLACACARRETA2 | char(8) | trailer plate 2 |
| SITUATION | string | Trip status (Waiting, In Progress, Completed or Canceled) |
| FLVINCULO | string | Employee link ((FUNC), (AGR) or (TERC)) |
| CDOPEMISSOR | integer | Trip issuer code |
| OPEMISSOR | char(10) | Trip issuer login |
| DTPREVINIDB | datetime | Estimated start date (sort filter) |
| DTPREVFIMDB | datetime | Expected end date (sort filter) |
| DTINIDB | datetime | Actual start date (sort filter) |
| DTFIMDB | datetime | Actual end date (sort filter) |
| DTPREVINI | string | Estimated start date and time |
| DTPREVFIM | string | Estimated end date and time |
| DTINI | string | Actual start date and time |
| DTFIM | string | Actual end date and time |
| CDTRANSP | integer | Carrier code |
| DSTRANSPORTORA | string | Carrier name |