Inspection Events
The Inspection Events resource consolidates common information for the inspection such as inventory organization, event type, item, subinventory, quantity, and inspection status.
Data Store Key : FscmTopModelAM.ScmExtractAM.QaBiccExtractAM.QaIpEventsExtractPVO
Primary Keys : QaIpEventsPEOIpEventId
Initial Extract Date : QaIpEventsPEOCreationDate
Incremental Extract Date : QaIpEventsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| QaIpEventsPEOAcceptanceNumber | Acceptance number derived based on the sample size code and associated acceptable quality limits. |
| QaIpEventsPEOAssetId | Value that uniquely identifies the asset number to inspect if inspection type is Asset. |
| QaIpEventsPEOCategoryId | Value that uniquely identifies the category of the item to inspect. |
| QaIpEventsPEOCategorySetId | Value that uniquely identifies the catalog of the item to inspect. |
| QaIpEventsPEOCreatedBy | User who created the inspection event. |
| QaIpEventsPEOCreationDate | Date and time when the inspection event was created. |
| QaIpEventsPEOCustomerId | Value that uniquely identifies the customer returning the item to inspect. |
| QaIpEventsPEODispatchStatus | Dispatch status of the work order operation for the inspected item. |
| QaIpEventsPEODispositionDate | Disposition date of the work order operation for the inspected item. |
| QaIpEventsPEODocLineNumber | Document line number of the receiving inspection event. |
| QaIpEventsPEODocNumber | Document number of the receiving inspection event. |
| QaIpEventsPEODocScheduleNumber | Document schedule number of the receiving inspection event. |
| QaIpEventsPEODocType | Document type of the receiving inspection event. A list of accepted values is defined in the lookup type RCV_SOURCE_DOCUMENT_TYPE. It can have 4 possible values: Purchase order, Transfer order, In-transit shipment, and Return material authorization. This attribute doesn't have a default value. |
| QaIpEventsPEODraftFlag | Contains one of the following values: Y or N. If Y, then the transactions aren't finished. If N, then transactions are finished. This attribute doesn't have a default value. |
| QaIpEventsPEOEventType | Type of the event. A list of accepted values is defined in the lookup type ORA_QA_IP_EVENT_TYPES.It can have four possible values: WIP, RCV, INV and RES. |
| QaIpEventsPEOInlineFlag | 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 doesn't require the transaction identifiers. This attribute doesn't have a default value. |
| QaIpEventsPEOInspectedBy | User who does the inspection. |
| QaIpEventsPEOInspectionDate | Date and time when the inspection event occurred. |
| QaIpEventsPEOInspectionLevelId | Value that uniquely identifies the inspection level. |
| QaIpEventsPEOInspectionPlanId | Value that uniquely identifies the inspection plan. |
| QaIpEventsPEOInspectionStatus | Inspection status. A list of accepted values is defined in the lookup type ORA_QA_IP_DISPOSITIONS. It can have two possible values: Completed and Pending. This attribute doesn't have a default value. |
| QaIpEventsPEOInterfaceTransactionId | Value that uniquely identifies the interface transaction when inspecting a receipt. This attribute references the RCV_TRANSACTIONS_INTERFACE table. |
| QaIpEventsPEOInventoryItemId | Value that uniquely identifies the inventory item to inspect. |
| QaIpEventsPEOIpCriteriaId | Value that uniquely identifies the inspection criteria record. |
| QaIpEventsPEOIpEventId | Value that uniquely identifies the inspection event. |
| QaIpEventsPEOItemRevision | Value that identifies the version of the item for which the inspection is conducted. |
| QaIpEventsPEOLastUpdateDate | Date and time when the user last updated the inspection event. |
| QaIpEventsPEOLastUpdateLogin | Session login associated with the user who last updated the inspection event. |
| QaIpEventsPEOLastUpdatedBy | User who last updated the inspection event. |
| QaIpEventsPEOLocatorId | Value that uniquely identifies the subinventory locator of the item to inspect in this event. |
| QaIpEventsPEOLotNumber | Lot number inspected in this event. |
| QaIpEventsPEONonConformanceCount | Nonconformance number calculated based on sample inspection that determines lot acceptance. |
| QaIpEventsPEOOperationSeqNumber | Sequence number of the work order operation to use during manufacturing inspection. |
| QaIpEventsPEOOrganizationId | Value that uniquely identifies the inventory organization. |
| QaIpEventsPEOOriginalDisposition | Original disposition of the items to inspect. A list of accepted values is defined in the lookup type ORA_QA_IP_DISPOSITIONS. It can have 5 possible values: Accepted, Completed, In Progress, Pending, and Rejected. This attribute doesn't have a default value. |
| QaIpEventsPEOQtyAccepted | Total accepted quantity in this event. |
| QaIpEventsPEOQtyInspected | Total quantity inspected in this event. |
| QaIpEventsPEOQtyRejected | Total quantity rejected in this event. |
| QaIpEventsPEOQtyRequested | Requested inspection quantity received from the plant or from receiving. |
| QaIpEventsPEOReceiptNum | Receipt number that this inspection event inspects. |
| QaIpEventsPEORejectionNumber | Rejection number derived based on the sample size code and associated acceptable quality limits. |
| QaIpEventsPEOResourceId | Value that uniquely identifies the resource to inspect. |
| QaIpEventsPEORevisionId | Value that uniquely identifies the inspected item, if revisions control the item. |
| QaIpEventsPEOSampleSizeCode | Code that identifies the sample size which is derived based on the lot size. |
| QaIpEventsPEOSamplingQty | Quantity from the sampling plan to inspect. |
| QaIpEventsPEOShipmentHeaderId | Value that uniquely identifies the shipment header of the item to inspect. |
| QaIpEventsPEOShipmentLineId | Value that uniquely identifies the shipment line of the item to inspect. |
| QaIpEventsPEOSourceLineQty | Total quantity on the source line. It measures the receiving transaction quantity or the completion quantity of a manufacturing operation. |
| QaIpEventsPEOSourceOrgId | Value that uniquely identifies the source organization when the receiving transaction type is a transfer. |
| QaIpEventsPEOSubinventoryCode | Code that identifies the subinventory that stores the inspected item. |
| QaIpEventsPEOSupplierId | Value that uniquely identifies the supplier of the item to inspect. |
| QaIpEventsPEOSupplierLotNum | Number that identifies the shipment lot. |
| QaIpEventsPEOSupplierSiteId | Value that uniquely identifies the supplier site. |
| QaIpEventsPEOTotalSampleQuantity | Total quantity of material required for testing in the inspection quantity unit of measure. |
| QaIpEventsPEOTransactionType | Receiving transaction type. A list of accepted values is defined in the lookup type RCV_INSPECTION_STATUS. It can have three possible values: Accepted, Not inspected and Rejected. This attribute doesn't have a default value. |
| QaIpEventsPEOUomCode | Code that identifies the unit of measurement for the quantity of items to inspect in this event. |
| QaIpEventsPEOWoOperationId | Value that uniquely identifies the work order operation in a manufacturing inspection. |
| QaIpEventsPEOWorkAreaId | Value that uniquely identifies the work area for a resource inspection. |
| QaIpEventsPEOWorkCenterId | Value that uniquely identifies the work center for a resource inspection. |
| QaIpEventsPEOWorkOrderId | Value that uniquely identifies the work order for a manufacturing inspection. |