project QadFinancials > class BMfgCreditTermsDetail > business logic query CreditTermsDetailByDomainCode
Description
Get CreditTermsDetail by domain, payment condition code, staged payment condition code
Parameters
| icDomain | character | |
| icPaymentConditionCode | character | |
| icStagedPaymentConditionCode | character | |
query condition
each ctd_det where
ctd_det.ctd_domain = icDomain AND
ctd_det.ctd_code = icPaymentConditionCode AND
ctd_det.ctd_date_cd = icStagedPaymentConditionCode
query resultset tqCreditTermsDetailByDomainCode
| field name | data type | db field | description |
|---|
| tcctd_code | character | ctd_det.ctd_code | Terms Code |
| tcctd_date_cd | character | ctd_det.ctd_date_cd | Dating Code |
| tcctd_domain | character | ctd_det.ctd_domain | Domain |
| tdctd_pct_due | decimal | ctd_det.ctd_pct_due | % Due |
| tictd_seq | integer | ctd_det.ctd_seq | Sequence |
| tdoid_ctd_det | decimal | ctd_det.oid_ctd_det | |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(ctd_det) |
Internal usage
QadFinancials