GoldMine Table Structures.
FORMS
DBase Directory Location: GMBASE
Table Description: Documents available for merging.
Table Indexes | |||
Name | DBase Index | SQL Index | ID |
FORMS | UPPER(RECTYPE+USERID+FORMDESC) | RECTYPE+USERID+FORMDESC | - |
FLTRECID | RECID | RECID | - |
Table Relationships |
Field |
None |
Table Fields Structure | |||||||||||||
Field Name | Field Type | Length | Description | ||||||||||
RECTYPE | String | 4 | Position 1 is type of document – Form (from Document Management Center), Literature (from Literature Fulfillment Center), E-mail Template. Position 2 is typically blank. Position 3 is the Document Type (Position 1=’F’). 1=Document, 2=Spreadsheet, 3=Envelope, 4=Label. |
||||||||||
USERID | String | 16 | Characters 1-8=Username/Owner of document. If blank, document is public. Characters 9-16=Sort order for this document. |
||||||||||
FLAGS | String | 10 | Document Management flags indicating No (0) or Yes (1).
|
||||||||||
TEMPLATE | String | 80 | Document directory and file name. | ||||||||||
FORMDESC | String | 40 | Document description | ||||||||||
APPNAME | String | 20 | Application and version (i.e. Word.Document.8) | ||||||||||
MACRO | String | 50 | Macro used when launching application and document | ||||||||||
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=YYYYMMDDHHMM, FILENAME={Full path of directory and file name}. |
||||||||||
RECID | String | 15 | Record ID |