business logic query GetBankImpByLineID

Description

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

iiBankImpLineID

integer

Bank Import Line ID

each BankImpLine where

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

first BankImp (inner-join) where

BankImp.BankImp_ID = BankImpLine.BankImp_ID AND

field name	data type	db field	description
tiBankImp_ID	integer	BankImp.BankImp_ID	Record ID
tcBankImpCurrencyCode	character	BankImp.BankImpCurrencyCode	Bank Currency Code
tcBankImpFileName	character	BankImp.BankImpFileName	Bank File Name
tcBankImpFileType	character	BankImp.BankImpFileType	File Type
tiBankImpLine_ID	integer	BankImpLine.BankImpLine_ID	Record ID
tiBankImpLinesCount	integer	BankImp.BankImpLinesCount	Numbers of Detail Lines
ttBankImpLoadedDate	date	BankImp.BankImpLoadedDate	Upload Date
tiBankImpLoadedTime	integer	BankImp.BankImpLoadedTime	Time Loaded
tdBankImpTotalAmountInTC	decimal	BankImp.BankImpTotalAmountInTC	Total Amount In
tdBankImpTotalAmountOutTC	decimal	BankImp.BankImpTotalAmountOutTC	Total Amount Out

QadFinancials