Missing piece administration (only usable in a follow-up version)

The data of the missing piece administration are stored in the skr.defective_parts table.
Normalization and distribution of the data into several tables were not included at least for the time being (for performance reasons when inserting).

This is possible, as the missing piece administration is implemented as a type of "cash register system".

Data is never changed in this table, only new data is added!

In case of incorrect entries a "cancellation entry" is created.
(Naturally, old entries, which are no longer needed, can be deleted interactively.)

In case that the table becomes too big, the ticket data starting from TICKET_PRODUCTION_ID can be moved to a second table with TICKET_UID as KEY.

The PPS may access this table not only indirectly.

• New data records can be inserted with the UDF skrpps_02.addd_defective_part_data(…).
• The content of the table can be accessed via the skrpps_02.v_defective_parts view.