D Mapping Fields for Budget Data Import

This appendix contains the following topics:

D.1 Mapping Fields in the F0902Z1 Table

This section contains a list of the fields contained in the F0902Z1 table. The fields are categorized as follows:

  • Fields updated by the spreadsheet.

  • Fields updated by the system.

D.1.1 Fields Updated by the Spreadsheet

Review these guidelines for information about fields in the spreadsheet:

  • Each field in the spreadsheet should not exceed the maximum number of characters shown in the previous table, but it can contain fewer.

  • Amount fields can include decimal points.

  • If you use a minus sign, it must be the first character to the left of the left-most number.

This table describes each of the fields in the detail area of the Upload Records to F0902Z1 form and how to complete the corresponding cell in your spreadsheet:

F0902Z1 Field Complete Corresponding Cell in Spreadsheet
Account ID (AID) Enter a value in this field only if you entered 1 for the Account Number processing option for the Upload/Conversion Revisions program (P0902Z1). Enter the 8-digit system-assigned short account ID. Ensure that you enter all 8 digits, using the leading zeros if applicable.
Free Form Account Number (ANS) Enter a value in this field only if you entered 2 for the Account Number processing option for the Upload/Conversion Revisions program. This is commonly referred to as the third account number and is typically used to enter the account number from a prior system. No limitations exist for the characters that you can use.
Account Number (ANI) Enter the entire account number, including business unit, object account, and subsidiary (if applicable). Enter a value in this field only if you entered 3 for the Account Number processing option for the Upload/Conversion Revisions program.
Business Unit (MCU) Enter the number of the business unit. Use this field with the Object Account and Subsidiary fields only if you entered 4 for the Account Number processing option for the Upload/Conversion Revisions program.
Object Account (OBJ) Enter the object account number. Use this field with the Business Unit and Subsidiary fields only if you entered 4 for the Account Number processing option for the Upload/Conversion Revisions program.
Subsidiary Enter the subsidiary of the account. Use this field with the Business Unit and Object Account fields only if you entered 4 for the Account Number processing option for the Upload/Conversion Revisions program.
Subledger (SBL) Enter the value of the subledger for the account. This value is 8 alphanumeric characters.
Subledger Type (SBLT) Enter the value of the subledger type for the account. This value is one alphanumeric character.
Net Posting 01 (AN01) – Net Posting 14 (AN14) Enter the budget amount for periods 1–14. Use these fields to import budgets by period. This value is 15 numeric characters.
Original/Beg Budget (BORG) Use this field to import annual budgets. This value is 15 numeric characters.
Prior Year Net Postings (APYN) Use this field to enter a prior year posting for this account. This value is 15 numeric characters.
Week to Date Net Postings (AWTD) Enter a value in this field if you use 52 period accounting. This value is 15 numeric characters.
Approved Budget (BAPR) Use this field to import annual budget that are approved. This value is 15 numeric characters.
Requested Budget (BREQ) Use this field to import annual budgets that are requested. This value is 15 numeric characters.
Beg Balance/PYE Forward (APYC) Use this field to enter a beginning balance for this account. This value is 15 numeric characters.

D.1.2 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.