Documentation

OFFER_DEP_FLD (Enterprise)

INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14001, 'field-value', 'Amount of Discount', NULL, 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14002, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14003, 'field-targetItemCriteria', 'Which items receive the discount?', NULL, 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14004, 'field-offerMatchRules---FULFILLMENT-GROUP', 'What shipping condition is needed to qualify for this offer?', NULL, 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14005, 'field-type', 'Type', 'ORDER_ITEM', 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14006, 'field-discountType', 'Discount Type', 'AMOUNT_OFF', 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14007, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14008, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other offers?', NULL, 0, -14000);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14101, 'field-value', 'Percent Off discount', NULL, 0, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14102, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14103, 'field-targetItemCriteria', 'Which items receive the discount?', NULL, 0, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14104, 'field-offerMatchRules---FULFILLMENT-GROUP', NULL, NULL, 1, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14105, 'field-type', NULL, 'ORDER_ITEM', 1, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14106, 'field-discountType', NULL, 'PERCENT_OFF', 1, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14107, 'field-combinableWithOtherOffers', NULL, 'TRUE', 0, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14108, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other item offers?', NULL, 0, -14101);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14201, 'field-value', 'Amount Off discount', NULL, 0, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14202, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14203, 'field-targetItemCriteria', 'Which items receive the discount?', NULL, 0, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14204, 'field-offerMatchRules---FULFILLMENT-GROUP', NULL, NULL, 1, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14205, 'field-type', NULL, 'ORDER_ITEM', 1, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14206, 'field-discountType', NULL, 'AMOUNT_OFF', 1, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14207, 'field-combinableWithOtherOffers', NULL, 'TRUE', 0, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14208, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other item offers?', NULL, 0, -14102);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14301, 'field-value', 'Percent off order', NULL, 0, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14302, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 0, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14303, 'field-targetItemCriteria', NULL, NULL, 1, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14304, 'field-offerMatchRules---FULFILLMENT-GROUP', NULL, NULL, 1, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14305, 'field-type', NULL, 'ORDER', 1, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14306, 'field-discountType', NULL, 'PERCENT_OFF', 1, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14307, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14308, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other order offers?', NULL, 1, -14106);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14401, 'field-value', 'Amount off order', NULL, 0, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14402, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 0, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14403, 'field-targetItemCriteria', NULL, NULL, 1, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14404, 'field-offerMatchRules---FULFILLMENT-GROUP', NULL, NULL, 1, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14405, 'field-type', NULL, 'ORDER', 1, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14406, 'field-discountType', NULL, 'AMOUNT_OFF', 1, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14407, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14408, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other order offers?', NULL, 1, -14107);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14501, 'field-value', 'Amount of the discount', '100', 0, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14502, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 0, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14503, 'field-targetItemCriteria', 'Which items receive the discount?', NULL, 0, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14504, 'field-offerMatchRules---FULFILLMENT-GROUP', NULL, NULL, 1, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14505, 'field-type', NULL, 'ORDER_ITEM', 1, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14506, 'field-discountType', NULL, 'PERCENT_OFF', 1, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14507, 'field-combinableWithOtherOffers', NULL, 'TRUE', 0, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14508, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other item offers?', NULL, 0, -14105);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14601, 'field-value', NULL, '100', 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14602, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14603, 'field-targetItemCriteria', NULL, NULL, 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14604, 'field-offerMatchRules---FULFILLMENT-GROUP', 'What shipping criteria is needed for this discount?', NULL, 0, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14605, 'field-type', NULL, 'FULFILLMENT_GROUP', 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14606, 'field-discountType', NULL, 'PERCENT_OFF', 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14607, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14608, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other shipping offers?', NULL, 1, -14108);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14701, 'field-value', 'Amount of discount', NULL, 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14702, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14703, 'field-targetItemCriteria', 'Which items receive the discount?', NULL, 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14704, 'field-offerMatchRules---FULFILLMENT-GROUP', 'What shipping criteria is needed for this discount?', NULL, 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14705, 'field-type', NULL, 'ORDER_ITEM', 1, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14706, 'field-discountType', 'Discount Type', NULL, 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14707, 'field-combinableWithOtherOffers', NULL, 'TRUE', 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14708, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other item offers?', NULL, 0, -14109);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14801, 'field-value', 'Amount of discount', NULL, 0, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14802, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14803, 'field-targetItemCriteria', NULL, NULL, 1, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14804, 'field-offerMatchRules---FULFILLMENT-GROUP', 'What shipping criteria is needed for this discount?', NULL, 0, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14805, 'field-type', NULL, 'ORDER', 1, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14806, 'field-discountType', 'Discount Type', NULL, 0, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14807, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14808, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other order offers?', NULL, 1, -14110);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14901, 'field-value', 'Amount of discount', NULL, 0, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14902, 'field-qualifyingItemCriteria', 'What items are required to qualify for the discount?', NULL, 1, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14903, 'field-targetItemCriteria', NULL, NULL, 1, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14904, 'field-offerMatchRules---FULFILLMENT-GROUP', 'What shipping criteria is needed for this discount?', NULL, 1, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14905, 'field-type', NULL, 'FULFILLMENT_GROUP', 1, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14906, 'field-discountType', 'Discount Type', NULL, 0, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14907, 'field-combinableWithOtherOffers', NULL, 'FALSE', 0, -14103);
INSERT INTO BLC_OFFER_DEP_FLD (OFFER_DEP_FLD_ID, FIELD, FIELD_LABEL_OVERRIDE, FIELD_VALUE_OVERRIDE, IS_HIDDEN, OFFER_TEMPLATE_ID) VALUES (-14908, 'field-stackableWithOtherOffers', 'Can this offer be stacked with other shipping offers?', NULL, 1, -14103);