project QadFinancials > class BDebtorType > business logic query DebtorTypePrim


Parameters


iiDebtorTypeIDintegerDebtor Type ID
icDebtorTypeCodecharacterDebtor Type Code


query condition


  each DebtorType where
DebtorType.DebtorType_ID = iiDebtorTypeID AND
DebtorType.DebtorTypeCode = icDebtorTypeCode


query resultset tqDebtorTypePrim


field namedata typedb fielddescription
tiDebtorType_IDintegerDebtorType.DebtorType_IDRecord ID
tcDebtorTypeCodecharacterDebtorType.DebtorTypeCodeA code (maximum four characters) that identifies a customer type.
tcDebtorTypeDescriptioncharacterDebtorType.DebtorTypeDescriptionA brief description (maximum 40 characters) of the customer type.
tlDebtorTypeIsActivelogicalDebtorType.DebtorTypeIsActiveIndicate whether the customer type is active.
api annotation:Value for this field defaults to false.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DebtorType)


Internal usage


QadFinancials
method BDebtor.ApiLoadDebtor
method BDebtor.ApiLoadDebtorCalcDebtorTypeCode
method BDebtorType.ApiValidateDebtorType
read related business field(s) on tDebtor.DebtorType_ID
ApiGetAlternateKeyValues
validate related business field(s) on tDebtor.DebtorType_ID