Items

The Items view object contains the details of item content. Use this to view item and item attributes.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ItemExtractPVO

Primary Keys : ItemBasePEOInventoryItemId, ItemBasePEOOrganizationId

Initial Extract Date : ItemBasePEOCreationDate

Incremental Extract Date : ItemBasePEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ItemBasePEOAcceptableEarlyDays	Number of days before which the planning process won't reschedule the sales order. For example, if the due date on the original sales order is 10-JUN, and if the Acceptable Early Days is 3, and if the new due date is less than or equal to 13-JUN, then the planning process won't suggest rescheduling.
ItemBasePEOAcceptableRateDecrease	Value that identifies the amount the planning process uses to decrease current daily rates inside the planning time fence.
ItemBasePEOAcceptableRateIncrease	Value that identifies the amount the planning process uses to increase current daily rates inside the planning time fence.
ItemBasePEOAccountingRuleId	Value that identifies the accounting rule to identify special revenue recognition rules for an item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Accounting Rules task. This attribute doesn't have a default value.
ItemBasePEOAcdType	Indicates whether this is a production row, change row or change history row.
ItemBasePEOAllowExpressDeliveryFlag	Contains one of the following values: Y or N. If Y, then when the quantity to deliver equals the balance on the purchase order line, then deliver all distributions for this item with one data entry transaction. If N, then don't deliver all distributions for the item with one data entry transaction, even if the quantity to deliver equals the balance on the purchase order line. This attribute doesn't have a default value.
ItemBasePEOAllowItemDescUpdateFlag	Contains one of the following values: Y or N. If Y, then allow the application to update the purchasing document description. If N, then don't allow this update.
ItemBasePEOAllowMaintenanceAssetFlag	Contains one of the following values: Y or N. If Y, then maintainable assets can be defined for the item. If N, then maintainable assets can't be defined for the item. The default value is false.
ItemBasePEOAllowSubstituteReceiptsFlag	Contains one of the following values: Y or N. If Y, then allow the application to receive a defined substitute instead of the item. If N, then don't allow this substitution. This attribute doesn't have a default value.
ItemBasePEOAllowSuspendFlag	Contains one of the following values: Y or N. If Y, then allow suspending of a service contract. If N, then don't allow suspending of a service contract. The default value is false.
ItemBasePEOAllowTerminateFlag	Contains one of the following values: Y or N. If Y, then allow permanent stopping of a service contract. If N, then don't allow permanent stopping of a service contract. The default value is false.
ItemBasePEOAllowUnorderedReceiptsFlag	Contains one of the following values: Y or N. If Y, then allow the application to receive the item without a purchase order. If N, then don't allow this receipt. This attribute doesn't have a default value.
ItemBasePEOAllowedUnitsLookupCode	Value that identifies the conversion method used for units of measure associated with an item. A list of accepted values is defined in the lookup type EGP_ITEM_CONVERSIONS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 3.
ItemBasePEOAltItemCode	Contains one of the following values: Y or N. If Y, then allow the application to receive a defined substitute instead of the item. If N, then don't allow this substitution. This attribute doesn't have a default value.
ItemBasePEOApprovalStatus	Value that identifies the approval status of the item. A list of accepted values is defined in the lookup type EGP_APPROVAL_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Approved.
ItemBasePEOAsnAutoexpireFlag	Contains one of the following values: 1 or 2. If 1, then automatically expire the advance shipment notice. If 2, then don't automatically expire the advance shipment notice. The default value is 2.
ItemBasePEOAssetCategoryId	Value that identifies the key flexfield structure name for asset category. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Key Flexfields task.
ItemBasePEOAssetClass	Value that identifies the asset class of the item. A list of accepted values is defined in the lookup type EGP_CSE_ASSET_CLASS. Review and update the value for this attribute using and the Manage Standard Lookups task in the Setup and Maintenance work area.
ItemBasePEOAssetTrackedFlag	Contains one of the following values: Y or N. If Y, then the item is classified as an asset item. If N, then the item isn't classified as an asset item. The default value is N.
ItemBasePEOAtoForecastControl	Value that uniquely identifies the type of forecast demand to use for the item. A list of accepted values is defined in the lookup type EGP_ATO_FORECAST_CONTROL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOAtpComponentsFlag	Value that indicates additional components to be included in the bill of material for assemble-to-order or pick-to-order items in available-to-promise checking. A list of accepted values is defined in the lookup type EGP_ORDATPCHECKVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOAtpFlag	Contains one of the following values: Y or N. If Y, then calculate and print available-to-promise on the planning detail report. If N, then don't calculate and print. The default value is N.
ItemBasePEOAtpRuleId	Internal value that identifies the picking rule that defines the order in which subinventories, locators, lots, and revisions are picked. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Picking Rules task. The default value is none.
ItemBasePEOAttribute1	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute10	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute11	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute12	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute13	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute14	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute15	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute16	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute17	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute18	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute19	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute2	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute20	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute21	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute22	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute23	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute24	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute25	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute26	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute27	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute28	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute29	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute3	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute30	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute4	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute5	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute6	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute7	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute8	Segment for the Item descriptive flexfield.
ItemBasePEOAttribute9	Segment for the Item descriptive flexfield.
ItemBasePEOAttributeCategory	Context name for the Item descriptive flexfield.
ItemBasePEOAttributeDate1	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeDate2	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeDate3	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeDate4	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeDate5	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber1	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber10	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber2	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber3	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber4	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber5	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber6	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber7	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber8	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeNumber9	Date segment for the Item descriptive flexfield.
ItemBasePEOAttributeTimestamp1	Date and time segment for the Item descriptive flexfield.
ItemBasePEOAttributeTimestamp2	Date and time segment for the Item descriptive flexfield.
ItemBasePEOAttributeTimestamp3	Date and time segment for the Item descriptive flexfield.
ItemBasePEOAttributeTimestamp4	Date and time segment for the Item descriptive flexfield.
ItemBasePEOAttributeTimestamp5	Date and time segment for the Item descriptive flexfield.
ItemBasePEOAutoCreatedConfigFlag	Contains one of the following values: Y or N. If Y, then the item is created automatically. If N, then the item isn't created automatically. The default value is N.
ItemBasePEOAutoLotAlphaPrefix	Value that identifies the alphabetic prefix to add to the child lot.
ItemBasePEOAutoReduceMps	Value that indicates the option to decide when to reduce master production schedule quantities to zero.
ItemBasePEOAutoSerialAlphaPrefix	Prefix associated when serial numbers are automatically created for an item.
ItemBasePEOBackOrderableFlag	Contains one of the following values: Y or N. If Y, then when available-to-promise fails, then backorder the item. If N, then don't backorder the item. The default value is N.
ItemBasePEOBackToBackEnabled	Contains one of the following values' or N. If Y, then enable the item for back-to-back ordering. If N, then don't enable the item for back-to-back ordering. The default value is N.
ItemBasePEOBaseItemId	Value that uniquely identifies the model to use when creating an assemble-to-order configuration.
ItemBasePEOBomItemType	Value that indicates the type of bill of material the item can have. Values include standard, model, planning, and other. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 4.
ItemBasePEOBuildInWipFlag	Contains one of the following values: Y or N. If Y, then create discrete jobs or repetitive assemblies in Oracle Manufacturing Cloud. If N, then discrete jobs aren't created. The default value is N.
ItemBasePEOBulkPickedFlag	Contains one of the following values: Y or N. If Y, then pick items in bulk. If N, then don't pick items in bulk. The default value is N.
ItemBasePEOBuyerId	Value that identifies the default buyer that can be associated with the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Buyers task.
ItemBasePEOCarryingCost	Percent of unit cost that represents the internal cost to stock one unit for one year.
ItemBasePEOCasNumber	Value that uniquely identifies the chemical abstracts service registry number which identifies the chemical substance.
ItemBasePEOChangeLineId	Value that uniquely identifies a change order.
ItemBasePEOChargePeriodicityCode	Value that identifies the invoicing rule used to determine the period in which an invoice is sent. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Invoicing Rules task. The default value is null.
ItemBasePEOCheckShortagesFlag	Contains one of the following values: Y or N. If Y, then check for material shortages for the item. If N, then don't check for material shortages for the item. The default value is N.
ItemBasePEOChildLotFlag	Contains one of the following values: Y or N. If Y, and if the parent lot is specified, use lot control on the item during the transaction. If N, then don't use lot control on the item during the transaction. The default value is N.
ItemBasePEOChildLotPrefix	Value that identifies the alphabetic prefix to add to the child lot.
ItemBasePEOChildLotStartingNumber	Value that identifies the first number to use in a sequence of numbers for the child lot.
ItemBasePEOChildLotValidationFlag	Contains one of the following values: Y or N. If Y, then ensure the child lot numbers conform to the child lot parameters. If N, then don't ensure the child lot numbers conform to the child lot parameters. The default value is N.
ItemBasePEOCollateralFlag	Contains one of the following values: Y or N. If Y, then the item is collateral. If N, then the item isn't collateral. The default value is N.
ItemBasePEOCommsActivationReqdFlag	Contains one of the following values: Y or N. If Y, then the item is eligible for electronic fulfillment by the service fulfillment manager. If N, then the item isn't eligible for electronic fulfillment. The default value is N.
ItemBasePEOComnSupplyPrjDemandFlag	Value that determines if material can be planned, picked, and issued from common inventory if sufficient inventory doesn't exist in project inventory.
ItemBasePEOCompletenessScore	Value that identifies the completeness score of the item data.
ItemBasePEOConfigMatch	Value that indicates the capability to match to one of existing configurations of the models. Values include Standard, Container, or Null. A list of accepted values is defined in the lookup type EGP_CONFIG_MATCH. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Y.
ItemBasePEOConfigModelType	Value that indicates the behavior of the configurable models in the configurator. A list of accepted values is defined in the lookup type EGP_CONFIG_MODEL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemBasePEOConfigOrgs	Value that indicates whether the configured bill of materials can be created based on item or sourcing. A list of accepted values is defined in the lookup type EGP_CONFIG_ORG. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null.
ItemBasePEOConsignedFlag	Contains one of the following values: 1 or 2. If 1, then the item resides at your location but the supplier owns it. If 2, then the item resides at your location and you own it. The default value is 2.
ItemBasePEOContainerItemFlag	Contains one of the following values: Y or N. If Y, then use containers to ship items. If N, then don't use containers to ship items. The default value is N.
ItemBasePEOContainerTypeCode	Value that indicates the type of container used for shipping of the item. A list of accepted values is defined in the lookup type EGP_CONTAINER_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null.
ItemBasePEOContinousTransfer	Value that identifies whether to perform continuous interorganization transfers.
ItemBasePEOContractItemTypeCode	Value that identifies the contract item type.
ItemBasePEOContractManufacturing	Contains one of the following values: Y or N. If Y, then use the item in contract manufacturing. If N, then don't use the item in contract manufacturing. This attribute doesn't have a default value.
ItemBasePEOConvergence	Attribute indicating whether you use a convergent consumption pattern in planning.
ItemBasePEOCopyLotAttributeFlag	Contains one of the following values: Y or N. If Y, then the child lot inherits the parent lot attributes. If N, then the child lot doesn't inherit the parent lot attributes. The default value is N.
ItemBasePEOCostingEnabledFlag	Contains one of the following values: Y or N. If Y, then item costs are reported and accounted. If N, then item costs aren't reported and accounted. The default value is N.
ItemBasePEOCoverageScheduleId	Value that identifies the template associated with the contract item type.
ItemBasePEOCreateFixedAsset	Indicates when the item is asset capitalized. Values include At Receipt, At Invoice, or Null. A list of accepted values is defined in the lookup type ORA_EGP_FIXED_ASSET. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is null.
ItemBasePEOCreateSupplyAfterDate	Date after which the supply for the item has to be considered for demand.
ItemBasePEOCreateSupplyFlag	Contains one of the following values: Y or N. If Y, then suggest supply for this item. If N, then don't suggest supply for this item. The default value is Y.
ItemBasePEOCreatedBy	User who created the item.
ItemBasePEOCreatedFromItemId	Value that identifies the item from which this item was created.
ItemBasePEOCreatedFromRevisionId	Value that identifies the revision of the item from which this item was created.
ItemBasePEOCreationDate	Date and time when item revision was created.
ItemBasePEOCriticalComponentFlag	Value that identifies the item as a critical component for MPS and DRP planning.
ItemBasePEOCssEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is enabled for customer self service. If N, then the item isn't enabled for customer self service. The default value is N.
ItemBasePEOCumManufacturingLeadTime	Value that identifies the number of days required to manufacture the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble. The application subtracts the lead time offset of the operation to adjust each component.
ItemBasePEOCumulativeTotalLeadTime	Value that identifies the number of days required to assemble the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble.
ItemBasePEOCurrentPhaseCode	Value that identifies the name of the lifecycle phase of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task.
ItemBasePEOCurrentPhaseId	Internal name for the lifecycle phase of the item.
ItemBasePEOCustomerOrderEnabledFlag	Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: Y or N. If Y, then Item can be ordered by external customers. If N, then Item can't be ordered by external customers. The default value is N.
ItemBasePEOCustomerOrderFlag	Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: Y or N. If Y, then Item can be ordered by external customers. If N, then Item can't be ordered by external customers. The default value is N.
ItemBasePEOCycleCountEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is scheduled for automatic cycle count. If N, then the item isn't cycle counted. The default value is N.
ItemBasePEODaysEarlyReceiptAllowed	Value that identifies the number of days that you can receive the item before the promise date occurs without warning or rejection.
ItemBasePEODaysLateReceiptAllowed	Value that identifies the number of days that you can receive the item after the promise date occurs without warning or rejection.
ItemBasePEODaysMaxInvSupply	Value that identifies the maximum days of supply to allow before replenishing the item.
ItemBasePEODaysMaxInvWindow	Any materials and supplies in the application that's 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 and so on.
ItemBasePEODaysOfCover	Value that identifies the number of days of cover for the item. The application multiplies Days of Cover by the average demand to calculate the safety stock level.
ItemBasePEODaysTgtInvSupply	Value that identifies the maximum days of supply to allow before replenishing the item.
ItemBasePEODaysTgtInvWindow	Value that identifies the target Inventory, in terms of quantity, to be achieved by the Planning Engine.
ItemBasePEODefaultGrade	Value that identifies the default grade for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Grades task. The default value is Null.
ItemBasePEODefaultIncludeInRollupFlag	Contains one of the following values: Y or N. If Y, then the item is included in the cost rollup. If N, then the item isn't included in the cost rollup. The default value is N.
ItemBasePEODefaultLotStatusId	Internal value that identifies the default lot status for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. The default value is Null.
ItemBasePEODefaultSerialStatusId	Internal value that identifies the default serial status of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. The default value is Null.
ItemBasePEODefaultShippingOrg	Value that identifies the primary shipping organization. If item is the source attribute of the warehouse object in the standard value rule set for the order, this is the default organization when creating an order.
ItemBasePEODefaultSoSourceType	Value that identifies if an item is to be drop-shipped. If the value is internal, the item won't be drop-shipped. If the value is external, the item will be drop-shipped.
ItemBasePEODefaultTemplateFlag	Value that identifies if the template will be selected for defaulting when items are created.
ItemBasePEODefectTrackingOnFlag	Contains one of the following values: Y or N. If Y, then defects of the item are tracked. If N, then defects of the item aren't tracked. The default value is N.
ItemBasePEODemandPeriod	Value that identifies the number of days to use when calculating the average daily demand.
ItemBasePEODemandTimeFenceCode	Value that identifies the point in time to use when applying restrictions on demand recommendations. A list of accepted values is defined in the lookup type EGP_TIME_FENCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEODemandTimeFenceDays	Value that identifies the 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.
ItemBasePEODimensionUomCode	Value that identifies the unit of measure to use for item dimensions. Review and update the value for this attribute using the Setup and Maintenance work area, and the Units of Measures task.
ItemBasePEODivergence	Value that identifies whether divergent supply pattern for planning can be used.
ItemBasePEODownloadableFlag	Contains one of the following values: Y or N. If Y, then the customer can download the item. For example, the item is a software upgrade. If N, then the customer can't download the item. For example, the item is a desktop computer. The default value is N.
ItemBasePEODqRequiredFlag	Value that identifies whether or not the attribute participates in Data Quality.
ItemBasePEODqSemanticKey	Value that identifies the semantic key associated with the data quality for the item.
ItemBasePEODrpPlannedFlag	Value that identifies the type of planning that will be used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Not Planned.
ItemBasePEODualUomControl	Value that identifies the unit of measure that's used to determine pricing for an item. A list of accepted values is defined in the lookup type EGP_ITEM_PRICING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Primary.
ItemBasePEODualUomDeviationHigh	Value that identifies the deviation allowed on the higher side for a transaction on the secondary quantity derived from the default conversion factor.
ItemBasePEODualUomDeviationLow	Value that identifies the deviation allowed on the lower side for a transaction on the secondary quantity derived from the default conversion factor.
ItemBasePEOEffectivityControl	Value that identifies how to calculate lead time based on date, model, or unit number. A list of accepted values is defined in the lookup type EGP_BOM_EFFEC_CTRL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemBasePEOElectronicFlag	Contains one of the following values: Y or N. If Y, then the item exists only in electronic format. If N, then the item doesn't exist only in electronic format. The default value is N.
ItemBasePEOEligibilityCompatibilityRule	Contains one of the following values: Y or N. If Y, then the item can be made available to customers based on specific requirements and constraints. 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. If N, then the item can be made available to customers even if they don't meet specific requirements. The default value is N.
ItemBasePEOEnableGenealogyTrackingFlag	Contains one of the following values: Y or N. If Y, then the item is enabled for genealogy tracking. If N, then the item isn't enabled for genealogy tracking. The default value is N.
ItemBasePEOEnableIotFlag	Contains one of the following values: Y or N. If Y, and if the parent lot is specified, use lot control on the item during the transaction. If N, then don't use lot control on the item during the transaction. The default value is N.
ItemBasePEOEnabledFlag	Value that identifies if the item class is enabled.
ItemBasePEOEndAssemblyPeggingFlag	Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_EGP_HARD_PEGGING_LEVEL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOEndDateActive	Date when the item is inactivated.
ItemBasePEOEnforceShipToLocationCode	Value that indicates an option to control whether the supplier can deliver to a location that differs from the ship to location defined on the purchase order. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOEngineeredItemFlag	Contains one of the following values: Y or N. If Y, then the item is an engineering item. If N, then the item isn't an engineering item. The default value is N.
ItemBasePEOEngineeringItemId	Value that identifies the internal name for an engineering item.
ItemBasePEOEquipmentType	Contains one of the following values: 1 or 2. If 1, then the item is equipment. If 2, then the item isn't equipment. The default value is 2.
ItemBasePEOEventFlag	Contains one of the following values: Y or N. If Y, then the item is an event. If N, then the item isn't an event. The default value is N.
ItemBasePEOExcludeFromBudgetFlag	Contains one of the following values: 1 or 2. If 1, then allow transactions in order management. If 2, then don't allow transactions in order management. The transaction in order management identifies the type of transaction in each application where the budget control transaction starts. The default value is 2.
ItemBasePEOExpenditureTypeId	Value that identifies the default expenditure type to be used in project-driven supply chain transactions. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Expenditure Types task. The default value is Null.
ItemBasePEOExpenseAccount	Value that identifies the account used when tracking a nonasset item.
ItemBasePEOExpirationActionCode	Internal value that identifies the default action to be taken for this item when the lot expires or the lot fails a quality check. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Expiration Actions task. The default value is Null.
ItemBasePEOExpirationActionInterval	Value that identifies the number of days the application adds to the expiration date before taking an action on the lot.
ItemBasePEOFinancingAllowedFlag	Contains one of the following values: Y or N. If Y, then the customer can finance this item. If N, then the customer can't finance this item. The default value is null.
ItemBasePEOFixedDaysSupply	Value that identifies the number of days to use to modify the size and timing of each planned order quantity.
ItemBasePEOFixedLeadTime	Value that identifies the number of days required to assemble an item independent of the sales order quantity, such as setup time or disassemble time.
ItemBasePEOFixedLotMultiplier	Value used to identify the multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate.
ItemBasePEOFixedOrderQuantity	Value that identifies the quantity to use to modify the size of each planned order quantity or each repetitive daily rate.
ItemBasePEOForcePurchaseLeadTimeFlag	Contains one of the following values: Y or N. If Y, then the item's purchasing lead time is enforced as a hard constraint. If N, then the item's purchasing lead time isn't enforced as a hard constraint. The default value is Y.
ItemBasePEOForecastHorizon	Value that identifies the time period to use when forecasting demand for the item.
ItemBasePEOFullLeadTime	Value that identifies the number of days required to assemble the item, including the adjusted, cumulative, and total lead time for the component that requires the longest time to assemble.
ItemBasePEOGdsnOutboundEnabledFlag	Contains one of the following values: Y or N. If Y, the item is enabled for data synchronization. If N, then item won't be synced.
ItemBasePEOGlobalAttribute1	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute10	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute2	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute3	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute4	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute5	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute6	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute7	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute8	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttribute9	Segment for the Item descriptive global flexfield.
ItemBasePEOGlobalAttributeCategory	Context name for the Item global descriptive flexfield.
ItemBasePEOGradeControlFlag	Contains one of the following values: Y or N. If Y, then the item is grade controlled in addition to lot controlled. If N, then the item isn't grade controlled. The default value is N.
ItemBasePEOHardPeggingLevel	Value that identifies the type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_EGP_HARD_PEGGING_LEVEL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOHazardClassId	Value that identifies the category of the hazardous material for international trade. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Hazard Classes task.
ItemBasePEOHazardousMaterialFlag	Contains one of the following values: Y or N. If Y, then the item is hazardous. If N, then the item isn't hazardous. The default value is N.
ItemBasePEOHoldDays	Value that identifies the number of days to add to the lot creation date that determines when you can release the lot.
ItemBasePEOImplementationDate	Date when an event will take place.
ItemBasePEOIndivisibleFlag	Contains one of the following values: Y or N. If Y, then allow orders in fractions of an item. If N, then don't allow orders in fractions of an item. The default value is N.
ItemBasePEOInspectionRequiredFlag	Contains one of the following values: Y or N. If Y, then inspection is needed for items returned by customers. The item then must be transferred to inventory separately. If N, then Inspection isn't needed for items returned by customers. The default value is N.
ItemBasePEOInternalOrderEnabledFlag	Contains one of the following values: Y or N. If Y, then the item can be ordered by internal customers. If N, then the item can't be ordered by internal customers. The default value is N.
ItemBasePEOInternalOrderFlag	Contains one of the following values: Y or N. If Y, then the item can be ordered by internal customers. If N, then the item can't be ordered by internal customers. The default value is N.
ItemBasePEOInternalVolume	Value that identifies the internal volume of the container or vehicle.
ItemBasePEOInventoryAssetFlag	Contains one of the following values: Y or N. If Y, then item is valued as an asset in inventory. If N, then item isn't valued as an asset in inventory. The default value is N.
ItemBasePEOInventoryCarryPenalty	Value that identifies the penalty for jobs that aren't completed before their scheduled finish date.
ItemBasePEOInventoryItemFlag	Contains one of the following values: Y or N. If Y, then the item can be stocked and transacted. If N, then the item can't be stocked and transacted. The default value is N.
ItemBasePEOInventoryItemId	Value that uniquely identifies the item.
ItemBasePEOInventoryItemStatusCode	Status of the transaction activity for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
ItemBasePEOInventoryOrganizationId	Value that uniquely identifies the inventory organization.
ItemBasePEOInventoryPlanningCode	Value that indicates the type of planning for the item. A list of accepted values is defined in the EGP_MATERIAL_PLANNING lookup type. Review the value for this attribute using the Manage Standard Lookups task in the Setup and Maintenance work area. The default value is set to Not Planned.
ItemBasePEOInvoiceCloseTolerance	Value that identifies the percent tolerance to use when closing the purchase order shipment for invoicing.
ItemBasePEOInvoiceEnabledFlag	Contains one of the following values: Y or N. If Y, then the item can be invoiced in Oracle Receivables Cloud. If N, then the item can't be invoiced. The default value is N.
ItemBasePEOInvoiceMatchOption	Value that identifies the type of match used for the purchase order. A list of accepted values is defined in the lookup type EGP_POINV_MAT_OPTION. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Receipt.
ItemBasePEOInvoiceableItemFlag	Contains one of the following values: Y or N. If Y, then the item can be invoiced in Oracle Receivables Cloud. If N, then the item can't be invoiced. The default value is N.
ItemBasePEOInvoicingRuleId	Value that identifies the invoicing rule used to determine the period in which an invoice is sent. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Invoicing Rules task. The default value is null.
ItemBasePEOItemCatalogGroupId	Value that identifies 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.
ItemBasePEOItemNumber	Value that identifies the name or number of the part, item, product, or service.
ItemBasePEOItemObjectType	Value that indicates if the entity is an item or a document object.
ItemBasePEOItemType	Value that identifies the type of item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOLastContractPrice	Value that identifies the last contract price of the item.
ItemBasePEOLastContractPriceCurrencyCode	Value that identifies the currency associated with the last contract price of the item.
ItemBasePEOLastSubmittedNirId	Value that identifies the new item request number associated with the item.
ItemBasePEOLastUpdateDate	Date and time when the item was most recently updated.
ItemBasePEOLastUpdateLogin	Session login associated with the user who updated the item.
ItemBasePEOLastUpdatedBy	User who most recently updated the item.
ItemBasePEOLeadTimeLotSize	Value that identifies the quantity to use when computing the processing lead time.
ItemBasePEOListPricePerUnit	Value that identifies the list price of the item.
ItemBasePEOLocationControlCode	Value that identifies the physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf.
ItemBasePEOLotControlCode	Value that identifies the ability to use lot numbers during material transactions for tracking of item batches. A list of accepted values is defined in the lookup type EGP_LOT_CONTROL_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemBasePEOLotDivisibleFlag	Contains one of the following values: Y or N. If Y, then allow the application to allocate, reserve, or move partial lot quantities. If N, then don't allow the application to allocate, reserve, or move partial lot quantities. The default value is N.
ItemBasePEOLotMergeEnabled	Contains one of the following values: Y or N. If Y, then allow the application to merge multiple lots into one lot for an item that lots control. If N, then don't allow this merge. The default value is N.
ItemBasePEOLotSplitEnabled	Contains one of the following values: Y or N. If Y, then the lot-controlled item can be split into many lots. If N, then the lot-controlled item can't be split into many lots. The default value is N.
ItemBasePEOLotStatusEnabled	Contains one of the following values: Y or N. If Y, then the item lot is status controlled at the lot level. If N, then the item lot isn't status controlled. The default value is N.
ItemBasePEOLotSubstitutionEnabled	Contains one of the following values: Y or N. If Y, then allow the application to substitute a lot in the transaction. If N, then don't allow this substitution. The default value is N.
ItemBasePEOLotTranslateEnabled	Contains one of the following values: Y or N. If Y, then Item lots can be translated. If N, then Item Lots can't be translated. The default value is N.
ItemBasePEOMarketPrice	Value that identifies the market price of the item that's printed on the purchase order lines.
ItemBasePEOMatchApprovalLevel	Status of the match approvals. Values include PO or Receipt. A list of accepted values is defined in the lookup type EGP_MAT_APPR_LEV. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is blank.
ItemBasePEOMaterialBillableFlag	Value that identifies user definable attributes and must be tagged with one of three billing category codes as follows: material, labor, or expense. Billing types are used in Contracts to define discount percent.
ItemBasePEOMaterialCost	Value that identifies the material cost of the item.
ItemBasePEOMaterialCostCurrencyCode	Value that identifies the currency associated with the material cost of the item.
ItemBasePEOMaturityDays	Value that identifies the number of days to add to the lot creation date to determine the lot maturity date.
ItemBasePEOMaxMinmaxQuantity	Value that identifies the minimum quantity for minimum-maximum planning.
ItemBasePEOMaximumLoadWeight	Value that identifies the maximum load weight of the container or vehicle. You can specify value for this attribute only if any one of the attributes VehicleItemFlag or ContainerItemFlag is set to true.
ItemBasePEOMaximumOrderQuantity	Value that identifies the minimum order quantity of the item.
ItemBasePEOMinMinmaxQuantity	Value that identifies the minimum quantity for minimum-maximum planning.
ItemBasePEOMinimumFillPercent	Value that identifies the minimum percent to fill the container or vehicle before shipping.
ItemBasePEOMinimumLicenseQuantity	Value that identifies the minimum number of licenses the customer must order for the item.
ItemBasePEOMinimumOrderQuantity	Value that identifies the minimum order quantity of the item.
ItemBasePEOMrpCalculateAtpFlag	Contains one of the following values: Y or N. If Y, then calculate and print available-to-promise on the planning detail report. If N, then don't calculate and print. The default value is N.
ItemBasePEOMrpPlanningCode	Value that identifies the organization-level planning for the item. Choices -Min-Max, Not Planned, and Reorder Point.
ItemBasePEOMrpSafetyStockCode	Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOMrpSafetyStockPercent	Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOMtlTransactionsEnabledFlag	Contains one of the following values: Y or N. If Y, then transactions can be performed on the item. If N, then transactions can't be performed on the item. The default value is N.
ItemBasePEOMustUseApprovedVendorFlag	Contains one of the following values: Y or N. If Y, then require an approved supplier. If N, then don't require an approved supplier. The default value is N.
ItemBasePEONegativeMeasurementError	Value that identifies the maximum negative difference to allow between the cycle count quantity and the on-hand quantity that the application monitors.
ItemBasePEONegotiationRequiredFlag	Contains one of the following values: Y or N. If Y, then require negotiation. If N, then don't require negotiation. The default value is N.
ItemBasePEOOntPricingQtySource	Value that identifies the unit of measure in which the item is priced for the selling of the products and services.
ItemBasePEOOperationSlackPenalty	Value that indicates, in units per day, the operation slack penalty for items having lag time between operations.
ItemBasePEOOrderCost	Value that identifies the fixed costs that are associated with placing a sales order for the item.
ItemBasePEOOrderModifierStartQtyFlag
ItemBasePEOOrderableOnWebFlag	Contains one of the following values: Y or N. If Y, then allow the customer to order the item from the web. If N, then don't allow the customer to order the item from the web. The default value is Y.
ItemBasePEOOrganizationId	Value that uniquely identifies the item.
ItemBasePEOOutsideOperationUomType	Value that identifies the type of unit of measure that outside processing uses. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOOutsideProcessServiceFlag	Contains one of the following values: Y or N. If Y, then the item can be added to an outside processing purchase order. If N, then the item can't be added to an outside processing purchase order. The default value is N.
ItemBasePEOOverReturnTolerance	Value that identifies the amount of the shipment that can be more than the return tolerance at the time of receiving or receipt creation.
ItemBasePEOOverShipmentTolerance	Value that indicates the amount of the shipment that can be more than the shipment tolerance at the time of ship confirmation.
ItemBasePEOOvercompletionToleranceType	Value that identifies the overcompletion tolerance type. Valid values include Percent or Amount. A list of accepted values is defined in the lookup type EGP_OVER_TOLTYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemBasePEOOvercompletionToleranceValue	Value that identifies the acceptable percent or quantity of assemblies that are allowed to be over completed.
ItemBasePEOOverrunPercentage	Value that identifies the amount of the shipment that can be more than the return tolerance at the time of receiving or receipt creation.
ItemBasePEOParentChildGenerationFlag	Value that identifies how the application generates child lot numbers at the item level.
ItemBasePEOPartsSourcing
ItemBasePEOPaymentTermsId	Internal value that identifies a valid payment terms code. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payment Terms task. This attribute doesn't have a default value.
ItemBasePEOPickComponentsFlag	Contains one of the following values: Y or N. If Y, then items can be picked from finished goods inventory. If N, then items can't be picked from finished goods inventory. The default value is N.
ItemBasePEOPickingRuleId	Internal value that indicates the picking rule that defines the order in which subinventories, locators, lots, and revisions are picked. Review and update the value for this attribute using the Manage Picking Rules task in the Setup and Maintenance work area. The default value is none.
ItemBasePEOPlannedInvPointFlag	Value that identifies the 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.
ItemBasePEOPlannerCode	Value that identifies the material planner for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Planners task.
ItemBasePEOPlanningExceptionSet	Value that identifies 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.
ItemBasePEOPlanningMakeBuyCode	Value that identifies whether your organization manufactures or buys the item. A list of accepted values is defined in the lookup type EGP_PLANNING_MAKE_BUY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOPlanningTimeFenceCode	Value that identifies the point in time to use when applying restrictions on planning recommendations. A list of accepted values is defined in the lookup type EGP_TIME_FENCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOPlanningTimeFenceDays	Value that identifies the days to add to the planning time fence. Use this attribute as an option when you define the time fence.
ItemBasePEOPositiveMeasurementError	Value that identifies the maximum positive difference to allow between the cycle count quantity and the on-hand quantity that the application monitors.
ItemBasePEOPostprocessingLeadTime	Value that identifies the number of days required to receive a purchased item into inventory from the supplier receipt.
ItemBasePEOPreliminaryItemFlag	Contains one of the following values: Y or N. If Y, then the item is a preliminary item. If N, then the item isn't a preliminary item.
ItemBasePEOPrepositionPoint	Value that identifies the push type relationship with a trading partner.
ItemBasePEOPreprocessingLeadTime	Value that identifies the days that must be added to the purchasing or manufacturing lead time to place an order.
ItemBasePEOPriceTolerancePercent	Value that identifies the maximum price percentage over the normal price range of the item. For example, if the tolerance percentage is 5, then the maximum acceptable price on the purchase order is 5% over the requisition price. In this example, a purchase order price that's 5% above the requisition price isn't acceptable, and you can't approve the purchase order.
ItemBasePEOPrimaryUomCode	Value that identifies the primary unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOProcessCostingEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is used in the costing module of the process manufacturing. If N, then don't use the item in the costing module of the process manufacturing. The default value is N.
ItemBasePEOProcessExecutionEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is used as an ingredient, product, or by-product in a production batch. If N, then don't use the item as ingredient, product, or by-product in a production batch. The default value is N.
ItemBasePEOProcessQualityEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is used in quality module of the process manufacturing. If N, then don't use the item in quality module of the process manufacturing. The default value is N.
ItemBasePEOProcessSupplyLocatorId	Internal value that identifies the locator from which the item is normally consumed as an ingredient in process manufacturing. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. The default value is None.
ItemBasePEOProcessSupplySubinventory	Internal value that identifies a subinventory from which the item is normally consumed as an ingredient in process manufacturing. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task. The default value is None.
ItemBasePEOProcessYieldLocatorId	Internal value that identifies the locator in which you place the results of a production batch. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. The default value is None.
ItemBasePEOProcessYieldSubinventory	Internal value that identifies a subinventory in which you place results of a production batch. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task. The default value is None.
ItemBasePEOPurchasingEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is purchased and received. If N, then the item isn't purchased and received. The default value is N.
ItemBasePEOPurchasingItemFlag	Contains one of the following values: Y or N. If Y, then the item is purchased and received. If N, then the item isn't purchased and received. The default value is N.
ItemBasePEOPurchasingTaxCode	Value that identifies the tax code to use when calculating tax based on location and tax codes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Codes task.
ItemBasePEOQscSalesProductType	Value that identifies the sales product type. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Finished Goods.
ItemBasePEOQtyRcvExceptionCode	Value that identifies the action to be performed when the receive date is outside the range defined by quantity received tolerance.
ItemBasePEOQtyRcvTolerance	Value that identifies the amount of the shipment that can be more than the return tolerance at the time of receiving or receipt creation.
ItemBasePEOReceiptDaysExceptionCode	Value that identifies the action to be performed when the receive date is outside the range defined by days early receipt allowed or days late receipt allowed. Valid values include None, Reject, or Warning. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOReceiveCloseTolerance	Value that identifies the percentage tolerance used to automatically close Purchase Order Shipments for receipt.
ItemBasePEOReceivingRoutingId	Value that identifies the routing of the Items at the time of receipt.
ItemBasePEORecipeEnabledFlag	Contains one of the following values: Y or N. If Y, then the item is used in recipes and formulas in process manufacturing. If N, then don't use the item in recipes and formulas. The default value is N.
ItemBasePEORecoveredPartDispCode	Value that identifies the process for returning defective or unused parts to a warehouse consolidation point. A list of accepted values is defined in the lookup type EGP_RECOVERED_PART_DISP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is N.
ItemBasePEOReleaseTimeFenceCode	Value that identifies the option used to determine a point in time inside which planned orders for discretely planned items are automatically released as WIP jobs or purchase requisitions.
ItemBasePEOReleaseTimeFenceDays	Value that identifies the additional days to be added to the release time fence.
ItemBasePEORepairLeadtime	Value that identifies the time to repair the part at the supplier site.
ItemBasePEORepairProgram	Contains one of the following values: Y or N. If Y, then a service request can be created for the item. If N, then a service request can't be created for the item. The default value is Y.
ItemBasePEORepairTransactionCode	Code that indicates the system, component, and position where an asset item will be used to maintain another asset.
ItemBasePEORepairYield	Value that identifies the yield when you upgrade or repair a defective part.
ItemBasePEORepetitivePlanningFlag	Contains one of the following values: Y or N. If Y, then create discrete jobs or repetitive assemblies in Oracle Manufacturing Cloud. If N, then discrete jobs aren't created. The default value is N.
ItemBasePEOReplacementType	Value that identifies whether an item can be replaced by field or customer. Valid values are Customer, Field, or Null.
ItemBasePEOReplenishToOrderFlag	Value that identifies if the item is generally built for sales order demand. For example, a final assembly work order that's created based on sales order details.
ItemBasePEORequiresFulfillmentLocFlag	Contains one of the following values: Y or N. If Y, then the fulfillment location of the item is required. If N, then the fulfillment location of the item isn't required. The default value is N.
ItemBasePEORequiresItmAssociationFlag	Contains one of the following values: Y or N. If Y, then the item association for the item is required. If N, then the item association for the item isn't required. The default value is N.
ItemBasePEOReservableType	Contains one of the following values: Y or N. If Y, then create material reservations for the item. If N, then don't create material reservations for the item. The default value is Y.
ItemBasePEORestrictLocatorsCode	Contains one of the following values: 1 or 2. If 1, then restrict the transactions of the item from the locator. If 2, then don't restrict the transactions of the item from the locator. The default value is 2.
ItemBasePEORestrictSubinventoriesCode	Contains one of the following values: 1 or 2. If 1, then restrict the transactions of the item from the subinventory. If 2, then don't restrict the transactions of the item from the subinventory. The default value is 2.
ItemBasePEORetestInterval	Value that identifies the number of days after the creation date before retesting the lot.
ItemBasePEOReturnInspectionRequirement	Contains one of the following values: 1 or 2. If 1, then inspection is needed for items returned by customers. The item then must be transferred to inventory separately. If 2, then Inspection isn't needed for items returned by customers. The default value is 2.
ItemBasePEOReturnableFlag	Contains one of the following values: Y or N. If Y, then the item can be returned by external customers. If N, then the item can't be returned by external customers. The default value is N.
ItemBasePEORevisionQtyControlCode	Contains one of the following values: 2 or 1. If 2, then the item is under revision control and it includes inventory attributes. If 1, then the item isn't under revision control and it includes inventory attributes. The default value is 1.
ItemBasePEORoundingControlType	Contains one of the following values: 1 or 2. If 1, then round the quantity on an internal requisition when converting between the unit of measure on the requisition line and the item on the unit of issue. If 2, then don't resolve the unit of issue to an integer. Setting this attribute to False might result in a fractional amount.
ItemBasePEORoundingFactor	Value that identifies the factor to use when rounding the quantity on an internal requisition. This rounding occurs when converting the unit of measure on the requisition line to the unit of measure on the unit of issue. This factor makes sure that the unit of issue resolves to an integer, and not to a fractional amount.
ItemBasePEOSafetyStockBucketDays	Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOSafetyStockPlanningMethod	Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOSalesAccount	Value that identifies the account used when tracking a sales item. This attribute doesn't have a default value.
ItemBasePEOSalesProductType	Value that identifies the sales product type. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Finished Goods.
ItemBasePEOSecondaryDefaultInd	Value that identifies how the conversion between primary and secondary units of measure is handled. Valid values are Default, Fixed, and No Default. You can provide the value of Defaulting Control depending on the value of the Tracking Unit of Measure attribute. If the Tracking Unit of Measure is Primary and Secondary, then the Defaulting Control can be provided. Otherwise, the Defaulting Control can't be provided.
ItemBasePEOSecondaryUomCode	Value that identifies the secondary unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Units of Measures task.
ItemBasePEOSerialNumberControlCode	Value that identifies the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemBasePEOSerialStatusEnabled	Contains one of the following values: Y or N. If Y, then transactions on the item are restricted to the subinventory. If N, then transactions on the item aren't restricted to the subinventory. The default value is N.
ItemBasePEOServBillingEnabledFlag	Contains one of the following values: Y or N. If Y, then enable the billing service. If N, then don't enable the billing service. The default value is N.
ItemBasePEOServReqEnabledCode	Contains one of the following values: Y or N. If Y, then a service request can be created for the item. If N, then a service request can't be created for the item. The default value is Y.
ItemBasePEOServiceDuration	Value that identifies the duration for an item to fulfill a service contract. The value of this attribute depends on the value for Service Duration Type Value. You can update the value for Service Duration if the value for Service Duration Type is either variable or fixed.
ItemBasePEOServiceDurationPeriodCode	Value that identifies the duration for an item to fulfill a service contract. A list of accepted values is the units of measures belonging to time Units of Measure class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. The value of this attribute depends on the value for Service Duration Type Value. You can update the value for Service Duration if the value for Service Duration Type is either variable or fixed.
ItemBasePEOServiceDurationTypeCode	Value that identifies the type of duration for an item that fulfills a service contract. A list of accepted values is defined in the lookup type EGP_SERV_DUR_TYPE_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOServiceStartDelay	Value that identifies the delay in starting a service after a milestone.
ItemBasePEOServiceStartTypeCode	Value that identifies the type of service start rule to use for an item that fulfills a service contract. A list of accepted values is defined in the lookup type EGP_SERV_START_TYPE_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOServiceStartingDelay	Value that identifies the delay in starting a service after a milestone.
ItemBasePEOServiceableProductFlag	Contains one of the following values: Y or N. If Y, then a service request can be created for the item. If N, then a service request can't be created for the item. The default value is Y.
ItemBasePEOShelfLifeCode	Value that identifies the shelf life for the item.
ItemBasePEOShelfLifeDays	Value that identifies the number of days that each lot is active.
ItemBasePEOShipModelCompleteFlag	Contains one of the following values: Y or N. If Y, then ship each configuration derived from this configuration model only when the required quantities for each component, option, and item that the configuration references is available. If N, then ship the configuration even if one or more of these quantities isn't available. The default value is N.
ItemBasePEOShippableItemFlag	Contains one of the following values: Y or N. If Y, then the application can ship the item to the customer. If N, then the application can't ship the item. For example, the item is a service agreement that you don't physically ship. The default value is N.
ItemBasePEOShrinkageRate	Value that identifies the average amount of material you expect to lose when manufacturing or storing the item.
ItemBasePEOSoAuthorizationFlag	Value that identifies the type of authorization required before creating the sales order. A list of accepted values is defined in the lookup type EGP_MSI_GP_RELEASE_AUTH. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Customer.
ItemBasePEOSoTransactionsFlag	Contains one of the following values: Y or N. If Y, then transactions can be performed on the item. If N, then transactions can't be performed on the item. The default value is N.
ItemBasePEOSourceOrganizationId	Value that identifies the organization that an internal requisition uses as the source to get the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
ItemBasePEOSourceSubinventory	Internal value that identifies a subinventory from which the item is normally consumed. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task.
ItemBasePEOSourceType	Value that identifies how to replenish an inventory that the requests have depleted. A list of accepted values is defined in the lookup type EGP_SOURCE_TYPES. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemBasePEOStartAutoLotNumber	Value that identifies the first number to use in a sequence of numbers for the child lot.
ItemBasePEOStartAutoSerialNumber	Value that identifies the starting number associated with the serial numbers when they're automatically created for an item.
ItemBasePEOStartDateActive	Date when the item is active.
ItemBasePEOStdLotSize	Value that identifies the amount of a particular item that's ordered from the plant or a supplier, or issued as a standard quantity to the production process. Oracle Cost Management Cloud uses this value to calculate unit costs for subelements with a lot basis type.
ItemBasePEOStockEnabledFlag	Contains one of the following values: Y or N. If Y, then the item can be stocked in inventory. If N, then the item can't be stocked in inventory. The default value is N.
ItemBasePEOStyleItemFlag	Contains one of the following values: Y or N. If Y, then the item is a style item. If N, then the item isn't a style item. The default value is N.
ItemBasePEOStyleItemId	Value that uniquely identifies the style item.
ItemBasePEOSubcontractingComponent	Value that identifies the subcontracting type associated to this item when it's used as a subcontracting component in chargeable subcontracting. Values include Prepositioned and Synchronized. A list of accepted values is defined in the lookup type EGP_SUBCONT_COMPONENT. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. This attribute doesn't have a default value.
ItemBasePEOSubstitutionWindowCode	Value that identifies the time for which a substitute can be considered for an item.
ItemBasePEOSubstitutionWindowDays	Value that identifies the number of days a substitute is considered for an item.
ItemBasePEOTaxCode	Value that identifies the tax code to use when calculating tax based on location and tax codes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Codes task.
ItemBasePEOTaxableFlag	Contains one of the following values: Y or N. If Y, then the supplier charges a tax on the item. If N, then the supplier doesn't charge a tax on the item. The default value is N.
ItemBasePEOTrackingQuantityInd	Value that identifies the unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOTradeItemDescriptor	Value that identifies the pack type, also known as trade item unit descriptor, that describes the hierarchy level of the Global Trade Item Number. Hierarchy is used as link between different levels of a product, item, logistical chain. A list of accepted values is defined in the lookup type EGP_PACK_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Null.
ItemBasePEOUnNumberId	Value identifies the United Nations identification number used for international trade purposes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage UN Numbers task
ItemBasePEOUnderComplToleranceType	Value that identifies the undercompletion tolerance type. Values include Percentage, Quantity, or Null. A list of accepted values is defined in the lookup type ORA_EGP_UNDER_COMP_TOL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is null.
ItemBasePEOUnderComplToleranceValue	Value that identifies the acceptable percent or quantity of assemblies that's allowed to be undercompletion.
ItemBasePEOUnderReturnTolerance	Value that identifies the lower limit of the received quantity to be considered as full receipt.
ItemBasePEOUnderShipmentTolerance	Value that identifies the amount of the shipment that can be less than the shipment tolerance at the time of ship confirmation.
ItemBasePEOUnitHeight	Value that identifies the height of the item.
ItemBasePEOUnitLength	Value that identifies the length of the item.
ItemBasePEOUnitOfIssue	Value that identifies the unit of measure to use when issuing the item from inventory. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOUnitVolume	Value that identifies the volume of one item.
ItemBasePEOUnitWeight	Value that identifies the weight of one item.
ItemBasePEOUnitWidth	Value the identifies the width of the item.
ItemBasePEOVariableLeadTime	Value that identifies the time to produce one unit of an assembly.
ItemBasePEOVehicleItemFlag	Contains one of the following values: Y or N. If Y, then use vehicles to ship items. If N, then don't use vehicles. The default value is N.
ItemBasePEOVersionId	Value that uniquely identifies the item version.
ItemBasePEOVmiFixedOrderQuantity	Value that identifies the fixed quantity to reorder in the inventory that the supplier manages.
ItemBasePEOVmiForecastType	Value that uniquely identifies the type of demand for the item. A list of accepted values is defined in the lookup type EGP_ATO_FORECAST_CONTROL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOVmiMaximumDays	Value that identifies the maximum allowed days of supply for replenishment reorder.
ItemBasePEOVmiMaximumUnits	Value that identifies the maximum order quantity or repetitive rate, units per day.
ItemBasePEOVmiMinimumDays	Value that identifies the minimum allowed days of supply before replenishment must occur.
ItemBasePEOVmiMinimumUnits	Value that identifies the minimum order quantity or repetitive rate, units per day.
ItemBasePEOVolumeUomCode	Value that identifies the unit of measure to use for the item volume. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOWebStatus	Value that identifies the web status of the item. Valid values are Enabled, Published, and Unpublished. The default value is Unpublished.
ItemBasePEOWeightUomCode	Value that identifies the unit of measure to use for the item weight. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task.
ItemBasePEOWhUpdateDate	Date and time when the item revision was last updated.
ItemBasePEOWipSupplyLocatorId	Internal value that identifies the supply locator from which to issue, push, or backflush, pull, an item to work in process. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. The default value is None.
ItemBasePEOWipSupplySubinventory	Value that identifies the primary subinventory from which to issue or backflush an item to work in process. A list of accepted values is defined in the lookup type EGP_WIP_SUP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None.
ItemBasePEOWipSupplyType	Value that identifies the supply type for components. A list of accepted values is defined in the lookup type EGP_WIP_SUP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1.
ItemTranslationPEODescription	Value that identifies the description of the part, item, product, or service.
ItemTranslationPEOHtmlLongDescription	Value that identifies the formatted description in rich text or in HTML.
ItemTranslationPEOInventoryItemId	Value that uniquely identifies the Item.
ItemTranslationPEOLanguage	Value that identifies the language used for the item attribute translations.
ItemTranslationPEOLongDescription	Value that identifies the text description of the item.
ItemTranslationPEOOrganizationId	Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.