NominalCodes
| 📊 Overview: 6 Fields | 3 Indexes | 1 One-to-Many Relations |
📝 Description
🗨️ Accounting lookup table defining general ledger codes for financial transactions. Used to categorize costs and revenue by account type.
- Table ID: 84
- UUID: B4B021F72621A44A861BDFF8762EE00C
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:46Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| NominalCode | Long Integer | ✨ Unique | - |
| Description | String (255) | 🚫 Not Null | - |
| Code_4D | String (255) | 🚫 Not Null | - |
| Category | String (255) | 🚫 Not Null | - |
| FinishedGoodsTransport | Boolean | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
FinishedGoodsTransport | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
NominalCode | B-Tree | regular | ✨ Yes |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
PurchaseInfoSelection | PurchaseInfo | NominalCode → ID | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:46Z