Viewing post 1 (of 2 total)
The view is automatically generated by third-party software based on a web form definition we create and is defined as follows:
CREATE view [dbo].[DallasMobile] (
SalesResult,RejectionStage0,RejectionStage1,RejectionStage2,RejectionNotes,
DoNotContactReason,BusinessName,ProbabilityIndex,AccountType,FollowUpDateIndex,
StreetNumber,ESIID,NoOutcomeReason,FollowUpDate,SwapDiscountPct,Notes,Priority,
Result,ProbabilityToClose,SwapDiscountValue,FollowUpTime,SICDescription,
StreetName,LastUpdateDate,ContactFirstName,ContactLastName,TerritoryID,City,
EstimatedUsagekWh,FollowupContactFirstName,PriceperkW,PriceperkWh,
FollowupContactLastName,REP,State,JobTitle,ContactTelephoneNumber,Zip,
ContractExpirationDate,FollowUpNotes,PerkWhAveragePrice,NumberofTimesContacted,
LastDateWithTXUE,ContactFaxNumber,RelatedLocations,RelatedLookupRecordNumber,
ActionItemId, RecordId, CreatedAt, CreatedBy, LastModifiedAt, LastModifiedBy,
CurrentStateName)
with SCHEMABINDING
as...
September 12, 2007 at 8:17 am
Viewing post 1 (of 2 total)