Tax Role

Tax Role Data Model

The following data model illustrates the tax role object.

Tax Role Data Model

Tax Role Table Names

Data Model Name

Table Name

Generated Keys

Object Validation Batch Control

Referential Integrity Validation Batch Control

Key Assignment Batch Control

Insertion Batch Control

Tax Role

CI_​TAX_​ROLE

Yes. CI_​TAX_​ROLE_​K

VAL-TAXR

CIPVTXRV

CIPVTXRK

Has dependencies

CIPVTXRI

Tax Role Revenue Calendar

CI_​TAX_​ROLE_​CAL

No. The key is Tax Role ID and Effective Date.

CIPVTRCV

CIPVTRCI

Tax Role Address

CI_​TAX_​ROLE_​ADDR

No. The key is Tax Role ID and Sequence Number.

CIPVTRAV

CIPVTRAI

Tax Role Related Persons

CI_​TAX_​ROLE_​PER

No. The key is Tax Role ID, Relationship Type, Start Date and Person ID.

CIPVTXPV

CIPVTXPI

Tax Role Characteristic

CI_​TAX_​ROLE_​CHAR

No. The key is Tax Role ID, Characteristic Type, and Effective Date.

CIPVTXCV

CIPVTXCI

Tax Role Suggestions

This maintenance object includes a character large object field that your organization may be using to capture implementation specific data as defined by your business objects. For records of this type, the process to insert the records to the staging table is responsible for populating the data in this CLOB as per the record's business object schema.

Optional FK Note

Tax Role has an optional foreign key ASSET_​ID to the Asset (CI_​ASSET) table. Implementations that are not planning to convert Assets must still run the key generation process for Assets. Refer to The Big Picture of Key Assignment for more information.