     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$ --. . . . . . . . . . .