Structure of the Missing Pieces view „skrpps_02.v_defective_parts“

ID

bigint

UID of a line

TICKET_UID

bigint

Ticket UID

STATE_MODE

smallint

Actions:

• 0 = Missing pieces reported
• 1 = Re-knitting order locally at the machine
• 2 = Re-knitting order with ticket

TIME_S

imestamp without time zone

Timestamp of the entry

COUNT

integer

Quantity of Fabrics
(in case of cancellation it can also be < 0)

USER

text

User, who added the entry

MC_ID

integer

SKR machine ID

MC_GUID

text

PPS Machines Id
Due to performance redundant to MC_ID

SEQ_NAME

text

Sequence

PATTERN_NAME

text

Pattern name

PATTERN_SEQ_POS

smallint

Position of the pattern in the sequence

COMMENT

text

Any comment

TICKET_PRODUCTION_ID

text

Ticket Production ID

TICKET_PRODUCTION_SUB1_ID

text

Ticket Production Sub1 ID

TICKET_PRODUCTION_SUB2_ID

text

Ticket Production Sub2 ID

TICKET_ARTICLE_ID

text

Ticket Article ID

TICKET_CUSTOMER_ID

text

Ticket Customer ID

FLAGS

integer

Flags (for free use)