• Last edited on: 01 February 2019

Budget Line Adjustment Import

The Budget Line Adjustment integration loader uses only a single set of header columns.

Overview

The Budget Line Adjustment Import process read files from  ./Incoming/BudgetLineAdjustments/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/BudgetLineAdjustment/ before being processed in alphanumeric order. 

  • The Chart of Accounts must already exist
  • The Account must already exist for the Chart of Accounts
  • Currency must be active.
  • Budget Segment Must exists
Note

You must open an individual record in order to download the CSV import template.

Column Name Description Req'd Unique Type Allowable Values
Budget period* Name for Budget Period TRUE FALSE string(100) any
Chart of Accounts* Name for Chart of Accounts TRUE FALSE string(1024) any
Budget segment* Budget Line code TRUE FALSE int(11) any
Adjustment amount* Budget Line Adjustment amount TRUE FALSE decimal(32,4) any
Currency* Currency code TRUE FALSE string(6) any
Description adjustment description FALSE FALSE string(255) any

Related Items


Enterprise Import

03 February 2019

The Enterprises integration loader uses only a single set of header columns.

Exchange Rate Import

03 February 2019

The exchange rates integration loader uses only a single set of header columns.

Expense Category Import

03 February 2019

The Expense Category loader uses only a single set of header columns.

Expense Mileage Data Import

04 February 2019

The expense mileage data integration loader uses only a single set of header columns.