JDBC Driver for Oracle SCM

Build 22.0.8462

InspectionPlanscriteria

The Criteria in Inspection Plans resource manages criteria for the inspection plan.

Columns

Name Type Description
InspectionPlansInspectionPlanId String Value that uniquely identifies the inspection plan.
CriteriaId String Value that uniquely identifies the inspection plan criteria.
InspectionPlanId String Value that uniquely identifies the inspection plan.
InspectionPlanType String Type of inspection plan. Valid values include Receiving, Inventory, Work in process, and Resource. A list of accepted values is defined in the lookup type ORA_QA_IP_TYPES.
OperationSequenceNumber Long Sequence number of the work order operation that occurs during manufacturing inspection.
OperationCode String Abbreviation that identifies the operation for this item.
DispatchStatus String Status of the dispatch in the work order operation. A list of accepted values include Ready and Reject.
DocumentType String Type of document for the inspection event where inspection plan type is Receiving. Valid values include Purchase order, Transfer order, In-transit shipment, and Return material authorization. A list of accepted values is defined in the lookup type ORA_QA_IP_DOC_TYPES.
SupplierId String Value that uniquely identifies the supplier who supplies the material to inspect. This attribute is required where inspection plan type is Receiving and document type is Purchase order.
SupplierSiteId String Value that uniquely identifies the supplier site. This attribute is required where inspection plan type is Receiving and document type is Purchase order for the specified supplier. This is optional.
SourceOrganizationId String Value that uniquely identifies the organization that requested the item. This attribute is required where inspection plan type is Receiving and DocumentType is In-transit shipment or Transfer order.
SubinventoryCode String Abbreviation that identifies the subinventory. This attribute is required where inspection plan type is Inventory.
LocatorId String Value that uniquely identifies the locator within the subinventory. This attribute is required where InspectionPlanType is Inventory. This is optional.
EnabledFlag Bool Contains one of the following values: Yes or No. If Yes, then inspection criteria is enabled. If No, then inspection criteria is not enabled. The default value is Yes.
CreatedBy String User who created the inspection criteria record.
CreationDate Datetime Date when the user created the inspection criteria.
LastUpdatedBy String User who most recently updated the inspection criteria.
LastUpdateDate Datetime Date and time when the user most recently updated the inspection criteria.
SubinventoryId String Value that uniquely identifies the subinventory. This attribute is required where inspection plan type is Inventory.
Supplier String Name of the supplier. This attribute is required where inspection plan type is Receiving and document type is Purchase order.
ProcurementBUId String Value that uniquely identifies the procurement business unit.
ProcurementBUCode String Abbreviation that identifies the procurement business unit.
SupplierSite String Value that identifies the supplier site. This attribute is required where inspection plan type is Receiving, document type is Purchase order for the specified supplier. This is optional.
Locator String Value that identifies the locator within the subinventory. This attribute is required where inspection plan type is Inventory. This is optional.
SourceOrganization String Value that identifies the source organization. This attribute is required where inspection plan type is Receiving and DocumentType is In-transit shipment or Transfer order.

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