ZX_PARTY_TAXPAYER_STG

This table stores taxpayer details that need to be imported into taxpayer 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
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	Party type code associated with the record such as THIRD_PARTY,etc.	Active
TAX_PAYER_NUMBER	VARCHAR2	50			An unique reference number which is used to identify??entities??for tax-related purpose.	Active
COUNTRY_CODE	VARCHAR2	2			Country code for which the taxpayer id is registered.	Active
EFFECTIVE_FROM	DATE			Yes	Date from which the taxpayer record is effective.	Active
EFFECTIVE_TO	DATE				Date until which the taxpayer record is effective.	Active
REPORTING_TYPE_CODE	VARCHAR2	30			Reporting type code associated with the record.	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_PARTY_TAXPAYER_STG_N1	Non Unique	FUSION_TS_TX_IDX	PARTY_NAME, PARTY_TYPE_CODE, PARTY_NUMBER	Active