Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00682
Product: FieldService (949)
Series: Project
Display Name: svcContractSiteCoveragePeriod DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: SVC00682
Technical Name: svcContractSiteCoveragePeriodSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 CONSTS 
Contract Record Type DDL_Contract_Status Integer 2 0 2 CONTNBR Contract Number STR11 String 12 11 3 LNSEQNBR Line SEQ Number Sequence_Number Currency 10 19 4 svcCoveragePeriodStart2 svcCoveragePeriodStart2 TM6 Time 4 6 5 svcCoveragePeriodStart2_1 svcCoveragePeriodStart2[1] TM6 Time 4 6 6 svcCoveragePeriodStart2_2 svcCoveragePeriodStart2[2] TM6 Time 4 6 7 svcCoveragePeriodStart2_3 svcCoveragePeriodStart2[3] TM6 Time 4 6 8 svcCoveragePeriodStart2_4 svcCoveragePeriodStart2[4] TM6 Time 4 6 9 svcCoveragePeriodStart2_5 svcCoveragePeriodStart2[5] TM6 Time 4 6 10 svcCoveragePeriodStart2_6 svcCoveragePeriodStart2[6] TM6 Time 4 6 11 svcCoveragePeriodStart2_7 svcCoveragePeriodStart2[7] TM6 Time 4 6 12 svcCoveragePeriodEnd2 svcCoveragePeriodEnd2 TM6 Time 4 6 13 svcCoveragePeriodEnd2_1 svcCoveragePeriodEnd2[1] TM6 Time 4 6 14 svcCoveragePeriodEnd2_2 svcCoveragePeriodEnd2[2] TM6 Time 4 6 15 svcCoveragePeriodEnd2_3 svcCoveragePeriodEnd2[3] TM6 Time 4 6 16 svcCoveragePeriodEnd2_4 svcCoveragePeriodEnd2[4] TM6 Time 4 6 17 svcCoveragePeriodEnd2_5 svcCoveragePeriodEnd2[5] TM6 Time 4 6 18 svcCoveragePeriodEnd2_6 svcCoveragePeriodEnd2[6] TM6 Time 4 6 19 svcCoveragePeriodEnd2_7 svcCoveragePeriodEnd2[7] TM6 Time 4 6 20 svcCoveragePeriodStart3 svcCoveragePeriodStart3 TM6 Time 4 6 21 svcCoveragePeriodStart3_1 svcCoveragePeriodStart3[1] TM6 Time 4 6 22 svcCoveragePeriodStart3_2 svcCoveragePeriodStart3[2] TM6 Time 4 6 23 svcCoveragePeriodStart3_3 svcCoveragePeriodStart3[3] TM6 Time 4 6 24 svcCoveragePeriodStart3_4 svcCoveragePeriodStart3[4] TM6 Time 4 6 25 svcCoveragePeriodStart3_5 svcCoveragePeriodStart3[5] TM6 Time 4 6 26 svcCoveragePeriodStart3_6 svcCoveragePeriodStart3[6] TM6 Time 4 6 27 svcCoveragePeriodStart3_7 svcCoveragePeriodStart3[7] TM6 Time 4 6 28 svcCoveragePeriodEnd3 svcCoveragePeriodEnd3 TM6 Time 4 6 29 svcCoveragePeriodEnd3_1 svcCoveragePeriodEnd3[1] TM6 Time 4 6 30 svcCoveragePeriodEnd3_2 svcCoveragePeriodEnd3[2] TM6 Time 4 6 31 svcCoveragePeriodEnd3_3 svcCoveragePeriodEnd3[3] TM6 Time 4 6 32 svcCoveragePeriodEnd3_4 svcCoveragePeriodEnd3[4] TM6 Time 4 6 33 svcCoveragePeriodEnd3_5 svcCoveragePeriodEnd3[5] TM6 Time 4 6 34 svcCoveragePeriodEnd3_6 svcCoveragePeriodEnd3[6] TM6 Time 4 6 35 svcCoveragePeriodEnd3_7 svcCoveragePeriodEnd3[7] TM6 Time 4 6 36 svcCoveragePeriodStart4 svcCoveragePeriodStart4 TM6 Time 4 6 37 svcCoveragePeriodStart4_1 svcCoveragePeriodStart4[1] TM6 Time 4 6 38 svcCoveragePeriodStart4_2 svcCoveragePeriodStart4[2] TM6 Time 4 6 39 svcCoveragePeriodStart4_3 svcCoveragePeriodStart4[3] TM6 Time 4 6 40 svcCoveragePeriodStart4_4 svcCoveragePeriodStart4[4] TM6 Time 4 6 41 svcCoveragePeriodStart4_5 svcCoveragePeriodStart4[5] TM6 Time 4 6 42 svcCoveragePeriodStart4_6 svcCoveragePeriodStart4[6] TM6 Time 4 6 43 svcCoveragePeriodStart4_7 svcCoveragePeriodStart4[7] TM6 Time 4 6 44 svcCoveragePeriodEnd4 svcCoveragePeriodEnd4 TM6 Time 4 6 45 svcCoveragePeriodEnd4_1 svcCoveragePeriodEnd4[1] TM6 Time 4 6 46 svcCoveragePeriodEnd4_2 svcCoveragePeriodEnd4[2] TM6 Time 4 6 47 svcCoveragePeriodEnd4_3 svcCoveragePeriodEnd4[3] TM6 Time 4 6 48 svcCoveragePeriodEnd4_4 svcCoveragePeriodEnd4[4] TM6 Time 4 6 49 svcCoveragePeriodEnd4_5 svcCoveragePeriodEnd4[5] TM6 Time 4 6 50 svcCoveragePeriodEnd4_6 svcCoveragePeriodEnd4[6] TM6 Time 4 6 51 svcCoveragePeriodEnd4_7 svcCoveragePeriodEnd4[7] TM6 Time 4 6 52 DEX_ROW_ID int int 10 10