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 | [Quote,Contract] | |
| 3 | Description (Description) | Text50 | ||
| 4 | Description 2 (Description 2) | Text50 | ||
| 5 | Status (Status) | Option | [ ,Signed,Canceled] | Editable: Yes |
| 6 | Change Status (Change Status) | Option | [Open,Locked] | Editable: No |
| 7 | Customer No. (Customer No.) | Code20 |
|
NotBlank: Yes |
| 8 | Name (Name) | Text50 |
|
Editable: No FlowField |
| 9 | Address (Address) | Text50 |
|
Editable: No FlowField |
| 10 | Address 2 (Address 2) | Text50 |
|
Editable: No FlowField |
| 11 | Post Code (Post Code) | Code20 |
|
Editable: No FlowField |
| 12 | City (City) | Text30 |
|
Editable: No FlowField |
| 13 | Contact Name (Contact Name) | Text50 | ||
| 14 | Your Reference (Your Reference) | Text35 | ||
| 15 | Salesperson Code (Salesperson Code) | Code10 |
|
|
| 16 | Bill-to Customer No. (Bill-to Customer No.) | Code20 |
|
|
| 17 | Bill-to Name (Bill-to Name) | Text50 |
|
Editable: No FlowField |
| 18 | Bill-to Address (Bill-to Address) | Text50 |
|
Editable: No FlowField |
| 19 | Bill-to Address 2 (Bill-to Address 2) | Text50 |
|
Editable: No FlowField |
| 20 | Bill-to Post Code (Bill-to Post Code) | Code20 |
|
Editable: No FlowField |
| 21 | Bill-to City (Bill-to City) | Text30 |
|
Editable: No FlowField |
| 22 | Ship-to Code (Ship-to Code) | Code10 |
|
|
| 23 | Ship-to Name (Ship-to Name) | Text50 |
|
Editable: No FlowField |
| 24 | Ship-to Address (Ship-to Address) | Text50 |
|
Editable: No FlowField |
| 25 | Ship-to Address 2 (Ship-to Address 2) | Text50 |
|
Editable: No FlowField |
| 26 | Ship-to Post Code (Ship-to Post Code) | Code20 |
|
Editable: No FlowField |
| 27 | Ship-to City (Ship-to City) | Text30 |
|
Editable: No FlowField |
| 28 | Serv. Contract Acc. Gr. Code (Serv. Contract Acc. Gr. Code) | Code10 |
|
|
| 32 | Invoice Period (Invoice Period) | Option | [Month,Two Months,Quarter,Half Year,Year,None] | |
| 33 | Last Invoice Date (Last Invoice Date) | Date | Editable: No | |
| 34 | Next Invoice Date (Next Invoice Date) | Date | Editable: No | |
| 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 | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
| 40 | Calcd. Annual Amount (Calcd. Annual Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 42 | Annual Amount (Annual Amount) | Decimal | AutoFormatType: 1 | BlankZero: Yes |
| 43 | Amount per Period (Amount per Period) | Decimal | AutoFormatType: 1 | BlankZero: Yes 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) | BlankZero: Yes | |
| 56 | Contract Lines on Invoice (Contract Lines on Invoice) | Boolean | ||
| 57 | No. of Posted Invoices (No. of Posted Invoices) | Integer |
|
Editable: No FlowField |
| 58 | No. of Unposted Invoices (No. of Unposted Invoices) | Integer |
|
Editable: No FlowField |
| 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 | [Quote 1,Quote 2,Quote 3,Quote 4,Quote 5,Quote 6,Quote 7,Quote 8] | |
| 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 | CaptionClass: '1,2,1'
|
|
| 68 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 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 | InitValue: 1Y | |
| 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) | Code10 |
|
Editable: No |
| 83 | Probability (Probability) | Decimal (0:5) | InitValue: 100 | |
| 84 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 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 |
|
Editable: No FlowField |
| 90 | County (County) | Text30 |
|
Editable: No FlowField |
| 91 | Ship-to County (Ship-to County) | Text30 |
|
Editable: No FlowField |
| 92 | Country/Region Code (Country/Region Code) | Code10 |
|
Editable: No FlowField |
| 93 | Bill-to Country/Region Code (Bill-to Country/Region Code) | Code10 |
|
Editable: No FlowField |
| 94 | Ship-to Country/Region Code (Ship-to Country/Region Code) | Code10 |
|
Editable: No FlowField |
| 95 | Name 2 (Name 2) | Text50 |
|
Editable: No FlowField |
| 96 | Bill-to Name 2 (Bill-to Name 2) | Text50 |
|
Editable: No FlowField |
| 97 | Ship-to Name 2 (Ship-to Name 2) | Text50 |
|
Editable: No FlowField |
| 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 | Contract Invoice Amount (Contract Invoice Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 101 | Contract Prepaid Amount (Contract Prepaid Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 102 | Contract Discount Amount (Contract Discount Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 103 | Contract Cost Amount (Contract Cost Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 104 | Contract Gain/Loss Amount (Contract Gain/Loss Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 106 | No. of Posted Credit Memos (No. of Posted Credit Memos) | Integer |
|
Editable: No FlowField |
| 107 | No. of Unposted Credit Memos (No. of Unposted Credit Memos) | Integer |
|
Editable: No FlowField |
| 140 | Type Filter (Type Filter) | Option | [ ,Resource,Item,Service Cost,Service Contract,G/L Account] | FlowFilter |
| 141 | Reason Code Filter (Reason Code Filter) | Code10 |
|
FlowFilter |
| 142 | Posted Service Order Filter (Posted Service Order Filter) | Code20 |
|
FlowFilter |
| 143 | Date Filter (Date Filter) | Date | FlowFilter | |
| 144 | Item Filter (Item Filter) | Code20 |
|
FlowFilter |
| 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 | ||
| 5053 | Last Invoice Period End (Last Invoice Period End) | Date |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Contract Type,Contract No. (Contract Type,Contract No.) | Clustered: Yes | |
| 1 | Contract No.,Contract Type (Contract No.,Contract Type) | ||
| 2 | Customer No.,Ship-to Code (Customer No.,Ship-to Code) | ||
| 3 | Bill-to Customer No.,Contract Type,Combine Invoices,Next Invoice Date (Bill-to Customer No.,Contract Type,Combine Invoices,Next Invoice Date) | ||
| 4 | Next Price Update Date (Next Price Update Date) | ||
| 5 | Responsibility Center,Service Zone Code,Status,Contract Group Code (Responsibility Center,Service Zone Code,Status,Contract Group Code) | ||
| 6 | Salesperson Code,Status (Salesperson Code,Status) | ||
| 7 | Template No. (Template No.) | ||
| 8 | Customer No.,Bill-to Customer No. (Customer No.,Bill-to Customer No.) | MaintainSQLIndex: No | |
| 9 | Customer No.,Currency Code,Ship-to Code (Customer No.,Currency Code,Ship-to Code) | MaintainSQLIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bill-to Contact No. (Bill-to Contact No.) | Contact | No. (No.) |
|
1..n |
| Contract Group Code (Contract Group Code) | Contract Group | 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 |
| Item Filter (Item Filter) | Item | No. (No.) |
|
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 |
| Reason Code Filter (Reason Code Filter) | 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 |
| Service Order Type (Service Order Type) | Service Order Type | Code (Code) |
|
1..n |
| Posted Service Order Filter (Posted Service Order Filter) | Service Shipment Header | No. (No.) |
|
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 |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Contract Change Log | Contract No. (Contract No.) |
|
1..n |
| Contract Gain/Loss Entry | Contract No. (Contract No.) |
|
1..n |
| Contract/Service Discount | Contract No. (Contract No.) |
|
1..n |
| Filed Service Contract Header | Contract No. Relation (Contract No. Relation) |
|
1..n |
| Sales Line Archive | Service Contract No. (Service Contract No.) |
|
1..n |
| Service Comment Line | No. (No.) |
|
1..n |
| Service Contract Line | Contract No. (Contract No.) |
|
1..n |
| Service Cr.Memo Header | Contract Filter (Contract Filter) |
|
1..n |
| Service Cr.Memo Line | Contract No. (Contract No.) |
|
1..n |
| Service Header | Contract Filter (Contract Filter) |
|
1..n |
| Service Hour | Service Contract No. (Service Contract No.) |
|
1..n |
| Service Invoice Header | Contract Filter (Contract Filter) |
|
1..n |
| Service Invoice Line | Contract No. (Contract No.) |
|
1..n |
| Service Item | Contract Filter (Contract Filter) |
|
1..n |
| Service Item Line | Contract No. (Contract No.) |
|
1..n |
| Service Item Log | Document No. (Document No.) |
|
1..n |
| Service Ledger Entry | No. (No.) |
|
1..n |
| Service Line | Contract No. (Contract No.) |
|
1..n |
| Service Shipment Header | Contract Filter (Contract Filter) |
|
1..n |
| Service Shipment Item Line | Contract No. (Contract No.) |
|
1..n |
| Service Shipment Line | Contract No. (Contract No.) |
|
1..n |
| Warranty Ledger Entry | Service Contract No. (Service Contract No.) |
|
1..n |