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

labor_dept

  • Last UpdatedNov 20, 2024
  • 1 minute read

The labor_dept table defines departments or cost centers to which labor may be attributed.

Field

Datatype

PK

Nulls?

Description

dept_id

string40

Y

N

Identify labor dept

dept_desc

string80

N

N

Labor dept description; must be unique

spare1

string1000

N

Y

Use defined by language term 525

spare2

string1000

N

Y

Use defined by language term 526

spare3

string1000

N

Y

Use defined by language term 527

spare4

string1000

N

Y

Use defined by language term 528

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

Y

Who last changed this record

last_edit_at

tdatetime

N

N

When this record was last changed

row_id

ID 1

N

N

Unique row identifier, for audit trail

dept_desc is UK.

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