project QadFinancials > class BDebtor > business logic query DebtorForReasonBusRel

Description

DebtorForReasonBusRel


Parameters


iiCompanyIdintegerCompany id
icDebtorCodecharacter
iiDebtorIDinteger


query condition


  each Debtor where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = iiDebtorID AND
Debtor.DebtorCode = icDebtorCode

      first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND

      first Reason (inner-join) where
Reason.Reason_ID = Debtor.Reason_ID AND


query resultset tqDebtorForReasonBusRel


field namedata typedb fielddescription
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.
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.
tlDebtorIsActivelogicalDebtor.DebtorIsActiveIndicate if this is an active record.
api annotation:Value for this field defaults to false.
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.
tlBusinessRelationIsActivelogicalBusinessRelation.BusinessRelationIsActiveActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true.
tcReasonCodecharacterReason.ReasonCodeInvoice Status Code
tlReasonIsActivelogicalReason.ReasonIsActiveActive
tiBusinessRelation_IDintegerDebtor.BusinessRelation_IDBusiness Relation
tiDebtor_IDintegerDebtor.Debtor_IDRecord ID
tiReason_IDintegerDebtor.Reason_IDInvoice Status Code


Internal usage


QadFinancials
method BDInvoice.AdditionalUpdatesAllCreateDA
method BOpenItemAdjustment.GetBusinessRelationForCredDeb