| Table Name: | inv_bin |
| Table Number: | 243 |
| Group: | Logistics |
| Description: | A physical or logical location within an inventory location for the storage of parts |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | LONG | smallint | 1 | DIRECT | Indicates whether the bin is in use; i.e., 0=inactive, 1=active, default=1 | Search (2) | ||
| bin_name | CHAR | varchar | 20 | Unique name of the inventory bin within an inventory location | Search (15) | |||
| bin_type | LONG | smallint | 0 | DIRECT | User-defined type of bins; i.e., 0=fixed bin, 1=container, 2=pallet, default=0 | Search (1) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| fixed_bin_name | CHAR | varchar | 20 | For containers, the name of the fixed bin within which the container resides, for fixed bins this field is blank, default=' ' | Search (2) | |||
| fixed_ind | LONG | tinyint | 0 | DIRECT | Indicates whether the bin is movable or not; i.e., 0=no it is fixed, 1=yes, it is moveable, default=0 | Search (1) | ||
| gl_acct_no | CHAR | varchar | 20 | The GL account of the inventory bin. This is the GL account of its parent inventory location | Search (2) | |||
| id_number | CHAR | varchar | 4 | 32 | Unique bin number assigned according to auto-numbering definition | Search (4) | ||
| inv_class | LONG | smallint | 0 | DIRECT | Parent inventory location; i.e., 0=an inventory location, 1=a capital GL account, 2=expense GL account | |||
| location_name | CHAR | varchar | 40 | Name of the inventory location in which the bin is located | Search (4) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (15) | ||
| opened_ind | LONG | tinyint | 1 | DIRECT | 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 | Search (3) | ||
| prior_active | LONG | smallint | 1 | DIRECT | Indicates whether the bin was in use prior to being inactivated for physical inventory; i.e., 0=was inactive, 1=was active, default=1 |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| inv_bin2bin_role | OTM | bin_role | bin_role2inv_bin | Used for the bin that has been staged for an inventory update stemming from a part used activity. Removed once the update has occurred | |||
| setup2count_setup | MTM | count_setup | setup2inv_bin | Inventory profiles involving the inventory bin | mtm_inv_bin7_ count_setup0 | ||
| inv_bin2demand_dtl | OTM | demand_dtl | demand_dtl2inv_bin | Parts requests which requested the inventory bin as their destination bin | |||
| child2inv_bin | MTO | inv_bin | parent2inv_bin | For inventory bins, the child bins | Search (1) | ||
| parent2inv_bin | OTM | inv_bin | child2inv_bin | For inventory bins, the parent bin | |||
| movable_bin2inv_bin | MTO | inv_bin | fixed_bin2inv_bin | Fixed bin in which the container (moveable bin) is located | Search (1) | ||
| fixed_bin2inv_bin | OTM | inv_bin | movable_bin2inv_bin | Containers (moveable bins) located in the fixed bin | |||
| inv_bin2inv_ctrl | MTO | inv_ctrl | inv_ctrl2inv_bin | Inventory control group for the bin | |||
| inv_bin2inv_locatn | MTO | inv_locatn | inv_locatn2inv_bin | Inventory location in which the bin is located | Search (13) | ||
| inv_bin2part_auth | OTM | part_auth | part_auth2inv_bin | Authorized part stocking levels for the bin | |||
| inv_bin2part_inst | OTM | part_inst | part_inst2inv_bin | Parts in the bin | |||
| from_bin2part_trans | OTM | part_trans | from_bin2inv_bin | Bin that is credited, the FROM bin, in a parts movement | |||
| to_bin2part_trans | OTM | part_trans | to_bin2inv_bin | Bin that is debited, the TO bin, in a parts movement | |||
| from_fixed2part_trans | OTM | part_trans | from_fixed2inv_bin | Fixed bin that is credited, the FROM bin, in a parts movement when the transfer involves a container. For fixed bin to fixed bin transfers defaults to from_bin2part_trans | |||
| to_fixed2part_trans | OTM | part_trans | to_fixed2inv_bin | Fixed bin that is debited, the TO bin, in a parts movement. For fixed bin to fixed bin transfers defaults to to_bin2part_trans |
| Index Name | Fields | Flags |
|---|---|---|
| inv_bin_index | bin_name:inv_bin2inv_locatn:id_number | UNIQUE |
| inv_bin_loc_name_ind | bin_name:location_name:id_number | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_inv_bin2inv_locatn | inv_bin2inv_locatn, bin_name | nonclustered located on PRIMARY |
| ind_loc_name | location_name, bin_name | nonclustered located on PRIMARY |
| inv_bin_index | bin_name, inv_bin2inv_locatn, id_number | nonclustered, unique located on PRIMARY |
| inv_bin_loc_name_ind | bin_name, location_name, id_number | nonclustered, unique located on PRIMARY |
| m2ib0243 | movable_bin2inv_bin | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| inv_bin | |||