fos_l4


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MonthID DATETIME 19 √ null
Store VARCHAR 50 null
Status VARCHAR 50 √ null
StoreName VARCHAR 67 √ null
ChannelGroup VARCHAR 50 √ null
ChannelCombined VARCHAR 50 √ null
Channel VARCHAR 50 √ null
OrgLevel1 VARCHAR 50 √ null
OrgLevel1_GLCode VARCHAR 50 √ null
OrgLevel2 VARCHAR 51 √ null
OrgLevel2_GLCode VARCHAR 50 √ null
OrgLevel3 VARCHAR 55 √ null
OrgLevel3_GLCode VARCHAR 50 √ null
OrgLevel4 VARCHAR 52 √ null
OrgLevel4_GLCode VARCHAR 50 √ null
OrgLevel4Leader VARCHAR 50 √ null
OrgLevel4Leader_Title VARCHAR 60 √ null
OrgLevel4Leader_TitleStartDate DATETIME 19 √ null
OrgLevel4Leader_PNum VARCHAR 50 √ null
StoreCompanyCode VARCHAR 50 √ null
StoreGLCode INT 10 √ null
StoreType VARCHAR 50 √ null
Address VARCHAR 77 √ null
City VARCHAR 50 √ null
County VARCHAR 50 √ null
State VARCHAR 50 √ null
Zip VARCHAR 50 √ null
Phone VARCHAR 50 √ null
Longitude VARCHAR 50 √ null
Latitude VARCHAR 50 √ null
MarketSegment VARCHAR 50 √ null
StoreEmail VARCHAR 58 √ null
StoreModel VARCHAR 50 √ null
Training_Room VARCHAR 50 √ null
TBuilderSiteID INT 10 √ null
Category VARCHAR 50 √ null
SubCategory VARCHAR 50 √ null
TPRType VARCHAR 50 √ null
CompStatus VARCHAR 50 √ null
Hispanicstore VARCHAR 50 √ null
DMAMarket VARCHAR 56 √ null
MasterDealer VARCHAR 64 √ null
CHID VARCHAR 50 √ null
MasterDealerCode VARCHAR 50 √ null
SubDealer VARCHAR 64 √ null
Apple2TMOStore VARCHAR 50 √ null
HighVolumeStore VARCHAR 50 √ null
OpenDate DATETIME 19 √ null
FutureOpenDate DATETIME 19 √ null
NewRampDate DATETIME 19 √ null
ReloDate DATETIME 19 √ null
ClosedDate DATETIME 19 √ null
RSM VARCHAR 54 √ null
RSM_Title VARCHAR 66 √ null
RSM_TitleStartDate DATETIME 19 √ null
RSM_NTID VARCHAR 50 √ null
RSM_Pnum VARCHAR 50 √ null
RSM_Email VARCHAR 69 √ null
RSM_Phone VARCHAR 50 √ null
RSM2 VARCHAR 50 √ null
RSM2_TitleStartDate VARCHAR 50 √ null
RSM2_Title VARCHAR 50 √ null
RSM2_NTID VARCHAR 50 √ null
RSM2_Pnum VARCHAR 50 √ null
RSM2_Email VARCHAR 50 √ null
RSM3 VARCHAR 50 √ null
RSM3_Title VARCHAR 50 √ null
RSM3_TitleStartDate VARCHAR 50 √ null
RSM3_NTID VARCHAR 50 √ null
RSM3_Pnum VARCHAR 50 √ null
RSM3_Email VARCHAR 50 √ null
AE VARCHAR 50 √ null
AE_Title VARCHAR 66 √ null
AE_TitleStartDate DATETIME 19 √ null
AE_NTID VARCHAR 50 √ null
AE_PNum VARCHAR 50 √ null
AE_Email VARCHAR 63 √ null
OrgLevel1Leader VARCHAR 50 √ null
OrgLevel1Leader_NTID VARCHAR 50 √ null
OrgLevel1Leader_PNum VARCHAR 50 √ null
OrgLevel1Leader_Email VARCHAR 54 √ null
OrgLevel2Leader VARCHAR 50 √ null
OrgLevel2Leader_NTID VARCHAR 50 √ null
OrgLevel2Leader_PNum VARCHAR 50 √ null
OrgLevel2Leader_Email VARCHAR 54 √ null
OrgLevel3Leader VARCHAR 50 √ null
OrgLevel3Leader_Title VARCHAR 55 √ null
OrgLevel3Leader_TitleStartDate DATETIME 19 √ null
OrgLevel3Leader_NTID VARCHAR 50 √ null
OrgLevel3Leader_PNum VARCHAR 50 √ null
OrgLevel3Leader_Email VARCHAR 57 √ null
OrgLevel4_COR VARCHAR 51 √ null
OrgLevel4CORLeader VARCHAR 50 √ null
OrgLevel4CORLeader_Title VARCHAR 60 √ null
OrgLevel4CORLeader_TitleStartDate DATETIME 19 √ null
OrgLevel4CORLeader_NTID VARCHAR 50 √ null
OrgLevel4CORLeader_Pnum VARCHAR 50 √ null
OrgLevel4CORLeader_Email VARCHAR 60 √ null
OrgLevel4_TPR VARCHAR 52 √ null
OrgLevel4TPRLeader VARCHAR 50 √ null
OrgLevel4TPRLeader_NTID VARCHAR 50 √ null
OrgLevel4TPRLeader_PNum VARCHAR 50 √ null
OrgLevel4TPRLeader_Email VARCHAR 60 √ null
SM VARCHAR 50 √ null
SM_NTID VARCHAR 50 √ null
SM_PNum VARCHAR 50 √ null
SM_Email VARCHAR 62 √ null
DirSalesOpsBusPtnr VARCHAR 50 √ null
DirSalesOpsBusPtnr_NTID VARCHAR 50 √ null
DirSalesOpsBusPtnr_PNum VARCHAR 50 √ null
DirSalesOpsBusPtnr_Email VARCHAR 53 √ null
OPSManager VARCHAR 50 √ null
OPSManager_NTID VARCHAR 50 √ null
OPSManager_PNum VARCHAR 50 √ null
OPSManager_Email VARCHAR 63 √ null
AM VARCHAR 50 √ null
AM_NTID VARCHAR 50 √ null
AM_PNumber VARCHAR 50 √ null
AM_Email VARCHAR 60 √ null
AD_TPR VARCHAR 50 √ null
AD_TPR_NTID VARCHAR 50 √ null
AD_TPR_Pnum VARCHAR 50 √ null
AD_TPR_Email VARCHAR 61 √ null
SNAM VARCHAR 50 √ null
SNAM_NTID VARCHAR 50 √ null
SNAM_PNum VARCHAR 50 √ null
SNAM_Email VARCHAR 56 √ null
FAPM VARCHAR 50 √ null
FAPM_NTID VARCHAR 50 √ null
FAPM_PNum VARCHAR 50 √ null
FAPM_Email VARCHAR 63 √ null
APSM VARCHAR 50 √ null
APSM_NTID VARCHAR 50 √ null
APSM_PNum VARCHAR 50 √ null
APSM_Email VARCHAR 55 √ null
SrMgrSalesTraining VARCHAR 50 √ null
SrMgrSalesTraining_NTID VARCHAR 50 √ null
SrMgrSalesTraining_PNum VARCHAR 50 √ null
SrMgrSalesTraining_Email VARCHAR 57 √ null
SrMgrFOps VARCHAR 50 √ null
SrMgrFOps_NTID VARCHAR 50 √ null
SrMgrFOps_PNum VARCHAR 50 √ null
SrMgrFOps_Email VARCHAR 54 √ null
SrCEM VARCHAR 50 √ null
SrCEM_NTID VARCHAR 50 √ null
SrCEM_Pnum VARCHAR 50 √ null
SrCEM_Email VARCHAR 54 √ null
EffDate DATETIME 19 √ null
RecordModifiedDate DATETIME 19 √ null
isCurrentMonth INT 10 √ null
Rollup VARCHAR 50 √ null
RampStore VARCHAR 50 √ null
Layer3 VARCHAR 50 √ null
REMO VARCHAR 50 √ null
SDMHomeEnt VARCHAR 50 √ null
SDMHomeEnt_NTID VARCHAR 50 √ null
SDMHomeEnt_PNumber VARCHAR 50 √ null
SDMHomeEnt_Email VARCHAR 50 √ null
Market_Manager VARCHAR 50 √ null
Market_Manager_EMAIL VARCHAR 50 √ null
Market_Manager_NTID VARCHAR 50 √ null
Market_Manager_PNum VARCHAR 50 √ null
RetailDevelopmentManager VARCHAR 50 √ null
RetailDevelopmentManager_Email VARCHAR 50 √ null
RetailDevelopmentManager_NTID VARCHAR 50 √ null
RetailDevelopmentManager_Pnum VARCHAR 50 √ null
MSA VARCHAR 75 √ null
MSA_ID VARCHAR 11 √ null
SrTrainerSales VARCHAR 50 √ null
SrTrainerSales_Email VARCHAR 50 √ null
SrTrainerSales_NTID VARCHAR 50 √ null
SrTrainerSales_Pnum VARCHAR 50 √ null
SeatingCapacity VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc Store
IX_fos_l4_site_id Performance Asc TBuilderSiteID

Relationships

Close relationships within degrees of separation