SF_TransferTemplate

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

SF_TransferTemplate Table Columns

Column	Type
CaseID (PK, FK)	Nvarchar(40), not null
ID (PK)	Nvarchar(40), not null
Name	Nvarchar(128), null
Description	Nvarchar(128), null
Categories	Nvarchar(128), null
Layers	Nvarchar(128), null
Source	Nvarchar(128), null
Destination	Nvarchar(128),null
StartTime	Datetime, not null
StartTimeUTC	Datetime, not null
EndTime	Datetime, not null
EndTimeUTC	Datetime, not null
ConnectionType	Varchar(40), null
VolumeTolerance	Float, null
ValidityIndex	Float, null
UserComments	Nvarchar(252), null
User	Nvarchar(252), null
Type	Nvarchar(252), null
TransportMode	Nvarchar(252), null
TransferNameInfo	Nvarchar(252), null
TransferCalculationFlag	Bit, null
TransferCalculatedResults	Nvarchar(252), null
Temperature	Float, null
Status	Nvarchar(252), null
StartingWaterGauge	Float, null
StartingTemperature	Float, null
StartingPressure	Float, null
StartingPercentBsw	Float, null
StartingNetVolume	Float, null
StartingMolecularWeight	Float, null
StartingGrossVolume	Float, null
StartingGauge	Float, null
StartingDensity	Float, null
StartBlending	Datetime, null
SigmafineBalanceMinimum	Float, null
SigmafineBalanceMaximum	Float, null
ShipNumber	Nvarchar(252), null
SelfCalculatingFlag	Bit, null
RoutingTagList	Nvarchar(252), null
RfgBatchNumber	Nvarchar(252), null
ReconciledWeight	Float, null
ReconciledVolumeTolerance	Float, null
ReconciledVolumeTest2	Float, null
ReconciledVolumeTest1	Float, null
ReconciledVolumeSolvability	Nvarchar(252), null
ReconciledVolume	Float, null
ReconciledSolidComponentResults	Sql_variant, null
ReconciledOrganicLiquidComponentResults	Sql_variant, null
ReconciledMassTolerance	Float, null
ReconciledMassTest2	Float, null
ReconciledMassTest1	Float, null
ReconciledMassSolvability	Nvarchar(252), null
ReconciledMass	Float, null
ReconciledInfluence	Float, null
ReconciledGasComponentResults	Sql_variant, null
ReconciledComponentResults	Sql_variant, null
ReconciledAqueousLiquidComponentResults	Sql_variant, null
QuantityValidatedFlag	Bit, null
QuantitySource	Nvarchar(252), null
QAValidatedFlag	Bit, null
ProductCode	Nvarchar(252), null
Pressure	Float null
PlannedVolume	Float, null
PlannedStartTime	Datetime, null
PlannedQuantity	Float, null
PlannedMass	Float, null
PlannedEndTime	Datetime, null
PlannedDensity	Float, null
Path	Nvarchar(252), null
ParentID	Nvarchar(252), null
Owner	Nvarchar(252), null
OriginDestination	Nvarchar(252), null
ObjectStatus	Nvarchar(252), null
NumberCaseTotal	Smallint, null
NumberCaseGood	Smallint, null
NominationID	Nvarchar(252), null
NetWeight	Float, null
NetVolume	Float, null
Movement_TypeID	Smallint, null
Movement_TypeDescr	Nvarchar(252), null
Movement_Type	Nvarchar(252), null
Movement_Fiscal	Bit, null
MolecularWeight	Float, null
MeasuredMass	Float, null
MaterialGroup	Nvarchar(252), null
MaterialDescription	Nvarchar(252), null
Material	Nvarchar(252), null
ManualAdjustmentFlag	Bit, null
LastModify	Nvarchar(252)
InterfaceQuantity	Float, null
InitialStartDate	Datetime, null
InitialSource	Nvarchar(252)
InferredStatus	Nvarchar(252), null
InferredStatus	Nvarchar(25Float, null2), null
GrossVolume	Float, null
FtzFlag	Bit, null
FinalEndDate	Datetime, null
FinalDest	Nvarchar(252), null
EstimatedRate	Float, null
EndingWaterGauge	Float, null
EndingTemperature	Float, null
EndingPressure	Float, nFloat, nullull
Density	Float, null
Comment	Nvarchar(252), null
EndingPercentBsw	Float, null
EndingNetVolume	Float, null
EndingMolecularWeight	Float, null
EndingGrossVolume	Float, null
EndingGauge	Float, null
EndingDensity	Float, null
EndBlending	Datetime, null
ElementQuantityName	Nvarchar(252), null
ElementQuantity	Float, null
DutyPeriod	Datetime, null
DutyDate	Datetime, null
Density	Float, null
Customer	Nvarchar(252), null
CorrectedWeight	Float, null
CorrectedVolumeTolerance	Float, null
CorrectedVolume	Float, null
CorrectedMassTolerance	Float, null
CorrectedMass	Float, null
ConstraintFlag	Nvarchar(252), null
CompositionTrackingResults	Sql_variant, null
CompositionInputPercentages	Sql_variant, null
Comment	Nvarchar(252), null
ClosingTimeStamp	Datetime, null
Carrier	Nvarchar(252), null
CalculationObject	Nvarchar(252), null
CalculatedQuantity	Float, null
BlendingID	Nvarchar(252), null
BlendedMaterial	Nvarchar(252), null
AssociatedAnalyzer	Nvarchar(252), null
ActivationTimeStamp	Datetime, null