Enterprise Financials Database Schema
Database - New Tables
Terminology Mapping
The Financials module was originally written by another company, which was acquired by QAD. At that time, many of the core tables used names different from those used by standard MFG/PRO. As a result, the names of internal tables do not exactly match the labels used within the application
Database - Fields in New Tables
Database - Fields in New Tables 2
Database - Fields in New Tables 3
Database - Fields in New Tables 4
Data Replication/Data Ownership
Data Replication/Data Ownership 2
Data Replication/Data Ownership 3
Data Replication/Data Ownership 4
Data Replication/Data Ownership 5
Data Replication/Data Ownership 6
Replicated Tables
Replicated Tables 2
Replicated Tables 3
Business Data Model
Levels of Data
Shared Set Data
One set can even be used by entities from different domains.
Shared Sets
Shared Sets - Assignment to Domain
Shared Sets - Assignment to Entity
Browses on Entity Data
Make sure that the CompanyCode is a column in the browse resultset so that browse users can filter on the current entity.
Browses on Shared Data
Also, make sure that CompanyCode is a column in the browse resultset so that browse users can filter on the current entity.
