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 |