business logic query BankNumberPayCodeForExcelInteg

Description

Used for populating temp-table tApiBankNumberPayCode for Supplier/Customer Bank Number Excel Integration.

each BankNumberPayCode where

first BankNumber (inner-join) where

BankNumber.BankNumber_ID = BankNumberPayCode.BankNumber_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	BankNumberPayCode.PayFormatGroup_ID	Link to PayFormatGroup
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	PayFormatGroup.PayFormatTypeCode	Payment Format Type
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BankNumberPayCode),rowid(BankNumber),rowid(PayFormatCode),rowid(PayFormatGroup)

QadFinancials