Examples of realtions: Includes and Extended by
FIL Employee1 Owned by FIL employee
FIL Employee1 Qualified by FLD A:A7C Quatity
FIL Employee1 Known by 1 FLD A:A7C Customer ID
FIL Employee1 Extended by FIL employee
FIL Employee1 Refers to FIL employee
FIL Employee1 Has FLD A:A7C Amount
FIL Employee1 Includes FIL A:A7A Audit fields(a/c)
FIL employee Owned by FIL pharmacy
FIL employee Known by FLD empno
FIL employee Known by FLD Emp_id
FIL employee Known by FLD Employee Id
FIL employee Refers to FIL deptno
FIL employee Refers to FIL dept
FIL employee Has FLD sal
FIL employee Has FLD empname
FIL employee Has FLD empdoj
FIL employee Has FLD empmgr
FIL employee Has FLD Emp_Name
FIL employee Has FLD Emp_Phone
FIL employee Has FLD Employee Name
File name. . . . : Employee1
? Field Type Ocr Et Ksq
pharmacy id NBR K 1
empno CDE K 2
Emp_id CDE K 3
Employee Id CDE K 4
A:A7C Quatity NBR K 5
A:A7C Customer ID NBR K 6
empno 005919 CDE REF A
Emp_id 008312 CDE REF A
Employee Id 008489 CDE REF A
A:A7C Amount NBR A
Add Date DTE REF A
Add Time TME REF A
ADD User Name VNM REF A
ADD Program Name VNM REF A
Chg Date DTE REF A
Chg Time TME REF A
CHG User Name VNM REF A
CHG Program Name VNM REF A
File name. . . . : employee
? Field Type Ocr Et Ksq
pharmacy id NBR K 1
empno CDE K 2
Emp_id CDE K 3
Employee Id CDE K 4
deptno CDE A
dno CDE A
DEPARTMENT CODE TXT A
sal NBR A
empname TXT A
empdoj DT# A
empmgr CDE A
Emp_Name TXT A
Emp_Phone NBR A
Employee Name TXT A
FIL EMP Employee Known by 20 FLD EMP NO
FIL EMP Employee Has 30 FLD emp_loc
FIL EMP Employee Includes 999 FIL auditlogj
FIL auditlogj Has FLD Chg Date
FIL auditlogj Has FLD Chg Time
FIL auditlogj Has FLD Created Date
FIL auditlogj Has FLD Created Time
File name. . . . : EMP Employee
? Field Type Ocr Et Ksq
EMP NO CDE K 1
emp_loc TXT A
Chg Date DTE REF A
Chg Time TME REF A
Created Date DTE A
Created Time TME A
File name. . . . : auditlogj
? Field Type Ocr Et Ksq
Chg Date DTE REF A
Chg Time TME REF A
Created Date DTE A
Created Time TME A