ZX_REPORT_CODES_ASSOC_STG

This table stores reporting codes association details that need to be imported into reporting codes association table.

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

• Tablespace: INTERFACE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
BATCH_NAME	VARCHAR2	30		Yes	Batch Name to identify the set of records to be processed.	Active
REPORTING_TYPE_CODE	VARCHAR2	30			Reporting type code associated with the record.	Active
REPORTING_CODE_CHAR_VALUE	VARCHAR2	60			Alphanumeric value for the reporting code	Active
REPORTING_CODE_DATE_VALUE	DATE				Date value for the reporting code	Active
REPORTING_CODE_NUM_VALUE	NUMBER				Numeric value for the reporting code	Active
PARTY_NUMBER	VARCHAR2	240		Yes	Party number used to identify the party	Active
PARTY_NAME	VARCHAR2	240			Party name used to identify the party	Active
PARTY_TYPE_CODE	VARCHAR2	30		Yes	Lookup code to indicate the party type for this party tax profile.	Active
ENTITY_CODE	VARCHAR2	30		Yes	Lookup code to identify the entity with which the reporting code is associated.	Active
EFFECTIVE_FROM	DATE			Yes	Date from which the tax reporting code association record is effective.	Active
EFFECTIVE_TO	DATE				Date until which the tax reporting code association record is effective.	Active
RECORD_STATUS	NUMBER				Gives the validation status of the record being processed: NULL - only these records will be picked up for processing by program 0 - record picked up by concurrent program for validation 1 -all id???s validated 2 - successful record 3 - error record	Active
LOAD_REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.	Active
LOAD_STATUS	VARCHAR2	30			Enterprise Service Scheduler: indicates the request status of the interface load job that created the row.	Active
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_REPORT_CODES_ASSOC_STG_N1	Non Unique	FUSION_TS_TX_IDX	PARTY_NAME, PARTY_TYPE_CODE, PARTY_NUMBER	Active