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