count_objid | count_setup | objid | Count setup internal record number | |
count_name | count_setup | count_name | The name of this inventory reconciliation count profile | |
count_status | count_setup | status | The status of this reconciliation count profile | |
objid | inv_count | objid | Inventory count internal record number | 3 (UNIQUE) |
count_part_no | inv_count | count_part_no | Tag ID for the recount | |
gen_date | inv_count | gen_date | The date this count was initialized | |
count_date | inv_count | count_date | The date this count was counted | |
recount_date | inv_count | recount_date | The date this count was recounted | |
reconcile_date | inv_count | reconcile_date | The date this count was reconciled | |
tag_count | inv_count | tag_count | Tag ID for the initial count | |
tag_recount | inv_count | tag_recount | Tag ID for the recount | |
rev_perpetual | inv_count | rev_perpetual | The part revision number in the system | |
rev_counted | inv_count | rev_counted | The part revision number physically counted | |
sn_perpetual | inv_count | sn_perpetual | For parts tracked by serial number, the part serial number in the system | |
sn_counted | inv_count | sn_counted | For parts tracked by serial number, the part serial number physically counted | |
qty_good_perp | inv_count | qty_good_perp | For parts tracked by quantity, the good quantity currently in the system | |
qty_good_count | inv_count | qty_good_count | For parts tracked by quantity, the good quantity physically counted | |
qty_bad_perp | inv_count | qty_bad_perp | For parts tracked by quantity, the bad quantity currently in the system | |
qty_bad_count | inv_count | qty_bad_count | For parts tracked by quantity, the bad quantity physically counted | |
inv_loc_perp | inv_count | inv_loc_perp | The inventory location currently in the system | |
inv_loc_count | inv_count | inv_loc_count | The inventory location the part was counted in | |
inv_bin_perp | inv_count | inv_bin_perp | The inventory bin the part is in according to the system | |
inv_bin_count | inv_count | inv_bin_count | The inventory bin the part was counted in | |
std_cost_perp | inv_count | std_cost_perp | Active Std Cost of the mod_level from part_inst | |
std_cost_count | inv_count | std_cost_count | Active Std Cost of the mod_level that was counted | |
ext_cost_perp | inv_count | ext_cost_perp | Extended cost of the original quantity of parts | |
ext_cost_count | inv_count | ext_cost_count | Extended cost of the counted quantity of parts | |
counted_by | counted_by(user) | login_name | Login name of the user who did the count | |
entered_by | entered_by(user) | login_name | Login name of the user who entered the count in the system | |
recounted_by | recounted_by(user) | login_name | Login name of the user who did the recount | |
init_by | init_by(user) | login_name | Login name of the user who initialized the count | |
status | inv_count | status | Internal status of this count | |
trial_by | trial_by(user) | login_name | Login name of the user who did the last trial reconciliation | |
qty_good_final | inv_count | qty_good_final | The good quantity reconciled | |
qty_bad_final | inv_count | qty_bad_final | The bad quantity reconciled | |
std_cost_final | inv_count | std_cost_final | Active Std Cost of the mod_level that was reconciled | |
ext_cost_final | inv_count | ext_cost_final | Extended Std Cost of the mod_level that was reconciled | |
reinit_date | inv_count | reinit_date | Date the inv_count was re-initialized | |
trial_date | inv_count | trial_date | Last date the inv_count had trial reconciliation done | |
bin_objid_perp | inv_count | bin_objid_perp | Objid of perpetual inv bin | |
id_number | inv_count | id_number | Unique bin number assigned according to auto-numbering definition | |
opened_ind | inv_count | opened_ind | Indicates 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_type | inv_count | bin_type | User-defined type of bins; i.e., 0=fixed bin, 1=container, 2=pallet, default=0 | |
mv_bin_perp | inv_count | mv_bin_perp | The movable inventory bin the part is in according to the system | |
mv_objid_perp | inv_count | mv_objid_perp | Objid of perpetual movable inv bin | |
count_id | count_setup | count_id | The unique identifier for this inventory reconciliation count profile | |
comments | inv_count | comments | Notes about count transaction | |
blank_tag | inv_count | blank_tag | Identifies whether this tag was generated for a blank tag | |
vi_trans_in | inv_count | vi_trans_in | Virtual transactions INTO bin/container | |
vi_trans_out | inv_count | vi_trans_out | Virtual transactions OUT OF bin/container | |
abc_cd_cls | inv_count | abc_cd_cls | ABC classification assigned to the part | |