Table 5970 Filed Service Contract Header

Base Application, Microsoft.Service.Contract

103 fields

IdNameTypeVersions
1Contract No.Code[20]17-29
2Contract TypeEnum "Service Contract Type"17-29changed in 25
3DescriptionText[100]17-29
4Description 2Text[50]17-29
5StatusOption17-29
6Change StatusEnum "Service Contract Change Status"17-29changed in 25
7Customer No.Code[20]17-29
8NameText[100]17-29
9AddressText[100]17-29
10Address 2Text[50]17-29
11Post CodeCode[20]17-29
12CityText[30]17-29
13Contact NameText[100]17-29
14Your ReferenceText[35]17-29
15Salesperson CodeCode[20]17-29
16Bill-to Customer No.Code[20]17-29
17Bill-to NameText[100]17-29
18Bill-to AddressText[100]17-29
19Bill-to Address 2Text[50]17-29
20Bill-to Post CodeCode[20]17-29
21Bill-to CityText[30]17-29
22Ship-to CodeCode[10]17-29
23Ship-to NameText[100]17-29
24Ship-to AddressText[100]17-29
25Ship-to Address 2Text[50]17-29
26Ship-to Post CodeCode[20]17-29
27Ship-to CityText[30]17-29
28Serv. Contract Acc. Gr. CodeCode[10]17-29
32Invoice PeriodEnum "Service Contract Header Invoice Period"17-29changed in 25
33Last Invoice DateDate17-29
34Next Invoice DateDate17-29
35Starting DateDate17-29
36Expiration DateDate17-29
38First Service DateDate17-29
39Max. Labor Unit PriceDecimal17-29
40Calcd. Annual AmountDecimal17-29
42Annual AmountDecimal17-29
43Amount per PeriodDecimal17-29
44Combine InvoicesBoolean17-29
45PrepaidBoolean17-29
46Next Invoice PeriodText[30]17-29
47Service Zone CodeCode[10]17-29
48Language CodeCode[10]17-29
49Format RegionText[80]new in 25
50Cancel Reason CodeCode[10]17-29
51Last Price Update DateDate17-29
52Next Price Update DateDate17-29
53Last Price Update %Decimal17-29
55Response Time (Hours)Decimal17-29
56Contract Lines on InvoiceBoolean17-29
59Service PeriodDateFormula17-29
60Payment Terms CodeCode[10]17-29
62Invoice after ServiceBoolean17-29
63Quote TypeOption17-29
64Allow Unbalanced AmountsBoolean17-29
65Contract Group CodeCode[10]17-29
66Service Order TypeCode[10]17-29
67Shortcut Dimension 1 CodeCode[20]17-29
68Shortcut Dimension 2 CodeCode[20]17-29
69Accept BeforeDate17-29
71Automatic Credit MemosBoolean17-29
74Template No.Code[20]17-29
75Price Update PeriodDateFormula17-29
79Price Inv. Increase CodeCode[20]17-29
80Print Increase TextBoolean17-29
81Currency CodeCode[10]17-29
82No. SeriesCode[20]17-29
83ProbabilityDecimal17-29
84CommentBooleannew in 25
85Responsibility CenterCode[10]17-29
86Phone No.Text[30]17-29
87Fax No.Text[30]17-29
88E-MailText[80]17-29
89Bill-to CountyText[30]17-29
90CountyText[30]17-29
91Ship-to CountyText[30]17-29
92Country/Region CodeCode[10]17-29
93Bill-to Country/Region CodeCode[10]17-29
94Ship-to Country/Region CodeCode[10]17-29
95Name 2Text[50]17-29
96Bill-to Name 2Text[50]17-29
97Ship-to Name 2Text[50]17-29
98Next Invoice Period StartDate17-29
99Next Invoice Period EndDate17-29
100Entry No.Integer17-29
101File DateDate17-29
102File TimeTime17-29
103Filed ByCode[50]17-29
104Reason for FilingOption17-29
105Contract Type RelationEnum "Service Contract Type"17-29changed in 19
106Contract No. RelationCode[20]17-29
109No. of Filed VersionsIntegernew in 25
110RestorableBooleannew in 25
111Source Contract ExistsBooleannew in 25
112Last Filed DateTimeDateTimenew in 25
204Payment Method CodeCode[10]new in 25
210Ship-to Phone No.Text[30]new in 25
480Dimension Set IDInteger17-29
1200Direct Debit Mandate IDCode[35]new in 25
5050Contact No.Code[20]17-29
5051Bill-to Contact No.Code[20]17-29
5052Bill-to ContactText[100]17-29
5053Last Invoice Period EndDatenew in 25