ShipmentsshippingCosts
ShipmentsshippingCosts
Columns
Name | Type | Description |
ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsshippingCosts |
FreightCostId [KEY] | Long | FreightCostId of ShipmentsshippingCosts |
DeliveryDetailId | Long | DeliveryDetailId of ShipmentsshippingCosts |
LPNId | Long | LPNId of ShipmentsshippingCosts |
PackingUnit | String | PackingUnit of ShipmentsshippingCosts |
ShippingCostTypeId | Long | ShippingCostTypeId of ShipmentsshippingCosts |
ShippingCost | String | ShippingCost of ShipmentsshippingCosts |
ShippingCostTypeCategoryCode | String | ShippingCostTypeCategoryCode of ShipmentsshippingCosts |
ShippingCostTypeCategory | String | ShippingCostTypeCategory of ShipmentsshippingCosts |
Amount | Double | Amount of ShipmentsshippingCosts |
CurrencyCode | String | CurrencyCode of ShipmentsshippingCosts |
CurrencyName | String | CurrencyName of ShipmentsshippingCosts |
ConversionRateTypeCode | String | ConversionRateTypeCode of ShipmentsshippingCosts |
ConversionRateType | String | ConversionRateType of ShipmentsshippingCosts |
ConversionRate | Double | ConversionRate of ShipmentsshippingCosts |
ConversionDate | Date | ConversionDate of ShipmentsshippingCosts |
CreatedBy | String | CreatedBy of ShipmentsshippingCosts |
CreationDate | Datetime | CreationDate of ShipmentsshippingCosts |
LastUpdatedBy | String | LastUpdatedBy of ShipmentsshippingCosts |
LastUpdateDate | Datetime | LastUpdateDate of ShipmentsshippingCosts |
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 |
DeliveryId | Long | DeliveryId |
EndAssemblyItemNumber | String | EndAssemblyItemNumber |
IntegrationStatus | String | IntegrationStatus |
Item | String | Item |
LineStatus | String | LineStatus |
OrderNumber | String | OrderNumber |
OrderType | String | OrderType |
OrderTypeCode | String | OrderTypeCode |
ParentPackingUnit | String | ParentPackingUnit |
PickWave | String | PickWave |
QuickShipStatus | String | QuickShipStatus |
RcvShipmentLineId | Long | RcvShipmentLineId |
ShipToCustomer | String | ShipToCustomer |
ShipToPartyId | String | ShipToPartyId |
Shipment | String | Shipment |
ShipmentSet | String | ShipmentSet |
SourceOrder | String | SourceOrder |
SourceOrderFulfillmentLine | String | SourceOrderFulfillmentLine |
SourceOrderFulfillmentLineId | String | SourceOrderFulfillmentLineId |
SourceOrderLine | String | SourceOrderLine |
SourceSystemId | String | SourceSystemId |
TradeComplianceStatus | String | TradeComplianceStatus |
TransportationPlanningStatus | String | TransportationPlanningStatus |
Finder | String | finder |