PurchaseInfo

📊 Overview: 24 Fields

8 Indexes

3 Many-to-One Relations

2 One-to-Many Relations

📝 Description

🗨️ Detail table for individual line items within purchase orders. Each record represents one material/supply item ordered from a supplier.

Field	Type	Constraints	Description
🔑 UniqueID_l	`Long Integer`	🔑 PK, ✨ Unique, ⚡ Auto, ⚠️ Required, 🚫 Not Null	-
OrderNo_l	`Long Integer`	🚫 Not Null	-
SuppliesID_i	`Integer`	🚫 Not Null	-
Currency_s	`String` (3)	🚫 Not Null	-
Reference_s	`String` (20)	🚫 Not Null	-
Description_txt	`String`	🚫 Not Null	-
Quantity_r	`Real`	🚫 Not Null	-
Unit_s	`String` (20)	🚫 Not Null	-
Price_r	`Real`	🚫 Not Null	-
PriceQuantity_l	`Long Integer`	🚫 Not Null	-
Cost_r	`Real`	🚫 Not Null	-
FontStyle_i	`Integer`	🚫 Not Null	-
FontSize_i	`Integer`	🚫 Not Null	-
QuantityReceived_r	`Real`	🚫 Not Null	-
QuantityInvoiced_r	`Real`	🚫 Not Null	-
Received	`Boolean`	🚫 Not Null	-
Invoiced	`Boolean`	🚫 Not Null	-
InvoiceNumber	`String` (255)	🚫 Not Null	-
DateRequested	`Date`	🚫 Not Null	-
NominalCode	`Long Integer`	🚫 Not Null	-
Revision	`Integer`	🚫 Not Null	-
CAPEX	`Long Integer`	🚫 Not Null	-
Invoice	`String` (255)	🚫 Not Null	-
DateReceived	`Date`	🚫 Not Null	-

Field	Type	Kind	Unique
`OrderNo_l`	Keywords	regular	-
`UniqueID_l`	Keywords	regular	✨ Yes
`Invoiced`	Keywords	regular	-
`SuppliesID_i`	Keywords	regular	-
`Description_txt`	Cluster	keywords	-
`Received`	Keywords	regular	-
`DateRequested`	Keywords	regular	-
`Description_txt`	Keywords	regular	-

Relation Name	Destination Table	Source → Destination	State	Description
`PurchasesEntity`	Purchases	`OrderNo_l` → `OrderNo_l`	Active	-
`SuppliesEntity`	Supplies	`SuppliesID_i` → `UniqueID_i`	Active	-
`NominalCodesEntity`	NominalCodes	`NominalCode` → `ID`	Active	-

Relation Name	Source Table	Source → Destination	State	Description
`PurchaseReceiptsSelection`	PurchaseReceipts	`PurchaseInfoID` → `UniqueID_l`	Active	-
`RMCSelection`	RMC	`PurchaseInfoID` → `UniqueID_l`	Active	-

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:48Z