project QadFinancials > class BCreditorReport > business logic query GetBankingEntryByInvoice


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIDinteger


query condition


  each BankStateAlloc where
BankStateAlloc.Company_Id = iiCompanyId AND
BankStateAlloc.CInvoice_ID = iiCInvoiceID


query resultset tqGetBankingEntryByInvoice


field namedata typedb fielddescription
tiBankState_IDintegerBankStateAlloc.BankState_IDLink to BankState
tdBankStateAllocWHTAmtTCdecimalBankStateAlloc.BankStateAllocWHTAmtTCTC WHT Amount
tiCInvoice_IDintegerBankStateAlloc.CInvoice_IDLink to CInvoice


Internal usage


QadFinancials
method BCreditorReport.CreditorWithholdingTax