SOURCE_MODULES

Source Modules

tableFINSOURCE

SOURCE_MODULES — Source Modules. FIN table in the standard Ross ERP 8.0 schema: 8 columns, used by 222 programs. Columns, data types, keys, foreign keys and relationships.

Open SOURCE_MODULES in the interactive Data Dictionary →

Part of Other tables & objects · all tables, views & procedures

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2SOURCE_MODULEvarchar(2)PKSource Module Reference
3CODE_DESCRIPTIONvarchar(30)Code Description
4MODULE_IN_USEvarchar(1)Module in Use
5GENERATE_GL_POSTINGSvarchar(1)Generate GL Postings
6RENAISSANCE_JRNL_NUMBERsmallintRenaissance Journal Number
7MODULE_FACILITY_PREFIXvarchar(3)Prefix for Facilities in this Module
8GEM_MODIFY_DATEdatetimeSystem timestamp of the most recent modification to the row, maintained by GEMBASE.

Referenced by · 1 foreign key

SYS_FUNCTIONS