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

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


Name	Type	Description
DeliveryId	Long	DeliveryId
OrderNumber	String	OrderNumber
Finder	String	finder

JDBC Driver for Oracle Fusion Cloud SCM

ShipmentsouterPackingUnitsshipmentLines

Columns

Pseudo-Columns