I_SFIAtOpActyLatestSASAction

Latest SAS action performed on a SFI at an OA | view: IMPESFIOALTSTACT | TRAN | Extraction: Not supported | Component: Shop Floor Execution
Tables used: MPE_SFI_CONFIRM
Column Name Description
ShopFloorItem ID of Serialized Material
OpActyNtwkInstance Operation Activity Network: Instance ID
OpActyNtwkElement Internal OAN Element Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ShopFloorItemConfirmationType SFI Confirmation - Document Type Show values
Column Name Description Domain name
ShopFloorItemStatusChangeDoc SFI Confirmation - Document Number MPE_DOC_NMBR
StatusAndActionSchema Status and Action Schema MPE_OBJECT_NAME_TYPE
SASActionStartStatus Serial Number Status MPE_OBJECT_NAME_TYPE
SASActionEndStatus Serial Number Status MPE_OBJECT_NAME_TYPE
StatusAndActionSchemaAction Action of a Status and Action Schema MPE_ACTION_TYPE
ManufacturingActionReasonCode Code QCODE
MfgActionReasonCodeGroupCtlg Catalog QKATART
MfgActionReasonCodeGroup Code Group QCODEGRP
CreationDateTime UTC Time Stamp in Long Form TZNTSTMPL
CreatedByUserName Last Changed By USNAM
ShopFloorItemStatusEndDateTime UTC Time Stamp in Long Form TZNTSTMPL
SFIStatusDurationInSeconds Duration Based on Calendar Days
NetSFIStatusDurationInSeconds Duration Based on Operating Times of Work Center