project QadFinancials > class BBillReport > business logic query GetCompanyInfoForBill


Parameters


iiCompanyIdintegerCompany id


query condition


  each Company where
Company.Company_Id = iiCompanyId AND

      each CompanyProperty (inner-join) where
CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

          first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND

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

                  first AddressType (inner-join) where
AddressType.AddressType_ID = Address.AddressType_ID AND

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

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

                  first State (conditional-join) where
State.State_ID = Address.State_ID AND


query resultset tqGetCompanyInfoForBill


field namedata typedb fielddescription
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressEMailcharacterAddress.AddressEMailE-Mail. This field indicates the e-mail address associated with this business relation.
This field can be blank.
tcAddressFaxcharacterAddress.AddressFaxFax. This field indicates the fax or telex number to use when sending documents to this address.
This field can be balnk.
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressTelephonecharacterAddress.AddressTelephoneTelephone. The telephone number for calling this business relation address.
This field can be blank.
tiAddressType_IDintegerAddress.AddressType_IDAddress Type
tcAddressTypeCodecharacterAddressType.AddressTypeCodeAddress Type
tcAddressWebSitecharacterAddress.AddressWebSiteInternet. This field indicates the Web site of this business relation.
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.
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.
tcBusinessRelationOrgTypecharacterBusinessRelation.BusinessRelationOrgTypeOrganization Type
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCountryDescriptioncharacterCountry.CountryDescriptionDescription
tcCountyDescriptioncharacterCounty.CountyDescriptionDescription
tcLocalisationCodecharacterCompany.LocalisationCodeWhen running any business component of the application, the framework will always lookup the localisation code of current company and if filled, will look for a localisation of that type for the business component, and if found will run that localisation in stead of the standard version of the business component.
tcStateDescriptioncharacterState.StateDescriptionDescription


Internal usage


QadFinancials
method BBillReport.BillReportDInvoice