CofC
| 📊 Overview: 26 Fields | 11 Indexes | 5 Many-to-One Relations | 2 One-to-Many Relations |
📝 Description
🗨️ Transaction table for Certificates of Conformance issued with product shipments. Links to WorksOrders and materials to certify product compliance with specifications.
ℹ️ Table Information
- Table ID: 6
- UUID: 81B9B2AF685A1B4E892794C866475FCC
- Primary Key: 🔑
Cert_Of_Conformance_No - Generated: 🕐 2025-12-04T14:33:34Z
📑 Table of Contents
- 📋 Fields (26)
- 🔍 Indexes (11)
- 🔗 Many-to-One Relations (5)
- 🔗 One-to-Many Relations (2)
- 🔗 Related Items
📋 Fields
| 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 | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
Cert_Of_Conformance_No | Keywords | regular | ✨ Yes |
CofC_Report | Keywords | regular | - |
Works_Order_No | Keywords | regular | - |
Advice_Note_No | Keywords | regular | - |
Date_Int | Keywords | regular | - |
Customer_Code | Keywords | regular | - |
Invoice_Report | Keywords | regular | - |
ProductID_l | Keywords | regular | - |
MovementCofC | Keywords | regular | - |
Part No | Keywords | regular | - |
Petes No | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
WorksOrderEntity | WorksOrder | Works_Order_No → Works_Order_No | Active | - |
Customer_OrderEntity | Customer_Order | Petes No → Petes_No | Active | - |
Advice_NoteEntity | Advice_Note | Advice_Note_No → Advice_Note_No | Active | - |
Stock_LocationEntity | Stock_Location | LocationID_l → StockLocationID_l | Active | - |
ProductEntity | Product | ProductID_l → Product_ID | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
BoxLabelsSelection | BoxLabels | CofCID → Cert_Of_Conformance_No | Active | - |
PalletSelection | Pallet | CofCID → Cert_Of_Conformance_No | Active | - |
🔗 Related Items
📦 Classes
- CofCEntity - ORDA Entity class for CofC table
📄 Forms
- CancelAdviceNote - Data source for CancelAdviceNote form
- ConsignmentCallOff - Data source for ConsignmentCallOff form
- CustomerOrders - Data source for CustomerOrders form
- Forecast - Data source for Forecast form
- OrderDelivery - Data source for OrderDelivery form
- SNRSUMMARY - Data source for SNRSUMMARY form
- StockMovements - Data source for StockMovements form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:34Z