[Home] [Help] [Dependency Information]
Object Name: | JAI_RGM_DIS_SRC_TAXES |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JAI_RGM_DIS_SRC_TAXES |
Subobject Name: | |
Status: | VALID |
This table has the details of the taxes , and amounts transferred from the source organization.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JAI_RGM_DIS_SRC_TAXES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSFER_SOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSFER_ID | NUMBER | A Unique Record which identifies the Distribution transaction. | ||
TRANSFER_SOURCE_ID | NUMBER | Yes | A unique record which identifies the distribution source record. | |
TAX_TYPE | VARCHAR2 | (30) | It has the tax type from where transfer is done | |
DEBIT_BALANCE | NUMBER | The debit balance available for the tax type | ||
CREDIT_BALANCE | NUMBER | The credit balance available for the tax type | ||
TRANSFER_AMOUNT | NUMBER | The Amount to be transferred from the Source Tax Type | ||
PARENT_TAX_TYPE | VARCHAR2 | (30) | The Parent Tax Type for this tax record | |
PERCENT_OF_PARENT | NUMBER | The Percentage of parent tax type to be calculated. | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSFER_ID
, TRANSFER_SOURCE_ID
, TAX_TYPE
, DEBIT_BALANCE
, CREDIT_BALANCE
, TRANSFER_AMOUNT
, PARENT_TAX_TYPE
, PERCENT_OF_PARENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM JA.JAI_RGM_DIS_SRC_TAXES;
JA.JAI_RGM_DIS_SRC_TAXES does not reference any database object
JA.JAI_RGM_DIS_SRC_TAXES is referenced by following:
|
|
|