Version: 2024 Sage 50 US
Columns
| Column Name | Data Type |
|---|---|
| AssemblyRecordNo | UINTEGER |
| ComponentNumber | UINTEGER |
| ComponentRecordNo | UINTEGER |
| EffectiveDate | DATE |
| GUID | BINARY(16) |
| LastUpdateCounter | UINTEGER |
| QtyRequired | DECIMAL |
| RecordNumber | IDENTITY |
| RevisionNumber | UINTEGER |
Indexes
- ByAssemblyDate:
- ByAssemblyRev:
- ByComponent:
- ByGUID:
- UK_RecordNumber:
Foreign Keys
No foreign key metadata (or none defined).
Example Query
SELECT *
FROM BOMItems
LIMIT 0, 50;