line
- Last UpdatedNov 20, 2024
- 2 minute read
The line table defines production lines. Treated separately from other groupings of entities because line members have a distinct order, which is not reflected in the ent_link table. Also, lines have some unique settings that are not applicable to other entities, and because many entity settings are not applicable to lines.
Note: This table could also define line classes, but this capability is not currently used.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
line_name |
string80 |
N |
N |
Unique name for production line Note: This field could also be the unique name of a line class, but this functionality is currently not used. |
|
line_class |
logical |
N |
N |
Indicates whether this a line class. Default = No. Note: This field is currently not used. |
|
origin_line_class_id |
int32 |
N |
Y |
Line class from which this line was instantiated; null for line classes, and for lines created "from scratch". Note: This field is currently not used. |
|
labor_load |
int32 |
N |
Y |
Number of people to run the line reported to ERP. |
|
max_wo |
int32 |
N |
N |
Maximum number of simultaneous work orders permitted on the line. Default = 1. |
|
prod_ent_id |
int32 |
N |
Y |
Identifies the entity that is the source of production counts for the line. Note: This field could also identify the entity class for a line class if a line class is being defined, but this functionality is currently not used. |
|
prod_uom |
int32 |
N |
N |
Standard production rate unit of measure for reporting production rate: 0 = hours/batch (default) 1 = minutes/batch 2 = seconds/batch 3 = batches/hour 4 = batches/minute 5 = batches/second |
|
batch_size |
tfloat |
N |
N |
Standard batch size for reporting production rate. Default = 1 |
|
std_item_id |
string40 |
N |
Y |
Standard item to use for reporting production rate. |
|
bottleneck_ent_id |
int32 |
N |
Y |
Identifies an entity at the position that is predetermined to be the bottleneck for this line. Overrides that entity having Can be_bottleneck set to false. |
|
target_util |
tfloat |
N |
Y |
Target utilization. |
|
target_qual |
tfloat |
N |
Y |
Target quality. |
|
target_perf |
tfloat |
N |
Y |
Target performance. |
|
target_oee |
tfloat |
N |
Y |
Target OEE. |
|
spare1 |
string1000 |
N |
Y |
Use defined by language term 7909 |
|
spare2 |
string1000 |
N |
Y |
Use defined by language term 7910 |
|
spare3 |
string1000 |
N |
Y |
Use defined by language term 7911 |
|
spare4 |
string1000 |
N |
Y |
Use defined by language term 7912 |
|
last_edit_comment |
string254 |
N |
Y |
Reserved for internal use to indicate why this record was changed |
|
last_edit_by |
string40 |
N |
N |
Who last changed this record |
|
last_edit_at |
tdatetime |
N |
N |
When record was last changed |
|
line_id |
ID 1 |
Y |
N |
Unique line identifier. |
line_name is UK.
FK from origin_line_class_id to line. (Set null)
FK from line_id, prod_ent_id to line_ent_link. (Set null (prod_ent_id))
FK from std_item_id to item. (Set null)
FK from line_id, bottleneck_ent_id to line_ent_link. (Set null (bottleneck_ent_id))