ZX_STATUS_B
This table stores tax statuses and the related attributes for multiple configuration owners. Each row stores a status for a tax and configuration owner.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_STATUS_B_PK |
TAX_STATUS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TAX_STATUS_CODE | VARCHAR2 | 30 | Yes | Tax status code | |
| EFFECTIVE_FROM | DATE | Effective from date | |||
| EFFECTIVE_TO | DATE | Effective to date | |||
| TAX | VARCHAR2 | 30 | Yes | Tax for this status | |
| TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Tax regime code for this status | |
| RULE_BASED_RATE_FLAG | VARCHAR2 | 1 | Y or N indicates whether rules are defined for this status to determine tax rate | ||
| ALLOW_RATE_OVERRIDE_FLAG | VARCHAR2 | 1 | Y or N indicates whether the rate for this status can be overridden | ||
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates whether exemptions are allowed for this tax status | ||
| ALLOW_EXCEPTIONS_FLAG | VARCHAR2 | 1 | Y or N indicates whether exceptions are allowed for this tax status | ||
| DEFAULT_STATUS_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is the default status code for the tax | ||
| DEFAULT_FLG_EFFECTIVE_FROM | DATE | Effective start date from which this is the default status for the tax | |||
| DEFAULT_FLG_EFFECTIVE_TO | DATE | Effective end date till when this is the default status for the tax | |||
| 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. | ||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user | ||
| 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. | ||
| REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| 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. | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| TAX_STATUS_ID | NUMBER | 18 | Yes | Unique identifier | |
| CONTENT_OWNER_ID | NUMBER | 18 | Yes | Party tax profile identifier for configuration owner of this status | |
| 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. | |
| 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 |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZX_STATUS_B | zx_party_tax_profile | CONTENT_OWNER_ID |
| ZX_STATUS_B | zx_regimes_b | TAX_REGIME_CODE |
| zx_rec_nrec_dist | zx_status_b | TAX_STATUS_ID |
| zx_lines | zx_status_b | TAX_STATUS_ID |
| zx_lines | zx_status_b | ORIG_TAX_STATUS_ID |
| zx_status_tl | zx_status_b | TAX_STATUS_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_STATUS_B_U1 | Unique | Default | TAX_STATUS_ID |
| ZX_STATUS_B_U2 | Unique | Default | TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, CONTENT_OWNER_ID |