ZX_PARTY_DEDUCTIONS_F

This table stores information about tax deductions such as social security, alimony, etc for a particular tax party.

Details

• Schema: FUSION

• Object owner: ZX

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
ZX_PARTY_DEDUCTIONS_F_PK	TAX_DEDUCTION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TAX_DEDUCTION_ID	NUMBER		18	Yes	Deduction identifier associated with a party.
TAX_DEDUCTION_TYPE_CODE	VARCHAR2	30		Yes	Type of deduction such as for social secuirty, alimony, and dependents.
NUM_OF_DEPENDENTS	NUMBER				Number of dependents to be considered for deductions in withholding tax calculation.
TAX_DEDUCTION_AMT	NUMBER				Amount of deduction from the taxable basis for withholding tax calculation.
TAX_REGIME_CODE	VARCHAR2	30		Yes	Tax regime code for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority.
TAX	VARCHAR2	30		Yes	Tax code for the classification of a charge imposed by a government through a fiscal or tax authority.
TAX_JURISDICTION_CODE	VARCHAR2	30			Tax jurisdiction code for a geographic area where a tax is levied by a specific tax authority.
PARTY_TAX_PROFILE_ID	NUMBER		18	Yes	Party tax profile identifier of the party for which this deduction applies. Foreign key to ZX_PARTY_TAX_PROFILE.
EFFECTIVE_START_DATE	DATE			Yes	Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE	DATE			Yes	Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
RECORD_TYPE_CODE	VARCHAR2	30		Yes	Deduction record type, such as seeded or user defined.
ALIMONY_BENEFICIARIES_INFO	VARCHAR2	1000			Concatenated information on beneficiaries of alimony for withholding tax deduction.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
ZX_PARTY_DEDUCTIONS_F_U1	Unique	Default	TAX_DEDUCTION_ID
ZX_PARTY_DEDUCTIONS_F_U2	Unique	Default	TAX_REGIME_CODE, TAX, PARTY_TAX_PROFILE_ID, TAX_DEDUCTION_TYPE_CODE, TAX_JURISDICTION_CODE, EFFECTIVE_START_DATE