Skip to main content

Projects & Milestones - Key Tables

Full column listings for the 3 key tables in this category.

MileStone (17 columns)

# Column Type Length Nullable Default
1 MSTid int NO
2 MSTFaultId int YES
3 MSTName nvarchar 1000 YES
4 MSTSequence int YES
5 MSTStartDate datetime YES
6 MSTTargetDate datetime YES
7 MSTState int YES
8 msttargetdays int YES ((0))
9 mststartdays int YES ((0))
10 mstvalue float YES
11 mstprocesseddate datetime YES ((0))
12 mstinvoicenumber nvarchar 1000 YES
13 msfromtemplateid int YES ((0))
14 mstvalueperc int YES
15 mstheaderid int YES
16 mstlineid int YES
17 mstitemid int YES

PROJECTNOTE (5 columns)

# Column Type Length Nullable Default
1 PNid int NO
2 PNprojectid int YES
3 PNdate datetime YES
4 PNwho int YES
5 PNmemo ntext 1073741823 YES

TASK (10 columns)

# Column Type Length Nullable Default
1 TAid int NO
2 TASubject nvarchar 4000 YES
3 TANote ntext 1073741823 YES
4 TAUnum int YES ((0))
5 TADueDate datetime YES
6 TAReminderMinutes int YES ((0))
7 TAFaultid int YES ((0))
8 TAStatus int YES ((0))
9 TAReminderStatus int YES ((0))
10 TAReminderdate datetime YES
Back to top