| |
INFOMINE
GMBASE
InfoCenter file—stores all data for the InfoCenter
INFOMINE |
UPPER(RECTYPE+LEFT(TSECTION,80)+LEFT(TOPIC,10) |
RECTYPE+U_TSECTION+U_TOPIC |
57 |
INFOSORT |
SORTKEY |
SORTKEY |
58 |
INFOTRAN |
RECTYPE+RECID |
RECTYPE+RECID |
59 |
INFRECID |
RECID |
RECID |
60 |
ACCOUNTNO |
String |
20 |
Account Number of contact if linked |
CREATEBY |
String |
8 |
Creation User |
RECTYPE |
String |
10 |
Record Type (‘IO1’=Global, ‘P0’Username=Private to specified user) |
SORTKEY |
String |
20 |
Unique Sort Key. Formatted as date and time the record was created |
TSECTION |
String |
100 |
Section |
TOPIC |
String |
80 |
Topic |
KEYWORDS |
String |
80 |
Keywords |
OPTIONS |
String |
10 |
Options |
OPTIONS1 |
String |
20 |
Options1 |
OPTIONS2 |
String |
20 |
Options2 |
LINKEDDOC |
Memo |
- |
Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after. Parameters include: SYNC={0/1 –
No/Yes},
CREATETIME=YYYYMMDDHHMMSS, FILENAME={Full path of directory and linked file name}. |
NOTES |
Memo |
- |
Notes (formatted as RTF) |
USERREAD |
String |
8 |
User/Group with read access (Blank=Public) |
USERWRITE |
String |
8 |
User/Group with write access (Blank=Public) |
LASTUSER |
String |
8 |
Last Modified By |
LASTDATE |
Date |
- |
Last Modified Date |
LASTTIME |
String |
5 |
Last Modified Time |
U_TSECTION |
String |
100 |
Upper-case shadow of Section (SQL Only) |
U_TOPIC |
String |
80 |
Upper-case shadow of Topic (SQL Only) |
RECID |
String |
15 |
Record ID |
|
|
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
A home is ruled by the sickest person in it.
|
|
|
|
|