project QadFinancials > class BBankEntry > business logic query BankStateInfoByDInvoiceId


Parameters


iiCompanyIdintegerCompany id
iiDInvoiceIdinteger


query condition


  each BankStateAlloc where
BankStateAlloc.Company_Id = iiCompanyId AND
BankStateAlloc.DInvoice_ID = iiDInvoiceId

      first BankState (inner-join) where
BankState.Company_Id = iiCompanyId AND
BankState.BankState_ID = BankStateAlloc.BankState_ID AND


query resultset tqBankStateInfoByDInvoiceId


field namedata typedb fielddescription
tiBankState_IDintegerBankStateAlloc.BankState_IDLink to BankState
tiBankStateAlloc_IDintegerBankStateAlloc.BankStateAlloc_IDRecord ID
tcBankStateAllocTypecharacterBankStateAlloc.BankStateAllocTypeAllocation Type
tcBankStateTransactionTypecharacterBankState.BankStateTransactionTypeTransaction Type
tiDInvoice_IDintegerBankStateAlloc.DInvoice_IDLink to DInvoice


Internal usage


QadFinancials
method BDInvoice.GetDeductionPaymentByDInvoiceId