project QadFinancials > class BBusinessRelation > business logic query BusinessRelationByCode

Parameters


icBusinessRelationCodecharacterBusiness Relation Code
iiDomainIDintegerDomain Restricate

query condition


  each BusinessRelation where
BusinessRelation.BusinessRelationCode = icBusinessRelationCode AND
(BusinessRelation.Domain_ID = iiDomainID OR
BusinessRelation.Domain_ID = 0 OR
BusinessRelation.Domain_ID = ? )

query sort order


BusinessRelation.BusinessRelationCode (ascending)

query resultset tqBusinessRelationByCode


field namedata typedb fielddescription
tiBusinessRelation_IDintegerBusinessRelation.BusinessRelation_IDRecord ID
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.
tcBusinessRelationEANCodecharacterBusinessRelation.BusinessRelationEANCodeObsolete field
tcBusinessRelationICCodecharacterBusinessRelation.BusinessRelationICCodeIntercompany Code. When Intercompany is true, this field is mandatory.
The code entered here must match the intercompany code entered for GL accounts in order to generate intercompany reports.
The intercompany code must be unique for this business relation.
tlBusinessRelationIsActivelogicalBusinessRelation.BusinessRelationIsActiveActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true.
tlBusinessRelationIsCompenslogicalBusinessRelation.BusinessRelationIsCompensCustomer/Supplier Compensation Allowed. This filed indicates how open items should be managed during payment processing when a customer and supplier are both associated with this business relation.
api annotation:PartialUpdate = yes - defaults to false.
tlBusinessRelationIsDomRestrlogicalBusinessRelation.BusinessRelationIsDomRestrDomain Restricted. This filed indicates if access to this business relation is restricted by domain.
api annotation:PartialUpdate = yes - defaults to the value for this field defaults from the Business Relations by Domain field in System Maintain.
tlBusinessRelationIsInComplogicalBusinessRelation.BusinessRelationIsInCompInternal Entity. This filed indicates if the business relation identifies one of your entities within this database.
If this is an internal entity, you can also update the Tax Report, Name Control, and Last Filing fields, which are used for filing 1099-MISC reports in the US.
api annotation:PartialUpdate = yes - defaults to false.
For internal entities, this field defaults to yes and cannot be changed.
tlBusinessRelationIsIntercologicalBusinessRelation.BusinessRelationIsIntercoIntercompany. This field Indicates if the business relation identifies an entity that is a member of a group of entities that trade with each other.
If the business relation is identified as an internal entity,this field is true and cannot be changed.
api annotation:PartialUpdate = yes - defaults to false.
tlBusinessRelationIsLastFilllogicalBusinessRelation.BusinessRelationIsLastFillLast Filing. For an internal company, this field indicates whether this is the last time your company is filing a 1099-MISC under its current taxpayer ID number.
api annotation:PartialUpdate = yes - defaults to false.
tlBusinessRelationIsTaxReplogicalBusinessRelation.BusinessRelationIsTaxRepTax Report. For an internal company,this filed indicates whether to use this address for 1099 tax reporting.
When this field is yes, the name, first line of the street address, city, state, zip code, telephone number, and federal tax ID for the headoffice address must not be blank.
api annotation:PartialUpdate = yes - defaults to false.
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.
tcBusinessRelationName3characterBusinessRelation.BusinessRelationName3Third Name: A name required for some regional reports.
This field can be blank.
tcBusinessRelationNameCtrlcharacterBusinessRelation.BusinessRelationNameCtrlName Control. For an internal company, the value is the IRS magnetic media control code assigned to this company.
When Tax Report is selected, a warning displays when this field is blank.
tcBusinessRelationSearchNamecharacterBusinessRelation.BusinessRelationSearchNameSearch Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
tiCorporateGroup_IDintegerBusinessRelation.CorporateGroup_IDGroup Name
tcCustomCombo0characterBusinessRelation.CustomCombo0Custom Combo Field
tcCustomCombo1characterBusinessRelation.CustomCombo1Custom Combo Field
tcCustomCombo2characterBusinessRelation.CustomCombo2Custom Combo Field
tcCustomCombo3characterBusinessRelation.CustomCombo3Custom Combo Field
tcCustomCombo4characterBusinessRelation.CustomCombo4Custom Combo Field
tcCustomCombo5characterBusinessRelation.CustomCombo5Custom Combo Field
tcCustomCombo6characterBusinessRelation.CustomCombo6Custom Combo Field
tcCustomCombo7characterBusinessRelation.CustomCombo7Custom Combo Field
tcCustomCombo8characterBusinessRelation.CustomCombo8Custom Combo Field
tcCustomCombo9characterBusinessRelation.CustomCombo9Custom Combo Field
ttCustomDate0dateBusinessRelation.CustomDate0Custom Date Field
ttCustomDate1dateBusinessRelation.CustomDate1Custom Date Field
ttCustomDate2dateBusinessRelation.CustomDate2Custom Date Field
ttCustomDate3dateBusinessRelation.CustomDate3Custom Date Field
ttCustomDate4dateBusinessRelation.CustomDate4Custom Date Field
tdCustomDecimal0decimalBusinessRelation.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalBusinessRelation.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalBusinessRelation.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalBusinessRelation.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalBusinessRelation.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerBusinessRelation.CustomInteger0Custom Integer Field
tiCustomInteger1integerBusinessRelation.CustomInteger1Custom Integer Field
tiCustomInteger2integerBusinessRelation.CustomInteger2Custom Integer Field
tiCustomInteger3integerBusinessRelation.CustomInteger3Custom Integer Field
tiCustomInteger4integerBusinessRelation.CustomInteger4Custom Integer Field
tcCustomLong0characterBusinessRelation.CustomLong0Custom Long Field
tcCustomLong1characterBusinessRelation.CustomLong1Custom Long Field
tcCustomNotecharacterBusinessRelation.CustomNoteCustom Note Field
tcCustomShort0characterBusinessRelation.CustomShort0Custom Short Field
tcCustomShort1characterBusinessRelation.CustomShort1Custom Short Field
tcCustomShort2characterBusinessRelation.CustomShort2Custom Short Field
tcCustomShort3characterBusinessRelation.CustomShort3Custom Short Field
tcCustomShort4characterBusinessRelation.CustomShort4Custom Short Field
tcCustomShort5characterBusinessRelation.CustomShort5Custom Short Field
tcCustomShort6characterBusinessRelation.CustomShort6Custom Short Field
tcCustomShort7characterBusinessRelation.CustomShort7Custom Short Field
tcCustomShort8characterBusinessRelation.CustomShort8Custom Short Field
tcCustomShort9characterBusinessRelation.CustomShort9Custom Short Field
tiDomain_IDintegerBusinessRelation.Domain_IDLink to Domains
ttLastModifiedDatedateBusinessRelation.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBusinessRelation.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBusinessRelation.LastModifiedUserLast Modified User
tiLng_IDintegerBusinessRelation.Lng_IDLanguage Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BusinessRelation)

Internal usage


QadFinancials
method BBusinessRelation.ApiLoadBusinessRelation
method BCompany.ApiSynchroniseCustom
method BGL.ValBankNumberRef
method BMfgAddress.ApiGetDockAddress
method BMfgAddress.ApiGetHeadOfficeAddress
method BOpenItemAdjustment.OIAdjNewOpenItem