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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field