AP_DOCIO_STREAM_DETAILS
This table contains the summary and status information for all Payables documents ingested through various channels including both Doc IO and non-Doc IO processes.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STREAM_DETAIL_ID | NUMBER | 18 | Yes | Unique identifier of the document. | |
| STREAM_DEFINITION_CODE | VARCHAR2 | 30 | Internal lookup code for the stream display name for both predefined and user-extended streams. Values mapped to the Stream Categories lookup. | ||
| INCOMING_DOCUMENT_ID | NUMBER | 18 | Identifier for the document ingested in Document IO. | ||
| LOGICAL_DOCUMENT_ID | NUMBER | 18 | Identifier for the document transformed in Document IO. | ||
| DOCIO_FLOW_CODE | VARCHAR2 | 240 | Flow code for the ingested document. | ||
| DOCUMENT_NAME | VARCHAR2 | 1000 | The name of the ingested document. | ||
| FILE_TYPE_CODE | VARCHAR2 | 30 | The type of the ingested document. | ||
| SOURCE | VARCHAR2 | 50 | Sender of the document ingested in Document IO. | ||
| INGESTION_SOURCE | VARCHAR2 | 50 | Ingestion channel of the document. | ||
| TOTAL_RECORDS | NUMBER | 18 | Total number of transactions in a document. | ||
| STATUS_CODE | VARCHAR2 | 30 | Stores the current processing status in the document’s lifecycle. | ||
| STATUS_DETAILS | VARCHAR2 | 1000 | Details of error captured during document processing. | ||
| TRAINING_MODE_FLAG | VARCHAR2 | 1 | Indicates whether the document is uploaded for training the model or standard execution. | ||
| PARTY_NAME | VARCHAR2 | 360 | An entity that can enter into business relationships with other entities and submit invoices or other requests for payment. In some cases, goods or services or both are provided in return for payment. | ||
| PARTY_TYPE_CODE | VARCHAR2 | 30 | Categorizes the type of party involved in business transactions. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency of transaction belonging to the document. | ||
| MULTIPLE_CURRENCY_FLAG | VARCHAR2 | 1 | Flag to indicate if document has multiple currency transactions. | ||
| AMOUNT | NUMBER | Total amount of the invoices in a document. | |||
| ORG_ID_LIST | CLOB | Business Unit Identifier for the invoices in the document. To contain comma separated value for distinct BUs in a document. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. | |
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 1000 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| REFERENCE1 | VARCHAR2 | 4000 | General text reference for telemetry purpose. | ||
| REFERENCE2 | VARCHAR2 | 4000 | General text reference for telemetry purpose. | ||
| REFERENCE3 | VARCHAR2 | 4000 | General text reference for telemetry purpose. | ||
| REFERENCE4 | VARCHAR2 | 4000 | General text reference for telemetry purpose. | ||
| REFERENCE5 | VARCHAR2 | 4000 | General text reference for telemetry purpose. | ||
| REFERENCE6 | VARCHAR2 | 150 | General text reference for telemetry purpose. | ||
| REFERENCE7 | VARCHAR2 | 150 | General text reference for telemetry purpose. | ||
| REFERENCE8 | VARCHAR2 | 150 | General text reference for telemetry purpose. | ||
| REFERENCE9 | VARCHAR2 | 150 | General text reference for telemetry purpose. | ||
| REFERENCE10 | VARCHAR2 | 150 | General text reference for telemetry purpose. | ||
| REFERENCE11 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE12 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE13 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE14 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE15 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE16 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE17 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE18 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE19 | NUMBER | General numeric reference for telemetry purpose. | |||
| REFERENCE20 | NUMBER | General numeric reference for telemetry purpose. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_DOCIO_STREAM_DETAILS_N1 | Non Unique | Default | CREATION_DATE |
| AP_DOCIO_STREAM_DETAILS_N2 | Non Unique | Default | DOCUMENT_NAME, CREATION_DATE |
| AP_DOCIO_STREAM_DETAILS_N3 | Non Unique | Default | PARTY_NAME, CREATION_DATE |
| AP_DOCIO_STREAM_DETAILS_N4 | Non Unique | Default | STATUS_CODE, CREATION_DATE |
| AP_DOCIO_STREAM_DETAILS_N5 | Non Unique | Default | INCOMING_DOCUMENT_ID |
| AP_DOCIO_STREAM_DETAILS_N6 | Non Unique | Default | LOGICAL_DOCUMENT_ID |
| AP_DOCIO_STREAM_DETAILS_N7 | Non Unique | Default | STREAM_DEFINITION_CODE |
| AP_DOCIO_STREAM_DETAILS_U1 | Unique | Default | STREAM_DETAIL_ID |