Source Event Document Information
The Source Event Document Information view object contains the document related data which is in source system format
Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosSourceEventDocInfoExtractPVO
Primary Keys : SourceEventDocInfoPEODocInfoLogId
Initial Extract Date : SourceEventDocInfoPEOCreationDate
Incremental Extract Date : SourceEventDocInfoPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| SourceEventDocInfoPEOAgreementPtrId | Value that uniquely identifies the primary route of financial orchestration flow. This is a foreign key to the Primary Routes view object. |
| SourceEventDocInfoPEOAutoCreatedConfigFlag | Value that indicates whether the configured Item is auto created or preconfigured. |
| SourceEventDocInfoPEOBaseInventoryItemId | Value that identifies the base item associated with the configured item that's being transacted as part of the document. |
| SourceEventDocInfoPEOBillToCustomerAccntNumber | Value that identifies the account number of the customer for which billing will be made. |
| SourceEventDocInfoPEOBillToLocationCode | Value that identifies the code of the location for which billing will be done. |
| SourceEventDocInfoPEOCategoryCode | Value that's used to differentiate the sales order document with RMA document. |
| SourceEventDocInfoPEOConsignedFlag | Value that indicates whether the source document is for consignment. |
| SourceEventDocInfoPEOCreatedBy | User who created the source event document information. |
| SourceEventDocInfoPEOCreationDate | Date when the source event document information was created. |
| SourceEventDocInfoPEOCustomerDeliverToLocation | Value that identifies the site usage identifier of the customer where the goods are being delivered. |
| SourceEventDocInfoPEOCustomerShipToLocation | Value that identifies the site usage identifier of the customer where the goods are being shipped. |
| SourceEventDocInfoPEODeliverToPartyNumber | Value that identifies the number of the party to which goods will be delivered. |
| SourceEventDocInfoPEODeliverToPartySiteNumber | Value that identifies the number of the party site to which goods will be delivered. |
| SourceEventDocInfoPEODestinationType | Value that identifies the final destination of the purchased items. |
| SourceEventDocInfoPEODocInfoLogId | Value that uniquely identifies the source event document Information. This is the primary key of the Source Event Document Information view object. |
| SourceEventDocInfoPEODocumentDate | Value that identifies the document date which is used to find the agreement. |
| SourceEventDocInfoPEODocumentHeaderId | Value that identifies the document header identifier. For global procurement it's the attribute PO_HEADER_ID. For distributed order orchestration, it's the HEADER_ID. |
| SourceEventDocInfoPEODocumentLineDetailId | Value that identifies the shipment line in the line of the document to which the event belongs. |
| SourceEventDocInfoPEODocumentLineDetailNumber | Value that identifies the document line detail number, which is one level above the document line number. For global procurement, the transaction happens at this level. |
| SourceEventDocInfoPEODocumentLineId | Value that identifies the line in the document to which the event belongs. |
| SourceEventDocInfoPEODocumentLineNumber | Value that identifies the document line number. For example, it may be the purchase order line number or the shipment line number. |
| SourceEventDocInfoPEODocumentNumber | Value that identifies the document number that's visible to the end user. This would include the purchase order number, the Transfer Order number, and the sales order number. |
| SourceEventDocInfoPEODocumentRevision | Value that identifies the revision number of the document. |
| SourceEventDocInfoPEODocumentSourceSystemCode | Value that identifies the document source system. |
| SourceEventDocInfoPEODocumentType | Value that identifies the type of the document to which this event belongs. Valid values are contained within the FOS_IMT_DOCUMENT_TYPES, FOS_PROCUREMENT_DOCUMENT_TYPES, and FOS_SHIPMENT_DOCUMENT_TYPES lookup types. |
| SourceEventDocInfoPEODropshipFlag | Value that indicates whether the shipment has a backing sales order line. |
| SourceEventDocInfoPEOEnterpriseId | Value that identifies the enterprise that's being used for multiple tenancy partitioning. |
| SourceEventDocInfoPEOFromBu | Value that identifies the from business unit identifier. In procurement it's sold to business unit and in shipments it's the shipping business unit. |
| SourceEventDocInfoPEOFromLe | Value that identifies the from legal entity identifier. In procurement it's the sold to legal entity and for shipments it's a shipping legal entity. |
| SourceEventDocInfoPEOInventoryItemId | Value that identifies the item that's being transacted as part of the document. |
| SourceEventDocInfoPEOItemDescription | Value that identifies the PO Item description which is used for description only orders. |
| SourceEventDocInfoPEOLastUpdateDate | Date when the source event document information was last updated. |
| SourceEventDocInfoPEOLastUpdateLogin | Session login associated with the user who last updated the source event document information. |
| SourceEventDocInfoPEOLastUpdatedBy | User who last updated the source event document information. |
| SourceEventDocInfoPEOLineType | Value that indicates if the goods and expenses are defined in purchasing. |
| SourceEventDocInfoPEOLinkToDocumentId | Value that identifies the document identifier to which the event is linked. |
| SourceEventDocInfoPEOLinkToDocumentSystemCode | Value that identifies the parent document system identifier. |
| SourceEventDocInfoPEOLinkToDocumentType | Value that identifies the parent document type. |
| SourceEventDocInfoPEOObjectVersionNumber | Value that identifies the number of times the source event document information row has been updated. |
| SourceEventDocInfoPEOOrderTypeCode | Value that identifies the code of the type of sales order that was placed. |
| SourceEventDocInfoPEOOrderedAmount | Value that identifies the source document amount from purchase order schedule. |
| SourceEventDocInfoPEOOrderedCurrencyCode | Value that identifies the source document currency code from purchase header. |
| SourceEventDocInfoPEOOrderedQuantity | Value that identifies the quantity ordered or break quantity for blanket purchase orders, RFQs, and quotations. |
| SourceEventDocInfoPEOOrderedUom | Value that identifies the unit of measure defined in the source document. |
| SourceEventDocInfoPEOPriceCurrencyCode | Value that identifies the currency code of the source document. |
| SourceEventDocInfoPEOPrjRefEnabledFlag | Value that indicates whether the project attributes need to be interfaced for this document. |
| SourceEventDocInfoPEOProcurementBuId | Value that identifies the procurement business unit identifier. |
| SourceEventDocInfoPEOPurchasingCategory | Value that identifies the item category assigned to an item for purchasing. |
| SourceEventDocInfoPEOReceiptRequiredFlag | Value that indicates if a receipt is required for this transaction. Y indicates that the receipt is required. N indicates that the receipt isn't required. This value will be populated only for expense destination internal material transfers. For all other types, this value is null. |
| SourceEventDocInfoPEORefDocumentId | Value that identifies the forward source document ID for a referenced RMA. |
| SourceEventDocInfoPEORefDocumentSystemCode | Value that identifies the forward source document system code for a referenced RMA |
| SourceEventDocInfoPEORefDocumentType | Value that identifies the forward source document type for a referenced RMA |
| SourceEventDocInfoPEORefSalesOrderLineNumber | Value that identifies the sales order line number captured from the order capture system and orchestrated through DOO. |
| SourceEventDocInfoPEORefSalesOrderNumber | Value that identifies the sales order number captured from the order capture system and orchestrated through DOO. |
| SourceEventDocInfoPEORefSalesOrderSystemCode | Value that identifies the system identifier of the order capture system and orchestrated through DOO. |
| SourceEventDocInfoPEOReferencedRmaFlag | Value that indicates if the RMA document is referenced or unreferenced. |
| SourceEventDocInfoPEOShipFromOrganizationCode | Value that identifies the ship from inventory organization. |
| SourceEventDocInfoPEOShipToCustomerAccntNumber | Value that identifies the account number of the customer to whom the goods will be shipped. |
| SourceEventDocInfoPEOShipToCustomerNumber | Value that identifies the number of the customer to whom the goods are shipped. |
| SourceEventDocInfoPEOShipToLocationCode | Value that identifies the code of the location to which the goods will be shipped. |
| SourceEventDocInfoPEOShipToOrganizationCode | Value that identifies the ship to inventory organization. |
| SourceEventDocInfoPEOShipToPartyNumber | Value that identifies the number of the party to whom the goods will be shipped. |
| SourceEventDocInfoPEOShipToPartySiteNumber | Value that identifies the number of the party site to whom the goods will be shipped. |
| SourceEventDocInfoPEOSoldToCustomerAccntNumber | Value that identifies the account number of the customer to whom the goods are sold. |
| SourceEventDocInfoPEOSoldToCustomerNumber | Value that identifies the number of the customer to whom the goods are sold. |
| SourceEventDocInfoPEOSoldToPartyNumber | Value that identifies the number of the party to whom the goods are sold. |
| SourceEventDocInfoPEOSourceDocumentId | Value that identifies the event source document identifier. For example, in procurement it stores the PO_LINE_LOCATION_ID, for distributed order orchestration it would store the FULFILLMENT_LINE_DETAIL_ID, and for internal material transfer it would store the LINE_ID. |
| SourceEventDocInfoPEOStatus | Value that identifies the processing status for this record. Valid values are contained within the FOS_SOURCE_EVENT_DOC_STATUS lookup type. |
| SourceEventDocInfoPEOSupplierNumber | Value that identifies the party site used for the supplier. |
| SourceEventDocInfoPEOSupplierSiteCode | Value that identifies the party site code used for the supplier. |
| SourceEventDocInfoPEOToBu | Value that identifies the to business unit identifier. In procurement it's the requisitioning business unit and for shipments it's selling business unit. |
| SourceEventDocInfoPEOToLe | Value that identifies the to legal entity identifier. For procurement flows it's the requisitioning legal entity and for shipments it's the selling legal entity. |
| SourceEventDocInfoPEOTransferOrderFlag | Value that indicates if the internal transfer of goods is executed through a transfer order. |
| SourceEventDocInfoPEOUnitPrice | Value that identifies the price per unit of the item that's transacted. |