The TICKETACTIVITYITEM table stores information on items (parts) associated with an activity. This generates data used for billing the customer for materials necessary to address a problem.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
TICKETACTIVITYITEMID (PK) |
STANDARDID(12) |
NOT NULL |
TICKETACTIVITYITEMID_PK (CA) |
|
|
|
TICKETACTIVITYID (FK) |
STANDARDID(12) |
NULLS |
TICKETACTIVITYITEM_TICKETACTIVITYID (IE) |
(Many) to (One) |
|
|
ACCOUNTPRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ITEMDESC |
varchar(80) |
NULLS |
|
|
|
|
ITEMAMOUNT |
float(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ITEMQUANTITY |
float(8) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ITEMTOTALAMOUNT |
float(8) |
NULLS |
|
|
|
|
PRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |