- Must be valid name.
- Unique within Model.
- Upto 25 characters including embedded blanks.
File Types in Synon:
File Types Attribute Description Example
Database CPT Capture File Order Entry
REF Reference File Company File
Non- database STR Structure File Audit date & Timestamp
Reference Files:- (REF)
Master File that contain non volatile information.
e.g. Product, Employee, Customer.
Capture File :- (CPT)
Contain transactional data that is recorded regualrly.
e.g. Order, Sales.
Strucuture Files:- (STR)
Contain group of fields that can be included in other files using "INCLUDES" relation.
e.g. Audit Stamp File.
Default functions:
- standard functions are automatically defined for files.
- default functions depend on file types.
*************************************************************************
Default functions for REF files:
Function Access Path
CRTOBJ - Create Object UPD
DLTOBJ - Delete Object UPD
CHGOBJ - Change Object UPD
SELRCD - Select Record RTV
EDTFIL - Edit File RTV
*************************************************************************
Default functions for CPT files
Function Access Path
CRTOBJ - Create Object UPD
DLTOBJ - Delete Object UPD
CHGOBJ - Change Object UPD
*************************************************************************
Creating/Defining Files
At the Edit Database Relations panel, press F10 to show Define Objects panel
- In the Object type column, enter FIL.
- Type File Name in Object Name column.
- Type CPT or REF or STR in Object attr column depending on the file type.
- Defined as relation for the file is automatically created.
