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