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