SYS_EVENT_TRANSACTION_XREFS
Event Transaction Cross Reference Table
tableFINSYS
SYS_EVENT_TRANSACTION_XREFS — Event Transaction Cross Reference Table. FIN table in the standard Ross ERP 8.0 schema: 15 columns, used by 12 programs. Columns, data types, keys, foreign keys and relationships.
Open SYS_EVENT_TRANSACTION_XREFS in the interactive Data Dictionary →Part of SYS tables & objects · all tables, views & procedures
Columns
| # | Column | Type | Key | Description |
|---|---|---|---|---|
| 1 | GEM_DBKEY | int | GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one. | |
| 2 | SYS_TRANSACTION_TYPE_CODE | varchar(6) | PK | Monitor Type Code |
| 3 | SYS_EVENT_CODE | varchar(10) | PK | Event Code |
| 4 | SYS_AUDIT_DEFAULT_FLAG | varchar(1) | Audit Fixed/Default Value Flag | |
| 5 | SYS_AUDIT_FLAG | varchar(1) | Audit Flag | |
| 6 | SYS_EXCEPTION_DEFAULT_FLAG | varchar(1) | Exception Fixed/Default Value Flag | |
| 7 | SYS_EXCEPTION_FLAG | varchar(1) | Exception Flag | |
| 8 | SYS_STOP_VALIDATIONS_FLAG | varchar(1) | Stop Validations Flag | |
| 9 | SYS_PREVENT_RELEASE_DEF_FLAG | varchar(1) | Prevent Release Fixed/Default Value Flag | |
| 10 | SYS_PREVENT_RELEASE_FLAG | varchar(1) | Prevent Release Flag | |
| 11 | SYS_EVENT_PROCEDURE | varchar(80) | Event Procedure | |
| 12 | HOLD_STATUS_CODE | varchar(6) | Sales Order Hold Status Code | |
| 13 | SYS_EDI_UPDATE_OPTION | varchar(1) | EDI update option for event | |
| 14 | UPDATE_OPTION_DEFAULT_FLAG | varchar(1) | Update Option Fixed or Default flag | |
| 15 | SYS_STOP_VALIDATIONS_DEF_FLAG | varchar(1) | Stop Validations Default Flag |