SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: A File Heading Information (DD0$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"A" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Sequence Number "000" . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(12,3)
Description . . . . . . . . . . . . . . Description . . . . . . . . . String (15,30)
MAS90 Data File Name. . . . . . . . . . MAS90DataFileName . . . . . . Uppercase (45,3)
File Type . . . . . . . . . . . . . . . FileType. . . . . . . . . . . Uppercase (48,1)
S=Standard. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
H=Header File Linked To Line File . . . . . . . . . . . . . . . . . Memo
Line Detail File Name . . . . . . . . . LineDetailFileName. . . . . . Uppercase (49,3)
Line Detail File Link Field . . . . . . LineDetailFileLinkField . . . Zero-Filled (52,2)
(The Above Two Fields Are . . . . . . . . . . . . . . . . . . . . . Memo
Valid Only If File Type="H"). . . . . . . . . . . . . . . . . . . . Memo
Multiple Record Types . . . . . . . . . MultipleRecordTypes . . . . . Yes/No (54,1)
R/M Compiled File Offset Byte . . . . . RMCompiledFileOffsetByte. . . Zero-Filled (55,5)
R/M Compiled File Length In Bytes . . . RMCompiledFileLengthInBytes . Zero-Filled (60,5)
D/I Compiled File Offset Byte . . . . . DICompiledFileOffsetByte. . . Zero-Filled (65,5)
D/I Compiled File Length In Bytes . . . DICompiledFileLengthInBytes . Zero-Filled (70,5)
DI & RM Validation String Files:. . . . . . . . . . . . . . . . . . Memo
DI0aaD.SOA, aa=Application Code . . . . . . . . . . . . . . . . . . Memo
RM0aaD.SOA, aa=Application Code . . . . . . . . . . . . . . . . . . Memo
Extended Part Of Data File Name . . . . ExtendedPartOfDataFileName. . String (75,2)
Extended Part Of Line File Name . . . . ExtendedPartOfLineFileName. . String (77,2)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (79,48)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: B Data Items Heading Information (DD1$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . . . . . . . . . . . . . . . . Uppercase *(1,10)
"B" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Sequence Number ("001" Thru "099"). . . SequenceNumber. . . . . . . . Zero-Filled *(12,3)
Data Item Name. . . . . . . . . . . . . DataItemName. . . . . . . . . Uppercase (15,15)
Data Item Type. . . . . . . . . . . . . DataItemType. . . . . . . . . Uppercase (30,1)
S=Standard. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
H=Header Item . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
L=Line Item . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
C=Calculated. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Must have 'C' Record. . . . . . . . . . . . . . . . . . . . . . Memo
X=X-Reference File. . . . . . . . . . . . . . . . . . . . . . . . . Memo
Must have 'X' Record. . . . . . . . . . . . . . . . . . . . . . Memo
Data Type . . . . . . . . . . . . . . . DataType. . . . . . . . . . . Uppercase (31,1)
A=Account Number. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
D=Date. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
N=Numeric . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
P=Phone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
S=String. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
X=String-Numeric. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Y=Yes/No. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Z=Zero-Filled . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Part Of The Key . . . . . . . . . . . . PartOfTheKey. . . . . . . . . Yes/No (32,1)
Start Position or Index . . . . . . . . StartPositionOrIndex. . . . . Zero-Filled (33,3)
Starting Position in String or . . . . . . . . . . . . . . . . . . Memo
Numeric Array Index or . . . . . . . . . . . . . . . . . . . . . . Memo
Index to 'C' or 'X' Record. . . . . . . . . . . . . . . . . . . . . Memo
Field Length or Mask (xxy). . . . . . . FieldLengthOrMask . . . . . . Zero-Filled (36,3)
xx = Digits Left Of Decimal . . . . . . . . . . . . . . . . . . . . Memo
y = Digits Right Of Decimal . . . . . . . . . . . . . . . . . . . . Memo
Group Code ("0" Thru "Z") . . . . . . . GroupCode . . . . . . . . . . Uppercase (39,1)
Column Title. . . . . . . . . . . . . . ColumnTitle . . . . . . . . . String (40,35)
Applications Used With. . . . . . . . . ApplicationsUsedWith. . . . . Uppercase (75,1)
Report Master . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
D=Data Import . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
B=Both. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Index To Related Records. . . . . . . . IndexToRelatedRecords . . . . String (76,3)
Blank or Index to . . . . . . . . . . . . . . . . . . . . . . . . . Memo
V/W/X/Z Records . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (79,48)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: C Calculation Info / Report Master (DD3$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"C" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Index From Record 'B' (76,3) . . . . . IndexFromRecordB. . . . . . . Zero-Filled *(12,3)
Calculation Formula . . . . . . . . . . CalculationFormula. . . . . . String (15,60)
This record is created when a . . . . . . . . . . . . . . . . . . . Memo
"C" Type 'B' record is specified. . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (75,52)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: D Record Type Information (DD8$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"D" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Record Type (1-9, A-Z). . . . . . . . . RecordType. . . . . . . . . . Uppercase *(12,1)
Sequence Number "00" . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(13,2)
Description . . . . . . . . . . . . . . Description . . . . . . . . . String (15,20)
Group Codes (Up to 10). . . . . . . . . GroupCodes. . . . . . . . . . Uppercase (35,10)
Value Assignment. . . . . . . . . . . . ValueAssignment . . . . . . . String (45,30)
Assigns Record Type to proper field . . . . . . . . . . . . . . . . Memo
Use Variable name, not Data Item name . . . . . . . . . . . . . . . Memo
Is Record Type For Header Record. . . . IsRecordTypeForHeaderRecord . Yes/No (75,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (76,51)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: E Record Group Information (DD4$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"E" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Group Code (0-9,A-Z). . . . . . . . . . GroupCode . . . . . . . . . . String *(12,1)
Sequence Number ("00" ) . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(13,2)
Description . . . . . . . . . . . . . . Description . . . . . . . . . String (15,20)
Condition Expression. . . . . . . . . . ConditionExpression . . . . . String (35,70)
Use Data Item names, not Variable name. . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (105,22)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: F File Linkage Information (DD5$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
This record is obsolete with 4.0. . . . . . . . . . . . . . . . . . Memo
See SY_ExportLink.xxx . . . . . . . . . . . . . . . . . . . . . . . Memo
"F" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Linked File Seq Number (000-899). . . . LinkedFileSeqNumber . . . . . Zero-Filled *(12,3)
Linked File Name (AA.XXXXXXX) . . . . . LinkedFileName. . . . . . . . Uppercase (15,10)
Key Expression. . . . . . . . . . . . . KeyExpression . . . . . . . . String (25,54)
Use Data Item names, not Variable . . . . . . . . . . . . . . . . . Memo
names. All Data Item Names needed . . . . . . . . . . . . . . . . . Memo
to form the key expression to the . . . . . . . . . . . . . . . . . Memo
linked file must exist in the main fil. . . . . . . . . . . . . . . Memo
900+ sequence numbers are for . . . . . . . . . . . . . . . . . . . Memo
User Defined link files.. . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (79,48)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: R Run Time Fields Record 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"R" (R/M) or "r" (D/I). . . . . . . . SY0DCTRecordType. . . . . . . String *(11,1)
Sequence Number (000-999) . . . . . . . SequenceNumber. . . . . . . . Zero-Filled *(12,3)
Data Item Name. . . . . . . . . . . . . DataItemName. . . . . . . . . Uppercase (15,15)
Data Item Type. . . . . . . . . . . . . DataItemType. . . . . . . . . Uppercase (30,1)
S=Standard. . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Data Type . . . . . . . . . . . . . . . DataType. . . . . . . . . . . Uppercase (31,1)
D=Date, N=Numeric, S=String . . . . . . . . . . . . . . . . . . . Memo
Part of The Key . . . . . . . . . . . . PartofTheKey. . . . . . . . . Yes/No (32,1)
Start Position or Index . . . . . . . . StartPositionOrIndex. . . . . Zero-Filled (33,3)
Field Length or Mask. . . . . . . . . . FieldLengthOrMask . . . . . . Zero-Filled (36,3)
See 'B' Record. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (39,88)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: V Data Validation (Import Only) (DD6$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"V" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Index From Record 'B' (76,3). . . . . . IndexFromRecordB. . . . . . . Zero-Filled *(12,3)
Data Item Name. . . . . . . . . . . . . DataItemName. . . . . . . . . Uppercase (15,15)
Validation Type . . . . . . . . . . . . ValidationType. . . . . . . . String (30,1)
F=File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
S=String. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
N=None. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
U=Uppercase String. . . . . . . . . . . . . . . . . . . . . . . . . Memo
E=Expression. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
X=neXt (key is incr. using Next). . . . . . . . . . . . . . . . . . Memo
Skip Validation On Blank Field. . . . . SkipValidationOnBlankField. . Yes/No (31,1)
Validation File Name. . . . . . . . . . ValidationFileName. . . . . . Uppercase (32,10)
AA.XXXXXXX or Table Name. . . . . . . . . . . . . . . . . . . . . . Memo
Concatenated with (79,20) . . . . . . . . . . . . . . . . . . . . . Memo
Blank If String Verified. . . . . . . . . . . . . . . . . . . . . . Memo
Starting Position . . . . . . . . . . . StartingPosition. . . . . . . Zero-Filled (42,3)
Field Length. . . . . . . . . . . . . . FieldLength . . . . . . . . . Zero-Filled (45,3)
File Type (S,H,L) . . . . . . . . . . . FileType. . . . . . . . . . . Uppercase (48,1)
Validation Expression . . . . . . . . . ValidationExpression. . . . . String (49,30)
The 2nd 30 bytes of this expression . . . . . . . . . . . . . . . . Memo
is in the 'W' record. 'V' and 'W'. . . . . . . . . . . . . . . . . Memo
records must exist as pairs.. . . . . . . . . . . . . . . . . . . . Memo
Z record must exist if Val. Type=X. . . . . . . . . . . . . . . . . Memo
Validation File Name Extension. . . . . ValidationFileNameExten . . . Uppercase (79,20)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (99,28)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: W Default Value Record Used By D/I (DD9$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"W" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Index From Record 'B' (76,3) . . . . . IndexFromRecordB. . . . . . . Zero-Filled *(12,3)
Default Value . . . . . . . . . . . . . DefaultValue. . . . . . . . . String (15,30)
This Record Is Used By Data Import. . . . . . . . . . . . . . . . . Memo
To Hold The Default Value To Be . . . . . . . . . . . . . . . . . . Memo
Be Used During Import.. . . . . . . . . . . . . . . . . . . . . . . Memo
One Record Per Field Being Importd. . . . . . . . . . . . . . . . . Memo
If Field Type Is Date Then This . . . . . . . . . . . . . . . . . . Memo
Field Is 6 Chars Containing Compact . . . . . . . . . . . . . . . . Memo
Date, If Numeric Then String Value. . . . . . . . . . . . . . . . . Memo
Of Number Is Contained Otherwise It . . . . . . . . . . . . . . . . Memo
Contains A String Of Field Length . . . . . . . . . . . . . . . . . Memo
Up to A Max Of 30 Chars.. . . . . . . . . . . . . . . . . . . . . . Memo
Validation/Key Expression . . . . . . . ValidationKeyExpression . . . String (45,30)
This Is The Second Half Of This . . . . . . . . . . . . . . . . . . Memo
String The First 30 Chars Are Found . . . . . . . . . . . . . . . . Memo
In The "V" Record.. . . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (75,52)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: X X-Ref File Info (DD2$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"X" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Index From Record 'B' (76,3) . . . . . IndexFromRecordB. . . . . . . Zero-Filled *(12,3)
X-Ref File Name . . . . . . . . . . . . XRefFileName. . . . . . . . . Uppercase (15,10)
AA.XXXXXXX or Table Name. . . . . . . . . . . . . . . . . . . . . . Memo
Concatenated with (49,20) . . . . . . . . . . . . . . . . . . . . . Memo
X-Ref Data Item Name. . . . . . . . . . XRefDataItemName. . . . . . . Uppercase (25,20)
or Column Name. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Concatenated with (69,10) . . . . . . . . . . . . . . . . . . . . . Memo
Data Type . . . . . . . . . . . . . . . DataType. . . . . . . . . . . Uppercase (45,1)
See 'B' Record Data Types . . . . . . . . . . . . . . . . . . . . . Memo
Field Length or Mask (xxy). . . . . . . FieldLengthOrMask . . . . . . Zero-Filled (46,3)
xx = Digits Left Of Decimal . . . . . . . . . . . . . . . . . . . . Memo
y = Digits Right Of Decimal . . . . . . . . . . . . . . . . . . . Memo
X-Ref Table Name Extension. . . . . . . XRefTableNameExt. . . . . . . String (49,20)
X-Ref Column Name Extension . . . . . . XRefColumnNameExt . . . . . . String (69,10)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (79,48)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: Y Next Ind No For Data Import Recrd (DD7$) 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"Y" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Sequence Number "000" . . . . . . . . . NextAvailableIndex. . . . . . Zero-Filled *(12,3)
Next Available Index For V Record . . . NextAvailableIndex. . . . . . Zero-Filled (15,3)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (18,109)
________
Total Bytes 128
SY0DCT Data Dictionary (SY0DCT_DataDictionary) Level: 4.40
Record Type: Z Record For Next Operation DDA$ 08/28/2009
File Type: Direct Key Size: 14 Rec Len: 128 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
File Name (AA.XXXXXXX) . . . . . . . . FileName. . . . . . . . . . . Uppercase *(1,10)
"Z" . . . . . . . . . . . . . . . . . . SY0DCTRecordType. . . . . . . Uppercase *(11,1)
Index From Record 'B' . . . . . . . . . IndexFromRecordB. . . . . . . Zero-Filled *(12,3)
File Name To Get Next From. . . . . . . FileNameToGetNextFrom . . . . String (15,5)
Key To File . . . . . . . . . . . . . . KeyToFile . . . . . . . . . . String (20,30)
Start Position Of 'Next' Field. . . . . StartPositionOfNextField. . . String (50,4)
Length Of 'Next' Field. . . . . . . . . LengthOfNextField . . . . . . String (54,3)
Data Item Name. . . . . . . . . . . . . DataItemName. . . . . . . . . Uppercase (57,15)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (72,55)
________
Total Bytes 128