Diagrams


Table

Job Planning Line - Calendar

Fields

# Name Type
1 Job No. Code20
2 Job Task No. Code20
3 Planning Line No. Integer
4 Resource No. Code20
6 Planning Date Date
7 Quantity Decimal
8 Description Text50
9 UID GUID
10 Sequence Integer

Keys

# Fields
0 Job No.,Job Task No.,Planning Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Planning Line No. Job Planning Line Line No. 1..1
Resource No. Resource No. 1..n

Table Relations From Other Tables

From Table From Field