JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

ItemsV2

The Items Version 2 resource manages the item details. An item is any part, material, product, or service that is unique when compared to the attributes of any other item.

Columns

Name Type Description
ItemId [KEY] Long ItemId of ItemsV2
OrganizationId [KEY] Long OrganizationId of ItemsV2
OrganizationCode String OrganizationCode of ItemsV2
ItemClass String ItemClass of ItemsV2
Template String Template of ItemsV2
ItemNumber String ItemNumber of ItemsV2
ItemDescription String ItemDescription of ItemsV2
ApprovalStatusValue String ApprovalStatusValue of ItemsV2
ItemStatusValue String ItemStatusValue of ItemsV2
LifecyclePhaseValue String LifecyclePhaseValue of ItemsV2
StyleItemFlag Bool StyleItemFlag of ItemsV2
StyleItemNumberValue String StyleItemNumberValue of ItemsV2
Keyword String Keyword of ItemsV2
IgnoreDuplicateItemFlag Bool IgnoreDuplicateItemFlag of ItemsV2
UserItemTypeValue String UserItemTypeValue of ItemsV2
PackTypeValue String PackTypeValue of ItemsV2
LongDescription String LongDescription of ItemsV2
FormattedDescription String FormattedDescription of ItemsV2
PrimaryUOMValue String PrimaryUOMValue of ItemsV2
TransactionConversionValue String TransactionConversionValue of ItemsV2
DefaultingControlValue String DefaultingControlValue of ItemsV2
PositiveDeviationFactor Decimal PositiveDeviationFactor of ItemsV2
NegativeDeviationFactor Decimal NegativeDeviationFactor of ItemsV2
CopyItemAndApplyTemplatesFlag Bool CopyItemAndApplyTemplatesFlag of ItemsV2
CopyAssociationsFlag Bool CopyAssociationsFlag of ItemsV2
CopyAttachmentsFlag Bool CopyAttachmentsFlag of ItemsV2
CopyCategoriesFlag Bool CopyCategoriesFlag of ItemsV2
CopyFromItemValue String CopyFromItemValue of ItemsV2
CopyFromRevisionValue String CopyFromRevisionValue of ItemsV2
CopyFromVersionValue String CopyFromVersionValue of ItemsV2
CopyOrganizationAssignmentsFlag Bool CopyOrganizationAssignmentsFlag of ItemsV2
LastSubmittedNewItemRequest String LastSubmittedNewItemRequest of ItemsV2
ChangeNotice String ChangeNotice of ItemsV2
ChangeOrderLineSequenceNumber Int ChangeOrderLineSequenceNumber of ItemsV2
StructureItemTypeValue String StructureItemTypeValue of ItemsV2
CreateConfiguredItem String CreateConfiguredItem of ItemsV2
ConfigModelTypeValue String ConfigModelTypeValue of ItemsV2
EffectivityControlValue String EffectivityControlValue of ItemsV2
BaseItemValue String BaseItemValue of ItemsV2
AutoCreatedConfigurationFlag Bool AutoCreatedConfigurationFlag of ItemsV2
PickComponentsFlag Bool PickComponentsFlag of ItemsV2
AssembleToOrderFlag Bool AssembleToOrderFlag of ItemsV2
CostingEnabledFlag Bool CostingEnabledFlag of ItemsV2
IncludeInRollUpFlag Bool IncludeInRollUpFlag of ItemsV2
StandardLotSize Decimal StandardLotSize of ItemsV2
InventoryAssetFlag Bool InventoryAssetFlag of ItemsV2
BuildInWIPFlag Bool BuildInWIPFlag of ItemsV2
WIPSupplyTypeValue String WIPSupplyTypeValue of ItemsV2
WIPSupplyLocatorValue String WIPSupplyLocatorValue of ItemsV2
WIPSupplySubinventoryValue String WIPSupplySubinventoryValue of ItemsV2
OvercompletionToleranceTypeValue String OvercompletionToleranceTypeValue of ItemsV2
OvercompletionToleranceValue Decimal OvercompletionToleranceValue of ItemsV2
InventoryCarryPenalty Decimal InventoryCarryPenalty of ItemsV2
OperationSlackPenalty Decimal OperationSlackPenalty of ItemsV2
RecipeEnabledFlag Bool RecipeEnabledFlag of ItemsV2
ProcessQualityEnabledFlag Bool ProcessQualityEnabledFlag of ItemsV2
ProcessCostingEnabledFlag Bool ProcessCostingEnabledFlag of ItemsV2
ProcessExecutionEnabledFlag Bool ProcessExecutionEnabledFlag of ItemsV2
ProcessSupplySubinventoryValue String ProcessSupplySubinventoryValue of ItemsV2
ProcessSupplyLocatorValue String ProcessSupplyLocatorValue of ItemsV2
ProcessYieldSubinventoryValue String ProcessYieldSubinventoryValue of ItemsV2
ProcessYieldLocatorValue String ProcessYieldLocatorValue of ItemsV2
HazardousMaterialFlag Bool HazardousMaterialFlag of ItemsV2
CASNumber String CASNumber of ItemsV2
AssetTrackedFlag Bool AssetTrackedFlag of ItemsV2
AssetClassValue String AssetClassValue of ItemsV2
ServiceRequestEnabledValue String ServiceRequestEnabledValue of ItemsV2
DefectTrackingOnFlag Bool DefectTrackingOnFlag of ItemsV2
ServiceDurationTypeValue String ServiceDurationTypeValue of ItemsV2
ServiceDuration Decimal ServiceDuration of ItemsV2
ServiceDurationPeriodValue String ServiceDurationPeriodValue of ItemsV2
ServiceStartTypeValue String ServiceStartTypeValue of ItemsV2
ServiceStartDelay Decimal ServiceStartDelay of ItemsV2
AllowSuspendFlag Bool AllowSuspendFlag of ItemsV2
AllowTerminateFlag Bool AllowTerminateFlag of ItemsV2
RequiresItemAssociationFlag Bool RequiresItemAssociationFlag of ItemsV2
CreateFixedAssetFlag Bool CreateFixedAssetFlag of ItemsV2
InstanceClassValue String InstanceClassValue of ItemsV2
BillingTypeValue String BillingTypeValue of ItemsV2
ServiceBillingEnabledFlag Bool ServiceBillingEnabledFlag of ItemsV2
RecoveredPartDispositionValue String RecoveredPartDispositionValue of ItemsV2
InventoryItemFlag Bool InventoryItemFlag of ItemsV2
StockEnabledFlag Bool StockEnabledFlag of ItemsV2
MaterialTransactionEnabledFlag Bool MaterialTransactionEnabledFlag of ItemsV2
ReservableFlag Bool ReservableFlag of ItemsV2
CheckMaterialShortageFlag Bool CheckMaterialShortageFlag of ItemsV2
RevisionQuantityControlFlag Bool RevisionQuantityControlFlag of ItemsV2
BulkPickedFlag Bool BulkPickedFlag of ItemsV2
LotControlValue String LotControlValue of ItemsV2
StartingLotPrefix String StartingLotPrefix of ItemsV2
StartingLotNumber String StartingLotNumber of ItemsV2
MaturityDays Decimal MaturityDays of ItemsV2
HoldDays Decimal HoldDays of ItemsV2
LotExpirationControlValue String LotExpirationControlValue of ItemsV2
ShelfLifeDays Decimal ShelfLifeDays of ItemsV2
RetestInterval Decimal RetestInterval of ItemsV2
ExpirationActionValue String ExpirationActionValue of ItemsV2
ExpirationActionInterval Decimal ExpirationActionInterval of ItemsV2
ChildLotEnabledFlag Bool ChildLotEnabledFlag of ItemsV2
ChildLotFormatValidationFlag Bool ChildLotFormatValidationFlag of ItemsV2
CopyLotAttributeFlag Bool CopyLotAttributeFlag of ItemsV2
ChildLotPrefix String ChildLotPrefix of ItemsV2
ChildLotStartingNumber Decimal ChildLotStartingNumber of ItemsV2
ChildLotParent String ChildLotParent of ItemsV2
LotTranslateEnabledFlag Bool LotTranslateEnabledFlag of ItemsV2
LotSplitEnabledFlag Bool LotSplitEnabledFlag of ItemsV2
LotDivisibleFlag Bool LotDivisibleFlag of ItemsV2
LotSubstitutionEnabledFlag Bool LotSubstitutionEnabledFlag of ItemsV2
LotMergeEnabledFlag Bool LotMergeEnabledFlag of ItemsV2
GradeControlFlag Bool GradeControlFlag of ItemsV2
DefaultGradeValue String DefaultGradeValue of ItemsV2
SerialGenerationValue String SerialGenerationValue of ItemsV2
SerialStartingPrefix String SerialStartingPrefix of ItemsV2
SerialStartingNumber String SerialStartingNumber of ItemsV2
NegativeMeasurementError Decimal NegativeMeasurementError of ItemsV2
PositiveMeasurementError Decimal PositiveMeasurementError of ItemsV2
CycleCountEnabledFlag Bool CycleCountEnabledFlag of ItemsV2
LotStatusEnabledFlag Bool LotStatusEnabledFlag of ItemsV2
SerialStatusEnabledFlag Bool SerialStatusEnabledFlag of ItemsV2
DefaultLotStatusValue String DefaultLotStatusValue of ItemsV2
DefaultSerialStatusValue String DefaultSerialStatusValue of ItemsV2
RestrictSubinventoriesFlag Bool RestrictSubinventoriesFlag of ItemsV2
RestrictLocatorsFlag Bool RestrictLocatorsFlag of ItemsV2
StockLocatorControlValue String StockLocatorControlValue of ItemsV2
DimensionUOMValue String DimensionUOMValue of ItemsV2
UnitWidthQuantity Decimal UnitWidthQuantity of ItemsV2
UnitLengthQuantity Decimal UnitLengthQuantity of ItemsV2
UnitHeightQuantity Decimal UnitHeightQuantity of ItemsV2
WeightUOMValue String WeightUOMValue of ItemsV2
UnitWeightQuantity Decimal UnitWeightQuantity of ItemsV2
VolumeUOMValue String VolumeUOMValue of ItemsV2
UnitVolumeQuantity Decimal UnitVolumeQuantity of ItemsV2
ContainerItemFlag Bool ContainerItemFlag of ItemsV2
ContainerTypeValue String ContainerTypeValue of ItemsV2
MaximumLoadWeight Decimal MaximumLoadWeight of ItemsV2
VehicleItemFlag Bool VehicleItemFlag of ItemsV2
InternalVolume Decimal InternalVolume of ItemsV2
MinimumFillPercent Decimal MinimumFillPercent of ItemsV2
WarehouseEquipmentFlag Bool WarehouseEquipmentFlag of ItemsV2
EventFlag Bool EventFlag of ItemsV2
CollateralFlag Bool CollateralFlag of ItemsV2
CustomerOrderFlag Bool CustomerOrderFlag of ItemsV2
CustomerOrderEnabledFlag Bool CustomerOrderEnabledFlag of ItemsV2
ATPComponentsValue String ATPComponentsValue of ItemsV2
PickingRuleValue String PickingRuleValue of ItemsV2
RMAInspectionRequiredFlag Bool RMAInspectionRequiredFlag of ItemsV2
EligibilityRuleFlag Bool EligibilityRuleFlag of ItemsV2
ReturnableFlag Bool ReturnableFlag of ItemsV2
ATPValue String ATPValue of ItemsV2
FinancingAllowedFlag Bool FinancingAllowedFlag of ItemsV2
SalesProductTypeValue String SalesProductTypeValue of ItemsV2
TransactionEnabledFlag Bool TransactionEnabledFlag of ItemsV2
OrderManagementIndivisibleFlag Bool OrderManagementIndivisibleFlag of ItemsV2
DefaultSalesOrderSourceTypeValue String DefaultSalesOrderSourceTypeValue of ItemsV2
ElectronicFormatFlag Bool ElectronicFormatFlag of ItemsV2
ShippableFlag Bool ShippableFlag of ItemsV2
DefaultShippingOrganizationValue String DefaultShippingOrganizationValue of ItemsV2
ShipModelCompleteFlag Bool ShipModelCompleteFlag of ItemsV2
DownloadableFlag Bool DownloadableFlag of ItemsV2
OverShipmentTolerance Decimal OverShipmentTolerance of ItemsV2
UnderShipmentTolerance Decimal UnderShipmentTolerance of ItemsV2
OverReturnTolerance Decimal OverReturnTolerance of ItemsV2
UnderReturnTolerance Decimal UnderReturnTolerance of ItemsV2
InvoiceEnabledFlag Bool InvoiceEnabledFlag of ItemsV2
AccountingRuleValue String AccountingRuleValue of ItemsV2
PaymentTermsValue String PaymentTermsValue of ItemsV2
OutputTaxClassificationCodeValue String OutputTaxClassificationCodeValue of ItemsV2
InvoicedFlag Bool InvoicedFlag of ItemsV2
InvoicingRuleValue String InvoicingRuleValue of ItemsV2
SalesAccountValue String SalesAccountValue of ItemsV2
WebStatusValue String WebStatusValue of ItemsV2
BackOrderableFlag Bool BackOrderableFlag of ItemsV2
OrderableOnWebFlag Bool OrderableOnWebFlag of ItemsV2
MinimumLicenseQuantity Decimal MinimumLicenseQuantity of ItemsV2
InventoryPlanningMethodValue String InventoryPlanningMethodValue of ItemsV2
PlanningMakeBuyValue String PlanningMakeBuyValue of ItemsV2
Planner String Planner of ItemsV2
SubcontractingComponentValue String SubcontractingComponentValue of ItemsV2
MinimumMinmaxQuantity Decimal MinimumMinmaxQuantity of ItemsV2
MaximumMinmaxQuantity Decimal MaximumMinmaxQuantity of ItemsV2
MinimumOrderQuantity Decimal MinimumOrderQuantity of ItemsV2
MaximumOrderQuantity Decimal MaximumOrderQuantity of ItemsV2
OrderCost Decimal OrderCost of ItemsV2
SourceOrganizationValue String SourceOrganizationValue of ItemsV2
SourceSubinventoryOrganizationValue String SourceSubinventoryOrganizationValue of ItemsV2
SourceSubinventoryValue String SourceSubinventoryValue of ItemsV2
FixedOrderQuantity Decimal FixedOrderQuantity of ItemsV2
FixedDaysSupply Decimal FixedDaysSupply of ItemsV2
FixedLotSizeMultiplier Decimal FixedLotSizeMultiplier of ItemsV2
ReleaseAuthorizationRequiredValue String ReleaseAuthorizationRequiredValue of ItemsV2
AutomaticallyExpireASNFlag Bool AutomaticallyExpireASNFlag of ItemsV2
ConsignedFlag Bool ConsignedFlag of ItemsV2
ReplenishmentMinimumOrder Decimal ReplenishmentMinimumOrder of ItemsV2
ReplenishmentMaximumOrder Decimal ReplenishmentMaximumOrder of ItemsV2
VMIFixedOrderQuantity Decimal VMIFixedOrderQuantity of ItemsV2
ForecastTypelValue String ForecastTypelValue of ItemsV2
ForecastHorizon Decimal ForecastHorizon of ItemsV2
PlanningMethodValue String PlanningMethodValue of ItemsV2
RoundingControlTypeFlag Bool RoundingControlTypeFlag of ItemsV2
CreateSupplyFlag Bool CreateSupplyFlag of ItemsV2
PlanningTimeFence String PlanningTimeFence of ItemsV2
DemandTimeFence String DemandTimeFence of ItemsV2
ReleaseTimeFence String ReleaseTimeFence of ItemsV2
ShrinkageRate Decimal ShrinkageRate of ItemsV2
ForecastControlValue String ForecastControlValue of ItemsV2
AcceptableEarlyDays Decimal AcceptableEarlyDays of ItemsV2
PlanningTimeDays Decimal PlanningTimeDays of ItemsV2
DemandTimeDays Decimal DemandTimeDays of ItemsV2
ReleaseTimeDays Decimal ReleaseTimeDays of ItemsV2
MRPCalculateATPFlag Bool MRPCalculateATPFlag of ItemsV2
RepairLeadtime Decimal RepairLeadtime of ItemsV2
RepairYield Decimal RepairYield of ItemsV2
PreprocessingDays Decimal PreprocessingDays of ItemsV2
PostprocessingDays Decimal PostprocessingDays of ItemsV2
ProcessingDays Decimal ProcessingDays of ItemsV2
VariableLeadTime Decimal VariableLeadTime of ItemsV2
CumulativeTotalLeadTime Decimal CumulativeTotalLeadTime of ItemsV2
FixedLeadTime Decimal FixedLeadTime of ItemsV2
CumulativeManufacturingLeadTime Decimal CumulativeManufacturingLeadTime of ItemsV2
LeadTimeLotSize Decimal LeadTimeLotSize of ItemsV2
PurchasingFlag Bool PurchasingFlag of ItemsV2
UseApprovedSupplierFlag Bool UseApprovedSupplierFlag of ItemsV2
NegotiationRequiredFlag Bool NegotiationRequiredFlag of ItemsV2
PurchasingInputTaxClassificationValue String PurchasingInputTaxClassificationValue of ItemsV2
InvoiceCloseTolerancePercentage Decimal InvoiceCloseTolerancePercentage of ItemsV2
HazardClassValue String HazardClassValue of ItemsV2
AssetCategoryValue String AssetCategoryValue of ItemsV2
PurchasableFlag Bool PurchasableFlag of ItemsV2
TaxableFlag Bool TaxableFlag of ItemsV2
BuyerOrganizationValue String BuyerOrganizationValue of ItemsV2
DefaultBuyerValue String DefaultBuyerValue of ItemsV2
ReceiptCloseTolerancePercentage Decimal ReceiptCloseTolerancePercentage of ItemsV2
UNNumberValue String UNNumberValue of ItemsV2
ListPrice Decimal ListPrice of ItemsV2
PriceTolerancePercentage Decimal PriceTolerancePercentage of ItemsV2
MarketPrice Decimal MarketPrice of ItemsV2
RoundingFactor Decimal RoundingFactor of ItemsV2
MatchApprovalLevelValue String MatchApprovalLevelValue of ItemsV2
MatchConfigurationOptionValue String MatchConfigurationOptionValue of ItemsV2
ReceiptDateActionValue String ReceiptDateActionValue of ItemsV2
DaysEarlyReceiptAllowed Decimal DaysEarlyReceiptAllowed of ItemsV2
DaysLateReceiptAllowed Decimal DaysLateReceiptAllowed of ItemsV2
AllowSubstituteReceiptsFlag Bool AllowSubstituteReceiptsFlag of ItemsV2
AllowUnorderedReceiptsFlag Bool AllowUnorderedReceiptsFlag of ItemsV2
QuantityReceivedToleranceAction String QuantityReceivedToleranceAction of ItemsV2
QuantityReceivedTolerancePercentage Decimal QuantityReceivedTolerancePercentage of ItemsV2
ItemExtensibleFlexfieldCategoryCode String ItemExtensibleFlexfieldCategoryCode of ItemsV2
CreationDate Datetime CreationDate of ItemsV2
LastUpdateDate Datetime LastUpdateDate of ItemsV2
BackToBackEnabledFlag Bool BackToBackEnabledFlag of ItemsV2
ContractManufacturingFlag Bool ContractManufacturingFlag of ItemsV2
DaysOfCover Decimal DaysOfCover of ItemsV2
DemandPeriod Decimal DemandPeriod of ItemsV2
SafetyStockPlanningMethodValue String SafetyStockPlanningMethodValue of ItemsV2
OutsideProcessServiceFlag Bool OutsideProcessServiceFlag of ItemsV2
AllowMaintenanceAssetFlag Bool AllowMaintenanceAssetFlag of ItemsV2
EnableGenealogyTrackingFlag Bool EnableGenealogyTrackingFlag of ItemsV2
EngineeredItemFlag Bool EngineeredItemFlag of ItemsV2
ProcurementBusinessUnitName String ProcurementBusinessUnitName of ItemsV2
ForcePurchaseLeadTimeFlag Bool ForcePurchaseLeadTimeFlag of ItemsV2
ReplacementTypeValue String ReplacementTypeValue of ItemsV2
BuyerEmailAddress String BuyerEmailAddress of ItemsV2
AssetTrackedValue String AssetTrackedValue of ItemsV2
RequestId Long RequestId of ItemsV2
CreatedBy String CreatedBy of ItemsV2
CreationDateTime Datetime CreationDateTime of ItemsV2
LastUpdateDateTime Datetime LastUpdateDateTime of ItemsV2
LastUpdateLogin String LastUpdateLogin of ItemsV2
LastUpdatedBy String LastUpdatedBy of ItemsV2
InternallyTransferableFlag Bool InternallyTransferableFlag of ItemsV2
TransferOrdersEnabledFlag Bool TransferOrdersEnabledFlag of ItemsV2
ReplenishmentMaximumDaysOfSupply Decimal ReplenishmentMaximumDaysOfSupply of ItemsV2
CustomerSelfServiceEnabledFlag Bool CustomerSelfServiceEnabledFlag of ItemsV2
AllowPurchasingDocumentDescriptionUpdateFlag Bool AllowPurchasingDocumentDescriptionUpdateFlag of ItemsV2
EnableContractCoverage Bool EnableContractCoverage of ItemsV2
CarryingCostPercentage Decimal CarryingCostPercentage of ItemsV2
ReplenishmentMinimumDaysOfSupply Decimal ReplenishmentMinimumDaysOfSupply of ItemsV2
AllowExpressTransactionsFlag Bool AllowExpressTransactionsFlag of ItemsV2
ReceiptRoutingValue String ReceiptRoutingValue of ItemsV2
InvoiceMatchOptionValue String InvoiceMatchOptionValue of ItemsV2
CommsActivationRequiredFlag Bool CommsActivationRequiredFlag of ItemsV2
RequiresFulfillmentLocationFlag Bool RequiresFulfillmentLocationFlag of ItemsV2
IssueUOMValue String IssueUOMValue of ItemsV2
EnforceShipToLocationValue String EnforceShipToLocationValue of ItemsV2
StandardCoverageValue String StandardCoverageValue of ItemsV2
ReplenishmentSourceTypeValue String ReplenishmentSourceTypeValue of ItemsV2
TrackingUOMValue String TrackingUOMValue of ItemsV2
SecondaryUOMValue String SecondaryUOMValue of ItemsV2
PricingUOMValue String PricingUOMValue of ItemsV2
HardPeggingLevelValue String HardPeggingLevelValue of ItemsV2
CommonSupplyProjectDemandFlag Bool CommonSupplyProjectDemandFlag of ItemsV2
EnableIotFlag Bool EnableIotFlag of ItemsV2
ExpenditureTypeValue String ExpenditureTypeValue of ItemsV2
PackagingStringValue String PackagingStringValue of ItemsV2
CreateSupplyAfterDate Date CreateSupplyAfterDate of ItemsV2
CreateFixedAssetValue String CreateFixedAssetValue of ItemsV2
UnderCompletionToleranceTypeValue String UnderCompletionToleranceTypeValue of ItemsV2
UnderCompletionToleranceValue Decimal UnderCompletionToleranceValue of ItemsV2
DefaultRepairTransactionName String DefaultRepairTransactionName of ItemsV2
CreatedFromItemId Long CreatedFromItemId of ItemsV2
CreatedFromItemNumber String CreatedFromItemNumber of ItemsV2
CreatedFromItemRevision String CreatedFromItemRevision of ItemsV2
ItemObjectTypeValue String ItemObjectTypeValue of ItemsV2
AcdType String AcdType of ItemsV2
ChangeLineId Long ChangeLineId of ItemsV2
Finder String Finder of ItemsV2
InventoryOrganizationId Long InventoryOrganizationId of ItemsV2
VersionId Long VersionId of ItemsV2

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060