BOM

(NUMBER) = returns a number .
(STRING) = returns a string of characters.
(DIM_NUM) = returns a dimension expressed as a decimal number .
(DIM) = returns a dimension expressed using fractions and hyphens.
(DATE) = returns a date .
(ANGLE) = returns a decimal number in radians.

Field names in this database are hard coded. However, your reports will still work if you choose to use field names for which there are aliases in the dictionary_aliases.txt files that are stored in the reports and reports/SDS2 folders in the data directory for the current version of the SDS2 program you are running. Do not alter the file in reports/SDS2 folder -- that file is maintained to preserve backwards compatibility with previous versions of the Report Writer databases. If you want to add your own aliases for field names, you should do so by making changes to the dictionary_aliases.txt file in the reports folder. The format of these files is your_new_name = current_database_name . You may enter either a name segment ( c = C ) or a full path ( a.b.c = A.B.C ) to either side of the equal sign. For example, you could enter a name segment to subtitute for a full path ( c = A.B.C ).

BillOfMaterial.

|- BOMIndex (NUMBER)

|- Piecemark (STRING)

|- MinorMark (STRING)

|- Description (STRING)

|- UnitQuantity (NUMBER)

|- TotalQuantity (NUMBER)

|- Length (DIM_NUM)

|- LengthDimension (DIM)

|- UnitWeight (WEIGHT)

|- TotalWeight (WEIGHT)

|- SequenceIndex (NUMBER)

|- Sequence (STRING)

|- ZoneIndex (NUMBER)

|- Zone (STRING)

|- SequenceQuantity (NUMBER)

|- SequenceABMNumber (STRING)

|- Grade (STRING)

|- ABMNumber (STRING)

|- Remarks (STRING)

|- MultCuttingNumber (STRING)

|- LaborCode (STRING)

|- JobCostCode (STRING)

|- BOMMaterialTypeSortValue (STRING)

BillOfMaterial.MaterialFile.

|- |- Index (SHORT)

|- |- SectionSize (SECTIONSIZE)

|- |- MaterialTypeIndex (NUMBER)

|- |- MaterialType (STRING)

|- |- MaterialTypeSortValue (STRING)

|- |- JoistType (BYTE)

|- |- JoistTypeDescription (STRING)

|- |- Depth (DIM_NUM)

|- |- DepthDimension (DIM)

|- |- FlangeWidth (DIM_NUM)

|- |- FlangeWidthDimension (DIM)

|- |- FlangeThickness (DIM_NUM)

|- |- FlangeThicknessDimension (DIM)

|- |- WebThickness (DIM_NUM)

|- |- WebThicknessDimension (DIM)

|- |- kDistanceDetail (DIM_NUM)

|- |- kDistanceDetailDimension (DIM)

|- |- kDistanceDesign (DIM_NUM)

|- |- kDistanceDesignDimension (DIM)

|- |- WeightPerFoot (WEIGHT)

|- |- NominalDepth (DIM_NUM)

|- |- NominalDepthDimension (DIM)

|- |- FlangeGauge (DIM_NUM)

|- |- FlangeGaugeDimension (DIM)

|- |- LongLegGauge1 (DIM_NUM)

|- |- LongLegGauge1Dimension (DIM)

|- |- LongLegGauge2 (DIM_NUM)

|- |- LongLegGauge2Dimension (DIM)

|- |- LongLegGauge3 (DIM_NUM)

|- |- LongLegGauge3Dimension (DIM)

|- |- ShortLegGauge1 (DIM_NUM)

|- |- ShortLegGauge1Dimension (DIM)

|- |- ShortLegGauge2 (DIM_NUM)

|- |- ShortLegGauge2Dimension (DIM)

|- |- ShortLegGauge3 (DIM_NUM)

|- |- ShortLegGauge3Dimension (DIM)

|- |- MomentofInertiaXAxis (DIM_NUM)

|- |- MomentofInertiaXAxisDimension (DIM)

|- |- MinimumBearing (DIM_NUM)

|- |- MinimumBearingDimension (DIM)

|- |- SecondarySectionSize (SECTIONSIZE)

|- |- Reference (STRING)

|- |- SourceReference (STRING)

