JDBC Driver for Oracle SCM

Build 22.0.8462

InspectionEvents

The Inspection Events resource manages inspection results.

Columns

Name Type Description
CategoryId String Value that uniquely identifies the category of the item to inspect.
CategorySetId String Value that uniquely identifies the catalog of the item to inspect.
CustomerId String Value that uniquely identifies the customer returning the item to inspect.
DispatchStatus String Dispatch status of the work order operation for the inspected item.
DispositionDate Datetime Disposition date of the work order operation for the inspected item.
DocumentLineNumber Double Document line number of the receiving inspection event.
DocumentNumber String Document number of the receiving inspection event.
DocumentScheduleNumber String Document schedule number of the receiving inspection event.
DocumentType String Document type of the receiving inspection event.
Draft String Contains one of the following values: Y or N. If Y, then the transactions are not finished. If N, then transactions are finished. This attribute does not have a default value..
EventType String Abbreviation for the type of event. Valid values include WIP, RCV, INV, or RES.
Inline String Contains one of the following values: Y or N. If Y, then the application collects results as part of a receipt or work order, and the application requires the transaction identifiers. If N, then the application collects results independent of the receipt or work order, and the application does not require the transaction identifiers. This attribute does not have a default value.
InspectedBy String Person who performs the inspection.
InspectionDate Datetime Date and time when the inspection event occurred.
InspectionLevelId String Value that uniquely identifies the inspection level.
InspectionPlanId String Value that uniquely identifies the inspection plan.
InspectionStatus String Inspection status. Valid values include PENDING or COMPLETE.
InterfaceTransactionId String Value that uniquely identifies the interface transaction when inspecting a receipt. This attribute references the RCV_TRANSACTIONS_INTERFACE table.
InventoryItemId String Value that uniquely identifies the inventory item to inspect.
IpCriteriaId String Value that uniquely identifies the inspection criteria record.
IpEventId [KEY] String Value that uniquely identifies the inspection event.
LocatorId String Value that uniquely identifies the subinventory locator of the item to inspect in this event.
LotNumber String Lot number inspected in this event.
ObjectVersionNumber Int Number that identifies the object version. You can use this attribute to lock the object. The Inspection Events resource increments this value every time it updates the row. It compares this number at the start and end of the transaction to determine whether another session updated the same row during the inspection.
OperationSequenceNumber Long Sequence number of the work order operation to use during manufacturing inspection.
OrganizationId String Value that uniquely identifies the inventory organization.
OriginalDisposition String Original disposition of the items to inspect.
QuantityAccepted String Total quantity passing inspection in this event.
QuantityInspected String Total quantity inspected in this event.
QuantityRejected String Total quantity rejected in this event.
QuantityRequested String Requested inspection quantity received from the plant or from receiving.
ReceiptNumber String Receipt number that this inspection event inspects.
ResourceId String Identifies the resource to inspect.
RevisionId String Value that uniquely identifies the inspected item if revisions control the item.
SamplingQuantity String Quantity from the sampling plan to inspect.
ShipmentHeaderId String Value that uniquely identifies the shipment header of the item to inspect.
ShipmentLineId String Value that uniquely identifies the shipment line of the item to inspect.
SourceLineQuantity String Total quantity on the source line. It measures the receiving transaction quantity or the completion quantity of a manufacturing operation.
SourceOrgId String Value that uniquely identifies the source organization if the receiving transaction type is a transfer.
SubinventoryCode String Abbreviation that identifies the subinventory that stores the inspected item.
SupplierId String Value that uniquely identifies the supplier of the item to inspect.
SupplierLotNumber String Number that identifies the shipment lot.
SupplierSiteId String Value that uniquely identifies the supplier site.
TransactionType String Receiving transaction type.
UOMCode String Unit of measurement for the quantity of items to inspect in this event.
WoOperationId String Value that uniquely identifies the work order operation in a manufacturing inspection.
WorkAreaId String Value that uniquely identifies the work area for a resource inspection.
WorkCenterId String Value that uniquely identifies the work center for a resource inspection.
WorkOrderId String Value that uniquely identifies the work order for a manufacturing inspection.
OrganizationCode String Abbreviation that identifies the list of values for the organization.
WorkOrderNumber String Number that identifies the list of values for the work order.
ItemNumber String Number that identifies the item.
WIPInspectionPlanName String Name of the inspection plan for work in process.
ItemRevision String Revision of the item.
WoOperationCode String Abbreviation that identifies the work order operation.
SubinventoryId String Value that uniquely identifies the subinventory.
Locator String Value that uniquely identifies the locator.
INVInspectionPlanName String Name of the inventory inspection plan.
ResourceInspectionPlanName String Name of the resource inspection plan.
WorkCenterCode String Abbreviation that identifies the work center.
ResourceCode String Abbreviation that identifies the resource.
InspectionLevelName String Name of the inspection level.
IsSkiplotEnabled String Value that indicates whether the application uses skip lots.
SamplingRate String Rate of the sampling.
NumofLotsInspect Long Number of lots to inspect.
NumofLots Long Number of lots.
InspectionPlanType String Name of the type of inspection plan.
InspectionPlanVersion String Version of the inspection plan.
InspectionPlanVersionDescription String Description of the version of the inspection plan.
IsSamplingEnabled String Value that indicates whether the application uses sampling.
FromOrganizationId String Value that uniquely identifies the source organization.
ItemDescription String Description of the item.
VendorId String Value that uniquely identifies the supplier.
VendorSiteId String Value that uniquely identifies the supplier site.
SourceDocumentCode String Abbreviation that identifies the source document.
EventTypeLOV String List of values for the event type include INVENTORY, RESOURCE, WORK IN PROCESS, and RECEIVING. A list of accepted values is defined in the lookup type ORA_QA_IP_EVENT_TYPES.
InspectAllSamplesFlag Bool Contains one of the following values: true or false. If true, then all samples are created for inspection based on the document line quantity. If false, then the samples are created based on the sampling rate. This attribute does not have a default value.
SerialResultsEntryFlag Bool Contains one of the following values: true or false. If true, then serials are created for inspection. If false, then samples are created for inspection. This attribute does not have a default value.
SourceOrganizationCode String Abbreviation that identifies the source organization. This attribute is required when EventType is Receiving and DocumentType is In-transit shipment or Transfer order.
Supplier String Name of the supplier. This attribute is required when EventType is Receiving and DocumentType is Purchase order.
SupplierSite String Name of the supplier site. This attribute is required when EventType is Receiving, DocumentType is Purchase order for the specified supplier.
InspectionName String Name of the inspection event. This attribute is derived from the event source.
RCVInspectionPlanName String Name of the receiving inspection plan.
WoOperationName String Name of the work order operation associated with the inspection event.
AcceptanceNumber String Number that indicates the acceptance value associated with the sampling plan.
NonConformanceCount String Total number of non-conformities in an inspection event. This attribute is derived as one hundred times the number of nonconforming units divided by the total number of units of product.
RejectionNumber String Rejection number value based on the sampling plan.
SampleSizeCode String Code that identifies the sample size which is derived based on the lot size.
TotalSampleQuantity String Total amount of material required for testing in the inspection quantity unit of measure.
PreAssignedLotNumber String Number that identifies the preassigned lot inspected in the event. Use this attribute instead of the LotNumber attribute when a lot is preassigned to a work order operation.

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