project QadFinancials > class BMfgInventoryTransaction > dataset BMfgInventoryTransaction

class dataset

object identification

primary key
tr_domain
tr_trnbr

table ttr_hist


field namedata typemnd.description
tr_partcharacter(30)noItem Number
tr_datedatenoDate
tr_per_datedatenoPerformance Date
tr_typecharacter(80)noTrans Type
tr_loccharacter(80)noLoc
tr_loc_begindecimal(10)noBegin Loc Bal
tr_begin_qohdecimal(10)noBegin Balance
tr_qty_reqdecimal(10)noQty Required
tr_qty_chgdecimal(10)noQty Change
tr_qty_shortdecimal(10)noQty Short
tr_umcharacter(30)noUM
tr_last_datedatenoLast Activity
tr_nbrcharacter(30)noOrder
tr_so_jobcharacter(80)noSales/Job
tr_ship_typecharacter(30)noShip Type
tr_addrcharacter(80)noAddress
tr_rmkscharacter(80)noRemarks
tr_xdr_acctcharacter(80)noNot used. Dr Acct
tr_xcr_acctcharacter(80)noNot Used. Cr Acct
tr_mtl_stddecimal(10)noMaterial
tr_lbr_stddecimal(10)noLabor
tr_bdn_stddecimal(10)noBurden
tr_pricedecimal(10)noPrice
tr_trnbrintegernoTrans
tr_gl_amtdecimal(10)noAmount
tr_xdr_cccharacter(30)noNot used. Dr Cost Ctr
tr_xcr_cccharacter(30)noNot Used. Cr Cost Ctr
tr_lotcharacter(80)noID
tr_sub_stddecimal(10)noSubcontract
tr_gl_datedatenoGL Date
tr_qty_locdecimal(10)noLoc Qty Change
tr_useridcharacter(80)noUser ID
tr_serialcharacter(50)noLot/Serial
tr_effdatedatenoEffective
tr_prod_linecharacter(30)noProduct Line
tr_xslspsn1character(80)noSalesperson 1
tr_xslspsn2character(80)noSalesperson 2
tr_xcr_projcharacter(80)noNot used. Cr Project
tr_xdr_projcharacter(80)noNot used. Dr Project
tr_lineintegernoLine
tr_user1character(80)noUfld1
tr_user2character(80)noUfld2
tr_currcharacter(30)noCurrency
tr_ex_ratedecimal(10)noExch Rate
tr_revcharacter(30)noRev
tr_timeintegernoTime
tr_ovh_stddecimal(10)noOverhead
tr_sitecharacter(80)noSite
tr_statuscharacter(80)noInventory Status
tr_gradecharacter(30)noGrade
tr_expiredatenoExpire Date
tr_assaydecimal(10)noAssay %
tr_xgl_refcharacter(30)noNot used. GL Reference
tr__chr01character(80)no
tr__chr02character(80)no
tr__chr03character(80)no
tr__chr04character(80)no
tr__chr05character(80)no
tr__chr06character(80)no
tr__chr07character(80)no
tr__chr08character(80)no
tr__chr09character(80)no
tr__chr10character(80)no
tr__chr11character(80)no
tr__chr12character(80)no
tr__chr13character(80)no
tr__chr14character(80)no
tr__chr15character(80)no
tr__dte01dateno
tr__dte02dateno
tr__dte03dateno
tr__dte04dateno
tr__dte05dateno
tr__dec01decimal(10)no
tr__dec02decimal(10)no
tr__dec03decimal(10)no
tr__dec04decimal(10)no
tr__dec05decimal(10)no
tr__log01logicalno
tr__log02logicalno
tr_refcharacter(80)noRef
tr_msgintegernoMessage Number
tr_programcharacter(30)noProgram
tr_ord_revintegernoRevision
tr_ref_sitecharacter(80)noReference Site
tr_rsn_codecharacter(80)noReason
tr_vend_lotcharacter(30)noSupplier Lot
tr_vend_datedatenoSupplier Production Date
tr_daycodecharacter(80)noDay Code
tr_forcharacter(30)noService Part
tr_fsm_typecharacter(80)noFSM Type
tr_upd_isblogicalno
tr_auto_installlogicalnoAuto Installed
tr_ca_int_typecharacter(80)noWork Code
tr_covered_amtdecimal(10)noCovered Amount
tr_fcg_codecharacter(80)noCharge Code
tr_batchcharacter(30)noBatch
tr_fsc_codecharacter(80)noService Category
tr_sa_nbrcharacter(80)noContract
tr_sv_codecharacter(80)noContract Type
tr_eng_areacharacter(30)noService Area
tr_sys_prodcharacter(30)noSystem Product Line
tr_svc_typecharacter(30)no
tr_ca_opn_datedateno
tr_cpricedecimal(10)noPrice
tr_eng_codecharacter(80)noEngineer Code
tr_wod_opintegernoOperation
tr_endusercharacter(80)noEnd User
tr_ship_inv_movcharacter(80)noInventory Movement Code
tr_ship_datedatenoShip Date
tr_ship_idcharacter(30)noShipper Number
tr_ex_rate2decimal(10)noExch Rate 2
tr_ex_ratetypecharacter(80)noRate Type
tr_exru_seqintegernoSequence
tr_promise_datedatenoPromise Date
tr_fldchg_cmtindxintegernoComment
tr_domaincharacter(8)yesDomain
oid_tr_histdecimal(10)no
tr_qty_cn_adjdecimal(10)noConsignment Qty Adjusted
tr_doc_idcharacter(24)noDocument ID
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table ttrgl_det


field namedata typemnd.description
trgl_cr_acctcharacter(80)noCr Acct
trgl_cr_cccharacter(30)noCr Cost Ctr
trgl_dr_acctcharacter(80)noDr Acct
trgl_dr_cccharacter(30)noDr Cost Ctr
trgl_trnbrintegernoTransaction
trgl_gl_amtdecimal(10)noAmount
trgl_gl_refcharacter(30)noGL Reference
trgl_typecharacter(80)noType
trgl_cr_projcharacter(80)noCr Project
trgl_dr_projcharacter(80)noDr Project
trgl_cr_lineintegernoLine
trgl_dr_lineintegernoLine
trgl_user1character(80)noUfld1
trgl_user2character(80)noUfld2
trgl_sequenceintegernoSequence
trgl__qadc01character(80)no
trgl_dy_codecharacter(80)noDaybook
trgl_dy_numcharacter(80)noEntry Number
trgl_cr_subcharacter(80)noCr Sub-Acct
trgl_dr_subcharacter(80)noDr Sub-Acct
trgl_domaincharacter(8)yesDomain
oid_trgl_detdecimal(10)no
trgl_eff_translogicalnoCurrent
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = ttr_hist.tc_Rowid
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