project QadFinancials > class BBankNumber > business logic query BankNumberByCinvoiceid

Description

query to fetch bank number details for ParentObject id + Banknumber Parenttype + banknumber


Parameters


iiParentobject_idinteger
icParentTypecharacter
icBanknumbercharacter
iiCompanyidinteger


query condition


  each BankNumber where
BankNumber.ParentObject_ID = iiParentObject_id AND
BankNumber.BankNumberParentType = icParentType AND
BankNumber.BankNumber = icBankNumber

      first BusinessRelation (outer-join) where
BusinessRelation.BusinessRelation_ID = BankNumber.BankBusinessRelation_ID AND

          each Address (outer-join) where
Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

              first Country (outer-join) where
Country.Country_ID = Address.Country_ID AND

              first County (outer-join) where
County.County_ID = Address.County_ID AND


query resultset tqBankNumberByCinvoiceid


field namedata typedb fielddescription
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tiAddressFormatintegerAddress.AddressFormatFormat. This field determines where postal codes display on printed addresses.
api annotation:PartialUpdate = yes - defaults to the value for the same field defined for the country.
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressStreet2characterAddress.AddressStreet2Address.Line two of address details.
This field can be blank.
tcAddressZipcharacterAddress.AddressZipZip. The postal code or US zip code associated with this address.
This field is used to decide the tax zone for the address.
This field can be blank.
tiBankAccFormat_IDintegerBankNumber.BankAccFormat_IDBank Account Format
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerBankNumber.BankNumber_IDRecord ID
tcBankNumberBranchcharacterBankNumber.BankNumberBranchBranch
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tlBankNumberIsActivelogicalBankNumber.BankNumberIsActiveActive
tlBankNumberIsDefaultlogicalBankNumber.BankNumberIsDefaultDefault
tlBankNumberIsSBDeflogicalBankNumber.BankNumberIsSBDefSelf-Bill Default
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
tiBankPayFormat_IDintegerBankNumber.BankPayFormat_IDLink to BankPayFormat
tiBusinessRelation_IDintegerBusinessRelation.BusinessRelation_IDRecord ID
tcBusinessRelationCodecharacterBusinessRelation.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.
tcBusinessRelationName1characterBusinessRelation.BusinessRelationName1Name: The full name of the business relation.
This field sets the default name for linked addresses such as customers and suppliers.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
tcBusinessRelationName2characterBusinessRelation.BusinessRelationName2Second Name. An extended name when the Name field is not large enough to contain all information.
This fielsd can be blank.
tiCompanySharedSet_IDintegerBankNumber.CompanySharedSet_IDLink to CompanySharedSet
tiCountry_IDintegerCountry.Country_IDRecord ID
tcCountryDescriptioncharacterCountry.CountryDescriptionDescription
tiCounty_IDintegerCounty.County_IDRecord ID
tcCountyDescriptioncharacterCounty.CountyDescriptionDescription
tiCurrency_IDintegerBankNumber.Currency_IDCurrency Code
tiDDocumentStatus_IDintegerBankNumber.DDocumentStatus_IDPayment Status
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object


Internal usage


QadFinancials
method BCDocumentReport.CDocumentReportAllCreate