ShipmentTransactionRequestsshipmentsunpackedLinescosts
ShipmentTransactionRequestsshipmentsunpackedLinescosts
Columns
Name | Type | Description |
ShipmentTransactionRequestsTransactionId [KEY] | Long | ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
ShipmentsDeliveryInterfaceId [KEY] | Long | ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
UnpackedlinesDeliveryDetailInterfaceId [KEY] | Long | UnpackedlinesDeliveryDetailInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
FreightCostInterfaceId [KEY] | Long | FreightCostInterfaceId of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
ShippingCostType | String | Type of cost that is predefined in the application. |
Amount | Double | Amount for the shipping cost for each unit. |
Currency | String | Abbreviation that identifies the currency of the shipping cost. |
ConversionRate | Double | Rate of the currency conversion. |
ConversionDate | Date | Date when the currency conversion occurred. |
ConversionRateTypeCode | String | Abbreviation that identifies the type of currency conversion. |
Subinventory | String | Subinventory to use when fulfilling the item to be shipped. |
Locator | String | Concatenated name of the inventory locator that provides the source for material that ships. |
CreatedBy | String | CreatedBy of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
CreationDate | Datetime | CreationDate of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequestsshipmentsunpackedLinescosts |
Errors | String | errors |
DFF | String | DFF |
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 |
TransactionId | Long | TransactionId |
Finder | String | finder |