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 | [Quote,Contract] | |
3 | Description | Text50 | ||
4 | Description 2 | Text50 | ||
5 | Status | Option | [ ,Signed,Canceled] | Editable: Yes |
6 | Change Status | Option | [Open,Locked] | Editable: No |
7 | Customer No. | Code20 |
|
NotBlank: Yes |
8 | Name | Text50 |
|
Editable: No FlowField |
9 | Address | Text50 |
|
Editable: No FlowField |
10 | Address 2 | Text50 |
|
Editable: No FlowField |
11 | Post Code | Code20 |
|
Editable: No FlowField |
12 | City | Text30 |
|
Editable: No FlowField |
13 | Contact Name | Text50 | ||
14 | Your Reference | Text35 | ||
15 | Salesperson Code | Code10 |
|
|
16 | Bill-to Customer No. | Code20 |
|
|
17 | Bill-to Name | Text50 |
|
Editable: No FlowField |
18 | Bill-to Address | Text50 |
|
Editable: No FlowField |
19 | Bill-to Address 2 | Text50 |
|
Editable: No FlowField |
20 | Bill-to Post Code | Code20 |
|
Editable: No FlowField |
21 | Bill-to City | Text30 |
|
Editable: No FlowField |
22 | Ship-to Code | Code10 |
|
|
23 | Ship-to Name | Text50 |
|
Editable: No FlowField |
24 | Ship-to Address | Text50 |
|
Editable: No FlowField |
25 | Ship-to Address 2 | Text50 |
|
Editable: No FlowField |
26 | Ship-to Post Code | Code20 |
|
Editable: No FlowField |
27 | Ship-to City | Text30 |
|
Editable: No FlowField |
28 | Serv. Contract Acc. Gr. Code | Code10 |
|
|
32 | Invoice Period | Option | [Month,Two Months,Quarter,Half Year,Year,None] | |
33 | Last Invoice Date | Date | Editable: No | |
34 | Next Invoice Date | Date | Editable: No | |
35 | Starting Date | Date | ||
36 | Expiration Date | Date | ||
38 | First Service Date | Date | ||
39 | Max. Labor Unit Price | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
40 | Calcd. Annual Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
42 | Annual Amount | Decimal | AutoFormatType: 1 | BlankZero: Yes |
43 | Amount per Period | Decimal | AutoFormatType: 1 | BlankZero: Yes 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) | BlankZero: Yes | |
56 | Contract Lines on Invoice | Boolean | ||
57 | No. of Posted Invoices | Integer |
|
Editable: No FlowField |
58 | No. of Unposted Invoices | Integer |
|
Editable: No FlowField |
59 | Service Period | DateFormula | ||
60 | Payment Terms Code | Code10 |
|
|
62 | Invoice after Service | Boolean | ||
63 | Quote Type | Option | [Quote 1,Quote 2,Quote 3,Quote 4,Quote 5,Quote 6,Quote 7,Quote 8] | |
64 | Allow Unbalanced Amounts | Boolean | ||
65 | Contract Group Code | Code10 |
|
|
66 | Service Order Type | Code10 |
|
|
67 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
68 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
69 | Accept Before | Date | ||
71 | Automatic Credit Memos | Boolean | ||
74 | Template No. | Code20 | ||
75 | Price Update Period | DateFormula | InitValue: 1Y | |
79 | Price Inv. Increase Code | Code20 |
|
|
80 | Print Increase Text | Boolean | ||
81 | Currency Code | Code10 |
|
|
82 | No. Series | Code10 |
|
Editable: No |
83 | Probability | Decimal (0:5) | InitValue: 100 | |
84 | Comment | Boolean |
|
Editable: No FlowField |
85 | Responsibility Center | Code10 |
|
|
86 | Phone No. | Text30 [Phone No.] | ||
87 | Fax No. | Text30 | ||
88 | Text80 [E-Mail] | |||
89 | Bill-to County | Text30 |
|
Editable: No FlowField |
90 | County | Text30 |
|
Editable: No FlowField |
91 | Ship-to County | Text30 |
|
Editable: No FlowField |
92 | Country/Region Code | Code10 |
|
Editable: No FlowField |
93 | Bill-to Country/Region Code | Code10 |
|
Editable: No FlowField |
94 | Ship-to Country/Region Code | Code10 |
|
Editable: No FlowField |
95 | Name 2 | Text50 |
|
Editable: No FlowField |
96 | Bill-to Name 2 | Text50 |
|
Editable: No FlowField |
97 | Ship-to Name 2 | Text50 |
|
Editable: No FlowField |
98 | Next Invoice Period Start | Date | Editable: No | |
99 | Next Invoice Period End | Date | Editable: No | |
100 | Contract Invoice Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
101 | Contract Prepaid Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
102 | Contract Discount Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
103 | Contract Cost Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
104 | Contract Gain/Loss Amount | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
106 | No. of Posted Credit Memos | Integer |
|
Editable: No FlowField |
107 | No. of Unposted Credit Memos | Integer |
|
Editable: No FlowField |
140 | Type Filter | Option | [ ,Resource,Item,Service Cost,Service Contract,G/L Account] | FlowFilter |
141 | Reason Code Filter | Code10 |
|
FlowFilter |
142 | Posted Service Order Filter | Code20 |
|
FlowFilter |
143 | Date Filter | Date | FlowFilter | |
144 | Item Filter | Code20 |
|
FlowFilter |
480 | Dimension Set ID | Integer |
|
Editable: No |
5050 | Contact No. | Code20 |
|
|
5051 | Bill-to Contact No. | Code20 |
|
|
5052 | Bill-to Contact | Text50 | ||
5053 | Last Invoice Period End | Date |
Keys
# | Fields | ||
---|---|---|---|
0 | Contract Type,Contract No. | Clustered: Yes | |
1 | Contract No.,Contract Type | ||
2 | Customer No.,Ship-to Code | ||
3 | Bill-to Customer No.,Contract Type,Combine Invoices,Next Invoice Date | ||
4 | Next Price Update Date | ||
5 | Responsibility Center,Service Zone Code,Status,Contract Group Code | ||
6 | Salesperson Code,Status | ||
7 | Template No. | ||
8 | Customer No.,Bill-to Customer No. | MaintainSQLIndex: No | |
9 | Customer No.,Currency Code,Ship-to Code | MaintainSQLIndex: No |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Bill-to Contact No. | Contact | No. |
|
1..n |
Contract Group Code | Contract Group | 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 |
Item Filter | Item | No. |
|
1..n |
Language Code | Language | Code |
|
1..n |
No. Series | No. Series | Code |
|
1..n |
Payment Terms Code | Payment Terms | Code |
|
1..n |
Reason Code Filter | 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 |
Service Order Type | Service Order Type | Code |
|
1..n |
Posted Service Order Filter | Service Shipment Header | No. |
|
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 |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Contract Change Log | Contract No. |
|
1..n |
Contract Gain/Loss Entry | Contract No. |
|
1..n |
Contract/Service Discount | Contract No. |
|
1..n |
Filed Service Contract Header | Contract No. Relation |
|
1..n |
Sales Line Archive | Service Contract No. |
|
1..n |
Service Comment Line | No. |
|
1..n |
Service Contract Line | Contract No. |
|
1..n |
Service Cr.Memo Header | Contract Filter |
|
1..n |
Service Cr.Memo Line | Contract No. |
|
1..n |
Service Header | Contract Filter |
|
1..n |
Service Hour | Service Contract No. |
|
1..n |
Service Invoice Header | Contract Filter |
|
1..n |
Service Invoice Line | Contract No. |
|
1..n |
Service Item | Contract Filter |
|
1..n |
Service Item Line | Contract No. |
|
1..n |
Service Item Log | Document No. |
|
1..n |
Service Ledger Entry | No. |
|
1..n |
Service Line | Contract No. |
|
1..n |
Service Shipment Header | Contract Filter |
|
1..n |
Service Shipment Item Line | Contract No. |
|
1..n |
Service Shipment Line | Contract No. |
|
1..n |
Warranty Ledger Entry | Service Contract No. |
|
1..n |