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