New Prod_Rate Table (in FI_Data_2)
- Last UpdatedDec 18, 2018
- 2 minute read
Specifies production rate standards for performance as a function of entity or line, item class or item, and/or operation in lieu of a rate based on an operation of a process at an entity. This would override a production rate that is inferred from std_oper_ent_link. The most specific record that fits the situation is used; the more of the first 5 fields are used, the more specific it is. For records matching the same number of fields, item_id is more specific than item_class_id, and ent_id is more specific than line_id. For the case in which the situation fits two records with the same number of fields, one with the specified ent_id and item_class and the other with the specified line_id and item_id, the latter would be considered the more specific.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
ent_id |
int32 |
N |
Y |
Identifies the entity. Null if line_id is not null. |
|
line_id |
int32 |
N |
Y |
Identifies the line. Null if ent_id is not null. |
|
item_class_id |
string40 |
N |
Y |
Identifies the class of item being produced. Null if item_id is not null. |
|
item_id |
string40 |
N |
Y |
Identifies the item being produced. Null if item_class is not null. |
|
oper_id |
string40 |
N |
Y |
Identifies the operation at which production occurs. |
|
est_prod_rate |
tfloat |
N |
N |
Est. entity batch rate or time, depending on prod_uom. |
|
prod_uom |
int32 |
N |
N |
Unit of measure for est_prod_rate: 0 = hours/batch (default) 1 = minutes/batch 2 = seconds/batch 3 = batches/hour 4 = batches/minute 5 = batches/second |
|
last_edit_comment |
string254 |
N |
Y |
Why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When this record was last changed |
|
row_id |
ID 0 |
Y |
N |
Unique row identifier, for audit trail |
FK from ent_id to ent. (Cascade delete)
FK from line_id to line. (Cascade delete)
FK from item_class_id to item_class. (Cascade delete)
FK from item_ id to item. (Cascade delete)