 Definition (DFN) |
Browse, Report and Export File def's $
|
|
Keys
|
| Name |
Attributes |
Fields |
| DFN:GuidKey |
Case |
+DFN:Guid |
| DFN:CodeKey |
Primary |
+DFN:DefnCode |
| DFN:DescKey |
Dup |
+DFN:Description |
| DFN:LinkKey |
Dup |
+DFN:LinkNumber |
|
|
Fields
|
| Name |
Type |
Picture |
Description |
| DFN:Guid |
STRING |
@s16 |
Internal System Identifier |
| DFN:DefnCode |
LONG |
@n13 |
|
| DFN:Description |
STRING |
@s50 |
|
| DFN:PrimaryFile |
STRING |
@s30 |
|
| DFN:Order |
STRING |
@s20 |
|
| DFN:OtherOrder |
STRING |
@s100 |
|
| DFN:Filter |
STRING |
@s255 |
|
| DFN:SendTo |
BYTE |
@n3 |
|
| DFN:Destination |
STRING |
@s80 |
|
| DFN:Type |
BYTE |
@n3 |
1=Report, 2=Payroll |
| DFN:Format |
BYTE |
@n3 |
0=text, 1=pdf, 2=html, 3=excel |
| DFN:Module1 |
BYTE |
@n3 |
1=Appears in TNA module |
| DFN:Module2 |
BYTE |
@n3 |
1=Appears in ACCESS module |
| DFN:Module3 |
BYTE |
@n3 |
1=Appears in HR module |
| DFN:Module4 |
BYTE |
@n3 |
1=Appears in Job Costing module |
| DFN:Archive |
BYTE |
@n3 |
1=Archived |
| DFN:Landscape |
BYTE |
@n3 |
1=Landscape mode |
| DFN:Header |
STRING |
@s255 |
|
| DFN:Footer |
STRING |
@s255 |
|
| DFN:HeaderLen |
BYTE |
@n3 |
|
| DFN:FooterLen |
BYTE |
@n3 |
|
| DFN:DetailLen |
SHORT |
@n-6 |
|
| DFN:From1 |
STRING |
@s20 |
From "Key Element 1=this" |
| DFN:From2 |
STRING |
@s20 |
From "Key Element 2=this" |
| DFN:From3 |
STRING |
@s20 |
From "Key Element 3=this" |
| DFN:To1 |
STRING |
@s20 |
|
| DFN:To2 |
STRING |
@s20 |
|
| DFN:To3 |
STRING |
@s20 |
|
| DFN:Notes |
MEMO |
1024 |
|
| DFN:FontName |
STRING |
@s30 |
|
| DFN:FontSize |
LONG |
@n-13 |
|
| DFN:FontType |
LONG |
@n-13 |
|
| DFN:FontColor |
LONG |
@n-13 |
|
| DFN:LinkNumber |
LONG |
@n-14 |
|
|
|
RelationShips
|
| Table |
Type |
This Key |
Foreign Key |
| Schedule |
1:MANY |
DFN:CodeKey |
SCH:DefnKey |
| DefnFiles |
1:MANY |
DFN:CodeKey |
DFI:key |
| DefnFields |
1:MANY |
DFN:CodeKey |
DFL:key |
|
