copy of query resultset tqTaxDetailByKey
table tLgddDetTaxForAPM
| field name | data type | description |
|---|
| tc_ParentRowid | character | |
| tctx2_base | character | |
| tltx2_tax_in | logical | |
| tdtx2d_cur_abs_ret_amt | decimal(10) | |
| tctx2_dltx_cn_sub | character | |
| tctx2_dltx_inv_acct | character | |
| tctx2_dltx_inv_sub | character | |
| tctx2_ap_acct | character | |
| tctx2_ap_cn_acct | character | |
| tctx2_ap_cn_sub | character | |
| tctx2_ap_sub | character | |
| tctx2_apr_acct | character | |
| tctx2_apr_cn_acct | character | |
| tctx2_apr_cn_sub | character | |
| tctx2_apr_sub | character | |
| tltx2_apr_use | logical | |
| tctx2_dltx_cn_acct | character | |
| tdtx2d_abs_ret_amt | decimal(10) | |
| tdtx2d_cur_recov_amt | decimal(10) | |
| tdtx2d_cur_tax_amt | decimal(10) | |
| tctx2d_domain | character | |
| titx2d_line | integer | |
| tctx2d_nbr | character | |
| tltx2d_rcpt_tax_point | logical | |
| tctx2d_ref | character | |
| tdtx2d_tax_amt | decimal(10) | |
| tctx2d_tax_code | character | |
| tctx2d_tax_env | character | |
| tltx2d_tax_in | logical | |
| tctx2d_tax_type | character | |
| tctx2d_tax_usage | character | |
| tdtx2d_taxable_amt | decimal(10) | |
| tctx2d_taxc | character | |
| tdtx2d_totamt | decimal(10) | |
| tdtx2d_tottax | decimal(10) | |
| tctx2d_tr_type | character | |
| tctx2d_trl | character | |
| tltx2d_usage_tax_point | logical | |
| tctx2d_zone_from | character | |
| tctx2d_zone_to | character | |
| tctx2_domain | character | |
| tltx2_inv_disc | logical | |
| tdtx2_pct_recv | decimal(10) | |
| tltx2_rcpt_tax_point | logical | |
| tltx2_reverse_charge | logical | |
| tltx2_stx_dltx_use | logical | |
| tctx2_tax_code | character | |
| tdtx2_tax_pct | decimal(10) | |
| tltx2_update_tax | logical | |
| tltx2_usage_tax_point | logical | |
Internal usage
QadFinancials