Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Here are the components required to create a new bagged item in the DOR.

Type IL Bag (92.6) Sold

Type IL Bag (92.6) Produced

Type IL # Bags Consumed

Type IL Cement Consumed for TIL Bag

Type IL # (Empty) Bags ADJ

Type IL Bag Inventory

Type IL Bag Inv (Bags)

INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (759, N'                                                  ', null, N'float     ', N'Amerimix AMX145 Type IL Bag (94) Sold', 2, null, N'DSN=Daily_Reports_IP21', 13, 2, 1, 0, 0, 0, 1, 1, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, N'2023-04-21 00:00:00.000', 60, N'0', 0, 2, 18, 6, 33, null, null, 2, null, 3, N'Bags        ', 0, 300, 0, 1, 1, N'00:30', 1, 1, N'p759 * 94 * 0.907185 / 2000', N'MTons       ', 1, 17, 0, -1, -1, -1, -1, -1, -1, 1209, 0, null, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (760, N'                                                  ', null, N'int       ', N'Amerimix AMX145 Type IL Bag (94) Produced', 2, null, N'DSN=Daily_Reports_IP21', 13, 2, 1, 0, 0, 0, 1, 1, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, N'2023-04-21 00:00:00.000', 60, N'0', 0, 2, 17, 20, 9, null, null, 2, null, -1, N'Bags        ', 0, 300, 0, 1, 1, N'00:30', 1, 1, N'p760 * 94 * 0.907185 / 2000', N'MTons       ', 1, 17, 1, 55, 8, 68, 3, -1, 2, 1131, 1, -2, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (761, N' ', N'=p760 + p763', N'float     ', N'Amerimix AMX145 Type IL # Bags Consumed', 1, null, N'N/A', 1, 1, 1, 0, 0, 0, 1, 0, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, null, 300, null, 0, 1, 18, 25, 4, null, null, 2, null, 1, N'Bags        ', 0, 300, 0, 0, 1, N'00:30', 0, 1, N'p761', N'Bags        ', 0, 17, 1, 55, 8, 67, 2, -1, -1, 1132, 0, -1, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (762, N'                                                  ', N'=c710', N'float     ', N'Amerimix AMX145 Type IL Cement Consumed for TIL Bag', 1, null, N'N/A', 1, 1, 1, 0, 0, 0, 1, 0, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, null, 300, null, 0, -1, -1, -1, -1, null, null, 2, null, 1, N'mtons       ', 0, 300, 0, 0, 1, N'00:30', 0, 1, N'p762', N'mtons       ', 0, 17, 1, 55, 8, 58, 2, 2, -1, 1133, 0, -2, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (763, N' ', null, N'int       ', N'Amerimix AMX145 Type IL # (Empty) Bags ADJ', -1, null, N'N/A', 13, 1, 1, 0, 0, 0, 1, 0, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, N'2020-07-31 00:00:00.000', 300, N'-1413', 0, 2, 18, 47, -1, null, 1, 0, null, 1, N'Bags        ', 0, 300, 0, 0, 1, null, 0, 1, N'p763', N'Bags        ', 1, 18, 0, -1, -1, -1, -1, -1, -1, 1132, 0, -1, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (764, N'', N'=c760 - c759 + q764', N'float     ', N'Amerimix AMX145 Type IL Bag Inventory', -1, null, N'DSN=Daily_Reports_IP21', 13, 2, 1, 0, 0, 0, 0, 0, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, N'2014-04-01 00:00:00.000', 300, N'328.305644188', 0, 1, 19, 230, 28, 1, 1, 2, -1, 1, N'            ', 0, 300, 0, 0, 1, N'00:30', 0, 1, N'p764', N'mtons       ', 0, 85, 0, -1, -1, -1, -1, -1, -1, 1254, 0, null, 1);
INSERT INTO [PDATA-US-PFHRL].dbo.tblPLC_PLCid (PLCid, PLC_Tagname, PLC_SubTagName, ValueType, PLC_Description, SummaryType, SummaryTypeSecondaryTag, PLC_Address, PLC_Communication_Type, PLC_Communication_Specs, DisplayItNow, TrackData, TrackNoChangedData, TrackIPisAlive, ActiveValue, UseActiveValue, UseHighLow, HighVal, LowVal, UseHighHighLowLow, HighHighVal, LowLowVal, UseStdDev, StdDevValue, StdDevIncrement, AlertNotActive, AlertExceedHighLow, AlertExceedHighHighLowLow, AlertExceedStdDev, AlertIPisAlive, UseSplit, SplitDelimeter, SplitUsableValue, LastDT, PLC_PullInterval, LastValue, PLC_IsForAliveOnly, GroupID, SecondaryGroupID, GroupDisplayRank, SecondaryGroupDisplayRank, SubGroupID, LabelPositionDisplay, DisplayDecimalPoints, ReportGroupID, ReportColumn, UnitMeasurements, MSDMonitorOnly, AliveOnly_TimeDelay, AliveEmailSent, DoNotIncludeIn6AMForce, TrackDataOnceDaily, TrackDataOnceDailyTime, IsManualEntryOnly, DisplayIsFormulated, DisplayFormula, DisplayFormulaUnits, AllowAdjustment, AdminToEditId, SAPIncludeInExport, SAPMaterialToProduce, SAPResource, SAPMaterial, SAPTypeOfMovement, SAPBatch, SAPUnitOfMeasure, SortOrder, SAPExportHours, SAPHoursPLCid, ShiftGroupID) VALUES (765, N' ', N'=p760 - p759 + q765', N'float     ', N'Amerimix AMX145 Type IL Bag Inv (Bags)', -1, null, N'DSN=Daily_Reports_IP21', 1, 1, 1, 0, 0, 0, 0, 0, 0, null, null, 0, null, null, 0, null, null, 0, 0, 0, 0, 0, 0, null, null, N'2014-04-01 00:00:00.000', 300, N'7700', 0, 1, -1, 279, -1, -1, 1, 2, -1, 1, N'Bags        ', 0, 300, 0, 0, 1, N'00:30', 0, 1, N'p765', N'Bags        ', 0, 85, 0, -1, -1, -1, -1, -1, -1, 1269, 0, null, 1);
  • No labels