SY0DD1_DataDictionary Roswell Data Dictionary Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N SOA/SY0DD1.soa
Fld Column Name M/L TUR Description/Notes Class
1 TableName . . . . . . . . . . 6 SNN Table Name ( 6 spaces ). . . . 2 RecordCode. . . . . . . . . . 1 SNN Record Code ( 1 space ). . . . 3 FieldNumber . . . . . . . . . 3 SNN Field Number ( 3 spaces) 4 RecordFlag. . . . . . . . . . 1 SNN Record Flag "A" 5 Description . . . . . . . . . 40 SNN Version Description 6 Unknown1. . . . . . . . . . . 10 SNN Version Code 7 Unknown2. . . . . . . . . . . 1 SNN -- RCD -- . . . . . . . . . . . 8 Unknown3. . . . . . . . . . . 1 SNN -- FLD -- . . . . . . . . . . . 9 Unknown4. . . . . . . . . . . 1 SNN -- IDX -- . . . . . . . . . . . 10 Tables. . . . . . . . . . . . 0 NN . . . . . . . . . . . . . . . Valid:B 11 TableName . . . . . . . . . . 6 SNN Table Name. . . . . . . . . . . 12 RecordCode. . . . . . . . . . 1 SNN Record Code "0". . . . . . . . 13 FieldNumber . . . . . . . . . 3 SNN Field Number "000" 14 RecordFlag. . . . . . . . . . 1 SNN Record Flag "B" 15 Description . . . . . . . . . 40 SNN Table Description 16 FileType. . . . . . . . . . . 1 SYN File Type . . . . . . . . . . . Notes: A : AsciiD : DirectI : IndexedM : MkeyedS : Sort 17 DefineFile. . . . . . . . . . 1 SYN Define File . . . . . . . . . .YesNo 18 ModuleCode. . . . . . . . . . 3 SNN Module Code . . . . . . . . . . 19 Unknown1. . . . . . . . . . . 3 SNN Key Size. . . . . . . . . . . . Mask:000 20 Unknown2. . . . . . . . . . . 6 SNN Record Length . . . . . . . . . Mask:000000 21 Unknown3. . . . . . . . . . . 6 SNN Record Length Minimum String Si Mask:000000 22 Unknown4. . . . . . . . . . . 6 SNN Header File: Linked File Name . 23 UseCompanyCodeInFileName. . . 1 SYN Use Company Code in File Name .YesNo 24 SQLCreateTable. . . . . . . . 1 SYN SQL : Create Table. . . . . . .YesNo 25 Unknown5. . . . . . . . . . . 1 SYN SQL : Create in MAS90_SYSTEM DaYesNo 26 SQLSingleRcdsqlColumn . . . . 1 SYN SQL : Single RCDSQL Column. . .YesNo 27 ALEExportTable. . . . . . . . 1 SYN ALE : Export Table. . . . . . .YesNo 28 OdbcSQLTableName. . . . . . . 32 SNN ODBC/SQL : Table Name . . . . . 29 SQLLineItemFile . . . . . . . 1 SYN SQL : Line Item File. . . . . .YesNo 30 Unknown6. . . . . . . . . . . 1 SYN Key Not in Data Record. . . . .YesNo 31 SQLSingleKeysqlColumn . . . . 1 SYN SQL : Single KEYSQL Column. . .YesNo 32 SQLHexKeysqlColumn. . . . . . 1 SYN SQL : Hex KEYSQL Column . . . .YesNo 33 Unknown7. . . . . . . . . . . 29 SNN XML Tag . . . . . . . . . . . . 34 Unknown8. . . . . . . . . . . 3 SNN UDF Entity Tied to this File. . 35 Unknown9. . . . . . . . . . . 1 SYN Use RNO Stored Procedure. . . .YesNo 36 HeaderFileLinkedFieldIndex. . 2 SNN Header File: Linked Field Index Mask:00 37 ODBCExportField . . . . . . . 3 SNN ODBC Export : Field . . . . . . Mask:000 38 ODBCExportOffset. . . . . . . 3 SNN ODBC Export : Offset. . . . . . Mask:000 39 ODBCExportSize. . . . . . . . 2 SNN ODBC Export : Size. . . . . . . Mask:00 40 TableIsNormal . . . . . . . . 1 SYN Table is Normal . . . . . . . .YesNo 41 DDFExportTable. . . . . . . . 1 SYN DDF : Export Table? YesNo 42 Unknown10 . . . . . . . . . . 1 SNN -- RCD -- . . . . . . . . . . . 43 Unknown11 . . . . . . . . . . 1 SNN -- FLD -- . . . . . . . . . . . 44 Unknown12 . . . . . . . . . . 1 SNN -- IDX -- . . . . . . . . . . . 45 Records . . . . . . . . . . . 0 NN . . . . . . . . . . . . . . . Valid:C 46 TableName . . . . . . . . . . 6 SNN Table Name. . . . . . . . . . . 47 RecordCode. . . . . . . . . . 1 SNN Record Code "A-Z" or "1-9" . . 48 FieldNumber . . . . . . . . . 3 SNN Field Number "000" 49 RecordFlag. . . . . . . . . . 1 SNN Record Flag "C" 50 Description . . . . . . . . . 40 SNN Record Description 51 Unknown1. . . . . . . . . . . 1 SNN -- TBL -- . . . . . . . . . . . 52 Unknown2. . . . . . . . . . . 120 SNN Variant Expression. . . . . . . 53 Unknown3. . . . . . . . . . . 2 SNN Record Priority . . . . . . . . Mask:00 54 Unknown4. . . . . . . . . . . 1 SYN ODBC Export?. . . . . . . . . .YesNo 55 Unknown5. . . . . . . . . . . 10 SNN ODBC Export Variant Tag 56 Unknown6. . . . . . . . . . . 1 SNN -- FLD -- . . . . . . . . . . . 57 Unknown7. . . . . . . . . . . 1 SNN -- IDX -- . . . . . . . . . . . 58 Fields. . . . . . . . . . . . 0 NN . . . . . . . . . . . . . . . Valid:D 59 TableName . . . . . . . . . . 6 SNN Table Name. . . . . . . . . . . 60 RecordCode. . . . . . . . . . 1 SNN Record Code . . . . . . . . . . 61 FieldNumber . . . . . . . . . 3 SNN Field Number "001-999" 62 RecordFlag. . . . . . . . . . 1 SNN Record Flag "D" 63 Description . . . . . . . . . 40 SNN Field Description 64 Unknown1. . . . . . . . . . . 1 SNN -- TBL -- . . . . . . . . . . . 65 Unknown2. . . . . . . . . . . 1 SNN -- RCD -- . . . . . . . . . . . 66 Unknown3. . . . . . . . . . . 1 SNN Field Type. . . . . . . . . . . Notes: A : AccountD : DateB : Packed BinaryG : G/L Account NumberH : HexadecimalM : MemoN : NumberP : PhoneS : StringU : UppercaseY : Yes/NoZ : Zero-filled1 : Open String2 : Open Number3 : Packed Year YY 67 Unknown4. . . . . . . . . . . 1 SNN Field Separator ("F") . . . . . 68 Unknown5. . . . . . . . . . . 4 SNN String Offset or Numeric Array Mask:0000 69 Unknown6. . . . . . . . . . . 4 SNN String Length . . . . . . . . . Mask:0000 70 Unknown7. . . . . . . . . . . 3 SNN Numeric Mask (XXZ). . . . . . . Mask:000 Notes: XX : Digits Left of DecimalZ : Digits Right of Decimal99-0 : INTEGER number type98-0 : SMALLINT number type 71 Unknown8. . . . . . . . . . . 32 SNN SQL/ODBC : Column Name. . . . . 72 _S1 . . . . . . . . . . . . . 1 SNN Open String . . . . . . . . . . 73 Unknown9. . . . . . . . . . . 32 SNN XML Tag . . . . . . . . . . . . 74 Unknown10 . . . . . . . . . . 1 SYN Part of Key? (SYOFIL flag) YesNo 75 Unknown11 . . . . . . . . . . 1 SNN -- IDX -- . . . . . . . . . . . 76 Index Structure . . . . . . . 0 NN . . . . . . . . . . . . . . . Valid:E 77 TableName . . . . . . . . . . 6 SNN Table Name. . . . . . . . . . . 78 RecordCode. . . . . . . . . . 1 SNN Record Code """ ( Tilde ) . . 79 FieldNumber . . . . . . . . . 3 SNN Field Number (1-9/A-Z + 01-99) Notes: First byte of field number is indexnumber ( 1-9 / A-Z ) and next twobytes are sequence number ( 01-99 ).The A-Z index codes representindexes 10 through 35. 80 RecordFlag. . . . . . . . . . 1 SNN Record Flag "E" 81 Unknown1. . . . . . . . . . . 32 SNN Index Description 82 Unknown2. . . . . . . . . . . 1 SNN -- TBL -- . . . . . . . . . . . 83 Unknown3. . . . . . . . . . . 1 SNN -- RCD -- . . . . . . . . . . . 84 Unknown4. . . . . . . . . . . 1 SNN -- FLD -- . . . . . . . . . . . 85 Unknown5. . . . . . . . . . . 32 SNN Column Name (from "D" record) . 86 Unknown6. . . . . . . . . . . 1 SNN Sort Order. . . . . . . . . . . Notes: A : AscendingD : DescendingNOTE: Only "A"scending may beused on non-mkeyed files 87 Unknown7. . . . . . . . . . . 1 SNN Unique Option . . . . . . . . . Notes: U : Unique 88 Unknown8. . . . . . . . . . . 1 SNN Case Option . . . . . . . . . . Notes: C : UppercaseL : Lowercase 89 Unknown9. . . . . . . . . . . 1 SNN Translation Option Notes: T : Use Translation Table( Not Implemented ) 90 Table Notes . . . . . . . . . 0 NN . . . . . . . . . . . . . . . Valid:F 91 TableName . . . . . . . . . . 6 SNN Table Name. . . . . . . . . . . 92 RecordCode. . . . . . . . . . 1 SNN Record Code "^" ( Caret ) . . 93 FieldNumber . . . . . . . . . 3 SNN Field Number (001 - 999) Notes: Up to 999 lines at 80 bytes each 94 RecordFlag. . . . . . . . . . 1 SNN Record Flag "F" 95 Unknown1. . . . . . . . . . . 96 SNN Note 96 Unknown2. . . . . . . . . . . 1 SNN -- TBL -- . . . . . . . . . . . 97 Unknown3. . . . . . . . . . . 1 SNN -- RCD -- . . . . . . . . . . . 98 Unknown4. . . . . . . . . . . 1 SNN -- FLD -- . . . . . . . . . . . 99 Unknown5. . . . . . . . . . . 1 SNN -- IDX$ --. . . . . . . . . . .