project QadFinancials > class BDDocumentReport > business logic query BankNumberForDocumentID


Parameters


iiCompanyIdintegerCompany id
iiDocument_IDinteger


query condition


  each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = iiDocument_ID

      first BankNumber (inner-join) where
BankNumber.BankNumber_ID = DDocument.BankNumber_ID AND

          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 tqBankNumberForDocumentID


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.
tcAddressStatecharacterAddress.AddressStateObsolete field
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.
tiBankBusinessRelation_IDintegerBankNumber.BankBusinessRelation_IDBusiness Relation
tcBankNumbercharacterBankNumber.BankNumberBank Number
tiBankNumber_IDintegerDDocument.BankNumber_IDLink to BankNumber
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberParentTypecharacterBankNumber.BankNumberParentTypeType
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
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.
tiCountry_IDintegerCountry.Country_IDRecord ID
tcCountryCodecharacterCountry.CountryCodeCountry Code
tcCountryDescriptioncharacterCountry.CountryDescriptionDescription
tiCounty_IDintegerCounty.County_IDRecord ID
tcCountyCodecharacterCounty.CountyCodeCounty Code
tcCountyDescriptioncharacterCounty.CountyDescriptionDescription
tiParentObject_IDintegerBankNumber.ParentObject_IDParent Object
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DDocument),rowid(BankNumber),rowid(BusinessRelation),rowid(Address),rowid(Country),rowid(County)


Internal usage


QadFinancials
method BDDocumentReport.DDocumentReportAllCreate