π Overview: 25 Fields 3 Indexes 3 One-to-Many Relations
π¨οΈ Master data table for material and equipment suppliers. Stores supplier contact details, payment terms, and performance metrics. Links to Materials and Purchases.
Table ID: 18UUID: DD48C27A4EEF9442A7DB4C93B8CD90D3Primary Key: π SupplierID_lGenerated: π 2025-12-04T14:33:44Z Field Type Constraints Description π SupplierID_l Long Integerπ PK, β¨ Unique, β‘ Auto, π« Not Null, οΏ½οΏ½οΏ½ Not Modifiable - Name_s String (31)β οΈ Required, π« Not Null - Address1_s String (41)π« Not Null - Address2_s String (41)π« Not Null - Address3_s String (41)π« Not Null - County_s String (21)π« Not Null - Postcode_s String (11)π« Not Null - TelephoneNo_s String (15)π« Not Null - FaxNo_s String (21)π« Not Null - AccountsCode_s String (5)π« Not Null - TypeOfSupply_s String (25)π« Not Null - AdditionalInfo_txt Stringπ« Not Null - ContactName_s String (31)π« Not Null - EMailAddress_s String (51)π« Not Null - ConfirmationR Booleanπ« Not Null - FaxNo2_s String (30)π« Not Null - EMailAddress2_s String (51)π« Not Null - Position_s String (21)π« Not Null - Archived_b Booleanπ« Not Null - ContactName2_s String (21)π« Not Null - VATRate_r Realπ« Not Null - TelephneNo1_s String (15)π« Not Null - LastOrdered Dateπ« Not Null - ApprovalStatus String (255)π« Not Null - CofaEmailContact String (255)π« Not Null -
Field Type Kind Unique Name_sKeywords regular - Archived_bKeywords regular - SupplierID_lKeywords regular β¨ Yes
Relation Name Source Table Source β Destination State Description SuppliesSelectionSupplies SupplierID_l β SupplierID_lActive - PurchasesSelectionPurchases SupplierID_l β SupplierID_lActive - SupplierDocumentationSelectionSupplierDocumentation SupplierID β SupplierID_lActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:44Z