report query GetDebtorBankNumbers

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiDebtorIDFilter	i	=
tBankNumber2.BankNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankNumber.BankNumber	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankNumber.BankNumberBranch	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankNumber.BankNumberExtension	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankNumber.BankNumberIsActive	l	=,<>
tBankNumber.BankNumberIsDefault	l	=,<>
tBankNumber.BankNumberSwiftCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBankNumber.BankNumberValidation	c	=,>=,>,<>,<=,<,begins,can-do,matches
tBusinessRelation.BusinessRelationCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tCurrency.CurrencyCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tPayFormatType.PayFormatTypeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tPayFormatType.PayFormatTypePayInstrument	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiDebtorIDFilter

integer

query condition

each BankNumber where

BankNumber.ParentObject_ID = iiDebtorIDFilter

first BankPayFormat (conditional-join) where

BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

first BankNumber2 (conditional-join) where

BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND

first PayFormatType (conditional-join) where

PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND

first BusinessRelation (conditional-join) where

BusinessRelation.BusinessRelation_ID = BankNumber.BankBusinessRelation_ID AND

first Currency (conditional-join) where

Currency.Currency_ID = BankNumber.Currency_ID AND

query resultset tqGetDebtorBankNumbers

field name	data type	db field	description
tcBankNumber	character	BankNumber.BankNumber	Bank Number
tcBankNumber2	character	BankNumber2.BankNumber	Bank Number
tcBankNumberBranch	character	BankNumber.BankNumberBranch	Branch
tcBankNumberExtension	character	BankNumber.BankNumberExtension	Bank Extension
tlBankNumberIsActive	logical	BankNumber.BankNumberIsActive	Active
tlBankNumberIsDefault	logical	BankNumber.BankNumberIsDefault	Default
tcBankNumberSwiftCode	character	BankNumber.BankNumberSwiftCode	SWIFT Code
tcBankNumberValidation	character	BankNumber.BankNumberValidation	Validation
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tcPayFormatTypeCode	character	PayFormatType.PayFormatTypeCode	Format Name
tcPayFormatTypePayInstrument	character	PayFormatType.PayFormatTypePayInstrument	Payment Instrument
BankNumberCustom	character	calculated	custom fields
BankNumber2Custom	character	calculated	custom fields
PayFormatTypeCustom	character	calculated	custom fields
BusinessRelationCustom	character	calculated	custom fields
CurrencyCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankNumber),rowid(BankPayFormat),rowid(BankNumber2),rowid(PayFormatType),rowid(BusinessRelation),rowid(Currency)

Internal usage

QadFinancials

method BDebtorReport.DebtorMasterCard