New Line Table (in FI_Data_2)

line_name

string80

N

N

Unique name for production line or line class.

line_class

logical

N

N

Indicates whether this is a line class. Default = No.

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".

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 (or entity class in the case of a line class) that is the source of production counts for the line.

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.

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

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.

line_id

ID 0

Y

N

Unique line identifier.