Diagrams


Table

Filed Service Contract Header

DynamicsDocs.comFiled Service Contract Header«Table 5970»Filed Service Contract HeaderContract No.Contract Type; [Quote,Contract]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr......«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 5973»Service Contract Account GroupCode [PK]DescriptionNon-Prepaid Contract Acc.Prepaid Contract Acc.«Table 5957»Service ZoneCode [PK,NN]Description«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 5966»Contract GroupCode [PK,NN]DescriptionDisc. on Contr. Orders OnlyDate FilterContract Gain/Loss Amount«Table 5903»Service Order TypeCode [PK,NN]Description«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«Table 7»Standard TextCode [PK,NN]Description«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Customer No.><Bill-to Customer No.><Salesperson Code><Ship-to Code><Serv. Contract Acc. Gr. Code><Service Zone Code><Language Code><Cancel Reason Code><Payment Terms Code><Contract Group Code><Service Order Type><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Price Inv. Increase Code><Currency Code><No. Series><Responsibility Center><Country/Region Code><Bill-to Country/Region Code><Ship-to Country/Region Code><Filed By><Contract No. Relation><Dimension Set ID><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Currency Code><Currency Filter><Currency Id><Customer Filter><Language Code><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Salesperson Code><Country/Region Code><Bill-to Customer No.><No. Series><Responsibility Center><Service Zone Code><Ship-to Filter><Customer No.><Customer No.><Bill-to Customer No.><Global Dimension 1 Code><Global Dimension 2 Code><Salesperson Code><Country/Region Code><Service Zone Code><Ship-to Code><Serv. Contract Acc. Gr. Code><Service Zone Code><Language Code><Cancel Reason Code><Reason Code Filter><Payment Terms Code><Contract Group Code><Service Order Type><Dimension Value Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Price Inv. Increase Code><Currency Code><No. Series><Country/Region Code><Responsibility Center><Dimension Set ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Contract No. Code20
2 Contract Type Option
3 Description Text50
4 Description 2 Text50
5 Status Option Editable: Yes
6 Change Status Option
7 Customer No. Code20 NotBlank: Yes
8 Name Text50 Editable: No
9 Address Text50 Editable: No
10 Address 2 Text50 Editable: No
11 Post Code Code20 Editable: No
12 City Text30 Editable: No
13 Contact Name Text50
14 Your Reference Text35
15 Salesperson Code Code20
16 Bill-to Customer No. Code20
17 Bill-to Name Text50 Editable: No
18 Bill-to Address Text50 Editable: No
19 Bill-to Address 2 Text50 Editable: No
20 Bill-to Post Code Code20 Editable: No
21 Bill-to City Text30 Editable: No
22 Ship-to Code Code10
23 Ship-to Name Text50 Editable: No
24 Ship-to Address Text50 Editable: No
25 Ship-to Address 2 Text50 Editable: No
26 Ship-to Post Code Code20 Editable: No
27 Ship-to City Text30 Editable: No
28 Serv. Contract Acc. Gr. Code Code10
32 Invoice Period Option
33 Last Invoice Date Date Editable: No
34 Next Invoice Date Date
35 Starting Date Date
36 Expiration Date Date
38 First Service Date Date
39 Max. Labor Unit Price Decimal
40 Calcd. Annual Amount Decimal
42 Annual Amount Decimal
43 Amount per Period Decimal Editable: No
44 Combine Invoices Boolean
45 Prepaid Boolean
46 Next Invoice Period Text30 Editable: No
47 Service Zone Code Code10
48 Language Code Code10
50 Cancel Reason Code Code10
51 Last Price Update Date Date Editable: No
52 Next Price Update Date Date
53 Last Price Update % Decimal (0:5) Editable: No
55 Response Time (Hours) Decimal (0:5)
56 Contract Lines on Invoice Boolean
59 Service Period DateFormula
60 Payment Terms Code Code10
62 Invoice after Service Boolean
63 Quote Type Option
64 Allow Unbalanced Amounts Boolean
65 Contract Group Code Code10
66 Service Order Type Code10
67 Shortcut Dimension 1 Code Code20
68 Shortcut Dimension 2 Code Code20
69 Accept Before Date
71 Automatic Credit Memos Boolean
74 Template No. Code20
75 Price Update Period DateFormula
79 Price Inv. Increase Code Code20
80 Print Increase Text Boolean
81 Currency Code Code10
82 No. Series Code20
83 Probability Decimal (0:5)
85 Responsibility Center Code10
86 Phone No. Text30 [Phone No.]
87 Fax No. Text30
88 E-Mail Text80 [E-Mail]
89 Bill-to County Text30
90 County Text30
91 Ship-to County Text30
92 Country/Region Code Code10
93 Bill-to Country/Region Code Code10
94 Ship-to Country/Region Code Code10
95 Name 2 Text50 Editable: No
96 Bill-to Name 2 Text50 Editable: No
97 Ship-to Name 2 Text50 Editable: No
98 Next Invoice Period Start Date Editable: No
99 Next Invoice Period End Date Editable: No
100 Entry No. Integer
101 File Date Date
102 File Time Time
103 Filed By Code50
104 Reason for Filing Option
105 Contract Type Relation Option
106 Contract No. Relation Code20
480 Dimension Set ID Integer Editable: No
5050 Contact No. Code20
5051 Bill-to Contact No. Code20
5052 Bill-to Contact Text50

Keys

# Fields
0 Entry No. Clustered: Yes
1 Contract Type Relation,Contract No. Relation,File Date,File Time
2 Contract Type,Contract No.

Table Relations To Other Tables

Field Related Table Related Field
Contract Group Code Contract Group Code 1..n
Ship-to Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Bill-to Customer No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Language Code Language Code 1..n
No. Series No. Series Code 1..n
Payment Terms Code Payment Terms Code 1..n
Cancel Reason Code Reason Code Code 1..n
Responsibility Center Responsibility Center Code 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Serv. Contract Acc. Gr. Code Service Contract Account Group Code 1..n
Contract No. Relation Service Contract Header Contract No. 1..n
Service Order Type Service Order Type Code 1..n
Service Zone Code Service Zone Code 1..n
Ship-to Code Ship-to Address Code 1..n
Price Inv. Increase Code Standard Text Code 1..n
Filed By User User Name 1..n

Table Relations From Other Tables

From Table From Field