View Name:reconcilecnt
View Number:5178
Group:Logistics
Description:Used by the inventory Reconcile Count form (8412)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
count_objidcount_setupobjidCount setup internal record number 
count_namecount_setupcount_nameThe name of this inventory reconciliation count profile 
count_statuscount_setupstatusThe status of this reconciliation count profile 
objidinv_countobjidInventory count internal record number 3 (UNIQUE)
count_part_noinv_countcount_part_noTag ID for the recount 
gen_dateinv_countgen_dateThe date this count was initialized 
count_dateinv_countcount_dateThe date this count was counted 
recount_dateinv_countrecount_dateThe date this count was recounted 
reconcile_dateinv_countreconcile_dateThe date this count was reconciled 
tag_countinv_counttag_countTag ID for the initial count 
tag_recountinv_counttag_recountTag ID for the recount 
rev_perpetualinv_countrev_perpetualThe part revision number in the system 
rev_countedinv_countrev_countedThe part revision number physically counted 
sn_perpetualinv_countsn_perpetualFor parts tracked by serial number, the part serial number in the system 
sn_countedinv_countsn_countedFor parts tracked by serial number, the part serial number physically counted 
qty_good_perpinv_countqty_good_perpFor parts tracked by quantity, the good quantity currently in the system 
qty_good_countinv_countqty_good_countFor parts tracked by quantity, the good quantity physically counted 
qty_bad_perpinv_countqty_bad_perpFor parts tracked by quantity, the bad quantity currently in the system 
qty_bad_countinv_countqty_bad_countFor parts tracked by quantity, the bad quantity physically counted 
inv_loc_perpinv_countinv_loc_perpThe inventory location currently in the system 
inv_loc_countinv_countinv_loc_countThe inventory location the part was counted in 
inv_bin_perpinv_countinv_bin_perpThe inventory bin the part is in according to the system 
inv_bin_countinv_countinv_bin_countThe inventory bin the part was counted in 
std_cost_perpinv_countstd_cost_perpActive Std Cost of the mod_level from part_inst 
std_cost_countinv_countstd_cost_countActive Std Cost of the mod_level that was counted 
ext_cost_perpinv_countext_cost_perpExtended cost of the original quantity of parts 
ext_cost_countinv_countext_cost_countExtended cost of the counted quantity of parts 
counted_bycounted_by(user)login_nameLogin name of the user who did the count 
entered_byentered_by(user)login_nameLogin name of the user who entered the count in the system 
recounted_byrecounted_by(user)login_nameLogin name of the user who did the recount 
init_byinit_by(user)login_nameLogin name of the user who initialized the count 
statusinv_countstatusInternal status of this count 
trial_bytrial_by(user)login_nameLogin name of the user who did the last trial reconciliation 
qty_good_finalinv_countqty_good_finalThe good quantity reconciled 
qty_bad_finalinv_countqty_bad_finalThe bad quantity reconciled 
std_cost_finalinv_countstd_cost_finalActive Std Cost of the mod_level that was reconciled 
ext_cost_finalinv_countext_cost_finalExtended Std Cost of the mod_level that was reconciled 
reinit_dateinv_countreinit_dateDate the inv_count was re-initialized 
trial_dateinv_counttrial_dateLast date the inv_count had trial reconciliation done 
bin_objid_perpinv_countbin_objid_perpObjid of perpetual inv bin 
id_numberinv_countid_numberUnique bin number assigned according to auto-numbering definition 
opened_indinv_countopened_indIndicates whether the bin allows parts to be moved in/out or not; i.e, 0=no, it s sealed, 1=yes it is opened, default=1 
bin_typeinv_countbin_typeUser-defined type of bins; i.e., 0=fixed bin, 1=container, 2=pallet, default=0 
mv_bin_perpinv_countmv_bin_perpThe movable inventory bin the part is in according to the system 
mv_objid_perpinv_countmv_objid_perpObjid of perpetual movable inv bin 
count_idcount_setupcount_idThe unique identifier for this inventory reconciliation count profile 
commentsinv_countcommentsNotes about count transaction 
blank_taginv_countblank_tagIdentifies whether this tag was generated for a blank tag 
vi_trans_ininv_countvi_trans_inVirtual transactions INTO bin/container 
vi_trans_outinv_countvi_trans_outVirtual transactions OUT OF bin/container 
abc_cd_clsinv_countabc_cd_clsABC classification assigned to the part 

Joins:

Join FromJoin To
(inv_count).count2count_setup(count_setup).setup2inv_count
(inv_count).init_by2userinit_by(user).init_by2inv_count
(inv_count).entered_by2userOUTER entered_by(user).entered_by2inv_count
(inv_count).counted_by2userOUTER counted_by(user).counted_by2inv_count
(inv_count).recounted_by2userOUTER recounted_by(user).recounted_by2inv_count
(inv_count).trial_by2userOUTER trial_by(user).trial_by2inv_count
My Recent Objects
reconcilecnt