File Name
Syntax
GenerateMovedEvent(VAL table: STRING, VAL oldID: STRING, VAL newID: STRING, VAL iid: INTEGER, VAL event_id: INTEGER, REF histBeforeList: LIST OF Inventory_HistoryRec, REF histAfterList: LIST OF Inventory_HistoryRec)
Parameters
table - table name
oldID - old ID depending on the table
newID - new ID depending on the table
iid - inventory ID
event_id - event ID
histBeforeList - old list of inventory history records
histAfterList - new list of inventory history records
Returns
histBeforeList, histAfterList, function result
Side Effects
None
Description
This function is used to create moved events.
Dialog Forms Called
None
File Name
Syntax
GenerateMovedEvent2(VAL table: STRING, VAL oldID: STRING, VAL newID: STRING, VAL iid: INTEGER, VAL event_id: INTEGER, REF histBeforeList: LIST OF Inventory_HistoryRec, REF histAfterList: LIST OF Inventory_HistoryRec)
Parameters
table - table name
oldID - old category ID
newID - new category ID
iid - is_inventory_id
event_id - event ID
histBeforeList - list of old inventory history records
histAfterList - list of new inventory history records
Returns
histBeforeList, histAfterList, list insert was successful or not
Side Effects
None
Description
This function inserts a new inventory history record in the list for a moved event.
Dialog Forms Called
None
File Name
Syntax
GetHist(REF lst: LIST OF Inventory_HistoryRec, VAL iid: INTEGER)
Parameters
lst - list of inventory history records
iid - inventory ID
Returns
lst, SQLSelect return result
Side Effects
None
Description
This function returns the list of inventory history records for a selected asset.
Dialog Forms Called
None
File Name
Syntax
GetInvHist(REF histList: LIST OF HistViewRec,VAL is_inventory_id: INTEGER)
Parameters
None
Returns
Integer for success or failure
Side Effects
None
Description
This function returns a list of inventory history records for the selected inventory ID.
Dialog Forms Called
None
File Name
Syntax
GetInvHistRec( VAL inv_hist_id: INTEGER, REF newinvrec: Inventory_HistoryRec)
Parameters
inv_hist_id - inventory history ID
newinvrec - new inventory history record
Returns
result of SQLSelectInto
Side Effects
None
Description
This function gets an inventory history record based on the inventory history ID.
Dialog Forms Called
None
File Name
Syntax
GetSomeInvHist(VAL where: STRING, REF lst: LIST OF HistViewRec)
Parameters
where - WHERE clause of select statement
lst - list of inventory history view records
Returns
lst, SQLSelectInto return result
Side Effects
None
Description
This function returns a list of inventory history view records based on the WHERE clause.
Dialog Forms Called
None
File Name
Syntax
InsertMovedEventsForInv(VAL before: IS_InventoryRec, VAL after: IS_InventoryRec)
Parameters
before - old inventory record
after - new inventory record
Returns
result of UpdateListOfHistRec
Side Effects
None
Description
This function updates a list of inventory history records for moved events.
Dialog Forms Called
None