[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:
|
|
|