The CalculatedFieldData table contains the standard calculated fields included with Infor CRM, as well as those created for custom use. In Infor CRM calculated fields are defined as several fields from one or more tables that are treated as a single unit. For example, character fields may be combined, or mathematical formulas may be used to create calculated fields.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
CALCFIELDID (PK) |
STANDARDID |
NOT NULL |
CALCULATEDFIELDDATA_CALCFIELDID_PK (CA) |
|
|
|
NAME |
varchar(32) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(128) |
NULLS |
|
|
|
|
BASETABLE |
varchar(32) |
NULLS |
|
|
|
|
CALCULATION |
Textblob |
NULLS |
|
|
|
|
SECCODEID(FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
SORTORDER |
varchar(128) |
NULLS |
|
|
|