Diagrams

Table

Service Hour

DynamicsDocs.comService Hour«Table 5910»Service HourService Contract No. [PK]Starting Date [PK]Day; [Monday,Tuesday,Wednesday,Thursda...Starting TimeEnding TimeValid on HolidaysService Contract Type; [,Quote,Contrac...«Table 5965»Service Contract HeaderContract No. [PK]Contract Type; [Quote,Contract] [PK]DescriptionDescription 2Status; [,Signed,Canceled]Change Status; [Open,Locked]Customer No. [NN]NameAddressAddress 2Post CodeCityContact NameYour ReferenceSalesperson CodeBill-to Customer No.Bill-to NameBill-to AddressBill-to Address 2Bill-to Post CodeBill-to CityShip-to CodeShip-to NameShip-to AddressShip-to Address 2Ship-to Post CodeShip-to CityServ. Contract Acc. Gr. CodeInvoice Period; [Month,Two Months,Quar...Last Invoice DateNext Invoice Date...<Service Contract No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Service Contract No. (Service Contract No.) Code20
2 Starting Date (Starting Date) Date
3 Day (Day) Option
4 Starting Time (Starting Time) Time
5 Ending Time (Ending Time) Time
6 Valid on Holidays (Valid on Holidays) Boolean
7 Service Contract Type (Service Contract Type) Option

Keys

# Fields
0 Service Contract Type,Service Contract No.,Day,Starting Date (Service Contract Type,Service Contract No.,Day,Starting Date) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field