project QadFinancials > class BCDocumentReport > business logic query BankNumberByDocID


Parameters


iiCompanyIdintegerCompany id
iiCDocument_IDinteger


query condition


  each CDocument where
CDocument.Company_Id = iiCompanyId AND
CDocument.CDocument_ID = iiCDocument_ID

      first BankNumber (inner-join) where
BankNumber.BankNumber_ID = CDocument.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 tqBankNumberByDocID


field namedata typedb fielddescription
tiAddress_IDintegerAddress.Address_IDRecord ID
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressCountycharacterAddress.AddressCountyObsolete field
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.
tcAddressPostalAddress1characterAddress.AddressPostalAddress1Obsolete field
tcAddressPostalAddress2characterAddress.AddressPostalAddress2Obsolete field
tcAddressPostalCitycharacterAddress.AddressPostalCityObsolete field
tcAddressPostalZipcharacterAddress.AddressPostalZipObsolete field
tcAddressSearchNamecharacterAddress.AddressSearchNameSearch Name. An alternate name for finding this address.
The searchname of a headoffice address is the same as the business relationship and can not be modified.
api annotation:PartialUpdate = yes - defaults to the searchname of the businessRelation.
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.
tcAddressStreet3characterAddress.AddressStreet3Address.Line three 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.
tcBankNumbercharacterBankNumber.BankNumberBank Number
tcBankNumberExtensioncharacterBankNumber.BankNumberExtensionBank Extension
tcBankNumberFormattedcharacterBankNumber.BankNumberFormattedFormatted Bank Account No
tcBankNumberSwiftCodecharacterBankNumber.BankNumberSwiftCodeSWIFT Code
tcBankNumberValidationcharacterBankNumber.BankNumberValidationValidation
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


Internal usage


QadFinancials
method BCDocumentReport.CDocumentReportAllCreate