ZX_RATES_B_
This table stores tax rates and the related attributes for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable to a specific tax status or tax jurisdiction.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_RATES_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, TAX_RATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAX_RATE_CODE | VARCHAR2 | 50 | Tax rate code | ||
| EFFECTIVE_FROM | DATE | Effective from date | |||
| EFFECTIVE_TO | DATE | Effective to date | |||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code for this rate | ||
| TAX | VARCHAR2 | 30 | Tax for which this rate is defined | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code for which this rate is defined | ||
| SCHEDULE_BASED_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this rate has multiple schedules | ||
| RATE_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether this rate is a percentage rate, a quantity based rate, a schedule based rate or a recovery rate | ||
| PERCENTAGE_RATE | NUMBER | Column to record rate value if this is a percentage rate | |||
| QUANTITY_RATE | NUMBER | Column to record rate value if this is a quantity based rate | |||
| UOM_CODE | VARCHAR2 | 30 | Unit of measure code for this rate. This column is applicable only for quantity based rates. | ||
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code for which this rate is defined | ||
| RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Default recovery type code for which this rate is defined | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this rate is active | ||
| DEFAULT_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is the default rate code for the status or jurisdiction | ||
| DEFAULT_FLG_EFFECTIVE_FROM | DATE | Effective start date from which this is the default rate code for the status or jurisdiction | |||
| DEFAULT_FLG_EFFECTIVE_TO | DATE | Effective end date till when this is the default rate code for the status or jurisdiction | |||
| DEFAULT_REC_TYPE_CODE | VARCHAR2 | 30 | Recovery type code for the default recovery rate code associated with this rate. This column is applicable only for status based rates. | ||
| DEFAULT_REC_RATE_CODE | VARCHAR2 | 50 | Default recovery rate code associated with this rate. This column is applicable only for status based rates. | ||
| OFFSET_TAX | VARCHAR2 | 30 | Tax of the offset rate code associated with this tax rate | ||
| OFFSET_STATUS_CODE | VARCHAR2 | 30 | Tax status code of the offset rate code associated with this tax rate | ||
| OFFSET_TAX_RATE_CODE | VARCHAR2 | 50 | Offset tax rate code associated with this tax rate | ||
| RECOVERY_RULE_CODE | VARCHAR2 | 30 | Recovery rule code if this is a recovery rate | ||
| DEF_REC_SETTLEMENT_OPTION_CODE | VARCHAR2 | 30 | Lookup code to indicate whether an input tax can be recovered when an invoice is recorded or only when the invoice is paid and whether an output tax is due for settlement when the invoice is issued or only when the payment is received against it. | ||
| VAT_TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | VAT transaction type code used to group invoices | ||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| INPUT_IC_AP_TAX_RATE_CODE | VARCHAR2 | 50 | Indicates the Input Tax Rate Code to be used for Inter-company Payables transactions | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| TAX_RATE_ID | NUMBER | 18 | Yes | Unique identifier | |
| CONTENT_OWNER_ID | NUMBER | 18 | Party tax profile identifier for configuration owner of this rate | ||
| ADJ_FOR_ADHOC_AMT_CODE | VARCHAR2 | 30 | Lookup code to identify whether tax rate or taxable basis is to be adjusted when tax amount is changed for tax lines with adhoc tax rate | ||
| ALLOW_ADHOC_TAX_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates whether adhoc tax rates are allowed for this tax rate | ||
| TAX_CLASS | VARCHAR2 | 30 | Column to indicate whether this tax code is applicable for Procure To Pay business flows or Order To Cash business flows. Possible values are INPUT and OUTPUT. NULL indicates it is applicable to both. | ||
| SOURCE_ID | NUMBER | 18 | Identifier of the tax code in AR_VAT_TAX_ALL or AP_TAX_CODES_ALL of prior releases for migrated records. | ||
| TAXABLE_BASIS_FORMULA_CODE | VARCHAR2 | 30 | Formula code to determine taxable base amount | ||
| INCLUSIVE_TAX_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax rate is tax inclusive by default | ||
| TAX_INCLUSIVE_OVERRIDE_FLAG | VARCHAR2 | 1 | Y or N indicates whether the tax inclusive flag can be overridden at tax line level | ||
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates if exemtpions are allowed for this rate | ||
| ALLOW_EXCEPTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates if exemtpions are allowed for this rate | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| DESCRIPTION | VARCHAR2 | 240 | Tax rate description | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program name of last concurrent program to update this record | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application name of last concurrent program to update this record | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_RATES_B_N1_ | Non Unique | Default | TAX_RATE_ID |
| ZX_RATES_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, TAX_RATE_ID |