Oracle Fusion · Data dictionary
FOS_SOURCE_EVENT_DOC_INFO
SharedUsed in 1 subject areas21 reporting columns
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for FOS_SOURCE_EVENT_DOC_INFO, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CONSIGNED_FLAG | ● | Indicator (Y/N) for the consigned. | |
| DOCUMENT_DATE | ● | Document date. | |
| DOCUMENT_HEADER_ID | ● | Identifier for the document header. | |
| DOCUMENT_LINE_DETAIL_NUMBER | ● | Document line detail number. | |
| DOCUMENT_LINE_ID | ● | Identifier for the document line. | |
| DOCUMENT_LINE_NUMBER | ● | Document line number. | |
| DOCUMENT_NUMBER | ● | Document number. | |
| DOCUMENT_TYPE | ● | Type of document. | |
| DROPSHIP_FLAG | ● | Indicator (Y/N) for the dropship. | |
| ITEM_NUMBER | ● | Item number. | |
| LINK_TO_DOCUMENT_ID | ● | Identifier for the link to document. | |
| LINK_TO_DOCUMENT_TYPE | ● | Type of link to document. | |
| ORDERED_QUANTITY | ● | Ordered quantity. | |
| PRICE_CURRENCY_CODE | ● | Currency code for the price. | |
| REFERENCED_RMA_FLAG | ● | Indicator (Y/N) for the referenced rma. | |
| REF_DOCUMENT_ID | ● | Identifier for the reference document. | |
| REF_DOCUMENT_TYPE | ● | Type of reference document. | |
| REF_SALES_ORDER_LINE_NUMBER | ● | Reference sales order line number. | |
| REF_SALES_ORDER_NUMBER | ● | Reference sales order number. | |
| SOURCE_DOCUMENT_ID | ● | Identifier for the source document. | |
| UNIT_PRICE | ● | Unit price. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for FOS_SOURCE_EVENT_DOC_INFO?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table