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