COLUMN NAME | DATA TYPE | DATA LENGTH | NULLABLE |
LAST_UPDATE_DATE | TIMESTAMP(6) | 11 | N |
FILL_KILL_TRANSFER_ORDERS_FLAG | VARCHAR2 | 4 | Y |
TRACK_COUNTRY_OF_ORIGIN_FLAG | VARCHAR2 | 4 | Y |
ORGANIZATION_ID | NUMBER | 22 | N |
LAST_UPDATED_BY | VARCHAR2 | 256 | N |
CREATION_DATE | TIMESTAMP(6) | 11 | N |
CREATED_BY | VARCHAR2 | 256 | N |
LAST_UPDATE_LOGIN | VARCHAR2 | 128 | Y |
ORGANIZATION_CODE | VARCHAR2 | 72 | Y |
MASTER_ORGANIZATION_ID | NUMBER | 22 | Y |
BUSINESS_UNIT_ID | NUMBER | 22 | Y |
LEGAL_ENTITY_ID | NUMBER | 22 | Y |
SCHEDULE_ID | NUMBER | 22 | Y |
DEFAULT_PICKING_RULE_ID | NUMBER | 22 | Y |
DEFAULT_LOCATOR_ORDER_VALUE | NUMBER | 22 | Y |
DEFAULT_SUBINV_ORDER_VALUE | NUMBER | 22 | Y |
NEGATIVE_INV_RECEIPT_CODE | NUMBER | 22 | Y |
STOCK_LOCATOR_CONTROL_CODE | VARCHAR2 | 120 | Y |
SOURCE_ORGANIZATION_ID | NUMBER | 22 | Y |
SOURCE_SUBINVENTORY | VARCHAR2 | 40 | Y |
SOURCE_TYPE | VARCHAR2 | 120 | Y |
SERIAL_NUMBER_TYPE | VARCHAR2 | 120 | Y |
AUTO_SERIAL_ALPHA_PREFIX | VARCHAR2 | 320 | Y |
START_AUTO_SERIAL_NUMBER | VARCHAR2 | 320 | Y |
AUTO_LOT_ALPHA_PREFIX | VARCHAR2 | 320 | Y |
LOT_NUMBER_UNIQUENESS | VARCHAR2 | 120 | Y |
LOT_NUMBER_GENERATION | VARCHAR2 | 120 | Y |
LOT_NUMBER_ZERO_PADDING | VARCHAR2 | 120 | Y |
LOT_NUMBER_LENGTH | NUMBER | 22 | Y |
STARTING_REVISION | VARCHAR2 | 72 | Y |
LPN_PREFIX | VARCHAR2 | 40 | Y |
LPN_SUFFIX | VARCHAR2 | 40 | Y |
LPN_STARTING_NUMBER | NUMBER | 22 | Y |
TOTAL_LPN_LENGTH | NUMBER | 22 | Y |
UCC_128_SUFFIX_FLAG | VARCHAR2 | 4 | Y |
ATTRIBUTE_CATEGORY | VARCHAR2 | 120 | Y |
ATTRIBUTE1 | VARCHAR2 | 600 | Y |
ATTRIBUTE2 | VARCHAR2 | 600 | Y |
ATTRIBUTE3 | VARCHAR2 | 600 | Y |
ATTRIBUTE4 | VARCHAR2 | 600 | Y |
ATTRIBUTE5 | VARCHAR2 | 600 | Y |
ATTRIBUTE6 | VARCHAR2 | 600 | Y |
ATTRIBUTE7 | VARCHAR2 | 600 | Y |
ATTRIBUTE8 | VARCHAR2 | 600 | Y |
ATTRIBUTE9 | VARCHAR2 | 600 | Y |
ATTRIBUTE10 | VARCHAR2 | 600 | Y |
ATTRIBUTE11 | VARCHAR2 | 600 | Y |
ATTRIBUTE12 | VARCHAR2 | 600 | Y |
ATTRIBUTE13 | VARCHAR2 | 600 | Y |
ATTRIBUTE14 | VARCHAR2 | 600 | Y |
ATTRIBUTE15 | VARCHAR2 | 600 | Y |
SERIAL_NUMBER_GENERATION | VARCHAR2 | 120 | Y |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 120 | Y |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | 600 | Y |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | 600 | Y |
MO_PICK_CONFIRM_REQUIRED | NUMBER | 22 | Y |
OVPK_TRANSFER_ORDERS_ENABLED | VARCHAR2 | 4 | Y |
ALLOCATE_SERIAL_FLAG | VARCHAR2 | 4 | Y |
DISTRIBUTED_ORGANIZATION_FLAG | VARCHAR2 | 4 | Y |
ALLOW_DIFFERENT_STATUS | NUMBER | 22 | Y |
CHILD_LOT_ALPHA_PREFIX | VARCHAR2 | 320 | Y |
CHILD_LOT_NUMBER_LENGTH | NUMBER | 22 | Y |
CHILD_LOT_VALIDATION_FLAG | VARCHAR2 | 4 | Y |
CHILD_LOT_ZERO_PADDING_FLAG | VARCHAR2 | 4 | Y |
COPY_LOT_ATTRIBUTE_FLAG | VARCHAR2 | 4 | Y |
CREATE_LOT_UOM_CONVERSION | NUMBER | 22 | Y |
PARENT_CHILD_GENERATION_FLAG | VARCHAR2 | 4 | Y |
AUTO_DEL_ALLOC_FLAG | VARCHAR2 | 4 | Y |
ENFORCE_LOCATOR_ALIS_UNQ_FLAG | VARCHAR2 | 4 | Y |
PRE_FILL_PICKED_QTY | VARCHAR2 | 4 | Y |
CAPTURE_PICKING_EXCEPTION | VARCHAR2 | 4 | Y |
INVENTORY_FLAG | VARCHAR2 | 4 | N |
OBJECT_VERSION_NUMBER | NUMBER | 22 | N |
QA_SKIPPING_INSP_FLAG | VARCHAR2 | 4 | Y |
WCS_ENABLED | VARCHAR2 | 4 | Y |
EAM_ENABLED_FLAG | VARCHAR2 | 4 | Y |
WMS_ENABLED_FLAG | VARCHAR2 | 4 | Y |
MAINT_ORGANIZATION_ID | NUMBER | 22 | Y |
TRADING_PARTNER_ORG_FLAG | VARCHAR2 | 4 | Y |
PREGEN_PUTAWAY_TASKS_FLAG | NUMBER | 22 | Y |
REGENERATION_INTERVAL | NUMBER | 22 | Y |
TIMEZONE_ID | NUMBER | 22 | Y |
DEFAULT_WMS_PICKING_RULE_ID | NUMBER | 22 | Y |
DEFAULT_PUT_AWAY_RULE_ID | NUMBER | 22 | Y |
DEFAULT_CARTON_RULE_ID | NUMBER | 22 | Y |
DEFAULT_CYC_COUNT_HEADER_ID | NUMBER | 22 | Y |
CROSSDOCK_FLAG | NUMBER | 22 | Y |
CARTONIZATION_FLAG | NUMBER | 22 | Y |
PROJECT_REFERENCE_ENABLED | NUMBER | 22 | Y |
PROJECT_CONTROL_LEVEL | NUMBER | 22 | Y |
PM_COST_COLLECTION_ENABLED | NUMBER | 22 | Y |
JOB_DEFINITION_NAME | VARCHAR2 | 400 | Y |
JOB_DEFINITION_PACKAGE | VARCHAR2 | 3600 | Y |
REQUEST_ID | NUMBER | 22 | Y |
PICK_QTY_DEFAULT_REASON_ID | NUMBER | 22 | Y |
FIFO_ORIG_RCPT_DATE_FLAG | VARCHAR2 | 4 | Y |
ALLOW_NEG_ONHAND_CC_TXNS | VARCHAR2 | 4 | Y |
PURCHASING_BY_REVISION | VARCHAR2 | 4 | Y |
ROUND_REORDER_QTY_FLAG | VARCHAR2 | 4 | Y |
REPLNSH_MOVE_ORDER_GROUPING | NUMBER | 22 | Y |
FILL_KILL_MOVE_ORDER_FLAG | VARCHAR2 | 4 | Y |
PICK_SLIP_BATCH_SIZE | NUMBER | 22 | Y |
STANDARD_PACK_ENABLED | NUMBER | 22 | Y |
AUTO_BREAKDOWN_ENABLED | VARCHAR2 | 4 | Y |
ATTRIBUTE_NUMBER1 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER2 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER3 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER4 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER5 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER6 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER7 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER8 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER9 | NUMBER | 22 | Y |
ATTRIBUTE_NUMBER10 | NUMBER | 22 | Y |
ATTRIBUTE_DATE1 | DATE | 7 | Y |
ATTRIBUTE_DATE2 | DATE | 7 | Y |
ATTRIBUTE_DATE3 | DATE | 7 | Y |
ATTRIBUTE_DATE4 | DATE | 7 | Y |
ATTRIBUTE_DATE5 | DATE | 7 | Y |
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP(6) | 11 | Y |
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP(6) | 11 | Y |
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP(6) | 11 | Y |
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP(6) | 11 | Y |
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP(6) | 11 | Y |
PROFIT_CENTER_BU_ID | NUMBER | 22 | Y |
MANUAL_RECEIPT_EXP_AT_DEST | VARCHAR2 | 4 | Y |
MFG_PLANT_FLAG | VARCHAR2 | 4 | Y |
CONTRACT_MFG_FLAG | VARCHAR2 | 4 | Y |
SUPPLIER_ID | NUMBER | 22 | Y |
SUPPLIER_SITE_ID | NUMBER | 22 | Y |
TIMEZONE_CODE | VARCHAR2 | 200 | Y |
INTEGRATED_SYSTEM_CODE | VARCHAR2 | 100 | Y |
ITEM_GROUPING_CODE | VARCHAR2 | 80 | Y |
ITEM_DEFINITION_ORG_ID | NUMBER | 22 | Y |
GROUPING_JOB_STATUS | VARCHAR2 | 80 | Y |
GROUPING_JOB_ID | NUMBER | 22 | Y |
INTERNAL_CUSTOMER_FLAG | VARCHAR2 | 4 | Y |
CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 120 | Y |
PARTY_ID | NUMBER | 22 | Y |
USE_CUR_ITEM_COST_FLAG | VARCHAR2 | 4 | Y |