Greetings,

I don't think there is comprehensive documentation for these options.  I would expect they are covered in the Data File Structures training offered by Sage Learning services. As you stated many of these are self-explanatory.

Here is a quick overview:

Physical Path -  The path where the file/table will be created. %C$ is the company code.  %S$ (used in wrk tables) is the session information (date/time stamp, etc.)

SQL Create - Yes/No - For Sage 100 Premium will the table be created in the SQL Database

SQL Sys DB - Yes/No - For Sage 100 Premium will the table be created in MAS_System or company databse.

SQL Null Dates - Yes/No For Sage 100 Premium will null dates be allowed in the table.

Exclude V/I - Yes/No - Does that table allow Import/Export via Visual Integrator.

Create Table - Yes/No - Do not create table.  Indicates if the table should be created in the database or not.

Bus Obj - The business object(s) in Sage 100 that use or support this table.

Thanks,

Kent Mackall

Hello,

Thanks for your quick reply. I also noticed that some of the objects they have following option

Enhancement Code: 5.00.00.00
What does this indicate? why this option is not for all objects?

Thanks again.

If Enhancement Code has a value that indicates that a Sage 100 Development Partner has created an enhancement that modified the table in some way.  For standard (unmodified) Sage 100 Tables this value is always blank.

Thanks,

Kent

Thanks for your help on this.