CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

SalesOrdersForOrderHublines

Manages detailed information about sales order lines, including item specifications, quantities, and associated order details.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the order line details to the specific sales order.
HeaderId Long Unique identifier for the sales order header, used to associate the order line with the corresponding header.
LineId Long Unique identifier for each line in the sales order, allowing the order to be broken down into individual items.
FulfillLineId [KEY] Long Identifier for the fulfillment line associated with the order line, used to track fulfillment statuses for individual lines.
SourceTransactionLineId String Unique identifier for the transaction line in the source application, allowing the order line to be linked to its original transaction.
SourceTransactionLineNumber String Transaction line number from the source application, used to reference and identify specific lines in the source document.
SourceTransactionId String Unique identifier for the source transaction, linking the sales order line to the original source transaction.
SourceTransactionNumber String Transaction number of the source system, used for referencing the originating transaction that created the order line.
SourceTransactionSystem String The system from which the original source transaction originated, providing context for the source of the sales order line.
RequestingBusinessUnitId Long Unique identifier for the business unit requesting the fulfillment of the order line, used for internal tracking and allocation.
RequestingBusinessUnitName String Name of the business unit that requested the fulfillment, helping to categorize and assign responsibility for the order line.
AccountingRuleCode String Abbreviation for the accounting rule applied to the order line, used to manage how the revenue is recognized for the transaction.
AccountingRule String The accounting rule applied to the order line, determining the accounting periods and revenue distribution for the sales order.
ActionTypeCode String Code representing the type of action for the coverage or subscription product on the fulfillment line, such as add, update, renew for coverage or suspend, terminate for subscriptions.
ActionType String Descriptive label for the action type on the fulfillment line, detailing the nature of the change or update to the coverage or subscription.
ActualCompletionDate Datetime The actual date when the fulfillment of the order line was completed, used to track when the order was fully processed.
ActualShipDate Datetime The actual ship date of the sales order line, marking the point at which the item was shipped to the customer.
AppliedPriceListId Long Unique identifier for the price list applied to the order line, allowing tracking of the specific pricing terms used.
AppliedPriceListName String Name of the price list applied to the order line, providing clarity on which pricing rules were used for the line item.
AssessableValue Decimal The price used by tax authorities to calculate taxes for the item, typically based on the value of the goods or services.
AssetGroupNumber String Group identifier for customer assets, used to categorize and manage assets related to the order line.
AssetTrackedFlag Bool Flag indicating whether the fulfillment line is eligible for asset tracking. This attribute is used for items that are tracked in asset management systems.
AssetTrackingCode String Code identifying whether the item is eligible for tracking in the asset management system, providing additional context for managing customer assets.
AssetTracking String Detailed asset tracking status or code, specifying the tracking conditions of the item on the order line.
BillingTransactionTypeId Long Unique identifier for the type of billing transaction associated with the order line, used to categorize the transaction for invoicing and accounting.
BillingTransactionTypeName String The name of the billing transaction type, used to describe the transaction for invoicing and accounting purposes.
BuyerId Long Unique identifier for the buyer associated with the order line, linking to buyer-specific data within the system.
BuyerName String Name of the buyer for the scheduled item, used for identification and tracking within the sales order process.
BuyerFirstName String First name of the buyer associated with the order line, providing clarity for communication and tracking.
BuyerLastName String Last name of the buyer associated with the order line, used for identifying the buyer and managing the order.
BuyerMiddleName String Middle name of the buyer, providing additional clarity for identifying the buyer in the order management system.
CancelReasonCode String Code representing the reason for canceling the order line, providing a reference to predefined reasons for cancellations.
CancelReason String The detailed reason for canceling the order line, providing further context for the action.
CanceledFlag Bool Flag indicating whether the order line has been canceled. If true, the line is marked as canceled; otherwise, it remains active.
CanceledQuantity Decimal The quantity of the order line that was canceled, used to track the amount of items or services no longer being processed.
ShippingCarrierId Long Unique identifier for the carrier responsible for delivering the item, used to track the logistics and shipping process.
ShippingCarrier String Name of the shipping carrier delivering the item, providing clarity on the third-party responsible for transportation.
TransactionCategoryCode String Abbreviation representing the transaction category for the order line, such as RETURN or ORDER, used to classify the line for processing.
Comments String Textual comments for the order line, allowing for additional notes or details to be included for reference during order fulfillment.
ComponentIdPath String Unique identifier for the path from the inventory item to the parent configured item in the order line, used to track configurations.
ConfigCreationDate Datetime The date when the configured item was created, providing a timestamp for when custom configurations were finalized.
ConfigHeaderId Long Unique identifier for the order header associated with the configured item, linking the configuration to the main sales order.
ConfigInventoryItemId Long Inventory item ID for an assemble-to-order or configured item that can be shipped, linking it to the inventory.
ConfigInventoryItemNumber String Unique item number for the configured item, used to identify and track the item in the order line.
ConfigInventoryItemDescription String Description of the configured inventory item, providing further details on what the item represents.
ConfigItemReference String Reference to the finished configured item, used to link the order line to the finished product after configuration.
ConfigRevisionNumber Long Revision number of the configured item, used to track changes or updates to the configuration over time.
ConfigTradeComplianceResultCode String Code representing the trade compliance result for the configured item, used for compliance checks during order processing.
ConfigTradeComplianceResult String Detailed result of the trade compliance check for the configured item, providing context for regulatory compliance.
ConfiguratorPath String Path that identifies the inventory item for the configure option, structured in a format separated by identifiers and brackets.
ContractEndDate Date End date of the contract associated with the order line, used for tracking the duration of contract-based items or services.
ContractStartDate Date Start date of the contract, marking the beginning of the contractual obligations tied to the order line.
CreatedBy String The name or identifier of the person who created the order line, useful for auditing and accountability.
CreationDate Datetime The date and time when the order line was created, providing a timestamp for when the item was added to the order.
CreditCheckAuthExpiryDate Datetime The expiration date for the approved credit authorization, used to track the validity period for credit checks.
CreditCheckAuthorizationNumber String Unique identifier for the approved credit authorization, used for reference in credit management and validation processes.
CustomerProductId Long Unique identifier for the customer’s product associated with the order line, allowing for easy identification of customer-specific items.
CustomerProductNumber String Customer-specific product number, used for reference and tracking of custom or proprietary items.
CustomerProductDescription String Description of the customer’s product, providing details about the item for clarity and order processing.
CustomerPOLineNumber String Unique identifier for the purchase order line associated with the sales order, linking the sales order to the original purchase order.
CustomerPONumber String Number of the customer’s purchase order, used to track and manage the order within the sales process.
CustomerPOScheduleNumber String Number that identifies the schedule for shipment associated with the purchase order, helping to manage delivery times.
DefaultTaxationCountry String Country used by the tax authority to calculate tax, ensuring the correct tax rates are applied based on the customer's location.
DefaultTaxationCountryShortName String Short name of the country used for tax calculations, simplifying the tax processing by using an abbreviated country name.
DemandClassCode String Abbreviation representing the demand class, categorizing the order line for better management and reporting based on customer type or region.
DemandClass String Class of demand representing different customer categories, such as government, commercial, or retail, for tailored order processing.
DestinationLocationId Long Unique identifier for the location where the item is being shipped, helping to track the destination of the fulfillment.
DestinationShippingOrganizationId Long Identifier for the shipping organization responsible for delivering the item, linking the order to a specific fulfillment provider.
DestinationShippingOrganizationCode String Code representing the destination shipping organization, helping to identify the fulfillment partner in the logistics process.
DestinationShippingOrganizationName String Name of the destination shipping organization responsible for the delivery, providing clarity on the carrier handling the shipment.
DocumentSubtype String Tax classification used for tax reporting, determining how the tax on the item is calculated based on the country-specific rules.
DocumentSubtypeName String Name of the tax classification for reporting, specifying the nature of the tax used for the item in compliance with local tax regulations.
EarliestAcceptableShipDate Datetime Earliest date when the customer is willing to receive the shipment, used to define the earliest fulfillment window.
EstimateFulfillmentCost Decimal Estimated cost to fulfill the order line, including both item and shipping costs, helping in cost forecasting and margin calculations.
EstimateMargin Decimal Estimated margin on the order line, calculated by subtracting costs from the sale price to provide insight into profitability.
ExemptionCertificateNumber String Certification number issued by the tax authority for tax exemption, used for customers who qualify for tax-free purchases.
ExtendedAmount Decimal The total monetary amount for the order line, calculated by multiplying the unit price by the quantity of items ordered.
FinalDischargeLocationId Long Unique identifier for the final destination location of the item, helping to track where the purchase will be delivered.
FinalDischargeLocationAddressLine1 String First line of the address for the final discharge location, providing a physical address for where the item will be delivered.
FinalDischargeLocationAddressLine2 String Second line of the address for the final discharge location, used to provide additional address details (for example, suite, apartment).
FinalDischargeLocationAddressLine3 String Third line of the address for the final discharge location, providing further address breakdown if necessary.
FinalDischargeLocationAddressLine4 String Fourth line of the address for the final discharge location, capturing additional address information for the delivery.
FinalDischargeLocationAddressCity String City of the final discharge location, indicating the city where the item will be delivered.
FinalDischargeLocationAddressPostalCode String Postal code of the final discharge location, helping to identify the specific region for the shipment.
FinalDischargeLocationAddressState String State of the final discharge location, helping to further specify the region for accurate delivery.
FinalDischargeLocationAddressProvince String Province of the final discharge location, used for countries like Canada, where provinces are used instead of states.
FinalDischargeLocationAddressCounty String County of the final discharge location, providing additional geographic context for the delivery.
FinalDischargeLocationAddressCountry String Country of the final discharge location, ensuring that the shipment reaches the correct country.
FirstPartyTaxRegistration Long Registration number for the supplier or the first party in the transaction, used for tax purposes in international transactions.
FirstPartyTaxRegistrationNumber String Unique number assigned to the supplier or first party for tax registration, ensuring that tax obligations are properly managed.
FOBPointCode String Abbreviation representing the FOB (Free on Board) point, identifying where ownership of goods transfers between buyer and seller.
FOBPoint String Describes the FOB point, where the responsibility for the goods shifts from the seller to the buyer during transit.
FreightTermsCode String Code representing the terms under which freight charges are handled, such as prepaid or collect.
FreightTerms String Description of the freight terms, indicating whether the seller or buyer is responsible for shipping costs.
FulfillInstanceId Long Unique identifier for the fulfillment instance, used to track the fulfillment process for each line of the sales order.
FulfillLineNumber String Line number of the fulfillment, which is linked to the order line for the fulfillment tracking process.
RequestedFulfillmentOrganizationId Long Unique identifier for the organization responsible for fulfilling the order, ensuring the correct team or warehouse handles the fulfillment.
RequestedFulfillmentOrganizationCode String Code representing the organization responsible for fulfillment, helping to identify the location or warehouse handling the order.
RequestedFulfillmentOrganizationName String Name of the organization responsible for fulfilling the order, providing clarity on which business unit or team is tasked with the fulfillment.
RequestedFulfillmentOrganizationAddress1 String Address line 1 of the fulfillment organization, helping to pinpoint the physical location of the warehouse or fulfillment center.
RequestedFulfillmentOrganizationAddress2 String Address line 2 of the fulfillment organization, used to provide additional location details for accurate delivery.
RequestedFulfillmentOrganizationAddress3 String Address line 3 of the fulfillment organization, providing further details when necessary.
RequestedFulfillmentOrganizationAddress4 String Address line 4 of the fulfillment organization, used to capture extra address information for the fulfillment center.
RequestedFulfillmentOrganizationCity String City where the fulfillment organization is located, helping to identify the geographic location of the fulfillment center.
RequestedFulfillmentOrganizationState String State or region where the fulfillment organization is located, adding further context to the fulfillment location.
RequestedFulfillmentOrganizationPostalCode String Postal code of the fulfillment organization, aiding in the identification of the specific delivery area.
RequestedFulfillmentOrganizationCounty String County of the fulfillment organization, providing additional geographic context for the delivery.
RequestedFulfillmentOrganizationProvince String Province of the fulfillment organization, used for countries like Canada, where provinces are the administrative divisions.
RequestedFulfillmentOrganizationCountry String Country of the fulfillment organization, ensuring the shipment is being processed from the correct nation.
OverFulfillmentTolerance Decimal Tolerance for over-fulfillment, indicating the maximum allowed overage for an order line before it becomes a problem.
UnderFulfillmentTolerance Decimal Tolerance for under-fulfillment, specifying the maximum allowed shortfall for an order line before an issue arises.
FulfilledQuantity Decimal Quantity of the order line that has been fulfilled or shipped, used to track how much of the order has been processed.
SecondaryFulfilledQuantity Decimal Quantity of the order line that has been fulfilled in a secondary unit of measure, used when multiple units of measure are involved.
FulfillmentDate Datetime Date on which the order line was fulfilled, providing a timestamp for the completion of the fulfillment process.
FulfillmentMode String Mode used for fulfilling the order line, such as pick, pack, and ship, or other fulfillment methods.
FulfillmentSplitReferenceId Long Identifier used for splitting fulfillment lines, helping to manage partial fulfillments or multiple fulfillment attempts.
GopReferenceId String Reference ID used to link the order line to global order promising processes, ensuring availability and fulfillment are managed properly.
GopRequestRegion String Region associated with the global order promising request, providing regional context for the fulfillment process.
IntendedUseClassificationId Long Identifier for the intended use classification, used for tax and compliance purposes to define how the item will be used by the customer.
IntendedUseClassificationName String Name of the intended use classification, providing clarity on the intended purpose of the item for tax or regulatory purposes.
ProductId Long Unique identifier for the product associated with the order line, used to track the specific inventory item being ordered.
ProductNumber String Product number for the inventory item on the order line, helping to identify and manage the product within the system.
ProductDescription String Description of the product being ordered, providing detailed information about the item for the customer and system users.
InventoryOrganizationId Long Identifier for the inventory organization responsible for the product on the order line, ensuring the item is sourced from the correct warehouse.
InventoryOrganizationCode String Code representing the inventory organization, used for tracking inventory management across multiple locations.
InventoryOrganizationName String Name of the inventory organization, clarifying which specific warehouse or inventory management system is handling the product.
InvoiceEnabledFlag Bool Flag indicating whether invoicing is enabled for the order line, ensuring that the line will be processed for invoicing.
InvoiceInterfacedFlag Bool Flag indicating whether the order line has been interfaced with the invoicing system, allowing the line to be included in the billing process.
InvoiceableItemFlag Bool Flag indicating whether the item is invoiceable, ensuring that only eligible items are included in the invoice.
InvoicingRuleCode String Code for the invoicing rule applied to the order line, defining when and how invoicing will occur.
InvoicingRule String Description of the invoicing rule for the order line, outlining the specific conditions under which the item will be invoiced.
ItemSubTypeCode String Code representing the subcategory of the item, used to categorize items for internal processing and reporting.
ItemSubType String Name or description of the item subcategory, providing additional classification to help manage product types.
ItemTypeCode String Code representing the type of item, such as product, service, or memo line, to differentiate the nature of the line item.
LastUpdateDate Datetime Date and time when the order line was last updated, helping to track changes made to the line item.
LastUpdateLogin String User login associated with the last update to the order line, ensuring accountability for changes.
LastUpdatedBy String Name or identifier of the person who last updated the order line, providing traceability for modifications.
LatestAcceptableArrivalDate Datetime The latest date by which the customer is willing to receive the item, helping to define the time frame for delivery.
LatestAcceptableShipDate Datetime The latest date by which the item should be shipped, marking the end of the allowable shipping window for the customer.
TransactionLineTypeCode String Code representing the type of transaction line, such as purchase, return, or adjustment, used for categorizing the order line.
TransactionLineType String Description of the transaction line type, providing context for the nature of the order line and its processing requirements.
OnHoldFlag Bool Flag indicating whether the order line is on hold, used to prevent further processing until certain conditions are met.
OpenFlag Bool Flag indicating whether the order line is open, meaning it is still active and not completed or canceled.
OrderedQuantity Decimal The quantity of the item ordered, used to track the amount of product or service the customer requested.
SecondaryOrderedQuantity Decimal Quantity of the item ordered in a secondary unit of measure, used when multiple units of measure are involved.
OrderedUOMCode String Code representing the unit of measure for the ordered quantity, ensuring the correct measurement system is used.
OrderedUOM String Unit of measure for the ordered quantity, such as pieces, kilograms, or liters, providing clarity on how the item is quantified.
SecondaryUOMCode String Code for the secondary unit of measure, used for tracking items that require multiple units of measure.
SecondaryUOM String Secondary unit of measure used to track the order quantity, providing additional context when measuring items in multiple units.
BusinessUnitId Long Identifier for the business unit associated with the order line, helping to organize and track sales across different organizational units.
BusinessUnitName String Name of the business unit associated with the order line, providing clarity on which unit is handling the order.
OrigSystemDocumentLineReference String Reference from the source application linking the order line to the original document line, ensuring traceability.
OrigSystemDocumentReference String Reference number of the original system document, linking the order line to the originating transaction or document.
OriginalProductId Long Unique identifier for the product on the order line, used to track the original product before any substitutions or changes.
OriginalProductNumber String Original product number on the order line, used to reference the initial product before any substitutions were made.
OriginalProductDescription String Description of the original product on the order line, providing further context before any modifications or substitutions.
OverrideScheduleDateFlag Bool Flag indicating whether the user has overridden the scheduled date for shipment or fulfillment, ensuring manual changes are tracked.
OwnerId Long User ID of the person responsible for the order line, used for accountability and tracking of who owns or manages the line.
PackingInstructions String Instructions for how the order line should be packed for shipment, ensuring the correct handling and packaging of items.
ParentFulfillLineId Long Identifier for the parent fulfillment line, used to link child lines to the main line in cases of item bundling or configuration.
PartialShipAllowedFlag Bool Flag indicating whether partial shipment of the order line is allowed, defining whether the order line can be shipped in parts.
PaymentTermsCode Long Code representing the payment terms for the order line, defining the conditions under which payment for the line is due.
PaymentTerms String Description of the payment terms for the order line, outlining the agreed conditions for payment, such as net 30 days.
POStatusCode String Abbreviation representing the status of the purchase order associated with the sales order line, helping to track its processing state.
PricedOn Datetime Date when the order line was priced, marking the point at which the item’s price was finalized.
ProcessNumber String Unique identifier for the process that handles the order line, helping to track the flow of the order through various stages.
ProductFiscalCategoryId Long Identifier for the fiscal category of the product, used for tax classification and reporting.
ProductFiscalCategory String Name of the fiscal category assigned to the product for tax purposes, helping to manage tax rates applied to the item.
ProductCategory String Category used to classify the product for taxation and reporting purposes.
ProductCategoryName String Name of the product category for tax classification, used to specify how tax is applied to the product.
ProductType String Type of item, such as product, service, or memo, used to define how the item is processed and billed.
ProductTypeName String Descriptive name for the product type, providing more context on the nature of the item.
PromiseArrivalDate Datetime Date when the global order promising system promises the item will arrive at the customer location.
PromiseShipDate Datetime Date when the global order promising system promises the item will ship, giving customers a clear expectation of the shipment.
PurchasingEnabledFlag Bool Flag indicating whether the item can be included on a purchase order, ensuring that only eligible items are processed for procurement.
PurchasingUOMCode String Unit of measure used in purchasing for the item, helping to ensure that procurement matches the correct measurement system.
PurchasingUOM String Description of the unit of measure for purchasing, such as boxes, kilograms, or liters, to match supplier requirements.
QuantityForEachModel Decimal Quantity for each model in a configured product, used for items that involve configurable options.
ReceivablesOrgId Long Identifier for the receivables organization associated with the order line, used to manage financial transactions.
ReceivablesOrgName String Name of the receivables organization, providing clarity on which business unit handles the financial aspects of the order line.
RemnantFlag Bool Flag indicating whether the order line is a remnant item, which may refer to leftover or surplus stock from a previous order.
RequestedArrivalDate Datetime Original date requested by the customer for when the item should arrive, used to manage delivery expectations.
RequestedCancelDate Datetime Date when the customer requested to cancel the order line, used for processing cancellations and managing customer expectations.
RequestedShipDate Datetime Original date requested by the customer for when the item should ship, helping to define shipping deadlines.
RequiredFulfillmentDate Datetime Date by which the customer requires the order line to be fulfilled, ensuring the fulfillment process meets customer needs.
RequisitionBusinessUnitId Long Identifier for the business unit that generated the requisition, linking the order line to the requisition process.
RequisitionBusinessUnitName String Name of the business unit that generated the requisition, providing clarity on which unit is responsible for the requisition.
RequisitionInventoryOrganizationId Long Identifier for the inventory organization handling the requisition, helping to manage stock and supply chain logistics.
RequisitionInventoryOrganizationCode String Code representing the inventory organization responsible for the requisition, ensuring proper coordination in supply.
RequisitionInventoryOrganizationName String Name of the inventory organization handling the requisition, providing context for where the item is being sourced from.
ReservableFlag Bool Flag indicating whether the item can be reserved for fulfillment, ensuring that inventory is available for order processing.
ReservationId Long Identifier for the reservation associated with the order line, used to track the inventory allocated for the order.
ReservedQuantity Decimal Quantity of the order line that has been reserved, ensuring that sufficient stock is available for fulfillment.
ReturnReasonCode String Code identifying the reason for returning an item, helping to categorize and process return requests.
ReturnReason String Description of the reason for returning the item, providing context for the customer’s return request.
ReturnableFlag Bool Flag indicating whether the order line item is eligible for return, ensuring that only returnable items are processed.
RMADeliveredQuantity Decimal Quantity of the item delivered under the Return Material Authorization (RMA) process, helping to track returns and exchanges.
SecondaryRMADeliveredQuantity Decimal Secondary quantity of the item delivered under the RMA process, used when multiple units of measure are involved.
RootParentFulfillLineId Long Identifier for the root parent fulfillment line, used to track the primary line when there are sublines or configurations involved.
SalesProductTypeCode String Code representing the type of product being sold, such as physical product, service, or subscription.
SalesProductType String Descriptive name for the sales product type, clarifying whether the item is a physical product, service, or other type of offering.
SalespersonId Long Unique identifier for the salesperson associated with the order line, linking the line to the individual responsible for the sale.
Salesperson String Name of the salesperson responsible for the order line, providing accountability and contact information for the sales team.
ScheduleArrivalDate Datetime Scheduled date for the arrival of the item, helping to manage delivery expectations and inventory planning.
ScheduleShipDate Datetime Scheduled date for the shipment of the order line, marking when the item is expected to leave the warehouse.
SchedulingReason String Reason for the scheduled shipment or arrival of the item, providing context for the fulfillment timeline.
SchedulingReasonCode String Code representing the reason for the scheduled shipment or arrival, helping to categorize scheduling actions.
ServiceDuration Decimal Duration of service coverage or subscription for the order line, indicating the length of the service or subscription period.
ServiceDurationPeriodCode String Code representing the unit of measure for the service duration, such as months, days, or years.
ServiceDurationPeriodName String Name of the unit of measure for the service duration, clarifying how the coverage or subscription period is defined.
ShippingServiceLevelCode String Code representing the shipping service level used for the order line, such as standard or expedited shipping.
ShippingServiceLevel String Descriptive name for the shipping service level, providing clarity on the level of service provided for shipping.
ShippingModeCode String Code representing the mode of transport for shipping the order line, such as ground, air, or sea.
ShippingMode String Name of the mode of transport for shipping, helping to identify how the item will be delivered to the customer.
ShipSetName String Name of the group of order lines that must ship together from one location to one destination, often used for grouped shipments.
ShipmentPriorityCode String Code representing the priority level for the shipment, such as high, medium, or low priority.
ShipmentPriority String Descriptive name for the shipment priority level, clarifying the urgency or importance of the shipment.
ShippableFlag Bool Flag indicating whether the item is eligible to be shipped, ensuring that only shippable items are processed.
ShippedQuantity Decimal Quantity of the order line that has been shipped to the customer, used to track fulfillment progress.
SecondaryShippedQuantity Decimal Secondary quantity of the item shipped, used when tracking multiple units of measure for the order line.
ShippedUOMCode String Code representing the unit of measure for the shipped quantity, ensuring that the right unit is used for the fulfillment.
ShippedUOM String Unit of measure for the shipped quantity, such as boxes, pallets, or units, to ensure the correct measure is used.
ShippingInstructions String Special instructions for shipping the order line, detailing any specific handling, packaging, or delivery requirements.
ShowInSales Int Flag determining whether a configured item should be displayed in sales views, such as on the sales summary or configurator pages.
SourceTransactionRevisionNumber Long Revision number of the transaction in the source system, used to track different versions of the same transaction.
SourceTransactionScheduleId String Unique identifier for the schedule or subline in the source application, used to track the timing and details of the original transaction.
SourceScheduleNumber String Schedule number assigned by the source system, used for tracking and referencing shipment or order schedules.
SplitFromFlineId Long Identifier for the original fulfillment line from which this line was split, helping to manage partial fulfillments or modifications.
StatusCode String Code representing the status of the order line, such as open, shipped, or canceled, to track the progress of the line.
Status String Descriptive name for the status of the order line, providing clarity on its current state in the fulfillment process.
SubinventoryCode String Code for the subinventory where the item is stored, used to track the location of the product within the warehouse or inventory system.
Subinventory String Descriptive name for the subinventory location, helping to identify where the item is stored or sourced from within the warehouse.
SubstitutionAllowedFlag Bool Flag indicating whether the item on the order line is allowed to be substituted with another product, typically due to stock issues.
SubstitutionReasonCode String Code representing the reason for substituting the item on the order line, such as out of stock or customer preference.
SubstitutionReason String Descriptive reason for why a substitution is being made for the order line item, providing context for the action.
SupplierId Long Unique identifier for the supplier providing the item on the order line, helping to track procurement details.
SupplierName String Name of the supplier providing the item on the order line, used for reference and accountability.
SupplierSiteId Long Unique identifier for the supplier site associated with the order line, used to track which location is fulfilling the order.
SupplierSiteName String Name of the supplier site, helping to identify the specific location fulfilling the order.
SupplyStatusCode String Code representing the status of the supply for the fulfillment line, helping to track whether the supply is on schedule or delayed.
TaxClassificationCode String Code representing the tax classification for the item, used to apply appropriate tax rules to the order line.
TaxClassification String Name or description of the tax classification for the item, helping to ensure proper tax treatment based on product type.
TaxExemptFlag Bool Flag indicating whether the item on the order line is tax-exempt, ensuring the correct tax rates are applied.
TaxExemptCode String Code indicating whether the item is exempt from tax, used for proper tax reporting and processing.
TaxExempt String Tax exemption status of the order line, providing clarity on whether the item qualifies for tax exemption.
TaxExemptReasonCode String Code representing the reason for tax exemption, used to categorize and process exemptions in tax reporting.
TaxExemptReason String Description of the reason why the item is tax-exempt, helping to provide context for the exemption.
TaxInvoiceDate Date Date of the tax invoice, used for tax reporting based on the requirements of different countries.
TaxInvoiceNumber String Invoice number used for tax reporting purposes, ensuring proper identification of tax-related transactions.
ThirdPartyTaxRegistration Long Registration number provided by the third party, used for tax compliance and reporting purposes.
ThirdPartyTaxRegistrationNumber String Unique number assigned to the third party for tax registration, used for tracking tax obligations.
TotalContractAmount Decimal Total amount for the contract duration, representing the full value of the contract over its term.
TotalContractQuantity Decimal Total quantity for the contract duration, accounting for all quantities over the term of the contract.
TradeComplianceDate Datetime Date when the trade compliance check was performed on the order line, ensuring compliance with export and import regulations.
TradeComplianceResultCode String Code representing the result of the trade compliance check, used for categorizing compliance statuses.
TradeComplianceResult String Description of the trade compliance result, helping to provide context for the outcome of the compliance check.
TransportationPlannedFlag Bool Flag indicating whether transportation planning has been performed for the fulfillment line, ensuring logistical planning is complete.
TransportationPlannedStatusCode String Code representing the status of the transportation planning for the fulfillment line, indicating whether the shipment is scheduled.
TransactionBusinessCategory String Tax classification required by the tax authority for reporting and tax calculation.
TransactionBusinessCategoryName String Name of the tax classification required by the tax authority for transaction reporting.
UnitListPrice Decimal Selling price for each unit of the item, before discounts are applied, representing the base price of the item.
UnitQuantity Decimal Quantity of units for the item in the order line, used to calculate the total quantity ordered.
UnitSellingPrice Decimal Price the customer pays for one unit of the item, after any applicable discounts or adjustments.
UserDefinedFiscalClass String Tax classification defined by the user for custom tax handling.
UserDefinedFiscalClassName String Name of the user-defined fiscal class, allowing custom tax classifications to be applied based on user input.
ValidConfigurationFlag Bool Flag indicating whether the configured item is valid, used to ensure that only valid configurations are processed.
LineNumber Int The line number of the order line, used to track the sequence and position of the line in the sales order.
DisplayLineNumber String Display number of the order line, used for presenting the line in a user-friendly format.
ParentSourceTransactionLineId String Unique identifier for the parent transaction line in the source application, used to track hierarchical relationships for configured items.
TransformFromLineId Long Identifier for the original fulfillment line from which the order line was transformed, tracking the changes in the order process.
UnreferencedReturnFlag Bool Flag indicating whether the order line is marked for unreferenced return, used to track return items that are not associated with the original order.
ServiceCancelDate Datetime Date when the customer canceled a service-related item, used to manage the cancellation of subscriptions or coverage services.
CoveredProductId Long Unique identifier for the product covered by the coverage item, used to link the coverage to the specific product.
CoveredProductNumber String Product number for the product covered by the coverage item, ensuring the coverage applies to the correct product.
CoveredProductDescription String Description of the product covered by the coverage item, providing further context for the relationship between the product and its coverage.
CoveredCustomerProductId Long Unique identifier for the customer’s product covered by the coverage item, linking the coverage to the customer’s inventory.
CoveredCustomerProductNumber String Product number for the customer’s product covered by the coverage item, ensuring correct matching of coverage to customer product.
CoveredCustomerProductDescription String Description of the customer’s product covered by the coverage item, providing clarity on the customer’s covered item.
JeopardyPriorityCode String Code representing the jeopardy priority for the order line, indicating the urgency of processing based on certain conditions.
JeopardyPriority String Descriptive priority of the order line, representing how urgent the line is in terms of fulfillment and delivery.
AgreementHeaderId Long Unique identifier for the agreement header associated with the order line, used to link the line to a sales agreement.
AgreementLineId Long Line identifier for the agreement, used to link the order line to a specific line item in the sales agreement.
AgreementLineNumber String Line number in the agreement, helping to reference the specific item in a sales agreement associated with the order line.
AgreementVersionNumber Long Version number of the agreement, used to track revisions and updates made to the original agreement.
AgreementNumber String Number identifying the agreement, used to link the order line to the corresponding agreement for fulfillment.
SellingProfitCenterBusinessUnitId Long Unique identifier for the business unit responsible for the profit center associated with the sale, helping to track profitability.
SellingProfitCenterBusinessUnitName String Name of the business unit handling the profit center, providing clarity on the profit responsibility for the order line.
TransportationPlanningOrder String Unique identifier for the transportation planning order, used for managing transportation and shipping schedules for the fulfillment.
ContractEndDateTime Datetime End date and time for the contract, determining the final date when the contract is valid and services are provided.
ContractStartDateTime Datetime Start date and time for the contract, marking the beginning of the contractual obligations and services.
SubscriptionProfileId Long Unique identifier for the subscription profile, used to link the order line to a specific subscription offering.
SubscriptionProfileName String Name of the subscription profile associated with the order line, helping to identify the type of subscription.
ExternalPriceBookName String Name of the external price book used for pricing the order line, linking to the pricing rules in an external pricing system.
EndReasonCode String Code representing the reason for ending or closing the subscription, used to track why a subscription was terminated.
EndReason String Detailed reason for ending or closing the subscription, providing context for the termination of services.
EndCreditMethodCode String Code representing the credit method used for ending or closing the subscription, ensuring correct processing of credits or refunds.
EndCreditMethod String Description of the credit method used for ending or closing the subscription, providing further context for the termination process.
EndDate Datetime Date when the subscription or service ends, marking the end of the contract or coverage.
InventoryTransactionFlag Bool Flag indicating whether an inventory transaction is triggered by fulfilling the order line, ensuring inventory adjustments are processed.
InventoryInterfacedFlag Bool Flag indicating whether the order line has been interfaced with the inventory system for tracking and management.
PriceUsingSecondaryUOMFlag Bool Flag indicating whether the price for the item is based on a secondary unit of measure, used for cases where multiple units of measure are involved.
SubscriptionInterfacedFlag Bool Flag indicating whether the subscription details for the order line have been interfaced with a subscription management system.
SupplierAddress1 String First address line for the supplier, used to identify the supplier’s location for shipping or invoicing purposes.
SupplierAddress2 String Second address line for the supplier, providing additional address details for accurate identification.
SupplierAddress3 String Third address line for the supplier, used for further specifying the supplier’s delivery or billing address.
SupplierAddress4 String Fourth address line for the supplier, capturing any extra address details needed for the supplier’s location.
SupplierCity String City of the supplier, helping to identify the geographic location for shipment or invoicing purposes.
SupplierState String State of the supplier, used to identify the region of the supplier’s address for shipping and delivery.
SupplierPostalCode String Postal code of the supplier, used for precise identification of the location for shipping and invoicing.
SupplierProvince String Province of the supplier, relevant for countries like Canada, where provinces are used instead of states.
SupplierCounty String County of the supplier, providing additional geographical context for shipping or invoicing.
SupplierCountry String Country of the supplier, used for identifying the supplier’s country of operation and for international shipping.
RatePlanId Long Unique identifier for the rate plan applied to the order line, linking the order to a specific pricing model or scheme.
RatePlanNumber String Rate plan number used to identify the specific rate plan applied to the order line for pricing purposes.
RatePlanName String Name of the rate plan applied to the order line, providing a descriptive title for the pricing model.
RequestedRatePlanId Long Identifier for the rate plan requested by the user, linking to the external pricing system for the order line.
RequestedRatePlanNumber String Number identifying the rate plan requested by the user, used to reference external pricing details.
RequestedRatePlanName String Name of the rate plan requested by the user, providing clarity on the pricing model the customer selected.
RatePlanDocumentId Long Unique identifier for the rate plan document, used to reference the associated documentation in JSON format for the pricing model.
RatePlanDocument String Document in JSON format containing the details of the rate plan, encoded using Base64, to capture all pricing information.
OrchestrationProcessName String Name of the orchestration process assigned to the order line, ensuring that the order is handled through the correct workflow.
IntegrateSubscriptionFlag Bool Flag indicating whether the order line is integrated with a subscription management system for processing.
DemandSourceLineReference String Reference that uniquely identifies the demand for the item, such as the order line in a shopping cart on a web store.
DemandSourceScheduledFlag Bool Flag indicating whether the demand has been scheduled in the order management system, ensuring demand is processed accordingly.
CancelBackordersFlag Bool Flag indicating whether backorders should be canceled if they cannot be fulfilled during the shipping process.
EnforceSingleShipmentFlag Bool Flag indicating whether multiple shipments for the same order line should be allowed. If set to true, only one shipment is allowed.
Finder String A tool or method used to search and locate specific order lines within the system
FromDate Date Start date for the order line, defining the period when the order line is valid and should be processed.
OrderKey String Key used to uniquely identify the order line within the system, ensuring it can be tracked throughout the fulfillment process.
OrderNumber String Order number assigned to the sales order, providing a unique identifier for tracking and managing the order.
ToDate Date End date for the order line, marking when the order line is no longer valid or when the fulfillment process should end.

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