CODE_FILE

CODE_FILE

This table is intended to be used to gather all types of codes that might help you simplify and standardize frequent used information i.e. instead of typing information you can simply select appropriate code from CODE_FILE table.

Column Required(NotNull) Type Values Comments
IDX Yes Integer Identity (auto generated)[important]Note: Do not rely on this identity column in your code, it is reserved and volatile. Use combination of Type and Name columns to uniquely identify a given code.[/important]
Type Yes Integer Code Type: 0 – Fax cover pages, 1 – Printers, 2 – Fax servers
Name Yes Varchar(50) Code name. Must be unique for a given Type.
Descr Varchar(250) Code Description. For Printer and Fax objects this may describe location and defaults to printer comments. For Cover Page objects this is reservered for a user-defined UNC file path.
Rem1 Varchar(50) Optional remark. Can be used to filter objects of a certain type in your code, i.e. toggle visibility etc.
Rem2 Varchar(50) Optional remark. Can be used to further filter objects of a certain type in your code.