2.5.1 - 31 Oct 2023

Owned by Malcolm Mackay
Last updated: Dec 17, 2023
1 min read

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

 

 

 

 

Â