FOS_EVENT_DOC_INFO
To invoke orchestration it is important to identify the agreement by evaluating qualifier rules. These qualifier rules require data from source document of the event. Source document information for the event is stored in this table.
Details
-
Schema: FUSION
-
Object owner: FOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
FOS_EVENT_DOC_INFO_PK |
EVENT_DOC_INFO_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EVENT_DOC_INFO_ID | NUMBER | 18 | Yes | This is the primary key and its value is an application generated unique id. It is used to identify a unique document across events. | |
PRJ_REF_ENABLED_FLAG | VARCHAR2 | 1 | A flag that indicates whether the project attributes need to be interfaced for this document or not. | ||
RECEIPT_REQUIRED_FLAG | VARCHAR2 | 1 | Y/N indicating Receipt is required for this transaction. Y will indicate that Receipt will be required. N will indicate that Receipt will not be required. This value will be populated only for Expense Destination IMT transfers. For all other types this value will be null. | ||
PROCUREMENT_BU_ID | NUMBER | 18 | The procurement business unit identifier. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
DOCUMENT_SOURCE_SYSTEM_ID | NUMBER | 18 | Yes | The identifier of the document source system. | |
SOURCE_DOCUMENT_ID | VARCHAR2 | 100 | Yes | Represents the event source document identifier. For example, in procurement it would store the PO_LINE_LOCATION_ID; for distributed order orchestration it would store the FULFILLMENT_LINE_DETAIL_ID; and for internal material transfers it would store the LINE_ID. | |
DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | 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. | |
DOCUMENT_HEADER_ID | VARCHAR2 | 100 | Context-based field representing the document header identifier. For global procurement it is the PO_HEADER_ID. For distributed order orchestration it is the HEADER_ID. | ||
DOCUMENT_NUMBER | VARCHAR2 | 100 | Field representing the document number that is visible to the end-user. This would include the purchase order number, the IMT transfer number, the sales order number, etc. | ||
DOCUMENT_DATE | DATE | The document date. This date is used to find the agreement. | |||
DOCUMENT_REVISION | NUMBER | The revision number of the document. | |||
DOCUMENT_LINE_ID | VARCHAR2 | 100 | Line in the document to which the event belongs. | ||
DOCUMENT_LINE_NUMBER | VARCHAR2 | 100 | Context-based field representing the document line number. For example, it may be the purchase order line number or the shipment line number. | ||
DOCUMENT_LINE_DETAIL_ID | VARCHAR2 | 100 | The shipment line in the line of the document to which the event belongs. | ||
DOCUMENT_LINE_DETAIL_NUMBER | VARCHAR2 | 100 | This field represents the document line detail number, which is one level above the document line number. For global procurement, the transaction happens at this level. | ||
FROM_LE_ID | NUMBER | 18 | Context-based field representing the from legal entity identifier. In procurement it is the sold to legal entity and for shipments it is the shipping legal entity. | ||
FROM_LE_CODE | VARCHAR2 | 100 | Context-based field representing the from legal entity code. In procurement it is the code of the sold to legal entity and for shipments it is the code of the shipping legal entity. | ||
FROM_BU_ID | NUMBER | 18 | Context-based field representing the from business unit identifier. In procurement it is the sold to business unit and in shipments it is the shipping business unit. | ||
TO_LE_ID | NUMBER | 18 | Context-based field representing the to legal entity identifier. In procurement it is the requisitioning legal entity and for shipments it is the selling legal entity. | ||
TO_LE_CODE | VARCHAR2 | 100 | Context-based field representing the to legal entity code. In procurement it is the code of the requisitioning legal entity and for shipments it is the code of the selling legal entity. | ||
TO_BU_ID | NUMBER | 18 | Context-based field representing the to business unit identifier. In procurement it is the requisitioning business unit and for shipments it is the selling business unit. | ||
SUPPLIER_NUMBER | VARCHAR2 | 360 | Context-based party site used for customer and supplier. | ||
SUPPLIER_SITE_CODE | VARCHAR2 | 240 | Context-based party site's code used for customer and supplier. | ||
SOLD_TO_CUSTOMER_NUMBER | VARCHAR2 | 30 | The number of the customer to whom the goods are sold. | ||
SHIP_TO_CUSTOMER_NUMBER | VARCHAR2 | 30 | The number of the customer to whom the goods are shipped. | ||
SOLD_TO_PARTY_NUMBER | VARCHAR2 | 30 | The number of the party to whom the goods are sold | ||
SOLD_TO_CUSTOMER_ACCNT_NUMBER | VARCHAR2 | 30 | The account number of the customer to whom the goods are sold | ||
SHIP_TO_PARTY_NUMBER | VARCHAR2 | 30 | The number of the party to whom the goods will be shipped | ||
SHIP_TO_PARTY_SITE_NUMBER | VARCHAR2 | 30 | The number of the party site to whom the goods will be shipped | ||
SHIP_TO_CUSTOMER_ACCNT_NUMBER | VARCHAR2 | 30 | The account number of the customer to whom the goods will be shipped | ||
SHIP_TO_LOCATION_CODE | VARCHAR2 | 30 | The code of the location to which the goods will be shipped | ||
BILL_TO_CUSTOMER_ACCNT_NUMBER | VARCHAR2 | 30 | The Account number of the customer for which billing will be made | ||
BILL_TO_LOCATION_CODE | VARCHAR2 | 30 | The code of the location for which billing will be done | ||
DELIVER_TO_PARTY_NUMBER | VARCHAR2 | 30 | The Number of the party to which goods will be delivered | ||
DELIVER_TO_PARTY_SITE_NUMBER | VARCHAR2 | 30 | The number of teh party site to which goods will be delivered | ||
CUSTOMER_SHIP_TO_LOCATION | VARCHAR2 | 150 | The site usage identifier of the customer where the goods are being shipped to. | ||
CUSTOMER_DELIVER_TO_LOCATION | VARCHAR2 | 150 | The site usage identifier of the customer where the goods are being delivered to. | ||
SHIP_FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | The identifier for the ship from inventory organization. | ||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | 18 | The identifier for the ship to inventory organization. | ||
LINK_TO_DOCUMENT_ID | VARCHAR2 | 100 | Represents the document identifier for which the event is linked. | ||
LINK_TO_DOCUMENT_TYPE | VARCHAR2 | 30 | Refers to the parent document type. | ||
LINK_TO_DOCUMENT_SYSTEM_ID | NUMBER | 18 | Refers to the parent document system identifier. | ||
REF_DOCUMENT_ID | VARCHAR2 | 100 | Used to store forward document iddetails for a referenced RMA | ||
REF_DOCUMENT_TYPE | VARCHAR2 | 30 | Used to store forward source document type for a referenced RMA | ||
REF_DOCUMENT_SYSTEM_ID | NUMBER | 18 | Used to store forward document system id for a referenced RMA | ||
LINE_TYPE | VARCHAR2 | 30 | Goods and expenses as defined in purchasing. | ||
ITEM_NUMBER | VARCHAR2 | 300 | The unique number for the item that is being transacted as part of the document. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Attribute indicating the unique identifier of the item. | ||
PURCHASING_CATEGORY | VARCHAR2 | 820 | The item category assigned to an item for purchasing. | ||
ORDERED_QUANTITY | NUMBER | The quantity ordered or break quantity for blanket purchase orders, RFQs and quotations. | |||
ORDERED_UOM | VARCHAR2 | 3 | The unit-of-measure defined in the source document. | ||
UNIT_PRICE | NUMBER | Price per unit of the item that is being transacted. | |||
PRICE_CURRENCY_CODE | VARCHAR2 | 15 | The currency code of the source document. | ||
DESTINATION_TYPE | VARCHAR2 | 30 | The final destination of the purchased items. | ||
REF_SALES_ORDER_NUMBER | VARCHAR2 | 100 | The sales order number captured from the order capture system and orchestrated through DOO. | ||
REF_SALES_ORDER_LINE_NUMBER | VARCHAR2 | 100 | The sales order line number captured from the order capture system and orchestrated through DOO. | ||
REF_SALES_ORDER_SYSTEM_CODE | VARCHAR2 | 100 | The system identifier of the order capture system and orchestrated through DOO. | ||
REFERENCED_RMA_FLAG | VARCHAR2 | 1 | Used to identify if the document is referenced RMA or not. For a procurement document this column will be null | ||
CATEGORY_CODE | VARCHAR2 | 30 | Used to differentiate Sales order document with RMA document | ||
DROPSHIP_FLAG | VARCHAR2 | 1 | Yes | A flag that indicates whether the shipment has a backing sales order line. | |
CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | A flag that indicates whether the source document is for consignment or not. | |
AGREEMENT_PTR_ID | NUMBER | 18 | This is a foreign key to the FOS_AGREEMENTS_PTR_F table. | ||
AGREEMENT_TYPE | VARCHAR2 | 30 | Represents the type of the agreement. Valid values are contained within the ORA_FOS_AGREEMENT_TYPE_FOR_VAL lookup type. | ||
STATUS | VARCHAR2 | 30 | Identifies the processing status for this record. Valid values are contained within the FOS_EVENT_DOC_STATUS lookup type. | ||
ENTERPRISE_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partioning. | |
ITEM_DESCRIPTION | VARCHAR2 | 240 | PO Item description which is used for description only orders. | ||
ORDERED_AMOUNT | NUMBER | Used to store source document amount from purchase order schedule. | |||
ORDERED_CURRENCY_CODE | VARCHAR2 | 15 | Used to store source document currency code from purchase header. | ||
DELIVERY_TRANSACTION_ID | VARCHAR2 | 30 | In case of drop ship, this column will be populated for a PO document and stores the corresponding delivery transaction id for that PO receipt. | ||
BASE_ITEM_NUMBER | VARCHAR2 | 300 | The Base model item of the configured item represented by item_number column. | ||
BASE_INVENTORY_ITEM_ID | NUMBER | 18 | Attribute indicating the unique identifier of the base model item. | ||
AUTO_CREATED_CONFIG_FLAG | VARCHAR2 | 1 | A flag that indicates whether the Configured Item is Auo Created or Pre-Configured. | ||
TRANSFER_ORDER_FLAG | VARCHAR2 | 1 | Flag that specifies if the internal transfer of goods is executed through a transfer order. | ||
ORDER_TYPE_CODE | VARCHAR2 | 30 | Code of the type of sales order that was placed. | ||
TRANSACTION_ORG_ID | NUMBER | 18 | Represents the organization id from which the event originated. | ||
PRICING_UOM_TYPE | VARCHAR2 | 30 | The flag indicates if the pricing UOM type is primary or secondary | ||
PRICING_UOM_VALUE | VARCHAR2 | 3 | This indicates the pricing unit of measure | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
fos_pricing_details | fos_event_doc_info | DOCUMENT_ID, DOCUMENT_TYPE, SOURCE_SYSTEM_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
FOS_EVENT_DOC_INFO_N1 | Non Unique | Default | LINK_TO_DOCUMENT_ID, LINK_TO_DOCUMENT_TYPE, LINK_TO_DOCUMENT_SYSTEM_ID | Obsolete |
FOS_EVENT_DOC_INFO_N2 | Non Unique | Default | LINK_TO_DOCUMENT_ID, LINK_TO_DOCUMENT_TYPE | |
FOS_EVENT_DOC_INFO_N3 | Non Unique | Default | DOCUMENT_NUMBER | |
FOS_EVENT_DOC_INFO_N4 | Non Unique | Default | UPPER("SOURCE_DOCUMENT_ID"), UPPER("DOCUMENT_TYPE"), DOCUMENT_SOURCE_SYSTEM_ID | |
FOS_EVENT_DOC_INFO_N5 | Non Unique | Default | UPPER("DOCUMENT_NUMBER") | |
FOS_EVENT_DOC_INFO_N6 | Non Unique | Default | UPPER("ITEM_NUMBER") | |
FOS_EVENT_DOC_INFO_PK | Unique | Default | EVENT_DOC_INFO_ID | |
FOS_EVENT_DOC_INFO_U1 | Unique | Default | DOCUMENT_SOURCE_SYSTEM_ID, SOURCE_DOCUMENT_ID, DOCUMENT_TYPE | Obsolete |
FOS_EVENT_DOC_INFO_U2 | Unique | Default | SOURCE_DOCUMENT_ID, DOCUMENT_TYPE, DOCUMENT_SOURCE_SYSTEM_ID |