| field name | data type | description |
|---|---|---|
| tlTx2UpdateTax | logical | Update tax flag of tx2_mstr |
| tlTx2InvoiceDisc | logical | |
| tdTx2TaxPerc | decimal | |
| tdTx2RecovTaxPerc | decimal | |
| tcTx2APGL | character | |
| tcTx2APDivision | character | |
| tcTx2APRGL | character | |
| tcTx2APRDivision | character | |
| tcTx2ARGL | character | |
| tcTx2ARDivision | character | |
| tcTx2ARAGL | character | |
| tcTx2ARADivision | character | |
| tcTx2APCNGL | character | |
| tcTx2APCNDivision | character | |
| tcTx2APRCNGL | character | |
| tcTx2APRCNDivision | character | |
| tcTx2ARCNGL | character | |
| tcTx2ARCNDivision | character | |
| tcTx2ARACNGL | character | |
| tcTx2ARACNDivision | character | |
| tlTx2ReverseCharge | logical | |
| tctx2DelayAPCNDivision | character | |
| tctx2DelayAPCNGL | character | |
| tctx2DelayAPDivision | character | |
| tctx2DelayAPGL | character | |
| tctx2SuspARCNDivision | character | |
| tctx2SuspARCNGL | character | |
| tctx2SuspARDivision | character | |
| tctx2SuspARGL | character | |
| tltx2SuspDelayTax | logical | |
| tlIsAvataxLine | logical | |
| tx2d_ref | character | |
| tx2d_nbr | character | |
| tx2d_line | integer | |
| tx2d_trl | character | |
| tx2d_tr_type | character | |
| tx2d_tax_code | character | |
| tx2d_effdate | date | |
| tx2d_totamt | decimal(10) | |
| tx2d_tottax | decimal(10) | |
| tx2d_curr | character | |
| tx2d_user1 | character | |
| tx2d_user2 | character | |
| tx2d__chr01 | character | |
| tx2d__chr02 | character | |
| tx2d__dec01 | decimal(10) | |
| tx2d__dec02 | decimal(10) | |
| tx2d__dte01 | date | |
| tx2d__log01 | logical | |
| tx2d__qad01 | character | |
| tx2d__qad02 | character | |
| tx2d_edited | logical | |
| tx2d__qad04 | decimal(10) | |
| tx2d_posted_date | date | |
| tx2d_rcpt_tax_point | logical | |
| tx2d_carrier | character | |
| tx2d_tax_env | character | |
| tx2d_zone_from | character | |
| tx2d_zone_to | character | |
| tx2d_tax_type | character | |
| tx2d_trans_ent | character | |
| tx2d_line_site_ent | character | |
| tx2d_taxc | character | |
| tx2d_tax_usage | character | |
| tx2d_tax_in | logical | |
| tx2d_by_line | logical | |
| tx2d_cur_tax_amt | decimal(10) | |
| tx2d_tax_amt | decimal(10) | |
| tx2d_ent_tax_amt | decimal(10) | |
| tx2d_cur_nontax_amt | decimal(10) | |
| tx2d_nontax_amt | decimal(10) | |
| tx2d_ent_nontax_amt | decimal(10) | |
| tx2d_taxable_amt | decimal(10) | |
| tx2d_cur_recov_amt | decimal(10) | |
| tx2d_recov_amt | decimal(10) | |
| tx2d_ent_recov_amt | decimal(10) | |
| tx2d_cur_abs_ret_amt | decimal(10) | |
| tx2d_abs_ret_amt | decimal(10) | |
| tx2d_ent_abs_ret_amt | decimal(10) | |
| tx2d__qad03 | logical | |
| tx2d__qad05 | date | |
| tx2d_usage_tax_point | logical | |
| tx2d_domain | character | |
| oid_tx2d_det | decimal(10) | |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials