CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ShipmentLines

Handles details for shipment lines, including search and retrieval based on attributes like order type, status, and reservations.

Columns

Name Type Description
ShipmentLine [KEY] Long The unique identifier for each shipment line within the shipment table.
OrderTypeCode String The code representing the order type for this shipment line, used to categorize the order (for example, standard, expedited).
OrderType String The specific type of order this shipment line belongs to, such as a regular or backorder.
Order String The order number associated with the shipment line, typically referencing the customer’s purchase order.
OrderLine String The line number within the order, used to track specific items or quantities in an order.
OrderSchedule String The schedule or expected delivery date associated with the order line.
InventoryItemId Long The unique identifier for the inventory item that is being shipped in this shipment line.
Item String The item number assigned to the product being shipped, used for tracking and identification purposes.
ItemDescription String A description of the item, providing additional details about the product being shipped.
Revision String The revision number of the item, typically used to track different versions of the product.
UnitPrice Long The price per unit of the item being shipped, typically in the base currency for the organization.
SellingPrice Long The price at which the item is sold, which may include any additional costs such as handling or delivery fees.
RequestedQuantity Decimal The quantity of the item requested to be shipped, as specified by the customer on their order.
RequestedQuantityUOMCode String The unit of measure (UOM) code for the requested quantity (for example, each, kg, lb).
RequestedQuantityUOM String The full UOM for the requested quantity (for example, each, kilograms, pounds).
SecondaryRequestedQuantity Decimal The secondary quantity requested, usually used for items with dual UOM settings (for example, weight or volume).
SecondaryRequestedQuantityUOMCode String The UOM code for the secondary requested quantity.
SecondaryRequestedQuantityUOM String The full UOM for the secondary requested quantity.
FOBCode String The code that specifies the terms of delivery (for example, Free On Board), which determines when the responsibility for the item transfers.
FOB String The term of delivery indicating the point at which the item ownership is transferred, typically including shipping and handling terms.
FreightTermsCode String The code used to specify the terms for freight or shipping, which can determine who pays for freight costs.
FreightTerms String The description or name of the freight terms, which specify whether the buyer or seller pays for shipping costs.
ShippingPriorityCode String A code used to categorize the urgency of the shipment, impacting delivery methods or timelines.
ShippingPriority String The description of the shipping priority (for example, High, Medium, Low), determining how urgently the item should be shipped.
PreferredGrade String The preferred grade of the item, which could refer to quality standards or customer preferences for the product.
PreferredGradeName String The full name or description of the preferred grade of the item.
CurrencyCode String The currency code used for pricing and charges related to this shipment line (for example, USD, EUR).
CurrencyName String The full name of the currency used for pricing (for example, USD, EUR).
ShipmentSet String A grouping identifier for shipment lines that are part of the same shipment batch or set.
ArrivalSet String A grouping identifier for items within the shipment that should arrive together.
CustomerPONumber String The customer's purchase order number associated with the shipment line.
CustomerItemId Long The unique identifier of the item as assigned by the customer, for reference or tracking purposes.
CustomerItem String The item number assigned by the customer, typically for inventory or order tracking.
CustomerItemDescription String A description of the item as identified by the customer, providing context about the product.
RequestedDate Datetime The date the customer requested the shipment or delivery to occur.
ScheduledShipDate Datetime The date scheduled for the item to be shipped, often determined by the fulfillment process.
RequestedDateTypeCode String The code specifying the type of requested date, such as delivery date or ship date.
RequestedDateType String A description of the type of requested date, clarifying whether it's for shipping or delivery.
ShipToPartyId Long The unique identifier for the party (customer or recipient) to whom the item is being shipped.
ShipToCustomer String The name of the customer or recipient receiving the shipment.
ShipToCustomerNumber String The unique identifier for the customer receiving the shipment, typically used in the system for tracking.
ShipToPartySiteId Long The unique identifier for the site (address or location) where the item is to be shipped.
ShipToPartySiteNumber String The site number used for identifying the specific location within the party's address.
ShipToContactId Long The identifier for the contact person at the delivery location, used for communication or delivery coordination.
ShipToContact String The full name of the contact person at the delivery site.
ShipToContactFirstName String The first name of the contact person at the delivery site.
ShipToContactLastName String The last name of the contact person at the delivery site.
ShipToContactPhone String The phone number of the contact person at the delivery site, used for coordination or issues during delivery.
ShipToURL String The URL or website associated with the contact or delivery site.
ShipToFax String The fax number for the contact person at the shipping destination.
ShipToEmail String The email address of the contact person at the shipping destination.
ShipToLocationId Long The location ID used to uniquely identify the place where the shipment will be delivered.
ShipToLocationType String The type of location for the delivery, such as a warehouse, retail store, or residential address.
ShipToAddress1 String The first line of the shipping address for the destination, typically including street or building number.
ShipToAddress2 String The second line of the shipping address, often used for apartment numbers or additional address details.
ShipToAddress3 String The third line of the shipping address, used for extended address information if necessary.
ShipToAddress4 String The fourth line of the shipping address, typically used for additional address details in specific cases.
ShipToCity String The city of the shipping address where the item is to be delivered.
ShipToCounty String The county of the shipping address where the item is to be delivered.
ShipToPostalCode String The postal code (ZIP code) for the shipping address, used for mail sorting and delivery.
ShipToRegion String The region or area within the country for the shipping address (for example, state or province).
ShipToState String The state or province associated with the shipping address, providing a more specific geographic location.
ShipToCountry String The country of the shipping address, used to identify international or domestic deliveries.
SoldToPartyId Long The unique identifier for the party (typically the customer) who purchased the item being shipped.
SoldToCustomer String The name of the customer who made the purchase and is associated with the sold-to party.
SoldToCustomerNumber String The unique identifier for the customer who made the purchase, typically used for billing or order tracking.
Supplier String The supplier or vendor providing the items for shipment, often used for tracking sourcing details.
SupplierPartyNumber String The supplier's internal party number used for identification and reference in the system.
SoldToContactId Long The identifier for the contact person at the sold-to party, used for communication regarding the shipment.
SoldToContact String The name of the contact person at the sold-to party.
SoldToContactFirstName String The first name of the contact person at the sold-to party.
SoldToContactLastName String The last name of the contact person at the sold-to party.
SoldToContactPhone String The phone number for the contact person at the sold-to party.
SoldToURL String The URL associated with the sold-to party, potentially for online customer portals or communications.
SoldToFax String The fax number for the contact person at the sold-to party.
SoldToEmail String The email address for the contact person at the sold-to party.
BillToPartyId Long The unique identifier for the party responsible for paying for the goods or services.
BillToCustomer String The name of the customer associated with the billing party.
BillToCustomerNumber String The unique customer number assigned to the billing party for invoicing and payment purposes.
BillToPartySiteId Long The unique identifier for the site (location) where the billing information is processed or managed.
BillToPartySiteNumber String The party site number used for identifying the specific location within the billing party's records.
BillToContactId Long The identifier for the contact person responsible for handling billing-related communication.
BillToContact String The name of the contact person for billing inquiries at the bill-to party.
BillToContactFirstName String The first name of the contact person responsible for billing inquiries.
BillToContactLastName String The last name of the contact person responsible for billing inquiries.
BillToContactPhone String The phone number of the contact person for billing-related questions or issues.
BillToURL String The URL associated with the billing party, possibly for online payments or billing-related communications.
BillToFax String The fax number for sending billing-related documents to the bill-to contact.
BillToEmail String The email address for the billing contact, used for invoices and communication.
BillToLocationId Long The location ID used to uniquely identify where billing information is stored or processed.
BillToAddress1 String The first line of the billing address, typically including street or building number.
BillToAddress2 String The second line of the billing address, often used for apartment numbers or additional address details.
BillToAddress3 String The third line of the billing address, used for extended address details if necessary.
BillToAddress4 String The fourth line of the billing address, typically used for additional details in specific cases.
BillToCity String The city of the billing address, where the customer is registered or where invoices are sent.
BillToCounty String The county or region associated with the billing address.
BillToPostalCode String The postal code (ZIP code) for the billing address.
BillToRegion String The region or area within the country for the billing address (for example, state or province).
BillToState String The state or province associated with the billing address.
BillToCountry String The country for the billing address, used to determine the geographical location of the bill-to party.
Subinventory String The subinventory within the warehouse where the inventory for this shipment line is stored.
LocatorId Long The identifier for the specific location within the subinventory where the inventory item is found.
Locator String The locator name or code used to pinpoint the exact physical location of the item in the warehouse or storage.
ShippedQuantity Decimal The quantity of the item actually shipped as part of this shipment line.
SecondaryShippedQuantity Decimal The secondary quantity of the item shipped, used when multiple units of measure are involved (for example, weight or volume).
NetWeight Long The total weight of the shipped items in this line, excluding packaging, measured in the unit of weight (for example, kilograms or pounds).
GrossWeight Long The total weight of the shipment including the items and the packaging material, measured in the unit of weight (for example, kilograms or pounds).
TareWeight Decimal The weight of the packaging material for the shipment, without the items, measured in the unit of weight.
WeightUOMCode String The code used to define the UOM for the weight (for example, KG for kilograms, LB for pounds).
WeightUOM String The UOM for weight, providing context on whether the weight is in kilograms, pounds, or other weight units.
Volume Long The total volume of the shipment line, typically representing the space the items occupy in the shipping container or pallet, measured in cubic units.
VolumeUOMCode String The UOM code for the volume, indicating the system used (for example, CM for cubic meters, FT3 for cubic feet).
VolumeUOM String The UOM for volume, such as cubic meters or cubic feet, used to describe the space occupied by the shipment.
LoadingSequence Long The order in which the shipment lines are to be loaded into the transport vehicle, typically based on size, weight, or priority.
LotNumber String The lot number assigned to a batch of items that were manufactured or processed together, used for inventory tracking and quality control.
EndAssemblyItemNumber String The item number of the end assembly product, if this shipment line involves the delivery of a finished product from subassemblies.
OrganizationId Long The unique identifier for the organization responsible for managing the shipment line within the company.
OrganizationCode String The code used to identify the organization within the company’s system, helping to classify and track shipments.
OrganizationName String The name of the organization that is responsible for managing this shipment line.
ParentPackingUnitId Long The unique identifier for the parent packing unit under which this shipment line is grouped, often used for bulk or multi-item shipments.
ParentPackingUnit String The identifier or description for the parent packing unit, indicating if this line is part of a larger unit (for example, carton, pallet).
ShipmentId Long The unique identifier for the shipment, used to track the entire shipment process across various systems.
Shipment String The shipment number or identifier assigned to the specific shipping event, used for tracking and reference purposes.
ProjectSalesOrderFlag Bool A flag indicating whether the shipment line is related to a project sales order, distinguishing it from regular sales orders.
RcvShipmentLineId Long The unique identifier for the shipment line within the receiving system, helping to track the goods once they arrive at the destination.
LineStatusCode String The status code for the shipment line, indicating its current state in the shipping or delivery process (for example, shipped, pending, cancelled).
LineStatus String The descriptive status of the shipment line, providing context to the current state such as 'shipped,' 'in transit,' or 'delivered.'
TrackingNumber String The tracking number assigned by the carrier for the shipment, used to monitor the movement of goods from dispatch to delivery.
SealNumber String The seal number assigned to the shipment container, ensuring the integrity of the shipment during transit and storage.
PickWaveId Long The unique identifier for the pick wave, which groups together shipments or items for picking during the fulfillment process.
PickWave String The code or name assigned to a pick wave, helping to track and manage the grouping of items for fulfillment.
SourceOrderId Long The identifier for the original order from which this shipment line is derived, linking it back to the initial order request.
SourceOrder String The order number or identifier from the originating sales or fulfillment order that this shipment line is part of.
SourceOrderLineId Long The specific line item identifier from the source order that this shipment line corresponds to.
SourceOrderLine String The line number or identifier from the source order, providing the specific product or item being shipped.
SourceOrderFulfillmentLineId Int The unique identifier for the fulfillment line in the source order, helping to track specific fulfillments related to the shipment.
SourceOrderFulfillmentLine String The description or identifier for the fulfillment line in the source order, showing which product is being shipped from the order.
TaxationCountryCode String The country code used for tax purposes, indicating the country where the goods are being shipped or where the tax rules apply.
TaxationCountry String The name of the country used for taxation, helping to apply correct tax rates based on the delivery or shipping location.
FirstPartyTaxRegistrationId Long The unique identifier for the first party’s tax registration, often linked to the billing or selling party in the shipment.
FirstPartyTaxRegistrationNumber String The tax registration number assigned to the first party for tax reporting and legal purposes.
ThirdPartyTaxRegistrationId Long The unique identifier for the third party’s tax registration, typically relevant when third-party vendors or service providers are involved.
ThirdPartyTaxRegistrationNumber String The tax registration number for the third party, needed for tax reporting purposes when a third-party is handling shipments or taxes.
LocationOfFinalDischargeId Long The unique identifier for the final discharge location of the shipment, which specifies where the goods are delivered or unloaded.
LocationOfFinalDischargeCode String The code used to represent the final discharge location, aiding in the classification and tracking of delivery destinations.
LocationOfFinalDischarge String The full name or description of the final discharge location, providing details about where the shipment will be unloaded.
DocumentFiscalClassificationCode String The code used for fiscal classification of the shipment document, helping to categorize goods for taxation and customs purposes.
DocumentFiscalClassification String The fiscal classification associated with the shipment document, providing context for customs, duty, and tax calculations.
TransactionBusinessCategoryCode String The code identifying the business category for the transaction, used for classifying the nature of the shipment (for example, sale, return, exchange).
TransactionBusinessCategory String The descriptive category of the business transaction, helping categorize the shipment based on its commercial purpose (for example, sale, return, exchange).
UserDefinedFiscalClassificationCode String A custom code used for fiscal classification that may be specific to a business's unique processes or tax requirements.
UserDefinedFiscalClassification String A user-defined description for fiscal classification, providing flexibility to adapt to specific tax categories or business rules.
TaxInvoiceNumber String The unique identifier for the tax invoice associated with the shipment, used for tax reporting and legal documentation purposes.
TaxInvoiceDate Date The date the tax invoice was issued, which is essential for determining the timing of tax obligations and compliance reporting.
ProductCategoryCode String The code used to categorize the type of product being shipped, helping streamline logistics and inventory management.
ProductCategory String The category or classification of the product being shipped, providing context for managing products and understanding their commercial use.
IntendedUseClassificationId Decimal The identifier for the intended use classification of the products in the shipment, ensuring proper categorization for compliance and reporting.
IntendedUse String The intended use description for the product, helping determine how the item is used and ensuring it meets legal and compliance standards.
ProductTypeCode String The code assigned to the product type, aiding in the classification of goods and aligning them with the appropriate shipping or tax classifications.
ProductType String The product type description, which classifies goods based on their commercial or industrial type, influencing shipping and handling procedures.
AssessableValue Decimal The value assigned to the goods for assessment purposes, typically for customs or taxation, representing the taxable value of the shipment.
TaxClassificationCode String The code used to classify the shipment for tax purposes, helping apply the correct tax rates based on the product and shipping destination.
TaxClassification String The descriptive classification of the shipment’s tax status, determining the tax rate and any applicable exemptions based on the product and location.
TaxExemptionCertificateNumber String The number of the tax exemption certificate provided for the shipment, indicating that the goods are exempt from certain taxes.
TaxExemptionReasonCode String The code identifying the reason for tax exemption, explaining why the shipment is exempt from taxes under specific legal conditions.
TaxExemptionReason String The description of why the goods in the shipment are tax-exempt, used for documentation and compliance with tax regulations.
ProductFiscalClassificationId Long The unique identifier for the product fiscal classification, which helps assign the correct tax treatment based on the fiscal classification of the goods.
ProductFiscalClassification String The description of the fiscal classification for the product, used to determine the appropriate tax rates and legal treatment for the shipment.
TransportationPlanningStatusCode String The code representing the current status of transportation planning for the shipment, indicating progress in shipment preparation.
TransportationPlanningStatus String The descriptive status of transportation planning, showing whether the shipment is in the preparation, transit, or completed phase.
TransportationPlanningDate Datetime The date when transportation planning was completed or scheduled for the shipment, helping track logistics timelines.
TransportationShipment String The identifier or number assigned to the transportation shipment, used to track the progress and status of goods in transit.
TransportationShipmentLine String The line identifier for the transportation shipment, representing a specific item or group of items within the broader shipment.
InitialDestinationId Long The unique identifier for the initial destination of the shipment, specifying the first intended delivery location.
InitialDestination String The description of the initial destination for the shipment, indicating the location where the goods are first intended to be delivered.
TradeComplianceStatusCode String The code used to indicate the trade compliance status of the shipment, showing whether the shipment meets all legal and regulatory requirements.
TradeComplianceStatus String The descriptive status of the trade compliance process, indicating whether the shipment has passed all necessary legal checks for export or import.
TradeComplianceDate Datetime The date when trade compliance was verified or completed, ensuring that the shipment complies with all international trade laws.
TradeComplianceReason String The reason for any non-compliance or delay in the trade compliance process, explaining issues that need resolution for shipment clearance.
TradeComplianceScreeningMethodCode String The code indicating the method used for trade compliance screening, which determines how shipments are assessed for legal compliance.
TradeComplianceScreeningMethod String The description of the screening method used for assessing the shipment’s compliance with trade laws and regulations.
ShipFromLocationId Long The unique identifier for the location from which the shipment is dispatched, used for tracking and logistical purposes.
ShipFromAddress1 String The first line of the shipping address from where the goods are being dispatched, providing location-specific details.
ShipFromAddress2 String The second line of the shipping address from where the goods are being dispatched, used to complete the full address.
ShipFromAddress3 String The third line of the shipping address from where the goods are being dispatched, providing further location detail if needed.
ShipFromAddress4 String The fourth line of the shipping address from where the goods are being dispatched, used to provide additional address information.
ShipFromCity String The city of the shipping origin, specifying the urban area where the shipment is being dispatched from.
ShipFromCounty String The county of the shipping origin, detailing the broader administrative region from which the goods are being dispatched.
ShipFromPostalCode String The postal code of the shipping origin, used to identify the area for shipping logistics and delivery purposes.
ShipFromRegion String The region of the shipping origin, which may include broader geographic details such as state or province.
ShipFromState String The state or province from where the shipment originates, used for location-specific regulations and delivery coordination.
ShipFromCountry String The country from which the shipment is being dispatched, essential for international shipping and customs processes.
MaximumOvershipmentPercentage Long The maximum allowed percentage by which a shipment can exceed the requested quantity without requiring special approval or adjustments.
MaximumUndershipmentPercentage Long The maximum allowed percentage by which a shipment can fall short of the requested quantity without requiring special approval or adjustments.
SourceRequestedQuantity Decimal The quantity of goods requested for shipment as indicated by the source document or order, used for inventory and shipment planning.
SourceRequestedQuantityUOMCode String The UOM code for the requested quantity, specifying the measurement units used (for example, units, kilograms).
SourceRequestedQuantityUOM String The UOM description for the requested quantity, ensuring clarity in the type of measurement (for example, kg, box, unit).
SecondarySourceRequestedQuantity Decimal The secondary requested quantity for the shipment, typically used in cases where dual units of measure are involved (for example, kilograms and units).
SecondarySourceRequestedQuantityUOMCode String The UOM code for the secondary requested quantity, used in dual-unit shipments to specify additional measurements.
SecondarySourceRequestedQuantityUOM String The UOM description for the secondary requested quantity, further detailing the additional measurement type (for example, liters, meters).
DeliveredQuantity Decimal The quantity of goods actually delivered in the shipment, used to track discrepancies between requested and delivered amounts.
SecondaryDeliveredQuantity Decimal The secondary delivered quantity for the shipment, used when multiple units of measure are involved (for example, weight and volume).
CancelledQuantity Decimal The quantity of goods in the shipment that have been cancelled, used for adjustments and inventory management.
SecondaryCancelledQuantity Decimal The secondary cancelled quantity for the shipment, relevant when dual units of measure are used and some units are cancelled.
BackorderedQuantity Decimal The quantity of goods that could not be fulfilled and are placed on backorder, awaiting future delivery.
SecondaryBackorderedQuantity Decimal The secondary backordered quantity, relevant in cases where dual units of measure are used for backordered items.
PickedQuantity Decimal The quantity of goods picked from inventory for the shipment, used in warehouse management and order fulfillment tracking.
SecondaryPickedQuantity Decimal The secondary picked quantity, detailing the picked goods when multiple units of measure are used (for example, weight and number of units).
ConvertedQuantity Decimal The quantity of goods converted for shipment, typically used when items are re-measured or packed in different units of measure.
SecondaryConvertedQuantity Decimal The secondary converted quantity for goods being shipped, used in dual-UOM systems.
StagedQuantity Decimal The quantity of goods staged for shipment, indicating the goods that have been prepped but not yet shipped.
SecondaryStagedQuantity Decimal The secondary staged quantity, used when dual units of measure are involved for staging the shipment.
PendingQuantity Decimal The quantity of goods that are pending shipment, typically representing items that are in the process of being fulfilled.
PendingQuantityFlag Bool A flag indicating whether there is any pending quantity in the shipment that has not yet been fulfilled.
CreationDate Datetime The date and time when the shipment line was created, providing a timestamp for shipment record keeping.
CreatedBy String The user or system responsible for creating the shipment line, ensuring traceability and accountability in the system.
LastUpdateDate Datetime The date and time when the shipment line was last updated, used for audit purposes and tracking any modifications.
LastUpdatedBy String The user or system responsible for the most recent update to the shipment line, ensuring traceability for changes.
SplitFromShipmentLine Long The identifier of the shipment line from which the current shipment line has been split, used for managing changes in shipment volumes.
SourceSubinventory String The source subinventory from which the goods are being shipped, used in inventory management to specify which location the goods are picked from.
CarrierId Long The identifier for the carrier responsible for the shipment, used for tracking and coordination with third-party shipping providers.
Carrier String The name of the carrier responsible for transporting the shipment, providing clarity on the shipment’s logistics provider.
CarrierNumber String The carrier’s reference number for the shipment, used for tracking purposes and to identify the shipment in the carrier’s system.
ModeOfTransportCode String The code representing the mode of transport used for the shipment (for example, air, sea, land).
ModeOfTransport String The descriptive name of the mode of transport used for the shipment (for example, Air Freight, Ocean Shipping, Ground Transport).
ServiceLevelCode String The service level code representing the speed and type of delivery service selected for the shipment (for example, standard, expedited).
ServiceLevel String The description of the service level selected for the shipment, providing more context about the expected delivery time and service type.
ShippingMethodCode String The code identifying the shipping method used for the shipment, specifying how the goods are to be delivered.
ShippingMethod String The descriptive name of the shipping method used for the shipment (for example, Express, Standard Shipping, Same-Day Delivery).
SourceDocumentTypeId Long The identifier for the source document type that initiated the shipment, such as a sales order or purchase order.
UnitWeight Long The weight of a single unit of the item being shipped, important for calculating shipping costs and managing logistics.
UnitVolume Long The volume of a single unit of the item being shipped, which is critical for space optimization in shipping containers.
LogisticsServiceProviderCustomerId Long The identifier for the customer of the logistics service provider, used for managing and tracking logistics service relationships.
LogisticsServiceProviderCustomer String The name of the customer associated with the logistics service provider, allowing identification of customer accounts in logistics systems.
LogisticsServiceProviderCustomerNumber String The customer number assigned by the logistics service provider, used for identifying and tracking specific customer shipments.
SourceLineUpdateDate Datetime The date when the source line was last updated, helping track changes or modifications made to the originating order.
SourceSystemId Long The identifier for the source system where the shipment information was originally created or managed.
SourceSystem String The name or code for the source system, which might be an internal or external system managing shipment details.
ShipmentAdviceStatusFlag Bool A flag indicating whether the shipment advice has been completed, used to track the advice status in the shipment process.
DoNotShipBeforeDate Datetime The earliest date that the goods in the shipment can be shipped, typically used to handle specific timing or delay requirements.
DoNotShipAfterDate Datetime The latest date the shipment can be processed or delivered, often used for time-sensitive shipments.
IntegrationStatusCode String The code representing the integration status of the shipment, used for tracking whether the shipment has been successfully integrated with other systems.
IntegrationStatus String The descriptive status of the shipment integration, providing information about the current state of integration (for example, pending, completed).
QuickShipStatus String The status of the quick shipping process, indicating whether the shipment is being expedited or processed normally.
BusinessUnitId Long The identifier for the business unit responsible for the shipment, used for internal tracking and reporting within the organization.
BusinessUnit String The name of the business unit responsible for the shipment, used for organizational tracking and coordination.
LegalEntityId Long The identifier for the legal entity that owns or is responsible for the shipment, often used for accounting and legal purposes.
LegalEntity String The name of the legal entity responsible for the shipment, used for accounting, reporting, and legal identification.
POHeaderId Long The identifier for the purchase order header associated with the shipment, providing a link between the shipment and the original purchase order.
PONumber String The purchase order number associated with the shipment, used for order tracking and reporting.
POBillToBusinessUnitId Long The identifier for the business unit to which the billing for the purchase order is attributed.
POBillToBusinessUnit String The name of the business unit to which the billing for the purchase order is attributed, used for invoicing and financial purposes.
POSoldToLegalEntityId Long The identifier for the legal entity to which the sale in the purchase order is attributed.
POSoldToLegalEntity String The name of the legal entity to which the sale in the purchase order is attributed, often used for legal and accounting purposes.
ConversionTypeCode String The code identifying the type of conversion applied to the shipment, such as currency conversion or unit conversion.
ConversionDate Date The date on which the conversion (for example, currency or unit) was applied to the shipment, used for historical tracking.
ConversionRate Double The conversion rate used for changing the quantity or currency in the shipment, used for calculations and adjustments.
ParentItemId Long The identifier for the parent item in the shipment, indicating the parent-child relationship between items (for example, kits or sets).
ParentItem String The name of the parent item in the shipment, used to track and manage product relationships.
ParentItemDescription String The description of the parent item in the shipment, providing additional details about the item or product.
ParentSourceOrderFulfillmentLineId Long The identifier for the parent source order fulfillment line, used to track the parent-child relationship in order fulfillment.
BaseItemId Long The identifier for the base item associated with the shipment, often used for standardizing shipments or for tracking base model products.
BaseItem String The name of the base item associated with the shipment, used to link shipments with specific product categories.
BaseItemDescription String The description of the base item associated with the shipment, providing more context about the item or product being shipped.
SrcAttributeCategory String The category of the source attributes associated with the shipment, used for organizing and filtering shipment-related data.
SrcAttribute1 String A custom attribute for the shipment, allowing users to define additional characteristics or classifications for the shipment.
SrcAttribute2 String A custom attribute for the shipment, similar to SrcAttribute1 but offering more flexible categorization of shipment data.
SrcAttribute3 String A custom attribute for the shipment, designed for additional classifications or metadata that might be needed in the shipment process.
SrcAttribute4 String A custom attribute for the shipment, allowing for further classification and organization of shipment data.
SrcAttribute5 String A custom attribute for the shipment, allowing for additional flexibility in categorizing the shipment and its components.
SrcAttribute6 String A custom attribute for the shipment, designed for users who need to track unique characteristics of the shipment.
SrcAttribute7 String A custom attribute for the shipment, offering additional classification options for managing shipment data.
SrcAttribute8 String A custom attribute for the shipment, providing more ways to classify or categorize shipments for organizational or analytical purposes.
SrcAttribute9 String A custom attribute for the shipment, used for specific shipment details that are relevant to internal or external reporting.
SrcAttribute10 String A custom attribute for the shipment, designed to track particular shipment-related features that are important to the organization.
SrcAttribute11 String A custom attribute for the shipment, allowing for tracking additional shipment metadata as needed.
SrcAttribute12 String A custom attribute for the shipment, used for specifying further characteristics or conditions of the shipment.
SrcAttribute13 String A custom attribute for the shipment, used for organizing and categorizing additional shipment details.
SrcAttribute14 String A custom attribute for the shipment, offering flexibility for users to categorize shipments with specific features.
SrcAttribute15 String A custom attribute for the shipment, used for organizing data points that are not typically captured in standard fields.
SrcAttribute16 String A custom attribute for the shipment, allowing further classification and tracking for shipment-related data.
SrcAttribute17 String A custom attribute for the shipment, offering more ways to classify shipment data based on unique needs.
SrcAttribute18 String A custom attribute for the shipment, designed to track specific shipment details as required.
SrcAttribute19 String A custom attribute for the shipment, used for tracking special shipment features that might not be covered by default fields.
SrcAttribute20 String A custom attribute for the shipment, providing another layer of classification or categorization for the shipment data.
SrcAttributeDate1 Date A custom date attribute for the shipment, allowing users to capture and track date-based shipment information.
SrcAttributeDate2 Date A custom date attribute for the shipment, providing more flexibility for tracking date-specific shipment details.
SrcAttributeDate3 Date A custom date attribute for the shipment, used for specifying additional time-based data for the shipment.
SrcAttributeDate4 Date A custom date attribute for the shipment, offering more options for recording specific dates related to shipments.
SrcAttributeDate5 Date A custom date attribute for the shipment, used to track additional dates associated with shipment events.
SrcAttributeNumber1 Decimal A custom numeric attribute for the shipment, allowing users to track numeric data related to the shipment.
SrcAttributeNumber2 Decimal A custom numeric attribute for the shipment, providing another way to track numeric shipment details.
SrcAttributeNumber3 Decimal A custom numeric attribute for the shipment, used for specifying shipment-related numerical data.
SrcAttributeNumber4 Decimal A custom numeric attribute for the shipment, offering flexibility to track numeric data as needed.
SrcAttributeNumber5 Decimal A custom numeric attribute for the shipment, used for recording additional numeric data related to the shipment.
SrcAttributeNumber6 Decimal A custom numeric attribute for the shipment, allowing users to track numeric data points associated with the shipment.
SrcAttributeNumber7 Decimal A custom numeric attribute for the shipment, offering further options to capture shipment-specific numeric data.
SrcAttributeNumber8 Decimal A custom numeric attribute for the shipment, enabling the tracking of additional numerical details.
SrcAttributeNumber9 Decimal A custom numeric attribute for the shipment, providing more flexibility for tracking numeric shipment information.
SrcAttributeNumber10 Decimal A custom numeric attribute for the shipment, designed to track specific numeric data related to shipments.
SrcAttributeTimestamp1 Datetime A custom timestamp attribute for the shipment, allowing users to track specific date and time-based shipment details.
SrcAttributeTimestamp2 Datetime A custom timestamp attribute for the shipment, used to capture additional time-sensitive data.
SrcAttributeTimestamp3 Datetime A custom timestamp attribute for the shipment, allowing the tracking of other timestamped events during the shipment lifecycle.
SrcAttributeTimestamp4 Datetime A custom timestamp attribute for the shipment, used for tracking specific moments or events tied to a shipment.
SrcAttributeTimestamp5 Datetime A custom timestamp attribute for the shipment, enabling the capture of specific time-based data as needed.
TransportationShipmentFromEvent String The event that initiated the transportation shipment, used for tracking the source of the transportation process.
TransportationShipmentLineFromEvent String The event that initiated the transportation shipment line, used to associate each line item of the shipment with an event.
TransportationShipmentCompleteFromEvent String The event that marks the completion of the transportation shipment, used for tracking finalization events in the shipment process.
TradeComplianceScreenedFromEvent String The event related to the screening of the shipment for trade compliance, often used to ensure that the shipment meets regulatory requirements.
CurrentBackorderedQuantityFromEvent Decimal The current backordered quantity associated with the shipment, used for tracking the quantity of items that have not yet been fulfilled.
OriginalShipmentLineFromEvent Long The original shipment line identifier from the event, used to link the shipment line to the event that triggered the creation of the shipment.
ProjectCostingProjectId Long The project identifier associated with the shipment, used for cost tracking and project management purposes in shipment processing.
ProjectCostingProjectNumber String The project number associated with the shipment, providing a unique reference for project-based cost accounting.
ProjectCostingProjectName String The project name associated with the shipment, used to identify the specific project for which the shipment is being processed.
ProjectCostingTaskId Long The task identifier for the project associated with the shipment, used for tracking specific tasks within a project.
ProjectCostingTaskNumber String The task number for the project associated with the shipment, used to identify a particular task within a project.
ProjectCostingTaskName String The task name associated with the shipment in the context of the project, used to provide more detail about the shipment's purpose.
OverShipTolerancePercentage Decimal The percentage of overshipment tolerance allowed for the shipment, used to track how much more than the requested quantity can be shipped.
UnderShipTolerancePercentage Decimal The percentage of undershipment tolerance allowed for the shipment, used to track how much less than the requested quantity can be shipped.
ShippingToleranceBehavior String Defines the behavior for handling shipping tolerances, such as whether over or under shipments are accepted.
ConvertedRequestedQuantity Decimal The quantity of items in the shipment that has been converted, such as from one UOM to another, or from one product type to another.
LineNetWeight Decimal The net weight of the shipment line, excluding packaging, used for logistical purposes and transportation calculations.
LineGrossWeight Decimal The gross weight of the shipment line, including packaging, used to determine shipping costs and compliance with weight limits.
SupplierLotNumber String The lot number provided by the supplier for the shipment, used to track the specific batch or group of items in the shipment.
MovementRequestLineId Long The identifier for the movement request line associated with the shipment, used to link shipment details to specific requests for item movement.
AllowItemSubstitutionFlag Bool Indicates whether item substitution is allowed in the shipment, typically used in cases where the original item is unavailable.
OriginalItemId Long The identifier for the original item in the shipment, used to track the original item before any substitutions or modifications.
OriginalItemNumber String The original item number of the shipment, used to identify the product before any changes or substitutions are made.
OriginalDeliveryDetailId Long The identifier for the original delivery detail associated with the shipment, linking it to the initial shipping details.
OriginalItemConvertedQuantity Decimal The quantity of the original item that has been converted (for example, due to unit changes), used for tracking modifications to the shipment.
DestinationOrganizationCode String The code of the organization where the shipment is ultimately going, used for organizational tracking and reporting purposes.
LineUnitPrice Decimal The unit price of the line item in the shipment, used for pricing, invoicing, and financial reporting.
LineUnitVolume Decimal The unit volume of the shipment line, used for logistical calculations and ensuring the shipment meets dimensional requirements.
LineVolume Decimal The total volume of the shipment line, used for determining storage and shipping space requirements.
LineUnitWeight Decimal The unit weight of the shipment line item, used for logistics, transportation, and weight-based cost calculations.
LineSellingPrice Decimal The selling price of the line item in the shipment, used for financial purposes, invoicing, and revenue tracking.
OriginalSourceOrderFulfillmentLineId Long The identifier for the source order fulfillment line from which the shipment line originated, used to track the relationship between source orders and shipments.
OriginalSourceOrderFulfillmentLine String The identifier of the source order fulfillment line from which the shipment line was generated, linking the shipment to the original order.
EnforceSingleShipment String A flag indicating whether the system should enforce that all items in the shipment are consolidated into a single shipment, typically used for order consolidation.
CancelBackorders String A flag indicating whether backordered items related to the shipment should be canceled, often used in cases of shipment adjustments.
Finder String The finder used to search and retrieve specific shipment lines based on criteria, used in queries and reports to filter shipment data.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175