| 🔑 Customer_Code | String (3) | 🔑 PK, ✨ Unique, ⚠️ Required, 🚫 Not Null, ��� Not Modifiable | Primary key - Unique 3-character customer identifier code. Non-modifiable after creation. |
| Cust Name | String (35) | ⚠️ Required, 🚫 Not Null | Company name of the customer. Maximum 35 characters, mandatory field. |
| Cust Addr1 | String (35) | 🚫 Not Null | First line of customer’s billing address. |
| Cust Addr2 | String (35) | 🚫 Not Null | Second line of customer’s billing address. |
| Cust Addr3 | String (35) | 🚫 Not Null | Third line of customer’s billing address (indexed for search). |
| Cust Addr4 | String (35) | 🚫 Not Null | Fourth line of customer’s billing address. |
| Cust Postcode | String (20) | 🚫 Not Null | Postal code for customer’s billing address. |
| Cust Phone1 | String (20) | 🚫 Not Null | Primary phone number for the customer. |
| Cust Fax | String (20) | 🚫 Not Null | Fax number for the customer (legacy field). |
| Cust Contact1 | String (20) | 🚫 Not Null | Name of primary contact person at customer’s organization. |
| Email1 | String (80) | 🚫 Not Null | Email address for primary contact person. |
| Cust Notes | String | 🚫 Not Null | Free-text notes and comments about the customer. Unlimited length. |
| Cust Cum Ord | Real | 🚫 Not Null | Cumulative order value total for this customer. |
| Cust Inv Date | Date | 🚫 Not Null | Date of last invoice sent to this customer. |
| Cust Label1 | String (25) | ⚠️ Required, 🚫 Not Null | Primary label format/template name for customer shipments. Mandatory field. |
| Cust Label2 | String (25) | 🚫 Not Null | Secondary label format/template name for customer shipments. |
| Cust label3 | String (25) | 🚫 Not Null | Tertiary label format/template name for customer shipments. |
| Acknowledgement | Boolean | 🚫 Not Null | Flag indicating whether order acknowledgements should be sent to this customer. |
| Acknow Contact | String (30) | 🚫 Not Null | Name of contact person who should receive order acknowledgements. |
| Archive | Boolean | 🚫 Not Null | Flag indicating whether customer is archived (inactive). Indexed for filtering. |
| CustContact2 | String (20) | 🚫 Not Null | Name of secondary contact person at customer’s organization. |
| CustPhone2 | String (20) | 🚫 Not Null | Phone number for secondary contact person. |
| CustPosition1 | String (20) | 🚫 Not Null | Job title/position of primary contact person. |
| CustPosition2 | String (20) | 🚫 Not Null | Job title/position of secondary contact person. |
| Email2 | String (80) | 🚫 Not Null | Email address for secondary contact person. |
| CofCRequired_b | Boolean | 🚫 Not Null | Flag indicating whether Certificate of Conformance is required for this customer’s orders. |
| DeliveryAddress_txt | String | 🚫 Not Null | Complete delivery address if different from billing address. Unlimited length. |
| SupplierCode | String (30) | 🚫 Not Null | Code used to identify this customer as a supplier in their own system. |
| DeliveryDays | Integer | 🚫 Not Null | Standard number of days for delivery to this customer. |
| CustPosition3 | String (20) | 🚫 Not Null | Job title/position of third contact person. |
| CustPosition4 | String (20) | 🚫 Not Null | Job title/position of fourth contact person. |
| CustPosition5 | String (20) | 🚫 Not Null | Job title/position of fifth contact person. |
| CustPosition6 | String (20) | 🚫 Not Null | Job title/position of sixth contact person. |
| CustContact3 | String (20) | 🚫 Not Null | Name of third contact person at customer’s organization. |
| CustContact4 | String (20) | 🚫 Not Null | Name of fourth contact person at customer’s organization. |
| CustContact5 | String (20) | 🚫 Not Null | Name of fifth contact person at customer’s organization. |
| CustContact6 | String (20) | 🚫 Not Null | Name of sixth contact person at customer’s organization. |
| CustPhone3 | String (20) | 🚫 Not Null | Phone number for third contact person. |
| CustPhone4 | String (20) | 🚫 Not Null | Phone number for fourth contact person. |
| CustPhone5 | String (20) | 🚫 Not Null | Phone number for fifth contact person. |
| CustPhone6 | String (20) | 🚫 Not Null | Phone number for sixth contact person. |
| Email3 | String (80) | 🚫 Not Null | Email address for third contact person. |
| Email4 | String (80) | 🚫 Not Null | Email address for fourth contact person. |
| Email5 | String (80) | 🚫 Not Null | Email address for fifth contact person. |
| Email6 | String (80) | 🚫 Not Null | Email address for sixth contact person. |
| BoxesPerPallet | Real | 🚫 Not Null | Standard number of boxes per pallet for this customer’s shipments. |
| OrderEmail | String (255) | 🚫 Not Null | Email address for sending order confirmations and updates. |
| PalletTransportCost | Real | 🚫 Not Null | Cost per pallet for transport to this customer. |
| TransportComment | String (255) | 🚫 Not Null | Special transport instructions or notes for deliveries to this customer. |
| RequiresMaterialCofA | Boolean | - | Flag indicating whether Material Certificate of Analysis is required for this customer. |
| NtnSnrLocationCode | String (255) | - | NTN-SNR specific location code for this customer. Indexed for quick lookup. |
| Consignment | Boolean | 🚫 Not Null | Flag indicating whether customer uses consignment stock model. Indexed for filtering. |
| ConsignmentLocationID | Long Integer | - | Foreign key to Stock_Location table for consignment stock location. Indexed, relates to Stock_LocationEntity. |
| MigrationID | String | - | Unique identifier from legacy system for data migration tracking. Indexed. |
| LastMigration | String (255) | - | Timestamp or identifier of last migration/sync operation for this record. |
| TransportInstructionFileID | Long Integer | - | Foreign key to File table for attached transport instruction document. Relates to TransportInstructionFileEntity. |