1. Tables and Views for SCM
  2. EGP_SYSTEM_ITEMS_B

EGP_SYSTEM_ITEMS_B

Storage for Item Number(part number/part/item) .

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

EGP_SYSTEM_ITEMS_B_PK

INVENTORY_ITEM_ID, ORGANIZATION_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping Status
INVENTORY_ITEM_ID NUMBER 18 Yes Attribute indicating the unique identifier of the item. Active
ORGANIZATION_ID NUMBER 18 Yes A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
SUMMARY_FLAG VARCHAR2 1 Flexfield summary flag. Not used in Fusion Active
ENABLED_FLAG VARCHAR2 1 Attribute indicating the item class is enabled for use. Active
START_DATE_ACTIVE DATE The date on which a task, event or business process begins. Active
END_DATE_ACTIVE DATE This column is not used. Ignore this column. Active
BUYER_ID NUMBER 18 Attribute indicating the default buyer of the Item. Active
ACCOUNTING_RULE_ID NUMBER 18 Attribute indicating the accounting rule to identify special revenue recognition rules for an item. Active
INVOICING_RULE_ID NUMBER 18 Attribute indicating invoicing rule to determine the period in which an invoice is sent Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
PURCHASING_ITEM_FLAG VARCHAR2 1 Attribute which determines whether the Item is purchased and received Active
SHIPPABLE_ITEM_FLAG VARCHAR2 1 Attribute indicating whether to ship an item to a customer. Active
CUSTOMER_ORDER_FLAG VARCHAR2 1 Attribute Indicating whether to allow an item to be ordered by external customers. Active
INTERNAL_ORDER_FLAG VARCHAR2 1 Attribute indicating whether an item can be transferred internally. Active
INVENTORY_ITEM_FLAG VARCHAR2 1 Attribute indicating whether the Item can be Stocked and transacted. Active
INVENTORY_ASSET_FLAG VARCHAR2 1 Indicate whether to value an item as an asset in inventory Active
PURCHASING_ENABLED_FLAG VARCHAR2 1 Attribute which determines whether the item can be added in to a purchase order. Active
CUSTOMER_ORDER_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether an item is currently customer orderable Active
INTERNAL_ORDER_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to allow an item to be ordered on an internal requisition. Active
SO_TRANSACTIONS_FLAG VARCHAR2 1 Attribute indicating whether demand can be placed for an item by Oracle Order Management, and whether shipment transactions are interfaced to Oracle Inventory.This is a choice list. Active
MTL_TRANSACTIONS_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether transaction can be performed on an item. Active
STOCK_ENABLED_FLAG VARCHAR2 1 Attribute which determines whether Item can be stocked. Active
BUILD_IN_WIP_FLAG VARCHAR2 1 Attribute indicating whether to create discrete jobs or repetitive assemblies in Oracle Work in Process. Active
REVISION_QTY_CONTROL_CODE NUMBER An attribute that tracks inventory by item revision and forces a revision to be specified for each material transaction Active
ITEM_CATALOG_GROUP_ID NUMBER 18 Provides metadata common to all items that share the category. For example, the item catalog category "Engine" describes attributes, functions and other characteristics common to several item numbers, such as Engine M10000 and Engine M20000. Active
RETURNABLE_FLAG VARCHAR2 1 Attribute indicating whether to allow customers to return an item. Active
DEFAULT_SHIPPING_ORG NUMBER 18 Attribute indicating the primary Shipping Organization.This organization defaults to the Enter Orders window if Item is the source attribute of the warehouse object in the standard value rule set for the order Active
COLLATERAL_FLAG VARCHAR2 1 Attribute indicating whether the item is a collateral. Active
TAXABLE_FLAG VARCHAR2 1 Attribute indicating whether the supplier charges a Tax for the item. Active
QTY_RCV_EXCEPTION_CODE VARCHAR2 25 Attribute indicating Action to be performed when the receive date is outside the range defined by Quantity Received Tolerance. Active
ALLOW_ITEM_DESC_UPDATE_FLAG VARCHAR2 1 Attribute indicating whether to allow receipt of defined substitutes in place of this item. Active
MARKET_PRICE NUMBER Attribute indicating market Price of the item which is printed on the Purchase Order lines. Active
HAZARD_CLASS_ID NUMBER 18 Attribute indicating the category of Hazard material for International trade. Active
NEGOTIATION_REQUIRED_FLAG VARCHAR2 1 Attribute indicating whether Negotiation is required or not. Active
QTY_RCV_TOLERANCE NUMBER Attribute indicating the quantity received tolerance percent, the maximum acceptable over-receipt percentage. Active
LIST_PRICE_PER_UNIT NUMBER Attribute indicating default Price to be used in RFQ, Purchase Order or Quotation. Active
UN_NUMBER_ID NUMBER 18 United Nations Identification Number used for International Trade purposes. Active
PRICE_TOLERANCE_PERCENT NUMBER Attribute indicating the maximum price percentage over the normal price range for an item. For example, if the tolerance percent is 5, the maximum acceptable price on a purchase order is 5% over the requisition price. Any purchase order price 5% above the requisition price is unacceptable, and you cannot approve the purchase order. Active
ROUNDING_FACTOR NUMBER Attribute indicating how to round the quantity on an internal requisition that results from conversions between the requisition line unit of measure and the item unit of issue. This factor insures that the unit of issue resolves to an integer, rather than a fractional amount. Active
UNIT_OF_ISSUE VARCHAR2 25 Attribute indicating Unit of measure used for issuing the item from inventory. Active
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 25 Attribute indicating an option to control whether the supplier can deliver to a location that differs from the ship to location defined on the purchase order. Active
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 1 Attribute indicating whether to allow receipt of defined substitutes in place of this item. Active
ALLOW_UNORDERED_RECEIPTS_FLAG VARCHAR2 1 Attribute indicating whether you can receive an item without a purchase order. Active
ALLOW_EXPRESS_DELIVERY_FLAG VARCHAR2 1 Indicates whether you can deliver all distributions for this item with one data entry transaction if the quantity to deliver equals the purchase order line balance. Active
DAYS_EARLY_RECEIPT_ALLOWED NUMBER Attribute indicating the number of days before the promise date you can receive an item without warning or rejection. Active
DAYS_LATE_RECEIPT_ALLOWED NUMBER Attribute indicating the number of days after the promise date you can receive an item without warning or rejection. Active
RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 25 Attribute indicating Action to be performed when the receive date is outside the range defined by Days Early Receipt Allowed or Days Late Receipt Allowed. Choices - None, Reject, Warning. Active
RECEIVING_ROUTING_ID NUMBER 18 Attribute indicating routing of the Items at the time of receipt. Active
INVOICE_CLOSE_TOLERANCE NUMBER Percentage tolerance used to automatically close Purchase Order Shipments for invoicing. Active
RECEIVE_CLOSE_TOLERANCE NUMBER Attribute indicating percentage tolerance used to automatically close Purchase Order Shipments for receipt. Active
AUTO_LOT_ALPHA_PREFIX VARCHAR2 80 Attribute indicating starting alpha prefix for all serial numbers defined Active
START_AUTO_LOT_NUMBER VARCHAR2 80 Item Attribute which is the starting serial number for the Item. Active
LOT_CONTROL_CODE NUMBER Attribute indicating the ability to use lot numbers during material transactions for tracking of batches of Item. Active
SHELF_LIFE_CODE NUMBER Attribute indicating how long items in a given lot remain available. Active
SHELF_LIFE_DAYS NUMBER Attribute indicating number of days each lot is active. Active
SERIAL_NUMBER_CONTROL_CODE NUMBER Attribute indicating number assigned to each unit of an item and used to track the item. Active
START_AUTO_SERIAL_NUMBER VARCHAR2 80 Attribute indicating starting number for all serial numbers for this item. Active
AUTO_SERIAL_ALPHA_PREFIX VARCHAR2 80 Attribute indicating the starting alphabet prefix for all serial numbers which are being defined for the Item. Active
SOURCE_TYPE NUMBER Attribute indicating the way in which requests are fulfilled.(Inventory,Supplier, Subinventory) Active
SOURCE_ORGANIZATION_ID NUMBER 18 Attribute indicating the Organization from which an internal requisition draws the item. Active
SOURCE_SUBINVENTORY VARCHAR2 10 Attribute indicating the sub inventory from which an internal requisition draws the item. Active
RESTRICT_SUBINVENTORIES_CODE NUMBER Attribute indicating whether to restrict transactions of this item to or from a subinventory specified Active
UNIT_WEIGHT NUMBER Attribute Indicating Weight of One Unit of Item Active
WEIGHT_UOM_CODE VARCHAR2 3 Attribute indicating Weight Unit of Measure Active
VOLUME_UOM_CODE VARCHAR2 3 Attribute indicating Volume Unit of Measure. Active
UNIT_VOLUME NUMBER Attribute Indicating Volume of One Unit of Item Active
RESTRICT_LOCATORS_CODE NUMBER Attribute indicating whether to restrict transaction of this item to or from a locator specified Active
LOCATION_CONTROL_CODE NUMBER Attribute indicating the physical area within a subinventory where you store material, such as a row, aisle, bin,or shelf. Active
SHRINKAGE_RATE NUMBER Attribute indicating the factor that represents the average amount of material you expect to lose during manufacturing or in storage. Active
ACCEPTABLE_EARLY_DAYS NUMBER Attribute indicating the number of days before which the planning process will not reschedule orders. Active
PLANNING_TIME_FENCE_CODE NUMBER Attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. Active
DEMAND_TIME_FENCE_CODE NUMBER Attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. Active
LEAD_TIME_LOT_SIZE NUMBER Attribute indicating quantity used to compute processing lead time. Active
STD_LOT_SIZE NUMBER The amount of a particular item that is ordered from the plant or a supplier or issued as a standard quantity to the production process. Active
CUM_MANUFACTURING_LEAD_TIME NUMBER Attribute indicating the manufacturing lead time of an assembly (in days) plus the largest adjusted cumulative manufacturing lead time of its components, where each is adjusted by subtracting the operation lead time offset Active
OVERRUN_PERCENTAGE NUMBER Attribute indicating in percentage the planning process uses to suggest new daily rates. Active
MRP_CALCULATE_ATP_FLAG VARCHAR2 1 Attribute indicating whether to calculate and print available to promise (ATP) on the Planning Detail Report. Active
ACCEPTABLE_RATE_INCREASE NUMBER Attribute indicating the amount the planning process uses to increase current daily rates inside the planning time fence. Active
ACCEPTABLE_RATE_DECREASE NUMBER Attribute indicating the amount the planning process uses to decrease current daily rates inside the planning time fence. Active
CUMULATIVE_TOTAL_LEAD_TIME NUMBER Attribute indicating the total lead time of the assembly plus the largest adjusted cumulative total lead time of its components, where each is adjusted by subtracting the operation lead time offset. Active
PLANNING_TIME_FENCE_DAYS NUMBER Attribute indicating the optional day added to the planning time fence when planning time fence is User defined. Active
DEMAND_TIME_FENCE_DAYS NUMBER Attribute indicating option to determine a point in time inside which the planning process ignores forecast demand and considers only sales order demand when calculating gross requirements. Active
END_ASSEMBLY_PEGGING_FLAG VARCHAR2 1 Attribute indicating the planning process uses to decide when to calculate and print end assemblies for the item. Choices are -Soft Pegging,End Assembly Pegging,Soft Pegging,Hard Pegging,None. Active
REPETITIVE_PLANNING_FLAG VARCHAR2 1 Attribute indicating whether to plan material requirements in repetitive daily rates. Active
PLANNING_EXCEPTION_SET VARCHAR2 10 Attribute indicating the name of the planning exception set that groups together the sensitivity controls and exception time periods for item-level planning exceptions for the item. Active
BOM_ITEM_TYPE NUMBER Attribute indicating the type of bill of Material the Item can possess such as standard, model, planning, and other. Active
PICK_COMPONENTS_FLAG VARCHAR2 1 Attribute indicating whether an item has a bill of material with options, classes, or included items picked from finished goods inventory Active
REPLENISH_TO_ORDER_FLAG VARCHAR2 1 Attribute indicating is generally built for sales order demand; a final assembly work order is created based on sales order details Active
BASE_ITEM_ID NUMBER 18 Attribute indicating the Model from which an ATO configuration was created. Active
ATP_COMPONENTS_FLAG VARCHAR2 1 Attribute indicating whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items. Active
ATP_FLAG VARCHAR2 1 Attribute indicating to check available to promise and/or capable to promise information when placing demand. Active
FIXED_LEAD_TIME NUMBER Attribute indicating the days required to make an assembly independent of order quantity, such as setup or tear down time Active
VARIABLE_LEAD_TIME NUMBER Attribute indicating time to produce one additional unit of an assembly. Active
WIP_SUPPLY_LOCATOR_ID NUMBER 18 Attribute indicating the supply locator from which to issue (push) or backflush (pull) an item to work in process. Active
WIP_SUPPLY_TYPE NUMBER 18 Attribute indicating a supply type for components. Active
WIP_SUPPLY_SUBINVENTORY VARCHAR2 10 Attribute indicating the primary subinventory from which to issue (push) or backflush (pull) an item to work in process. Active
PRIMARY_UOM_CODE VARCHAR2 3 The principal unit of measure in which the quantity of an item is managed. Active
ALLOWED_UNITS_LOOKUP_CODE NUMBER Attribute indicating Conversion of transactions. Choices -Standard or Item Specific Conversion. Active
DEFAULT_INCLUDE_IN_ROLLUP_FLAG VARCHAR2 1 Indicate whether to include an item in the cost rollup. Active
INVENTORY_ITEM_STATUS_CODE VARCHAR2 10 Code used to control the transaction activity of an item. Active
INVENTORY_PLANNING_CODE NUMBER Attribute indicating the planning method to be used for the organization Active
PLANNER_CODE VARCHAR2 10 Attribute indicating the material planner for the item Active
PLANNING_MAKE_BUY_CODE NUMBER Attribute indicating whether the item is usually manufactured or bought Active
FIXED_LOT_MULTIPLIER NUMBER Attribute indicating the fixed lot multiple quantity or repetitive rate (units per day). Active
ROUNDING_CONTROL_TYPE NUMBER Attribute indicating whether the planning process uses decimal or whole number values when calculating planned order quantities or repetitive rates. Active
CARRYING_COST NUMBER Attribute indicating the percentage of Unit Cost that represents the internal cost to stock one unit for one year. Active
POSTPROCESSING_LEAD_TIME NUMBER Attribute indicating the days required to receive a purchased item into inventory from the initial supplier receipt. Active
PREPROCESSING_LEAD_TIME NUMBER Attribute indicating the days which must be added to purchasing or manufacturing lead time to place an order. Active
FULL_LEAD_TIME NUMBER Attribute indicating the days required to procure or manufacture an item. Active
ORDER_COST NUMBER Attribute indicating the fixed cost associated with placing an order for the item. Active
MRP_SAFETY_STOCK_PERCENT NUMBER Attribute indicating an option to plan use of fixed or dynamically calculated safety stock quantities. Active
MRP_SAFETY_STOCK_CODE NUMBER Attribute indicating use of fixed or dynamically calculated safety stock quantities. Values available are MRP Planned percent, Non-MRP Planned Active
MIN_MINMAX_QUANTITY NUMBER Attribute indicating the minimum qty for Min-Max Planning. Active
MAX_MINMAX_QUANTITY NUMBER Attribute indicating the maximum qty for Min-Max Planning. Active
MINIMUM_ORDER_QUANTITY NUMBER Attribute indicating Minimum Order quantity of the Item. Active
FIXED_ORDER_QUANTITY NUMBER Attribute indicating the quantity used to modify the size of planned order quantities or repetitive daily rates Active
FIXED_DAYS_SUPPLY NUMBER Attribute indicating the number of days used to modify the size and timing of planned order quantities. Active
MAXIMUM_ORDER_QUANTITY NUMBER Attribute indicating Maximum Order quantity of the Item. Active
ATP_RULE_ID NUMBER 18 Attribute indicating user-defined available to promise rule. Active
PICKING_RULE_ID NUMBER 18 Attribute indicating picking rule that defines the order in which subinventories, locators, lots, and revisions are picked. Active
RESERVABLE_TYPE NUMBER Item attribute which enables to create material reservations for the item. Active
POSITIVE_MEASUREMENT_ERROR NUMBER Attribute indicating percentage of positive variance acceptable before cycle count creates an adjustment transaction. Active
NEGATIVE_MEASUREMENT_ERROR NUMBER Attribute indicating percentage of negative variance acceptable before cycle count creates an adjustment transaction. Active
ENGINEERING_ITEM_ID NUMBER 18 Attribute indicating that the item is created as a engineering item. Active
SERVICE_STARTING_DELAY NUMBER Attribute indicating positive number indicating how many days after shipment the warranty should start Active
SERVICEABLE_PRODUCT_FLAG VARCHAR2 1 Attribute indicating whether the item is eligible to be covered by a service contract. Active
PAYMENT_TERMS_ID NUMBER 18 Attribute indicating a valid payment terms code. Active
MATERIAL_BILLABLE_FLAG VARCHAR2 30 Attribute indicating user definable and must be tagged with one of three Billing Category Codes as follows: material (M) labor (L) or Expense (E). Billing Types are used in Contracts to define Discount Percents. Active
COVERAGE_SCHEDULE_ID NUMBER 18 The template associated with the contract item type. Active
SERVICE_DURATION_PERIOD_CODE VARCHAR2 10 Attribute indicating positive number to indicate the service duration period Active
SERVICE_DURATION NUMBER Attribute indicating positive number to indicate the service duration. Active
INVOICEABLE_ITEM_FLAG VARCHAR2 1 Attribute indicating whether to include an item on an Oracle Receivables invoice. Active
TAX_CODE VARCHAR2 50 Attribute indicating a tax code to use when calculating tax based on location and tax codes. Active
INVOICE_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to activate an item for invoicing in Oracle Receivables. Active
MUST_USE_APPROVED_VENDOR_FLAG VARCHAR2 1 Attribute indicating whether to use only approved suppliers Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
OUTSIDE_OPERATION_FLAG VARCHAR2 1 Attribute Indicating whether the item can be added to Outside Processing Purchase Order. Active
OUTSIDE_OPERATION_UOM_TYPE VARCHAR2 25 Attribute indicating the quantity of item which is processed Outside. Active
SAFETY_STOCK_BUCKET_DAYS NUMBER The number of workdays within a repetitive planning period Active
AUTO_REDUCE_MPS NUMBER 22 Attribute indicating the option to decide when to reduce master production schedule (MPS) quantities to zero. Active
COSTING_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to report, value and account for any item costs Active
AUTO_CREATED_CONFIG_FLAG VARCHAR2 1 Attribute indicating whether the Item is autocreated. Active
CYCLE_COUNT_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether the item is on for automatic cycle count scheduling. Active
ITEM_TYPE VARCHAR2 30 Indicator or classification for an item, such as finished or purchased. Active
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 1 Attribute indicating whether any configuration derived from this model can ship only when all required quantities of all configuration components options or included items) are available. Active
MRP_PLANNING_CODE NUMBER Attribute indicating the organization level planning for the Item. Choices -Min-Max,Not Planned, Reorder Point. Active
RETURN_INSPECTION_REQUIREMENT NUMBER Attribute indicating whether inspection is required for items returned by the customer. The item then must be separately transferred to inventory. Active
ATO_FORECAST_CONTROL NUMBER Attribute indicating the type of demand the item undergoes and can be one of these; Consume, Consume and Derive, or None. Active
RELEASE_TIME_FENCE_CODE NUMBER Attribute indicating an option to determine a point in time inside which planned orders for discretely planned items are automatically released as WIP jobs or purchase requisitions Active
RELEASE_TIME_FENCE_DAYS NUMBER Additional days added to the Release Time Fence Active
CONTAINER_ITEM_FLAG VARCHAR2 1 Attribute indicating whether Containers are used for Shipping the items. Active
VEHICLE_ITEM_FLAG VARCHAR2 1 Attribute indicating whether vehicles are used for Shipping the items. Active
MAXIMUM_LOAD_WEIGHT NUMBER Attribute indicating Maximum load weight of the container or vehicle. Active
MINIMUM_FILL_PERCENT NUMBER Attribute indicating minimum fill of the container or vehicle to be used. Active
CONTAINER_TYPE_CODE VARCHAR2 30 Attribute indicating the type of the Container. Active
INTERNAL_VOLUME NUMBER Attribute indicating the internal volume of the Container or vehicle. Active
WH_UPDATE_DATE DATE Warehouse update date for tracking changes relevant to data collected in Data Warehouse. Not used in Fusion Active
PRODUCT_FAMILY_ITEM_ID NUMBER 18 If the item is product family member, stores the product family identifier.Not used in Fusion. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
PURCHASING_TAX_CODE VARCHAR2 50 Attribute to determine the appropriate tax classification code for the Item. Active
OVERCOMPLETION_TOLERANCE_TYPE NUMBER Attribute indicating the over-completion tolerance type. Choices - Percent or Amount. Active
OVERCOMPLETION_TOLERANCE_VALUE NUMBER Attribute indicating the acceptable percent or quantity of assemblies that you will allow to be over-completed Active
EFFECTIVITY_CONTROL NUMBER Attribute indicating the way to calculate lead time from the either of the choices - Date, Model/Unit Number Active
CHECK_SHORTAGES_FLAG VARCHAR2 1 Attribute indicating to check for material shortages for the item. Active
OVER_SHIPMENT_TOLERANCE NUMBER Attribute indicating the amount of the shipment you can ship below at the time of ship confirmation Active
UNDER_SHIPMENT_TOLERANCE NUMBER Attribute indicating the amount of the shipment which can be shipped below at the time of ship confirmation. Active
OVER_RETURN_TOLERANCE NUMBER Attribute indicating the amount of the shipment you can exceed at the time of receiving or receipt creation. Active
UNDER_RETURN_TOLERANCE NUMBER Attribute indicating the lower limit of the received quantity to be considered as full receipt Active
EQUIPMENT_TYPE NUMBER Attribute indicating whether the item is equipment. Active
RECOVERED_PART_DISP_CODE VARCHAR2 30 Attribute indicating this field will control the process for returning defective or unused parts to a warehouse consolidation point. Active
DEFECT_TRACKING_ON_FLAG VARCHAR2 1 Attribute indicating if defects of this item can be tracked Active
EVENT_FLAG VARCHAR2 1 Attribute indicating whether the item is event. Active
ELECTRONIC_FLAG VARCHAR2 1 Attribute indicating whether the item exists only Electronic format and not physical. Active
DOWNLOADABLE_FLAG VARCHAR2 1 Attribute indicating whether the item can be downloadable. Active
COMMS_NL_TRACKABLE_FLAG VARCHAR2 1 Attribute indicating life cycle tracking in Install Base and enterprise Install Base applications. Active
ASSET_CREATION_CODE VARCHAR2 30 Attribute indicating whether the Item creates a depreciable inventory asset used in Install Base. Active
COMMS_ACTIVATION_REQD_FLAG VARCHAR2 1 Attribute indicating whether the item is eligible for electronic fulfillment by the service fulfillment manager. Active
ORDERABLE_ON_WEB_FLAG VARCHAR2 1 Attribute indicating whether this item is orderable on from the web. Active
BACK_ORDERABLE_FLAG VARCHAR2 1 Attribute indicating whether this item can be backordered, if ATP fails. Active
WEB_STATUS VARCHAR2 30 Attribute indicating Indicate the web status of this item.(enabled, Published, Unpublished) Active
INDIVISIBLE_FLAG VARCHAR2 1 Attribute indicating whether the item can be ordered in fractions. Active
DIMENSION_UOM_CODE VARCHAR2 3 Attribute indicating unit of measure for the dimension of the item. Active
UNIT_LENGTH NUMBER Attribute Indicating Length of the Item Active
UNIT_WIDTH NUMBER Attribute Indicating Width of the Item Active
UNIT_HEIGHT NUMBER Attribute Indicating Height of the Item Active
BULK_PICKED_FLAG VARCHAR2 1 Attribute indicating to pick items in bulk. Active
LOT_STATUS_ENABLED VARCHAR2 1 Attribute indicating whether an item is subject to status control at the Lot Level Active
DEFAULT_LOT_STATUS_ID NUMBER 18 Attribute indicating the Default Lot Status for the Item. Active
SERIAL_STATUS_ENABLED VARCHAR2 1 Attribute indicating whether an item is subject to status control at the Serial Level Active
DEFAULT_SERIAL_STATUS_ID NUMBER 18 Attribute indicating the Default Serial Status of the Item. Active
LOT_SPLIT_ENABLED VARCHAR2 1 Attribute indicating whether a lot-controlled item may split into many lots. Active
LOT_MERGE_ENABLED VARCHAR2 1 Attribute indicating whether many lots of a lot controlled item may merge into one lot. Active
INVENTORY_CARRY_PENALTY NUMBER Attribute indicating the penalty for jobs that are not completed before they are scheduled to be finished. Active
OPERATION_SLACK_PENALTY NUMBER Attribute indicating, in units per day, the operation slack penalty for items having lag time between operations. Active
FINANCING_ALLOWED_FLAG VARCHAR2 1 Attribute indicating whether a customer can finance this item. Active
EAM_ITEM_TYPE NUMBER Attribute indicating whether the Item is Asset Group, Activity, or Rebuildable Item. Active
EAM_ACTIVITY_TYPE_CODE VARCHAR2 30 Attribute indicating the type of maintenance for the Asset activity. Active
EAM_ACTIVITY_CAUSE_CODE VARCHAR2 30 Attribute indicating what situation caused the work to be generated. Active
EAM_ACT_NOTIFICATION_FLAG VARCHAR2 1 Attribute indicating if the asset is movable, and needs to be brought into the shop for repairs. Active
EAM_ACT_SHUTDOWN_STATUS VARCHAR2 30 Attribute indicating whether the maintenance activity needs to be shut down. Active
DUAL_UOM_CONTROL NUMBER Attribute indicating if pricing is based on the primary or secondary unit of measure. Active
SECONDARY_UOM_CODE VARCHAR2 3 Attribute indicating the Secondary Unit of Measure through which the Item can be transacted. Active
DUAL_UOM_DEVIATION_HIGH NUMBER Deviation allowed on the higher side for a transaction on the secondary quantity derived from the default conversion factor. Active
DUAL_UOM_DEVIATION_LOW NUMBER Deviation allowed on the lower side for a transaction on the secondary quantity derived from the default conversion factor. Active
CONTRACT_ITEM_TYPE_CODE VARCHAR2 30 Attribute indicating the contract item type. Active
SERV_REQ_ENABLED_CODE VARCHAR2 30 Attribute indicating whether a service request for the item can be created Active
SERV_BILLING_ENABLED_FLAG VARCHAR2 1 Attribute indicating Billing Type Active
PLANNED_INV_POINT_FLAG VARCHAR2 1 Attribute indicating if the item is an Inventory Point item.This means that material can be stored at the item level without losing materials or quality characteristics. Active
LOT_TRANSLATE_ENABLED VARCHAR2 1 Attribute indicating whether Lots can be translated. Active
DEFAULT_SO_SOURCE_TYPE VARCHAR2 30 Attribute indicating if an item is to be drop-shipped. If the value is internal,the item will not be drop-shipped. If the value is external, the item will be drop-shipped. Active
CREATE_SUPPLY_FLAG VARCHAR2 1 Attribute indicating if the system can suggest supply for this item Active
SUBSTITUTION_WINDOW_CODE NUMBER Attribute indicating the time for which a substitute can be considered for an item. Active
SUBSTITUTION_WINDOW_DAYS NUMBER Attribute indicating the number of days a substitute is considered for an item. Active
IB_ITEM_INSTANCE_CLASS VARCHAR2 30 Attribute indicating that the item is used in Telecommunication Service Ordering for defining a configured link. Active
CONFIG_MODEL_TYPE VARCHAR2 30 Attribute indicating the behaviour of the Configurable Models in the Configurator. Active
LOT_SUBSTITUTION_ENABLED VARCHAR2 1 Attribute indicating whether lots can be substituted in a transaction. Active
MINIMUM_LICENSE_QUANTITY NUMBER Attribute indicating the minimum number of licenses a customer must order for products ordered on Oracle iStore and distributed based on licensing. Active
EAM_ACTIVITY_SOURCE_CODE VARCHAR2 30 Attribute indicating the reason the activity needs to be executed.This is relevant when asset item type is set to asset activity. Active
CURRENT_PHASE_ID NUMBER 18 Each phase represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. For example, the life cycle phases for a computer component life cycle might be: Concept, Design, Prototype, Preproduction, Production, and Retirement. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
TRACKING_QUANTITY_IND VARCHAR2 30 Attribute indicating the Unit of Measure in which the Item is tracked in inventory. Active
ONT_PRICING_QTY_SOURCE VARCHAR2 30 Attribute indicating the Unit of Measure in which the Item is priced for selling of the products and services. Active
SECONDARY_DEFAULT_IND VARCHAR2 30 Defaulting Control of the item attributes Active
OPTION_SPECIFIC_SOURCED NUMBER Attribute indicating whether the item is sourced for configured item.Not used in Fusion. Active
APPROVAL_STATUS VARCHAR2 30 The Approval Status of the Item. Active
VMI_MINIMUM_UNITS NUMBER Attribute indicating the minimum order quantity or repetitive rate (units per day). Active
VMI_MINIMUM_DAYS NUMBER Attribute indicating the minimum allowed days of supply before replenishment must occur. Active
VMI_MAXIMUM_UNITS NUMBER Attribute indicating maximum order quantity or repetitive rate (units per day) Active
VMI_MAXIMUM_DAYS NUMBER Attribute indicating the maximum allowed days of supply for replenishment reorder. Active
VMI_FIXED_ORDER_QUANTITY NUMBER Attribute indicating fixed quantity for reorder ( Vendor Managed) Active
SO_AUTHORIZATION_FLAG NUMBER Attribute indicating authorization is required before a sales order is created. Active
CONSIGNED_FLAG NUMBER Attribute indicating the item is residing at your location, but owned by the supplier. Active
ASN_AUTOEXPIRE_FLAG NUMBER Attribute indicating Advance Shipment Notice expires automatically. Its a choice list with Yes/No Value. Active
VMI_FORECAST_TYPE NUMBER Attribute indicating the forecast type. Choices -Order, Sales, Historical Forecast. Active
FORECAST_HORIZON NUMBER Period for which a forecast is considered by the Planning Engine. Active
EXCLUDE_FROM_BUDGET_FLAG NUMBER Attribute indicating whether the item is excluded from the budget. Active
DAYS_TGT_INV_SUPPLY NUMBER The target Inventory (in terms of days of Supply) to be achieved by the Planning Engine. Active
DAYS_TGT_INV_WINDOW NUMBER The target Inventory (in terms of quantity) to be achieved by the Planning Engine. Active
DAYS_MAX_INV_SUPPLY NUMBER Any materials and supplies in the system that is the maximum amount necessary to achieve the desired business metric like throughput rate, Cost, due date performance, Inventory, Days of Supply etc. Active
DAYS_MAX_INV_WINDOW NUMBER Any materials and supplies in the system that is the maximum amount necessary ( in terms of quantity) to achieve the desired business metric like throughput rate, Cost, due date performance, Inventory, Days of Supply etc Active
DRP_PLANNED_FLAG NUMBER Attribute indicating the kind of planning to be used for an item. It is the application of replenishment inventory calculations to assist in planning of key resources contained in a distribution system, such as sourcing and transport. Active
CRITICAL_COMPONENT_FLAG NUMBER Attribute indicating the item as a critical component for MPS and DRP planning. Active
CONTINOUS_TRANSFER NUMBER Attribute indicating to perform continuous inter organization transfers. Active
CONVERGENCE NUMBER Attribute indicating whether you use a convergent consumption pattern in planning. Active
DIVERGENCE NUMBER Attribute indicating whether divergent supply pattern for planning can be used. Active
CONFIG_ORGS VARCHAR2 30 Attribute indicating whether the Configured Bill of materials can be created based on Item Sourcing. Active
CONFIG_MATCH VARCHAR2 30 Attribute indicating the capability to match to one of existing configurations of the models -Standard,Container,Null. Active
ATTRIBUTE16 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE21 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE22 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE23 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE24 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE25 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE26 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE27 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE28 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE29 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
ATTRIBUTE30 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF) Active
CAS_NUMBER VARCHAR2 30 Attribute indicating the Chemical Abstracts Service (CAS) Registry Number which uniquely identifies a chemical substance. Active
CHILD_LOT_FLAG VARCHAR2 1 Attribute indicating whether an item is subject to Lot control at the transactional purposes when a Parent Lot is specified for transactional purpose. Active
CHILD_LOT_PREFIX VARCHAR2 30 Attribute indicating the starting alphabet prefix for the Child Lot. Active
CHILD_LOT_STARTING_NUMBER NUMBER Attribute indicating starting number for all Lot numbers for this item. Active
CHILD_LOT_VALIDATION_FLAG VARCHAR2 1 Attribute indicating whether the Child Lot numbers confirms to the child lot parameters. Active
COPY_LOT_ATTRIBUTE_FLAG VARCHAR2 1 Attribute indicating whether the Child Lot inherits all the attribute of the parent Lot. Active
DEFAULT_GRADE VARCHAR2 150 Attribute indicating default grade for the item. Active
EXPIRATION_ACTION_CODE VARCHAR2 32 Attribute indicating the default action code for this item when the lot expire or the lot fails for quality. Active
EXPIRATION_ACTION_INTERVAL NUMBER Attribute indicating the number of days the system adds to the expiration date before it performs an action on the lot. Active
GRADE_CONTROL_FLAG VARCHAR2 1 Attribute indicating whether the item is grade controlled in addition to lot controlled. Active
HAZARDOUS_MATERIAL_FLAG VARCHAR2 1 Attribute indicating if the item is hazardous. Active
HOLD_DAYS NUMBER Attribute indicating the number of days added to the lot creation date before you can release the lot. Active
LOT_DIVISIBLE_FLAG VARCHAR2 1 Attribute indicating whether the Lot can be allowed to allocate, reserve, or move partial lot quantities. Active
MATURITY_DAYS NUMBER Attribute indicating the number of days added to the lot creation date to determine the lot maturity date. Active
PARENT_CHILD_GENERATION_FLAG VARCHAR2 1 Attribute indicating how the system generates child lot numbers at the item level. Active
PROCESS_COSTING_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to use the process costing module with this item. This is a choice list. Active
PROCESS_EXECUTION_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to use this item in a production batch as an ingredient, product, or by-product. Active
PROCESS_QUALITY_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether to use the process manufacturing quality module with this item. Active
PROCESS_SUPPLY_LOCATOR_ID NUMBER 18 Attribute indicating the location from which the item is normally consumed as an ingredient in process manufacturing. Active
PROCESS_SUPPLY_SUBINVENTORY VARCHAR2 10 Attribute indicating a subinventory from which the item is normally consumed as an ingredient in process manufacturing. Active
PROCESS_YIELD_LOCATOR_ID NUMBER 18 Attribute indicating locator in which you place the results of a production batch Active
PROCESS_YIELD_SUBINVENTORY VARCHAR2 10 Attribute indicating a subinventory in which you place results of a production batch. Active
RECIPE_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether this item used in recipes or formulas in process manufacturing Active
RETEST_INTERVAL NUMBER Attribute indicating the number of days after the creation date before the lot needs to be retested. Active
CHARGE_PERIODICITY_CODE VARCHAR2 3 The time the system uses to price a persistent or recurring service or product. Active
REPAIR_LEADTIME NUMBER Attribute indicating time to repair the part at the supplier site. Active
REPAIR_YIELD NUMBER Attribute indicating the yield when you upgrade or repair a defective part. Active
PREPOSITION_POINT VARCHAR2 1 Attribute indicating the push type relationship with a trading partner. Active
REPAIR_PROGRAM NUMBER Attribute indicating the relationship with the vendor for the repair of an item. Active
SUBCONTRACTING_COMPONENT NUMBER Attribute indicating the subcontracting type associated to this item when it is used as a subcontracting component in Chargeable Subcontracting. Choices - Prepositioned, Synchronized. Active
OUTSOURCED_ASSEMBLY NUMBER Attribute indicating whether the Item is Outsourced assembly item Active
EGO_MASTER_ITEMS_DFF_CTX VARCHAR2 1 Attribute indicating the Flexfield associated with the item. Not used in Fusion Active
GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2 1 Enabled for data synchronization Active
TRADE_ITEM_DESCRIPTOR VARCHAR2 35 Trade Item Descriptor also known as Trade Item Unit Descriptor/Pack Type is used to describe the Global Trade Item Number (GTIN) hierarchy level. Hierarchy is used as link between different levels of a product (Item) logistical chain. Active
ASSET_TRACKED_FLAG VARCHAR2 1 Attribute indicating whether item is tracked as an asset in installed base
ASSET_CLASS VARCHAR2 30 Attribute indicating the asset class an item belongs to.
SERVICE_DURATION_TYPE_CODE VARCHAR2 3 Attribute indicating type of duration applicable for a service item
SERVICE_START_TYPE_CODE VARCHAR2 3 Attribute indicating the type of service start rule which should be used for a service item.
START_UPON_MILESTONE_CODE VARCHAR2 3 Attribute indicating the milestone for starting a service. Not used in Fusion
SERVICE_START_DELAY NUMBER Attribute specifying the delay in starting a service after a milestone.
ALLOW_SUSPEND_FLAG VARCHAR2 1 Attribute indicating if a service can be suspended.
ALLOW_TERMINATE_FLAG VARCHAR2 1 Attribute indicating if a service can be terminated.
REQUIRES_FULFILLMENT_LOC_FLAG VARCHAR2 1 Attribute indicating that a fulfillment location needs to be captured when ordering the service item.
REQUIRES_ITM_ASSOCIATION_FLAG VARCHAR2 1 Used for check box value. Attribute indicating that a service item needs to be applied to another item at order time.
STYLE_ITEM_ID NUMBER 18 Attribute referring to the associated Style Item Active
STYLE_ITEM_FLAG VARCHAR2 1 A Style represents a silhouette or model item use to group multiple similar items (SKUs) within. Generally, the items group under a particular style item will be differentiated by 1 or more product variant attributes. Examples include color and size for fashion, flavor and size for grocery, etc Active
LAST_SUBMITTED_NIR_ID NUMBER 18 Number of the New Item Request which processed most recently Active
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request Active
ELIGIBILITY_COMPATIBILITY_RULE VARCHAR2 1 A specific set of constraints or requirements that must be met for the offer to be available to a customer. For example, the customer may need to be a member of the loyalty program, or live in a certain state, or be in good financial standing with the company, or not be locked into an existing contract to be eligible for an offer. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ACD_TYPE VARCHAR2 30 Yes Values ADD/UPDATE/DELETE/HISTORY - ADD/DELETE not for item cases Active
CHANGE_LINE_ID NUMBER 20 Yes A unique identifier of a change order. Active
VERSION_ID NUMBER 20 Yes Version number to identify a version uniquely within a revision Active
MASTER_ITEM_VERSION_ID NUMBER 18 If org assignment saved in the change or version context then it stores master item version id
VERSION_START_DATE DATE Yes Date when new version is set to be effective Active
VERSION_END_DATE DATE Date after which the version will no longer remain effective. Active
IMPLEMENTATION_DATE DATE The date when an event will take place. Active
TEMPLATE_ITEM_FLAG VARCHAR2 1 Attribute used to mark the item as a template Active
QSC_SALES_PRODUCT_TYPE VARCHAR2 20 Attribute indicating classification of an item or product for sales processes Active
MATCH_APPROVAL_LEVEL NUMBER 1 Status of the Match Approvals. It can be either PO or Receipt. Active
INVOICE_MATCH_OPTION NUMBER 1 Indicates the Invoice Matching used. Values can be Null, 2 Way, 3 way or 4 Way. Active
DEFAULT_TEMPLATE_FLAG VARCHAR2 1 Check box indicating whether the template will be selected for defaulting when items are created. Active
INSPECTION_REQUIRED_FLAG VARCHAR2 1 Attribute indicating whether inspection is required at the time of receiving.Not used in Fusion. Active
RECEIPT_REQUIRED_FLAG VARCHAR2 1 Flag indicating supplier receipt is required before payment.Not used in Fusion. Active
ASSET_CATEGORY_ID NUMBER 18 Default asset category associated with the item. Active
EXPENSE_ACCOUNT NUMBER 18 Account used when tracking a non-asset item. Active
SALES_ACCOUNT NUMBER 18 Account used when tracking a sales item. Active
SALES_PRODUCT_TYPE VARCHAR2 30 Attribute indicating classification of an item or product for sales processes Active
SALES_PRODUCT_SUB_TYPE VARCHAR2 3 Attribute indicating the sales product sub type. Not used in Fusion.
ALT_ITEM_CODE VARCHAR2 40 Attribute indicating the substitute identifier for Item Active
CHANGE_BIT_MAP VARCHAR2 400 Yes Attribute indicating attribute changed value. Active
CURRENT_PHASE_CODE VARCHAR2 120 Each phase represents a set of tasks and deliverables that are required before promoting the object to the next phase of the Item Lifecycle. For example, the life cycle phases for a computer component life cycle might be: Concept, Design, Prototype, Preproduction, Production, and Retirement. Active
INVENTORY_ORGANIZATION_ID NUMBER 18 An Organization that tracks inventory transactions and balances, and/or that manufactures or distributes products. Active
ITEM_NUMBER VARCHAR2 300 Any part, material, product or service that is unique as compared with other items by nature of its attributes in product data hub. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
DQ_SEMANTIC_KEY VARCHAR2 4000 Semantic key associated with the data quality for the item. Active
DQ_REQUIRED_FLAG VARCHAR2 1 Attribute indicating whether the attribute participates in DQ or not. Active
THREAD_ID NUMBER 18 Attribute indicating the thread identifier associated with the publication. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. EGP_SYSTEM_ITEMS_DFF (EGP_SYSTEM_ITEMS_DFF)
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
BACK_TO_BACK_ENABLED VARCHAR2 1 Indicates that an item is enabled for back-to-back ordering.
CONTRACT_MANUFACTURING VARCHAR2 1 Indicates that the item is used in contract manufacturing
SAFETY_STOCK_PLANNING_METHOD VARCHAR2 30 Indicates the type of safety stock planning method to be used in planning.
DEMAND_PERIOD NUMBER Attribute that indicates the demand period.
DAYS_OF_COVER NUMBER Attribute that indicates the number of days of cover.
MASTER_ORG_ID NUMBER 18 Identification of Master Organization
OUTSIDE_PROCESS_SERVICE_FLAG VARCHAR2 1 This attribute indicates whether the item can be added to a outside processing purchase order
ALLOW_MAINTENANCE_ASSET_FLAG VARCHAR2 1 Attribute indicating that maintainable assets can be defined for the item.
ENABLE_GENEALOGY_TRACKING_FLAG VARCHAR2 1 Attribute indicating that item is enabled for genealogy tracking
COMPLETENESS_SCORE NUMBER 3 Attribute indicating the completeness score of the item data
CSS_ENABLED_FLAG VARCHAR2 1 Attribute indicating that item is enabled for use on Customer Self Service Application
ENGINEERED_ITEM_FLAG VARCHAR2 1 Attribute indicating item is designed and engineered using product development application
FORCE_PURCHASE_LEAD_TIME_FLAG VARCHAR2 1 This determines whether an item's purchasing lead time is enforced as a hard constraint or not in planning.
REPLACEMENT_TYPE VARCHAR2 30 This determines whether item is field or customer replaceable.
HARD_PEGGING_LEVEL VARCHAR2 25 It determines the type of pegging considered by the planning engine during the supply or demand netting process.
COMN_SUPPLY_PRJ_DEMAND_FLAG VARCHAR2 1 It determines if material can be planned, picked and issued from common inventory if sufficient inventory does not exist in project inventory.
ENABLE_IOT_FLAG VARCHAR2 1 It determines whether an asset can be enabled for IoT, for the item.
EXPENDITURE_TYPE_ID NUMBER 18 It stores the id corresponding to Default Expenditure Type.
PRIMARY_IMAGE_URL VARCHAR2 4000 Stores relative Image URL of Primary Image Attachment.
PACKAGING_STRING_ID NUMBER 18 It Stores the String ID of the Packaging String.
CREATE_SUPPLY_AFTER_DATE DATE The date after which supply can be created. Active
CREATE_FIXED_ASSET VARCHAR2 30 Attribute indicating the point where the item is asset capitalized. Active
UNDER_COMPL_TOLERANCE_TYPE VARCHAR2 30 Attribute that identifies the under completion tolerance type. Active
UNDER_COMPL_TOLERANCE_VALUE NUMBER Attribute indicating the acceptable percent or quantity of assemblies that you will allow to be under-completed. Active
REPAIR_TRANSACTION_CODE VARCHAR2 250 Code that indicates the system, component, and position where an asset item will be used to maintain another asset.
CREATED_FROM_ITEM_ID NUMBER 18 Attribute indicating the Item from which the copy has been made
CREATED_FROM_REVISION_ID NUMBER 18 Attribute indicating the Revision of the Item from which the copy has been made
ITEM_OBJECT_TYPE VARCHAR2 400 Indicates the type of item object. Active

