Additions Customer Details & Project Details APC Alterations General Ledger Transaction Customer Details (CAD & USD) Business Opportunity Dates (Busopp Dates) Notes The following SQL scripts have been modified and differ from previous versions: There were additional alterations to cdm to support transaction error logging 1. ⚠️ DIFFERENT: create_table_comment.sql2. ⚠️ DIFFERENT: create_table_log.sqlSource ID altered to … Read more
Commercially sensitive data includes any information that, if compromised, lost, or disclosed without authorisation, could cause moderate financial, competitive, reputational, or operational harm to the organisation. Handling such data requires additional care to ensure compliance with internal policies, contractual obligations, and regulatory requirements. 1. Key Characteristics of Commercially Sensitive Data Commercially sensitive data typically falls … Read more
Purpose General Ledger Period Budget Use Case Owner: Soon TanTypical Use Case: General Ledger Period BudgetStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General ledger Transaction Use Case Owner: Soon TanTypical Use Case: General ledger TransactionStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Project Balance Use Case Owner: Soon TanTypical Use Case: General Ledger Project BalanceStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Balance Set Use Case Owner: Soon TanTypical Use Case: General Ledger Balance SetStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose Provides Fact Data Use Case Owner: Soon TanTypical Use Case: General Ledger BalanceStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose Details Use Case Owner: Soon TanTypical Use Case: General LedgerStyle: Details Source Key Parameters CompanyLedger_ID (Created)Account_IDPRUPROJECT_ID Sample Exec Response SEQ Dates Codes SQL
Purpose Provides Management Account Structure Use Case Owner: Soon TanTypical Use Case: Financial Account StructureStyle: Detail Source Key Parameters CompanyAccount Code Sample Exec Response Level 1 Heading Grouping 1 Grouping 2 Leaf Account SQL