VIIJOB Export Data Elements File (VIIJOB_ExportDataElementsFile) Level: 4.40
Record Type: 1 Export Data Item Record 08/28/2009
File Type: Mkeyed Key Size: 0 Rec Len: 2413 Min Len: 2413 Define: Y
Main Key (KNO=0)JobName(1,15)+ElementIndex(16,5)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Name. . . . . . . . . . . . . . . . JobName . . . . . . . . . . . String (1,15)
Element Index . . . . . . . . . . . . . ElementIndex. . . . . . . . . String (16,5)
Converted To Numeric Variable . . . . . . . . . . . . . . . . . . . Memo
Data Dictionary File Name . . . . . . . DataDictionaryFileName. . . . String (21,10)
Element Field Name. . . . . . . . . . . ElementFieldName. . . . . . . String (1,28)
Field Type. . . . . . . . . . . . . . . FieldType . . . . . . . . . . Uppercase (1,1)
S=Standard. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
H=Header. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
L=Line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Data Type . . . . . . . . . . . . . . . DataType. . . . . . . . . . . String (1,1)
Export-To File Name . . . . . . . . . . ExportToFileName. . . . . . . String (1,5)
Field Starting Position . . . . . . . . FieldStartingPosition . . . . Number [0] 5.0
Field Length. . . . . . . . . . . . . . FieldLength . . . . . . . . . Number [1] 5.0
Numeric Field Index . . . . . . . . . . NumericFieldIndex . . . . . . Number [2] 5.0
Multiple Record Types Group Code. . . . MultipleRecordTypesGroupCode. String (1,1)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (1,1)
A=Assign. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
C=Calculated. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
T=Runtime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Field Is Part Of Odbc Index . . . . . . FieldIsPartOfOdbcIndex. . . . Yes/No (1,1)
Field Account Mask. . . . . . . . . . . FieldAccountMask. . . . . . . String (1,20)
Field Date Mask . . . . . . . . . . . . FieldDateMask . . . . . . . . String (1,30)
Field Numeric Mask. . . . . . . . . . . FieldNumericMask. . . . . . . String (1,20)
Sub String. . . . . . . . . . . . . . . SubString . . . . . . . . . . Yes/No (1,1)
Sub String Start. . . . . . . . . . . . SubStringStart. . . . . . . . Number [0] 5.0
Sub String Length . . . . . . . . . . . SubStringLength . . . . . . . Number [1] 5.0
Delimited File Column Number. . . . . . DelimitedFileColumnNumber . . Number [2] 5.0
Ascii File Start Position . . . . . . . AsciiFileStartPosition. . . . Number [3] 5.0
Odbc Field Data Storage String. . . . . OdbcFieldDataStorageString. . String (1,60)
Odbc Field Type . . . . . . . . . . . . OdbcFieldType . . . . . . . . Uppercase (1,10)
Bit = Yes/No . . . . . . . . . . . . . . . . . . . . . . . . Memo
Counter = Auto-Number. . . . . . . . . . . . . . . . . . . . . . Memo
Currency = Currency . . . . . . . . . . . . . . . . . . . . . . . Memo
Datetime = Date-Time. . . . . . . . . . . . . . . . . . . . . . . Memo
Long = Number . . . . . . . . . . . . . . . . . . . . . . . . Memo
Longbinary = Ole Object . . . . . . . . . . . . . . . . . . . . . . Memo
Longtext = Hyperlink. . . . . . . . . . . . . . . . . . . . . . . Memo
Longtext = Memo . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Text = Text . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Calculation Expression. . . . . . . . . CalculationExpression . . . . String (1,1024)
Default Value For Blank Fields. . . . . DefaultValueForBlankFields. . String (1,60)
Conditional Expression. . . . . . . . . ConditionalExpression . . . . String (1,1024)
Note: If Cond. Expr. Fails, A . . . . . . . . . . . . . . . . . . . Memo
Blank Field Will Be Exported To . . . . . . . . . . . . . . . . . . Memo
The New Output Record. Existing. . . . . . . . . . . . . . . . . . Memo
Odbc Fields Will Not Be Replaced. . . . . . . . . . . . . . . . . . Memo
Udf Entity. . . . . . . . . . . . . . . UdfEntity . . . . . . . . . . String (1,3)
Temporary Field Flag. . . . . . . . . . TemporaryFieldFlag. . . . . . String (1,1)
Execute Calculation On... . . . . . . . ExecuteCalculationOn. . . . . Uppercase (1,1)
(Header, Line, Both). . . . . . . . . . . . . . . . . . . . . . . . Memo
Reset Temp Vars On Each Record. . . . . ResetTempVarsOnEachRecord . . Yes/No (1,1)
Calculation Only. . . . . . . . . . . . CalculationOnly . . . . . . . Yes/No (1,1)
Runtime Field Prompt. . . . . . . . . . RuntimeFieldPrompt. . . . . . String (1,30)
Runtime Library Object Name . . . . . . RuntimeLibraryObjectName. . . String (1,10)
________
Total Bytes 2445