[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_TAX_RELATIONS_T |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_TAX_RELATIONS_T
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARENT_TAX_CODE_ID | NUMBER | (15) | Yes | Parent tax code identifier |
| PARENT_TAX_CODE | VARCHAR2 | (50) | Yes | Parent tax code |
| PARENT_REGIME_CODE | VARCHAR2 | (30) | Yes | Regime code for parent tax code |
| PARENT_PRECEDENCE | VARCHAR2 | (30) | Column to store the precedence for the parent tax code within the tax group | |
| CHILD_TAX_CODE_ID | NUMBER | (15) | Child tax code identifier | |
| CHILD_TAX_CODE | VARCHAR2 | (50) | Child tax code | |
| CHILD_REGIME_CODE | VARCHAR2 | (30) | Regime code for child tax code | |
| BRANCH_FLAG | VARCHAR2 | (30) | Y or N to indicate if the tax codes are originally from a branch group | |
| TAX_GROUP_ID | NUMBER | (15) | Yes | Tax group identifier |
| CHILD_PRECEDENCE | VARCHAR2 | (30) | Column to store the precedence for the child tax code within the tax group | |
| PARENT_TAXABLE_BASIS | VARCHAR2 | (30) | Taxable basis of parent tax code | |
| CHILD_TAXABLE_BASIS | VARCHAR2 | (30) | Taxable basis of child tax code | |
| PARENT_TAX | VARCHAR2 | (30) | Yes | Tax for parent tax code |
| CHILD_TAX | VARCHAR2 | (30) | Tax for child tax code | |
| TAX_GROUP_CODE | VARCHAR2 | (30) | Tax group code | |
| CONTENT_OWNER_ID | NUMBER | (15) | Yes | Party tax profile identifier for configuration owner of the taxes for parent and child tax codes |
| ORG_ID | NUMBER | (15) | Yes | Internal organization identifier |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | Request identifier of last concurrent program to update this record | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update this record | ||
| PROGRAM_ID | NUMBER | Program identifier of last concurrent program to update this record | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_TAX_CODE_ID
, PARENT_TAX_CODE
, PARENT_REGIME_CODE
, PARENT_PRECEDENCE
, CHILD_TAX_CODE_ID
, CHILD_TAX_CODE
, CHILD_REGIME_CODE
, BRANCH_FLAG
, TAX_GROUP_ID
, CHILD_PRECEDENCE
, PARENT_TAXABLE_BASIS
, CHILD_TAXABLE_BASIS
, PARENT_TAX
, CHILD_TAX
, TAX_GROUP_CODE
, CONTENT_OWNER_ID
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
FROM ZX.ZX_TAX_RELATIONS_T;
ZX.ZX_TAX_RELATIONS_T does not reference any database object
ZX.ZX_TAX_RELATIONS_T is referenced by following:
APPS
ZX_TAX_RELATIONS_T
|
|
|
|