Tableau Connector for Oracle Fusion Cloud SCM

Build 26.0.9770

ShipmentsouterPackingUnitsshipmentLines

Manages data about shipment lines included within specific packing units, facilitating tracking and documentation.

Columns

Name Type SupportedFinders Description
ShipmentsDeliveryId [KEY] Long Unique identifier for the delivery associated with the shipment line. This ensures the shipment line is linked to the correct delivery within the overall shipment process.
OuterpackingunitsLPNId [KEY] Long License Plate Number (LPN) identifier for the outer packing unit, used to track packaging and shipment details for larger items or containers.
ShipmentLine [KEY] Long Unique identifier for the shipment line, linking it to a specific line item within the shipment for tracking and management.
OrderTypeCode String FindByLineAttributes Code representing the type of order, such as 'SALES_ORDER' or 'PURCHASE_ORDER', helping classify and process shipment lines.
OrderType String FindByLineAttributes Descriptive name of the order type, providing context to the origin and classification of the order for the shipment line.
Order String The order number associated with the shipment line, providing a reference to the originating sales or purchase order.
OrderLine String Specific line number from the order, linking the shipment line to a particular item within the order for fulfillment.
OrderSchedule String The schedule number associated with the order, providing a reference to the timing of when the items in the order are expected to be shipped.
InventoryItemId Long Unique identifier for the inventory item associated with the shipment line, ensuring accurate tracking of items being shipped.
Item String FindByLineAttributes The item number or identifier for the specific product being shipped on the shipment line.
ItemDescription String Description of the item being shipped, providing context and detail about the specific product on the shipment line.
Revision String Revision number for the item being shipped, ensuring that the most current version or specification of the item is being shipped.
UnitPrice Long The price per unit for the item being shipped, used for calculating the total cost for the shipment line.
SellingPrice Long The selling price per unit of the item, reflecting the price that the customer is being charged for the item.
RequestedQuantity Decimal The quantity of items requested for shipment on this line, used for order fulfillment and inventory tracking.
RequestedQuantityUOMCode String Code for the unit of measure (UOM) for the requested quantity, ensuring proper unit tracking and conversions.
RequestedQuantityUOM String UOM for the requested quantity, such as 'each', 'box', or 'pallet', ensuring the correct unit is used in the shipment.
SecondaryRequestedQuantity Decimal The secondary quantity of items requested, usually for dual-unit measurements or specialized items with different measurement units.
SecondaryRequestedQuantityUOMCode String Code for the UOM for the secondary requested quantity, used when items are measured in multiple units.
SecondaryRequestedQuantityUOM String The secondary UOM for the requested quantity, allowing for dual measurement systems.
FOBCode String Code representing the Free on Board (FOB) terms, indicating when the responsibility for the goods transfers from seller to buyer.
FOB String The Free on Board (FOB) term associated with the shipment, such as 'FOB origin' or 'FOB destination', affecting shipping costs and responsibilities.
FreightTermsCode String Code representing the freight terms, specifying who pays for shipping (buyer or seller) and the timing of the payment.
FreightTerms String Descriptive name of the freight terms, providing context for payment and responsibility for shipping costs.
ShippingPriorityCode String Code representing the priority of the shipment, used to determine the order in which shipment lines should be processed.
ShippingPriority String Descriptive name of the shipping priority, such as 'High', 'Medium', or 'Low', helping prioritize shipments based on urgency.
PreferredGrade String The preferred grade of the item being shipped, indicating quality preferences or specifications required for shipment.
PreferredGradeName String Name of the preferred grade for the item, providing more specific information about quality expectations.
CurrencyCode String Currency code used for the shipment line, ensuring proper currency tracking for pricing and invoicing.
CurrencyName String Name of the currency used for the shipment line, providing clarity on the currency in which the pricing is determined.
ShipmentSet String FindByLineAttributes Group identifier for the shipment set, linking multiple shipment lines that are grouped together for handling or processing.
ArrivalSet String Group identifier for the arrival set, helping organize shipment lines based on their expected arrival at the destination.
CustomerPONumber String Customer's purchase order number, linking the shipment line to a specific customer order for reference and processing.
CustomerItemId Long Identifier for the customer-specific item number, used to track the item according to the customer's catalog or ordering system.
CustomerItem String The customer's item number for the product being shipped, ensuring alignment with the customer's system and inventory.
CustomerItemDescription String Description of the item as specified by the customer, ensuring proper identification and handling during the shipment process.
RequestedDate Datetime Date when the customer requested the shipment of the item, used for scheduling and tracking purposes.
ScheduledShipDate Datetime Date when the shipment is scheduled to be sent, ensuring proper scheduling and coordination with other shipments.
RequestedDateTypeCode String Code indicating whether the requested date is for the shipping or arrival date, helping determine fulfillment priorities.
RequestedDateType String Description of the requested date type, providing clarity on whether the date refers to shipping or arrival.
ShipToPartyId Long FindByLineAttributes Unique identifier for the party to which the shipment is being sent, ensuring accurate delivery.
ShipToCustomer String FindByLineAttributes Name of the customer who is the recipient of the shipment, ensuring that the shipment is correctly directed.
ShipToCustomerNumber String Customer number for the ship-to party, ensuring proper identification and communication with the receiving party.
ShipToPartySiteId Long Unique identifier for the site where the shipment is delivered, ensuring accurate location tracking.
ShipToPartySiteNumber String Number of the ship-to site, helping identify and locate the destination for the shipment.
ShipToContactId Long Unique identifier for the contact at the ship-to location, ensuring proper communication and handling of the shipment.
ShipToContact String Name of the person to contact at the ship-to location, ensuring communication for delivery issues or updates.
ShipToContactFirstName String First name of the contact person at the ship-to location.
ShipToContactLastName String Last name of the contact person at the ship-to location.
ShipToContactPhone String Phone number for the contact at the ship-to location, allowing for direct communication regarding the shipment.
ShipToURL String Website URL for the ship-to location, providing additional contact information for shipment tracking or updates.
ShipToFax String Fax number for the ship-to location, ensuring all possible communication channels are available for the shipment.
ShipToEmail String Email address for the contact at the ship-to location, ensuring communication is possible through email.
ShipToLocationId Long Unique identifier for the location where the shipment is to be delivered.
ShipToLocationType String Type of location where the shipment is to be delivered, such as warehouse, retail store, or office.
ShipToAddress1 String Primary address line for the ship-to location, ensuring accurate delivery.
ShipToAddress2 String Secondary address line for the ship-to location, providing additional address details if needed.
ShipToAddress3 String Additional address line for the ship-to location, providing further address details for the destination.
ShipToAddress4 String Final address line for the ship-to location, providing any final details for accurate shipment delivery.
ShipToCity String City of the ship-to location, ensuring the shipment is sent to the correct city.
ShipToCounty String County or district of the ship-to location.
ShipToPostalCode String Postal code of the ship-to location, used for accurate routing and delivery.
ShipToRegion String Region or state of the ship-to location, ensuring proper handling during transportation.
ShipToState String State of the ship-to location, ensuring compliance with regional regulations and accurate delivery.
ShipToCountry String Country of the ship-to location, ensuring international shipments are correctly handled.
SoldToPartyId Long Unique identifier for the party who purchased the items in the shipment.
SoldToCustomer String Name of the customer who made the purchase, ensuring correct billing and communication.
SoldToCustomerNumber String Customer number for the sold-to party, ensuring proper identification for invoicing and customer service.
Supplier String Name of the supplier providing the items in the shipment.
SupplierPartyNumber String Supplier's party number, ensuring accurate supplier tracking and communication.
SoldToContactId Long Unique identifier for the contact person at the sold-to location.
SoldToContact String Name of the contact person at the sold-to location, ensuring correct communication for billing and orders.
SoldToContactFirstName String First name of the contact person at the sold-to location.
SoldToContactLastName String Last name of the contact person at the sold-to location.
SoldToContactPhone String Phone number for the contact person at the sold-to location.
SoldToURL String URL for the sold-to party, providing more ways to contact or verify order details.
SoldToFax String Fax number for the sold-to location, providing an alternative contact method.
SoldToEmail String Email address for the contact at the sold-to location, ensuring communication about billing or order inquiries.
BillToPartyId Long Unique identifier for the billing party for the order.
BillToCustomer String Name of the customer being billed for the items in the shipment.
BillToCustomerNumber String Customer number for the bill-to party, ensuring correct invoicing and payment processing.
BillToPartySiteId Long Unique identifier for the billing party site.
BillToPartySiteNumber String Number identifying the billing party site.
BillToContactId Long Unique identifier for the contact at the billing party.
BillToContact String Name of the contact at the billing party, used for communication about payment or billing issues.
BillToContactFirstName String First name of the contact at the billing party.
BillToContactLastName String Last name of the contact at the billing party.
BillToContactPhone String Phone number for the contact at the billing party.
BillToURL String URL for the billing party, providing further details about payment and invoicing.
BillToFax String Fax number for the billing party, ensuring a method for receiving invoicing communications.
BillToEmail String Email address for the contact at the billing party, ensuring communication about invoices and payment.
BillToLocationId Long Unique identifier for the billing location.
BillToAddress1 String First address line for the billing location.
BillToAddress2 String Second address line for the billing location.
BillToAddress3 String Third address line for the billing location.
BillToAddress4 String Fourth address line for the billing location.
BillToCity String City of the billing location.
BillToCounty String County of the billing location.
BillToPostalCode String Postal code for the billing location.
BillToRegion String Region for the billing location.
BillToState String State for the billing location.
BillToCountry String Country of the billing location.
Subinventory String Subinventory from which the items are picked, used to track item availability.
LocatorId Long Identifier for the locator where the item is stored within the subinventory.
Locator String Locator name within the subinventory for the item, helping identify its exact storage location.
ShippedQuantity Decimal Quantity of the item that has been shipped, tracking progress of the order fulfillment.
SecondaryShippedQuantity Decimal Secondary quantity of items shipped, often used for dual-unit measurement.
NetWeight Long Net weight of the shipment line, excluding packaging.
GrossWeight Long Gross weight of the shipment line, including packaging.
TareWeight Decimal Tare weight of the shipment, representing the weight of the packaging material.
WeightUOMCode String UOM code for the weight of the shipment line.
WeightUOM String UOM for the weight, such as kilograms or pounds.
Volume Long Volume of the shipment line, used for determining space and weight considerations.
VolumeUOMCode String Code for the UOM for the volume of the shipment.
VolumeUOM String UOM for the volume, such as cubic meters or liters.
LoadingSequence Long Sequence number indicating the order in which shipment lines should be loaded for transportation.
LotNumber String Lot number for the items being shipped, helping track the production batch.
EndAssemblyItemNumber String FindByLineAttributes Item number for the final assembly of the product, linking the shipment to a specific assembly process.
OrganizationId Long Unique identifier for the organization managing the shipment.
OrganizationCode String Code representing the organization handling the shipment.
OrganizationName String Name of the organization handling the shipment.
ParentPackingUnitId Long Unique identifier for the parent packing unit, used for organizing multiple packing units within the shipment.
ParentPackingUnit String FindByLineAttributes Name of the parent packing unit, linking the shipment line to a larger packaging unit.
ShipmentId Long Unique identifier for the shipment, used to track all associated shipment lines.
Shipment String FindByShipmentName Shipment identifier for reference and tracking across the shipping process.
ProjectSalesOrderFlag Bool Flag indicating whether the order is related to a project, useful for tracking project-based sales.
RcvShipmentLineId Long FindByLineAttributes Shipment line ID for receiving purposes, linking the shipment line to the receiving process.
LineStatusCode String Code indicating the current status of the shipment line, such as 'shipped', 'backordered', or 'pending'.
LineStatus String FindByLineAttributes Descriptive name for the status of the shipment line, providing clarity on its current state.
TrackingNumber String Tracking number for the shipment, enabling visibility into the shipment's progress during transport.
SealNumber String Seal number used to secure the shipment, ensuring safety and integrity during transport.
PickWaveId Long Pick wave ID associated with the shipment line, helping coordinate the picking process in the warehouse.
PickWave String FindByLineAttributes Identifier for the pick wave, used to organize and optimize the warehouse picking process.
SourceOrderId Long Unique identifier for the source order associated with the shipment line.
SourceOrder String FindByLineAttributes Reference to the source order linked to the shipment line.
SourceOrderLineId Long Line ID from the source order that corresponds to the shipment line.
SourceOrderLine String FindByLineAttributes The order line from the source order that is being shipped.
SourceOrderFulfillmentLineId Int FindByFulfillmentLineId Identifier for the fulfillment line associated with the source order, tracking its processing.
SourceOrderFulfillmentLine String FindByLineAttributes Fulfillment line number for the source order, linking the shipment line to a specific fulfillment task.
TaxationCountryCode String Country code for taxation purposes, ensuring compliance with local tax laws.
TaxationCountry String Full name of the country for tax calculation purposes.
FirstPartyTaxRegistrationId Long Tax registration ID for the first party involved in the transaction, ensuring tax compliance.
FirstPartyTaxRegistrationNumber String Tax registration number for the first party, verifying tax compliance.
ThirdPartyTaxRegistrationId Long Tax registration ID for the third party, ensuring tax responsibilities are met for indirect parties.
ThirdPartyTaxRegistrationNumber String Tax registration number for the third party.
LocationOfFinalDischargeId Long Identifier for the location where the shipment will be discharged, crucial for transportation planning.
LocationOfFinalDischargeCode String Code for the final discharge location, indicating where the shipment will be offloaded.
LocationOfFinalDischarge String Name or description of the final discharge location, ensuring clarity about the destination.
DocumentFiscalClassificationCode String Fiscal classification code used for the shipment line to categorize taxes and duties.
DocumentFiscalClassification String Name of the fiscal classification used for tax purposes, ensuring the correct tax treatment.
TransactionBusinessCategoryCode String Business category code used to classify the transaction for fiscal and compliance reporting.
TransactionBusinessCategory String Descriptive name for the transaction's business category, providing insight into its classification.
UserDefinedFiscalClassificationCode String Custom fiscal classification code used to meet specific tax requirements not covered by standard classifications.
UserDefinedFiscalClassification String User-defined classification for tax purposes, providing flexibility for unique fiscal needs.
TaxInvoiceNumber String Tax invoice number for the shipment line, used for tax reporting and compliance.
TaxInvoiceDate Date Date the tax invoice was issued for the shipment line.
ProductCategoryCode String Code for the product category of the items being shipped, used for classification and tax reporting.
ProductCategory String Name of the product category for the shipment, ensuring proper categorization for tax and reporting.
IntendedUseClassificationId Decimal Identifier for the classification of the intended use of the product.
IntendedUse String Description of the intended use of the product being shipped.
ProductTypeCode String Code representing the type of product being shipped.
ProductType String Description of the product type, ensuring the proper categorization and handling of the shipment.
AssessableValue Decimal Assessable value for tax purposes, representing the deemed value of the goods as defined by tax authorities.
TaxClassificationCode String Tax classification code for the shipment, used for determining the appropriate taxes to be applied.
TaxClassification String Name of the tax classification for the shipment, ensuring proper tax treatment.
TaxExemptionCertificateNumber String Certificate number for tax exemption, ensuring compliance with applicable tax laws.
TaxExemptionReasonCode String Code identifying the reason for tax exemption, used for compliance reporting.
TaxExemptionReason String Description of the reason for the tax exemption.
ProductFiscalClassificationId Long ID for the fiscal classification of the product for tax purposes.
ProductFiscalClassification String Fiscal classification for the product, ensuring tax compliance and proper categorization.
TransportationPlanningStatusCode String Code representing the transportation planning status for the shipment line.
TransportationPlanningStatus String FindByLineAttributes Descriptive name for the transportation planning status, indicating whether the shipment is scheduled, pending, or in progress.
TransportationPlanningDate Datetime Date when the transportation planning was last updated or processed for the shipment line.
TransportationShipment String Identifier for the transportation shipment, linking the shipment line to transportation details.
TransportationShipmentLine String Identifier for the transportation shipment line, linking the shipment line to a specific transportation line item.
InitialDestinationId Long Unique identifier for the initial destination in the transportation route for the shipment.
InitialDestination String Description of the initial destination for the shipment.
TradeComplianceStatusCode String Code representing the trade compliance status for the shipment line, ensuring adherence to international trade regulations.
TradeComplianceStatus String FindByLineAttributes Descriptive name of the trade compliance status, providing insight into whether the shipment line has been cleared for export.
TradeComplianceDate Datetime Date when the trade compliance status was last updated for the shipment line.
TradeComplianceReason String Reason for the trade compliance status, providing context for any delays or issues.
TradeComplianceScreeningMethodCode String Code representing the method used for trade compliance screening.
TradeComplianceScreeningMethod String Description of the trade compliance screening method, ensuring clarity on how the shipment's trade compliance was verified.
ShipFromLocationId Long Unique identifier for the location from where the shipment is being sent, ensuring the origin of the goods is clear.
ShipFromAddress1 String Primary address line for the shipping origin location.
ShipFromAddress2 String Secondary address line for the shipping origin location.
ShipFromAddress3 String Tertiary address line for the shipping origin location.
ShipFromAddress4 String Final address line for the shipping origin location.
ShipFromCity String City where the shipment originates, used for routing and logistics.
ShipFromCounty String County or district where the shipment originates.
ShipFromPostalCode String Postal code for the shipping origin location.
ShipFromRegion String Region or state where the shipment originates.
ShipFromState String State of origin for the shipment.
ShipFromCountry String Country of origin for the shipment.
MaximumOvershipmentPercentage Long Maximum allowable overshipment percentage for the shipment line, defining the acceptable margin above the requested quantity.
MaximumUndershipmentPercentage Long Maximum allowable undershipment percentage for the shipment line, defining the acceptable margin below the requested quantity.
SourceRequestedQuantity Decimal Requested quantity for the item on the source order, helping track order fulfillment.
SourceRequestedQuantityUOMCode String Code for the UOM of the requested quantity from the source order.
SourceRequestedQuantityUOM String UOM for the requested quantity from the source order.
SecondarySourceRequestedQuantity Decimal Secondary requested quantity from the source order, used for dual-unit measures or special cases.
SecondarySourceRequestedQuantityUOMCode String UOM code for the secondary requested quantity.
SecondarySourceRequestedQuantityUOM String UOM for the secondary requested quantity.
DeliveredQuantity Decimal Quantity of the item that has been delivered for the shipment line.
SecondaryDeliveredQuantity Decimal Secondary quantity of the item delivered, used for dual-unit systems.
CancelledQuantity Decimal Quantity of the item that has been cancelled from the shipment.
SecondaryCancelledQuantity Decimal Secondary quantity of the item cancelled from the shipment.
BackorderedQuantity Decimal Quantity of the item that is on backorder, awaiting fulfillment.
SecondaryBackorderedQuantity Decimal Secondary backordered quantity, used for dual-unit measures or items with different units of measurement.
PickedQuantity Decimal Quantity of the item that has been picked from the warehouse for the shipment.
SecondaryPickedQuantity Decimal Secondary picked quantity, used for dual-unit measures.
ConvertedQuantity Decimal Converted quantity of the item, often used when quantities are converted between different units of measure.
SecondaryConvertedQuantity Decimal Secondary converted quantity, used for dual-unit conversions.
StagedQuantity Decimal Quantity of the item that has been staged for shipment, ready to be sent.
SecondaryStagedQuantity Decimal Secondary staged quantity, used for dual-unit systems.
PendingQuantity Decimal Quantity of the item that is still pending shipment or processing.
PendingQuantityFlag Bool Flag indicating whether the shipment line has a pending quantity that needs to be processed.
CreationDate Datetime Date when the shipment line was created in the system.
CreatedBy String User who created the shipment line entry, ensuring accountability and traceability.
LastUpdateDate Datetime Date when the shipment line was last updated.
LastUpdatedBy String User who last updated the shipment line, ensuring traceability of changes.
SplitFromShipmentLine Long Shipment line number from which this line was split, tracking changes to shipment lines.
SourceSubinventory String Subinventory from which the item is being sourced for shipment, ensuring correct stock levels are utilized.
CarrierId Long Unique identifier for the carrier responsible for shipping the items.
Carrier String Name of the carrier responsible for shipping the items.
CarrierNumber String Carrier reference number for the shipment, used for tracking purposes.
ModeOfTransportCode String Code representing the mode of transport for the shipment, such as 'air', 'sea', or 'ground'.
ModeOfTransport String Description of the mode of transport used for the shipment, helping identify the logistics method.
ServiceLevelCode String Code for the level of service selected for the shipment, such as 'overnight' or 'standard'.
ServiceLevel String Descriptive name for the level of service selected for the shipment.
ShippingMethodCode String Code representing the shipping method, such as 'express' or 'ground'.
ShippingMethod String Descriptive name for the shipping method, providing clarity on how the shipment will be handled.
SourceDocumentTypeId Long Unique identifier for the source document type from which the shipment line originates.
UnitWeight Long Weight per unit of the item being shipped, ensuring accurate weight calculations for transport.
UnitVolume Long Volume per unit of the item being shipped, important for calculating shipping costs based on volume.
LogisticsServiceProviderCustomerId Long Unique identifier for the logistics service provider customer associated with the shipment.
LogisticsServiceProviderCustomer String Name of the logistics service provider customer associated with the shipment.
LogisticsServiceProviderCustomerNumber String Customer number for the logistics service provider.
SourceLineUpdateDate Datetime Date when the source order line was last updated.
SourceSystemId Long FindByFulfillmentLineId Unique identifier for the source system from which the shipment line originated.
SourceSystem String Name of the source system from which the shipment line was created.
ShipmentAdviceStatusFlag Bool Flag indicating whether the shipment has been advised to the customer.
DoNotShipBeforeDate Datetime Date before which the shipment should not be shipped, ensuring compliance with scheduling rules.
DoNotShipAfterDate Datetime Date after which the shipment should not be shipped, ensuring compliance with scheduling deadlines.
IntegrationStatusCode String Code representing the current integration status for the shipment line.
IntegrationStatus String FindByLineAttributes Description of the current integration status, indicating whether the shipment line is fully integrated.
QuickShipStatus String FindByLineAttributes Status of the quick ship process, indicating whether the shipment qualifies for expedited processing.
BusinessUnitId Long Unique identifier for the business unit handling the shipment line.
BusinessUnit String Name of the business unit responsible for processing the shipment.
LegalEntityId Long Legal entity ID associated with the shipment, ensuring legal compliance in different jurisdictions.
LegalEntity String Name of the legal entity responsible for the shipment.
POHeaderId Long Unique identifier for the purchase order header related to the shipment line.
PONumber String Purchase order number associated with the shipment line, linking it to a specific purchase order.
POBillToBusinessUnitId Long Business unit ID for the billing address associated with the purchase order.
POBillToBusinessUnit String Name of the business unit responsible for billing associated with the purchase order.
POSoldToLegalEntityId Long Legal entity ID for the sold-to customer on the purchase order.
POSoldToLegalEntity String Name of the legal entity for the sold-to customer.
ConversionTypeCode String Code for the type of conversion applied to the shipment line.
ConversionDate Date Date on which the conversion was performed for the shipment line.
ConversionRate Double Rate at which the quantity was converted for the shipment line.
ParentItemId Long Unique identifier for the parent item associated with the shipment line.
ParentItem String Name or identifier for the parent item of the shipment line.
ParentItemDescription String Description of the parent item for the shipment line.
ParentSourceOrderFulfillmentLineId Long ID of the parent source order fulfillment line, indicating the origin of the shipment line.
BaseItemId Long ID for the base item associated with the shipment line.
BaseItem String FindByLineAttributes Identifier for the base item of the shipment line.
BaseItemDescription String Description of the base item for the shipment line.
SrcAttributeCategory String Category of attributes applied to the source item in the shipment.
SrcAttribute1 String Attribute 1 for the source item in the shipment, used for categorizing or classifying.
SrcAttribute2 String Attribute 2 for the source item.
SrcAttribute3 String Attribute 3 for the source item.
SrcAttribute4 String Attribute 4 for the source item.
SrcAttribute5 String Attribute 5 for the source item.
SrcAttribute6 String Attribute 6 for the source item.
SrcAttribute7 String Attribute 7 for the source item.
SrcAttribute8 String Attribute 8 for the source item.
SrcAttribute9 String Attribute 9 for the source item.
SrcAttribute10 String Attribute 10 for the source item.
SrcAttribute11 String Attribute 11 for the source item.
SrcAttribute12 String Attribute 12 for the source item.
SrcAttribute13 String Attribute 13 for the source item.
SrcAttribute14 String Attribute 14 for the source item.
SrcAttribute15 String Attribute 15 for the source item.
SrcAttribute16 String Attribute 16 for the source item.
SrcAttribute17 String Attribute 17 for the source item.
SrcAttribute18 String Attribute 18 for the source item.
SrcAttribute19 String Attribute 19 for the source item.
SrcAttribute20 String Attribute 20 for the source item.
SrcAttributeDate1 Date Date attribute 1 for the source item.
SrcAttributeDate2 Date Date attribute 2 for the source item.
SrcAttributeDate3 Date Date attribute 3 for the source item.
SrcAttributeDate4 Date Date attribute 4 for the source item.
SrcAttributeDate5 Date Date attribute 5 for the source item.
SrcAttributeNumber1 Decimal Numeric attribute 1 for the source item.
SrcAttributeNumber2 Decimal Numeric attribute 2 for the source item.
SrcAttributeNumber3 Decimal Numeric attribute 3 for the source item.
SrcAttributeNumber4 Decimal Numeric attribute 4 for the source item.
SrcAttributeNumber5 Decimal Numeric attribute 5 for the source item.
SrcAttributeNumber6 Decimal Numeric attribute 6 for the source item.
SrcAttributeNumber7 Decimal Numeric attribute 7 for the source item.
SrcAttributeNumber8 Decimal Numeric attribute 8 for the source item.
SrcAttributeNumber9 Decimal Numeric attribute 9 for the source item.
SrcAttributeNumber10 Decimal Numeric attribute 10 for the source item.
SrcAttributeTimestamp1 Datetime Timestamp attribute 1 for the source item.
SrcAttributeTimestamp2 Datetime Timestamp attribute 2 for the source item.
SrcAttributeTimestamp3 Datetime Timestamp attribute 3 for the source item.
SrcAttributeTimestamp4 Datetime Timestamp attribute 4 for the source item.
SrcAttributeTimestamp5 Datetime Timestamp attribute 5 for the source item.
TransportationShipmentFromEvent String Transportation shipment information from the event, helping track the shipment's initial event and process.
TransportationShipmentLineFromEvent String Transportation shipment line information from the event, used to track each individual shipment line's event details.
TransportationShipmentCompleteFromEvent String Completion status for the transportation shipment from the event.
TradeComplianceScreenedFromEvent String Trade compliance screening status from the event.
CurrentBackorderedQuantityFromEvent Decimal Current backordered quantity from the event, ensuring accurate backorder tracking.
OriginalShipmentLineFromEvent Long Original shipment line number from the event, providing traceability to the initial shipment line.
ProjectCostingProjectId Long Project costing project ID associated with the shipment line.
ProjectCostingProjectNumber String Project costing project number associated with the shipment line.
ProjectCostingProjectName String Project costing project name associated with the shipment line.
ProjectCostingTaskId Long Project costing task ID associated with the shipment line.
ProjectCostingTaskNumber String Project costing task number associated with the shipment line.
ProjectCostingTaskName String Project costing task name associated with the shipment line.
OverShipTolerancePercentage Decimal Tolerance percentage for overshipment, helping manage and track allowable overshipments.
UnderShipTolerancePercentage Decimal Tolerance percentage for undershipment, ensuring that undershipments are within acceptable limits.
ShippingToleranceBehavior String Behavior defined for shipping tolerance, determining whether the system allows for adjustments based on shipment discrepancies.
ConvertedRequestedQuantity Decimal Converted requested quantity, reflecting adjustments made during the order fulfillment process.
LineNetWeight Decimal Net weight of the shipment line, excluding packaging, for accurate logistics and reporting.
LineGrossWeight Decimal Gross weight of the shipment line, including packaging, for shipment management.
SupplierLotNumber String Lot number from the supplier, linking the shipment line to the supplier's original lot of goods.
MovementRequestLineId Long Movement request line ID, used to track internal movement requests for items associated with the shipment.
AllowItemSubstitutionFlag Bool Flag indicating whether item substitution is allowed for the shipment line.
OriginalItemId Long Original item identifier for the shipment line, used for traceability when item substitutions or changes occur.
OriginalItemNumber String Original item number for the shipment line, providing reference to the initial item ordered.
OriginalDeliveryDetailId Long Original delivery detail identifier for the shipment line, ensuring accurate tracing of changes made.
OriginalItemConvertedQuantity Decimal Quantity of the original item converted for the shipment line, allowing for tracking of modified quantities.
DestinationOrganizationCode String Code for the destination organization of the shipment, ensuring that the correct organization handles the delivery.
LineUnitPrice Decimal Unit price of the item for the shipment line, reflecting the base price before any adjustments or discounts.
LineUnitVolume Decimal Volume per unit of the item for the shipment line, used for space allocation during transportation.
LineVolume Decimal Total volume for the shipment line, helping manage logistics and space planning.
LineUnitWeight Decimal Weight per unit of the item in the shipment line.
LineSellingPrice Decimal Selling price for the shipment line item, representing the price charged to the customer.
OriginalSourceOrderFulfillmentLineId Long Original fulfillment line ID for the source order, tracing the fulfillment process.
OriginalSourceOrderFulfillmentLine String Source order fulfillment line number for the shipment, used for order fulfillment tracking.
EnforceSingleShipment String Flag indicating whether the shipment line should be handled as part of a single shipment for the order.
CancelBackorders String Flag indicating whether backorders for the shipment line should be canceled.
DeliveryId Long PrimaryKey Unique identifier for the delivery associated with the shipment line.
Finder String Finder identifier, used to quickly locate shipment line details.
OrderNumber String FindByLineAttributes Order number associated with the shipment line, linking it back to the originating order.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770