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