fos


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MonthID DATETIME 19 √ null
Store VARCHAR 50 null
Status VARCHAR 50 √ null
StoreName VARCHAR 75 √ null
ChannelGroup VARCHAR 50 √ null
ChannelCombined VARCHAR 50 √ null
Channel VARCHAR 50 √ null
OrgLevel1 VARCHAR 50 √ null
OrgLevel1_GLCode VARCHAR 50 √ null
OrgLevel2 VARCHAR 58 √ null
OrgLevel2_GLCode VARCHAR 50 √ null
OrgLevel3 VARCHAR 57 √ null
OrgLevel3_GLCode VARCHAR 50 √ null
OrgLevel3_Mgr VARCHAR 52 √ null
OrgLevel3_MgrTitle VARCHAR 66 √ null
OrgLevel3_MgrTitleStartDate DATETIME 19 √ null
StoreCompanyCode VARCHAR 50 √ null
StoreGLCode INT 10 √ null
StoreType VARCHAR 50 √ null
Address VARCHAR 80 √ 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 VARCHAR 50 √ 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 62 √ null
CHID VARCHAR 50 √ null
MasterDealerCode VARCHAR 50 √ null
SubDealer VARCHAR 62 √ 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 55 √ null
RSM_Title VARCHAR 64 √ null
RSM_TitleStartDate DATETIME 19 √ null
RSM_NTID VARCHAR 50 √ null
RSM_PNum VARCHAR 50 √ null
RSM_Email VARCHAR 75 √ null
RSM_Phone VARCHAR 50 √ null
RSM2 VARCHAR 50 √ null
RSM2_TitleStartDate DATETIME 19 √ null
RSM2_Title VARCHAR 50 √ null
RSM2_NTID VARCHAR 50 √ null
RSM2_PNum VARCHAR 50 √ null
RSM2_Email VARCHAR 53 √ null
RSM3 VARCHAR 50 √ null
RSM3_TitleStartDate DATETIME 19 √ null
RSM3_Title VARCHAR 50 √ null
RSM3_NTID VARCHAR 50 √ null
RSM3_PNum VARCHAR 50 √ null
RSM3_Email VARCHAR 50 √ null
AE VARCHAR 52 √ null
AE_Title VARCHAR 66 √ null
AE_TitleStartDate DATETIME 19 √ null
AE_NTID VARCHAR 50 √ null
AE_PNum VARCHAR 50 √ null
AE_Email VARCHAR 64 √ null
VP VARCHAR 50 √ null
VP_NTID VARCHAR 50 √ null
VP_Pnum VARCHAR 50 √ null
VP_Email VARCHAR 56 √ null
MarketDirector VARCHAR 52 √ null
MarketDirector_Title VARCHAR 55 √ null
MarketDirector_TitleStartDate DATETIME 19 √ null
MarketDirector_NTID VARCHAR 50 √ null
MarketDirector_PNum VARCHAR 50 √ null
MarketDirector_Email VARCHAR 66 √ null
OrgLevel3_COR VARCHAR 54 √ null
DM VARCHAR 52 √ null
DM_Title VARCHAR 66 √ null
DM_TitleStartDate DATETIME 19 √ null
DM_NTID VARCHAR 50 √ null
DM_Pnum VARCHAR 50 √ null
DM_Email VARCHAR 65 √ null
OrgLevel3_TPR VARCHAR 57 √ null
SOM VARCHAR 50 √ null
SOM_NTID VARCHAR 50 √ null
SOM_PNum VARCHAR 50 √ null
SOM_Email VARCHAR 65 √ 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 61 √ 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
FLPM VARCHAR 50 √ null
FLPM_NTID VARCHAR 50 √ null
FLPM_PNum VARCHAR 50 √ null
FLPM_Email VARCHAR 63 √ null
LPSM VARCHAR 50 √ null
LPSM_NTID VARCHAR 50 √ null
LPSM_PNum VARCHAR 50 √ null
LPSM_Email VARCHAR 57 √ null
SrMgrSalesTraining VARCHAR 54 √ null
SrMgrSalesTraining_NTID VARCHAR 50 √ null
SrMgrSalesTraining_PNum VARCHAR 50 √ null
SrMgrSalesTraining_Email VARCHAR 64 √ null
SrMgrFOps VARCHAR 50 √ null
SrMgrFOps_NTID VARCHAR 50 √ null
SrMgrFOps_PNum VARCHAR 50 √ null
SrMgrFOps_Email VARCHAR 59 √ null
SrCEM VARCHAR 50 √ null
SrCEM_NTID VARCHAR 50 √ null
SrCEM_Pnum VARCHAR 50 √ null
SrCEM_Email VARCHAR 61 √ null
EffDate DATETIME 19 √ null
RecordModifiedDate DATETIME 19 √ null
isCurrentMonth INT 10 √ null
Rollup VARCHAR 50 √ null

Indexes

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

Relationships

Close relationships within degrees of separation