ShipmentsunpackedShipmentLinesproratedCosts

Columns


Name	Type	Description
ShipmentsDeliveryId [KEY]	Long	ShipmentsDeliveryId of ShipmentsunpackedShipmentLinesproratedCosts
UnpackedshipmentlinesShipmentLine [KEY]	Long	UnpackedshipmentlinesShipmentLine of ShipmentsunpackedShipmentLinesproratedCosts
ProratedShippingCostId [KEY]	Long	ProratedShippingCostId of ShipmentsunpackedShipmentLinesproratedCosts
ShippingCostTypeId	Long	ShippingCostTypeId of ShipmentsunpackedShipmentLinesproratedCosts
ShippingCostType	String	ShippingCostType of ShipmentsunpackedShipmentLinesproratedCosts
ShippingCostTypeCategoryCode	String	ShippingCostTypeCategoryCode of ShipmentsunpackedShipmentLinesproratedCosts
ShippingCostTypeCategory	String	ShippingCostTypeCategory of ShipmentsunpackedShipmentLinesproratedCosts
ProratedAmount	Double	ProratedAmount of ShipmentsunpackedShipmentLinesproratedCosts
CurrencyCode	String	CurrencyCode of ShipmentsunpackedShipmentLinesproratedCosts
CurrencyName	String	CurrencyName of ShipmentsunpackedShipmentLinesproratedCosts
CreatedBy	String	CreatedBy of ShipmentsunpackedShipmentLinesproratedCosts
CreationDate	Datetime	CreationDate of ShipmentsunpackedShipmentLinesproratedCosts
LastUpdatedBy	String	LastUpdatedBy of ShipmentsunpackedShipmentLinesproratedCosts
LastUpdateDate	Datetime	LastUpdateDate of ShipmentsunpackedShipmentLinesproratedCosts

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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