Item Interface
An open interface table for an object that can be transacted, such as a physical product or service offering.
QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/itemInterfaceService/}ItemInterface
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 |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
ATPComponents |
string |
An attribute indicating whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items. |
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 |
Flag indicating substitute receipts allowed |
AllowSuspendFlag |
boolean |
A flag indicating if a service can be suspended. An attribute 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. |
AssembleToOrderFlag |
boolean |
A flag indicating is generally built for sales order demand; a final assembly work order is created based on sales order details. |
AssetActivityCause |
string |
An attribute indicating what situation caused the work to be generated. |
AssetActivityNotificationFlag |
boolean |
A flag indicating if the asset is movable, and needs to be brought into the shop for repairs. |
AssetActivityShutdownType |
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). |
AssetClass |
string |
An attribute indicating an item belongs to asset class. |
AssetItemType |
decimal |
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. |
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. |
BatchId |
long |
An unique indentifier for a batch in which this interface record is processed. |
BatchName |
string |
An attribute value that represents the name of the batch. |
BillingType |
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. |
BundleId |
long |
An unique identifier that groups items, packs and structures together in a single transaction. For example, bundle ID 1234 contains items ID123, ID234 and ID567. |
BuyerEmailAddress |
string |
Email Address of the buyer. |
CASNumber |
string |
An attribute indicating the Chemical Abstracts Service (CAS) Registry Number which uniquely identifies a chemical substance. |
CSSEnabledFlag |
boolean |
Attribute indicating that item is enabled for use on Customer Self Service Application. |
CarryPercentage |
decimal |
An attribute indicating the percentage of Unit Cost that represents the internal cost to stock one unit for one year. |
ChargePeriodicityValue |
string |
An attribute value representing the time the system uses to price a persistent or recurring service or product. |
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 atribute 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. |
ConfigModelType |
string |
A unique value indicating the behaviour 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 |
Flag indicating whether item is a container. Used for shipping sales orders |
ContainerType |
string |
An attribute indicating the type of the container. |
ContractManufacturingFlag |
boolean |
A flag indicating the item is used in contract manufacturing. |
CopyFromItemValue |
string |
An attribute value that represents the item which be used as the source when copied. |
CopyLotAttributeFlag |
boolean |
An attribute indicating whether the Child Lot inherits all the attribute of the parent Lot. If it is set to yes, a new child lot will inherit all attributes from the parent lot. If set to no, the lot attributes for a new child lot will not inherit the par |
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. |
CreateFixedAsset |
string |
Attribute indicating when the item is asset capitalized. |
CreateFixedAssetFlag |
boolean |
A flag indicating whether the Item creates a depreciable inventory asset used in install base. |
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. |
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 trading partner item. |
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 indicating whether an item is currently customer orderable. |
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. |
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. |
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. |
DefaultExpenditureType |
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. |
DefaultGrade |
string |
An unique indicating default grade for the newly created lot. |
DefaultLotStatus |
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. |
DefaultSalesOrderSourceType |
string |
An attribute indicating whether the maintenance activity needs to be shut down. |
DefaultSerialStatus |
string |
An attribute indicating the Default Serial Status of the Item. |
DefaultShippingOrganization |
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. |
DefaultingControl |
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 |
decimal |
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. |
EamActivitySource |
string |
An attribute indicating the reason the activity needs to be executed. This is relevant when asset item type is set to asset activity. |
EamActivityType |
string |
An attribute indicating the type of maintenance for the Asset activity. |
EffectivityControl |
decimal |
An unique identifier that controls the way to effectivity is controlled within a item. The values include Date Effectivity, Model/Unit Number Effectivity. |
ElectronicFormatFlag |
boolean |
A flag indicating whether the item exists only Electronic format and not physical. |
EligibilityRuleFlag |
boolean |
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 |
Identifies item as an event |
ExpirationAction |
string |
An attribute indicating the default action code for this item when the lot expire or the lot fails for quality. |
ExpirationActionInterval |
decimal |
An attribute indicating the number of days the system adds to the expiration date before it performs an action on the lot. |
FinancingAllowedFlag |
boolean |
Item is eligible for financing |
FixedDaysSupply |
decimal |
Fixed days supply |
FixedLeadTime |
decimal |
Fixed portion of the assembly's lead time |
FixedLotSizeMultiplier |
decimal |
Fixed lot size multiplier |
FixedOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Fixed order quantity |
ForcePurchaseLeadTimeFlag |
boolean |
Attribute indicating whether an item's purchasing lead time is enforced as a hard constraint or not in the planning. |
ForecastControl |
decimal |
An attribute indicating the type of demand the item undergoes and can be one of these; Consume, Consume and Derive, or None. |
ForecastHorizon |
decimal |
Forecast horizon for average daily demand calculation |
ForecastType |
decimal |
An attribute indicating the forecast type. The valued include: 1 (Order), 2 (Sales), or 3 (Historical Forecast). |
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. |
HardPeggingLevel |
string |
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. |
HazardClass |
string |
An attribute indicating the category of Hazard material for International trade. |
HazardousMaterialFlag |
boolean |
An attribute 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. |
IncludeInRollupFlag |
boolean |
An flag indicating whether to include an item in the cost rollup. |
InstanceClass |
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 |
Attribute indicating whether an Item can be ordered internally. |
InternalVolume |
decimal |
An attribute indicating the internal volume of the Container or vehicle which is used by Shipping to calculate container capacity restrictions. |
InventoryAssetFlag |
boolean |
A flag that indicate 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. |
InventoryPlanningMethod |
decimal |
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. |
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. |
ItemClass |
string |
An attribute that value provides metadata common to all items that share the category. |
ItemDescription |
string |
An attribute that value provides metadata common to all items that share the category. |
ItemInterfaceDFF |
Item Descriptive Flexfield |
|
ItemInterfaceGlobalDFF |
Item Global Descriptive Flexfield |
|
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. |
ItemRevisionForVersion |
string |
Read Only: An attribute that represent an incremenatal change to the item. All items have at least one revision. |
ItemStatus |
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. |
ItemTransactionId |
long |
Unique identifier of interface record.
|
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 trading partner item. |
LeadTimeLotSize |
decimal |
An attribute indicating quantity used to compute processing lead time. |
LifecyclePhase |
string |
The attribute value that represents the lifecycle phase for an item. |
LongDescription |
string |
Item Long Description |
LotControl |
decimal |
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. |
LotExpirationControl |
decimal |
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 |
An attribute value 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. |
MatchConfigurationOption |
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. |
MaximumLoadWeight |
decimal |
Maximum load weight of a container or a vehicle that can be used for shipping sales orders |
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 of the Item. |
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 the minimum number of licenses a customer must order for products ordered on Oracle iStore and distributed based on licensing. |
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 |
Attribute indicating whether Negotiation is required or not. |
NewItemClassName |
string |
An attribute that value represents the item class that will be used to change the existing item class for a set of items. |
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. |
OutputTaxClassificationCode |
string |
An attribute indicating a tax code to use when calculating tax based on location and tax codes. |
OutsideProcessingFlag |
boolean |
A flag indicating whether the item can be added to Outside Processing Purchase Order. |
OutsideProcessingUnitType |
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. |
OvercompletionTolerance |
decimal |
An attribute indicating the acceptable percent or quantity of assemblies that you will allow to be over-completed. |
OvercompletionToleranceType |
decimal |
An unique value indicating the over-completion tolerance type. Choices - Percent or Amount. |
PackType |
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. |
PackagingString |
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. |
PickComponentsFlag |
boolean |
A flag indicating whether an item has a structure l 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. |
Planner |
string |
An attribute indicating the material planner for the item. |
PlanningMakeBuy |
decimal |
An attribute indicating whether the item is usually manufactured or bought. |
PlanningMethod |
decimal |
An attribute indicating the organization level planning for the Item. Choices -Min-Max, Not Planned, Reorder Point. |
PlanningTimeDays |
decimal |
An attribute indicating the optional day added to the planning time fence when plannig time fence is User defined. |
PlanningTimeFence |
decimal |
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. |
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 |
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. |
ProcessStatus |
long |
Status of the interface row. (3- is errored, 7 - is successfully imported) |
ProcessSupplyLocatorValue |
string |
An attribute indicating the location from which the item is normally consumed as an ingredient in process manufacturing. |
ProcessSupplySubinventory |
string |
An unique value 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. |
ProcessYieldSubinventory |
string |
An unique value 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. |
PurchasedFlag |
boolean |
A flag which determines whether the Item is purchased and received. |
PurchasingInputTaxClassification |
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. |
RMAInspectionRequired |
decimal |
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. |
ReceiptDateAction |
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. |
ReceivingRoutingId |
long |
An attribute indicating routing of the Items at the time of receipt. |
RecipeEnabledFlag |
boolean |
A flag indicating that a receipt is required for the item transaction. |
RecoveredPartDisposition |
string |
An attribute indicating this field will control the process for returning defective or unused parts to a warehouse consolidation point. |
ReleaseAuthorizationRequired |
decimal |
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 |
decimal |
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. |
RepairYield |
decimal |
An attribute indicating the yield when you upgrade or repair a defective part. |
ReplacementType |
string |
Attribute indicating whether item is field or customer replaceable. |
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 |
decimal |
Attribute indicating the way in which requests are fulfilled. The value are Inventory, Supplier, or Subinventory. |
RequiresFulfillmentLocFlag |
boolean |
A flag indicating that a fullfilment 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 |
An unique value indicating the item is reservable and has inventory attributes. |
RestrictLocators |
decimal |
An attribute indicating whether to restrict transaction of this item to or from a locator specified. |
RestrictSubinventoriesFlag |
boolean |
An attribute indicating whether to restrict transactions of this item to or from a subinventory specified. |
RetestInterval |
decimal |
Number of days specifying how often lot controlled items should be retested |
ReturnableFlag |
boolean |
A flag indicating whether to allow customers to return an item. |
RevisionQuantityControlCode |
decimal |
An unique value that indicates the item is under revision control and has inventory attributes. |
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 t |
RoundingOrderQuantitiesFlag |
boolean |
An attribute indicating whether the planning process uses decimal or whole number values when calculating planned order quantities or repetitive rates. |
SafetyStockPlanningMethod |
string |
An attribute value that represents the type of safety planning method that will be used in planning for the item. |
SalesAccountValue |
string |
An attribute value for the display name of key flefield representing an account used when tracking a sales item. |
SalesProductType |
string |
An attribute indicating classification of an item or product for sales processes |
SecondaryUOMValue |
string |
An attribute indicating the Secondary Unit of Measure through which the Item can be transacted. |
SerialGeneration |
decimal |
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. |
ServiceDurationPeriod |
string |
An attribute indicating positive number to indicate the service duration period. |
ServiceDurationType |
string |
An attribute indicating type of duration applicable for a service item |
ServiceRequestEnabled |
string |
An attribute indicating type of duration applicable for a service item |
ServiceStartDelay |
decimal |
An attribue specifying the delay in starting a service after a milestone. |
ServiceType |
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 |
An attribute 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. |
SourceOrganization |
string |
An attribute indicating the organization from which an internal requisition draws the item. |
SourceSubinventory |
string |
An unique value indicating the sub inventory from which an internal requisition draws the item. |
SpokeSystemItem |
string |
The attribute that represents the name of the original system that data comes from. |
SpokeSystemItemDescription |
string |
An attribute value that represents the description of an item in the spoke system that is being referenced. |
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. |
StockLocatorControl |
decimal |
An attribute indicating the physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf. |
StructureItemType |
decimal |
An attribute indicating the type of structure the item can have. Structure Item Type include Model, Option Class, Standard and Planning. |
StyleItemFlag |
boolean |
Identifies if the item is a Style or a SKU. Y indicates Style, N indicates SKU, null indicates standard item |
StyleItemNumber |
string |
An unique identifier of the style item to which the SKU item is associated. |
SubcontractingComponent |
decimal |
An attribute indicating the subcontracting type associated to this item when it is used as a subcontracting component in Chargeable Subcontracting. Choices - Prepositioned, Synchronised. |
TaxableFlag |
boolean |
A flag indicating whether the supplier charges a Tax for the item. |
Template |
string |
An attribute that value provides metadata common to all items that share the category. |
TrackInstalledBaseFlag |
boolean |
A flag indicating life cycle tracking in Install Base and enterprise Install Base applications. |
TrackingUOM |
string |
An attribute indicating the Unit of Measure in which the Item is tracked in inventory. |
TransactionConversion |
decimal |
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. |
TransactionType |
string |
The attribute value which indicates the action type for the item transaction. The values includes CREATE, UPDATE, or DELETE. |
UNNumber |
string |
United Nations Identification Number used for International Trade purposes. |
UOMPricing |
string |
An attribute indicating the Unit of Measure in which the Item is priced for selling of the products and services. |
UnderCompletionToleranceType |
string |
Value that identifies the undercompletion tolerance type. The valid values include percentage or quantity. The default value is null. |
UnderCompletionToleranceValue |
decimal |
Undercompletion Tolerance Value - 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. |
UnitHeight |
decimal |
An attribute Indicating height of Item. |
UnitLength |
decimal |
An attribute Indicating length of Item. |
UnitOfIssue |
string |
An attribute indicating Unit of measure used for issuing the item from inventory. |
UnitVolume |
decimal |
An attribute Indicating Volume of One Unit of Item. |
UnitWeight |
decimal |
Conversion between weight unit of measure and base unit of measure |
UnitWidth |
decimal |
An attribute Indicating width of Item. |
UseApprovedSupplierFlag |
boolean |
A flag indicating an approved supplier must be used. |
UserItemType |
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. |
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. |
VersionPlannedEffectiveDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time on which the item revision is scheduled to be effective. |
VmiFixedOrderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
An attribute indicating fixed quantity for reorder ( Vendor Managed Inventory). |
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. |
WIPSupplySubinventory |
string |
An attribute indicating a supply subinventory for components. |
WIPSupplyType |
long |
An attribute indicating a supply type for components. |
WarehouseEquipment |
decimal |
Flag indicating item is equipment |
WebStatus |
string |
An attribute indicating Indicate the web status of this item.(enabled, Published, Unpublished). |
WeightUOMValue |
string |
An attribute indicating Weight Unit of Measure. |