JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ItemTemplates

The Item Templates resource manages item templates. An item template is a defined set of item attributes that enables quick creation of items with standard attributes. When you apply a template to an item, you overlay or default in the set of attribute values to the item definition.

Columns

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

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