project QadFinancials > class BDebtor > business logic query DebtorSafDefaultByDebtorSafDef

Description

DebtorSafDefaultByDebtorSafDef

Parameters


iiDebtorSafDefaultIDintegerDebtorSafDefaultID

query condition


  each DebtorSafDefault where
DebtorSafDefault.DebtorSafDefault_ID = iiDebtorSafDefaultID

      first Saf (inner-join) where
Saf.Saf_ID = DebtorSafDefault.Saf_ID AND

      first SafConcept (inner-join) where
SafConcept.SafConcept_ID = DebtorSafDefault.SafConcept_ID AND

query resultset tqDebtorSafDefaultByDebtorSafDef


field namedata typedb fielddescription
tiDebtor_IDintegerDebtorSafDefault.Debtor_IDLink to Debtor
tiDebtorSafDefault_IDintegerDebtorSafDefault.DebtorSafDefault_IDRecord ID
ttLastModifiedDatedateDebtorSafDefault.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerDebtorSafDefault.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterDebtorSafDefault.LastModifiedUserLast Modified User
tiSaf_IDintegerDebtorSafDefault.Saf_IDSAF Code
tcSafCodecharacterSaf.SafCodeSAF Code
tiSafConcept_IDintegerDebtorSafDefault.SafConcept_IDSAF Concept Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DebtorSafDefault),rowid(Saf),rowid(SafConcept)

Internal usage


QadFinancials
method BDebtor.ApiLoadDebtor