project QadFinancials > class BMfgTaxDetail > dataset BMfgTaxDetail

class dataset

object identification

primary key
tx2d_domain
tx2d_ref
tx2d_nbr
tx2d_line
tx2d_trl
tx2d_tr_type
tx2d_tax_code
alternate key
oid_tx2d_det

table ttx2d_det


field namedata typemnd.description
tx2d_refcharacter(80)yesReference
tx2d_nbrcharacter(80)noNumber
tx2d_lineintegeryesLine
tx2d_trlcharacter(30)noTrailer
tx2d_tr_typecharacter(30)yesTransaction Type
tx2d_tax_codecharacter(80)yesTax Code
tx2d_effdatedatenoTax Date
tx2d_totamtdecimal(10)noTotal Amount
tx2d_tottaxdecimal(10)noTaxable Sales
tx2d_currcharacter(30)noCurrency
tx2d_user1character(80)noUfld1
tx2d_user2character(80)noUfld2
tx2d__chr01character(80)no
tx2d__chr02character(80)no
tx2d__dec01decimal(10)no
tx2d__dec02decimal(10)no
tx2d__dte01dateno
tx2d__log01logicalno
tx2d__qad01character(80)no
tx2d__qad02character(80)no
tx2d_editedlogicalnoEdited
tx2d__qad04decimal(10)no
tx2d_posted_datedatenoPosted Date
tx2d_rcpt_tax_pointlogicalnoAccrue Tax at Receipt
tx2d_carriercharacter(80)noCarrier
tx2d_tax_envcharacter(30)noTax Environment
tx2d_zone_fromcharacter(30)noShip-From Tax Zone
tx2d_zone_tocharacter(30)noShip-To Tax Zone
tx2d_tax_typecharacter(30)noTax Type
tx2d_trans_entcharacter(30)noTransaction Entity
tx2d_line_site_entcharacter(30)noLine Site Entity
tx2d_taxccharacter(30)noTax Class
tx2d_tax_usagecharacter(80)noTax Usage
tx2d_tax_inlogicalnoTax In
tx2d_by_linelogicalnoTax-By-Line
tx2d_cur_tax_amtdecimal(10)noTax
tx2d_tax_amtdecimal(10)noBase Tax
tx2d_ent_tax_amtdecimal(10)noEntity Tax
tx2d_cur_nontax_amtdecimal(10)noNon-taxable
tx2d_nontax_amtdecimal(10)noBase Non-Taxable
tx2d_ent_nontax_amtdecimal(10)noEntity Non-Taxable
tx2d_taxable_amtdecimal(10)noBase Taxable
tx2d_cur_recov_amtdecimal(10)noRecoverable
tx2d_recov_amtdecimal(10)noBase Recoverable
tx2d_ent_recov_amtdecimal(10)noEntity Recoverable
tx2d_cur_abs_ret_amtdecimal(10)noAbsorbed/Retained
tx2d_abs_ret_amtdecimal(10)noBase Absorbed/Retained
tx2d_ent_abs_ret_amtdecimal(10)noEntity Absorbed/Retained
tx2d__qad03logicalno
tx2d__qad05dateno
tx2d_usage_tax_pointlogicalnoAccrue Tax At Usage
tx2d_domaincharacter(8)yesDomain
oid_tx2d_detdecimal(10)no
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter