project QadFinancials > class BBankPayFormat > business logic query BankPayFormatForBankImp
Description
Get definition of bank payment format by bank number and by bank file format.
Parameters
| iiBankNumberId | integer | |
| icBankFileFormatCode | character | |
| icPaymentModule | character | |
query condition
each BankPayFormat where
BankPayFormat.BankNumber_ID = iiBankNumberId
first BankFileFormat (inner-join) where
BankFileFormat.BankFileFormat_ID = BankPayFormat.BankFileFormat_ID AND
BankFileFormat.BankFileFormatCode = icBankFileFormatCode
first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND
PayFormatType.PayFormatTypeModule = icPaymentModule
each BankNumber (inner-join) where
BankNumber.BankPayFormat_ID = BankPayFormat.BankPayFormat_ID AND
query resultset tqBankPayFormatForBankImp
| field name | data type | db field | description |
|---|
| tiBankFileFormat_ID | integer | BankPayFormat.BankFileFormat_ID | Bank File Format Code |
| tcBankFileFormatCode | character | BankFileFormat.BankFileFormatCode | Format Code |
| tcBankNumber | character | BankNumber.BankNumber | Bank Number |
| tiBankNumber_ID | integer | BankPayFormat.BankNumber_ID | Bank Number |
| tiBankPayFormat_ID | integer | BankPayFormat.BankPayFormat_ID | Record ID |
| tcPayFormatTypeCode | character | BankPayFormat.PayFormatTypeCode | Payment Format |
Internal usage
QadFinancials