ShipmentTransactionRequests
ShipmentTransactionRequests
Columns
Name | Type | Description |
TransactionId [KEY] | Long | TransactionId of ShipmentTransactionRequests |
ActionCode | String | Value that uniquely identifies the action to be run for this transaction request. Valid values are CreateAndConfirmShipment, ShipmentCreate, and ShipmentUpdate. |
TransactionStatusCode | String | TransactionStatusCode of ShipmentTransactionRequests |
TransactionStatus | String | TransactionStatus of ShipmentTransactionRequests |
CreatedBy | String | CreatedBy of ShipmentTransactionRequests |
CreationDate | Datetime | CreationDate of ShipmentTransactionRequests |
LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequests |
LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequests |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Carrier | String | Carrier |
ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
FromActualShipDate | Datetime | FromActualShipDate |
FromInitialShipDate | Datetime | FromInitialShipDate |
Item | String | Item |
ModeOfTransportCode | String | ModeOfTransportCode |
Order | String | Order |
PackingUnit | String | PackingUnit |
ServiceLevelCode | String | ServiceLevelCode |
ShipFromOrganizationCode | String | ShipFromOrganizationCode |
Shipment | String | Shipment |
ShipmentLine | Long | ShipmentLine |
SoldToCustomer | String | SoldToCustomer |
ToActualShipDate | Datetime | ToActualShipDate |
ToInitialShipDate | Datetime | ToInitialShipDate |
Finder | String | finder |