Deal Item Loc Explode

Unique alphanumeric value that identifies the item.

Deal suppliers number. Oracle Retail target column SUPPLIER on DEAL_ITEM_LOC_EXPLODE.

Origin country of the item that the deal component should apply to.

Location for the item on the deal.

Type of the location referenced in the location field. Valid values are S and W. Location types will be held on the codes table under the code type LOTP.

Unique deal number. Oracle Retail target column DEAL_ID on DEAL_ITEM_LOC_EXPLODE.

Deal component Id number. Oracle Retail target column DEAL_DETAIL_ID on DEAL_ITEM_LOC_EXPLODE.

Date the deal will become active. This date will determine when deal components begin to be factored into item costs. For a PO-specific deal, the active_date will be the orders written date.

Date the deal will/did end. This date determines when deal components are no longer factored into item costs. It is optional for annual deals, required for promotional deals. It will be left NULL for PO- specific deals.

Indicates what cost bucket the deal component should affect. Valid values are N for net cost, NN for net net cost and DNN for dead net net cost. These values will be held on the codes tables under a code_type of DLCA. It can only be NULL for an M-type deal (vendor funded markdown).

Identifies deal components that should be included when calculating a pricing cost.

Identifies the calculation class of the deal component. Valid values are CU for cumulative (discounts are added together and taken off as one lump sum), CS for cascade (discounts are taken one at a time with subsequent discounts taken off the result of the previous discount), and EX for exclusive (overrides all other discounts). EX type deal components are only valid for promotional deals. Deal classes will be held on the codes table under a code type of DLCL. It can only be NULL for an M-type deal (vendor funded markdown).

Identifies whether the discount values associated with the thresholds will be set up as qty values, currency amount values, percentages or fixed amounts. Valid values are Q for qty, A for currency amount, P for percentage or F for fixed amount. Qty threshold deals are only allowed on off-invoice discounts. Deal threshold value types will be held on the codes table under a code type of DLL2. It can only be NULL for an M-type deal (vendor funded markdown).

Identifies the item that must be purchased for a quantity threshold-type discount. This value is required for quantity threshold-type discounts.

Identifies the type of the get discount for a quantity threshold-type (buy/get) discount. Valid values include X (free), P (percent), A (amount) and F (fixed amount). They are held on the codes table under a code type of DQGT. This value is required for quantity threshold deals.

Identifies the value of the get discount for a quantity threshold-type (buy/get) discount that is not a free goods deal. The type of the value is identified by the get type in the qty_thresh_get_type. This value is required for quantity threshold deals that are not a get type of free.

Identifies the quantity of the threshold buy item that must be ordered to qualify for the free item. This value is required for quantity threshold-type discounts.

For buy/get free discounts, indicates if the quantity threshold discount is only for the first buy amt. purchased (e.g. for the first 10 purchased, get 1 free), or if a free item will be given for every multiple of the buy amt purchased on the order (e.g. for each 10 purchased, get 1 free). This value is required for quantity threshold-type discounts with a get type of free. Valid values are Y for yes or N for no.

Indicates the targeted purchase level for all locs on a purchase order. This is the target level that will be used for future calculation of net cost

Indicates the average targeted purchase level per location on the deal. This value will be used in future cost calculations.

Identifies the get item for a quantity threshold-type (buy/get) discount. This value is required for quantity threshold deals.

Identifies the quantity of the identified get item that will be given at the specified get discount if the buy amt of the buy item is purchased. This value is required for quantity threshold-type discounts.

For buy/get free discounts, identifies the unit cost of the threshold free item that will be used in calculating the prorated qty. discount. It will default to the item/supplier cost, but can be modified based on the agreement with the supplier. It must be greater than zero as this is the cost that would normally be charged for the goods if no deal applied.

Indicates what level of the merchandise hierarchy the record is at. Valid values include: 1 for company- wide (all items), 2 for division, 3 for group, 4 for dept, 5 for class, 6 for subclass, 7 for item parent, 8 for item parent/diff, 9 for item parent/diff, 10 for item parent/diff, 11 for item parent/diff, 12 for transaction level item

ID of the division included in or excluded from the deal component.

ID of the group included in or excluded from the deal component.

ID of the department included in or excluded from the deal component.

ID of the class included in or excluded from the deal component.

ID of the subclass included in or excluded from the deal component.

Alphanumeric value that uniquely identifies the item/group at the level above the item. This value must exist as an item in another row on the item_master table.

Alphanumeric value that uniquely identifies the item/group two levels above the item. This value must exist as both an item and an item parent in another row on the item_master table.

Diff_group or diff_id that differentiates the current item from its item_parent.

Diff_group or diff_id that differentiates the current item from its item_parent.

Diff_group or diff_id that differentiates the current item from its item_parent.

Diff_group or diff_id that differentiates the current item from its item_parent.

Indicates what level of the organizational hierarchy the record is at. Valid values include 1 for chain, 2 for area, 3 for region, 4 for district and 5 for location. These level types will be held on the codes table under a code type of DIOL.

ID of the chain included in or excluded from the deal component.

ID of the area included in or excluded from the deal component.

ID of the region included in or excluded from the deal component.

ID of the district included in or excluded from the deal component.

Location for the item on the deal.

Type of the deal. Valid values are A for annual deal, P for promotional deal, O for PO-specific deal or M for vendor-funded markdown. Deal types will be held on the codes table under a code type of DLHT.

Type of the partner the deal applies to. Valid values are S1 for supplier hierarchy level 1 (e.g. manufacturer), S2 for supplier hierarchy level 2 (e.g. distributor) and S3 for supplier hierarchy level 3 (e.g. wholesaler). Descriptions of these codes will be held on the codes table under a code_type of SUHL.

Level of supplier hierarchy (e.g. manufacturer, distributor or wholesaler), up as a partner in the PARTNER table, used for assigning rebates by a level other than supplier. Rebates at this level will include all eligible supplier/item/country records assigned to this supplier hierarchy level.

Time and date the deal_item_loc_explode record was created.

Number indicating the order in which the deal component should be applied with respect to any other deal components applicable to the item within the deal. This number will be unique across all deal components within the deal. It can only be NULL for an M-type deal (vendor funded markdown).

Specify how much percentage of the total discount should be apportioned from the Get Items unit cost.

Identifies the type of component contribution for a vendor funded-type. Valid values include P (percent) and A (amount). They are held on the deal_comp_type table. This value is required for vendor funded markdown/promotion deals.

Identifies the value of component contribution for a vendor funded-type. The type of the value is identified by the contribution type in the vend_contrib_type. This value is required for vendor funded markdown/promotion deals.