project QadFinancials > class BMfgTaxDetail > business logic query TaxDetailLineForBillReport
Parameters
| icInvNbr | character | |
| icNumber | character | |
| iiLine | integer | |
| icTx2dDomain | character | |
query condition
each tx2d_det where
tx2d_det.tx2d_ref = icInvNbr AND
tx2d_det.tx2d_nbr = icNumber AND
tx2d_det.tx2d_line = iiLine AND
tx2d_det.tx2d_domain = icTx2dDomain
query resultset tqTaxDetailLineForBillReport
| field name | data type | db field | description |
|---|
| tltx2d_by_line | logical | tx2d_det.tx2d_by_line | Tax-By-Line |
| tdtx2d_cur_tax_amt | decimal | tx2d_det.tx2d_cur_tax_amt | Tax |
| tctx2d_domain | character | tx2d_det.tx2d_domain | Domain |
| tttx2d_effdate | date | tx2d_det.tx2d_effdate | Tax Date |
| titx2d_line | integer | tx2d_det.tx2d_line | Line |
| tctx2d_nbr | character | tx2d_det.tx2d_nbr | Number |
| tctx2d_ref | character | tx2d_det.tx2d_ref | Reference |
| tdtx2d_tax_amt | decimal | tx2d_det.tx2d_tax_amt | Base Tax |
| tctx2d_tax_code | character | tx2d_det.tx2d_tax_code | Tax Code |
| tctx2d_tax_env | character | tx2d_det.tx2d_tax_env | Tax Environment |
| tltx2d_tax_in | logical | tx2d_det.tx2d_tax_in | Tax In |
| tctx2d_tax_type | character | tx2d_det.tx2d_tax_type | Tax Type |
| tctx2d_tax_usage | character | tx2d_det.tx2d_tax_usage | Tax Usage |
| tdtx2d_taxable_amt | decimal | tx2d_det.tx2d_taxable_amt | Base Taxable |
| tctx2d_taxc | character | tx2d_det.tx2d_taxc | Tax Class |
| tdtx2d_totamt | decimal | tx2d_det.tx2d_totamt | Total Amount |
| tctx2d_trl | character | tx2d_det.tx2d_trl | Trailer |
Internal usage
QadFinancials