Excel Add-In for Oracle Fusion Cloud SCM

Build 23.0.8839

ShipmentsouterPackingUnitsshipmentLines

ShipmentsouterPackingUnitsshipmentLines

Columns

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

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
DeliveryId Long DeliveryId
OrderNumber String OrderNumber
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839