fos_old


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Plant VARCHAR 50 √ null
Channel VARCHAR 50 √ null
OrgLevel1 VARCHAR 50 √ null
OrgLevel2 VARCHAR 54 √ null
OrgLevel3 VARCHAR 52 √ null
CompanyCode VARCHAR 50 √ null
GLCode INT 10 √ null
StoreName VARCHAR 64 √ null
StoreType VARCHAR 50 √ null
Status VARCHAR 50 √ null
Address VARCHAR 75 √ null
City VARCHAR 50 √ null
County VARCHAR 50 √ null
State VARCHAR 50 √ null
Zip VARCHAR 50 √ null
Phone VARCHAR 50 √ null
OpenDate DATETIME 19 √ null
ReloDate DATETIME 19 √ null
ClosedDate DATETIME 19 √ null
RSM VARCHAR 53 √ null
RSM_NTID VARCHAR 50 √ null
RSM_Pnumber INT 10 √ null
RSM_Email VARCHAR 75 √ null
RSM_Phone VARCHAR 50 √ null
VP VARCHAR 50 √ null
VP_Email VARCHAR 75 √ null
VP_NTID VARCHAR 50 √ null
VP_PNumber VARCHAR 50 √ null
OrgLevel1_GLCode VARCHAR 50 √ null
MarketDirector VARCHAR 50 √ null
MarketDirector_Email VARCHAR 75 √ null
MarketDirector_NTID VARCHAR 50 √ null
MarketDirector_PNumber VARCHAR 50 √ null
OrgLevel2_GLCode VARCHAR 50 √ null
DM VARCHAR 50 √ null
DM_Email VARCHAR 75 √ null
DM_NTID VARCHAR 50 √ null
DM_Pnumber VARCHAR 50 √ null
OrgLevel3_GLCode VARCHAR 50 √ null
StoreModel VARCHAR 50 √ null
Category VARCHAR 50 √ null
SubCategory VARCHAR 50 √ null
TPRType VARCHAR 50 √ null
CompStatus VARCHAR 50 √ null
Hispanicstore VARCHAR 50 √ null
Partner VARCHAR 64 √ null
StoreEmail VARCHAR 75 √ null
DirSalesOpsBusPtnr VARCHAR 50 √ null
DirSalesOpsBusPtnr_Email VARCHAR 75 √ null
OPSManager VARCHAR 50 √ null
OPSManager_Email VARCHAR 75 √ null
OPSManager_NTID VARCHAR 50 √ null
OPSManager_PNumber VARCHAR 50 √ null
SOM VARCHAR 50 √ null
SOM_Email VARCHAR 75 √ null
SOM_NTID VARCHAR 50 √ null
SOM_PNumber VARCHAR 50 √ null
HighVolumeStore VARCHAR 50 √ null
SM VARCHAR 50 √ null
SM_Email VARCHAR 75 √ null
SM_NTID VARCHAR 50 √ null
SM_PNumber VARCHAR 50 √ null
AM VARCHAR 50 √ null
AM_Email VARCHAR 75 √ null
AM_NTID VARCHAR 50 √ null
AM_PNumber VARCHAR 50 √ null
SNAM VARCHAR 50 √ null
SNAM_Email VARCHAR 75 √ null
SNAM_NTID VARCHAR 50 √ null
SNAM_PNumber VARCHAR 50 √ null
FLPM VARCHAR 50 √ null
FLPM_Email VARCHAR 75 √ null
FLPM_NTID VARCHAR 50 √ null
FLPM_PNumber VARCHAR 50 √ null
LPSM VARCHAR 50 √ null
LPSM_Email VARCHAR 75 √ null
LPSM_NTID VARCHAR 50 √ null
LPSM_PNumber VARCHAR 50 √ null
TBuilderSiteID INT 10 √ null
DistrictSpecialist VARCHAR 50 √ null
DistrictSpecialist_Email VARCHAR 75 √ null
DistrictSpecialist_NTID VARCHAR 50 √ null
DistrictSpecialist_PNumber VARCHAR 50 √ null
SrMgSalesTraining VARCHAR 50 √ null
SrMgSalesTraining_PNumber VARCHAR 50 √ null
AE VARCHAR 50 √ null
AE_Email VARCHAR 75 √ null
AE_NTID VARCHAR 50 √ null
AE_PNumber VARCHAR 50 √ null
SrMgrFOps VARCHAR 50 √ null
SrMgrFOps_Email VARCHAR 75 √ null
SrMgrFOps_NTID VARCHAR 50 √ null
SrMgrFOps_PNumber VARCHAR 50 √ null
SubDealer VARCHAR 58 √ null
EffDate DATETIME 19 √ null
DirSalesOpsBusPtnr_PNumber VARCHAR 50 √ null
DirSalesOpsBusPtnr_NTID VARCHAR 50 √ null
DMAMarket VARCHAR 56 √ null
SrMgSalesTraining_Email VARCHAR 57 √ null
SrMgSalesTraining_NTID VARCHAR 50 √ null
CHID INT 10 √ null
pico_contract_holder.chid Implied Constraint R
RSM2 VARCHAR 50 √ null
RSM2_NTID VARCHAR 50 √ null
RSM2_Email VARCHAR 75 √ null
RSM2_Pnumber VARCHAR 50 √ null
MarketSegment VARCHAR 50 √ null
OrgLevel3_Node VARCHAR 50 √ null
AD_TPR VARCHAR 50 √ null
AD_TPR_NTID VARCHAR 50 √ null
AD_TPR_Email VARCHAR 75 √ null
AD_TPR_Pnumber VARCHAR 50 √ null
RSM3 VARCHAR 50 √ null
RSM3_NTID VARCHAR 50 √ null
RSM3_Email VARCHAR 75 √ null
RSM3_Pnumber VARCHAR 50 √ null
MasterDealerCode INT 10 √ null
SrCEM VARCHAR 50 √ null
SrCEM_NTID VARCHAR 50 √ null
SrCEM_Email VARCHAR 75 √ null
SrCEM_Pnumber VARCHAR 50 √ null
NewRampDate DATETIME 19 √ null

Relationships

Close relationships within degrees of separation