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