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 

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?