Diagrams


Table

No. Series Line

Fields

# Name Type
1 Series Code (Series Code) Code20 NotBlank: Yes
2 Line No. (Line No.) Integer
3 Starting Date (Starting Date) Date
4 Starting No. (Starting No.) Code20
5 Ending No. (Ending No.) Code20
6 Warning No. (Warning No.) Code20
7 Increment-by No. (Increment-by No.) Integer
8 Last No. Used (Last No. Used) Code20
9 Open (Open) Boolean Editable: No
10 Last Date Used (Last Date Used) Date

Keys

# Fields
0 Series Code,Line No. (Series Code,Line No.) Clustered: Yes
1 Series Code,Starting Date,Starting No. (Series Code,Starting Date,Starting No.)
2 Starting No. (Starting No.)

Table Relations To Other Tables

Field Related Table Related Field
Series Code (Series Code) No. Series Code (Code) 1..n

Table Relations From Other Tables

From Table From Field