Material usage
These tables outline the different components of the report.
Datasets
Dataset | Stored Procedure | Comment |
|---|---|---|
GetMaterialID | spGetMaterialIDByDate | Gets the Material IDs used between two dates |
GetMaterialUsageData | spGetMaterialUsageData- ByDate | Gets the Material amounts used between two dates |
GetRecipeNames | spGetRecipeNamesBYDate | Gets the Recipes used between two dates |
GetUnitName | spGetUnitNameByDate | Gets the Units used between two dates |
GetProcessCell | spGetProcessCellByDate | Gets the Process Cells used between two dates |
Report Parameters
Parameter | Where used | Comment |
|---|---|---|
StartTime | All Procedures | Start Time |
EndTime | All Procedures | End Time |
SearchWord | NA | User Defined Batch Filter |
ProcessCell | NA | Process Cell Filter |
RecipeName | NA | Recipe Name Filter |
UnitName | NA | Unit Name Filter |
MaterialName | GetMaterialUsageData | Material Parameter |
Heading Data
Object | Data Item | Data Source | Type |
|---|---|---|---|
Start Time | StartTime | User input | Parameter |
End Time | EndTime | User input | Parameter |
Material Name | materialname | GetmaterialUsageData | Data |
Total Consumed | TotalUsed | GetmaterialUsageData | Data |
Table Datasets
Table | Dataset | Comment |
|---|---|---|
table1_ GetmaterialUsageData | GetmaterialUsage- Data | Material Usage |
Provide Feedback