SF_Material Table
The SF_Material table does not have a specific structure. Most likely, the two columns 'Material' and 'VCFType' will be common to all Material Tables in different Databases.
The table below provides pertinent information regarding the several of the columns that could be included in the SF_Material table.
SF_Material Table Columns
| Column | Type |
|---|---|
| Material | Nvarchar(252), null |
| MaterialDescription | Nvarchar(252), null |
| MaterialGroup | Nvarchar(252), null |
| GroupDescription | Nvarchar(252), null |
| MaterialCost | Float, null |
| MaterialDensity | Float, null |
| VCFType | Int, null |
| SpecialMaterial | Smallinit, null |
| FromPlant | Nvarchar(252), null |
| MaterialFamily | Nvarchar(252), null |
| MaterialCategory | Nvarchar(252), null |
| MaterialOrder | Int, null |
| PhysicalState | Nvarchar(252), null |
| IsCharge | Nvarchar(252), null |
| SortingIndex | Int, null |
| TrackingGroup | Nvarchar(252), null |
| Density | Float, null |
| MolecularWeight | Float, null |