Previous | Next | Contents | Index | Navigation | Glossary | Library |
Budget Upload uses the Budget Interface table GL_BUDGET_ INTERFACE to upload budget information. The Budget Interface table is organized into columns in which your General Ledger application categorizes and stores specific budget information. For example, the name of your budget is stored in the column called Budget_Name. You must specify valid values for each of the required columns in this table to successfully complete a Budget Upload. You may specify values for the optional columns within this table. These values are validated before your General Ledger application updates budget balances. The Budget Interface table contains the following columns:
Column Name | Null? | Type |
---|---|---|
BUDGET_NAME | NOT NULL | VARCHAR2 (15) |
BUDGET_ENTITY_NAME | NOT NULL | VARCHAR2 (25) |
CURRENCY_CODE | NOT NULL | VARCHAR2 (15) |
FISCAL_YEAR | NOT NULL | NUMBER (15) |
UPDATE_LOGIC_TYPE | NOT NULL | VARCHAR2 (1) |
BUDGET_ENTITY_ID | NUMBER (15) | |
SET_OF_BOOKS_ID | NUMBER (15) | |
CODE_COMBINATION_ID | NUMBER (15) | |
BUDGET_VERSION_ID | NUMBER (15) | |
PERIOD_TYPE | VARCHAR2 (15) | |
DR_FLAG | VARCHAR2 (1) | |
STATUS | VARCHAR2 (1) | |
ACCOUNT_TYPE | VARCHAR2 (1) | |
LAST_UPDATE_DATE | DATE | |
LAST_UPDATED_BY | NUMBER (15) | |
REQUEST_ID | NUMBER (15) | |
PERIOD1_AMOUNT through PERIOD60_AMOUNT | NUMBER | |
SEGMENT1 through SEGMENT30 | VARCHAR2 (25) |
Loading Data into the Budget Interface Table
Previous | Next | Contents | Index | Navigation | Glossary | Library |