Budget Spreadsheet Upload

Organization

Required

• The organization entered is an active organization found in the organization table.

• The organization cannot have a terminated date.

Hierarchy

Required

• The hierarchy exists within the application

• The budget hierarchy flag is set to “Y”

Level

Required

• The level exists in the hierarchy

• The level is flagged for budgets

Reporting Entity Code

Required

• The Reporting Entity Code must exist for the reporting level and hierarchy entered.

Activity

Optional

• The Budget Activity must exist in the application for the organization if entered.

Activity Year

Optional

• Activity Year can only be entered is the Activity has been entered.

• It must be a valid year (Format YYYY). It can only be less than the budget year if the carryover flag is “Y”.

Origin Code

Optional

• Used to retain the source of the budget transactions.

• If entered this code must exist in the user defined validation codes screen.

Currency

Required

• Currency must be the operating currency of the organization.

Gross or Net

Optional

• Valid values are “G"(Gross), “N”(Net).

• If left blank the process will determine whether the amounts are gross or net based on the Major Account entered.

• Budgets should be entered in gross. unless the net account is not used by a gross account.

Dollars or Volumes

Optional

• Valid values are “D” (dollars) or “V” (volumes).

• Must be “V” when the budget volume checkbox is selected for the major/minor account.

• Must be “D” when the budget volume checkbox is NOT selected for the major/minor account.

Volumes Daily or Monthly

Required IF

• Required if the Dollars or Volumes field is “V”.

• Budget volumes are maintained as daily volumes. If monthly volumes are provided the daily volumes are calculated.

Measurement System

Required IF

• Required if the account budgets in volumes.

• Valid values are "S" (System International or Metric) or "I" (Imperial).

WI%

Optional

• Working interest percentage used to calculate net volumes or amounts when the gross volumes or amounts are provided.

• System will generate a warning message if WI% is NOT 100% or empty for a Net major/minor account

Major Account

Required

• Must be a valid major account.

Minor Account

Required

• Must be a valid minor account for the above entered major account.

• The Major/Minor account combination must be a valid account in the Budget Account Group listed in System Defaults.

Continuity Code

Optional

• If System default (BUDGET_CONT_CODE) is set to 'Y' and the account requires a continuity code, then the continuity code must be specified.

• If System default is set to 'O' (optional) and the account requires a continuity code, then the continuity code can be left blank or a valid value can be provided.

• If System default is set to 'N', the validation routine will generate an error if a continuity code has been provided (even if the major/minor account requires a continuity code).

Value (MONTH)

Optional

• The Amount or Volume for the month based on the Dollar or Volume column.

• If gross, net will be calculated using the WI% provided.

• If volumes are input, the dollar amounts are calculated based on budget prices (as set in the application).

• All of the value fields allow 2 decimal for dollars and volumes.

• If the user leaves the monthly amounts blank then existing budget items will not be overwritten.

• If the budget items do not currently exist and no values have been provided, they will be created with a value of zero.

Future Year

Optional

• The Amount or Volume for the first month of the following budget year based on the Dollar or Volume column.

• If gross, net will be calculated using the WI% provided.

• If volumes are input, the dollar amounts are calculated based on budget prices (as set in the application).

• All of the value fields allow 2 decimal for dollars and volumes.

• If the user leaves the monthly amounts blank then existing budget items will not be overwritten.

• If the budget items do not currently exist and no values have been provided, they will be created with a value of zero.

Load Upload Data Files

Must be set to N

Data Files in HOME directory

Must be left blank

Upload File Name

Must be left blank

Target Budget Ref

Budget Reference Number that was input on the spreadsheet

Target Budget Year

Budget Year that was input on the spreadsheet

Target Budget Version

Budget Version that was input on the spreadsheet

Replace Duplicates

Whether the process will overwrite existing values

Copy Partial of All Entries

Must be set to P

Batch ID

Report ID listed on the Budget Upload Spreadsheet

Override User ID

Enter user ID of user who uploaded budget information (if different than user submitting this job)