The TICKETACTIVITYRATE table stores information about the types and rates for activity support provided by your company. As an example, the rate type code could be Consulting and the description for the type could consist of On-site consulting at daily rate, and the amount could be $100/per day.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETACTIVITYRATEID (PK) |
STANDARDID (12) |
NOT NULL |
TICKETACTIVITYRATEID_PK (CA) |
(One) to (Many) |
|
|
RATETYPECODE |
STANDARDID (12) |
NOT NULL |
|
|
|
|
TYPEDESC |
varchar(80) |
NULLS |
TICKETACTIVITYRATE_TYPEDESC (IE) |
|
|
|
AMOUNT |
float |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID (12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID (12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|