Fields Updated by the System

These fields are completed by the system and, therefore, do not need to exist in your spreadsheet:

  • Century (CTRY)

  • Fiscal Year (FY)

    The CTRY and FY fields are populated by the system when you run the Upload/Conversion program (R14110), based on the values you enter in the Century and Fiscal Year processing options for that program.

    To load more than one year of budget data, complete these fields for each year you want to load, and then use the Century and Fiscal Year processing options and data selection for the Upload/Conversion program to upload one year at a time.

    For example, if you want to upload budget data for 2006 and 2007, run the Upload/Conversion program once with the Century processing option set to 20, the fiscal year processing option set to 06, and data selection set to Century is equal to 20 and Fiscal Year is equal to 06. Then, run the Upload/Conversion program again with the specifications set to the appropriate values for the year 2007.

    If you do not use data selection, the system overwrites the fiscal year and century from your spreadsheet with the values from the processing options.

  • Company (CO)

  • Date Updated (UPMJ)

  • Budget Memo Change (POU)

  • Commitment Memo Changes (TKER)

  • % Cmp (PC)

    Note: The system completes the Currency Code Denominated field (CRCX) with the currency of the company to which the accounts belong. The Currency Code From field (CRCD) is typically left blank for budget ledgers.