Table: promotioncode

InternalId	codehelp	codepattern	combinationtype	code	usetype	usetype_refid	customform	customform_refid	customercategory	customergroup	customergroup_refid	customers	description	discount	discount_refid	rate	applydiscountto	applydiscountto_refid	enddate	enddate_dt	externalid	discounttype	itemslabel	discounteditemssavedsearch	itemssavedsearch	discounteditemssavedsearch_refid	itemssavedsearch_refid	implementation_refid	couponcodefile	isinactive	id	itemquantifier	location	minimumorderamountcheck	applydiscounttotype	name	numbertogenerate	repeatdiscount	customergrouppreference	usematerializedsavedsearch	discountmessage	audience	specificitemscheck	saleschannels	whatthecustomerneedstobuy	startdate	startdate_dt	canbeautoapplied	canbeautoappliedmessage	baserecordtype	customergroupstatus	customwhence	entryformquerystring	implementation	isdynamic	nsbrowserenv	selectedtab	templatestored	type
1			ITEMLINEEXCLUSIVE	Winterpromo10%	Multiple Uses	MULTIPLEUSES	Item Promotion	-10501						Partner Discount	-6	0.000000	Unlimited amount of times	ALLSALES	11/30/2018	11/30/2018 12:00:00 AM		flat						default		F	1	1		F	EACHDISCITEM	Test item promo 10%		F	F	USECACHEDSAVEDSEARCH		EVERYONE	T	ALL	MINIMUMORDERAMOUNTORSPECIFICITEMS	11/28/2018	11/28/2018 12:00:00 AM	F		promotioncode			e=T&id=1		F			T	referralcode
2			ITEMLINEEXCLUSIVE		Single Use	SINGLEUSE	Item Promotion	-10501						Promotion	7548	25.000000	Unlimited amount of times	ALLSALES	4/13/2020	4/13/2020 12:00:00 AM		percent		Custom Item Search	Custom Item Search	834	834	default		T	2	1		F	EACHDISCITEM	STEAM SPA ROTATION 1 PROMO		F	F	USECACHEDSAVEDSEARCH		EVERYONE	T	ALL	MINIMUMORDERAMOUNTORSPECIFICITEMS	3/9/2020	3/9/2020 12:00:00 AM	F		promotioncode			e=T&id=2		F			T	referralcode

Page 1