The Literature table stores information about company literature that can be sent to a contact using the Literature Fulfillment feature. Examples of literature are corporate overview brochures, collateral pieces, and New Customer packages. The information includes item name, item family, author details, quantity on hand, cost of item, and reorder information. The information is entered using the Infor CRM Windows Client (Tools > Manage > Literature).
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
LITERATUREID (PK) |
STANDARDID(12) |
NOT NULL |
LITERATURE_LITERATUREID_PK (CA) |
(One) to (Many) |
|
|
ITEMNAME |
varchar(128) |
NULLS |
|
|
|
|
ITEMFAMILY |
varchar(32) |
NULLS |
|
|
|
|
AUTHOREDBY |
varchar(64) |
NULLS |
|
|
|
|
AUTHORDATE |
datetime(8) |
NULLS |
|
|
|
|
EXPIREDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
FILENAME |
varchar(255) |
NULLS |
|
|
|
|
COST |
decimal(17,4) |
NULLS |
|
|
|
|
QTYONHAND |
int(4) |
NULLS |
|
|
|
|
REORDERQTY |
int(4) |
NULLS |
|
|
|
|
ITEMNUMBER |
varchar(15) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |