Diagrams


Table

Service Contract Template

Fields

# Name Type
1 No. (No.) Code20
2 Description (Description) Text50
3 Invoice Period (Invoice Period) Option
4 Max. Labor Unit Price (Max. Labor Unit Price) Decimal BlankZero: Yes
5 Combine Invoices (Combine Invoices) Boolean
6 Prepaid (Prepaid) Boolean
7 Service Zone Code (Service Zone Code) Code10
8 Language Code (Language Code) Code10
9 Default Response Time (Hours) (Default Response Time (Hours)) Decimal (0:5) BlankZero: Yes
10 Contract Lines on Invoice (Contract Lines on Invoice) Boolean
11 Default Service Period (Default Service Period) DateFormula
14 Invoice after Service (Invoice after Service) Boolean
15 Allow Unbalanced Amounts (Allow Unbalanced Amounts) Boolean
16 Contract Group Code (Contract Group Code) Code10
17 Service Order Type (Service Order Type) Code10
18 Automatic Credit Memos (Automatic Credit Memos) Boolean
20 No. Series (No. Series) Code10 Editable: No
21 Price Update Period (Price Update Period) DateFormula
22 Price Inv. Increase Code (Price Inv. Increase Code) Code20
23 Serv. Contract Acc. Gr. Code (Serv. Contract Acc. Gr. Code) Code10

Keys

# Fields
0 No. (No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Contract Group Code (Contract Group Code) Contract Group Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n
No. Series (No. Series) No. Series 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
Service Zone Code (Service Zone Code) Service Zone 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/Service Discount Contract No. (Contract No.) 1..n