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