Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

New Labor_Dept_Cat_Link Table (in FI_Data_2)

  • Last UpdatedDec 18, 2018
  • 1 minute read

Field

Datatype

PK

Nulls?

Description

dept_id

string40

Y

N

Possible department

lab_cd

string40

Y

N

Possible labor category

std_crew

tfloat

N

Y

Standard number of workers for this category in this department

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

N

N

Unique row identifier, for audit trail.

FK from lab_cd to labor_cat. (Cascade delete)

FK from dept_id to labor_dept. (Cascade delete)

TitleResults for “How to create a CRG?”Also Available in