Budget - Sage Intacct Data Target Requirements

DataBlend supports the API calls to Create and Update Budget records within Sage Intacct leveraging the Sage Intacct SDK. In addition, Custom Fields can be added for data that is unique to your business practices.

A budget is a plan to help estimate revenue and expenses for operations. Budget amounts are uploaded early in the cycle (month or quarter), and then are used at the end of the cycle to compare against actuals.

DataBlend Query Object (SDK)

 

Sage Intacct Object (API)

 

Sage Intacct UI Name

 

Required

 

Notes

 

ACCT_NO

ACCT_NO

Account

Yes

Expected value is free text (80)

AMOUNT

AMOUNT

Amount

Yes

Expected value is decimal

BUDGETID

BUDGETID

Budget ID

Yes for Create

Expected value is free text (20)

CURRENCY

CURRENCY

Consolidated currency

Yes/Optional

Consolidation currency code. Required if ISCONSOLIDATED is set to true

CUSTOMERID

CUSTOMERID

Customer

Optional

Expected value is free text (20)

DEFAULT_BUDGET

DEFAULT_BUDGET

Default budget

Optional

Expected value is free text

DEPT_NO

DEPT_NO

Department

Optional

Expected value is free text (80)

DESCRIPTION

DESCRIPTION

Description

Yes/Optional

Yes for Create, Optional for Update. Expected value is free text (40)

IS_CONSOLIDATED

ISCONSOLIDATED

Single currency budget

Optional

Check box. Use true to make this a consolidated budget, otherwise use false

ITEM_RECORDNO

RECORDNO

Record number

Yes for Update

Record number of the budget. Expected value is integer.

LOCATION_NO

LOCATION_NO

Location

Optional

Expected value is free text (80)

PERIODNAME

PERIODNAME

Period Name

Yes

Expected value is free text (80)

RECORDNO

RECORDNO

Record Number

Optional

Record number of a budget detail to modify. Omit this parameter to create a new budget detail.