Module 1 Lagniappe

Supplement to Module 1 PWC SQL Case Study.

PWC SQL Case Study

Information not discussed in class

Data Lineage

Key Questions to ask:

What is an ERP System

General ledger and sub-ledger

Automated Journal Entries

Manual Journal Entries

Transactions and master data

  • ERP modules include multiple tables with different types of information about a transaction
  • Key data fields sit in multiple data tables creating relationships across the data
  • Multiple data tables are read, updated, etc. even for simple transactions
  • Within the ERP, each accounting process has configuration settings that ensure transactions are processed correctly and consistently

Transactional data

  • Generated as a result of a specific transaction

Master data

  • Not related to specific events but required for transactions of a given type

Common ERP Systems