project QadFinancials > class BBankImportLine > business logic query GetBankImpByLineID

Description

This query get Bank Imp information via the Bank Imp Line ID.


Parameters


iiBankImpLineIDintegerBank Import Line ID


query condition


  each BankImpLine where
BankImpLine.BankImpLine_ID = iiBankImpLineID AND
BankImpLine.ProcessInCompany_ID >= 0

      first BankImp (inner-join) where
BankImp.BankImp_ID = BankImpLine.BankImp_ID AND


query resultset tqGetBankImpByLineID


field namedata typedb fielddescription
tiBankImp_IDintegerBankImp.BankImp_IDRecord ID
tcBankImpCurrencyCodecharacterBankImp.BankImpCurrencyCodeBank Currency Code
tcBankImpFileNamecharacterBankImp.BankImpFileNameBank File Name
tcBankImpFileTypecharacterBankImp.BankImpFileTypeFile Type
tiBankImpLine_IDintegerBankImpLine.BankImpLine_IDRecord ID
tiBankImpLinesCountintegerBankImp.BankImpLinesCountNumbers of Detail Lines
ttBankImpLoadedDatedateBankImp.BankImpLoadedDateUpload Date
tiBankImpLoadedTimeintegerBankImp.BankImpLoadedTimeTime Loaded
tdBankImpTotalAmountInTCdecimalBankImp.BankImpTotalAmountInTCTotal Amount In
tdBankImpTotalAmountOutTCdecimalBankImp.BankImpTotalAmountOutTCTotal Amount Out


Internal usage


QadFinancials
method BBankImportLine.ProcessBankImpLineCDocStatusChg
method BBankImportLine.ProcessBankImpLineDDocStatusChg
method BBankImportLine.ProcessBankImpLineNewBankEntry
method BBankImportLine.ProcessBankImpLineNewDDocument
method BBankImportLine.CreatePrePaymentByBankImpLine
method BBankImportLine.CreateUnallocatedBankEntry