Skip to main content
Skip table of contents

Budget Item Detail Interface - BDUTFI

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

  1. Persons (bd_trvl)

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
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.