BDUTFI (Budget Item Detail Interface) is an interface utility that accepts a comma-delimited file and loads data from it into the BusinessPlus Budget Item Detail system. Files with Miscellaneous, Travel, Equipment, and Position Budget Details are supported.
After a BDUTFI uploads the input file successfully, it renames the input file with a ".done" extension.
Input File Format
|
Column |
Contents |
|
1 A |
Budget Type (all) (Required) – Set to MISC, TRVL, EQPT, or POSB |
|
2 B |
Budget Amount (bd_misc) |
|
3 C |
Bargain Unit (bd_posb) – Must be a valid Bargain Unit |
|
4 D |
Misc Amount (bd_trvl) |
|
5 E |
Comments (all) |
|
6 F |
Contract (bd_eqpt) |
|
7 G |
Description (all) (Required) |
|
8 H |
Employee ID (bd_posb) – Must be a valid Employee ID |
|
9 I |
Trip End Date (bd_trvl) |
|
10 J |
Fixed Asset Flag (bd_eqpt) – Set to Y or N. |
|
11 K |
Fees Amount (bd_trvl) |
|
12 L |
Funding Source (bd_eqpt) |
|
13 M |
Fringe Amount (bd_posb) |
|
14 N |
Fiscal Year (all) (Required) |
|
15 O |
Ledger Code (all) (Required) |
|
16 P |
Job Number (bd_posb) – Must be a valid Job Number |
|
17 Q |
Justification (bd_misc) |
|
18 R |
Org Key (all) (Required) – Must be valid and active IFAS Org Key |
|
19 S |
Lodging Amount (bd_trvl) |
|
20 T |
Location (bd_trvl, bd_posb) – Must be a valid location code for bd_posb. For bd_trvl, shouldn't be validated; task 506368 will fix this utility so that this isn't validated for bd_trvl. |
|
21 U |
Level Code (all) (Required) – Set to "OB" for object level or "G1" for group level 1, etc. |
|
22 V |
Meals Amount (bd_trvl) |
|
23 W |
Make (bd_eqpt) |
|
24 X |
Month (all) (Required). The month is a 2-character field, for example, "01" |
|
25 Y |
Model (bd_posb, bd_eqpt) – Must be a valid model code |
|
26 Z |
Object Code (all) (Required) – Must be valid and active IFAS Object Code |
|
27 AA |
Package (all) – Must be a valid package code |
|
28 AB |
|
|
29 AC |
Position (bd_posb) |
|
30 AD |
Priority (all) (Required). Priority is a 2-character field. In the BDUPDAMS screen, the Priority field is on the right side of the screen in the Details tab. |
|
31 AE |
Purchase Date (bd_eqpt) |
|
32 AF |
Quantity (bd_eqpt) – Up to 5 decimal places may be given |
|
33 AG |
Reference (all) |
|
34 AH |
Salary Amount (bd_posb) |
|
35 AI |
Salary Table (bd_posb) – Must be a valid salary table |
|
36 AJ |
Trip Start Date (bd_trvl) |
|
37 AK |
Transportation Amount (bd_trvl) |
|
38 AL |
Trns Type (bd_trvl) – Must be a valid Transaction Type |
|
39 AM |
Unit Price Amount (bd_eqpt) |
|
40 AN |
Version (all) (Required) – Must be a valid Budget Version which has been set up in BDUPCD. This is a 2-character field. |
|
41 AO |
Department (bd_posb) – Must be a valid department code |
File Format Notes:
-
Required fields are in bold
-
Unused columns should be left blank
-
Amounts are whole dollars, unless a decimal is included
-
Dates may be in CCYYMMDD or MM/DD/CCYY format