project QadFinancials > class BMfgLocationDet > dataset BMfgLocationDet

class dataset

object identification

primary key
ld_domain
ld_site
ld_loc
ld_part
ld_lot
ld_ref

table tld_det


field namedata typemnd.description
ld_loccharacter(80)noLocation
ld_partcharacter(30)yesItem Number
ld_datedatenoDate Created
ld_qty_ohdecimal(10)noQty On Hand
ld_lotcharacter(30)noLot/Serial
ld_refcharacter(80)noRef
ld_cnt_datedatenoLast Count
ld_assaydecimal(10)noAssay %
ld_expiredatenoExpire Date
ld_user1character(80)noUfld1
ld_user2character(80)noUfld2
ld_sitecharacter(80)noSite
ld_statuscharacter(80)noInventory Status
ld_qty_alldecimal(10)noQty Allocated
ld_gradecharacter(30)noGrade
ld_qty_frzdecimal(10)noFreeze Qty
ld_date_frzdatenoFreeze Date
ld_vd_lotcharacter(30)noNot Used
ld_cmtindxintegernoComment Index
ld_workdecimal(10)no
ld__chr01character(80)no
ld__chr02character(80)no
ld__chr03character(80)no
ld__chr04character(80)no
ld__chr05character(80)no
ld__dte01dateno
ld__dte02dateno
ld__dec01decimal(10)no
ld__dec02decimal(10)no
ld__log01logicalno
ld_costdecimal(10)no
ld_revcharacter(30)noRev
ld_cust_consign_qtydecimal(10)noCustomer Consignment Qty
ld_supp_consign_qtydecimal(10)noSupplier Consignment Qty
ld_domaincharacter(8)yesDomain
oid_ld_detdecimal(10)no
ld_alt_umcharacter(30)noAlternate UM
ld_crt_timeintegernoCreate Time
ld_crt_datedatenoCreate Date
ld_exp_qtyindecimal(10)noQty In
ld_exp_qtyoutdecimal(10)noQty Out
ld_time_frzintegernoFreeze Time
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