If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document.
The DEFECT table stores information about problems in a company's products or services. Defects are created using the Infor CRM. The DEFECT table contains information such as priority, severity, status, resolution and project codes, as well as whether or not the defect is closed.
|
|
If you applied the SLX Indexes for MS SQL.sql script to your database, your index information may be different than described in this topic. For more information, see the Index Changes.pdf document. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
DEFECTID (PK) (FK) |
char(12) |
NOT NULL |
DEFECT_DEFECTID_PK (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (One) |
|||||
|
(One) to (Many) |
|||||
|
PRIORITYCODE |
char(12) |
NULLS |
|
|
|
|
PROJECTCODE |
char(12) |
NULLS |
|
|
|
|
SEVERITYCODE |
char(12) |
NULLS |
|
|
|
|
STATUSCODE |
char(12) |
NULLS |
|
|
|
|
RESOLUTIONCODE |
char(12) |
NULLS |
|
|
|
|
RECORDEDBYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
RECORDEDDATE |
datetime(8) |
NULLS |
|
|
|
|
ASSIGNEDTOID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ASSIGNEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CLOSED |
BOOLEAN(1) |
NULLS |
|
|
|
|
CLOSEDBYID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CLOSEDDATE |
datetime(8) |
NULLS |
|
|
|
|
FIXEDINBUILD |
char(12) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One)
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
|
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
|
|
|
|
AREA |
varchar(64) |
NULLS |
|
|
|
|
CATEGORY |
varchar(64) |
NULLS |
|
|
|
|
ISSUE |
varchar(64) |
NULLS |
|
|
|
|
NOTES |
text(16) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
DEFECT_SECCODEID (IE) |
(Many) to (One)
|
|
|
PUBLICACCESSCODE |
char(12) |
NULLS |
|
|
|
|
ADDKNOWLEDGE |
char(1) |
NULLS |
|
|
|
|
SUBMITSEARCH |
char(1) |
NULLS |
|
|
|
|
SUBJECT |
varchar(254) |
NULLS |
|
|
|
|
VERSIONFOUND |
varchar(32) |
NULLS |
|
|
|
|
TARGETVERSION |
varchar(32) |
NULLS |
|
|
|
|
DEFECTTYPE |
varchar(32) |
NULLS |
|
|
|
|
FREQUENCY |
varchar(32) |
NULLS |
|
|
|
|
SOURCE |
varchar(32) |
NULLS |
|
|
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|