project QadFinancials > class BMfgTaxDetail > business logic query TaxDetailTrailerForBillReport
Parameters
| icInvNbr | character | |
| icNumber | character | |
| icTrailer | character | |
| icTx2dDomain | character | |
| iiSOLine | integer | |
query condition
each tx2d_det where
tx2d_det.tx2d_ref = icInvNbr AND
tx2d_det.tx2d_nbr = icNumber AND
tx2d_det.tx2d_trl = icTrailer AND
tx2d_det.tx2d_domain = icTx2dDomain AND
tx2d_det.tx2d_line = iiSOLine
first tx2_mstr (inner-join) where
tx2_mstr.tx2_domain = tx2d_det.tx2d_domain AND
tx2_mstr.tx2_tax_code = tx2d_det.tx2d_tax_code AND
query resultset tqTaxDetailTrailerForBillReport
| field name | data type | db field | description |
|---|
| tctx2_desc | character | tx2_mstr.tx2_desc | Description |
| tdtx2_tax_pct | decimal | tx2_mstr.tx2_tax_pct | Tax Rate |
| 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