<cfif (session.EnablePreferredCustomerAutoAssign EQ 1) AND (session.EnablePreferredCustomerAutoAssignStore NEQ 0)>

			<cfquery name="GetCustomerID" datasource="#session.TPCDS#" username="#session.QSAUsername#" password="#session.QSAPassword#">
			SELECT CUSTGroup
			FROM #session.TPPrefix##session.TPCDS#.dbo.PreferredCustomers
			WHERE CUSTClient = '#session.TPC.AccountID#'
				AND CUSTId = '{{cust_username}}'
			</cfquery>
			<!--- If Customer Belongs to a group ignore, if not assign. --->
			<cfif GetCustomerID.recordcount eq 0> <!-------- Start Record Count ----->

			<cfquery name="AddCustomerID" datasource="#session.TPCDS#" username="#session.QSAUsername#" password="#session.QSAPassword#" timeout="20">
			Insert Into #session.TPPrefix##session.TPCDS#.dbo.PreferredCustomers (CUSTClient,CUSTGroup, CUSTID, CUSTRate)
			Values('#session.TPC.AccountID#','#session.EnablePreferredCustomerAutoAssignStore#','{{cust_username}}','99999')
			</cfquery>

			</cfif>

	</cfif>