1. Tables and Views for SCM
  2. EGP_SYSTEM_ITEMS_INTERFACE

EGP_SYSTEM_ITEMS_INTERFACE

Interface table to import items through batch import program.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

EGP_SYSTEM_ITEMS_INTERFAC_PK

TRANSACTION_ID

Columns

Name Datatype Length Precision Comments Status
INVENTORY_ITEM_ID NUMBER 18 Attribute indicating the unique identifier of the item. Active
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface processing
ITEM_CLASS_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.
NEW_ITEM_CLASS_ID NUMBER 18 Attribute indicating the new item class in the import
ITEM_CLASS_NAME VARCHAR2 820 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.
NEW_ITEM_CLASS_NAME VARCHAR2 820 Attribute indicating the name of the new item class in import
HTML_LONG_DESCRIPTION CLOB Statement describing an item, formatted using hyper text tags.
ORGANIZATION_ID NUMBER 18 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 Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created 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
THREAD_NUMBER NUMBER 18 Attribute indicating the thread number associated with the import 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 Date on which Item is inactivated Active
DESCRIPTION VARCHAR2 240 Statement, picture in words, or account that describes; descriptive representation. 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. Active
ATTRIBUTE1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. 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 enabling item description to be updated in a PO. 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 lot 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 quantity 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 the engineering item identifier. Not used in Fusion 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 Attribute indicating the number of days to dynamically calculate safety stock quantities. 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
CYCLE_COUNT_ENABLED_FLAG VARCHAR2 1 Attribute indicating whether the item is on for automatic cycle count scheduling. Active
DEMAND_SOURCE_LINE VARCHAR2 30 Attribute indicating the demand source line associated with the item. Not used in Fusion Active
COPY_ITEM_ID NUMBER 18 Internal item id of the item used as a source for copying at the time of item creation Active
REVISION VARCHAR2 18 Code identifying the Item Revision Active
AUTO_CREATED_CONFIG_FLAG VARCHAR2 1 Attribute indicating whether the Item is autocreated. 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
DEMAND_SOURCE_TYPE NUMBER Attribute indicating the demand source type associated with the item. Not used in Fusion Active
DEMAND_SOURCE_HEADER_ID NUMBER Attribute indicating the demand source header associated with the item. Not used in Fusion Active
TRANSACTION_ID NUMBER 18 Attribute indicating the transaction identifier associated with the import Active
PROCESS_STATUS NUMBER 18 Attribute indicating the process status of the record in the import. Active
ORGANIZATION_CODE VARCHAR2 18 Unique Identifier of the Organization 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
COPY_ITEM_NUMBER VARCHAR2 81 Unique identifier of the item used as a source for copying at the time of item creation Active
TEMPLATE_ID NUMBER 18 An item template is a standard set of attribute values that can be used to define or update items. Active
TEMPLATE_NAME VARCHAR2 960 Attribute indicating the name of the template Active
COPY_ORGANIZATION_ID NUMBER 18 Internal id of the organization associated with the item used as a source for copying at the time of item creation Active
COPY_ORGANIZATION_CODE VARCHAR2 3 Unique identifier of the organization associated with the item used as a source for copying at the time of item creation 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
TRANSACTION_TYPE VARCHAR2 10 This refers to Transaction Type for Item Supplier Site Organization Association Mass Update Active
MATERIAL_COST NUMBER Attribute indicating the material cost associated with the item Active
MATERIAL_SUB_ELEM VARCHAR2 10 Attribute indicating the material sub element associated with the item Active
MATERIAL_OH_RATE NUMBER Attribute indicating the material over head cost associated with the item Active
MATERIAL_OH_SUB_ELEM VARCHAR2 10 Attribute indicating the material over head sub type associated with the item Active
MATERIAL_SUB_ELEM_ID NUMBER Attribute indicating the material sub element identifier associated with the item Active
MATERIAL_OH_SUB_ELEM_ID NUMBER Attribute indicating the material over head identifier associated with the item Active
AUTO_REL_TIME_FENCE_CODE NUMBER Additional days added to the Release Time Fence Active
AUTO_REL_TIME_FENCE_DAYS 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
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
BATCH_ID NUMBER 18 A unique identifier of an item batch. Active
CHECK_SHORTAGES_FLAG VARCHAR2 1 Attribute indicating to check for material shortages for the item. 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
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
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
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
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
LONG_DESCRIPTION VARCHAR2 4000 Statement, picture in words, or account that describes; descriptive representation. 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
CARTONIZATION_GROUP_ID NUMBER Attribute indicating the cartonization group associated with the item. Not used in Fusion. 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
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
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. Active
ATTRIBUTE17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield. 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 Syllable or syllables put at the beginning of another word to change its meaning. 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 report, value and account for any item costs 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 - Propositioned, Synchronized. Active
OUTSOURCED_ASSEMBLY NUMBER Attribute indicating whether the Item is Outsourced assembly item Active
SOURCE_SYSTEM_ID NUMBER 18 An external system from which item and its information is being imported into product hub. Active
SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Unique identifier of the spoke item that an item is related to. In a related item relationship, an item can be related to another item. This string represents the target item in the relationship. Active
SOURCE_SYSTEM_REFERENCE_DESC VARCHAR2 240 Attribute indicating the source system description in the import Active
GLOBAL_TRADE_ITEM_NUMBER VARCHAR2 14 An identifier for trade items developed by GS1 (comprising the former EAN International and Uniform Code Council). Such identifiers are used to look up product information in a database (often by inputting the number through a bar code scanner pointed at Active
CONFIRM_STATUS VARCHAR2 3 Match action that indicates whether the item is ready for import. Active
CHANGE_ID NUMBER 18 A unique identifier of a change order. Active
CHANGE_LINE_ID NUMBER 18 A unique identifier of a change order. Active
ITEM_CATALOG_GROUP_NAME VARCHAR2 820 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
REVISION_IMPORT_POLICY VARCHAR2 30 Attribute indicating the revision import policy associated with the import batch. Active
GTIN_DESCRIPTION VARCHAR2 240 Additional information provided to identify global trade item number of an item. Active
OBJECT_VERSION_NUMBER NUMBER 9 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
GDSN_OUTBOUND_ENABLED_FLAG VARCHAR2 1 Enabled for data synchronization Active
TRADE_ITEM_DESCRIPTOR VARCHAR2 35 Pack type, also known as Trade Item Unit Descriptor 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 start milestone code of the item. 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
STYLE_ITEM_NUMBER VARCHAR2 700 Attribute referring to the associated Style Item Active
COPY_REVISION_ID NUMBER 18 Unique identifier of the item revision used as a source for copying at the time of item creation Active
BUNDLE_ID NUMBER 18 Unique identifier that groups items together in a single transaction. Active
MESSAGE_TIMESTAMP DATE Attribute indicating the time associated with the error message generated Active
MESSAGE_ID NUMBER 18 Attribute indicating the message identifier generated while processing the import. Active
OPERATION VARCHAR2 80 Specific characteristic of an item. Attributes may be operational e.g. item status or user defined e.g. color. Active
TOP_ITEM_FLAG VARCHAR2 1 Attribute indicating whether the item is a top item in the pack associated with the import of packaging hierarchy Active
GPC_CODE VARCHAR2 8 Attribute indicating the category code in the import 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
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.
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
NIR_REQUIRED VARCHAR2 1 Attribute indicating whether the Items created for this Item Class can be routed via New Item Request. Active
VERSION_START_DATE DATE Date when new version is set to be effective Active
VERSION_REVISION_CODE VARCHAR2 18 Code identifying the Version Revision Active
PHASE_NUMBER NUMBER 18 Each phase code 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 lifecycle phases for a computer component lifecycle might be: Concept, Design, Prototype, Pr Active
VERSION_LABEL VARCHAR2 80 Attribute indicating the version associated with the item Active
VERSION_ENABLED_FLAG VARCHAR2 1 Indicates whether the items of the Item Class will be Versioned or Not. Active
VERSION_REVISION_ID NUMBER 18 The attribute incdicating the revision associated with the item version. Active
VERSION_ID NUMBER 18 Version number to identify a version uniquely within a revision 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
DQ_SEMANTIC_KEY VARCHAR2 4000 Attribute indicating the data quality semantic key associated with the item Active
INTRA_BATCH_MATCH_STATUS VARCHAR2 20 Attribute indicating the intra batch match status Active
INTRA_BATCH_MATCHED_SSREF VARCHAR2 255 Attribute indicating the intra batch matching of the source system cross reference Active
DQ_DATA_TYPE VARCHAR2 40 Data type of the Transactional Attribute. It can be Character, Date, Number or Time. Active
INTRA_BATCH_MATCH_PARENT VARCHAR2 255 Attribute indicating the intra batch matching of the parent item Active
DQ_COMPLETION_STATUS VARCHAR2 1 Attibute indicating whether the data quality associated with the item was processed. Active
LAST_IMPORT_REQUEST_ID NUMBER 18 Request Id of the ESS request that has processed this record last. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
SALES_ACCOUNT NUMBER 18 Account used when tracking a sales item.
EXPENSE_ACCOUNT NUMBER 18 Account used when tracking a non-asset item.
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.
ASSET_CATEGORY_ID NUMBER 18 Default asset category associated with the item.
MATCH_COUNT NUMBER 18 Attribute indicating the number of item matches found by DQ in import
LAST_MATCH_DATE TIMESTAMP Attribute indicating the date of the last match in the import
PRIMARY_UOM_NAME VARCHAR2 25 The principal unit of measure in which the quantity of an item is managed.
SECONDARY_UOM_NAME VARCHAR2 25 Attribute indicating the Secondary Unit of Measure through which the Item can be transacted.
DIMENSION_UOM_NAME VARCHAR2 25 Attribute indicating unit of measure for the dimension of the item.
WEIGHT_UOM_NAME VARCHAR2 25 Attribute indicating Weight Unit of Measure
VOLUME_UOM_NAME VARCHAR2 25 Attribute indicating Volume Unit of Measure.
CHARGE_PERIODICITY_NAME VARCHAR2 25 The time the system uses to price a persistent or recurring service or product.
SERVICE_DURATION_PERIOD_NAME VARCHAR2 25 Attribute indicating positive number to indicate the service duration period
BASE_ITEM_NUMBER VARCHAR2 300 Attribute indicating the Model from which an ATO configuration was created.
BATCH_NUMBER VARCHAR2 40 Unique identifier of the batch that is used for item import.
DEFAULT_SHIPPING_ORG_CODE VARCHAR2 18 Attribute indicating the code of 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
HAZARD_CLASS_CODE VARCHAR2 30 Attribute indicating the category of Hazard material for International trade.
PAYMENT_TERMS_NAME VARCHAR2 15 Attribute indicating a valid payment terms code.
SOURCE_ORGANIZATION_CODE VARCHAR2 18 Attribute indicating the Organization from which an internal requisition draws the item.
SOURCE_SYSTEM_CODE VARCHAR2 30 Attribute indicating the source system code in the import
UN_NUMBER_CODE VARCHAR2 30 United Nations Identification Number used for International Trade purposes.
LOAD_REQUEST_ID NUMBER 18 Attribute indicating the request id associated with the import process.
BUYER_NAME VARCHAR2 960 Attribute indicating the default buyer of the Item.
EXPENSE_ACCOUNT_KFFDISP VARCHAR2 4000 Account used when tracking a non-asset item.
ASSET_CATEGORY_KFFDISP VARCHAR2 4000 Key Flexfield structure name for Asset Category.
INVOICING_RULE_NAME VARCHAR2 120 Attribute indicating invoicing rule to determine the period in which an invoice is sent
SALES_ACCOUNT_KFFDISP VARCHAR2 4000 Attribute indicating the KFF associated with the Sales account.
ACCOUNTING_RULE_NAME VARCHAR2 120 Attribute indicating the accounting rule to identify special revenue recognition rules for an item.
DEFAULT_LOT_STATUS_CODE VARCHAR2 320 Attribute indicating the Default Lot Status code for the Item.
DEFAULT_SERIAL_STATUS_CODE VARCHAR2 320 Attribute indicating the Default Serial Status code of the Item.
PROCESS_SUPPLY_LOCATOR_KFFDISP VARCHAR2 4000 Attribute indicating the KFF associated with the Supply locator
PROCESS_YIELD_LOCATOR_KFFDISP VARCHAR2 4000 Attribute indicating the KFF associated with the process yield
WIP_SUPPLY_LOCATOR_KFFDISP VARCHAR2 4000 Attribute indicating the KFF associated with the WIP supply locator.
PREPROCESS_COMPLETION_STATUS NUMBER Attribute indicating the completion status of the pre processing in import.
PICKING_RULE_NAME VARCHAR2 320 Attribute indicating picking rule that defines the order in which subinventories, locators, lots, and revisions are picked.
MATCH_TYPE VARCHAR2 30 The type of match selected by the user.
NEW_PHASE_NUMBER NUMBER 18 New reommneded value of phase number, as per Structure heirarchy.
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.
OUTSIDE_PROCESS_SERVICE_FLAG VARCHAR2 1 Attribute that identifies that an item will be processed by an outside vendor.
INTERFACE_DATA_TYPE VARCHAR2 100 Data type of record. Values-BATCH/SUPPLIER_STAGE/SPOKE_STAGE
SUPPLIER_ID NUMBER 18 Unique identifier for supplier in case of supplier stage record
STAGED_ITEM_STATUS VARCHAR2 100 Attribute indicating the status of the item in the staging
STAGED_ITEM_ACTION_DATE DATE Last date when action was taken on stage record
STAGED_ITEM_ACTION_MESSAGE VARCHAR2 4000 Message for sending notification for stage item
PRODUCT_UPLOAD_ID NUMBER 18 Attribute indicating the product upload id associated with the import
STAGED_ITEM_TRANSACTION_ID NUMBER 18 Attribute indicating the transaction identifier associated with the item in staging
ITEM_IMPORT_CATEGORY_CODE VARCHAR2 820 Attribute indicating the category code associated with the item
ITEM_IMPORT_CATEGORY_NAME VARCHAR2 81 Attribute indicating the category associated with the item
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
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
STANDARD_COVERAGE VARCHAR2 150 Attribute indicating Coverage template associated with the item
PRC_BU_NAME VARCHAR2 240 Attribute indicating procurement business unit.
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.
BUYER_EMAIL_ADDRESS VARCHAR2 240 Attribute indicating email address of buyer.
DEFAULT_EXPENDITURE_TYPE VARCHAR2 240 It refers to the default expenditure type to be used in project Supply Chain transactions.
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.
CHANGE_NUMBER VARCHAR2 50 Engineering change order number or New Item request number
CHANGE_BUNDLE_ID NUMBER 18 Unique identifier that groups items together in a single transaction for change.
PACKAGING_STRING VARCHAR2 100 This column stores packaging string.
PACKAGING_STRING_ID NUMBER 18 It Stores String Id of the packaging String.
HAS_ERRORS NUMBER 1 This column stores if the record has any errors
CREATE_SUPPLY_AFTER_DATE DATE The date after which supply can be created. Active
BOM_COPY_COMMON VARCHAR2 30 Attribute indicating whether item is getting created by bom copy common use case.
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.
REPAIR_TRANSACTION_NAME VARCHAR2 250 Attribute that indicates the name of the system, component and position where an asset item will be used to maintain another asset.
PURCHASING_UOM_NAME VARCHAR2 50 This column stores the Purchasing UOM value and is used in Item Import of BPA lines from Purchasing.

Foreign Keys

Table Foreign Table Foreign Key Column
EGP_SYSTEM_ITEMS_INTERFACE egp_system_items_b INVENTORY_ITEM_ID, ORGANIZATION_ID
egp_product_notf_details egp_system_items_interface TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns Status
EGP_SYSTEM_ITEMS_INTF_N1 Non Unique FUSION_TS_INTERFACE INVENTORY_ITEM_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_INTF_N10 Non Unique Default BATCH_NUMBER
EGP_SYSTEM_ITEMS_INTF_N11 Non Unique FUSION_TS_INTERFACE BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, THREAD_NUMBER, PHASE_NUMBER Active
EGP_SYSTEM_ITEMS_INTF_N12 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, REQUEST_ID, PROCESS_STATUS, PREPROCESS_COMPLETION_STATUS
EGP_SYSTEM_ITEMS_INTF_N14 Non Unique Default BATCH_ID, REQUEST_ID, BUNDLE_ID
EGP_SYSTEM_ITEMS_INTF_N15 Non Unique Default NEW_ITEM_CLASS_ID
EGP_SYSTEM_ITEMS_INTF_N16 Non Unique Default INTERFACE_DATA_TYPE, SUPPLIER_ID, STAGED_ITEM_STATUS
EGP_SYSTEM_ITEMS_INTF_N17 Non Unique Default INTERFACE_DATA_TYPE, PRODUCT_UPLOAD_ID
EGP_SYSTEM_ITEMS_INTF_N18 Non Unique Default STAGED_ITEM_TRANSACTION_ID
EGP_SYSTEM_ITEMS_INTF_N19 Non Unique Default BATCH_ID, THREAD_NUMBER, PHASE_NUMBER
EGP_SYSTEM_ITEMS_INTF_N2 Non Unique FUSION_TS_INTERFACE ITEM_NUMBER, BATCH_ID, ORGANIZATION_ID Active
EGP_SYSTEM_ITEMS_INTF_N20 Non Unique Default BATCH_ID, REQUEST_ID, CHANGE_BUNDLE_ID
EGP_SYSTEM_ITEMS_INTF_N21 Non Unique Default LOAD_REQUEST_ID
EGP_SYSTEM_ITEMS_INTF_N22 Non Unique Default BATCH_ID, THREAD_NUMBER, PROCESS_STATUS, HAS_ERRORS
EGP_SYSTEM_ITEMS_INTF_N23 Non Unique EGP_SYSTEM_ITEMS_INTF_N23 REQUEST_ID, BATCH_ID, ORGANIZATION_ID, UPPER("ITEM_NUMBER")
EGP_SYSTEM_ITEMS_INTF_N3 Non Unique FUSION_TS_INTERFACE SOURCE_SYSTEM_REFERENCE, BATCH_ID, PREPROCESS_THREAD_NUMBER, SOURCE_SYSTEM_ID, ORGANIZATION_ID, PROCESS_STATUS Active
EGP_SYSTEM_ITEMS_INTF_N4 Non Unique FUSION_TS_INTERFACE ORGANIZATION_ID, ITEM_NUMBER Active
EGP_SYSTEM_ITEMS_INTF_N5 Non Unique FUSION_TS_INTERFACE SOURCE_SYSTEM_REFERENCE, BATCH_ID, PREPROCESS_THREAD_NUMBER, CONFIRM_STATUS, PROCESS_STATUS, ORGANIZATION_ID, SOURCE_SYSTEM_ID Active
EGP_SYSTEM_ITEMS_INTF_N6 Non Unique FUSION_TS_INTERFACE INTRA_BATCH_MATCHED_SSREF Active
EGP_SYSTEM_ITEMS_INTF_N7 Non Unique Default UPPER("SOURCE_SYSTEM_REFERENCE")
EGP_SYSTEM_ITEMS_INTF_N8 Non Unique Default UPPER("ITEM_NUMBER")
EGP_SYSTEM_ITEMS_INTF_N9 Non Unique Default BATCH_ID, PROCESS_STATUS, ORGANIZATION_ID, NVL("ITEM_NUMBER","TRANSACTION_ID")
EGP_SYSTEM_ITEMS_INTF_U1 Unique FUSION_TS_INTERFACE TRANSACTION_ID Active