Diagrams


Table

Serv. Price Group Setup

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

Fields

# Name Type
1 Service Price Group Code (Service Price Group Code) Code10 NotBlank: Yes
2 Fault Area Code (Fault Area Code) Code10
3 Cust. Price Group Code (Cust. Price Group Code) Code10
4 Currency Code (Currency Code) Code10
5 Starting Date (Starting Date) Date
6 Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Code10
7 Include Discounts (Include Discounts) Boolean
8 Adjustment Type (Adjustment Type) Option
9 Amount (Amount) Decimal
10 Include VAT (Include VAT) Boolean

Keys

# Fields
0 Service Price Group Code,Fault Area Code,Cust. Price Group Code,Currency Code,Starting Date (Service Price Group Code,Fault Area Code,Cust. Price Group Code,Currency Code,Starting Date) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code (Currency Code) Currency Code (Code) 1..n
Cust. Price Group Code (Cust. Price Group Code) Customer Price Group Code (Code) 1..n
Fault Area Code (Fault Area Code) Fault Area Code (Code) 1..n
Serv. Price Adjmt. Gr. Code (Serv. Price Adjmt. Gr. Code) Service Price Adjustment Group Code (Code) 1..n
Service Price Group Code (Service Price Group Code) Service Price Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field