Column Headings
If the generateOneRowPerAttribute attribute on the CostModelWatchPoints element is set to “true”, each worksheet into which data is output contains the following columns. (If set to “false”, then columns for each value that would have appeared under the “formula” column are added to the spreadsheet.)
• bomLineNumber -- This is a number starting from 1 (from 2 in the case of rollups) that is unique to each part/assembly for which rows are generated.
• bomDepth -- begining with "1" this number is incremented by one for each level in an assembly/rollup. Thus, immediate children of a top-level assembly will be at level 2, their children will be at 3 and so on.
• Part Number -- Self-explanatory.
• Cad File Name -- Self-explanatory.
• Scenario -- Default is “initial”.
• ScenarioType -- Rollup, part, or assembly. Note: Since aPriori doesn't generate any data for rollups other than the parts and/or assemblies that they contain, "rollup" never actually appears.
• ScenarioFullName – When generateStandardColumns=”true”, output format is “partNumber.scenarioName”. If generateStandardColumns=”false”, the line
“<Formula Heading="ScenarioFullName">displayName</Formula>” returns “partNumber.scenarioName” for virtual parts, and the Node value of process group/routing (e.g., ”Sheet Metal/Machining”) for a costed CAD part. Consider using “<Formula>componentName</Formula>” instead.
• VPE -- This is blank if the row represents a gcd attribute value.
• ProcessGroup -- This is blank if the row represents a gcd attribute value.
• Process -- The process or operation name from which the cost output has been generated. This is null if the row represents a gcd attribute/value
• Level -- One of "component", "process" or "operation".
• Leaf -- Boolean value. Set to true if the process/operation is a leaf node in a template.
• HasChildren -- Boolean value. Set to true if the process/operation has child operations for which data has been output in this report. Note that this is a value that is computed while the report is being generated, not from the process model. Use this if your output includes, for instance, both "3 Axis Mill" and "Milling" and you want to create a pivot that picks up just "milling" or just "3 Axis Mill".
• Node -- The name of the Node represented by this row in the report (blank for gcds).
• GcdType -- The type of the gcd represented in this row. This could be either the gcd type for the operation from which we're grabbing an output or the type of the gcd who's attribute we're printing out.
• Gcd -- The name of the actual gcd
• Gcd Display Name -- Self-explanatory.
• CostView -- The costview from which this report was generated ("current", "last saved", "previous"). Will generally be "current".
• Tag -- The value of the tag generated for this row (see below in the xml language spec).
• formula -- The name of the formula (or gcd attribute) represented by this row. (not present if generateOneRowPerAttribute is set to false)
• Value -- The value represented by the row. (not present if generateOneRowPerAttribute is set to false)
Again, if the generateOneRowPerAttribute attribute on the CostModelWatchPoints element is set to false, then the formula and Value columns are replaced by a single row for each node or GCD, containing columns for each specified attribute.