project QadFinancials > class BBankNumber > business logic query BankNumberForExcelIntegration

Description

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


Parameters


icBankNumberParentTypecharacter
iiCompanyIdintegerCompany id


query condition


  each BankNumber where
BankNumber.BankNumberParentType = icBankNumberParentType

      first BankAccFormat (conditional-join) where
BankAccFormat.BankAccFormat_ID = BankNumber.BankAccFormat_ID AND

      first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = BankNumber.BankPayFormat_ID AND

          first BankNumber2 (inner-join) where
BankNumber2.BankNumber_ID = BankPayFormat.BankNumber_ID AND

              first CompanySharedSet (inner-join) where
CompanySharedSet.Company_Id = iiCompanyId AND
CompanySharedSet.CompanySharedSet_ID = BankNumber2.CompanySharedSet_ID AND

                  first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CompanySharedSet.Company_ID AND

              first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = BankNumber2.ParentObject_ID AND

          first PayFormatType (inner-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 tqBankNumberForExcelIntegration


field namedata typedb fielddescription
tiBankAccFormat_IDintegerBankNumber.BankAccFormat_IDBank Account Format
tcBankAccFormatCodecharacterBankAccFormat.BankAccFormatCodeBank Account Format
tcBankNumberBankAccountTypecharacterBankNumber.BankNumberBankAccountTypeBank Account Type
tiBankNumberBankChargeGL_IDintegerBankNumber.BankNumberBankChargeGL_IDLink to GL for Bank Charges
tcBankNumberBranchcharacterBankNumber.BankNumberBranchBranch
tlBankNumberIsBankChargelogicalBankNumber.BankNumberIsBankChargeBank Charge
tlBankNumberIsSBDeflogicalBankNumber.BankNumberIsSBDefSelf-Bill Default
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiBankPayFormat_ID1integerBankPayFormat.BankPayFormat_IDRecord ID
tiCompany_IDintegerCompany.Company_IDRecord ID
tiCompany_ID1integerCompanySharedSet.Company_IDEntity
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCompanySharedSet_ID1integerCompanySharedSet.CompanySharedSet_IDRecord ID
tcCustomCombo0characterBankNumber.CustomCombo0Custom Combo Field
tcCustomCombo1characterBankNumber.CustomCombo1Custom Combo Field
tcCustomCombo2characterBankNumber.CustomCombo2Custom Combo Field
tcCustomCombo3characterBankNumber.CustomCombo3Custom Combo Field
tcCustomCombo4characterBankNumber.CustomCombo4Custom Combo Field
tcCustomCombo5characterBankNumber.CustomCombo5Custom Combo Field
tcCustomCombo6characterBankNumber.CustomCombo6Custom Combo Field
tcCustomCombo7characterBankNumber.CustomCombo7Custom Combo Field
tcCustomCombo8characterBankNumber.CustomCombo8Custom Combo Field
tcCustomCombo9characterBankNumber.CustomCombo9Custom Combo Field
ttCustomDate0dateBankNumber.CustomDate0Custom Date Field
ttCustomDate1dateBankNumber.CustomDate1Custom Date Field
ttCustomDate2dateBankNumber.CustomDate2Custom Date Field
ttCustomDate3dateBankNumber.CustomDate3Custom Date Field
ttCustomDate4dateBankNumber.CustomDate4Custom Date Field
tdCustomDecimal0decimalBankNumber.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalBankNumber.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalBankNumber.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalBankNumber.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalBankNumber.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerBankNumber.CustomInteger0Custom Integer Field
tiCustomInteger1integerBankNumber.CustomInteger1Custom Integer Field
tiCustomInteger2integerBankNumber.CustomInteger2Custom Integer Field
tiCustomInteger3integerBankNumber.CustomInteger3Custom Integer Field
tiCustomInteger4integerBankNumber.CustomInteger4Custom Integer Field
tcCustomLong0characterBankNumber.CustomLong0Custom Long Field
tcCustomLong1characterBankNumber.CustomLong1Custom Long Field
tcCustomNotecharacterBankNumber.CustomNoteCustom Note Field
tcCustomShort0characterBankNumber.CustomShort0Custom Short Field
tcCustomShort1characterBankNumber.CustomShort1Custom Short Field
tcCustomShort2characterBankNumber.CustomShort2Custom Short Field
tcCustomShort3characterBankNumber.CustomShort3Custom Short Field
tcCustomShort4characterBankNumber.CustomShort4Custom Short Field
tcCustomShort5characterBankNumber.CustomShort5Custom Short Field
tcCustomShort6characterBankNumber.CustomShort6Custom Short Field
tcCustomShort7characterBankNumber.CustomShort7Custom Short Field
tcCustomShort8characterBankNumber.CustomShort8Custom Short Field
tcCustomShort9characterBankNumber.CustomShort9Custom Short Field
tiDDocumentStatus_IDintegerBankNumber.DDocumentStatus_IDPayment Status
tiGL_IDintegerGL.GL_IDRecord ID
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tcOwnBankNumbercharacterBankNumber2.BankNumberBank Number
tiOwnBankNumber_IDintegerBankNumber2.BankNumber_IDRecord ID
tcPayFormatTypeCodecharacterBankPayFormat.PayFormatTypeCodePayment Format
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument
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
tcBankBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness 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.
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BankNumber),rowid(BankAccFormat),rowid(BankPayFormat),rowid(BankNumber2),rowid(CompanySharedSet),rowid(Company),rowid(GL),rowid(PayFormatType),rowid(BusinessRelation),rowid(Currency)


Internal usage


QadFinancials
method BBankNumber.ApiLoadCustomerBankNumber
method BBankNumber.ApiLoadSupplierBankNumber