Description
Get sequence(max) by domain and payment condition code.
Parameters
| icDomain | character | |
| icPaymentConditionCode | character | |
query condition
each ctd_det where
ctd_det.ctd_domain = icDomain AND
ctd_det.ctd_code = icPaymentConditionCode
query sort order
ctd_det.ctd_seq (descending)
query resultset tqDetailSeqByDomainCode
| field name | data type | db field | description |
|---|
| tcctd_code | character | ctd_det.ctd_code | Terms Code |
| tcctd_domain | character | ctd_det.ctd_domain | Domain |
| tictd_seq | integer | ctd_det.ctd_seq | Sequence |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(ctd_det) |
Internal usage
QadFinancials