business logic query DebtorSafDefaultByDebtor

Parameters

iiCompanyId	integer	Company id
icDebtorCode	character	Customer Code

each Debtor where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.DebtorCode = icDebtorCode

each DebtorSafDefault (inner-join) where

DebtorSafDefault.Debtor_ID = Debtor.Debtor_ID AND

first Saf (inner-join) where

Saf.Saf_ID = DebtorSafDefault.Saf_ID AND

first SafConcept (inner-join) where

SafConcept.SafConcept_ID = DebtorSafDefault.SafConcept_ID AND

field name	data type	db field	description
tiDebtor_ID	integer	DebtorSafDefault.Debtor_ID	Link to Debtor
tcDebtorCode	character	Debtor.DebtorCode	A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation.
	api annotation:		If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create.
tiDebtorSafDefault_ID	integer	DebtorSafDefault.DebtorSafDefault_ID	Record ID
tiSaf_ID	integer	DebtorSafDefault.Saf_ID	SAF Code
tcSafCode	character	Saf.SafCode	SAF Code
tcSafConceptCode	character	SafConcept.SafConceptCode	SAF Concept Code

QadFinancials