SalesOrdersForOrderHublineschannelPrograms
Stores details about channel programs associated with sales order lines for targeted marketing or sales strategies.
Columns
| Name | Type | SupportedFinders | 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 | FindByOrderedDate | Start date from which the channel program details are valid, marking the beginning of the eligibility period for the incentive. |
| HeaderId | Long | PrimaryKey, findByHeaderId | Unique identifier for the order header associated with the channel program, linking the program to the broader sales order. |
| OrderKey | String | FindByOrderKey | 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 | FindByOrderNumber | Order number assigned to the sales order, providing a reference for tracking the order throughout its lifecycle. |
| SourceTransactionNumber | String | FindBySourceOrderNumberAndSystem | Transaction number assigned by the source system, linking the channel program details to its originating transaction in the external system. |
| SourceTransactionSystem | String | FindBySourceOrderNumberAndSystem | Name of the source system from which the channel program data originated, providing context for integration with external systems. |
| ToDate | Date | FindByOrderedDate | End date after which the channel program details are no longer valid, marking the end of the incentive or discount period. |