Foreign Keys

Table Foreign Table Foreign Key Column
ego_item_associations egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_item_cat_assignments egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
ap_invoice_lines_all egp_system_items_b INVENTORY_ITEM_ID, ORG_ID
ego_sku_variant_attr_usages egp_system_items_b STYLE_ITEM_ID, ORGANIZATION_ID
ego_sku_variant_attr_usages egp_system_items_b SKU_ITEM_ID, ORGANIZATION_ID
pjb_invoice_lines egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID
pjb_bill_trxs egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID
egp_system_items_interface egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_system_items_tl egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
pjb_inv_line_dists egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID
ap_invoice_lines_interface egp_system_items_b INVENTORY_ITEM_ID, ORG_ID
ego_item_eff_b egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_item_categories egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
ra_interface_lines_all egp_system_items_b INVENTORY_ITEM_ID, ORG_ID
pjb_rev_distributions egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID
egp_item_relationships_b egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_item_revisions_b egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_item_text_tl egp_system_items_b ITEM_ID, ORG_ID
ego_item_eff_tl egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
pjb_billing_events egp_system_items_b INVENTORY_ITEM_ID, ITEM_ORGANIZATION_ID

Indexes

Index Uniqueness Tablespace Columns Status
EGP_SYSTEM_ITEMS_B_N1 Non Unique FUSION_TS_TX_IDX ITEM_NUMBER Active
EGP_SYSTEM_ITEMS_B_N10 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, PLANNER_CODE Active
EGP_SYSTEM_ITEMS_B_N11 Non Unique FUSION_TS_TX_IDX WEB_STATUS, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N13 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, WIP_SUPPLY_LOCATOR_ID Active
EGP_SYSTEM_ITEMS_B_N14 Non Unique FUSION_TS_TX_IDX BASE_ITEM_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N15 Non Unique FUSION_TS_TX_IDX STYLE_ITEM_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N16 Non Unique FUSION_TS_TX_IDX UPPER("ITEM_NUMBER"), ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N18 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, DQ_REQUIRED_FLAG, THREAD_ID Active
EGP_SYSTEM_ITEMS_B_N19 Non Unique FUSION_TS_TX_IDX TEMPLATE_ITEM_FLAG, ITEM_CATALOG_GROUP_ID Active
EGP_SYSTEM_ITEMS_B_N20 Non Unique FUSION_TS_TX_IDX UPPER("DQ_SEMANTIC_KEY"), ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N21 Non Unique FUSION_TS_TX_IDX STYLE_ITEM_FLAG Active
EGP_SYSTEM_ITEMS_B_N22 Non Unique FUSION_TS_TX_IDX TRADE_ITEM_DESCRIPTOR Active
EGP_SYSTEM_ITEMS_B_N23 Non Unique Default LAST_UPDATE_DATE, ORGANIZATION_ID, COMPLETENESS_SCORE
EGP_SYSTEM_ITEMS_B_N24 Non Unique Default TO_DATE((TO_CHAR("CREATION_DATE",'MM/DD/YYYY')),'MM/DD/YYYY')
EGP_SYSTEM_ITEMS_B_N25 Non Unique Default CURRENT_PHASE_CODE, ITEM_CATALOG_GROUP_ID
EGP_SYSTEM_ITEMS_B_N26 Non Unique FUSION_TS_TX_IDX CREATION_DATE Active
EGP_SYSTEM_ITEMS_B_N27 Non Unique Default ORGANIZATION_ID, SALES_PRODUCT_TYPE
EGP_SYSTEM_ITEMS_B_N28 Non Unique Default ORGANIZATION_ID, SERVICEABLE_PRODUCT_FLAG
EGP_SYSTEM_ITEMS_B_N29 Non Unique Default INVENTORY_ITEM_ID, INVENTORY_ORGANIZATION_ID, VERSION_ID, CHANGE_LINE_ID, ACD_TYPE
EGP_SYSTEM_ITEMS_B_N3 Non Unique FUSION_TS_TX_IDX INVENTORY_ITEM_STATUS_CODE Active
EGP_SYSTEM_ITEMS_B_N30 Non Unique Default REQUEST_ID
EGP_SYSTEM_ITEMS_B_N31 Non Unique Default INVENTORY_ITEM_ID, STYLE_ITEM_ID, ORGANIZATION_ID
EGP_SYSTEM_ITEMS_B_N32 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, UPPER("ITEM_NUMBER"), ACD_TYPE
EGP_SYSTEM_ITEMS_B_N33 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, TEMPLATE_ITEM_FLAG, DEFAULT_TEMPLATE_FLAG
EGP_SYSTEM_ITEMS_B_N4 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, AUTO_CREATED_CONFIG_FLAG Active
EGP_SYSTEM_ITEMS_B_N5 Non Unique FUSION_TS_TX_IDX WH_UPDATE_DATE Active
EGP_SYSTEM_ITEMS_B_N6 Non Unique FUSION_TS_TX_IDX ITEM_CATALOG_GROUP_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, TEMPLATE_ITEM_FLAG, APPROVAL_STATUS Active
EGP_SYSTEM_ITEMS_B_N7 Non Unique FUSION_TS_TX_IDX PRODUCT_FAMILY_ITEM_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N8 Non Unique FUSION_TS_TX_IDX COMMS_NL_TRACKABLE_FLAG, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_N9 Non Unique FUSION_TS_TX_IDX ORGANIZATION_ID, BUYER_ID Active
EGP_SYSTEM_ITEMS_B_U1 Unique FUSION_TS_TX_IDX INVENTORY_ITEM_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_B_U3 Unique FUSION_TS_TX_DATA ORGANIZATION_ID, ITEM_NUMBER Active