JE_HU_BALANCES_REPORT
JE_HU_BALANCES_REPORT contains information used for the Hungarian Asset Movement Schedule, the Hungarian Accumulated Depreciation Movement Schedule, and the Hungarian Depreciation Analysis Report. Oracle Assets never permanently stores data in this table. When you submit a balances report, Oracle Assets deletes any data in this table before running the report.
Details
-
Schema: FUSION
-
Object owner: JE
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
CATEGORY_ID | NUMBER | 18 | Yes | Asset category identifier | |
ASSET_ID | NUMBER | 18 | Yes | Asset identifier | |
DISTRIBUTION_CCID | NUMBER | 18 | Yes | Accounting Flexfield identifier for depreciation expense account for the asset | |
ADJUSTMENT_CCID | NUMBER | 18 | Accounting Flexfield identifier for adjustment account for the asset | ||
CATEGORY_BOOKS_ACCOUNT | VARCHAR2 | 25 | Account being adjusted, or depreciation reserve account | ||
SOURCE_TYPE_CODE | VARCHAR2 | 15 | Yes | Transaction or balance this row describes | |
AMOUNT | NUMBER | Depreciation, adjustment, cost, or reserve balance amount | |||
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. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. |