Item Version 2
An object that can be transacted, such as physical product or service offering.
QName: {http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/}Item
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ATPComponentsValue |
string |
An attribute indicating whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items. |
|
ATPValue |
string |
An attribute indicating to check available to promise and/or capable to promise information when placing demand. |
|
AcceptableEarlyDays |
decimal |
An attribute indicating the number of days before which the planning process will not reschedule orders. |
|
AccountingRuleValue |
string |
An unique value the accounting rule to identify special revenue recognition rules for an item. |
|
AllowExpressDeliveryFlag |
boolean |
A flag that indicates whether all distributions for this item can be delivered with one data entry transaction, if the quantity to be delivered equals the purchase order line balance. This is a choice list. |
|
AllowItemDescriptionUpdateFlag |
boolean |
A flag that controls the update of the Purchasing Document Description. |
|
AllowMaintenanceAssetFlag |
boolean |
Attribute indicating that maintainable assets can be defined for the item. |
|
AllowSubstituteReceiptsFlag |
boolean |
A flag indicating whether to allow receipt of defined substitutes in place of this item. |
|
AllowSuspendFlag |
boolean |
A flag indicating if a service can be suspended. |
|
AllowTerminateFlag |
boolean |
A flag indicating if a service can be terminated. |
|
AllowUnorderedReceiptsFlag |
boolean |
A flag indicating whether you can receive an item without a purchase order. |
|
ApprovalStatusValue |
string |
An attribute value that represents the status of the approval sought for item. |
|
AssembleToOrderFlag |
boolean |
A flag indicating is generally built for sales order demand; a final assembly work order is created based on sales order details. |
|
AssetActivityCauseValue |
string |
An attribute indicating what situation caused the work to be generated. |
|
AssetActivityShutdownTypeValue |
string |
An attribute indicating whether the maintenance activity needs to be shut down. |
|
AssetCategoryValue |
string |
An attribute value that is the fixed asset category identifier (foreign key FA asset category flexfield). |
|
AssetClassValue |
string |
An attribute indicating an item belongs to asset class. |
|
AssetItemTypeValue |
string |
An attribute indicating whether the Item is Asset Group, Activity, or Rebuildable Item. |
|
AssetTrackedFlag |
boolean |
A flag indicating whether item is tracked as an asset in installed base. |
|
AssetTrackedValue |
string |
This attribute indicates the type of asset tracking done on the items. |
|
AutoCreatedConfigurationFlag |
boolean |
A flag indicating whether the Item is autocreated. |
|
AutomaticallyExpireASNFlag |
boolean |
A flag indicating Advance Shipment Notice expires automatically. Its a choice list with Yes/No value. |
|
BackOrderableFlag |
boolean |
An attribute indicating whether this item can be backordered, if ATP fails. |
|
BackToBackEnabledFlag |
boolean |
A flag indicating the item is enabled for back to back ordering. |
|
BaseItemValue |
string |
An attribute indicating the Model from which an ATO configuration was created. |
|
BillingTypeValue |
string |
An attribute value 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. |
|
BuildInWIPFlag |
boolean |
A flag indicating whether to create discrete jobs or repetitive assemblies in Oracle Work in Process. |
|
BulkPickedFlag |
boolean |
A flag indicating to pick items in bulk. |
|
BuyerEmailAddress |
string |
Email Address of the buyer. |
|
BuyerOrganizationValue |
string |
An attribute value that represents the the organization that the Buyer belongs to. |
|
CASNumber |
string |
An attribute indicating the Chemical Abstracts Service (CAS) Registry Number which uniquely identifies a chemical substance. |
|
CarryPercentage |
decimal |
An attribute indicating the percentage of Unit Cost that represents the internal cost to stock one unit for one year. |
|
CategoryCode |
string |
The code that uniquely identifies the item class. This attribute is reserved for internal purposes. Do not use. |
|
ChangeNotice |
string |
An unique identifier for an change order. |
|
ChangeOrderLineSequenceNumber |
int |
The line number of an item in a change order. |
|
CheckMaterialShortageFlag |
boolean |
A flag indicating that material shortages will be checked for the item and the item has inventory attributes. |
|
ChildLotEnabledFlag |
boolean |
A flag indicating whether an item is subject to Lot control at the transactional purposes when a Parent Lot is specified for transactional purpose. |
|
ChildLotFormatValidationFlag |
boolean |
A flag indicating whether the Child Lot numbers confirms to the child lot parameters. |
|
ChildLotParent |
string |
An attribute value indicating how the system generates child lot numbers at the item level. |
|
ChildLotPrefix |
string |
An attribute indicating the starting alphabet prefix for the Child Lot. |
|
ChildLotStartingNumber |
decimal |
An attribute indicating the starting alphabet prefix for all serial numbers which are being defined for the lot. |
|
CollateralFlag |
boolean |
A flag indicating whether the item is a collateral. |
|
CommonSupplyProjectDemandFlag |
boolean |
Contains one of the following values: True or False. If True, then the material can be planned, picked, and issued from common inventory if sufficient inventory does not exist in project inventory. If False, then the material cannot be planned, picked, or issued from common inventory even if sufficient inventory does not exist in project inventory. The default value is False |
|
CommsActivationReqdFlag |
boolean |
An attribute indicating whether the item is eligible for electronic fulfillment by the service fulfillment manager. |
|
ConfigModelTypeValue |
string |
An attribute indicating the behavior of the Configurable Models in the Configurator. |
|
ConsignedFlag |
boolean |
A flag indicating the item is residing at your location, but owned by the supplier. |
|
ContainerItemFlag |
boolean |
A flag indicating whether containers are used for shipping the items. |
|
ContainerTypeValue |
string |
An attribute indicating the type of the container. |
|
ContractManufacturingFlag |
boolean |
A flag indicating the item is used in contract manufacturing. |
|
CopyAssociationsFlag |
boolean |
A flag that indicates if item associations are copied or not copied. |
|
CopyAttachmentsFlag |
boolean |
A flag that indicates if item attachments are copied or not copied. |
|
CopyCategoriesFlag |
boolean |
A flag that indicates if catalog categories are copied or not copied. |
|
CopyFromItemValue |
string |
An attribute value that represents the item which be used as the source when copied. |
|
CopyFromRevisionValue |
string |
An attribute that represents the revision of the item used as the source of the copy. |
|
CopyFromVersionValue |
string |
An attribute that represents the version of the revision of the item used as the source of the copy. |
|
CopyItemAndApplyTemplatesFlag |
boolean |
An flag that indicates the item will copied first and then the item templates will be applied to the item. |
|
CopyLotAttributeFlag |
boolean |
An attribute indicating whether the Child Lot inherits all the attribute of the parent Lot. |
|
CopyOrganizationAssignmentsFlag |
boolean |
A flag that indicates an attribute value if organization assignments for the item are copied. |
|
CostingEnabledFlag |
boolean |
A flag indicating whether to report, value and account for any item costs. |
|
CreateConfiguredItem |
string |
An attribute indicating whether the Configured Bill of materials can be created based on Item Sourcing. |
|
CreateFixedAssetFlag |
boolean |
A flag indicating whether the Item creates a depreciable inventory asset used in install base. |
|
CreateFixedAssetValue |
string |
Attribute indicating when the item is asset capitalized. |
|
CreateSupplyAfterDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date after which the supply for the item has to be considered while generating planned orders. |
|
CreateSupplyFlag |
boolean |
A flag indicating if the system can suggest supply for this item. |
|
CreatedBy |
string |
Who column: An attribute which indicates the user that created the item. |
|
CreatedFromItemId |
long |
The Value that identifies the item id from which copy has been made. |
|
CreatedFromItemNumber |
string |
The Value that identifies the item number from which copy has been made. |
|
CreatedFromItemRevision |
string |
The Value that identifies the revision of the item from which copy has been made. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: An attribute that indicates the date and time of the creation of the item. |
|
CreationDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: An attribute that indicates the date and time of the creation of the item. |
|
CriticalComponentFlag |
boolean |
A flag indicating the item as a critical component for MPS and DRP planning. |
|
CssEnabledFlag |
boolean |
Attribute indicating that item is enabled for use on Customer Self Service Application. |
|
CumulativeManufacturingLeadTime |
decimal |
An 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. |
|
CumulativeTotalLeadTime |
decimal |
An 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. |
|
CustomerOrderEnabledFlag |
boolean |
A flag that indicates the inventory item is cycle count enabled. |
|
CustomerOrderFlag |
boolean |
A flag attribute Indicating whether to allow an item to be ordered by external customers. |
|
CycleCountEnabledFlag |
boolean |
A flag that indicates the inventory item is cycle count enabled. |
|
DRPPlannedFlag |
boolean |
A flag indicating the kind of planning to be used for the 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. |
|
DaysEarlyReceiptAllowed |
decimal |
An attribute indicating the number of days before the promise date you can receive an item without warning or rejection. |
|
DaysLateReceiptAllowed |
decimal |
An attribute indicating the number of days after the promise date you can receive an item without warning or rejection. |
|
DaysMaximumInventorySupply |
decimal |
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, or Days of Supply. |
|
DaysOfCover |
decimal |
An attribute representing the number of days of cover for an item. |
|
DefaultBuyerValue |
string |
An attribute that represents the name of a default buyer of an item. |
|
DefaultGradeValue |
string |
An attribute indicating default grade for the item. |
|
DefaultLotStatusValue |
string |
An attribute indicating the Default Lot Status for the Item. |
|
DefaultRepairTransactionName |
string |
Attribute that indicates the name of the system, component and position where an asset item will be used to maintain another asset. |
|
DefaultSalesOrderSourceTypeValue |
string |
An attribute indicating whether the maintenance activity needs to be shut down. |
|
DefaultSerialStatusValue |
string |
An attribute indicating the Default Serial Status of the Item. |
|
DefaultShippingOrganizationValue |
string |
An 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. |
|
DefaultingControlValue |
string |
Defaulting Control of the item attributes. Values include Fixed, Default and No Default. |
|
DefectTrackingOnFlag |
boolean |
A flag indicating if defects of this item can be tracked. |
|
DemandPeriod |
decimal |
An attribute representing the demand period for an item. |
|
DemandTimeDays |
decimal |
An 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. |
|
DemandTimeFence |
string |
An attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. |
|
DimensionUOMValue |
string |
An attribute indicating unit of measure for the dimension of the item. |
|
DownloadableFlag |
boolean |
A flag indicating whether the item can be downloadable. |
|
EAMActivityNotificationFlag |
boolean |
A flag indicating if the asset is movable, and needs to be brought into the shop for repairs. |
|
EAMActivitySourceValue |
string |
An attribute indicating the reason the activity needs to be executed. This is relevant when asset item type is set to asset activity. |
|
EAMActivityTypeValue |
string |
An attribute indicating the type of maintenance for the Asset activity. |
|
EffectivityControlValue |
string |
An attribute which value indicates the way effectively is controlled within a structure. The values include Date, Unit Number, or Serial Number. |
|
ElectronicFormatFlag |
boolean |
A flag indicating whether the item exists only Electronic format and not physical. |
|
EligibilityRuleFlag |
boolean |
A flag that indicates 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. |
|
EnableGenealogyTrackingFlag |
boolean |
Attribute indicating that item is enabled for genealogy tracking. |
|
EnableIotFlag |
boolean |
Contains one of the following values: True or False. If True, then the asset can be enabled for Internet of Things (IoT). If False, then the asset cannot be enabled for IoT. The default value is False. |
|
EnforceShipToLocation |
string |
An 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. |
|
EngineeredItemFlag |
boolean |
Attribute indicating that the item is engineered by the customer in house. |
|
EventFlag |
boolean |
A flag indicating whether the item is event. |
|
ExcludeFromBudgetFlag |
boolean |
A flag indicating whether the item is excluded from the budget. |
|
ExpenditureTypeValue |
string |
Value for 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. |
|
ExpenseAccountValue |
string |
An attribute value that represents the expense account to be used when tracking a non-asset item. |
|
ExpirationActionInterval |
decimal |
An attribute indicating the number of days the system adds to the expiration date before it performs an action on the lot. |
|
ExpirationActionValue |
string |
An attribute indicating the default action code for this item when the lot expire or the lot fails for quality. |
|
FinancingAllowedFlag |
boolean |
A flag indicating whether to allow customers to return an item. |
|
FixedDaysSupply |
decimal |
An attribute indicating the number of days used to modify the size and timing of planned order quantities. |
|
FixedLeadTime |
decimal |
An attribute indicating the days required to make an assembly independent of order quantity, such as setup or teardown time |
|
FixedLotSizeMultiplier |
decimal |
An attribute indicating the fixed lot multiple quantity or repetitive rate (units per day). |
|
FixedOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating the quantity used to modify the size of planned order quantities or repetitive daily rates. |
|
ForcePurchaseLeadTimeFlag |
boolean |
Attribute indicating whether an item's purchasing lead time is enforced as a hard constraint or not in the planning. |
|
ForecastControlValue |
string |
An attribute indicating the type of demand the item undergoes and can be one of these; Consume, Consume and Derive, or None. |
|
ForecastHorizon |
decimal |
Period for which a forecast is considered by the Planning Engine. |
|
ForecastTypelValue |
string |
An attribute indicating the type of demand the item undergoes and can be one of these; Consume, Consume and Derive, or None. |
|
FormattedDescription |
string |
An attribute that represents a statement describing an item, formatted using hyper text tags. |
|
GradeControlFlag |
boolean |
A flag indicating whether the item is grade controlled in addition to lot controlled. |
|
HardPeggingLevelValue |
string |
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. |
|
HazardClassValue |
string |
An attribute indicating the category of Hazard material for International trade. |
|
HazardousMaterialFlag |
boolean |
A flag indicating if the item is hazardous. |
|
HoldDays |
decimal |
An attribute indicating the number of days added to the lot creation date before you can release the lot. |
|
IgnoreDuplicateItemFlag |
boolean |
A flag that indicates to create items, even though the matching items exists |
|
IncludeInRollUpFlag |
boolean |
An flag indicating whether to include an item in the cost rollup. |
|
InstanceClassValue |
string |
An attribute indicating that the item is used in Telecommunication Service Ordering for defining a configured link. |
|
InternalOrderEnabledFlag |
boolean |
A flag indicating whether to allow an item to be ordered on an internal requisition. |
|
InternalOrderFlag |
boolean |
A flag indicating whether an Item can be ordered internally. |
|
InternalVolume |
decimal |
An attribute indicating the internal volume of the Container or vehicle. |
|
InventoryAssetFlag |
boolean |
A flag indicating whether to value an item as an asset in inventory. |
|
InventoryCarryPenalty |
decimal |
An attribute indicating the penalty for jobs that are not completed before they are scheduled to be finished. |
|
InventoryItemFlag |
boolean |
A flag which indicates the item is used in inventory. |
|
InventoryItemStatusCode |
string |
The code that uniquely identifies the item status. This attribute is reserved for internal purposes. Do not use. |
|
InventoryPlanningMethodValue |
string |
An attribute indicating the planning method to be used for the organization. |
|
InvoiceCloseTolerancePercentage |
decimal |
Percentage tolerance used to automatically close Purchase Order Shipments for invoicing. |
|
InvoiceEnabledFlag |
boolean |
A flag indicating whether to include an item on an Oracle Receivables invoice. |
|
InvoiceMatchOptionValue |
string |
Value that indicates the type of match used for 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. |
|
InvoicedFlag |
boolean |
A flag indicating whether to include an item on an Oracle Receivables invoice. |
|
InvoicingRuleValue |
string |
An attribute indicating invoicing rule to determine the period in which an invoice is sent. |
|
ItemAttachment |
A view object for attachments associated with an item. |
|
|
ItemCategory |
ItemService.ItemCategory |
|
|
ItemClass |
string |
An attribute that value provides metadata common to all items that share the category. |
|
ItemDFF |
Item Descriptive Flex Field |
|
|
ItemDefinitionOrgId |
long |
Indicates which organization serves as the definition for all items in this organization. If self-referential, it is a definition organization. If it points to any other organization, it is a reference organization.
|
|
ItemDescription |
string |
An attribute value that is the description for the item. |
|
ItemEffCategory |
ItemService.ItemEFFCategory |
|
|
ItemExtensibleFlexfieldCategoryCode |
string |
An attribute value for the EFF category code for the Item. |
|
ItemGlobalDFF |
A view object for the global descriptive flexfield extensions for item. |
|
|
ItemId |
long |
An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
|
|
ItemNumber |
string |
An attribute that is an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes. |
|
ItemObjectTypeValue |
string |
Attribute indicating whether the entity is an item or a document object. |
|
ItemRevision |
ItemService.ItemRevision |
|
|
ItemStatusValue |
string |
An attribute that defines codes used to control the transaction activity of an item. For example, an item in active status can be customer order enabled. |
|
ItemSupplierAssociation |
ItemService.ItemSupplierAssociation |
|
|
ItemTranslation |
An attribute value which is used to acccess the translated information for the item. |
|
|
ItemType |
string |
The code that uniquely identifies the item type. This attribute is reserved for internal purposes. Do not use. |
|
Keyword |
string |
An attribute that repesents a string of characters used for searching using keywords. |
|
LastSubmittedNewItemRequest |
string |
An attribute value that represents the last new item request number submitted to be processed. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: An attribute which indicates the date and time of the last update of the item. |
|
LastUpdateDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Who column: An attribute which indicates the date and time of the last update of the item. |
|
LastUpdateLogin |
string |
Who column: An attribute which indicates the user that logged in last for the item. |
|
LastUpdatedBy |
string |
Who column: An attribute which indicates the user that last updated the item. |
|
LeadTimeLotSize |
decimal |
An attribute indicating quantity used to compute processing lead time. |
|
LifecyclePhaseValue |
string |
The attribute value that represents the lifecycle phase for an item. |
|
ListPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Attribute indicating default Price to be used in RFQ, Purchase Order or Quotation. |
|
LongDescription |
string |
An attribute that represents a statement, picture in words, or account that describes; descriptive representation. |
|
LotControlValue |
string |
An attribute indicating the ability to use lot numbers during material transactions for tracking of batches of Item. |
|
LotDivisibleFlag |
boolean |
A flag indicating whether the Lot can be allowed to allocate, reserve, or move partial lot quantities. |
|
LotExpirationControlValue |
string |
An attribute value representing how shelf life is controlled and lot expiration control for inventory items. |
|
LotMergeEnabledFlag |
boolean |
A flag indicating whether many lots of a lot controlled item may merge into one lot. |
|
LotSplitEnabledFlag |
boolean |
A flag indicating whether a lot-controlled item may split into many lots. |
|
LotStatusEnabledFlag |
boolean |
A flag indicating whether an item is subject to status control at the Lot Level. |
|
LotSubstitutionEnabledFlag |
boolean |
A flag indicating whether lots can be substituted in a transaction. |
|
LotTranslateEnabledFlag |
boolean |
A flag indicating whether Lots can be translated. |
|
MRPCalculateATPFlag |
boolean |
A flag indicating whether to calculate and print available to promise (ATP) on the Planning Detail Report. |
|
MarketPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Attribute indicating market Price of the item which is printed on the Purchase Order lines. |
|
MatchApprovalLevelValue |
string |
An attribute that represents the status of the Match Approvals. The values can be either PO or Receipt. |
|
MatchConfigurationOptionValue |
string |
An attribute indicating the capability to match to one of existing configurations of the models -Standard, Container, Null. |
|
MaterialTransactionEnabledFlag |
boolean |
A flag indicating the item is transaction enabled and has inventory attributes. |
|
MaturityDays |
decimal |
An attribute indicating the number of days added to the lot creation date to determine the lot maturity date. |
|
MaximumDaysOfSupply |
decimal |
An attribute indicating the maximum allowed days of supply for replenishment reorder. |
|
MaximumInventoryWindow |
decimal |
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 |
|
MaximumLoadWeight |
decimal |
An attribute indicating Maximum load weight of the container or vehicle. |
|
MaximumMinmaxQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating the maximum quantity for Min-Max Planning. |
|
MaximumOrder |
decimal |
An attribute indicating maximum order quantity of the Item. |
|
MaximumOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating maximum order quantity or repetitive rate (units per day). |
|
MinimumFillPercent |
decimal |
An attribute indicating minimum fill of the container or vehicle to be used. |
|
MinimumLicenseQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating the minimum number of licenses a customer must order for products ordered on Oracle iStore and distributed based on licensing. |
|
MinimumMinmaxQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating the minimum quantity for Min-Max Planning. |
|
MinimumOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating minimum order quantity of the Item. |
|
NegativeDeviationFactor |
decimal |
Deviation allowed on the lower side for a transaction on the secondary quantity derived from the default conversion factor. |
|
NegativeMeasurementError |
decimal |
The negative limit for the user defined limit for the difference between cycle count quantities and the system tracked on-hand quantities. |
|
NegotiationRequiredFlag |
boolean |
A flag indicating whether Negotiation is required or not. |
|
OperationSlackPenalty |
decimal |
An attribute indicating, in units per day, the operation slack penalty for items having lag time between operations. |
|
OrderCost |
decimal |
An attribute indicating the fixed cost associated with placing an order for the item. |
|
OrderManagementIndivisibleFlag |
boolean |
A flag indicating whether the item can be ordered in fractions. |
|
OrderableOnWebFlag |
boolean |
An attribute indicating whether this item is orderable on from the web. |
|
OrganizationCode |
string |
A name of an 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. |
|
OrganizationId |
long |
An unique identifer for the organization for th eitem for production items. In case of pending or update operations such update of version item, this attribute value will be the VersionId.
|
|
OutputTaxClassificationCodeValue |
string |
An attribute indicating a tax code to use when calculating tax based on location and tax codes. |
|
OutsideProcessServiceFlag |
boolean |
This attribute indicates whether the item can be added to a outside processing purchase order |
|
OutsideProcessingFlag |
boolean |
A flag indicating whether the item can be added to Outside Processing Purchase Order. |
|
OutsideProcessingUnitTypeValue |
string |
A attribute value indicating the type of unit of measure which is used in processing. |
|
OutsourcedAssemblyFlag |
boolean |
A flag indicating the item is an outsourced assembly. |
|
OverReturnTolerance |
decimal |
An attribute indicating the amount of the shipment you can exceed at the time of receiving or receipt creation. |
|
OverShipmentTolerance |
decimal |
An attribute indicating the amount of the shipment you can ship below at the time of ship confirmation. |
|
OvercompletionToleranceTypeValue |
string |
An attribute indicating the over-completion tolerance type. Choices - Percent or Amount. |
|
OvercompletionToleranceValue |
decimal |
An attribute indicating the acceptable percent or quantity of assemblies that you will allow to be over-completed. |
|
PackTypeValue |
string |
Trade Item Descriptor also known as Trade Item Unit Descriptor (TIUD)/Pack Type is used to describe the Global Trade Item Number (GTIN) hierarchy level. Hierarchy is used as link between different levels of a product (Item) logistical chain. |
|
PackagingStringValue |
string |
An attribute providing the packaging string for an item, which represents how the packaging of a particular item is assembled from the base unit, such as Boxes per Case. |
|
PaymentTermsValue |
string |
An attribute indicating a valid payment terms code. |
|
Pegging |
string |
An attribute indicating the planning process use end assembly pegging to decide when to calculate and print end assemblies for the item. |
|
PickComponentsFlag |
boolean |
A flag indicating whether an item has a bill of material with options, classes, or included items picked from finished goods inventory. |
|
PickingRuleValue |
string |
An attribute indicating picking rule that defines the order in which subinventories, locators, lots, and revisions are picked. |
|
PlannedInventoryPointFlag |
boolean |
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. |
|
Planner |
string |
An attribute indicating the material planner for the item. |
|
PlanningMakeBuyValue |
string |
An attribute indicating whether the item is usually manufactured or bought. |
|
PlanningMethodValue |
string |
An attribute indicating the organization level planning for the Item. Choices -Min-Max, Not Planned, Reorder Point. |
|
PlanningTimeDays |
decimal |
Attribute indicating the optional day added to the planning time fence when plannig time fence is User defined. |
|
PlanningTimeFence |
string |
Attribute indicating options to determine a point in time inside which certain restrictions on planning recommendations apply. |
|
PositiveDeviationFactor |
decimal |
Deviation allowed on the higher side for a transaction on the secondary quantity derived from the default conversion factor. |
|
PositiveMeasurementError |
decimal |
The positive limit for the user defined limit for the difference between cycle count quantities and the system tracked on-hand quantities. |
|
PostprocessingDays |
decimal |
An attribute indicating the days required to receive a purchased item into inventory from the initial supplier receipt. |
|
PrepositionPointFlag |
boolean |
A flag indicating the push type relationship with a trading partner. |
|
PreprocessingDays |
decimal |
An attribute indicating the days which must be added to purchasing or manufacturing lead time to place an order. |
|
PriceTolerancePercentage |
decimal |
An 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. |
|
PrimaryUOMValue |
string |
An attribute the value is the unit which is primarily used to measure quantities of the item. |
|
ProcessCostingEnabledFlag |
boolean |
A flag indicating whether to use the process costing module with this item. |
|
ProcessExecutionEnabledFlag |
boolean |
A flag indicating whether to use this item in a production batch as an ingredient, product, or by-product. |
|
ProcessQualityEnabledFlag |
boolean |
A flag indicating whether to use the process manufacturing quality module with this item. |
|
ProcessSupplyLocatorValue |
string |
An attribute indicating the location from which the item is normally consumed as an ingredient in process manufacturing. |
|
ProcessSupplySubinventoryValue |
string |
An attribute indicating a subinventory from which the item is normally consumed as an ingredient in process manufacturing. |
|
ProcessYieldLocatorValue |
string |
An attribute indicating locator in which you place the results of a production batch. |
|
ProcessYieldSubinventoryValue |
string |
An attribute indicating a subinventory in which you place results of a production batch. |
|
ProcessingDays |
decimal |
An attribute indicating the days required to procure or manufacture an item. |
|
ProcurementBusinessUnitName |
string |
Procurement Business unit. |
|
PurchasableFlag |
boolean |
A flag which determines whether the item can be added in to a purchase order. |
|
PurchasingFlag |
boolean |
A flag which determines whether the Item is purchased and received. |
|
PurchasingInputTaxClassificationValue |
string |
An attribute to determine the appropriate tax classification code for the Item. |
|
QuantityReceivedToleranceAction |
string |
An attribute indicating action to be performed when the receive date is outside the range defined by Quantity Received Tolerance. |
|
QuantityReceivedTolerancePercentage |
decimal |
An attribute indicating the quantity received tolerance percent, the maximum acceptable over-receipt percentage. |
|
RMAInspectionRequiredFlag |
boolean |
A flag indicating whether inspection is required for items returned by the customer. The item then must be separately transferred to inventory. |
|
ReceiptCloseTolerancePercentage |
decimal |
An attribute indicating percentage tolerance used to automatically close Purchase Order Shipments for receipt. |
|
ReceiptDateActionValue |
string |
An 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. |
|
ReceiptRountingValue |
string |
An attribute indicating routing of the Items at the time of receipt. |
|
RecipeEnabledFlag |
boolean |
A flag indicating whether this item used in recipes or formulas in process manufacturing. |
|
RecoveredPartDispositionValue |
string |
An attribute indicating this field will control the process for returning defective or unused parts to a warehouse consolidation point. |
|
ReleaseAuthorizationRequiredValue |
string |
Attribute indicating authorization is required before a sales order is created. |
|
ReleaseTimeDays |
decimal |
An attribute value that represents the release time Days, lead times attribute. |
|
ReleaseTimeFence |
string |
An 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. . Display attribute for ObjectVersionNumber. |
|
RepairLeadtime |
decimal |
An attribute indicating time to repair the part at the supplier site. |
|
RepairProgramValue |
string |
An attribute indicating the relationship with the vendor for the repair of an item. |
|
RepairYield |
decimal |
An attribute indicating the yield when you upgrade or repair a defective part. |
|
ReplacementTypeValue |
string |
Attribute indicating whether item is field or customer replaceable. |
|
ReplenishmentMaximumOrder |
decimal |
Maximum quantity for the sales order or repetitive rate in the number of units for each day. |
|
ReplenishmentMinimumDays |
decimal |
An attribute indicating the minimum allowed days of supply before replenishment must occur. |
|
ReplenishmentMinimumOrder |
decimal |
An attribute indicating the minimum order quantity or repetitive rate (units per day). |
|
ReplenishmentType |
string |
Attribute indicating the way in which requests are fulfilled. The value are Inventory, Supplier, or Subinventory. |
|
RequestId |
long |
An unique identifier for the item import scheduled process request which created or updated the item. |
|
RequiresFulfillmentLocFlag |
boolean |
A flag indicating that a fulfillment location needs to be captured when ordering the service item. |
|
RequiresItemAssociationFlag |
boolean |
A flag indicating that an item association is required for the item. |
|
ReservableFlag |
boolean |
A flag indicating the item is reservable and has inventory attributes. |
|
RestrictLocatorsFlag |
boolean |
An attribute indicating whether to restrict transaction of this item to or from a locator specified. |
|
RestrictSubinventoriesFlag |
boolean |
A flag indicating whether to restrict transactions of this item to or from a subinventory specified. |
|
RetestInterval |
decimal |
An attribute indicating the number of days after the creation date before the lot needs to be retested. |
|
ReturnableFlag |
boolean |
A flag indicating whether to allow customers to return an item. |
|
RevisionForVersion |
string |
Read Only: An attribute that represent an incremenatal change to the item. All items have at least one revision. |
|
RevisionQuantityControlFlag |
boolean |
A attribute value that indicates the item is under revision control and has inventory attributes. |
|
RoundingControlTypeFlag |
boolean |
A flag 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. |
|
RoundingFactor |
decimal |
An 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. |
|
SafetyStockPlanningMethodValue |
string |
An attribute value that represents the type of safety planning method that will be used in planning for the item. |
|
SalesAccountValue |
string |
Account used when tracking a sales item. |
|
SalesProductTypeValue |
string |
Attribute indicating classification of an item or product for sales processes |
|
SecondaryUnitofMeasureValue |
string |
An attribute indicating the Secondary Unit of Measure through which the Item can be transacted. |
|
SerialGenerationValue |
string |
An attribute indicating number assigned to each unit of an item and used to track the item. |
|
SerialStartingNumber |
string |
An attribute value representing the starting serial number for inventory items. |
|
SerialStartingPrefix |
string |
An attribute indicating starting alpha prefix for all serial numbers you define. |
|
SerialStatusEnabledFlag |
boolean |
An attribute indicating whether an item is subject to status control at the Serial Level. |
|
ServiceBillingEnabledFlag |
boolean |
A flag indicating that service billing is enabled. |
|
ServiceDuration |
decimal |
An attribute indicating positive number to indicate the service duration. |
|
ServiceDurationPeriodValue |
string |
An attribute indicating positive number to indicate the service duration period. |
|
ServiceDurationTypeValue |
string |
An attribute indicating type of duration applicable for a service item |
|
ServiceRequestEnabledValue |
string |
An attribute indicating type of duration applicable for a service item |
|
ServiceStartDelay |
decimal |
An attribute specifying the delay in starting a service after a milestone. |
|
ServiceStartTypeValue |
string |
An attribute indicating the type of service start rule which should be used for a service item. |
|
ServiceableProductFlag |
boolean |
A flag indicating whether the item is eligible to be covered by a service contract. |
|
ShelfLifeDays |
decimal |
An attribute value indicating number of days each lot is active. |
|
ShipModelCompleteFlag |
boolean |
A flag 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. |
|
ShippableFlag |
boolean |
A flag indicating whether to ship an item to a customer. |
|
ShrinkageRate |
decimal |
An attribute indicating the factor that represents the average amount of material you expect to lose during manufacturing or in storage. |
|
SourceOrganizationValue |
string |
An attribute indicating the organization from which an internal requisition draws the item. |
|
SourceSubinventoryOrganizationValue |
string |
An attribute value that represents the the organization that the SourceSubinventory belongs to. |
|
SourceSubinventoryValue |
string |
An attribute indicating the sub inventory from which an internal requisition draws the item. |
|
StandardCoverage |
string |
Coverage template associated with the item. |
|
StandardLotSize |
decimal |
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. |
|
StartingLotNumber |
string |
An attribute value representing the starting lot number for items. |
|
StartingLotPrefix |
string |
An attribute indicating starting alpha prefix for all serial numbers you define. |
|
StockEnabledFlag |
boolean |
A flag that indicates the item is stocked. |
|
StockLocatorControlValue |
string |
An attribute indicating the physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf. |
|
StructureItemTypeValue |
string |
An attribute indicating the type of structure the item can have. Structure Item Type include Model, Option Class, Standard and Planning. |
|
StyleItemFlag |
boolean |
A flag which indicates the item is style item. |
|
StyleItemNumberValue |
string |
An attribute value of the number of the style item. |
|
SubcontractingComponentValue |
string |
An attribute indicating the subcontracting type associated to this item when it is used as a subcontracting component in Chargeable Subcontracting. Choices - Prepositioned, Synchronised. |
|
SubstitutionDays |
decimal |
An attribute value that represents the substitution days, MPS and MRP Planning attribute. |
|
SubstitutionWindow |
string |
An attribute for MPS and MRP Planning indicating the time for which a substitute can be considered for an item. |
|
TagetInventoryWindow |
decimal |
The target Inventory (in terms of quantity) to be achieved by the Planning Engine. |
|
TargetInventoryDaysofSupply |
decimal |
The target Inventory (in terms of days of supply) to be achieved by the Planning Engine. |
|
TaxableFlag |
boolean |
A flag indicating whether the supplier charges a Tax for the item. |
|
Template |
string |
An attribute value which is the name of the template to applied to the item. |
|
TrackInstalledBaseFlag |
boolean |
A flag indicating life cycle tracking in Install Base and enterprise Install Base applications. |
|
TrackingUnitofMeasure |
string |
An attribute indicating the Unit of Measure in which the Item is tracked in inventory. |
|
TransactionConversionValue |
string |
An attribute indicating Conversion of transactions. Choices -Standard or Item Specific Conversion. |
|
TransactionEnabledFlag |
boolean |
A flag that is a reference to the source transaction definition that identifies the type of transactions within each application where a budgetary control transaction is originated. |
|
UNNumberValue |
string |
United Nations Identification Number used for International Trade purposes. |
|
UOMPricingValue |
string |
An attribute indicating the Unit of Measure in which the Item is priced for selling of the products and services. |
|
UnderCompletionToleranceTypeValue |
string |
Value that identifies the undercompletion tolerance type. The valid values include percentage or quantity. The default value is null. |
|
UnderCompletionToleranceValue |
decimal |
Attribute indicating the acceptable percent or quantity of assemblies that's allowed to be undercompletion. |
|
UnderReturnTolerance |
decimal |
An attribute indicating the lower limit of the received quantity to be considered as full receipt. |
|
UnderShipmentTolerance |
decimal |
An attribute indicating the amount of the shipment which can be shipped below at the time of ship confirmation. |
|
UnitHeightQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute Indicating height of Item. |
|
UnitLengthQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute Indicating length of Item. |
|
UnitOfIssueValue |
string |
An attribute indicating Unit of measure used for issuing the item from inventory. |
|
UnitVolumeQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute Indicating Volume of One Unit of Item. |
|
UnitWeightQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute Indicating Weight of One Unit of Item. |
|
UnitWidthQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute Indicating width of Item. |
|
UseApprovedSupplierFlag |
boolean |
v |
|
UserItemTypeValue |
string |
An attribute that indicates a grouping of all items of a particular category that share the same set of item attributes, used as a high-level grouping for processes. For example, each account generator item type (such as FA account generator) contains a group of processes for determining how an accounting flexfield code combination is created. |
|
VMIFixedOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating fixed quantity for reorder ( Vendor Managed Inventory). |
|
VariableLeadTime |
decimal |
An attribute indicating time to produce one additional unit of an assembly. |
|
VehicleItemFlag |
boolean |
A flag indicating whether vehicles are used for Shipping the items. |
|
Version |
string |
Read Only: An attribute value that represents an incremental change of an item revision. |
|
VersionDescription |
string |
Read Only: An attribute value that represents the description of an version of an item revision. |
|
VersionId |
long |
An unique value that represents the version of a revision of Item. |
|
VersionPlannedEffectiveDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time on which the item revision is scheduled to be effective. |
|
VersionStatus |
string |
Read Only: An attribute value that represents the status of a version for an item revision. This attribute value is controlled by lookup type EGO_VERSION_STATUSES. |
|
VolumeUOMValue |
string |
An attribute indicating Volume Unit of Measure. |
|
WIPSupplyLocatorValue |
string |
An attribute indicating the supply locator from which to issue (push) or back flush (pull) an item to work in process. |
|
WIPSupplySubinventoryValue |
string |
An attribute indicating a supply subinventory for components. |
|
WIPSupplyTypeValue |
string |
An attribute indicating a supply type for components. |
|
WarehouseEquipmentFlag |
boolean |
An attribute indicating whether the item is equipment. |
|
WebStatusValue |
string |
An attribute indicating Indicate the web status of this item.(enabled, Published, Unpublished). |
|
WeightUOMValue |
string |
An attribute indicating Weight Unit of Measure. |