objid | part_auth | objid | Part authorization internal record number | 3 (UNIQUE) |
locatn_objid | inv_locatn | objid | Inventory location internal record number | |
part_num_objid | part_num | objid | Part number internal record number | |
part_mod_objid | mod_level | objid | Part revision internal record number | |
bin_objid | inv_bin | objid | Inventory bin internal record number | |
location | inv_locatn | location_name | Name of the inventory location | |
description | inv_locatn | location_descr | Description of the inventory location | |
part_number | part_num | part_number | Part number/name | |
part_descr | part_num | description | Product description | |
active_cc_ind | part_auth | active_cc_ind | Indicates whether this mod level is active for cycle counting | |
abc_cd_cls | part_auth | abc_cd_cls | Calculated ABC classification code for cycle counting part instances | |
turn_ratio | part_auth | turn_ratio | Turn ratio for authorized parts included in a cycle count profile | |
last_cycle_ct | part_auth | last_cycle_ct | Date and time of last cycle count | |
average_usage | part_auth | average_usage | Part usage for authorized parts included in a cycle count profile. Reserved; future | |
last_calc_val | part_auth | last_calc_val | Last calculated valuation for the Cycle Count part | |
opn_ord_qty | part_auth | opn_ord_qty | Total quantity of the part currently on order for the bin | |
binname | inv_bin | bin_name | Name of the inventory bin | |
mod_level | mod_level | mod_level | Name of the part revision | |
cc_objid | cycle_count | objid | cycle count internal record number | |
cc_name | cycle_count | ct_name | cycle count name | |
part_good_qoh | part_auth | part_good_qoh | Good on hand quantity | |
part_bad_qoh | part_auth | part_bad_qoh | Bad on hand quantity | |
sn_track | part_num | sn_track | Part number/name | |
times_cc_ct | part_auth | times_cc_ct | Times this part has already been scheduled for this Cycle count | |