JDBC Driver for Oracle SCM

Build 22.0.8462

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 String ItemId of ItemTemplates
OrganizationId String 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 String PositiveDeviationFactor of ItemTemplates
NegativeDeviationFactor String 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 Long 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 String 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 String OvercompletionToleranceValue of ItemTemplates
InventoryCarryPenalty String InventoryCarryPenalty of ItemTemplates
OperationSlackPenalty String 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 String ServiceDuration of ItemTemplates
ServiceDurationPeriodValue String ServiceDurationPeriodValue of ItemTemplates
ServiceStartTypeValue String ServiceStartTypeValue of ItemTemplates
ServiceStartDelay String 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 String MaturityDays of ItemTemplates
HoldDays String HoldDays of ItemTemplates
LotExpirationControlValue String LotExpirationControlValue of ItemTemplates
ShelfLifeDays String ShelfLifeDays of ItemTemplates
RetestInterval String RetestInterval of ItemTemplates
ExpirationActionValue String ExpirationActionValue of ItemTemplates
ExpirationActionInterval String ExpirationActionInterval of ItemTemplates
ChildLotEnabledFlag Bool ChildLotEnabledFlag of ItemTemplates
ChildLotFormatValidationFlag Bool ChildLotFormatValidationFlag of ItemTemplates
CopyLotAttributeFlag Bool CopyLotAttributeFlag of ItemTemplates
ChildLotPrefix String ChildLotPrefix of ItemTemplates
ChildLotStartingNumber String 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 String NegativeMeasurementError of ItemTemplates
PositiveMeasurementError String 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 String UnitWidthQuantity of ItemTemplates
UnitLengthQuantity String UnitLengthQuantity of ItemTemplates
UnitHeightQuantity String UnitHeightQuantity of ItemTemplates
WeightUOMValue String WeightUOMValue of ItemTemplates
UnitWeightQuantity String UnitWeightQuantity of ItemTemplates
VolumeUOMValue String VolumeUOMValue of ItemTemplates
UnitVolumeQuantity String UnitVolumeQuantity of ItemTemplates
ContainerItemFlag Bool ContainerItemFlag of ItemTemplates
ContainerTypeValue String ContainerTypeValue of ItemTemplates
MaximumLoadWeight String MaximumLoadWeight of ItemTemplates
VehicleItemFlag Bool VehicleItemFlag of ItemTemplates
InternalVolume String InternalVolume of ItemTemplates
MinimumFillPercent String 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 String OverShipmentTolerance of ItemTemplates
UnderShipmentTolerance String UnderShipmentTolerance of ItemTemplates
OverReturnTolerance String OverReturnTolerance of ItemTemplates
UnderReturnTolerance String 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 String MinimumLicenseQuantity of ItemTemplates
InventoryPlanningMethodValue String InventoryPlanningMethodValue of ItemTemplates
PlanningMakeBuyValue String PlanningMakeBuyValue of ItemTemplates
Planner String Planner of ItemTemplates
SubcontractingComponentValue String SubcontractingComponentValue of ItemTemplates
MinimumMinmaxQuantity String MinimumMinmaxQuantity of ItemTemplates
MaximumMinmaxQuantity String MaximumMinmaxQuantity of ItemTemplates
MinimumOrderQuantity String MinimumOrderQuantity of ItemTemplates
MaximumOrderQuantity String MaximumOrderQuantity of ItemTemplates
OrderCost String OrderCost of ItemTemplates
SourceOrganizationValue String SourceOrganizationValue of ItemTemplates
SourceSubinventoryOrganizationValue String SourceSubinventoryOrganizationValue of ItemTemplates
SourceSubinventoryValue String SourceSubinventoryValue of ItemTemplates
FixedOrderQuantity String FixedOrderQuantity of ItemTemplates
FixedDaysSupply String FixedDaysSupply of ItemTemplates
FixedLotSizeMultiplier String FixedLotSizeMultiplier of ItemTemplates
ReleaseAuthorizationRequiredValue String ReleaseAuthorizationRequiredValue of ItemTemplates
AutomaticallyExpireASNFlag Bool AutomaticallyExpireASNFlag of ItemTemplates
ConsignedFlag Bool ConsignedFlag of ItemTemplates
ReplenishmentMinimumOrder String ReplenishmentMinimumOrder of ItemTemplates
ReplenishmentMaximumOrder String ReplenishmentMaximumOrder of ItemTemplates
VMIFixedOrderQuantity String VMIFixedOrderQuantity of ItemTemplates
ForecastTypelValue String ForecastTypelValue of ItemTemplates
ForecastHorizon String 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 String ShrinkageRate of ItemTemplates
ForecastControlValue String ForecastControlValue of ItemTemplates
AcceptableEarlyDays String AcceptableEarlyDays of ItemTemplates
PlanningTimeDays String PlanningTimeDays of ItemTemplates
DemandTimeDays String DemandTimeDays of ItemTemplates
ReleaseTimeDays String ReleaseTimeDays of ItemTemplates
MRPCalculateATPFlag Bool MRPCalculateATPFlag of ItemTemplates
RepairLeadtime String RepairLeadtime of ItemTemplates
RepairYield String RepairYield of ItemTemplates
PreprocessingDays String PreprocessingDays of ItemTemplates
PostprocessingDays String PostprocessingDays of ItemTemplates
ProcessingDays String ProcessingDays of ItemTemplates
VariableLeadTime String VariableLeadTime of ItemTemplates
CumulativeTotalLeadTime String CumulativeTotalLeadTime of ItemTemplates
FixedLeadTime String FixedLeadTime of ItemTemplates
CumulativeManufacturingLeadTime String CumulativeManufacturingLeadTime of ItemTemplates
LeadTimeLotSize String LeadTimeLotSize of ItemTemplates
PurchasingFlag Bool PurchasingFlag of ItemTemplates
UseApprovedSupplierFlag Bool UseApprovedSupplierFlag of ItemTemplates
NegotiationRequiredFlag Bool NegotiationRequiredFlag of ItemTemplates
PurchasingInputTaxClassificationValue String PurchasingInputTaxClassificationValue of ItemTemplates
InvoiceCloseTolerancePercentage String 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 String ReceiptCloseTolerancePercentage of ItemTemplates
UNNumberValue String UNNumberValue of ItemTemplates
ListPrice String ListPrice of ItemTemplates
PriceTolerancePercentage String PriceTolerancePercentage of ItemTemplates
MarketPrice String MarketPrice of ItemTemplates
RoundingFactor String RoundingFactor of ItemTemplates
MatchApprovalLevelValue String MatchApprovalLevelValue of ItemTemplates
MatchConfigurationOptionValue String MatchConfigurationOptionValue of ItemTemplates
ReceiptDateActionValue String ReceiptDateActionValue of ItemTemplates
DaysEarlyReceiptAllowed String DaysEarlyReceiptAllowed of ItemTemplates
DaysLateReceiptAllowed String DaysLateReceiptAllowed of ItemTemplates
AllowSubstituteReceiptsFlag Bool AllowSubstituteReceiptsFlag of ItemTemplates
AllowUnorderedReceiptsFlag Bool AllowUnorderedReceiptsFlag of ItemTemplates
QuantityReceivedToleranceAction String QuantityReceivedToleranceAction of ItemTemplates
QuantityReceivedTolerancePercentage String 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 String DaysOfCover of ItemTemplates
DemandPeriod String 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 String 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 String ReplenishmentMaximumDaysOfSupply of ItemTemplates
CustomerSelfServiceEnabledFlag Bool CustomerSelfServiceEnabledFlag of ItemTemplates
AllowPurchasingDocumentDescriptionUpdateFlag Bool AllowPurchasingDocumentDescriptionUpdateFlag of ItemTemplates
EnableContractCoverage Bool EnableContractCoverage of ItemTemplates
CarryingCostPercentage String CarryingCostPercentage of ItemTemplates
ReplenishmentMinimumDaysOfSupply String 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 String UnderCompletionToleranceValue of ItemTemplates
TemplateName String TemplateName of ItemTemplates

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462