Release 59

by

Additions

Customer Details & Project Details APC

  • Initial release of these DataMart views, incorporating recent Project and Client information specific to the APAC region.

Alterations

General Ledger Transaction

  • Added additional codes to enhance transaction details:
    • Voucher Type
    • Supplier Identity
    • Supplier Name
    • Reference Series
    • Reference Number

Customer Details (CAD & USD)

  • New source utilising recently supplied Customer spreadsheets.
  • CAD: Previously sourced from the Vision CL table.
  • USD: First initial view now introduced.

Business Opportunity Dates (Busopp Dates)

  • WANTED DATE field added, previously omitted from recent view in error.

Notes

The following SQL scripts have been modified and differ from previous versions:

  1. ⚠️ customer_details_APC.sql
  2. ⚠️ project_details_APC.sql
  3. ⚠️ generalledger_transaction.sql
  4. ⚠️ customer_details_CAD.sql
  5. ⚠️ customer_details_USD.sql
  6. ⚠️ busopp_dates.sql

There were additional alterations to cdm to support transaction error logging

1. ⚠️ DIFFERENT: create_table_comment.sql
2. ⚠️ DIFFERENT: create_table_log.sql
Source ID altered to accommodate varchar(16)
3. ⚠️ DIFFERENT: upsert_comment.sql
4. ⚠️ DIFFERENT: upsert_comment_insert.sql
5. ⚠️ DIFFERENT: upsert_comment_update.sql
6. ⚠️ DIFFERENT: upsert_log.sql
7. ⚠️ DIFFERENT: upsert_log_insert.sql
8. ⚠️ DIFFERENT: upsert_log_update.sql
Pass thru varchar(16) previously varchar(8)
9. ⚠️ DIFFERENT: myview.sql
Transaction logging to utilise new log.tran_mylog table

Leave a Comment