Shipments
Shipments
Columns
| Name | Type | Description |
| Shipment | String | Shipment of Shipments |
| DeliveryId [KEY] | Long | DeliveryId of Shipments |
| ShipmentDescription | String | ShipmentDescription of Shipments |
| InitialPickupDate | Date | InitialPickupDate of Shipments |
| InitialPickupDateTime | Datetime | InitialPickupDateTime of Shipments |
| BillOfLading | String | BillOfLading of Shipments |
| GrossWeight | Double | GrossWeight of Shipments |
| NetWeight | Double | NetWeight of Shipments |
| TareWeight | Double | TareWeight of Shipments |
| WeightUOMCode | String | WeightUOMCode of Shipments |
| WeightUOM | String | WeightUOM of Shipments |
| EquipmentTypeId | Long | EquipmentTypeId of Shipments |
| EquipmentType | String | EquipmentType of Shipments |
| Equipment | String | Equipment of Shipments |
| SealNumber | String | SealNumber of Shipments |
| Volume | Double | Volume of Shipments |
| VolumeUOMCode | String | VolumeUOMCode of Shipments |
| VolumeUOM | String | VolumeUOM of Shipments |
| CarrierId | Long | CarrierId of Shipments |
| Carrier | String | Carrier of Shipments |
| CarrierNumber | String | CarrierNumber of Shipments |
| ModeOfTransportCode | String | ModeOfTransportCode of Shipments |
| ModeOfTransport | String | ModeOfTransport of Shipments |
| ServiceLevelCode | String | ServiceLevelCode of Shipments |
| ServiceLevel | String | ServiceLevel of Shipments |
| ShippingMethodCode | String | ShippingMethodCode of Shipments |
| ShippingMethod | String | ShippingMethod of Shipments |
| Waybill | String | Waybill of Shipments |
| PackingSlipNumber | String | PackingSlipNumber of Shipments |
| ActualShipDate | Date | ActualShipDate of Shipments |
| ActualShipDateTime | Datetime | ActualShipDateTime of Shipments |
| UltimateDropoffDate | Date | UltimateDropoffDate of Shipments |
| UltimateDropoffDateTime | Datetime | UltimateDropoffDateTime of Shipments |
| FreightTermsCode | String | FreightTermsCode of Shipments |
| FreightTerms | String | FreightTerms of Shipments |
| FOBCode | String | FOBCode of Shipments |
| FOB | String | FOB of Shipments |
| FOBSiteId | Long | FOBSiteId of Shipments |
| FOBSiteNumber | String | FOBSiteNumber of Shipments |
| FOBLocationId | Long | FOBLocationId of Shipments |
| FOBAddress1 | String | FOBAddress1 of Shipments |
| FOBAddress2 | String | FOBAddress2 of Shipments |
| FOBAddress3 | String | FOBAddress3 of Shipments |
| FOBAddress4 | String | FOBAddress4 of Shipments |
| FOBCity | String | FOBCity of Shipments |
| FOBCounty | String | FOBCounty of Shipments |
| FOBPostalCode | String | FOBPostalCode of Shipments |
| FOBRegion | String | FOBRegion of Shipments |
| FOBState | String | FOBState of Shipments |
| FOBCountry | String | FOBCountry of Shipments |
| DockCode | String | DockCode of Shipments |
| CODAmount | Double | CODAmount of Shipments |
| CODPaidBy | String | CODPaidBy of Shipments |
| CODCurrencyCode | String | CODCurrencyCode of Shipments |
| CODRemitTo | String | CODRemitTo of Shipments |
| ASNDateSent | Date | ASNDateSent of Shipments |
| ASNDateTimeSent | Datetime | ASNDateTimeSent of Shipments |
| ConfirmedDate | Date | ConfirmedDate of Shipments |
| ConfirmedDateTime | Datetime | ConfirmedDateTime of Shipments |
| ConfirmedBy | String | ConfirmedBy of Shipments |
| LoadingSequenceRule | Double | LoadingSequenceRule of Shipments |
| LoadingOrderRuleCode | String | LoadingOrderRuleCode of Shipments |
| LoadingOrderRule | String | LoadingOrderRule of Shipments |
| ProblemContactReference | String | ProblemContactReference of Shipments |
| OrganizationId | Long | OrganizationId of Shipments |
| OrganizationCode | String | OrganizationCode of Shipments |
| OrganizationName | String | OrganizationName of Shipments |
| RcvShipmentNumber | String | RcvShipmentNumber of Shipments |
| RcvShipmentHeaderId | Long | RcvShipmentHeaderId of Shipments |
| ShipmentStatusCode | String | ShipmentStatusCode of Shipments |
| ShipmentStatus | String | ShipmentStatus of Shipments |
| CreatedBy | String | CreatedBy of Shipments |
| CreationDate | Datetime | CreationDate of Shipments |
| LastUpdatedBy | String | LastUpdatedBy of Shipments |
| LastUpdateDate | Datetime | LastUpdateDate of Shipments |
| SourceSystemId | Long | SourceSystemId of Shipments |
| SourceSystem | String | SourceSystem of Shipments |
| ShipFromLocationId | Long | ShipFromLocationId of Shipments |
| ShipFromAddress1 | String | ShipFromAddress1 of Shipments |
| ShipFromAddress2 | String | ShipFromAddress2 of Shipments |
| ShipFromAddress3 | String | ShipFromAddress3 of Shipments |
| ShipFromAddress4 | String | ShipFromAddress4 of Shipments |
| ShipFromCity | String | ShipFromCity of Shipments |
| ShipFromCounty | String | ShipFromCounty of Shipments |
| ShipFromPostalCode | String | ShipFromPostalCode of Shipments |
| ShipFromRegion | String | ShipFromRegion of Shipments |
| ShipFromState | String | ShipFromState of Shipments |
| ShipFromCountry | String | ShipFromCountry of Shipments |
| ShipToLocationId | Long | ShipToLocationId of Shipments |
| ShipToAddress1 | String | ShipToAddress1 of Shipments |
| ShipToAddress2 | String | ShipToAddress2 of Shipments |
| ShipToAddress3 | String | ShipToAddress3 of Shipments |
| ShipToAddress4 | String | ShipToAddress4 of Shipments |
| ShipToCity | String | ShipToCity of Shipments |
| ShipToCounty | String | ShipToCounty of Shipments |
| ShipToPostalCode | String | ShipToPostalCode of Shipments |
| ShipToRegion | String | ShipToRegion of Shipments |
| ShipToState | String | ShipToState of Shipments |
| ShipToCountry | String | ShipToCountry of Shipments |
| TransportationReasonCode | String | TransportationReasonCode of Shipments |
| TransportationReason | String | TransportationReason of Shipments |
| PortOfLoading | String | PortOfLoading of Shipments |
| PortOfDischarge | String | PortOfDischarge of Shipments |
| NumberOfOuterPackingUnits | Double | NumberOfOuterPackingUnits of Shipments |
| EarliestPickupDate | Datetime | EarliestPickupDate of Shipments |
| LatestPickupDate | Datetime | LatestPickupDate of Shipments |
| EarliestDropoffDate | Datetime | EarliestDropoffDate of Shipments |
| LatestDropoffDate | Datetime | LatestDropoffDate of Shipments |
| ShipToPartyId | Long | ShipToPartyId of Shipments |
| ShipToCustomer | String | ShipToCustomer of Shipments |
| ShipToCustomerNumber | String | ShipToCustomerNumber of Shipments |
| ShipToPartySiteId | Long | ShipToPartySiteId of Shipments |
| ShipToPartySiteNumber | String | ShipToPartySiteNumber of Shipments |
| SoldToPartyId | Long | SoldToPartyId of Shipments |
| SoldToCustomer | String | SoldToCustomer of Shipments |
| SoldToCustomerNumber | String | SoldToCustomerNumber of Shipments |
| Supplier | String | Supplier of Shipments |
| SupplierPartyNumber | String | SupplierPartyNumber of Shipments |
| LogisticsServiceProviderCustomerId | Long | LogisticsServiceProviderCustomerId of Shipments |
| LogisticsServiceProviderCustomer | String | LogisticsServiceProviderCustomer of Shipments |
| LogisticsServiceProviderCustomerNumber | String | LogisticsServiceProviderCustomerNumber of Shipments |
| TransportationShipment | String | TransportationShipment of Shipments |
| DistributedOrganizationFlag | Bool | DistributedOrganizationFlag of Shipments |
| CommercialInvoice | String | CommercialInvoice of Shipments |
| PlannedFlag | Bool | PlannedFlag of Shipments |
| AutomaticallyPackFlag | Bool | AutomaticallyPackFlag of Shipments |
| EnableAutoshipFlag | Bool | EnableAutoshipFlag of Shipments |
| TransportationShipmentFromEvent | String | TransportationShipmentFromEvent of Shipments |
| TransportationShipmentCompleteFromEvent | String | TransportationShipmentCompleteFromEvent of Shipments |
| TradeComplianceScreenedFromEvent | String | TradeComplianceScreenedFromEvent of Shipments |
| ExternalSystemTransactionReference | String | ExternalSystemTransactionReference of Shipments |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BaseItem | String | BaseItem |
| 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 |
| ShipmentSet | String | ShipmentSet |
| SourceOrder | String | SourceOrder |
| SourceOrderFulfillmentLine | String | SourceOrderFulfillmentLine |
| SourceOrderFulfillmentLineId | String | SourceOrderFulfillmentLineId |
| SourceOrderLine | String | SourceOrderLine |
| TradeComplianceStatus | String | TradeComplianceStatus |
| TransportationPlanningStatus | String | TransportationPlanningStatus |
| Finder | String | finder |