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 CONTRACT table stores information about agreements between your company and customers to provide support services. These support service contracts are set up in Infor CRM. The information includes the service code and type code, purchase date, start and end dates for the contract, the number of days after purchase date (grace period), a blanket designation to add all company products to the contract, and other details. The CONTRACT table also includes several user-defined fields.
|
|
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 |
|---|---|---|---|---|---|
|
CONTRACTID (PK) |
CHAR(12) |
NOT NULL |
CONTRACT_CONTRACTID_PK (AK) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
ACCOUNTID (FK) |
char(12) |
NOT NULL |
|
(Many) to (One) |
|
|
SERVICECODE (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
TYPECODE (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
PURCHASEDATE |
datetime(8) |
NULLS |
|
|
|
|
PERIOD |
float |
NULLS |
|
|
|
|
STARTDATE |
datetime(8) |
NULLS |
|
|
|
|
ENDINGDATE |
datetime(8) |
NULLS |
|
|
|
|
CONTRACTLEFT |
varchar(32) |
NULLS |
|
|
|
|
BLANKET |
char(1) |
NULLS |
|
|
|
|
FIRSTCALL |
char(1) |
NULLS |
|
|
|
|
FIRSTTICKET |
char(1) |
NULLS |
|
|
|
|
GRACEPERIOD |
int (4) |
NULLS |
|
|
|
|
FIRSTDATE |
datetime (8) |
NULLS |
|
|
|
|
AMOUNT |
decimal (17,4) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
NOTES |
text(16) |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
CREATEDATE |
datetime (8) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
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 |
|
|
|
|
REMAINING |
float(8) |
NULLS |
|
|
|
|
CONTACTID (FK) |
char(12) |
NULLS |
CONTRACT_CONTACTID(CA) |
(Many) to (One) |
|
|
LISTPRICE |
decimal(17,4) |
NULLS |
|
|
|
|
PONUMBER |
varchar(64) |
NULLS |
|
|
|
|
DISCOUNT |
float(8) |
NULLS |
|
|
|
|
ISACTIVE |
char(1) |
NULLS |
|
|
|
|
REFERENCENO |
varchar(128) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |