ZX_PARTY_IMPORT_ERRORS_STG

This table stores error information.

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PARTY_IMPORT_ERROR_ID	NUMBER		18	Yes	Generated import error identifier associated with failure of the record.	Active
BATCH_NAME	VARCHAR2	30		Yes	Batch Name to identify the set of records to be processed.	Active
STG_TABLE_NAME	VARCHAR2	30		Yes	The staging table for which the error is flashed	Active
PARTY_ID	NUMBER		18		Party Name used to identify the party	Active
PARTY_NAME	VARCHAR2	240			Party Name used to identify the party	Active
PARTY_TYPE_CODE	VARCHAR2	30		Yes	Party type code associated with the record such as THIRD_PARTY,etc.	Active
TAX_REGIME_CODE	VARCHAR2	30			Tax regime code of the error record.	Active
TAX_STATUS_CODE	VARCHAR2	30			Tax status code of the error record.	Active
TAX	VARCHAR2	30			Stores the tax code of the error record.	Active
TAX_RATE_CODE	VARCHAR2	30			Tax rate code of the error record.	Active
CONTENT_OWNER_NAME	VARCHAR2	240			Content owner name of the error record.	Active
TAX_JURISDICTION_CODE	VARCHAR2	30			Tax jurisdiction code of the error record.	Active
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	80			Exemption certificate number of the error record.	Active
EFFECTIVE_FROM	DATE				Effective start date of the error record.	Active
REPORTING_TYPE_CODE	VARCHAR2	30			Reporting type code of the error record.	Active
REPORTING_CODE_CHAR_VALUE	VARCHAR2	60			Alphanumeric type reporting code of the error record.	Active
REPORTING_CODE_DATE_VALUE	DATE				Date type reporting code of the error record.	Active
REPORTING_CODE_NUM_VALUE	NUMBER				Numeric type reporting code of the error record.	Active
TAX_PAYER_NUMBER	VARCHAR2	50			Taxpayer number of the error record.	Active
MESSAGE_CAUSE	VARCHAR2	1000			Cause associated with the error condition.	Active
MESSAGE_USER_ACTION	VARCHAR2	1000			User action that can be performed for the error condition.	Active
MESSAGE_TEXT	VARCHAR2	1000		Yes	Message text to provide details about the error.	Active
LOAD_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.	Active
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZX_PARTY_IMPORT_ERRORS_STG_U1	Unique	FUSION_TS_TX_IDX	PARTY_IMPORT_ERROR_ID	Active