Routines for i_db_val.kb


DeleteValuationRec

File Name

i_db_val.kb

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


GetBookValueSum

File Name

i_db_val.kb

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


GetInvValList

File Name

i_db_val.kb

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


GetValCurrencyList

File Name

i_db_val.kb

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


GetValueRec

File Name

i_db_val.kb

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


InsertValuationRec

File Name

i_db_val.kb

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


UpdateValuationRec

File Name

i_db_val.kb

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