📊 Overview: 26 Fields 11 Indexes 5 Many-to-One Relations 2 One-to-Many Relations
🗨️ Transaction table for Certificates of Conformance issued with product shipments. Links to WorksOrders and materials to certify product compliance with specifications.
Table ID: 6UUID: 81B9B2AF685A1B4E892794C866475FCCPrimary Key: 🔑 Cert_Of_Conformance_NoGenerated: 🕐 2025-12-04T14:33:34Z Field Type Constraints Description 🔑 Cert_Of_Conformance_No Long Integer🔑 PK, ✨ Unique, ⚡ Auto, ⚠️ Required, 🚫 Not Null - Customer_Code String (3)⚠️ Required, 🚫 Not Null - Created_Date Date⚠️ Required, 🚫 Not Null - Advice_Note_No Long Integer🚫 Not Null - Part No String (30)⚠️ Required, 🚫 Not Null - Customer_Order_No String (20)⚠️ Required, 🚫 Not Null - MovementCofC Boolean🚫 Not Null - RMC_Nos String (30)🚫 Not Null - Delivery_Quantity Long Integer⚠️ Required, 🚫 Not Null - Works_Order_No Long Integer⚠️ Required, 🚫 Not Null - Petes No Long Integer🚫 Not Null - Quantity_Loose Long Integer🚫 Not Null - Price Real🚫 Not Null - Nunber_Of_Boxes Integer🚫 Not Null - Number_In_Box Long Integer🚫 Not Null - loose String🚫 Not Null - Order_Completed Boolean🚫 Not Null - Batch_No String (5)🚫 Not Null - CofC_Report Boolean🚫 Not Null - Invoice_Report Boolean🚫 Not Null - ProductID_l Long Integer🚫 Not Null - Date_Int Long Integer🚫 Not Null - DeliveredDate_d Date🚫 Not Null - LocationID_l Long Integer🚫 Not Null - LocationName_s String (30)🚫 Not Null - Delivery_Method_s String (30)🚫 Not Null -
Field Type Kind Unique Cert_Of_Conformance_NoKeywords regular ✨ Yes CofC_ReportKeywords regular - Works_Order_NoKeywords regular - Advice_Note_NoKeywords regular - Date_IntKeywords regular - Customer_CodeKeywords regular - Invoice_ReportKeywords regular - ProductID_lKeywords regular - MovementCofCKeywords regular - Part NoKeywords regular - Petes NoKeywords regular -
Relation Name Destination Table Source → Destination State Description WorksOrderEntityWorksOrder Works_Order_No → Works_Order_NoActive - Customer_OrderEntityCustomer_Order Petes No → Petes_NoActive - Advice_NoteEntityAdvice_Note Advice_Note_No → Advice_Note_NoActive - Stock_LocationEntityStock_Location LocationID_l → StockLocationID_lActive - ProductEntityProduct ProductID_l → Product_IDActive -
Relation Name Source Table Source → Destination State Description BoxLabelsSelectionBoxLabels CofCID → Cert_Of_Conformance_NoActive - PalletSelectionPallet CofCID → Cert_Of_Conformance_NoActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:34Z