project QadFinancials > class BCashGroup > business logic query CashGroupPrim

Description

Prim query for Cash Group with parameters CashGroupID and CashGroupCode


Parameters


iiCashGroupIDinteger
icCashGroupCodecharacter


query condition


  each CashGroup where
CashGroup.CashGroup_ID = iiCashGroupID AND
CashGroup.CashGroupCode = icCashGroupCode


query resultset tqCashGroupPrim


field namedata typedb fielddescription
tiCashGroup_IDintegerCashGroup.CashGroup_IDRecord ID
tcCashGroupCodecharacterCashGroup.CashGroupCodeA code (maximum 20 characters) that identifies a cash group.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(CashGroup)


Internal usage


QadFinancials
method BCashGroup.DataLoadByInput
method BGL.ApiLoadGL
method BGL.ApiLoadGLCalcCashGroupCode
read related business field(s) on tGL.CashGroup_ID
ApiGetAlternateKeyValues
validate related business field(s) on tGL.CashGroup_ID