ES_FACILITY_SECURITY

e-Signature Facility Security

tableFINES

ES_FACILITY_SECURITY — e-Signature Facility Security. FIN table in the standard Ross ERP 8.0 schema: 8 columns, used by 13 programs. Columns, data types, keys, foreign keys and relationships.

Open ES_FACILITY_SECURITY 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.
2COMPANY_CODEvarchar(10)PKCompany Code
3ES_DATABASE_HANDLEvarchar(3)PKe-Sginature Database Handle
4ES_SYSTEM_NAMEvarchar(32)PKe-Signature System Name
5ES_FACILITY_IDvarchar(32)PKe-Signature Facility Name
6ES_NUMBER_OF_SIGNATURESsmallinte-Signature Number of Signatures
7ES_FACILITY_SECURITY_LEVEL_1smallint
8ES_FACILITY_SECURITY_LEVEL_2smallint