CSE_INTG_DOCS_DEBUG

The transaction document references passes on to the capture api are persisted here for debugging purposes.

Details

• Schema: FUSION

• Object owner: CSE

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CSE_INTG_DOCS_DEBUG_PK	DEBUG_DOCS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DEBUG_DOCS_ID	NUMBER		18	Yes	The unique primary key for this table. Auto generated.
DEBUG_TXN_ID	NUMBER		18		The foreign key that links the documents to the transaction for which these documents are processed.
SRC_DOC_TYPE_CODE	VARCHAR2	30			The type of document. Eg. Purchase Order, Sales Order etc.
SRC_DOC_REF	VARCHAR2	80			The user surrogate key for the document.
SRC_DOC_ID	NUMBER				The system surrogate key for the document.
SRC_DOC_LINE_REF	VARCHAR2	80			The user surrogate key for the document line.
SRC_DOC_LINE_ID	NUMBER				The system surrogate key for the document line.
SRC_DOC_SUB_LINE_REF	VARCHAR2	80			The user surrogate key for the document sub line.
SRC_DOC_SUB_LINE_ID	NUMBER				The system surrogate key for the document sub line.
SELF_INDEX	NUMBER				The asset index that identifies this document to the asset.
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
CSE_INTG_DOCS_DEBUG_U1	Unique	Default	DEBUG_DOCS_ID