MaterialInputChange
- Last UpdatedNov 03, 2021
- 1 minute read
The MaterialInputChange table contains a record for every quantity change made by an operator for a material consumed in a batch. Batch Manager controls the data in this table.
|
Field |
Allow Null |
Type |
Length |
|---|---|---|---|
|
Batch_Log_ID |
No |
char |
10 |
|
Batch_Server_Name |
No |
varchar |
20 |
|
CheckBy_User_ID |
No |
nvarchar |
64 |
|
DateTime |
No |
datetime |
8 |
|
DoneBy_User_ID |
No |
nvarchar |
64 |
|
Material_ID |
No |
varchar |
16 |
|
Material_Parameter |
No |
varchar |
16 |
|
New_Target_Qty |
No |
float |
8 |
|
Old_Target_Qty |
No |
float |
8 |
|
Operation_ID |
No |
varchar |
16 |
|
Phase_ID |
No |
nvarchar |
16 |
|
Phase_Instance_ID |
varchar |
16 |
|
|
Phase_Label |
No |
nvarchar |
8 |
|
UnitOrConnection |
No |
varchar |
16 |
|
UnitProcedure_ID |
No |
varchar |
16 |
|
DateTimeUTC |
Yes |
datetime |
8 |
|
AuthSession_ID |
Yes |
char |
10 |
|
HighDeviationValue |
No |
float |
8 |
|
LowDeviationValue |
No |
float |
8 |