Skip to main content

SF_NodeTemplate

The table below provides pertinent information regarding the columns in the SF_NodeTemplate table.

SF_NodeTemplate Table Columns

ColumnType
CaseID (PK, FK)Nvarchar(40), not null
ID (PK)Nvarchar(40), not null
NameNvarchar(128), null
DescriptionNvarchar(128), null
CategoriesNvarchar(128), null
LayersNvarchar(128), null
ToUNITNvarchar(252), null
ReconciledVolumeVarianceFloat, null
ReconciledVolumeTest4Float, null
ReconciledVolumeTest3Float, null
ReconciledVolumeImbalanceFloat, null
ReconciledResidualFloat, null
ReconciledMassVarianceFloat, null
ReconciledMassTest4Float, null
ReconciledMassTest3Float, null
ReconciledMassImbalanceFloat, null
ReconciledEnergyVarianceFloat, null
ReconciledEnergyTest4Float, null
ReconciledEnergyTest3Float, null
ReconciledEnergyImbalanceFloat, null
ReconciledComponentResultsSql_variant, null
ObjectStatusNvarchar(252), null
MaterialNvarchar(252), null
InequalityBalanceFlagBit, null
HoldupProductNvarchar(252), null
HoldupDensityFloat, null
HoldupFloat, null
EnergyBalanceFlagBit, null
EfficiencyFloat, null
DensityBalanceFlagBit, null
CostCenterSql_variant, null
ConstrainedComponentBalanceFlagBit, null
CompositionTrackingBalanceFlagBit, null
ComponentBalanceFlagBit, null