Uncategorized

Column Details of inv_org_parameters Table

COLUMN NAMEDATA TYPEDATA LENGTHNULLABLE
 LAST_UPDATE_DATETIMESTAMP(6)11
 FILL_KILL_TRANSFER_ORDERS_FLAGVARCHAR24
 TRACK_COUNTRY_OF_ORIGIN_FLAGVARCHAR24
 ORGANIZATION_IDNUMBER22
 LAST_UPDATED_BYVARCHAR2256
 CREATION_DATETIMESTAMP(6)11
 CREATED_BYVARCHAR2256
 LAST_UPDATE_LOGINVARCHAR2128
 ORGANIZATION_CODEVARCHAR272
 MASTER_ORGANIZATION_IDNUMBER22
 BUSINESS_UNIT_IDNUMBER22
 LEGAL_ENTITY_IDNUMBER22
 SCHEDULE_IDNUMBER22
 DEFAULT_PICKING_RULE_IDNUMBER22
 DEFAULT_LOCATOR_ORDER_VALUENUMBER22
 DEFAULT_SUBINV_ORDER_VALUENUMBER22
 NEGATIVE_INV_RECEIPT_CODENUMBER22
 STOCK_LOCATOR_CONTROL_CODEVARCHAR2120
 SOURCE_ORGANIZATION_IDNUMBER22
 SOURCE_SUBINVENTORYVARCHAR240
 SOURCE_TYPEVARCHAR2120
 SERIAL_NUMBER_TYPEVARCHAR2120
 AUTO_SERIAL_ALPHA_PREFIXVARCHAR2320
 START_AUTO_SERIAL_NUMBERVARCHAR2320
 AUTO_LOT_ALPHA_PREFIXVARCHAR2320
 LOT_NUMBER_UNIQUENESSVARCHAR2120
 LOT_NUMBER_GENERATIONVARCHAR2120
 LOT_NUMBER_ZERO_PADDINGVARCHAR2120
 LOT_NUMBER_LENGTHNUMBER22
 STARTING_REVISIONVARCHAR272
 LPN_PREFIXVARCHAR240
 LPN_SUFFIXVARCHAR240
 LPN_STARTING_NUMBERNUMBER22
 TOTAL_LPN_LENGTHNUMBER22
 UCC_128_SUFFIX_FLAGVARCHAR24
 ATTRIBUTE_CATEGORYVARCHAR2120
 ATTRIBUTE1VARCHAR2600
 ATTRIBUTE2VARCHAR2600
 ATTRIBUTE3VARCHAR2600
 ATTRIBUTE4VARCHAR2600
 ATTRIBUTE5VARCHAR2600
 ATTRIBUTE6VARCHAR2600
 ATTRIBUTE7VARCHAR2600
 ATTRIBUTE8VARCHAR2600
 ATTRIBUTE9VARCHAR2600
 ATTRIBUTE10VARCHAR2600
 ATTRIBUTE11VARCHAR2600
 ATTRIBUTE12VARCHAR2600
 ATTRIBUTE13VARCHAR2600
 ATTRIBUTE14VARCHAR2600
 ATTRIBUTE15VARCHAR2600
 SERIAL_NUMBER_GENERATIONVARCHAR2120
 GLOBAL_ATTRIBUTE_CATEGORYVARCHAR2120
 GLOBAL_ATTRIBUTE1VARCHAR2600
 GLOBAL_ATTRIBUTE2VARCHAR2600
 GLOBAL_ATTRIBUTE3VARCHAR2600
 GLOBAL_ATTRIBUTE4VARCHAR2600
 GLOBAL_ATTRIBUTE5VARCHAR2600
 GLOBAL_ATTRIBUTE6VARCHAR2600
 GLOBAL_ATTRIBUTE7VARCHAR2600
 GLOBAL_ATTRIBUTE8VARCHAR2600
 GLOBAL_ATTRIBUTE9VARCHAR2600
 GLOBAL_ATTRIBUTE10VARCHAR2600
 GLOBAL_ATTRIBUTE11VARCHAR2600
 GLOBAL_ATTRIBUTE12VARCHAR2600
 GLOBAL_ATTRIBUTE13VARCHAR2600
 GLOBAL_ATTRIBUTE14VARCHAR2600
 GLOBAL_ATTRIBUTE15VARCHAR2600
 GLOBAL_ATTRIBUTE16VARCHAR2600
 GLOBAL_ATTRIBUTE17VARCHAR2600
 GLOBAL_ATTRIBUTE18VARCHAR2600
 GLOBAL_ATTRIBUTE19VARCHAR2600
 GLOBAL_ATTRIBUTE20VARCHAR2600
 MO_PICK_CONFIRM_REQUIREDNUMBER22
 OVPK_TRANSFER_ORDERS_ENABLEDVARCHAR24
 ALLOCATE_SERIAL_FLAGVARCHAR24
 DISTRIBUTED_ORGANIZATION_FLAGVARCHAR24
 ALLOW_DIFFERENT_STATUSNUMBER22
 CHILD_LOT_ALPHA_PREFIXVARCHAR2320
 CHILD_LOT_NUMBER_LENGTHNUMBER22
 CHILD_LOT_VALIDATION_FLAGVARCHAR24
 CHILD_LOT_ZERO_PADDING_FLAGVARCHAR24
 COPY_LOT_ATTRIBUTE_FLAGVARCHAR24
 CREATE_LOT_UOM_CONVERSIONNUMBER22
 PARENT_CHILD_GENERATION_FLAGVARCHAR24
 AUTO_DEL_ALLOC_FLAGVARCHAR24
 ENFORCE_LOCATOR_ALIS_UNQ_FLAGVARCHAR24
 PRE_FILL_PICKED_QTYVARCHAR24
 CAPTURE_PICKING_EXCEPTIONVARCHAR24
 INVENTORY_FLAGVARCHAR24
 OBJECT_VERSION_NUMBERNUMBER22
 QA_SKIPPING_INSP_FLAGVARCHAR24
 WCS_ENABLEDVARCHAR24
 EAM_ENABLED_FLAGVARCHAR24
 WMS_ENABLED_FLAGVARCHAR24
 MAINT_ORGANIZATION_IDNUMBER22
 TRADING_PARTNER_ORG_FLAGVARCHAR24
 PREGEN_PUTAWAY_TASKS_FLAGNUMBER22
 REGENERATION_INTERVALNUMBER22
 TIMEZONE_IDNUMBER22
 DEFAULT_WMS_PICKING_RULE_IDNUMBER22
 DEFAULT_PUT_AWAY_RULE_IDNUMBER22
 DEFAULT_CARTON_RULE_IDNUMBER22
 DEFAULT_CYC_COUNT_HEADER_IDNUMBER22
 CROSSDOCK_FLAGNUMBER22
 CARTONIZATION_FLAGNUMBER22
 PROJECT_REFERENCE_ENABLEDNUMBER22
 PROJECT_CONTROL_LEVELNUMBER22
 PM_COST_COLLECTION_ENABLEDNUMBER22
 JOB_DEFINITION_NAMEVARCHAR2400
 JOB_DEFINITION_PACKAGEVARCHAR23600
 REQUEST_IDNUMBER22
 PICK_QTY_DEFAULT_REASON_IDNUMBER22
 FIFO_ORIG_RCPT_DATE_FLAGVARCHAR24
 ALLOW_NEG_ONHAND_CC_TXNSVARCHAR24
 PURCHASING_BY_REVISIONVARCHAR24
 ROUND_REORDER_QTY_FLAGVARCHAR24
 REPLNSH_MOVE_ORDER_GROUPINGNUMBER22
 FILL_KILL_MOVE_ORDER_FLAGVARCHAR24
 PICK_SLIP_BATCH_SIZENUMBER22
 STANDARD_PACK_ENABLEDNUMBER22
 AUTO_BREAKDOWN_ENABLEDVARCHAR24
 ATTRIBUTE_NUMBER1NUMBER22
 ATTRIBUTE_NUMBER2NUMBER22
 ATTRIBUTE_NUMBER3NUMBER22
 ATTRIBUTE_NUMBER4NUMBER22
 ATTRIBUTE_NUMBER5NUMBER22
 ATTRIBUTE_NUMBER6NUMBER22
 ATTRIBUTE_NUMBER7NUMBER22
 ATTRIBUTE_NUMBER8NUMBER22
 ATTRIBUTE_NUMBER9NUMBER22
 ATTRIBUTE_NUMBER10NUMBER22
 ATTRIBUTE_DATE1DATE7
 ATTRIBUTE_DATE2DATE7
 ATTRIBUTE_DATE3DATE7
 ATTRIBUTE_DATE4DATE7
 ATTRIBUTE_DATE5DATE7
 ATTRIBUTE_TIMESTAMP1TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP2TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP3TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP4TIMESTAMP(6)11
 ATTRIBUTE_TIMESTAMP5TIMESTAMP(6)11
 PROFIT_CENTER_BU_IDNUMBER22
 MANUAL_RECEIPT_EXP_AT_DESTVARCHAR24
 MFG_PLANT_FLAGVARCHAR24
 CONTRACT_MFG_FLAGVARCHAR24
 SUPPLIER_IDNUMBER22
 SUPPLIER_SITE_IDNUMBER22
 TIMEZONE_CODEVARCHAR2200
 INTEGRATED_SYSTEM_CODEVARCHAR2100
 ITEM_GROUPING_CODEVARCHAR280
 ITEM_DEFINITION_ORG_IDNUMBER22
 GROUPING_JOB_STATUSVARCHAR280
 GROUPING_JOB_IDNUMBER22
 INTERNAL_CUSTOMER_FLAGVARCHAR24
 CUSTOMER_ACCOUNT_NUMBERVARCHAR2120
 PARTY_IDNUMBER22
 USE_CUR_ITEM_COST_FLAGVARCHAR24

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?