DEXO Exports Entity Relationship Diagram (ERD)
This view presents the core data model structured around the project's key entities: **User Security**, **Master Data**, and **Core Transactions**.
PK: Primary Key
FK: Foreign Key
Entities are grouped by application concern (Base/Master Data/Sales/Purchase).
Security & Base
User
User_ID (PK)
Username
PasswordHash
Role
Category
Category_ID (PK)
Name
IsActive
CreatedBy_User_ID (FK)
Core Master Data
UOM (Unit of Measure) (1)
UOM_ID (PK)
Name
Description
CreatedBy_User_ID (FK)
Item
Item_ID (PK)
Category_ID (FK)
ItemName
UOM_ID (FK)
Rate
RemainingQTY
CreatedBy_User_ID (FK)
Vendor
Vendor_ID (PK)
Name
Address
Contact
IsActive
CreatedBy_User_ID (FK)
Sales Transaction (SO)
Customer
Customer_ID (PK)
FullName
CustomerType
Mobile
City
CreatedBy_User_ID (FK)
Sell Order (SO) - Export Order
SO_ID (PK)
Customer_ID (FK)
CreatedBy_User_ID (FK)
Date
GrandTotal
Discount
FinalPayable
SO Line Item
SOLine_ID (PK)
SO_ID (FK)
Item_ID (FK)
Quantity
Rate
LineTotal
Purchase Transaction (PO)
Purchase Order (PO) - Import Order
PO_ID (PK)
Vendor_ID (FK)
CreatedBy_User_ID (FK)
Date
VendorInvoiceID
GrandTotal
Discount
FinalPayable
PO Line Item
POLine_ID (PK)
PO_ID (FK)
Item_ID (FK)
Quantity
Rate
LineTotal
Note: Relationships are explicitly defined by FKs due to limitations in drawing complex paths reliably without SVG/Canvas.
