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. |