EGP_SYSTEM_ITEMS_B

SharedUsed in 76 subject areas97 reporting columns

Product Hub / Items (EGP) — base table — language-neutral data (paired with _TL labels and the _VL view).

Primary key: not yet catalogued for EGP_SYSTEM_ITEMS_B — reference Oracle Tables & Views guide.

Columns

Column	In reports	Description (inferred)
ALLOWED_UNITS_LOOKUP_CODE	●	Lookup code for the allowed units.
ALLOW_EXPRESS_DELIVERY_FLAG	●	Indicator (Y/N) for the allow express delivery.
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	●	Indicator (Y/N) for the allow substitute receipts.
ALLOW_UNORDERED_RECEIPTS_FLAG	●	Indicator (Y/N) for the allow unordered receipts.
APPROVAL_STATUS	●	Status of the approval.
ASSET_CATEGORY_ID	●	Identifier for the asset category.
ATP_COMPONENTS_FLAG	●	Indicator (Y/N) for the atp components.
ATP_FLAG	●	Indicator (Y/N) for the atp.
BOM_ITEM_TYPE	●	Type of bom item.
BULK_PICKED_FLAG	●	Indicator (Y/N) for the bulk picked.
CHARGE_PERIODICITY_CODE	●	Code identifying the charge periodicity.
COLLATERAL_FLAG	●	Indicator (Y/N) for the collateral.
CONFIG_MODEL_TYPE	●	Type of config model.
CONTAINER_ITEM_FLAG	●	Indicator (Y/N) for the container item.
CONTAINER_TYPE_CODE	●	Code identifying the container type.
COSTING_ENABLED_FLAG	●	Indicator (Y/N) for the costing enabled.
CREATION_DATE	●	Date and time the row was created.
CUSTOMER_ORDER_ENABLED_FLAG	●	Indicator (Y/N) for the customer order enabled.
CUSTOMER_ORDER_FLAG	●	Indicator (Y/N) for the customer order.
CYCLE_COUNT_ENABLED_FLAG	●	Indicator (Y/N) for the cycle count enabled.
DEFAULT_INCLUDE_IN_ROLLUP_FLAG	●	Indicator (Y/N) for the default include in rollup.
DIMENSION_UOM_CODE	●	Code identifying the dimension unit of measure.
DOWNLOADABLE_FLAG	●	Indicator (Y/N) for the downloadable.
DUAL_UOM_CONTROL	●	Dual unit of measure control.
EFFECTIVITY_CONTROL	●	Effectivity control.
ELECTRONIC_FLAG	●	Indicator (Y/N) for the electronic.
ELIGIBILITY_COMPATIBILITY_RULE	●	Eligibility compatibility rule.
EQUIPMENT_TYPE	●	Type of equipment.
EVENT_FLAG	●	Indicator (Y/N) for the event.
GRADE_CONTROL_FLAG	●	Indicator (Y/N) for the grade control.
HAZARD_CLASS_ID	●	Identifier for the hazard class.
HOLD_DAYS	●	Hold days.
INDIVISIBLE_FLAG	●	Indicator (Y/N) for the indivisible.
INTERNAL_ORDER_ENABLED_FLAG	●	Indicator (Y/N) for the internal order enabled.
INTERNAL_ORDER_FLAG	●	Indicator (Y/N) for the internal order.
INVENTORY_ASSET_FLAG	●	Indicator (Y/N) for the inventory asset.
INVENTORY_ITEM_ID	●	Identifier for the inventory item.
INVOICEABLE_ITEM_FLAG	●	Indicator (Y/N) for the invoiceable item.
INVOICE_ENABLED_FLAG	●	Indicator (Y/N) for the invoice enabled.
INVOICE_MATCH_OPTION	●	Invoice match option.
ITEM_NUMBER	●	Item number.
ITEM_TYPE	●	Type of item.
LIST_PRICE_PER_UNIT	●	List price per unit.
LOCATION_CONTROL_CODE	●	Code identifying the location control.
LOT_CONTROL_CODE	●	Code identifying the lot control.
LOT_STATUS_ENABLED	●	Lot status enabled.
LOT_TRANSLATE_ENABLED	●	Lot translate enabled.
MARKET_PRICE	●	Market price.
MATCH_APPROVAL_LEVEL	●	Match approval level.
MATURITY_DAYS	●	Maturity days.
MTL_TRANSACTIONS_ENABLED_FLAG	●	Indicator (Y/N) for the mtl transactions enabled.
ONT_PRICING_QTY_SOURCE	●	Ont pricing quantity source.
ORGANIZATION_ID	●	Identifier for the organization.
OUTSIDE_OPERATION_FLAG	●	Indicator (Y/N) for the outside operation.
OUTSIDE_OPERATION_UOM_TYPE	●	Type of outside operation unit of measure.
OUTSOURCED_ASSEMBLY	●	Outsourced assembly.
PICK_COMPONENTS_FLAG	●	Indicator (Y/N) for the pick components.
PRIMARY_UOM_CODE	●	Code identifying the primary unit of measure.
PURCHASING_ENABLED_FLAG	●	Indicator (Y/N) for the purchasing enabled.
PURCHASING_ITEM_FLAG	●	Indicator (Y/N) for the purchasing item.
PURCHASING_TAX_CODE	●	Code identifying the purchasing tax.
QTY_RCV_EXCEPTION_CODE	●	Code identifying the quantity receiving exception.
RECEIPT_DAYS_EXCEPTION_CODE	●	Code identifying the receipt days exception.
RECEIVING_ROUTING_ID	●	Identifier for the receiving routing.
RESERVABLE_TYPE	●	Type of reservable.
RESTRICT_LOCATORS_CODE	●	Code identifying the restrict locators.
RESTRICT_SUBINVENTORIES_CODE	●	Code identifying the restrict subinventories.
RETURNABLE_FLAG	●	Indicator (Y/N) for the returnable.
RETURN_INSPECTION_REQUIREMENT	●	Return inspection requirement.
REVISION_QTY_CONTROL_CODE	●	Code identifying the revision quantity control.
SALES_PRODUCT_TYPE	●	Type of sales product.
SECONDARY_UOM_CODE	●	Code identifying the secondary unit of measure.
SERIAL_NUMBER_CONTROL_CODE	●	Code identifying the serial number control.
SERIAL_STATUS_ENABLED	●	Serial status enabled.
SHELF_LIFE_CODE	●	Code identifying the shelf life.
SHELF_LIFE_DAYS	●	Shelf life days.
SHIPPABLE_ITEM_FLAG	●	Indicator (Y/N) for the shippable item.
SHIP_MODEL_COMPLETE_FLAG	●	Indicator (Y/N) for the shipment model complete.
SOURCE_ORGANIZATION_ID	●	Identifier for the source organization.
SO_TRANSACTIONS_FLAG	●	Indicator (Y/N) for the so transactions.
STOCK_ENABLED_FLAG	●	Indicator (Y/N) for the stock enabled.
STYLE_ITEM_FLAG	●	Indicator (Y/N) for the style item.
STYLE_ITEM_ID	●	Identifier for the style item.
TAXABLE_FLAG	●	Indicator (Y/N) for the taxable.
TAX_CODE	●	Code identifying the tax.
TRACKING_QUANTITY_IND	●	Tracking quantity ind.
TRADE_ITEM_DESCRIPTOR	●	Trade item descriptor.
UNIT_HEIGHT	●	Unit height.
UNIT_LENGTH	●	Unit length.
UNIT_OF_ISSUE	●	Unit of issue.
UNIT_VOLUME	●	Unit volume.
UNIT_WEIGHT	●	Unit weight.
UNIT_WIDTH	●	Unit width.
UN_NUMBER_ID	●	Identifier for the un number.
VEHICLE_ITEM_FLAG	●	Indicator (Y/N) for the vehicle item.
VOLUME_UOM_CODE	●	Code identifying the volume unit of measure.
WEIGHT_UOM_CODE	●	Code identifying the weight unit of measure.

Used by reports

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

Where this surfaces in OTBI

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for EGP_SYSTEM_ITEMS_B?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us