The BA_YEBA_Import.xls template applies to two document types:
• Year-End Budget Adjustment
The basic format of the template is shown below in two parts.
BA_YEBA_Import template format
Column |
Field Name |
A |
If your institution has set the ACCOUNTS_CAN_CROSS_CHARTS_IND parameter to NO, delete this column before using the template. |
B |
Account Number* |
C |
Sub-Account Number |
D |
|
E |
Sub-Object Code |
F |
Project Code |
G |
Organization Reference Id |
H |
Line Description |
I |
Current Budget Adjustment Amount* |
J |
Base Budget Adjustment Amount |
K |
Month 1 Budget Amount |
L |
Month 2 Budget Amount |
M |
Month 3 Budget Amount |
N |
Month 4 Budget Amount |
O |
Month 5 Budget Amount |
P |
Month 6 Budget Amount |
Q |
Month 7 Budget Amount |
R |
Month 8 Budget Amount |
S |
Month 9 Budget Amount |
T |
Month 10 Budget Amount |
U |
Month 11 Budget Amount |
V |
Month 12 Budget Amount |
If an amount is erroneously entered in the Base Budget Adjustment Amount column, it is imported to the accounting line of the e-doc. An error is displayed when the data is validated via saving or submitting the e-doc.
More: