project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyByBusinessRel

Annotation

CompanyPropertyByBusinessRel

Description

CompanyPropertyByBusinessRelation


Parameters


iiCompanyIdintegerCompany id
icAddressTypecharacter


query condition


  each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND

      first Currency (inner-join) where
Currency.Currency_ID = CompanyProperty.Currency_ID AND

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

          each VatNumber (conditional-join) where
VatNumber.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

              first Country2 (outer-join) where
Country2.Country_ID = VatNumber.IdentityCountry_ID AND

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

              first Country1 (inner-join) where
Country1.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

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


query sort order


CompanyProperty.BusinessRelation_ID (ascending)


query resultset tqCompanyPropertyByBusinessRel


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.
tcAddressCountryCodecharacterCountry1.CountryCodeCountry Code
tlAddressIsEUCountrylogicalCountry1.CountryIsEUCountryEU Member
tlAddressIsTaxInCitylogicalAddress.AddressIsTaxInCityTax in City. This field determines whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing.
api annotation:PartialUpdate = yes - defaults to true.
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.
tcAddressTaxIDStatecharacterAddress.AddressTaxIDStateState Tax. This field is for reference and documentation purposes, the value of the field is either a state or provincial tax identification number or a VAT registration number.
tcAddressTypeCodecharacterAddressType.AddressTypeCodeAddress Type
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.
tiBusinessRelation_IDintegerCompanyProperty.BusinessRelation_IDMandatory
tcBusinessRelationAVRCodecharacterBusinessRelation.BusinessRelationAVRCodeObsolete field
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.
tlCompanyPropertyIsARUseTaxDatelogicalCompanyProperty.CompanyPropertyIsARUseTaxDateAR Exchange Rate - Use Taxpoint Date
tiCountry_IDintegerCountry1.Country_IDRecord ID
tcCountryDescriptioncharacterCountry1.CountryDescriptionDescription
tiCounty_IDintegerCounty.County_IDRecord ID
tcCountyCodecharacterCounty.CountyCodeCounty Code
tcCountyDescriptioncharacterCounty.CountyDescriptionDescription
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiIdentityCountry_IDintegerVatNumber.IdentityCountry_IDCountry Tax Identification
tcIdentityCountryCodecharacterCountry2.CountryCodeCountry Code
tlIdentityIsEUCountrylogicalCountry2.CountryIsEUCountryEU Member
tiState_IDintegerState.State_IDRecord ID
tcStateCodecharacterState.StateCodeState
tcStateDescriptioncharacterState.StateDescriptionDescription
tcTxzTaxZonecharacterAddress.TxzTaxZoneTax Zone. This field indicates the tax zone for this address. This field is mandatory.
api annotation:PartialUpdate = yes - defaults to a value the system searches for based on the country, state or province, county, city, and postal code of the current address.
tiVatNumber_IDintegerVatNumber.VatNumber_IDRecord ID
tcVatNumberIdentitycharacterVatNumber.VatNumberIdentityObsolete field


Internal usage


QadFinancials
method BBankNumber.GetParentBankData
method BBusinessRelation.InitialValues
method BCDocument.AdditionalUpdatesPostingCrossCy
method BCInvoice.ApiStdMaintainTTWithIntPost
method BCInvoice.CreateCInvoices
method BCInvoice.InitialValues
method BDInvoice.ApiCreateDInvoicesFinCharge
method BDInvoice.ApiStdMaintainTTWithIntPost
method BDInvoice.CreateDInvoices
method BDInvoice.CreateFinChgInvoices
method BDInvoice.InitialValues
method BDInvoice.StdMaintainTTWithIntPost
method BDInvoiceJournalEntry.ApiStdMaintainTTDefValExtPost
method BJournalEntry.CreateTaxPosting
method BPaymentSelection.ExportBEAbroad
method BPaymentSelection.ExportNLInland
method BPaymentSelection.ExportUNIFI
method BVATExportListing.ExportFormatting723
method BVATExportListing.ExportFormatting725
method BVATReport.VATYearlyListingBE
method TConvertInstalNETXML.SetOutputData