Event Document Information
The Event Document Information view object stores Source document information for the event. To initiate the orchestration it's important to identify the agreement by evaluating qualifier rules. These qualifier rules require data from source document of the event.
Data Store Key : FscmTopModelAM.ScmExtractAM.FosBiccExtractAM.FosEventDocInfoExtractPVO
Primary Keys : FosEventDocInfoPEOEventDocInfoId
Initial Extract Date : FosEventDocInfoPEOCreationDate
Incremental Extract Date : FosEventDocInfoPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| FosEventDocInfoPEOAgreementPtrId | Value that uniquely identifies the primary route of financial orchestration flow. This is a foreign key to the Primary Routes view object. |
| FosEventDocInfoPEOAgreementType | Value that identifies the type of agreement. Valid values are contained within the ORA_FOS_AGREEMENT_TYPE_FOR_VAL lookup type. |
| FosEventDocInfoPEOAutoCreatedConfigFlag | Value that indicates whether the configured item is auto created. |
| FosEventDocInfoPEOBaseInventoryItemId | Value that identifies the base item associated with the configured item that's being transacted as part of the document. |
| FosEventDocInfoPEOBillToCustomerAccntNumber | Value that identifies the account number of the customer for which billing will be made |
| FosEventDocInfoPEOBillToLocationCode | Value that identifies the code of the billing location. |
| FosEventDocInfoPEOCategoryCode | Value that differentiates the sales order document from the RMA document. |
| FosEventDocInfoPEOConsignedFlag | Value that indicates if the source document is for consignment. |
| FosEventDocInfoPEOCreatedBy | User who created the event document information. |
| FosEventDocInfoPEOCreationDate | Date when the event document information was created. |
| FosEventDocInfoPEOCustomerDeliverToLocation | Value that identifies the site usage identifier of the customer where the goods are being delivered. |
| FosEventDocInfoPEOCustomerShipToLocation | Value that identifies the site usage identifier of the customer where the goods are being shipped. |
| FosEventDocInfoPEODeliverToPartyNumber | Value that identifies the party to which goods will be delivered. |
| FosEventDocInfoPEODeliverToPartySiteNumber | Value that identifies the party site to which goods will be delivered. |
| FosEventDocInfoPEODeliveryTransactionId | Value that identifies the corresponding delivery transaction ID for that PO receipt for a drop ship. |
| FosEventDocInfoPEODestinationType | Value that identifies the final destination of the purchased items. |
| FosEventDocInfoPEODocumentDate | Value that identifies the document date. This date is used to find the agreement. |
| FosEventDocInfoPEODocumentHeaderId | Value that identifies the document header identifier. For global procurement it's the PO_HEADER_ID. For distributed order orchestration it's the HEADER_ID. |
| FosEventDocInfoPEODocumentLineDetailId | Value that identifies the shipment line in the line of the document to which the event belongs. |
| FosEventDocInfoPEODocumentLineDetailNumber | 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. |
| FosEventDocInfoPEODocumentLineId | Value that identifies the line in the document to which the event belongs. |
| FosEventDocInfoPEODocumentLineNumber | Value is context-based field representing the document line number. For example, it may be the purchase order line number or the shipment line number. |
| FosEventDocInfoPEODocumentNumber | Value that identifies the document number that's visible to the end-user. This would include the purchase order number, the IMT transfer number, the sales order number, and so on. |
| FosEventDocInfoPEODocumentRevision | Value that identifies the revision number of the document. |
| FosEventDocInfoPEODocumentSourceSystemId | Value that identifies the document source system. |
| FosEventDocInfoPEODocumentType | 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. |
| FosEventDocInfoPEODropshipFlag | Value that indicates whether the shipment has a backing sales order line. |
| FosEventDocInfoPEOEnterpriseId | Value that identifies the enterprise that's used for multiple tenancy partition. |
| FosEventDocInfoPEOEventDocInfoId | Value that uniquely identifies the event document information. This is the primary key of the Event Document Information view object. |
| FosEventDocInfoPEOFromBuId | Value that identifies the from business unit identifier. In procurement it's the sold to business unit and in shipments it's the shipping business unit. |
| FosEventDocInfoPEOFromLeCode | Value that identifies the from legal entity code. In procurement it's the code of the sold to legal entity and for shipments it's the code of the shipping legal entity. |
| FosEventDocInfoPEOFromLeId | Value that identifies the from legal entity identifier. In procurement it's the sold to legal entity and for shipments it's the shipping legal entity. |
| FosEventDocInfoPEOInventoryItemId | Value that identifies the item that's being transacted as part of the document. |
| FosEventDocInfoPEOItemDescription | Value that identifies the PO Item description that's used for description only orders. |
| FosEventDocInfoPEOLastUpdateDate | Date when the event document information was last updated. |
| FosEventDocInfoPEOLastUpdateLogin | Session login associated with the user who last updated the event document information. |
| FosEventDocInfoPEOLastUpdatedBy | User who last updated the event document information. |
| FosEventDocInfoPEOLineType | Value that identifies the goods and expenses as defined in purchasing. |
| FosEventDocInfoPEOLinkToDocumentId | Value that identifies the document identifier for which the event is linked. |
| FosEventDocInfoPEOLinkToDocumentSystemId | Value that identifies the parent document system identifier. |
| FosEventDocInfoPEOLinkToDocumentType | Value that identifies the parent document type. |
| FosEventDocInfoPEOObjectVersionNumber | Value that identifies the number of times the event document information row has been updated. |
| FosEventDocInfoPEOOrderTypeCode | Value that identifies the type of sales order that was placed. |
| FosEventDocInfoPEOOrderedAmount | Value that identifies the source document amount from purchase order schedule. |
| FosEventDocInfoPEOOrderedCurrencyCode | Value that identifies the source document currency code from purchase header. |
| FosEventDocInfoPEOOrderedQuantity | Value that identifies the quantity ordered or break quantity for blanket purchase orders, RFQs and quotations. |
| FosEventDocInfoPEOOrderedUom | Value that identifies the unit of measure defined in the source document. |
| FosEventDocInfoPEOPriceCurrencyCode | Value that identifies the currency code of the source document. |
| FosEventDocInfoPEOPricingUomType | Value that indicates if the pricing UOM type is primary or secondary. |
| FosEventDocInfoPEOPricingUomValue | Value that identifies the pricing unit of measure. |
| FosEventDocInfoPEOPrjRefEnabledFlag | Value that indicates whether the project attributes need to be interfaced for this document. |
| FosEventDocInfoPEOProcurementBuId | Value that identifies the procurement business unit identifier. |
| FosEventDocInfoPEOPurchasingCategory | Value that identifies the item category assigned to an item for purchasing. |
| FosEventDocInfoPEOReceiptRequiredFlag | Contains one of the following values: Y or N. If Y, then the receipt will be required. If N, then the receipt won't be required. This value will be populated only for expense destination IMT transfers. For all other types, this value will be null. |
| FosEventDocInfoPEORefDocumentId | Value that identifies the forward document details for a referenced RMA |
| FosEventDocInfoPEORefDocumentSystemId | Value that identifies the forward document system ID for a referenced RMA. |
| FosEventDocInfoPEORefDocumentType | Value that identifies the forward source document type for a referenced RMA. |
| FosEventDocInfoPEORefSalesOrderLineNumber | Value that identifies the sales order line number captured from the order capture system and orchestrated through DOO. |
| FosEventDocInfoPEORefSalesOrderNumber | Value that identifies the sales order number captured from the order capture system and orchestrated through DOO. |
| FosEventDocInfoPEORefSalesOrderSystemCode | Value that identifies the system identifier of the order capture system and is orchestrated through DOO. |
| FosEventDocInfoPEOReferencedRmaFlag | Value that indicates if the document is referenced RMA. For a procurement document this column will be null. |
| FosEventDocInfoPEOShipFromOrganizationCode | Value that's used as an identifier for the ship from inventory organization. |
| FosEventDocInfoPEOShipToCustomerAccntNumber | Value that identifies the account number of the customer to whom the goods will be shipped. |
| FosEventDocInfoPEOShipToCustomerNumber | Value that identifies the number of the customer to whom the goods are shipped. |
| FosEventDocInfoPEOShipToLocationCode | Value that identifies the code of the location to which the goods will be shipped. |
| FosEventDocInfoPEOShipToOrganizationCode | Value that identifies the ship to inventory organization. |
| FosEventDocInfoPEOShipToPartyNumber | Value that identifies the number of the party to whom the goods will be shipped. |
| FosEventDocInfoPEOShipToPartySiteNumber | Value that identifies the number of the party site to whom the goods will be shipped. |
| FosEventDocInfoPEOSoldToCustomerAccntNumber | Value that identifies the account number of the customer to whom the goods are sold. |
| FosEventDocInfoPEOSoldToCustomerNumber | Value that identifies the number of the customer to whom the goods are sold. |
| FosEventDocInfoPEOSoldToPartyNumber | Value that identifies the number of the party to whom the goods are sold. |
| FosEventDocInfoPEOSourceDocumentId | Value that identifies the event source document identifier. For example, in procurement it stores the PO_LINE_LOCATION_ID, for distributed order orchestration it stores the FULFILLMENT_LINE_DETAIL_ID, and for internal material transfers it stores the LINE_ID. |
| FosEventDocInfoPEOStatus | Value that identifies the processing status for this record. Valid values are contained within the FOS_EVENT_DOC_STATUS lookup type. |
| FosEventDocInfoPEOSupplierNumber | Value that identifies the party site used for customer and supplier. |
| FosEventDocInfoPEOSupplierSiteCode | Value that identifies the party site's code used for the customer and supplier. |
| FosEventDocInfoPEOToBuId | Value that identifies the to business unit identifier. In procurement it's the requisitioning business unit and for shipments it's the selling business unit. |
| FosEventDocInfoPEOToLeCode | Value that identifies the legal entity code. For procurement flows, it's the code of the requisitioning legal entity and for shipments, it's the code of the selling legal entity. |
| FosEventDocInfoPEOToLeId | Value that identifies the legal entity identifier. For procurement it's the requisitioning legal entity and for shipments it's the selling legal entity. |
| FosEventDocInfoPEOTransactionOrgId | Value that identifies the organization ID from which the event originated. |
| FosEventDocInfoPEOTransferOrderFlag | Value that indicates if the internal transfer of goods is executed through a transfer order. |
| FosEventDocInfoPEOUnitPrice | Value that identifies the price per unit of the item that's being transacted. |