field name | data type | mnd. | description |
tx2_tax_code | character(80) | yes | Tax Code |
tx2_tax_type | character(30) | no | Tax Type |
tx2_pt_taxc | character(30) | no | Item Tax Class |
tx2_tax_usage | character(80) | no | Tax Usage |
tx2_effdate | date | no | Effective |
tx2_desc | character(80) | no | Description |
tx2_tax_pct | decimal(10) | no | Tax Rate |
tx2_method | character(30) | no | Tax Method |
tx2_by_line | logical | no | Tax-By-Line |
tx2_base | character(80) | no | Taxable Base Code |
tx2_min | decimal(10) | no | Minimum Taxable Amount |
tx2_max | decimal(10) | no | Maximum Taxable Amount |
tx2_mod_date | date | no | Modified Date |
tx2_userid | character(80) | no | User ID |
tx2_pct_recv | decimal(10) | no | Percent Recoverable |
tx2_trl_taxable | logical | no | Tax Trailer Amounts |
tx2_cmtindx | integer | no | Comment Index |
tx2_curr | character(30) | no | Currency |
tx2_inv_disc | logical | no | Discount Tax at Invoice |
tx2_pmt_disc | logical | no | Discount Tax at Payment |
tx2_update_tax | logical | no | Update Tax Allowed |
tx2_user1 | character(80) | no | Ufld1 |
tx2_user2 | character(80) | no | Ufld2 |
tx2__chr01 | character(80) | no | |
tx2__chr02 | character(80) | no | |
tx2__dec01 | decimal(10) | no | |
tx2__dec02 | decimal(10) | no | |
tx2__dte01 | date | no | |
tx2__log01 | logical | no | |
tx2__qad01 | character(80) | no | |
tx2__qad02 | character(80) | no | |
tx2__qad03 | logical | no | |
tx2__qad04 | decimal(10) | no | |
tx2__qad05 | date | no | |
tx2_rcpt_tax_point | logical | no | Accrue Tax at Receipt |
tx2_ar_acct | character(80) | no | AR Sales Tax Account |
tx2_ar_cc | character(30) | no | CC |
tx2_ara_acct | character(80) | no | AR Absorbed Tax Account |
tx2_ara_cc | character(30) | no | CC |
tx2_ara_use | logical | no | |
tx2_ap_acct | character(80) | no | AP Tax Account |
tx2_ap_cc | character(30) | no | CC |
tx2_apr_acct | character(80) | no | AP Retained Tax Account |
tx2_apr_cc | character(30) | no | CC |
tx2_apr_use | logical | no | |
tx2_tax_in | logical | no | Allow Tax Included |
tx2_exp_date | date | no | Expiration Date |
tx2_ec_sales_list | logical | no | EC Sales List |
tx2_ec_process_work | logical | no | EC Process Work |
tx2_apr_sub | character(80) | no | AP Retained Tax sub |
tx2_ap_sub | character(80) | no | AP Tax Sub-Account |
tx2_ara_sub | character(80) | no | AR Absorbed Tax Sub |
tx2_ar_sub | character(80) | no | AR Sales Tax Sub-Acct |
tx2_ap_disc_acct | character(80) | no | AP Discount Account |
tx2_ap_disc_cc | character(30) | no | CC |
tx2_ap_disc_sub | character(80) | no | AP Discount Sub-Account |
tx2_ar_disc_acct | character(80) | no | AR Discount Account |
tx2_ar_disc_cc | character(30) | no | CC |
tx2_ar_disc_sub | character(80) | no | AR Discount Sub-Account |
tx2_group | character(80) | no | Tax Group |
tx2_stx_acct | character(80) | no | Suspended Tax Account |
tx2_stx_cc | character(30) | no | CC |
tx2_stx_sub | character(80) | no | Suspended Tax Sub Account |
tx2_register | character(30) | no | Tax Register |
tx2_usage_tax_point | logical | no | Accrue Tax At Usage |
tx2_domain | character(8) | yes | Domain |
oid_tx2_mstr | decimal(10) | no | |
tx2_daybookset | character(8) | no | Daybook Set |
tx2_inv_tx_grp | character(30) | no | Customer Invoice Tax Group |
tx2_cn_tx_grp | character(30) | no | Customer Credit Note Tax Group |
tx2_voc_tx_grp | character(30) | no | Supplier Invoice Tax Group |
tx2_cr_voc_tx_grp | character(30) | no | Supplier CN Tax Group |
tx2_ab_inv_tx_grp | character(30) | no | Absorbed Inv Tax Group |
tx2_ab_cn_tx_grp | character(30) | no | Absorbed CN Tax Group |
tx2_ret_voc_tx_grp | character(30) | no | Retained Invoice Tax Group |
tx2_ret_cr_voc_tx_grp | character(30) | no | Retained CN Tax Group |
tx2_ar_cn_acct | character(80) | no | Sales Tax CN Account |
tx2_ar_cn_sub | character(80) | no | Sales Tax CN Sub-Account |
tx2_ap_cn_acct | character(80) | no | AP Tax CN Account |
tx2_ap_cn_sub | character(80) | no | AP Tax CN Sub-Account |
tx2_stx_inv_acct | character(80) | no | Suspended Tax Inv Account |
tx2_stx_inv_sub | character(80) | no | Suspended Tax Inv Sub-Account |
tx2_stx_cn_acct | character(80) | no | Suspended Tax CN Account |
tx2_stx_cn_sub | character(80) | no | Suspended Tax CN Sub-Account |
tx2_ar_dis_acct | character(80) | no | AR Discount Account |
tx2_ar_dis_sub | character(80) | no | AR Discount Sub-Account |
tx2_ap_dis_acct | character(80) | no | AP Discount Account |
tx2_ap_dis_sub | character(80) | no | AP Discount Sub-Account |
tx2_dltx_inv_acct | character(80) | no | Delayed Tax Invoice Account |
tx2_dltx_inv_sub | character(80) | no | Delayed Tax Invoice Sub-Account |
tx2_dltx_cn_acct | character(80) | no | Delayed Tax CN Account |
tx2_dltx_cn_sub | character(80) | no | Delayed Tax CN Sub-Account |
tx2_ara_cn_acct | character(80) | no | Sales Tax Abs CN Acct |
tx2_ara_cn_sub | character(80) | no | Sales Tax Abs CN Sub-Acct |
tx2_apr_cn_acct | character(80) | no | AP Tax Ret CN Account |
tx2_apr_cn_sub | character(80) | no | AP Tax Ret CN Sub-Account |
tx2_reverse_charge | logical | no | Domestic Reverse Charge |
tx2_stx_dltx_use | logical | no | Suspended/Delayed Taxes |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |