File Name
Syntax
DeleteValuationRec(VAL InTran: BOOLEAN, REF DeleteRec: ValuationRec)
Parameters
InTran - in a transaction or not
DeleteRec - valuation record to be deleted
Returns
SQLDelete return result
Side Effects
None
Description
This function deletes a valuation record in the valuation table.
Dialog Forms Called
None
File Name
Syntax
GetBookValueSum (VAL table: STRING, VAL column: STRING, VAL node_id: STRING, VAL currency_code: STRING)
Parameters
table - table name
column - column name
node_id - ID based on what is being selected
currency_code - currency code
Returns
SQLSelectInto return result
Side Effects
None
Description
This function retrieves the book value sum for different values.
Dialog Forms Called
None
File Name
Syntax
GetInvValList (VAL column_name: STRING, REF lst: LIST OF Inv_ValRec, VAL whdl: WINDOW)
Parameters
column_name - column name
lst - list of inv_val records
whdl - parent window handle
Returns
SQLSelect return result, inv_val record list
Side Effects
None
Description
This function returns a list of inv_val records for the column name.
Dialog Forms Called
None
File Name
Syntax
GetValCurrencyList(REF column_name: STRING)
Parameters
column_name - column name
Returns
SQLSelect return result, currency code list
Side Effects
None
Description
This function returns a list of currency codes based on the column name.
Dialog Forms Called
None
File Name
Syntax
GetValueRec(REF ktype: ValuationRec)
Parameters
ktype - valuation record
Returns
SQLSelectInto return result
Side Effects
None
Description
This function gets a valuation record based on the is_inventory_id.
Dialog Forms Called
None
File Name
Syntax
InsertValuationRec(VAL InTran: BOOLEAN, REF InsertRec: ValuationRec)
Parameters
InTran - in a transaction or not
InsertRec - valuation reocrd to be inserted
Returns
SQLInsert return result
Side Effects
None
Description
This function inserts a new valuation record into the valuation table.
Dialog Forms Called
None
File Name
Syntax
UpdateValuationRec(VAL InTran: BOOLEAN, REF BeforeRec: ValuationRec, REF AfterRec: ValuationRec)
Parameters
InTran - in a transaction or not
BeforeRec - old valuation record
AfterRec - new valuation record
Returns
SQLUpdate return result
Side Effects
None
Description
This function updates a valuation record in the valuation table.
Dialog Forms Called
None