The LitRequest table contains information regarding the literature requested and fulfilled for a contact. Literature requests are scheduled using the Infor CRM Network or Web Client and include the requested date, send date, user requesting the literature, description of the request, how to send the request (mail, UPS, etc), the cover letter ID, name to send with the request, and the contact information.
Literature fulfillments are performed using the Infor CRM Client.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LITREQID (PK) |
STANDARDID(12) |
NOT NULL |
LITREQUEST_LITREQUID_PK (CA) |
(One) to (Many) |
|
|
REQDATE |
datetime(8) |
NULLS |
|
|
|
|
SENDDATE |
datetime(8) |
NULLS |
|
|
|
|
REQUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
DESCRIPTION |
varchar(64) |
NULLS |
|
|
|
|
SENDVIA |
varchar(32) |
NULLS |
|
|
|
|
COVERID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
COVERNAME |
varchar(64) |
NULLS |
|
|
|
|
CONTACTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CONTACTNAME |
varchar(128) |
NULLS |
|
|
|
|
FILLDATE |
datetime(8) |
NULLS |
|
|
|
|
FILLUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
TOTALCOST |
float(8) |
NULLS |
|
|
|
|
PRIORITY |
varchar(64) |
NULLS |
|
|
|
|
OPTIONS |
int |
NULLS |
|
|
|
|
FILLSTATUS |
varchar(64) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |