Diagrams


Table

Contract Change Log

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field