ChannelProgramsmarketRulesV2
Manages market rules that define the eligibility of channel programs, including qualifiers and comparison operators.
Columns
| Name | Type | SupportedFinders | Description |
| ChannelProgramsProgramId [KEY] | Long | Value that uniquely identifies the channel program. | |
| ProgramId | Long | PrimaryKey | Value that uniquely identifies the supplier program. |
| RuleId [KEY] | Long | Value that uniquely identifies the market rule. | |
| RuleNumber | Int | Number that identifies the leading component of the display line number. The display line number is a concatenation of the rule number and the child rule number separated by a period. For example, if the display line number is 3.1, then the rule number is 3 and the child rule number is 1. | |
| ParentRuleId | Long | Value that identifies the parent market rule. | |
| ChildRuleNumber | Int | Number that identifies the trailing component of the display line number. | |
| QualifierTypeCode | String | Abbreviation that identifies the type of qualifier used to define the eligibility of the supplier program. | |
| QualifierType | String | Type of qualifier used to define the eligibility of the supplier program. A list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_TYPE for supplier ship and debit programs and the lookup type ORA_CJM_SUP_REBATE_QUAL for supplier rebate programs. | |
| QualifierValueCode | String | Abbreviation that identifies the qualifier used in the supplier program qualification. | |
| QualifierValue | String | Name of the qualifier used in the supplier program qualification. | |
| QualifierNumberValueCode | Long | Value of the numeric qualifier used in the supplier program qualification. | |
| ComparisonOperatorCode | String | Abbreviation that identifies the comparison operator used in the market rule. | |
| ComparisonOperator | String | Name of the comparison operator used in the market rule. A list of accepted values is defined in the lookup type ORA_CJM_QUALIFIER_OPERATOR. | |
| FromDate | Date | Date when the market rule becomes applicable. | |
| ToDate | Date | Date when the market rule is no longer applicable. | |
| Customer | String | Name of the customer. It applies if the qualifier type is Customer, Bill-to Account or Ship To. | |
| AccountNumber | String | Number of the bill-to customer account. | |
| Site | String | Name of the bill-to customer account site or the ship-to site. | |
| Address | String | Address for the customer. It applies if the qualifier type is Customer, Bill-to Account or Ship To. | |
| CustomQualifierFlag | Bool | Contains one of the following values: true or false. The default value for this attribute is false. | |
| DomainDataTypeCode | String | Type of dimension data. Valid values include text, number, date, and time stamp. A list of accepted values is defined in the lookup type ORA_QP_MTRXR_DIMN_DATA_TYPES. | |
| DomainLookupTypeCode | String | Lookup type code for the dimension of the lookup domain type. | |
| DomainTypeCode | String | Type of domain. Valid values include lookup, view object query, and custom. A list of accepted values is defined in the lookup type ORA_QP_MTRXR_DIMN_DOMAIN_TYPES. | |
| MatrixDimensionId | Long | Value that uniquely identifies the pricing matrix dimension associated with the market rule. | |
| CreatedBy | String | User who created the record. | |
| CreationDate | Datetime | Date and time when the user created the record. | |
| LastUpdatedBy | String | User who most recently updated the record. | |
| LastUpdateDate | Datetime | Date and time when the user most recently updated the record. | |
| Finder | String | The name of the finder method used to search and filter market rule records. |