Diagrams


Table

Contract Change Log

Fields

# Name Type
1 Contract Type (Contract Type) Option
2 Contract No. (Contract No.) Code20
3 Change No. (Change No.) Integer
4 User ID (User ID) Code50
5 Date of Change (Date of Change) Date
6 Time of Change (Time of Change) Time
7 Contract Part (Contract Part) Option
8 Field Description (Field Description) Text80
9 Old Value (Old Value) Text80
10 New Value (New Value) Text80
12 Type of Change (Type of Change) Option
13 Service Item No. (Service Item No.) Code20
14 Serv. Contract Line No. (Serv. Contract Line No.) Integer

Keys

# Fields
0 Contract No.,Change No. (Contract No.,Change No.) Clustered: Yes
1 Contract Type (Contract Type)

Table Relations To Other Tables

Field Related Table Related Field
Contract No. (Contract No.) Service Contract Header Contract No. (Contract No.) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field