BillOfMaterial.

|- MainMaterial (BOOL)

|- ConnectionGeneratedByThisMemberNumber (USHORT)

|- ConnectionGeneratedByThisPiecemark (STRING)

|- MemberConnectionEnd (UINT)

DetailSheet.

|- DetailSheetIndex (NUMBER)

|- DetailSheetName (STRING)

|- DrawingType (NUMBER)

|- DrawingTypeDescription (NUMBER)

|- DrawingSheetIndex (NUMBER)

|- DrawingFileName (STRING)

|- DetailType (NUMBER)

|- DetailTypeDescription (STRING)

|- RevisionLevel (BYTE)

DetailSheet.Revision.

|- |- ManualRevision (STRING)

|- |- RevisionDescription (STRING)

|- |- RevisionDate (DATE)

|- |- User1 (STRING)

|- |- User2 (STRING)

|- |- User3 (STRING)

|- |- User4 (STRING)

|- |- Locked (BOOL)

|- ApprovalStatusIndex (NUMBER)

|- ApprovalStatus (STRING)

|- Quantity (NUMBER)

|- MemberIndex (NUMBER)

|- MaterialIndex (NUMBER)

|- LastShowWindowDefinition0 (DIM_NUM)

|- LastShowWindowDefinition0Dimension (DIM)

|- LastShowWindowDefinition1 (DIM_NUM)

|- LastShowWindowDefinition1Dimension (DIM)

|- LastShowWindowDefinition2 (DIM_NUM)

|- LastShowWindowDefinition2Dimension (DIM)

|- LastShowWindowDefinition3 (DIM_NUM)

|- LastShowWindowDefinition3Dimension (DIM)

|- DrawingReferencePointX (DIM_NUM)

|- DrawingReferencePointXDimension (DIM)

|- DrawingReferencePointY (DIM_NUM)

|- DrawingReferencePointYDimension (DIM)

|- ViewUpperCornerReferencePointX0 (DIM_NUM)

|- ViewUpperCornerReferencePointX0Dimension (DIM)

|- ViewUpperCornerReferencePointY0 (DIM_NUM)

|- ViewUpperCornerReferencePointY0Dimension (DIM)

|- ViewUpperCornerReferencePointX1 (DIM_NUM)

|- ViewUpperCornerReferencePointX1Dimension (DIM)

|- ViewUpperCornerReferencePointY1 (DIM_NUM)

|- ViewUpperCornerReferencePointY1Dimension (DIM)

|- ViewUpperCornerReferencePointX2 (DIM_NUM)

|- ViewUpperCornerReferencePointX2Dimension (DIM)

|- ViewUpperCornerReferencePointY2 (DIM_NUM)

|- ViewUpperCornerReferencePointY2Dimension (DIM)

|- ViewUpperCornerReferencePointX3 (DIM_NUM)

|- ViewUpperCornerReferencePointX3Dimension (DIM)

|- ViewUpperCornerReferencePointY3 (DIM_NUM)

|- ViewUpperCornerReferencePointY3Dimension (DIM)

|- DrawingScale (FLOAT)

|- DrawingScaleLength (DIM_NUM)

|- DrawingScaleLengthDimension (DIM)

|- MemberRotation (ANGLE)

|- ShortenPointLimitLine (DIM_NUM)

|- ShortenPointLimitLineDimension (DIM)

|- SheetIndex (NUMBER)

|- DrawingHash (NUMBER)

|- LatestRevisionDate (DATE)

|- PlottedDate (DATE)

|- SentForApprovalDate (DATE)

|- ReceivedApprovalDate (DATE)

|- ReleasedForFabricationDate (DATE)

|- FabricationCompletedDate (DATE)

|- ShippedDate (DATE)

|- ErectedDate (DATE)

|- DetailCompleteDate (DATE)

CurrentLocation.

|- Job (STRING)

CurrentLocation.JobCustomProperties.

|- |- Log (STRING)

|- |- Notes (STRING)

|- Fabricator (STRING)

|- FabricatorIsMetric (STRING)

|- PrimaryDimensionUnits (STRING)

|- CurrentMaterialFile (STRING)

|- LocalMaterialFile (STRING)