ShipmentsunpackedShipmentLines
ShipmentsunpackedShipmentLines
Columns
| Name | Type | Description |
| ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsunpackedShipmentLines |
| ShipmentLine [KEY] | Long | ShipmentLine of ShipmentsunpackedShipmentLines |
| OrderTypeCode | String | OrderTypeCode of ShipmentsunpackedShipmentLines |
| OrderType | String | OrderType of ShipmentsunpackedShipmentLines |
| Order | String | Order of ShipmentsunpackedShipmentLines |
| OrderLine | String | OrderLine of ShipmentsunpackedShipmentLines |
| OrderSchedule | String | OrderSchedule of ShipmentsunpackedShipmentLines |
| InventoryItemId | Long | InventoryItemId of ShipmentsunpackedShipmentLines |
| Item | String | Item of ShipmentsunpackedShipmentLines |
| ItemDescription | String | ItemDescription of ShipmentsunpackedShipmentLines |
| Revision | String | Revision of ShipmentsunpackedShipmentLines |
| UnitPrice | Long | UnitPrice of ShipmentsunpackedShipmentLines |
| SellingPrice | Long | SellingPrice of ShipmentsunpackedShipmentLines |
| RequestedQuantity | Double | RequestedQuantity of ShipmentsunpackedShipmentLines |
| RequestedQuantityUOMCode | String | RequestedQuantityUOMCode of ShipmentsunpackedShipmentLines |
| RequestedQuantityUOM | String | RequestedQuantityUOM of ShipmentsunpackedShipmentLines |
| SecondaryRequestedQuantity | Double | SecondaryRequestedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryRequestedQuantityUOMCode | String | SecondaryRequestedQuantityUOMCode of ShipmentsunpackedShipmentLines |
| SecondaryRequestedQuantityUOM | String | SecondaryRequestedQuantityUOM of ShipmentsunpackedShipmentLines |
| FOBCode | String | FOBCode of ShipmentsunpackedShipmentLines |
| FOB | String | FOB of ShipmentsunpackedShipmentLines |
| FreightTermsCode | String | FreightTermsCode of ShipmentsunpackedShipmentLines |
| FreightTerms | String | FreightTerms of ShipmentsunpackedShipmentLines |
| ShippingPriorityCode | String | ShippingPriorityCode of ShipmentsunpackedShipmentLines |
| ShippingPriority | String | ShippingPriority of ShipmentsunpackedShipmentLines |
| PreferredGrade | String | PreferredGrade of ShipmentsunpackedShipmentLines |
| PreferredGradeName | String | PreferredGradeName of ShipmentsunpackedShipmentLines |
| CurrencyCode | String | CurrencyCode of ShipmentsunpackedShipmentLines |
| CurrencyName | String | CurrencyName of ShipmentsunpackedShipmentLines |
| ShipmentSet | String | ShipmentSet of ShipmentsunpackedShipmentLines |
| ArrivalSet | String | ArrivalSet of ShipmentsunpackedShipmentLines |
| CustomerPONumber | String | CustomerPONumber of ShipmentsunpackedShipmentLines |
| CustomerItemId | Long | CustomerItemId of ShipmentsunpackedShipmentLines |
| CustomerItem | String | CustomerItem of ShipmentsunpackedShipmentLines |
| CustomerItemDescription | String | CustomerItemDescription of ShipmentsunpackedShipmentLines |
| RequestedDate | Datetime | RequestedDate of ShipmentsunpackedShipmentLines |
| ScheduledShipDate | Datetime | ScheduledShipDate of ShipmentsunpackedShipmentLines |
| RequestedDateTypeCode | String | RequestedDateTypeCode of ShipmentsunpackedShipmentLines |
| RequestedDateType | String | RequestedDateType of ShipmentsunpackedShipmentLines |
| ShipToPartyId | Long | ShipToPartyId of ShipmentsunpackedShipmentLines |
| ShipToCustomer | String | ShipToCustomer of ShipmentsunpackedShipmentLines |
| ShipToCustomerNumber | String | ShipToCustomerNumber of ShipmentsunpackedShipmentLines |
| ShipToPartySiteId | Long | ShipToPartySiteId of ShipmentsunpackedShipmentLines |
| ShipToPartySiteNumber | String | ShipToPartySiteNumber of ShipmentsunpackedShipmentLines |
| ShipToContactId | Long | ShipToContactId of ShipmentsunpackedShipmentLines |
| ShipToContact | String | ShipToContact of ShipmentsunpackedShipmentLines |
| ShipToContactFirstName | String | ShipToContactFirstName of ShipmentsunpackedShipmentLines |
| ShipToContactLastName | String | ShipToContactLastName of ShipmentsunpackedShipmentLines |
| ShipToContactPhone | String | ShipToContactPhone of ShipmentsunpackedShipmentLines |
| ShipToURL | String | ShipToURL of ShipmentsunpackedShipmentLines |
| ShipToFax | String | ShipToFax of ShipmentsunpackedShipmentLines |
| ShipToEmail | String | ShipToEmail of ShipmentsunpackedShipmentLines |
| ShipToLocationId | Long | ShipToLocationId of ShipmentsunpackedShipmentLines |
| ShipToLocationType | String | ShipToLocationType of ShipmentsunpackedShipmentLines |
| ShipToAddress1 | String | ShipToAddress1 of ShipmentsunpackedShipmentLines |
| ShipToAddress2 | String | ShipToAddress2 of ShipmentsunpackedShipmentLines |
| ShipToAddress3 | String | ShipToAddress3 of ShipmentsunpackedShipmentLines |
| ShipToAddress4 | String | ShipToAddress4 of ShipmentsunpackedShipmentLines |
| ShipToCity | String | ShipToCity of ShipmentsunpackedShipmentLines |
| ShipToCounty | String | ShipToCounty of ShipmentsunpackedShipmentLines |
| ShipToPostalCode | String | ShipToPostalCode of ShipmentsunpackedShipmentLines |
| ShipToRegion | String | ShipToRegion of ShipmentsunpackedShipmentLines |
| ShipToState | String | ShipToState of ShipmentsunpackedShipmentLines |
| ShipToCountry | String | ShipToCountry of ShipmentsunpackedShipmentLines |
| SoldToPartyId | Long | SoldToPartyId of ShipmentsunpackedShipmentLines |
| SoldToCustomer | String | SoldToCustomer of ShipmentsunpackedShipmentLines |
| SoldToCustomerNumber | String | SoldToCustomerNumber of ShipmentsunpackedShipmentLines |
| Supplier | String | Supplier of ShipmentsunpackedShipmentLines |
| SupplierPartyNumber | String | SupplierPartyNumber of ShipmentsunpackedShipmentLines |
| SoldToContactId | Long | SoldToContactId of ShipmentsunpackedShipmentLines |
| SoldToContact | String | SoldToContact of ShipmentsunpackedShipmentLines |
| SoldToContactFirstName | String | SoldToContactFirstName of ShipmentsunpackedShipmentLines |
| SoldToContactLastName | String | SoldToContactLastName of ShipmentsunpackedShipmentLines |
| SoldToContactPhone | String | SoldToContactPhone of ShipmentsunpackedShipmentLines |
| SoldToURL | String | SoldToURL of ShipmentsunpackedShipmentLines |
| SoldToFax | String | SoldToFax of ShipmentsunpackedShipmentLines |
| SoldToEmail | String | SoldToEmail of ShipmentsunpackedShipmentLines |
| BillToPartyId | Long | BillToPartyId of ShipmentsunpackedShipmentLines |
| BillToCustomer | String | BillToCustomer of ShipmentsunpackedShipmentLines |
| BillToCustomerNumber | String | BillToCustomerNumber of ShipmentsunpackedShipmentLines |
| BillToPartySiteId | Long | BillToPartySiteId of ShipmentsunpackedShipmentLines |
| BillToPartySiteNumber | String | BillToPartySiteNumber of ShipmentsunpackedShipmentLines |
| BillToContactId | Long | BillToContactId of ShipmentsunpackedShipmentLines |
| BillToContact | String | BillToContact of ShipmentsunpackedShipmentLines |
| BillToContactFirstName | String | BillToContactFirstName of ShipmentsunpackedShipmentLines |
| BillToContactLastName | String | BillToContactLastName of ShipmentsunpackedShipmentLines |
| BillToContactPhone | String | BillToContactPhone of ShipmentsunpackedShipmentLines |
| BillToURL | String | BillToURL of ShipmentsunpackedShipmentLines |
| BillToFax | String | BillToFax of ShipmentsunpackedShipmentLines |
| BillToEmail | String | BillToEmail of ShipmentsunpackedShipmentLines |
| BillToLocationId | Long | BillToLocationId of ShipmentsunpackedShipmentLines |
| BillToAddress1 | String | BillToAddress1 of ShipmentsunpackedShipmentLines |
| BillToAddress2 | String | BillToAddress2 of ShipmentsunpackedShipmentLines |
| BillToAddress3 | String | BillToAddress3 of ShipmentsunpackedShipmentLines |
| BillToAddress4 | String | BillToAddress4 of ShipmentsunpackedShipmentLines |
| BillToCity | String | BillToCity of ShipmentsunpackedShipmentLines |
| BillToCounty | String | BillToCounty of ShipmentsunpackedShipmentLines |
| BillToPostalCode | String | BillToPostalCode of ShipmentsunpackedShipmentLines |
| BillToRegion | String | BillToRegion of ShipmentsunpackedShipmentLines |
| BillToState | String | BillToState of ShipmentsunpackedShipmentLines |
| BillToCountry | String | BillToCountry of ShipmentsunpackedShipmentLines |
| Subinventory | String | Subinventory of ShipmentsunpackedShipmentLines |
| LocatorId | Long | LocatorId of ShipmentsunpackedShipmentLines |
| Locator | String | Locator of ShipmentsunpackedShipmentLines |
| ShippedQuantity | Double | ShippedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryShippedQuantity | Double | SecondaryShippedQuantity of ShipmentsunpackedShipmentLines |
| NetWeight | Long | NetWeight of ShipmentsunpackedShipmentLines |
| GrossWeight | Long | GrossWeight of ShipmentsunpackedShipmentLines |
| TareWeight | Double | TareWeight of ShipmentsunpackedShipmentLines |
| WeightUOMCode | String | WeightUOMCode of ShipmentsunpackedShipmentLines |
| WeightUOM | String | WeightUOM of ShipmentsunpackedShipmentLines |
| Volume | Long | Volume of ShipmentsunpackedShipmentLines |
| VolumeUOMCode | String | VolumeUOMCode of ShipmentsunpackedShipmentLines |
| VolumeUOM | String | VolumeUOM of ShipmentsunpackedShipmentLines |
| LoadingSequence | Long | LoadingSequence of ShipmentsunpackedShipmentLines |
| LotNumber | String | LotNumber of ShipmentsunpackedShipmentLines |
| EndAssemblyItemNumber | String | EndAssemblyItemNumber of ShipmentsunpackedShipmentLines |
| OrganizationId | Long | OrganizationId of ShipmentsunpackedShipmentLines |
| OrganizationCode | String | OrganizationCode of ShipmentsunpackedShipmentLines |
| OrganizationName | String | OrganizationName of ShipmentsunpackedShipmentLines |
| ParentPackingUnitId | Long | ParentPackingUnitId of ShipmentsunpackedShipmentLines |
| ParentPackingUnit | String | ParentPackingUnit of ShipmentsunpackedShipmentLines |
| ShipmentId | Long | ShipmentId of ShipmentsunpackedShipmentLines |
| Shipment | String | Shipment of ShipmentsunpackedShipmentLines |
| ProjectSalesOrderFlag | Bool | ProjectSalesOrderFlag of ShipmentsunpackedShipmentLines |
| RcvShipmentLineId | Long | RcvShipmentLineId of ShipmentsunpackedShipmentLines |
| LineStatusCode | String | LineStatusCode of ShipmentsunpackedShipmentLines |
| LineStatus | String | LineStatus of ShipmentsunpackedShipmentLines |
| TrackingNumber | String | TrackingNumber of ShipmentsunpackedShipmentLines |
| SealNumber | String | SealNumber of ShipmentsunpackedShipmentLines |
| PickWaveId | Long | PickWaveId of ShipmentsunpackedShipmentLines |
| PickWave | String | PickWave of ShipmentsunpackedShipmentLines |
| SourceOrderId | Long | SourceOrderId of ShipmentsunpackedShipmentLines |
| SourceOrder | String | SourceOrder of ShipmentsunpackedShipmentLines |
| SourceOrderLineId | Long | SourceOrderLineId of ShipmentsunpackedShipmentLines |
| SourceOrderLine | String | SourceOrderLine of ShipmentsunpackedShipmentLines |
| SourceOrderFulfillmentLineId | Int | SourceOrderFulfillmentLineId of ShipmentsunpackedShipmentLines |
| SourceOrderFulfillmentLine | String | SourceOrderFulfillmentLine of ShipmentsunpackedShipmentLines |
| TaxationCountryCode | String | TaxationCountryCode of ShipmentsunpackedShipmentLines |
| TaxationCountry | String | TaxationCountry of ShipmentsunpackedShipmentLines |
| FirstPartyTaxRegistrationId | Long | FirstPartyTaxRegistrationId of ShipmentsunpackedShipmentLines |
| FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber of ShipmentsunpackedShipmentLines |
| ThirdPartyTaxRegistrationId | Long | ThirdPartyTaxRegistrationId of ShipmentsunpackedShipmentLines |
| ThirdPartyTaxRegistrationNumber | String | ThirdPartyTaxRegistrationNumber of ShipmentsunpackedShipmentLines |
| LocationOfFinalDischargeId | Long | LocationOfFinalDischargeId of ShipmentsunpackedShipmentLines |
| LocationOfFinalDischargeCode | String | LocationOfFinalDischargeCode of ShipmentsunpackedShipmentLines |
| LocationOfFinalDischarge | String | LocationOfFinalDischarge of ShipmentsunpackedShipmentLines |
| DocumentFiscalClassificationCode | String | DocumentFiscalClassificationCode of ShipmentsunpackedShipmentLines |
| DocumentFiscalClassification | String | DocumentFiscalClassification of ShipmentsunpackedShipmentLines |
| TransactionBusinessCategoryCode | String | TransactionBusinessCategoryCode of ShipmentsunpackedShipmentLines |
| TransactionBusinessCategory | String | TransactionBusinessCategory of ShipmentsunpackedShipmentLines |
| UserDefinedFiscalClassificationCode | String | UserDefinedFiscalClassificationCode of ShipmentsunpackedShipmentLines |
| UserDefinedFiscalClassification | String | UserDefinedFiscalClassification of ShipmentsunpackedShipmentLines |
| TaxInvoiceNumber | String | TaxInvoiceNumber of ShipmentsunpackedShipmentLines |
| TaxInvoiceDate | Date | TaxInvoiceDate of ShipmentsunpackedShipmentLines |
| ProductCategoryCode | String | ProductCategoryCode of ShipmentsunpackedShipmentLines |
| ProductCategory | String | ProductCategory of ShipmentsunpackedShipmentLines |
| IntendedUseClassificationId | Double | IntendedUseClassificationId of ShipmentsunpackedShipmentLines |
| IntendedUse | String | IntendedUse of ShipmentsunpackedShipmentLines |
| ProductTypeCode | String | ProductTypeCode of ShipmentsunpackedShipmentLines |
| ProductType | String | ProductType of ShipmentsunpackedShipmentLines |
| AssessableValue | Double | AssessableValue of ShipmentsunpackedShipmentLines |
| TaxClassificationCode | String | TaxClassificationCode of ShipmentsunpackedShipmentLines |
| TaxClassification | String | TaxClassification of ShipmentsunpackedShipmentLines |
| TaxExemptionCertificateNumber | String | TaxExemptionCertificateNumber of ShipmentsunpackedShipmentLines |
| TaxExemptionReasonCode | String | TaxExemptionReasonCode of ShipmentsunpackedShipmentLines |
| TaxExemptionReason | String | TaxExemptionReason of ShipmentsunpackedShipmentLines |
| ProductFiscalClassificationId | Long | ProductFiscalClassificationId of ShipmentsunpackedShipmentLines |
| ProductFiscalClassification | String | ProductFiscalClassification of ShipmentsunpackedShipmentLines |
| TransportationPlanningStatusCode | String | TransportationPlanningStatusCode of ShipmentsunpackedShipmentLines |
| TransportationPlanningStatus | String | TransportationPlanningStatus of ShipmentsunpackedShipmentLines |
| TransportationPlanningDate | Datetime | TransportationPlanningDate of ShipmentsunpackedShipmentLines |
| TransportationShipment | String | TransportationShipment of ShipmentsunpackedShipmentLines |
| TransportationShipmentLine | String | TransportationShipmentLine of ShipmentsunpackedShipmentLines |
| InitialDestinationId | Long | InitialDestinationId of ShipmentsunpackedShipmentLines |
| InitialDestination | String | InitialDestination of ShipmentsunpackedShipmentLines |
| TradeComplianceStatusCode | String | TradeComplianceStatusCode of ShipmentsunpackedShipmentLines |
| TradeComplianceStatus | String | TradeComplianceStatus of ShipmentsunpackedShipmentLines |
| TradeComplianceDate | Datetime | TradeComplianceDate of ShipmentsunpackedShipmentLines |
| TradeComplianceReason | String | TradeComplianceReason of ShipmentsunpackedShipmentLines |
| TradeComplianceScreeningMethodCode | String | TradeComplianceScreeningMethodCode of ShipmentsunpackedShipmentLines |
| TradeComplianceScreeningMethod | String | TradeComplianceScreeningMethod of ShipmentsunpackedShipmentLines |
| ShipFromLocationId | Long | ShipFromLocationId of ShipmentsunpackedShipmentLines |
| ShipFromAddress1 | String | ShipFromAddress1 of ShipmentsunpackedShipmentLines |
| ShipFromAddress2 | String | ShipFromAddress2 of ShipmentsunpackedShipmentLines |
| ShipFromAddress3 | String | ShipFromAddress3 of ShipmentsunpackedShipmentLines |
| ShipFromAddress4 | String | ShipFromAddress4 of ShipmentsunpackedShipmentLines |
| ShipFromCity | String | ShipFromCity of ShipmentsunpackedShipmentLines |
| ShipFromCounty | String | ShipFromCounty of ShipmentsunpackedShipmentLines |
| ShipFromPostalCode | String | ShipFromPostalCode of ShipmentsunpackedShipmentLines |
| ShipFromRegion | String | ShipFromRegion of ShipmentsunpackedShipmentLines |
| ShipFromState | String | ShipFromState of ShipmentsunpackedShipmentLines |
| ShipFromCountry | String | ShipFromCountry of ShipmentsunpackedShipmentLines |
| MaximumOvershipmentPercentage | Long | MaximumOvershipmentPercentage of ShipmentsunpackedShipmentLines |
| MaximumUndershipmentPercentage | Long | MaximumUndershipmentPercentage of ShipmentsunpackedShipmentLines |
| SourceRequestedQuantity | Double | SourceRequestedQuantity of ShipmentsunpackedShipmentLines |
| SourceRequestedQuantityUOMCode | String | SourceRequestedQuantityUOMCode of ShipmentsunpackedShipmentLines |
| SourceRequestedQuantityUOM | String | SourceRequestedQuantityUOM of ShipmentsunpackedShipmentLines |
| SecondarySourceRequestedQuantity | Double | SecondarySourceRequestedQuantity of ShipmentsunpackedShipmentLines |
| SecondarySourceRequestedQuantityUOMCode | String | SecondarySourceRequestedQuantityUOMCode of ShipmentsunpackedShipmentLines |
| SecondarySourceRequestedQuantityUOM | String | SecondarySourceRequestedQuantityUOM of ShipmentsunpackedShipmentLines |
| DeliveredQuantity | Double | DeliveredQuantity of ShipmentsunpackedShipmentLines |
| SecondaryDeliveredQuantity | Double | SecondaryDeliveredQuantity of ShipmentsunpackedShipmentLines |
| CancelledQuantity | Double | CancelledQuantity of ShipmentsunpackedShipmentLines |
| SecondaryCancelledQuantity | Double | SecondaryCancelledQuantity of ShipmentsunpackedShipmentLines |
| BackorderedQuantity | Double | BackorderedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryBackorderedQuantity | Double | SecondaryBackorderedQuantity of ShipmentsunpackedShipmentLines |
| PickedQuantity | Double | PickedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryPickedQuantity | Double | SecondaryPickedQuantity of ShipmentsunpackedShipmentLines |
| ConvertedQuantity | Double | ConvertedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryConvertedQuantity | Double | SecondaryConvertedQuantity of ShipmentsunpackedShipmentLines |
| StagedQuantity | Double | StagedQuantity of ShipmentsunpackedShipmentLines |
| SecondaryStagedQuantity | Double | SecondaryStagedQuantity of ShipmentsunpackedShipmentLines |
| PendingQuantity | Double | PendingQuantity of ShipmentsunpackedShipmentLines |
| PendingQuantityFlag | Bool | PendingQuantityFlag of ShipmentsunpackedShipmentLines |
| CreationDate | Datetime | CreationDate of ShipmentsunpackedShipmentLines |
| CreatedBy | String | CreatedBy of ShipmentsunpackedShipmentLines |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentsunpackedShipmentLines |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentsunpackedShipmentLines |
| SplitFromShipmentLine | Long | SplitFromShipmentLine of ShipmentsunpackedShipmentLines |
| SourceSubinventory | String | SourceSubinventory of ShipmentsunpackedShipmentLines |
| CarrierId | Long | CarrierId of ShipmentsunpackedShipmentLines |
| Carrier | String | Carrier of ShipmentsunpackedShipmentLines |
| CarrierNumber | String | CarrierNumber of ShipmentsunpackedShipmentLines |
| ModeOfTransportCode | String | ModeOfTransportCode of ShipmentsunpackedShipmentLines |
| ModeOfTransport | String | ModeOfTransport of ShipmentsunpackedShipmentLines |
| ServiceLevelCode | String | ServiceLevelCode of ShipmentsunpackedShipmentLines |
| ServiceLevel | String | ServiceLevel of ShipmentsunpackedShipmentLines |
| ShippingMethodCode | String | ShippingMethodCode of ShipmentsunpackedShipmentLines |
| ShippingMethod | String | ShippingMethod of ShipmentsunpackedShipmentLines |
| SourceDocumentTypeId | Long | SourceDocumentTypeId of ShipmentsunpackedShipmentLines |
| UnitWeight | Long | UnitWeight of ShipmentsunpackedShipmentLines |
| UnitVolume | Long | UnitVolume of ShipmentsunpackedShipmentLines |
| LogisticsServiceProviderCustomerId | Long | LogisticsServiceProviderCustomerId of ShipmentsunpackedShipmentLines |
| LogisticsServiceProviderCustomer | String | LogisticsServiceProviderCustomer of ShipmentsunpackedShipmentLines |
| LogisticsServiceProviderCustomerNumber | String | LogisticsServiceProviderCustomerNumber of ShipmentsunpackedShipmentLines |
| SourceLineUpdateDate | Datetime | SourceLineUpdateDate of ShipmentsunpackedShipmentLines |
| SourceSystemId | Long | SourceSystemId of ShipmentsunpackedShipmentLines |
| SourceSystem | String | SourceSystem of ShipmentsunpackedShipmentLines |
| ShipmentAdviceStatusFlag | Bool | ShipmentAdviceStatusFlag of ShipmentsunpackedShipmentLines |
| DoNotShipBeforeDate | Datetime | DoNotShipBeforeDate of ShipmentsunpackedShipmentLines |
| DoNotShipAfterDate | Datetime | DoNotShipAfterDate of ShipmentsunpackedShipmentLines |
| IntegrationStatusCode | String | IntegrationStatusCode of ShipmentsunpackedShipmentLines |
| IntegrationStatus | String | IntegrationStatus of ShipmentsunpackedShipmentLines |
| QuickShipStatus | String | QuickShipStatus of ShipmentsunpackedShipmentLines |
| BusinessUnitId | Long | BusinessUnitId of ShipmentsunpackedShipmentLines |
| BusinessUnit | String | BusinessUnit of ShipmentsunpackedShipmentLines |
| LegalEntityId | Long | LegalEntityId of ShipmentsunpackedShipmentLines |
| LegalEntity | String | LegalEntity of ShipmentsunpackedShipmentLines |
| POHeaderId | Long | POHeaderId of ShipmentsunpackedShipmentLines |
| PONumber | String | PONumber of ShipmentsunpackedShipmentLines |
| POBillToBusinessUnitId | Long | POBillToBusinessUnitId of ShipmentsunpackedShipmentLines |
| POBillToBusinessUnit | String | POBillToBusinessUnit of ShipmentsunpackedShipmentLines |
| POSoldToLegalEntityId | Long | POSoldToLegalEntityId of ShipmentsunpackedShipmentLines |
| POSoldToLegalEntity | String | POSoldToLegalEntity of ShipmentsunpackedShipmentLines |
| ConversionTypeCode | String | ConversionTypeCode of ShipmentsunpackedShipmentLines |
| ConversionDate | Date | ConversionDate of ShipmentsunpackedShipmentLines |
| ConversionRate | Double | ConversionRate of ShipmentsunpackedShipmentLines |
| ParentItemId | Long | ParentItemId of ShipmentsunpackedShipmentLines |
| ParentItem | String | ParentItem of ShipmentsunpackedShipmentLines |
| ParentItemDescription | String | ParentItemDescription of ShipmentsunpackedShipmentLines |
| ParentSourceOrderFulfillmentLineId | Long | ParentSourceOrderFulfillmentLineId of ShipmentsunpackedShipmentLines |
| BaseItemId | Long | BaseItemId of ShipmentsunpackedShipmentLines |
| BaseItem | String | BaseItem of ShipmentsunpackedShipmentLines |
| BaseItemDescription | String | BaseItemDescription of ShipmentsunpackedShipmentLines |
| SrcAttributeCategory | String | SrcAttributeCategory of ShipmentsunpackedShipmentLines |
| SrcAttribute1 | String | SrcAttribute1 of ShipmentsunpackedShipmentLines |
| SrcAttribute2 | String | SrcAttribute2 of ShipmentsunpackedShipmentLines |
| SrcAttribute3 | String | SrcAttribute3 of ShipmentsunpackedShipmentLines |
| SrcAttribute4 | String | SrcAttribute4 of ShipmentsunpackedShipmentLines |
| SrcAttribute5 | String | SrcAttribute5 of ShipmentsunpackedShipmentLines |
| SrcAttribute6 | String | SrcAttribute6 of ShipmentsunpackedShipmentLines |
| SrcAttribute7 | String | SrcAttribute7 of ShipmentsunpackedShipmentLines |
| SrcAttribute8 | String | SrcAttribute8 of ShipmentsunpackedShipmentLines |
| SrcAttribute9 | String | SrcAttribute9 of ShipmentsunpackedShipmentLines |
| SrcAttribute10 | String | SrcAttribute10 of ShipmentsunpackedShipmentLines |
| SrcAttribute11 | String | SrcAttribute11 of ShipmentsunpackedShipmentLines |
| SrcAttribute12 | String | SrcAttribute12 of ShipmentsunpackedShipmentLines |
| SrcAttribute13 | String | SrcAttribute13 of ShipmentsunpackedShipmentLines |
| SrcAttribute14 | String | SrcAttribute14 of ShipmentsunpackedShipmentLines |
| SrcAttribute15 | String | SrcAttribute15 of ShipmentsunpackedShipmentLines |
| SrcAttribute16 | String | SrcAttribute16 of ShipmentsunpackedShipmentLines |
| SrcAttribute17 | String | SrcAttribute17 of ShipmentsunpackedShipmentLines |
| SrcAttribute18 | String | SrcAttribute18 of ShipmentsunpackedShipmentLines |
| SrcAttribute19 | String | SrcAttribute19 of ShipmentsunpackedShipmentLines |
| SrcAttribute20 | String | SrcAttribute20 of ShipmentsunpackedShipmentLines |
| SrcAttributeDate1 | Date | SrcAttributeDate1 of ShipmentsunpackedShipmentLines |
| SrcAttributeDate2 | Date | SrcAttributeDate2 of ShipmentsunpackedShipmentLines |
| SrcAttributeDate3 | Date | SrcAttributeDate3 of ShipmentsunpackedShipmentLines |
| SrcAttributeDate4 | Date | SrcAttributeDate4 of ShipmentsunpackedShipmentLines |
| SrcAttributeDate5 | Date | SrcAttributeDate5 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber1 | Double | SrcAttributeNumber1 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber2 | Double | SrcAttributeNumber2 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber3 | Double | SrcAttributeNumber3 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber4 | Double | SrcAttributeNumber4 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber5 | Double | SrcAttributeNumber5 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber6 | Double | SrcAttributeNumber6 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber7 | Double | SrcAttributeNumber7 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber8 | Double | SrcAttributeNumber8 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber9 | Double | SrcAttributeNumber9 of ShipmentsunpackedShipmentLines |
| SrcAttributeNumber10 | Double | SrcAttributeNumber10 of ShipmentsunpackedShipmentLines |
| SrcAttributeTimestamp1 | Datetime | SrcAttributeTimestamp1 of ShipmentsunpackedShipmentLines |
| SrcAttributeTimestamp2 | Datetime | SrcAttributeTimestamp2 of ShipmentsunpackedShipmentLines |
| SrcAttributeTimestamp3 | Datetime | SrcAttributeTimestamp3 of ShipmentsunpackedShipmentLines |
| SrcAttributeTimestamp4 | Datetime | SrcAttributeTimestamp4 of ShipmentsunpackedShipmentLines |
| SrcAttributeTimestamp5 | Datetime | SrcAttributeTimestamp5 of ShipmentsunpackedShipmentLines |
| TransportationShipmentFromEvent | String | TransportationShipmentFromEvent of ShipmentsunpackedShipmentLines |
| TransportationShipmentLineFromEvent | String | TransportationShipmentLineFromEvent of ShipmentsunpackedShipmentLines |
| TransportationShipmentCompleteFromEvent | String | TransportationShipmentCompleteFromEvent of ShipmentsunpackedShipmentLines |
| TradeComplianceScreenedFromEvent | String | TradeComplianceScreenedFromEvent of ShipmentsunpackedShipmentLines |
| CurrentBackorderedQuantityFromEvent | Double | CurrentBackorderedQuantityFromEvent of ShipmentsunpackedShipmentLines |
| OriginalShipmentLineFromEvent | Long | OriginalShipmentLineFromEvent of ShipmentsunpackedShipmentLines |
| ProjectCostingProjectId | Long | ProjectCostingProjectId of ShipmentsunpackedShipmentLines |
| ProjectCostingProjectNumber | String | ProjectCostingProjectNumber of ShipmentsunpackedShipmentLines |
| ProjectCostingProjectName | String | ProjectCostingProjectName of ShipmentsunpackedShipmentLines |
| ProjectCostingTaskId | Long | ProjectCostingTaskId of ShipmentsunpackedShipmentLines |
| ProjectCostingTaskNumber | String | ProjectCostingTaskNumber of ShipmentsunpackedShipmentLines |
| ProjectCostingTaskName | String | ProjectCostingTaskName of ShipmentsunpackedShipmentLines |
| OverShipTolerancePercentage | Double | OverShipTolerancePercentage of ShipmentsunpackedShipmentLines |
| UnderShipTolerancePercentage | Double | UnderShipTolerancePercentage of ShipmentsunpackedShipmentLines |
| ShippingToleranceBehavior | String | ShippingToleranceBehavior of ShipmentsunpackedShipmentLines |
| ConvertedRequestedQuantity | Double | ConvertedRequestedQuantity of ShipmentsunpackedShipmentLines |
| LineNetWeight | Double | LineNetWeight of ShipmentsunpackedShipmentLines |
| LineGrossWeight | Double | LineGrossWeight of ShipmentsunpackedShipmentLines |
| SupplierLotNumber | String | SupplierLotNumber of ShipmentsunpackedShipmentLines |
| MovementRequestLineId | Long | MovementRequestLineId of ShipmentsunpackedShipmentLines |
| AllowItemSubstitutionFlag | Bool | AllowItemSubstitutionFlag of ShipmentsunpackedShipmentLines |
| OriginalItemId | Long | OriginalItemId of ShipmentsunpackedShipmentLines |
| OriginalItemNumber | String | OriginalItemNumber of ShipmentsunpackedShipmentLines |
| OriginalDeliveryDetailId | Long | OriginalDeliveryDetailId of ShipmentsunpackedShipmentLines |
| OriginalItemConvertedQuantity | Double | OriginalItemConvertedQuantity of ShipmentsunpackedShipmentLines |
| DestinationOrganizationCode | String | DestinationOrganizationCode of ShipmentsunpackedShipmentLines |
| LineUnitPrice | Double | LineUnitPrice of ShipmentsunpackedShipmentLines |
| LineUnitVolume | Double | LineUnitVolume of ShipmentsunpackedShipmentLines |
| LineVolume | Double | LineVolume of ShipmentsunpackedShipmentLines |
| LineUnitWeight | Double | LineUnitWeight of ShipmentsunpackedShipmentLines |
| LineSellingPrice | Double | LineSellingPrice of ShipmentsunpackedShipmentLines |
| OriginalSourceOrderFulfillmentLineId | Long | OriginalSourceOrderFulfillmentLineId of ShipmentsunpackedShipmentLines |
| OriginalSourceOrderFulfillmentLine | String | OriginalSourceOrderFulfillmentLine of ShipmentsunpackedShipmentLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DeliveryId | Long | DeliveryId |
| OrderNumber | String | OrderNumber |
| Finder | String | finder |