[Home] [Help] [Dependency Information]
Object Name: | GL_CARRYFORWARD_RANGES |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_CARRYFORWARD_RANGES |
Subobject Name: | |
Status: | VALID |
GL_CARRYFORWARD_RANGES stores the low and high ranges of account values that you want to carry forward at year end. You can carry forward encumbrance amounts only, encumbrance plus encumbered budget, or funds available when you cross a fiscal year. This is the base table for the Year-End Carry Forward form in Oracle General Ledger. CARRYFORWARD_RANGE_ID is unique for each Carry Forward request. This table has no foreign keys other than the standard Who columns.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CARRYFORWARD_RANGE_ID | NUMBER | (15) | Yes | Carry forward process defining column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
SEGMENT1_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT1_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT2_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT2_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT3_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT3_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT4_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT4_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT5_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT5_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT6_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT6_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT7_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT7_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT8_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT8_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT9_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT9_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT10_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT10_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT11_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT11_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT12_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT12_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT13_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT13_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT14_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT14_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT15_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT15_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT16_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT16_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT17_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT17_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT18_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT18_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT19_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT19_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT20_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT20_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT21_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT21_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT22_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT22_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT23_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT23_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT24_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT24_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT25_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT25_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT26_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT26_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT27_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT27_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT28_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT28_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT29_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT29_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column | |
SEGMENT30_LOW | VARCHAR2 | (25) | Key flexfield segment low range column | |
SEGMENT30_HIGH | VARCHAR2 | (25) | Key flexfield segment high range column |
Cut, paste (and edit) the following text to query this object:
SELECT CARRYFORWARD_RANGE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SEGMENT1_LOW
, SEGMENT1_HIGH
, SEGMENT2_LOW
, SEGMENT2_HIGH
, SEGMENT3_LOW
, SEGMENT3_HIGH
, SEGMENT4_LOW
, SEGMENT4_HIGH
, SEGMENT5_LOW
, SEGMENT5_HIGH
, SEGMENT6_LOW
, SEGMENT6_HIGH
, SEGMENT7_LOW
, SEGMENT7_HIGH
, SEGMENT8_LOW
, SEGMENT8_HIGH
, SEGMENT9_LOW
, SEGMENT9_HIGH
, SEGMENT10_LOW
, SEGMENT10_HIGH
, SEGMENT11_LOW
, SEGMENT11_HIGH
, SEGMENT12_LOW
, SEGMENT12_HIGH
, SEGMENT13_LOW
, SEGMENT13_HIGH
, SEGMENT14_LOW
, SEGMENT14_HIGH
, SEGMENT15_LOW
, SEGMENT15_HIGH
, SEGMENT16_LOW
, SEGMENT16_HIGH
, SEGMENT17_LOW
, SEGMENT17_HIGH
, SEGMENT18_LOW
, SEGMENT18_HIGH
, SEGMENT19_LOW
, SEGMENT19_HIGH
, SEGMENT20_LOW
, SEGMENT20_HIGH
, SEGMENT21_LOW
, SEGMENT21_HIGH
, SEGMENT22_LOW
, SEGMENT22_HIGH
, SEGMENT23_LOW
, SEGMENT23_HIGH
, SEGMENT24_LOW
, SEGMENT24_HIGH
, SEGMENT25_LOW
, SEGMENT25_HIGH
, SEGMENT26_LOW
, SEGMENT26_HIGH
, SEGMENT27_LOW
, SEGMENT27_HIGH
, SEGMENT28_LOW
, SEGMENT28_HIGH
, SEGMENT29_LOW
, SEGMENT29_HIGH
, SEGMENT30_LOW
, SEGMENT30_HIGH
FROM GL.GL_CARRYFORWARD_RANGES;
GL.GL_CARRYFORWARD_RANGES does not reference any database object
GL.GL_CARRYFORWARD_RANGES is referenced by following:
|
|
|