[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BUDGET_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_BUDGET_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
GL_BUDGET_INTERFACE is used to upload budget data into your Oracle General Ledger application from a spreadsheet program or other external source. Each row includes one fiscal year's worth of budget amounts for an account. When you load this table, you must supply all NOT NULL columns with data. In addition, you must supply a valid account combination in the SEGMENT columns appropriate to your chart of accounts. Finally, you must supply the budget amounts in the appropriate AMOUNT columns. For more information about this table, see the Oracle General Ledger Implementation Guide.
Scope: public
Product: GL
Lifecycle: active
Display Name: GL Budget Interface
Category: BUSINESS_ENTITY GL_BUDGET_DATA
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_BUDGET_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 REQUEST_ID
STATUS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUDGET_NAME | VARCHAR2 | (15) | Yes | Budget version name |
| BUDGET_ENTITY_NAME | VARCHAR2 | (25) | Yes | Budget organization name |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency |
| FISCAL_YEAR | NUMBER | (15) | Yes | Fiscal year |
| UPDATE_LOGIC_TYPE | VARCHAR2 | (1) | Yes | Method used to update budget balances ('A' for add, 'R' for replace) |
| BUDGET_ENTITY_ID | NUMBER | (15) | Budget organization defining column | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Ledger defining column | |
| CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield combination defining column | |
| BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
| PERIOD_TYPE | VARCHAR2 | (15) | Accounting period type | |
| DR_FLAG | VARCHAR2 | (1) | Debit/Credit flag | |
| STATUS | VARCHAR2 | (1) | Line error status | |
| ACCOUNT_TYPE | VARCHAR2 | (25) | Key flexfield combination type (Asset, Liability, etc.) | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Concurrent program request id | |
| PERIOD1_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD2_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD3_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD4_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD5_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD6_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD7_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD8_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD9_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD10_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD11_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD12_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD13_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD14_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD15_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD16_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD17_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD18_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD19_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD20_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD21_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD22_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD23_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD24_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD25_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD26_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD27_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD28_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD29_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD30_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD31_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD32_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD33_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD34_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD35_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD36_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD37_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD38_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD39_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD40_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD41_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD42_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD43_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD44_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD45_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD46_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD47_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD48_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD49_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD50_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD51_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD52_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD53_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD54_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD55_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD56_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD57_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD58_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD59_AMOUNT | NUMBER | Budget period amount | ||
| PERIOD60_AMOUNT | NUMBER | Budget period amount | ||
| SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT21 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT22 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT23 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT24 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT25 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT26 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT27 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT28 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT29 | VARCHAR2 | (25) | Key flexfield segment | |
| SEGMENT30 | VARCHAR2 | (25) | Key flexfield segment | |
| LEDGER_ID | VARCHAR2 | (15) | Ledger defining column |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_NAME
, BUDGET_ENTITY_NAME
, CURRENCY_CODE
, FISCAL_YEAR
, UPDATE_LOGIC_TYPE
, BUDGET_ENTITY_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, BUDGET_VERSION_ID
, PERIOD_TYPE
, DR_FLAG
, STATUS
, ACCOUNT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PERIOD1_AMOUNT
, PERIOD2_AMOUNT
, PERIOD3_AMOUNT
, PERIOD4_AMOUNT
, PERIOD5_AMOUNT
, PERIOD6_AMOUNT
, PERIOD7_AMOUNT
, PERIOD8_AMOUNT
, PERIOD9_AMOUNT
, PERIOD10_AMOUNT
, PERIOD11_AMOUNT
, PERIOD12_AMOUNT
, PERIOD13_AMOUNT
, PERIOD14_AMOUNT
, PERIOD15_AMOUNT
, PERIOD16_AMOUNT
, PERIOD17_AMOUNT
, PERIOD18_AMOUNT
, PERIOD19_AMOUNT
, PERIOD20_AMOUNT
, PERIOD21_AMOUNT
, PERIOD22_AMOUNT
, PERIOD23_AMOUNT
, PERIOD24_AMOUNT
, PERIOD25_AMOUNT
, PERIOD26_AMOUNT
, PERIOD27_AMOUNT
, PERIOD28_AMOUNT
, PERIOD29_AMOUNT
, PERIOD30_AMOUNT
, PERIOD31_AMOUNT
, PERIOD32_AMOUNT
, PERIOD33_AMOUNT
, PERIOD34_AMOUNT
, PERIOD35_AMOUNT
, PERIOD36_AMOUNT
, PERIOD37_AMOUNT
, PERIOD38_AMOUNT
, PERIOD39_AMOUNT
, PERIOD40_AMOUNT
, PERIOD41_AMOUNT
, PERIOD42_AMOUNT
, PERIOD43_AMOUNT
, PERIOD44_AMOUNT
, PERIOD45_AMOUNT
, PERIOD46_AMOUNT
, PERIOD47_AMOUNT
, PERIOD48_AMOUNT
, PERIOD49_AMOUNT
, PERIOD50_AMOUNT
, PERIOD51_AMOUNT
, PERIOD52_AMOUNT
, PERIOD53_AMOUNT
, PERIOD54_AMOUNT
, PERIOD55_AMOUNT
, PERIOD56_AMOUNT
, PERIOD57_AMOUNT
, PERIOD58_AMOUNT
, PERIOD59_AMOUNT
, PERIOD60_AMOUNT
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, LEDGER_ID
FROM GL.GL_BUDGET_INTERFACE;
GL.GL_BUDGET_INTERFACE does not reference any database object
GL.GL_BUDGET_INTERFACE is referenced by following:
GL
GL_BUDGET_INTERFACE#
|
|
|
|