business logic query BusRelationSafDefaultByBusRel

Parameters

icBusinessRelationCode

character

Business Relation Code

each BusRelationSafDefault where

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = BusRelationSafDefault.BusinessRelation_ID AND
BusinessRelation.BusinessRelationCode = icBusinessRelationCode

first Saf (inner-join) where

Saf.Saf_ID = BusRelationSafDefault.Saf_ID AND

first SafConcept (inner-join) where

SafConcept.SafConcept_ID = BusRelationSafDefault.SafConcept_ID AND

field name	data type	db field	description
tiBusinessRelation_ID	integer	BusRelationSafDefault.BusinessRelation_ID	Link to BusinessRelation
tcBusinessRelationCode	character	BusinessRelation.BusinessRelationCode	Business 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.
tiSaf_ID	integer	BusRelationSafDefault.Saf_ID	SAF Code
tcSafCode	character	Saf.SafCode	SAF Code
tiSafConcept_ID	integer	BusRelationSafDefault.SafConcept_ID	SAF Concept Code
tcSafConceptCode	character	SafConcept.SafConceptCode	SAF Concept Code

QadFinancials