CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

SalesOrdersForOrderHublineschannelPrograms

Stores details about channel programs associated with sales order lines for targeted marketing or sales strategies.

Columns

Name Type Description
SalesOrdersForOrderHubHeaderId [KEY] Long Unique identifier for the sales order header, linking the channel program details to the parent order and enabling tracking of program-based discounts or incentives.
LinesFulfillLineId [KEY] Long Identifier for the fulfillment line associated with the order, helping to connect the channel program details to specific order lines being fulfilled.
IncentiveEntityTypeCode String Code representing the type of incentive entity, such as distributor or partner, that the channel program applies to.
IncentiveEntitySubtypeCode String Code representing the subtype of the incentive entity, further specifying the type of relationship or classification within the broader incentive entity.
IncentiveId [KEY] Long Unique identifier for the incentive, linking the sales order to a specific incentive offered through the channel program.
SourceIncentiveId String Unique identifier assigned by the source system for the incentive, providing a reference for the originating application or platform.
ProgramCode String Code identifying the specific channel program under which the incentive or discount applies, used to group incentives by program.
ProgramId String Unique identifier for the program, linking the sales order line to a specific channel program offering incentives or discounts.
ProgramName String Name of the channel program, providing a more readable description for the program offering the incentive or discount.
ProgramDetails String Description of the channel program, outlining the specifics of how it operates and what it offers (for example, rebate details, special offers).
ProgramTypeName String Name of the program type, categorizing the channel program (for example, volume-based discounts, loyalty programs).
ProgramLine String Line within the channel program, used to specify details for a particular offer or incentive within a program.
ProgramLineId String Unique identifier for the specific program line, used to link the sales order to a distinct line item in the program.
ProgramDescription String Description of the specific program line, providing context on the type of incentive or discount available in that program line.
ApplyType String Code describing how the incentive or discount is applied (for example, on total order, per item), defining the structure of the discount.
ManuallyAppliedFlag Bool Flag indicating whether the incentive or discount was manually applied by a user (true) or automatically applied by the system (false).
ItemLevelCode String Code indicating if the incentive or discount is applied at the item level, order level, or another defined level within the sales order.
ItemLevel String Description of the level at which the incentive or discount is applied, such as 'per item' or 'per order', to clarify the scope of the discount.
StatusCode String Code representing the status of the channel program, indicating whether the incentive is active, expired, or pending.
Status String Description of the channel program's current status, providing clarity on whether the incentive or discount is in effect or inactive.
DiscountTypeCode String Code identifying the type of discount (for example, percentage off, fixed amount off), helping to categorize the discount.
DiscountType String Description of the type of discount, providing more detail on how the discount is structured (for example, 'percentage off' or 'fixed amount off').
DeclinableFlag Bool Flag indicating whether the customer can decline the incentive or discount (true) or if it is automatically applied (false).
DeclineReasonCode String Code identifying the reason for declining the incentive or discount, used to track why a discount was not accepted by the customer.
DeclineReason String Description of the reason for declining the incentive or discount, helping to provide additional context for customer decisions.
DiscountAmount Long Amount of the discount or incentive applied to the order, specifying the value of the discount offered.
StartDate Date Start date of the channel program or discount validity period, marking when the incentive or discount becomes available.
EndDate Date End date of the channel program or discount validity period, marking when the incentive or discount expires.
Comments String Any additional comments or notes related to the channel program or discount, providing further context or special instructions.
Finder String Tool or method used to search and locate specific channel program records, helping to filter and retrieve relevant program data.
FromDate Date Start date from which the channel program details are valid, marking the beginning of the eligibility period for the incentive.
HeaderId Long Unique identifier for the order header associated with the channel program, linking the program to the broader sales order.
OrderKey String Key used to uniquely identify the order line associated with the channel program, ensuring that the discount or incentive is applied to the correct line.
OrderNumber String Order number assigned to the sales order, providing a reference for tracking the order throughout its lifecycle.
SourceTransactionNumber String Transaction number assigned by the source system, linking the channel program details to its originating transaction in the external system.
SourceTransactionSystem String Name of the source system from which the channel program data originated, providing context for integration with external systems.
ToDate Date End date after which the channel program details are no longer valid, marking the end of the incentive or discount period.

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