Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
bin_id | NUMBER | 39 | 0 | Bin number ID | |||
bin_number | VARCHAR2 | 100 | Bin number | ||||
bin_number_extid | VARCHAR2 | 255 | Bin number external ID | ||||
isinactive | VARCHAR2 | 3 | Inactive | ||||
ispreferred | VARCHAR2 | 3 | Preferred | ||||
item_id | NUMBER | 39 | 0 | Item ID | |||
location_id | NUMBER | 39 | 0 | Location ID | |||
memo | VARCHAR2 | 4000 | Memo | ||||
on_hand_count | NUMBER | 39 | 0 | On hand count |