| Name |
Datatype |
Length |
Prcn |
| INVENTORY_ITEM_FLAG |
VARCHAR2
|
(1)
|
|
| STOCK_ENABLED_FLAG |
VARCHAR2
|
(1)
|
|
| MTL_TRANSACTIONS_ENABLED_FL |
VARCHAR2
|
(1)
|
|
| CHECK_SHORTAGES_FLAG |
VARCHAR2
|
(1)
|
|
| REVISION_QTY_CONTROL_CODE |
NUMBER
|
|
|
| RESERVABLE_TYPE |
NUMBER
|
|
|
| SHELF_LIFE_CODE |
NUMBER
|
|
|
| SHELF_LIFE_DAYS |
NUMBER
|
|
|
| CYCLE_COUNT_ENABLED_FLAG |
VARCHAR2
|
(1)
|
|
| NEGATIVE_MEASUREMENT_ERROR |
NUMBER
|
|
|
| POSITIVE_MEASUREMENT_ERROR |
NUMBER
|
|
|
| LOT_CONTROL_CODE |
NUMBER
|
|
|
| AUTO_LOT_ALPHA_PREFIX |
VARCHAR2
|
(30)
|
|
| START_AUTO_LOT_NUMBER |
VARCHAR2
|
(30)
|
|
| SERIAL_NUMBER_CONTROL_CODE |
NUMBER
|
|
|
| AUTO_SERIAL_ALPHA_PREFIX |
VARCHAR2
|
(30)
|
|
| START_AUTO_SERIAL_NUMBER |
VARCHAR2
|
(30)
|
|
| LOCATION_CONTROL_CODE |
NUMBER
|
|
|
| RESTRICT_SUBINVENTORIES_COD |
NUMBER
|
|
|
| RESTRICT_LOCATORS_CODE |
NUMBER
|
|
|
| BULK_PICKED_FLAG |
VARCHAR2
|
(1)
|
|
| LOT_STATUS_ENABLED |
VARCHAR2
|
(1)
|
|
| SERIAL_STATUS_ENABLED |
VARCHAR2
|
(1)
|
|
| LOT_SPLIT_ENABLED |
VARCHAR2
|
(1)
|
|
| LOT_MERGE_ENABLED |
VARCHAR2
|
(1)
|
|
| LOT_TRANSLATE_ENABLED |
VARCHAR2
|
(1)
|
|
| LOT_SUBSTITUTION_ENABLED |
VARCHAR2
|
(1)
|
|
| CHILD_LOT_FLAG |
VARCHAR2
|
(1)
|
|
| CHILD_LOT_PREFIX |
VARCHAR2
|
(30)
|
|
| CHILD_LOT_STARTING_NUMBER |
NUMBER
|
|
|
| CHILD_LOT_VALIDATION_FLAG |
VARCHAR2
|
(1)
|
|
| COPY_LOT_ATTRIBUTE_FLAG |
VARCHAR2
|
(1)
|
|
| DEFAULT_GRADE |
VARCHAR2
|
(150)
|
|
| EXPIRATION_ACTION_CODE |
VARCHAR2
|
(32)
|
|
| EXPIRATION_ACTION_INTERVAL |
NUMBER
|
|
|
| GRADE_CONTROL_FLAG |
VARCHAR2
|
(1)
|
|
| HOLD_DAYS |
NUMBER
|
|
|
| LOT_DIVISIBLE_FLAG |
VARCHAR2
|
(1)
|
|
| MATURITY_DAYS |
NUMBER
|
|
|
| PARENT_CHILD_GENERATION_FLAG |
VARCHAR2
|
(1)
|
|
| RETEST_INTERVAL |
NUMBER
|
|
|