Previous  Next          Contents  Index  Navigation  Glossary  Library

Understanding the Budget Interface Table

The first step in transferring your budget data from an outside source to your General Ledger application is to load your data into your General Ledger application Budget Interface table. Once you load your budget information into the Budget Interface table, you can run Budget Upload to post your budget data into your General Ledger application.

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)

See Also

Creating Your Budget Spreadsheet

Loading Data into the Budget Interface Table

Uploading Budgets

         Previous  Next          Contents  Index  Navigation  Glossary  Library