Parameters
query condition
each BankNumber where
BankNumber.ParentObject_ID = iiCreditor_ID
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 tqGetBankNumbers
| 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 |
Internal usage
QadFinancials