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 | |
authorized | inv_locatn | trans_auth | The type of transactions authorized for the inventory location; i.e., 0=All, 1=None, 2=Authorized Parts only. An authorized part is one for which there is a part_auth object | |
status | mod_level | active | Active/inactive/obsolete | |
opn_ord_qty | part_auth | opn_ord_qty | Total quantity of the part currently on order for the bin | |
allocate_exch | part_auth | allocate_exch | Reserved; future | |
allocate_repln | part_auth | allocate_repln | Reserved; future | |
allocate_other | part_auth | allocate_other | Reserved; future | |
part_rol | part_auth | part_rol | Reserved; future | |
part_roq | part_auth | part_roq | Reserved; future | |
part_maximum | part_auth | part_maximum | Maximum quantity that auto replenishment will fill | |
part_minimum | part_auth | part_minimum | Minimum quanty permitted before auto replenishment | |
hard_salelimit | part_auth | hard_salelimit | Reserved; future | |
hard_exchlimit | part_auth | hard_exchlimit | Reserved; future | |
hard_repllimit | part_auth | hard_repllimit | Reserved; future | |
binname | inv_bin | bin_name | Name of the inventory bin | |
part_num | part_num | description | Description of the product | |
repl_queue | part_auth | repl_queue | Default queue to which the auto replenishment part request will be dispatched | |
mod_level | mod_level | mod_level | Name of the part revision | |
primary_ind | part_auth | primary_ind | Indicates whether the related bin is the primary bin for the related part revision within the bin's inventory location; i.e., 0=no, 1=yes, default=0 | |
turn_ratio | part_auth | turn_ratio | Turn ratio for authorized parts included in a cycle count profile | |
abc_cd_cls | part_auth | abc_cd_cls | Calculated ABC classification code for cycle counting part instances | |
part_good_qoh | part_auth | part_good_qoh | Stores the cumulative part good quantity on hand for the part/location/bin | |
part_bad_qoh | part_auth | part_bad_qoh | Stores the cumulative part bad quantity on hand for the part/location/bin | |
active | part_auth | active | Indicates whether the current part authorization is active; i.e., 0=inactive, 1=active, default=1 | |
active_cc_ind | part_auth | active_cc_ind | Indicates whether this PSL is active for Cycle Counting; i.e., 0=no, 1=yes, default=0 | |