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 Cause Table (in FI_Data_2)

  • Last UpdatedDec 18, 2018
  • 1 minute read

Defines causes for samples. Analogous to utilization and item reasons.

Field

Datatype

PK

Nulls?

Description

cause_desc

string80

N

N

Description of cause

cause_grp_id

int32

N

N

Identify group to which this cause belongs

display_seq

int32

N

N

Specify the sequence of causes within the group

spare1

string80

N

Y

Use defined by language term 6872

spare2

string80

N

Y

Use defined by language term 6873

spare3

string80

N

Y

Use defined by language term 6874

spare4

string80

N

Y

Use defined by language term 6875

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

cause_id

ID 0

Y

N

Unique identifier

FK from cause_grp_id to cause_grp. (Cascade delete)

Cause_desc, cause_grp_id is UK.

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