fos_metro


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MonthID DATETIME 19 √ null
Plant VARCHAR 50 √ null
MDealerCode VARCHAR 50 √ null
MetroNowID INT 10 √ null
LocationCode VARCHAR 50 √ null
SAP_Plant VARCHAR 50 √ null
MetroNowIDOrigin VARCHAR 20 √ null
MetroNowIDOriginStartDate DATETIME 19 √ null
MetroNowIDOriginEndDate DATETIME 19 √ null
MetroNowIDPrevious INT 10 √ null
TBuilderSiteID VARCHAR 20 √ null
LocationType VARCHAR 55 √ null
Channel VARCHAR 50 √ null
OrgLevel1 VARCHAR 50 √ null
OrgLevel1GLCode INT 10 √ null
OrgLevel2 VARCHAR 50 √ null
OrgLevel2GLCode INT 10 √ null
OrgLevel3 VARCHAR 52 √ null
OrgLevel3GLCode INT 10 √ null
OrgLevel4 VARCHAR 62 √ null
OrgLevel4GLCode VARCHAR 20 √ null
Status VARCHAR 50 √ null
StoreName VARCHAR 72 √ null
CostCenter VARCHAR 20 √ null
Address VARCHAR 68 √ null
City VARCHAR 50 √ null
County VARCHAR 20 √ null
State VARCHAR 50 √ null
Zip VARCHAR 50 √ null
Phone VARCHAR 50 √ null
StoreEmail VARCHAR 70 √ null
Longitude DECIMAL 28,14 √ null
Latitude DECIMAL 28,14 √ null
OpenDate DATETIME 19 √ null
ClosedDate DATETIME 19 √ null
CompStatus VARCHAR 50 √ null
DMAMarket VARCHAR 56 √ null
StoreType VARCHAR 50 √ null
IDA_Type VARCHAR 50 √ null
IDA_Market INT 10 √ null
Category VARCHAR 50 √ null
Partner VARCHAR 71 √ null
OwnerRecordId INT 10 √ null
Operator VARCHAR 72 √ null
MetroMarket VARCHAR 59 √ null
NationalDealer VARCHAR 50 √ null
MDM_RSM_Phone BIGINT 19 √ null
MDM_RSM VARCHAR 57 √ null
MDM_RSM_Email VARCHAR 70 √ null
MDM_RSM_NTID VARCHAR 50 √ null
MDM_RSM_Pnumber VARCHAR 50 √ null
MDM_RSM_Title VARCHAR 65 √ null
RSM_Phone VARCHAR 20 √ null
RSM VARCHAR 50 √ null
RSM_Email VARCHAR 70 √ null
RSM_NTID VARCHAR 50 √ null
RSM_Pnumber VARCHAR 20 √ null
RSM_Title VARCHAR 50 √ null
MDM_Phone BIGINT 19 √ null
MDM VARCHAR 57 √ null
MDM_Email VARCHAR 70 √ null
MDM_NTID VARCHAR 50 √ null
MDM_Pnumber VARCHAR 50 √ null
MDM_Title VARCHAR 65 √ null
OrgLevel1Leader VARCHAR 50 √ null
OrgLevel1LeaderEmail VARCHAR 70 √ null
OrgLevel1LeaderNTID VARCHAR 50 √ null
OrgLevel1LeaderPNumber VARCHAR 50 √ null
OrgLevel1LeaderTitle VARCHAR 53 √ null
OrgLevel2Leader VARCHAR 50 √ null
OrgLevel2LeaderEmail VARCHAR 70 √ null
OrgLevel2LeaderNTID VARCHAR 50 √ null
OrgLevel2LeaderPNumber VARCHAR 50 √ null
OrgLevel2LeaderTitle VARCHAR 55 √ null
OrgLevel3Leader VARCHAR 51 √ null
OrgLevel3LeaderEmail VARCHAR 70 √ null
OrgLevel3LeaderNTID VARCHAR 50 √ null
OrgLevel3LeaderPNumber VARCHAR 50 √ null
OrgLevel3LeaderTitle VARCHAR 55 √ null
OrgLevel4Leader VARCHAR 56 √ null
OrgLevel4LeaderEmail VARCHAR 70 √ null
OrgLevel4LeaderNTID VARCHAR 50 √ null
OrgLevel4LeaderPNumber VARCHAR 50 √ null
OrgLevel4LeaderTitle VARCHAR 55 √ null
OrgLevel4RSLeader VARCHAR 50 √ null
OrgLevel4RSLeaderEmail VARCHAR 70 √ null
OrgLevel4RSLeaderNTID VARCHAR 50 √ null
OrgLevel4RSLeaderPNumber VARCHAR 20 √ null
OrgLevel4ISLeader VARCHAR 56 √ null
OrgLevel4ISLeaderEmail VARCHAR 70 √ null
OrgLevel4ISLeaderNTID VARCHAR 50 √ null
OrgLevel4ISLeaderPNumber VARCHAR 50 √ null
SrMgrSalesTraining VARCHAR 51 √ null
SrMgrSalesTraining_Email VARCHAR 70 √ null
SrMgrSalesTraining_NTID VARCHAR 50 √ null
SrMgrSalesTraining_Pnumber VARCHAR 50 √ null
SrMgrSalesTraining_Title VARCHAR 56 √ null
MgrSalesTraining VARCHAR 50 √ null
MgrSalesTraining_Email VARCHAR 70 √ null
MgrSalesTraining_NTID VARCHAR 50 √ null
MgrSalesTraining_Pnumber VARCHAR 50 √ null
MgrSalesTraining_Title VARCHAR 53 √ null
DirFieldBusDevelopment VARCHAR 50 √ null
DirFieldBusDevelopment_Email VARCHAR 70 √ null
DirFieldBusDevelopment_NTID VARCHAR 50 √ null
DirFieldBusDevelopment_Pnumber VARCHAR 50 √ null
DirFieldBusDevelopment_Title VARCHAR 69 √ null
MgrFieldBusDevelopment VARCHAR 50 √ null
MgrFieldBusDevelopment_Email VARCHAR 70 √ null
MgrFieldBusDevelopment_NTID VARCHAR 50 √ null
MgrFieldBusDevelopment_Pnumber VARCHAR 20 √ null
MgrFieldBusDevelopment_Title VARCHAR 20 √ null
DirFieldOps VARCHAR 50 √ null
DirFieldOps_Email VARCHAR 70 √ null
DirFieldOps_NTID VARCHAR 50 √ null
DirFieldOps_Pnumber VARCHAR 50 √ null
DirFieldOps_Title VARCHAR 64 √ null
SrMgrFieldOps VARCHAR 50 √ null
SrMgrFieldOps_Email VARCHAR 70 √ null
SrMgrFieldOps_NTID VARCHAR 50 √ null
SrMgrFieldOps_Pnumber VARCHAR 50 √ null
SrMgrFieldOps_Title VARCHAR 58 √ null
SalesCoordinator1 VARCHAR 50 √ null
SalesCoordinator1_Email VARCHAR 70 √ null
SalesCoordinator1_NTID VARCHAR 50 √ null
SalesCoordinator1_Pnumber VARCHAR 50 √ null
SalesCoordinator1_Title VARCHAR 54 √ null
SalesCoordinator2 VARCHAR 50 √ null
SalesCoordinator2_Email VARCHAR 70 √ null
SalesCoordinator2_NTID VARCHAR 50 √ null
SalesCoordinator2_Pnumber VARCHAR 50 √ null
SalesCoordinator2_Title VARCHAR 50 √ null
SalesCoordinator3 VARCHAR 50 √ null
SalesCoordinator3_Email VARCHAR 70 √ null
SalesCoordinator3_NTID VARCHAR 50 √ null
SalesCoordinator3_Pnumber VARCHAR 50 √ null
SalesCoordinator3_Title VARCHAR 50 √ null
SrMgrDealerSupportandOutreach VARCHAR 50 √ null
SrMgrDealerSupportandOutreach_Email VARCHAR 70 √ null
SrMgrDealerSupportandOutreach_NTID VARCHAR 50 √ null
SrMgrDealerSupportandOutreach_Pnumber VARCHAR 50 √ null
SrMgrDealerSupportandOutreach_Title VARCHAR 67 √ null
EffDate DATETIME 19 √ null
ActiveDuringMonth VARCHAR 50 √ null
RecordModifiedDate DATETIME 19 √ null
MDM_RSM_Slicer VARCHAR 59 √ null

Relationships

Close relationships within degrees of separation