[Home] [Help] [Dependency Information]
Object Name: | JA_AU_BAL_CHG_SOURCE |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_AU_BAL_CHG_SOURCE |
Subobject Name: | |
Status: | VALID |
JA_AU_BAL_CHG_SOURCE is used to store information about
the asset from which balancing charges are sourced. This table
is populated by the calculate balancing charges process and updated
by the allocation of balancing charges.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_AU_BAL_CHG_SOURCE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BAL_CHG_ID |
JA_AU_BAL_CHG_SOURCE_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
ASSET_ID RETIREMENT_ID |
JA_AU_BAL_CHG_SOURCE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BAL_CHG_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BAL_CHG_ID | NUMBER | (15) | Yes | Balancing charge identifier |
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
ASSET_ID | NUMBER | (15) | Yes | Asset identifier |
RETIREMENT_ID | NUMBER | (15) | Yes | Retirement identification number |
BAL_CHG_AMOUNT | NUMBER | Amount of balancing charges available for the asset | ||
BAL_CHG_APPLIED | NUMBER | Amount of balancing charges applied from the asset | ||
DATE_RETIRED | DATE | Date the asset was retired | ||
BAL_CHG_STATUS | VARCHAR2 | (1) | Status of the balancing charge | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | VARCHAR2 | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive Flexfield structure defining column |
Cut, paste (and edit) the following text to query this object:
SELECT BAL_CHG_ID
, BOOK_TYPE_CODE
, ASSET_ID
, RETIREMENT_ID
, BAL_CHG_AMOUNT
, BAL_CHG_APPLIED
, DATE_RETIRED
, BAL_CHG_STATUS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
FROM JA.JA_AU_BAL_CHG_SOURCE;
JA.JA_AU_BAL_CHG_SOURCE does not reference any database object
JA.JA_AU_BAL_CHG_SOURCE is referenced by following:
|
|
|