project QadFinancials > class BBusinessRelation > business logic query BusinessRelationPrim

Description

Query that can be used to convert the ID into the Code and vice-versa (Code is also a related-key-business-field in this query).


Parameters


iiBusinessRelationIdinteger
icBusinessRelationCodecharacterBusiness Relation Code


query condition


  each BusinessRelation where
BusinessRelation.BusinessRelation_ID = iiBusinessRelationId AND
BusinessRelation.BusinessRelationCode = icBusinessRelationCode


query resultset tqBusinessRelationPrim


field namedata typedb fielddescription
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.
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.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BusinessRelation)


Internal usage


QadFinancials
method BAnalyticalReport.CostCentreTransDet
method BAutoNumber.GetAutoNumber
method BBankBranch.DataLoadByInput
method BBankCharge.PreValidateComponent
method BBusinessRelation.ApiMaintainAddressForEI
method BBusinessRelation.ApiStdMaintainTT
method BBusinessRelation.ApiSynchronise
method BBusinessRelation.MaintainAddressMulti
method BBusinessRelation.ValidateComponentSystemOrDomain
method BCompany.PreValidateComponent
method BCompanyProperty.CalcAllCompanyPropertyForCalculate
method BCompanyProperty.PreValidateComponent
method BCreditor.ValBankNumberAndPayCodeRef
method BDebtor.ValBankNumberandPayCodeRef
method BEmployee.ApiLoadEmployee
method BEmployee.ApiLoadEmployeeCalcBusRelCode
method BPrepayment.PreValidateComponent
method BProject.ApiLoadProject
method BProject.ApiLoadProjectCalcBusinessRelationCode
read related business field(s) on tBankBranch.BusinessRelation_ID
read related business field(s) on tBankCharge.BusinessRelation_ID
read related business field(s) on tBankNumber.BankBusinessRelation_ID
read related business field(s) on tCompanyProperty.BusinessRelation_ID
read related business field(s) on tCreditor.BusinessRelation_ID
read related business field(s) on tDebtor.BusinessRelation_ID
read related business field(s) on tEmployee.BusinessRelation_ID
read related business field(s) on tPaySelPrepay.BusinessRelation_ID
read related business field(s) on tProject.BusinessRelation_ID
read related business field(s) on tRevalGL.IntercoBusinessRelation_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tBankBranch.BusinessRelation_ID
validate related business field(s) on tBankNumber.BankBusinessRelation_ID
validate related business field(s) on tCreditor.BusinessRelation_ID
validate related business field(s) on tDebtor.BusinessRelation_ID
validate related business field(s) on tEmployee.BusinessRelation_ID
validate related business field(s) on tPaySelPrepay.BusinessRelation_ID
validate related business field(s) on tProject.BusinessRelation_ID
validate related business field(s) on tRevalGL.IntercoBusinessRelation_ID