| field name | data type | mnd. | description |
|---|---|---|---|
| tx2d_ref | character(80) | yes | Reference |
| tx2d_nbr | character(80) | no | Number |
| tx2d_line | integer | yes | Line |
| tx2d_trl | character(30) | no | Trailer |
| tx2d_tr_type | character(30) | yes | Transaction Type |
| tx2d_tax_code | character(80) | yes | Tax Code |
| tx2d_effdate | date | no | Tax Date |
| tx2d_totamt | decimal(10) | no | Total Amount |
| tx2d_tottax | decimal(10) | no | Taxable Sales |
| tx2d_curr | character(30) | no | Currency |
| tx2d_user1 | character(80) | no | Ufld1 |
| tx2d_user2 | character(80) | no | Ufld2 |
| tx2d__chr01 | character(80) | no | |
| tx2d__chr02 | character(80) | no | |
| tx2d__dec01 | decimal(10) | no | |
| tx2d__dec02 | decimal(10) | no | |
| tx2d__dte01 | date | no | |
| tx2d__log01 | logical | no | |
| tx2d__qad01 | character(80) | no | |
| tx2d__qad02 | character(80) | no | |
| tx2d_edited | logical | no | Edited |
| tx2d__qad04 | decimal(10) | no | |
| tx2d_posted_date | date | no | Posted Date |
| tx2d_rcpt_tax_point | logical | no | Accrue Tax at Receipt |
| tx2d_carrier | character(80) | no | Carrier |
| tx2d_tax_env | character(30) | no | Tax Environment |
| tx2d_zone_from | character(30) | no | Ship-From Tax Zone |
| tx2d_zone_to | character(30) | no | Ship-To Tax Zone |
| tx2d_tax_type | character(30) | no | Tax Type |
| tx2d_trans_ent | character(30) | no | Transaction Entity |
| tx2d_line_site_ent | character(30) | no | Line Site Entity |
| tx2d_taxc | character(30) | no | Tax Class |
| tx2d_tax_usage | character(80) | no | Tax Usage |
| tx2d_tax_in | logical | no | Tax In |
| tx2d_by_line | logical | no | Tax-By-Line |
| tx2d_cur_tax_amt | decimal(10) | no | Tax |
| tx2d_tax_amt | decimal(10) | no | Base Tax |
| tx2d_ent_tax_amt | decimal(10) | no | Entity Tax |
| tx2d_cur_nontax_amt | decimal(10) | no | Non-taxable |
| tx2d_nontax_amt | decimal(10) | no | Base Non-Taxable |
| tx2d_ent_nontax_amt | decimal(10) | no | Entity Non-Taxable |
| tx2d_taxable_amt | decimal(10) | no | Base Taxable |
| tx2d_cur_recov_amt | decimal(10) | no | Recoverable |
| tx2d_recov_amt | decimal(10) | no | Base Recoverable |
| tx2d_ent_recov_amt | decimal(10) | no | Entity Recoverable |
| tx2d_cur_abs_ret_amt | decimal(10) | no | Absorbed/Retained |
| tx2d_abs_ret_amt | decimal(10) | no | Base Absorbed/Retained |
| tx2d_ent_abs_ret_amt | decimal(10) | no | Entity Absorbed/Retained |
| tx2d__qad03 | logical | no | |
| tx2d__qad05 | date | no | |
| tx2d_usage_tax_point | logical | no | Accrue Tax At Usage |
| tx2d_domain | character(8) | yes | Domain |
| oid_tx2d_det | decimal(10) | no | |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |