...
...
...
...
Sharperlight Data Model 2.5.2.1
11 Dec 2023
Added Subcontract Retention Trust Accounts.
Sharperlight Data Model 2.5.1.1
31 Oct 2023
The data model 2.5.1.0 contains a bug in the VoucherStatus field which will break any query using it.
Version 2.5.1.1 fixes this issue.
Sharperlight Data Model 2.5.1.0
23 Oct 2023
Incorporated custom code to cater for transaction approval writeback.
Changed source of writeback tables to be select statements rather that the whole source table. This is to avoid problems when merging new columns from an updated database schema.
Aligned the Assigned To Person and Voucher Status on AP Vouchers with the AP Voucher List in the application.
Added Asset Attributes link to Assets table.
Fixed incorrect join for Plant Issues Rate Codes.
Added the following tables:
Emails
Surcharge Discounts
Job Surcharge Discounts
People Attributes
Added new columns to existing tables:
AP Invoices
AP Invoice Lines
Bonds
Companies
Cost Categories
Expense Claims
Expense Claim Lines
GL Accounts
Job Invoice Lines
Job Outputs
Jobs
Log Headers
Plant Groups
Plant Statistics
Purchase Orders
Purchase Order Lines
Subcontracts
WIP Codes
...