project QadFinancials > class BDebtor > business logic query DebtorSafDefaultByDebtor


Parameters


iiCompanyIdintegerCompany id
icDebtorCodecharacterCustomer Code


query condition


  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


query resultset tqDebtorSafDefaultByDebtor


field namedata typedb fielddescription
tiDebtor_IDintegerDebtorSafDefault.Debtor_IDLink to Debtor
tcDebtorCodecharacterDebtor.DebtorCodeA 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_IDintegerDebtorSafDefault.DebtorSafDefault_IDRecord ID
tiSaf_IDintegerDebtorSafDefault.Saf_IDSAF Code
tcSafCodecharacterSaf.SafCodeSAF Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code


Internal usage


QadFinancials
method BDInvoice.CreateDIPosting
method BDInvoiceJournalEntry.CreateDefaultSafRecords
method BSafDefault.GetSafDefaults