JDBC Driver for Oracle SCM

Build 22.0.8462

StandardOperations

The Standard Operations resource manages standard operations.

Columns

Name Type Description
OrganizationId String Value that uniquely identifies the inventory organization that the application enables for manufacturing. It is a primary key that the application generates when it creates the inventory organization.
OperationType String Specifies the type of the operation. A list of accepted values is defined in the lookup type ORA_WIS_OPERATION_TYPE.
OperationTypeDescription String OperationTypeDescription of StandardOperations
StandardOperationId [KEY] String Value that uniquely identifies the standard operation. It is a primary key that the application generates when it creates the standard operation.
StandardOperationName String Name of the standard operation.
StandardOperationCode String Abbreviation that identifies the standard operation.
StandardOperationDescription String Description of the standard operation.
WorkAreaId String WorkAreaId of StandardOperations
WorkAreaCode String WorkAreaCode of StandardOperations
WorkAreaName String WorkAreaName of StandardOperations
WorkAreaDescription String WorkAreaDescription of StandardOperations
WorkCenterId String Value that uniquely identifies the work center. It is a primary key that the application generates when it creates the work center.
WorkCenterCode String Abbreviation that identifies the work center.
WorkCenterName String WorkCenterName of StandardOperations
WorkCenterDescription String WorkCenterDescription of StandardOperations
OSPItemId String Value that uniquely identifies the outside processing (OSP) item. It is a primary key that the application generates when it creates the item.
OSPItemDescription String OSPItemDescription of StandardOperations
SupplierId String Value that uniquely identifies the outside processing (OSP) supplier. It is a primary key that the application generates when it creates the supplier.
SupplierName String Name of the outside processing (OSP) supplier.
SupplierSiteId String Value that uniquely identifies the supplier site. It is a primary key that the application generates when it creates the supplier site.
SupplierSiteDescription String SupplierSiteDescription of StandardOperations
FixedLeadTime String Lead time to perform this outside processing (OSP) operation, independent of the quantity of the outside processing item.
VariableLeadTime String Lead time to perform this outside processing (OSP) operation for each unit of the outside processing item.
LeadTimeUOMCode String Abbreviation that identifies the unit of measure that the lead time uses.
LeadTimeUnitOfMeasure String LeadTimeUnitOfMeasure of StandardOperations
CountPointOperationFlag Bool Contains one of the following values: true or false. If true, then this operation is a count point operation. If an operation is a count point operation, then you have to manually complete it. If false, then this operation is not a count point operation. If an operation is not a count operation, then you have to report the operation. The default value is false.
AutoTransactFlag Bool Contains one of the following values: true or false. If true, then both resources and materials are automatically charged based on the supply type or the charge type setup for the operation. If the supply type is Operation Pull, the component level issue transactions will happen when the operation is completed. If the supply type is Assembly Pull, the component level issue transactions will happen at the assembly completion event. Resource transactions are automatically performed when the quantity is moved outside the operation. If false, then this operation is not reported automatically. If the operation is not significant, then it is recommended that you set this attribute to true. The Count Point attribute and the Automatically Transact attribute are mutually exclusive. You must make sure that each of these attributes do not both contain true. If Count Point and Automatically Transact each contain false, then the operation is optional. You can manually report component usage and resource usage for an optional operation. The default value is false.
InactiveDate Date Date when the standard operation is not valid.
ResourcesCount Long ResourcesCount of StandardOperations
DefaultforAutomaticWorkDefinition String Contains one of the following values: true or false. If true, then this standard operation is the default operation when the application automatically creates the work definition from the item structure. If false, then the application does not use this standard operation when creating the work definition. Only one valid standard operation can exist for each instance that the application contains. Default value is false.
AddlMtlAtManualIssue String Name that identifies a list of values that control whether a production operator can issue more than the required quantity while manually reporting material issues. You can allow issuing more than the required quantity without any hindrance, or prevent the material issue in case of additional material issue.
OperationComplWithOpenExceptions String Name that identifies a list of values that control whether operation completion should be allowed when open exceptions exist for an operation. You can allow operation completion without any hindrance, allow with a warning, or prevent the operation completion.
OperationComplWithUnderIssue String Name that identifies a list of values that control whether operation completion should be allowed when less than the required quantity of material is issued. You can allow operation completion without any hindrance, allow with a warning, or prevent the operation completion.
OrganizationCode String Abbreviation that identifies the inventory organization that is enabled for manufacturing.
OrganizationIdMfg String OrganizationIdMfg of StandardOperations
OSPItemNumber String Abbreviation that identifies outside processing (OSP) item.
InventoryItemId String InventoryItemId of StandardOperations
OrganizationIdInv String OrganizationIdInv of StandardOperations
SupplierSiteCode String Abbreviation that identifies the supplier site.

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