 RateNames (RAT) |
Rate Descriptions $
|
|
Keys
|
| Name |
Attributes |
Fields |
| RAT:GuidKey |
Case |
+RAT:Guid |
| RAT:CodeKey |
Primary |
+RAT:RateNameCode |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| RAT:Guid |
STRING |
@s16 |
Internal System Identifier |
| RAT:RateNameCode |
SHORT |
@n3 |
|
| RAT:Description |
STRING |
@s20 |
|
| RAT:Color |
LONG |
@n-13 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| JobHours |
1:MANY |
RAT:CodeKey |
JHR:RateKey |
| Redirect |
1:MANY |
RAT:CodeKey |
RED:RateKey |
| WRounding |
1:MANY |
RAT:CodeKey |
WRO:RateKey |
| WBalancing |
1:MANY |
RAT:CodeKey |
WBa:RateKey |
| WeeklyHours |
1:MANY |
RAT:CodeKey |
WEE:RateKey |
| DailyHours |
1:MANY |
RAT:CodeKey |
DAI:RateKey |
| Balancing |
1:MANY |
RAT:CodeKey |
BAL:RateKey |
| Slot |
1:MANY |
RAT:CodeKey |
SLO:RateKey |
|
