project QadFinancials > class BBankNumber > business logic query BankNumberByParentPayFormat

Description

Used for populating BankNumberRef temp-tables.

Parameters


iiParentObjectIdinteger
icBankNumberParentTypecharacter
ilBankNumberIsDefaultlogicalBank Number Is Default
iiCompanyIdintegerCompany id

query condition


  each BankNumber where
BankNumber.ParentObject_ID = iiParentObjectId AND
BankNumber.BankNumberParentType = icBankNumberParentType AND
BankNumber.BankNumberIsDefault = ilBankNumberIsDefault

      each BankPayFormat (inner-join) where
BankPayFormat.BankNumber_ID = BankNumber.BankNumber_ID AND

query resultset tqBankNumberByParentPayFormat


field namedata typedb fielddescription
tiBankAccFormat_IDintegerBankNumber.BankAccFormat_IDBank Account Format
tcBankNumberBranchcharacterBankNumber.BankNumberBranchBranch
tlBankNumberIsSBDeflogicalBankNumber.BankNumberIsSBDefSelf-Bill Default
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiBankPayFormat_ID1integerBankPayFormat.BankPayFormat_IDRecord ID
tiDDocumentStatus_IDintegerBankNumber.DDocumentStatus_IDPayment Status
ttLastModifiedDatedateBankNumber.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBankNumber.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBankNumber.LastModifiedUserLast Modified User
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format
tcQADC01characterBankNumber.QADC01unused QAD reserved field
tcQADC02characterBankNumber.QADC02unused QAD reserved field
tdQADD01decimalBankNumber.QADD01unused QAD reserved field
ttQADT01dateBankNumber.QADT01unused QAD reserved field
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiCompanySharedSet_IDintegerBankNumber.CompanySharedSet_IDLink to CompanySharedSet

Internal usage


QadFinancials
method BSharedSetMerge.MergeBeforeMergeGL
dataset BSharedSetMerge.tBankPayFormatMaster
dataset BSharedSetMerge.tBankPayFormatRedundant