Hello, I am doing integration with Sage 300 CRE and trying to read data from some tables. As an example I am using installed "Construction Sample Data" folder and it's subfolders. For some data/fields I do not know in which tables/columns to look. For Employees I need to find a "certified class description" column For Jobs I need to find a string representation (column) of jstatus from "MASTER_JCM_R1" table For Cost Codes I need to find a string representation (column) of pstatus from "MASTER_JCM_R3" table and also "cost code units, quantities, hours" columns Which is default Employee table, one in SMData or in PVData (PRM_R1.MKD file) ? Any help will be appreciated. Thanks!

Sage 300 CRE Pervasive DB information related to some tables

Posted By Rhumbix over 5 years ago

Hello,

I am doing integration with Sage 300 CRE and trying to read data from some tables.

As an example I am using installed "Construction Sample Data" folder and it's subfolders.

For some data/fields I do not know in which tables/columns to look.

For Employees I need to find a "certified class description" column
For Jobs I need to find a string representation (column) of jstatus from "MASTER_JCM_R1" table
For Cost Codes I need to find a string representation (column) of pstatus from "MASTER_JCM_R3" table and also "cost code units, quantities, hours" columns
Which is default Employee table, one in SMData or in PVData (PRM_R1.MKD file) ?

Any help will be appreciated. Thanks!