1. Tables and Views for SCM
  2. FOS_SOURCE_EVENT_DOC_INFO

FOS_SOURCE_EVENT_DOC_INFO

This table holds the document related data which is in source system format

Details

  • Schema: FUSION

  • Object owner: FOS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FOS_SOURCE_EVENT_DOC_INFO_PK

DOC_INFO_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
DOC_INFO_LOG_ID NUMBER 18 Yes This is the primary key and its value is an application generated unique id.
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.
PRJ_REF_ENABLED_FLAG VARCHAR2 1 A flag that indicates whether the project attributes need to be interfaced for this document or not.
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_CODE VARCHAR2 100 Yes Identifier for 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 50 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 VARCHAR2 100 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_BU VARCHAR2 100 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 VARCHAR2 100 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_BU VARCHAR2 100 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.
PROCUREMENT_BU_ID NUMBER 18 The procurement business unit identifier.
SUPPLIER_NUMBER VARCHAR2 360 Context-based party site used for the supplier.
SUPPLIER_SITE_CODE VARCHAR2 240 Context-based party site's code used for the 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.
CUSTOMER_DELIVER_TO_LOCATION VARCHAR2 150 The site usage identifier of the customer where the goods are being delivered.
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 to which the event is linked.
LINK_TO_DOCUMENT_TYPE VARCHAR2 30 Refers to the parent document type.
LINK_TO_DOCUMENT_SYSTEM_CODE VARCHAR2 100 Refers to the parent document system identifier.
REF_DOCUMENT_SYSTEM_CODE VARCHAR2 100 Captures forward source document system code for a refrenced RMA
REF_DOCUMENT_ID VARCHAR2 100 Captures forward source document id for a refrenced RMA
REF_DOCUMENT_TYPE VARCHAR2 30 Captures forward source document type for a refrenced 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.
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.
REFERENCED_RMA_FLAG VARCHAR2 1 Used to identify if RMA document is referenced or unreferenced
STATUS VARCHAR2 30 Identifies the processing status for this record. Valid values are contained within the FOS_SOURCE_EVENT_DOC_STATUS lookup type.
ENTERPRISE_ID NUMBER 18 Yes Identifier of Enterprise, used for multi-tenancy partitioning.
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.
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.
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.

Indexes

Index Uniqueness Tablespace Columns Status
FOS_SOURCE_EVENT_DOC_INFO_U1 Unique Default DOC_INFO_LOG_ID
FOS_SRC_EVNT_DOC_INFO_N1 Non Unique Default LINK_TO_DOCUMENT_ID, LINK_TO_DOCUMENT_TYPE, LINK_TO_DOCUMENT_SYSTEM_CODE
FOS_SRC_EVNT_DOC_INFO_N2 Non Unique Default DOCUMENT_NUMBER
FOS_SRC_EVNT_DOC_INFO_N3 Non Unique Default UPPER("DOCUMENT_NUMBER")
FOS_SRC_EVNT_DOC_INFO_N4 Non Unique Default UPPER("ITEM_NUMBER")
FOS_SRC_EVNT_DOC_INFO_U1 Unique Default DOCUMENT_SOURCE_SYSTEM_CODE, SOURCE_DOCUMENT_ID, DOCUMENT_TYPE Obsolete
FOS_SRC_EVNT_DOC_INFO_U2 Unique Default LINK_TO_DOCUMENT_ID, LINK_TO_DOCUMENT_TYPE, LINK_TO_DOCUMENT_SYSTEM_CODE Obsolete
FOS_SRC_EVNT_DOC_INFO_U3 Unique Default SOURCE_DOCUMENT_ID, DOCUMENT_TYPE, DOCUMENT_SOURCE_SYSTEM_CODE