ShipmentLineTransactionRequestsshipmentLinesholds
ShipmentLineTransactionRequestsshipmentLinesholds
Columns
Name | Type | Description |
ShipmentLineTransactionRequestsTransactionId [KEY] | Long | ShipmentLineTransactionRequestsTransactionId of ShipmentLineTransactionRequestsshipmentLinesholds |
ShipmentlinesDeliveryDetailInterfaceId [KEY] | Long | ShipmentlinesDeliveryDetailInterfaceId of ShipmentLineTransactionRequestsshipmentLinesholds |
HoldActionCode | String | Abbreviation that identifies the action code for the hold. |
HoldId | Long | Value that uniquely identifies the hold type. |
HoldReasonCode | String | Value that uniquely identifies the action to be run for this hold request. Valid vales are APPLY_HOLD and RELEASE_HOLD. |
HoldReason | String | Description of the reason for the hold. |
CreatedBy | String | CreatedBy of ShipmentLineTransactionRequestsshipmentLinesholds |
CreationDate | Datetime | CreationDate of ShipmentLineTransactionRequestsshipmentLinesholds |
LastUpdatedBy | String | LastUpdatedBy of ShipmentLineTransactionRequestsshipmentLinesholds |
LastUpdateDate | Datetime | LastUpdateDate of ShipmentLineTransactionRequestsshipmentLinesholds |
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 |
BaseItem | String | BaseItem |
BaseItemId | Long | BaseItemId |
Carrier | String | Carrier |
CarrierId | Long | CarrierId |
CarrierNumber | String | CarrierNumber |
EndAssemblyItem | String | EndAssemblyItem |
FromRequestedDate | Datetime | FromRequestedDate |
FromScheduledShipDate | Datetime | FromScheduledShipDate |
InitialDestinationId | Long | InitialDestinationId |
Item | String | Item |
ItemId | Long | ItemId |
ModeOfTransportCode | String | ModeOfTransportCode |
OrderTypeCode | String | OrderTypeCode |
OrganizationCode | String | OrganizationCode |
OrganizationId | Long | OrganizationId |
OrganizationName | String | OrganizationName |
ServiceLevelCode | String | ServiceLevelCode |
ToRequestedDate | Datetime | ToRequestedDate |
ToScheduledShipDate | Datetime | ToScheduledShipDate |
TransactionId | Long | TransactionId |
TransportationShipment | String | TransportationShipment |
Finder | String | finder |