Uncategorized

Column Details of inv_org_parameters Table

COLUMN NAMEDATA TYPEDATA LENGTHNULLABLE LAST_UPDATE_DATETIMESTAMP(6)11N  FILL_KILL_TRANSFER_ORDERS_FLAGVARCHAR24Y  TRACK_COUNTRY_OF_ORIGIN_FLAGVARCHAR24Y  ORGANIZATION_IDNUMBER22N  LAST_UPDATED_BYVARCHAR2256N  CREATION_DATETIMESTAMP(6)11N  CREATED_BYVARCHAR2256N  LAST_UPDATE_LOGINVARCHAR2128Y  ORGANIZATION_CODEVARCHAR272Y  MASTER_ORGANIZATION_IDNUMBER22Y  BUSINESS_UNIT_IDNUMBER22Y  LEGAL_ENTITY_IDNUMBER22Y  SCHEDULE_IDNUMBER22Y  DEFAULT_PICKING_RULE_IDNUMBER22Y  DEFAULT_LOCATOR_ORDER_VALUENUMBER22Y  DEFAULT_SUBINV_ORDER_VALUENUMBER22Y  NEGATIVE_INV_RECEIPT_CODENUMBER22Y  STOCK_LOCATOR_CONTROL_CODEVARCHAR2120Y  SOURCE_ORGANIZATION_IDNUMBER22Y  SOURCE_SUBINVENTORYVARCHAR240Y  SOURCE_TYPEVARCHAR2120Y  SERIAL_NUMBER_TYPEVARCHAR2120Y  AUTO_SERIAL_ALPHA_PREFIXVARCHAR2320Y  START_AUTO_SERIAL_NUMBERVARCHAR2320Y  AUTO_LOT_ALPHA_PREFIXVARCHAR2320Y  LOT_NUMBER_UNIQUENESSVARCHAR2120Y  LOT_NUMBER_GENERATIONVARCHAR2120Y  LOT_NUMBER_ZERO_PADDINGVARCHAR2120Y  LOT_NUMBER_LENGTHNUMBER22Y  STARTING_REVISIONVARCHAR272Y  LPN_PREFIXVARCHAR240Y  LPN_SUFFIXVARCHAR240Y  LPN_STARTING_NUMBERNUMBER22Y  TOTAL_LPN_LENGTHNUMBER22Y  UCC_128_SUFFIX_FLAGVARCHAR24Y  ATTRIBUTE_CATEGORYVARCHAR2120Y  ATTRIBUTE1VARCHAR2600Y  ATTRIBUTE2VARCHAR2600Y  ATTRIBUTE3VARCHAR2600Y  ATTRIBUTE4VARCHAR2600Y  ATTRIBUTE5VARCHAR2600Y  ATTRIBUTE6VARCHAR2600Y  ATTRIBUTE7VARCHAR2600Y  ATTRIBUTE8VARCHAR2600Y  ATTRIBUTE9VARCHAR2600Y  ATTRIBUTE10VARCHAR2600Y  ATTRIBUTE11VARCHAR2600Y  ATTRIBUTE12VARCHAR2600Y  ATTRIBUTE13VARCHAR2600Y  ATTRIBUTE14VARCHAR2600Y  ATTRIBUTE15VARCHAR2600Y  SERIAL_NUMBER_GENERATIONVARCHAR2120Y  GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2120Y  GLOBAL_ATTRIBUTE1VARCHAR2600Y  GLOBAL_ATTRIBUTE2VARCHAR2600Y  GLOBAL_ATTRIBUTE3VARCHAR2600Y  GLOBAL_ATTRIBUTE4VARCHAR2600Y  GLOBAL_ATTRIBUTE5VARCHAR2600Y  GLOBAL_ATTRIBUTE6VARCHAR2600Y  GLOBAL_ATTRIBUTE7VARCHAR2600Y  GLOBAL_ATTRIBUTE8VARCHAR2600Y  GLOBAL_ATTRIBUTE9VARCHAR2600Y  GLOBAL_ATTRIBUTE10VARCHAR2600Y  GLOBAL_ATTRIBUTE11VARCHAR2600Y  GLOBAL_ATTRIBUTE12VARCHAR2600Y  GLOBAL_ATTRIBUTE13VARCHAR2600Y  GLOBAL_ATTRIBUTE14VARCHAR2600Y  GLOBAL_ATTRIBUTE15VARCHAR2600Y  GLOBAL_ATTRIBUTE16VARCHAR2600Y  GLOBAL_ATTRIBUTE17VARCHAR2600Y  GLOBAL_ATTRIBUTE18VARCHAR2600Y  GLOBAL_ATTRIBUTE19VARCHAR2600Y  GLOBAL_ATTRIBUTE20VARCHAR2600Y  MO_PICK_CONFIRM_REQUIREDNUMBER22Y  OVPK_TRANSFER_ORDERS_ENABLEDVARCHAR24Y  ALLOCATE_SERIAL_FLAGVARCHAR24Y  DISTRIBUTED_ORGANIZATION_FLAGVARCHAR24Y  ALLOW_DIFFERENT_STATUSNUMBER22Y  CHILD_LOT_ALPHA_PREFIXVARCHAR2320Y  CHILD_LOT_NUMBER_LENGTHNUMBER22Y  CHILD_LOT_VALIDATION_FLAGVARCHAR24Y  CHILD_LOT_ZERO_PADDING_FLAGVARCHAR24Y  COPY_LOT_ATTRIBUTE_FLAGVARCHAR24Y  CREATE_LOT_UOM_CONVERSIONNUMBER22Y  PARENT_CHILD_GENERATION_FLAGVARCHAR24Y  AUTO_DEL_ALLOC_FLAGVARCHAR24Y  ENFORCE_LOCATOR_ALIS_UNQ_FLAGVARCHAR24Y  PRE_FILL_PICKED_QTYVARCHAR24Y  CAPTURE_PICKING_EXCEPTIONVARCHAR24Y  INVENTORY_FLAGVARCHAR24N  OBJECT_VERSION_NUMBERNUMBER22N  QA_SKIPPING_INSP_FLAGVARCHAR24Y  WCS_ENABLEDVARCHAR24Y  EAM_ENABLED_FLAGVARCHAR24Y  WMS_ENABLED_FLAGVARCHAR24Y  MAINT_ORGANIZATION_IDNUMBER22Y  TRADING_PARTNER_ORG_FLAGVARCHAR24Y  PREGEN_PUTAWAY_TASKS_FLAGNUMBER22Y  REGENERATION_INTERVALNUMBER22Y  TIMEZONE_IDNUMBER22Y  DEFAULT_WMS_PICKING_RULE_IDNUMBER22Y  DEFAULT_PUT_AWAY_RULE_IDNUMBER22Y  DEFAULT_CARTON_RULE_IDNUMBER22Y  DEFAULT_CYC_COUNT_HEADER_IDNUMBER22Y  CROSSDOCK_FLAGNUMBER22Y  CARTONIZATION_FLAGNUMBER22Y  PROJECT_REFERENCE_ENABLEDNUMBER22Y  PROJECT_CONTROL_LEVELNUMBER22Y  PM_COST_COLLECTION_ENABLEDNUMBER22Y  JOB_DEFINITION_NAMEVARCHAR2400Y  JOB_DEFINITION_PACKAGEVARCHAR23600Y  REQUEST_IDNUMBER22Y  PICK_QTY_DEFAULT_REASON_IDNUMBER22Y  FIFO_ORIG_RCPT_DATE_FLAGVARCHAR24Y  ALLOW_NEG_ONHAND_CC_TXNSVARCHAR24Y  PURCHASING_BY_REVISIONVARCHAR24Y  ROUND_REORDER_QTY_FLAGVARCHAR24Y  REPLNSH_MOVE_ORDER_GROUPINGNUMBER22Y  FILL_KILL_MOVE_ORDER_FLAGVARCHAR24Y  PICK_SLIP_BATCH_SIZENUMBER22Y  STANDARD_PACK_ENABLEDNUMBER22Y  AUTO_BREAKDOWN_ENABLEDVARCHAR24Y  ATTRIBUTE_NUMBER1NUMBER22Y  ATTRIBUTE_NUMBER2NUMBER22Y  ATTRIBUTE_NUMBER3NUMBER22Y  ATTRIBUTE_NUMBER4NUMBER22Y  ATTRIBUTE_NUMBER5NUMBER22Y  ATTRIBUTE_NUMBER6NUMBER22Y  ATTRIBUTE_NUMBER7NUMBER22Y  ATTRIBUTE_NUMBER8NUMBER22Y  ATTRIBUTE_NUMBER9NUMBER22Y  ATTRIBUTE_NUMBER10NUMBER22Y  ATTRIBUTE_DATE1DATE7Y  ATTRIBUTE_DATE2DATE7Y  ATTRIBUTE_DATE3DATE7Y  ATTRIBUTE_DATE4DATE7Y  ATTRIBUTE_DATE5DATE7Y  ATTRIBUTE_TIMESTAMP1TIMESTAMP(6)11Y  ATTRIBUTE_TIMESTAMP2TIMESTAMP(6)11Y  ATTRIBUTE_TIMESTAMP3TIMESTAMP(6)11Y  ATTRIBUTE_TIMESTAMP4TIMESTAMP(6)11Y  ATTRIBUTE_TIMESTAMP5TIMESTAMP(6)11Y  PROFIT_CENTER_BU_IDNUMBER22Y  MANUAL_RECEIPT_EXP_AT_DESTVARCHAR24Y  MFG_PLANT_FLAGVARCHAR24Y  CONTRACT_MFG_FLAGVARCHAR24Y  SUPPLIER_IDNUMBER22Y  SUPPLIER_SITE_IDNUMBER22Y  TIMEZONE_CODEVARCHAR2200Y  INTEGRATED_SYSTEM_CODEVARCHAR2100Y  ITEM_GROUPING_CODEVARCHAR280Y  ITEM_DEFINITION_ORG_IDNUMBER22Y  GROUPING_JOB_STATUSVARCHAR280Y  GROUPING_JOB_IDNUMBER22Y  INTERNAL_CUSTOMER_FLAGVARCHAR24Y  CUSTOMER_ACCOUNT_NUMBERVARCHAR2120Y  PARTY_IDNUMBER22Y  USE_CUR_ITEM_COST_FLAGVARCHAR24Y