business logic query BankNumberPayCodeByBankNbrID

Parameters

iiBankNumberId

integer

each BankNumberPayCode where

BankNumberPayCode.BankNumber_ID = iiBankNumberId

first BankNumber (inner-join) where

BankNumber.BankNumber_ID = BankNumberPayCode.BankNumber_ID AND

first BankPayFormat (inner-join) where

BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

first PayFormatCode (conditional-join) where

PayFormatCode.PayFormatCode_ID = BankNumberPayCode.PayFormatCode_ID AND

first PayFormatGroup (inner-join) where

PayFormatGroup.PayFormatGroup_ID = BankNumberPayCode.PayFormatGroup_ID AND

field name	data type	db field	description
tiBankNumber_ID	integer	BankNumberPayCode.BankNumber_ID	Link to BankNumber
tiBankNumberPayCode_ID	integer	BankNumberPayCode.BankNumberPayCode_ID	Record ID
tiBankNumberPayCodeSequence	integer	BankNumberPayCode.BankNumberPayCodeSequence	Sequence
tcBankNumberPayCodeValue	character	BankNumberPayCode.BankNumberPayCodeValue	Attribute Value
tcPayFormatCode	character	PayFormatCode.PayFormatCode	Attribute Value
tiPayFormatCode_ID	integer	BankNumberPayCode.PayFormatCode_ID	Description
tcPayFormatCodeDescription	character	PayFormatCode.PayFormatCodeDescription	Description
tiPayFormatGroup_ID	integer	PayFormatGroup.PayFormatGroup_ID	Record ID
tcPayFormatGroupCode	character	PayFormatGroup.PayFormatGroupCode	Attribute Name
tcPayFormatGroupDataType	character	PayFormatGroup.PayFormatGroupDataType	Data Type
tcPayFormatGroupDescription	character	PayFormatGroup.PayFormatGroupDescription	Description
tcPayFormatGroupInputOption	character	PayFormatGroup.PayFormatGroupInputOption	Input Option
tlPayFormatGroupIsMandatory	logical	PayFormatGroup.PayFormatGroupIsMandatory	Mandatory
tiPayFormatGroupSequence	integer	PayFormatGroup.PayFormatGroupSequence	Group Code
tcPayFormatTypeCode	character	BankPayFormat.PayFormatTypeCode	Payment Format

QadFinancials