Skip to main content

Contracts & Recurring - Key Tables

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

CONTRACT (19 columns)

# Column Type Length Nullable Default
1 CNid int NO
2 CNcompanynum int YES
3 cnphone1 nvarchar 4000 YES
4 cnphone2 nvarchar 4000 YES
5 cnphone3 nvarchar 4000 YES
6 CNContractCode nvarchar 4000 YES
7 CNContractDesc nvarchar 4000 YES
8 CNslaid int YES
9 CNnote ntext 1073741823 YES
10 CNstartdate datetime YES
11 CNenddate datetime YES
12 CNDontSendAlarm bit NO ((0))
13 CNCost ntext 1073741823 YES
14 CNIsDefault bit NO ((0))
15 CNDontSendAlarm2 bit YES ((0))
16 CNDontSendAlarm3 bit YES ((0))
17 cnactive bit YES ((1))
18 cnrenewedfromid int YES
19 cnrenewedbyid int YES

CONTRACTDETAIL (30 columns)

# Column Type Length Nullable Default
1 CDid int NO
2 CDseq int NO
3 CDType int YES ((0))
4 CDRequestType int YES ((0))
5 CDSeriousness int YES ((0))
6 CDChargeCode int YES ((0))
7 CDMultiplier float YES ((0))
8 CDCPid int YES ((0))
9 CDcat2 nvarchar 4000 YES
10 CDuserCoveredBillingDescription int YES ((-1))
11 CDpartialMatchCategory bit YES ((0))
12 cdsite int YES ((-1))
13 cdallowallcontracts bit YES ((0))
14 CDAssetCoveredByContract bit YES ((0))
15 CDUserCoveredByContract bit YES ((0))
16 CDcat3 nvarchar 4000 YES
17 CDpartialmatchcategory2 bit YES
18 CDcat4 nvarchar 4000 YES
19 CDpartialmatchcategory3 bit YES
20 CDcat5 nvarchar 4000 YES
21 CDpartialmatchcategory4 bit YES
22 cdorder int YES
23 cdworkhourscovered int YES
24 cdbillingplandesc nvarchar 500 YES
25 cdrtid int YES ((-1))
26 cdnotincludedincontract bit YES ((0))
27 cdchargetype int YES ((0))
28 cdactive bit YES ((1))
29 cdenddate datetime YES ((0))
30 cdstartdate datetime YES ((0))

CONTRACTHEADER (98 columns)

# Column Type Length Nullable Default
1 CHid int NO
2 CHarea int YES ((0))
3 CHstartdate datetime YES
4 CHenddate datetime YES
5 CHstartbalance float YES ((0))
6 CHPaymentScheme int YES ((0))
7 CHChargeHoursPerPeriod float YES ((0))
8 CHPeriodChargeAmount float YES ((0))
9 CHChargeRollOver bit NO ((0))
10 CHNote ntext 1073741823 YES
11 CHOutOfHoursMultiplier float YES ((0))
12 CHRequestMinimum float YES ((0))
13 CHInvoiceMinimum float YES ((0))
14 CHAllowFixedPrice bit NO ((0))
15 CHAllowPYG bit NO ((0))
16 CHAllowPrePay bit NO ((0))
17 CHChargePerDevice bit NO ((0))
18 CHBillingPeriod int YES ((0))
19 CHPrepayRecurringCharge float YES ((0))
20 CHChargePrePayTravel bit NO ((0))
21 CHChargePrePayMileage bit NO ((0))
22 CHChargePYGTravel bit NO ((0))
23 CHChargePYGMileage bit NO ((0))
24 CHOnlyBillAtEndOfPeriod bit NO ((0))
25 CHUnmatchedCombinations int YES ((0))
26 chTermMonths int YES
27 chbillingdescription int YES ((-1))
28 CHPercentageIncrease float YES ((0))
29 CHnextincrementdate datetime YES
30 CHDateReceived datetime YES
31 CHcontractRef nvarchar 4000 YES
32 CHPeriodicInvoiceNextDate datetime YES
33 CHInvoiceDescription ntext 1073741823 YES
34 CHNumberofUnitsFree float YES
35 CHstatus int YES ((0))
36 CHDateSent datetime YES
37 CHPaymentMethod int YES ((0))
38 CHDontSendAlarm bit YES ((0))
39 CHTechnician int YES ((0))
40 CHFaultid int YES ((0))
41 CHCostPerPeriod float YES ((0.00))
42 CHRollingContract bit YES ((0))
43 CHpreviouscontract int YES ((0))
44 CHbillingcategory int YES ((0))
45 CHSite int YES ((-1))
46 CHslaid int YES ((-1))
47 chDontInvoice bit YES ((0))
48 CHOHid int YES ((0))
49 CHEmailAddresses nvarchar 255 YES ('')
50 CHScheduleEmails nvarchar 4000 YES ('')
51 CHScheduleSendAccountManager bit YES ((0))
52 CHAccountsDesc nvarchar 400 YES ('')
53 chsurchargeid int YES ((-1))
54 CHDontChargeForItems bit YES ((0))
55 CHDontSendAlarm2 bit YES ((0))
56 CHDontSendAlarm3 bit YES ((0))
57 CHDontSendUserAlarm bit YES ((0))
58 CHDontSendUserAlarm2 bit YES ((0))
59 CHDontSendUserAlarm3 bit YES ((0))
60 CHPdfTemplateId int YES ((0))
61 CHconvertedToRecurringInvoice bit YES ((0))
62 CHconvertedToRecurringInvoiceId int YES ((0))
63 CHAutotaskId int YES ((-1))
64 CHchargerateMethod int YES ((0))
65 chchargemultiplier float YES
66 chactive bit YES ((1))
67 chtype int YES ((0))
68 chprepayrecurringchargenextdate datetime YES ((0))
69 chprepayrecurringhours float YES
70 chprepayrecurringchargebp int YES
71 chbillforrecurringprepayamount bit YES
72 chprepayrecurringminimumdeduction float YES
73 chprepayrecurringminimumdeductiononlyactive bit YES
74 chprepayrecurringautomaticdeduction float YES
75 CHLabourNominalCodeOverride nvarchar 4000 YES
76 chprepayrecurringexpirymonths int YES
77 chemailaddressto nvarchar 500 YES ('')
78 chemailaddresscc nvarchar 500 YES ('')
79 chlast_modified datetime YES ((0))
80 chcostcalculation nvarchar 4000 YES ('')
81 chusecostcalculation bit YES ((0))
82 chsubtype int YES
83 choracleinvoiceid int YES
84 chdatesenttooracle datetime YES ((0))
85 chsenttooracle bit YES
86 chnextcalldate datetime YES ((0))
87 chuserid int YES ((0))
88 chprepayitemid int YES ((0))
89 choverrideaccountsmailbox int YES ((-1))
90 chautotopupthreshhold float YES
91 chautotopuptoamount float YES
92 chautotopupcostperhour float YES
93 chautotopupbyamount float YES
94 chapprovername nvarchar 50 YES
95 chapproveremail nvarchar 50 YES
96 chsignatureattachmentid int YES ((0))
97 chapproverdate datetime YES ((0))
98 chprepayasamount bit YES
Back to top