ProjectBudgetTransaction

A project budget transaction [ProjectBudgetTransaction] defines a transaction in one project budget grid line.

Review the Usage Guidelines for the ProjectBudgetTransaction object.

—	XML	SOAP	REST	Database table
Object	`ProjectBudgetTransaction`	`oaProjectBudgetTransaction`	—	`project_budget_transaction`
Supported Commands	`Add`, `Read`, `Modify`, `Delete`	`add()`, `read()`, `modify()`, `upsert()`, `delete()`	—	—

—

XML

SOAP

REST

Database table

Object

ProjectBudgetTransaction

oaProjectBudgetTransaction

—

project_budget_transaction

Supported Commands

Add, Read, Modify, Delete

add(), read(), modify(), upsert(), delete()

—

The ProjectBudgetTransaction object has the following properties:

XML / SOAP	Database	Description
`category`	`category`	[Read-only] Copied from project budget rule. The main category for this budget transaction: 1 — labor 2 — expense item 3 — purchase order When setting `category` to `1`, the property `labor_subcategory` for the associated project budget group `project_budget_groupid` must be set.
`categoryid`	`category_id`	[Read-only] Copied from project budget rule. The ID of the associated category.
`created`	`created`	[Read-only] Time the record was created. See Date Fields.
`currency`	`currency`	Currency for the money fields in the record.
`customerid`	`customer_id`	[Read-only] Copied from project budget group. The ID of the associated customer.
`date`	`date`	The date of the project budget transaction. See Date Fields.
`id`	`id`	[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro.
`itemid`	`item_id`	[Read-only] Copied from project budget rule. The ID of the associated item.
`job_codeid`	`job_code_id`	[Read-only] Copied from project budget rule. The ID of the associated job code.
`productid`	`product_id`	[Read-only] Copied from project budget rule. The ID of the associated product.
`project_budget_groupid`	`project_budget_group_id`	The ID of the associated project budget group.
`project_budget_ruleid`	`project_budget_rule_id`	The ID of the associated project budget rule.
`project_taskid`	`project_task_id`	[Read-only] Copied from project budget rule. The ID of the associated project task.
`projectid`	`project_id`	[Read-only] Copied from project budget group. The ID of the associated project.
`quantity`	`quantity`	Quantity for this project budget transaction.
`quantity_best`	`quantity_best`	The best-case quantity estimate for this project budget transaction.
`quantity_most_likely`	`quantity_most_likely`	The most likely quantity estimate for this project budget transaction.
`quantity_worst`	`quantity_worst`	The worst-case quantity estimate for this project budget transaction.
`total`	`total`	The total for this budget transaction. Date set by the date" attribute."
`total_best`	`total_best`	The best-case estimate for this project budget transaction. Date set by the date" attribute."
`total_most_likely`	`total_most_likely`	The most likely estimate for this project budget transaction. Date set by the date" attribute."
`total_worst`	`total_worst`	The worst-case estimate for this project budget transaction. Dated by the date field.
`updated`	`updated`	[Read-only] Time the record was last updated or modified. See Date Fields.

XML / SOAP

Database

Description

category

[Read-only] Copied from project budget rule. The main category for this budget transaction:

1 — labor
2 — expense item
3 — purchase order

When setting category to 1, the property labor_subcategory for the associated project budget group project_budget_groupid must be set.

categoryid

category_id

[Read-only] Copied from project budget rule. The ID of the associated category.

created

[Read-only] Time the record was created. See Date Fields.

currency

Currency for the money fields in the record.

customerid

customer_id

[Read-only] Copied from project budget group. The ID of the associated customer.

date

The date of the project budget transaction. See Date Fields.

id

[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro.

itemid

item_id

[Read-only] Copied from project budget rule. The ID of the associated item.

job_codeid

job_code_id

[Read-only] Copied from project budget rule. The ID of the associated job code.

productid

product_id

[Read-only] Copied from project budget rule. The ID of the associated product.

project_budget_groupid

project_budget_group_id

The ID of the associated project budget group.

project_budget_ruleid

project_budget_rule_id

The ID of the associated project budget rule.

project_taskid

project_task_id

[Read-only] Copied from project budget rule. The ID of the associated project task.

projectid

project_id

[Read-only] Copied from project budget group. The ID of the associated project.

quantity

Quantity for this project budget transaction.

quantity_best

The best-case quantity estimate for this project budget transaction.

quantity_most_likely

The most likely quantity estimate for this project budget transaction.

quantity_worst

The worst-case quantity estimate for this project budget transaction.

total

The total for this budget transaction. Date set by the date" attribute."

total_best

The best-case estimate for this project budget transaction. Date set by the date" attribute."

total_most_likely

The most likely estimate for this project budget transaction. Date set by the date" attribute."

total_worst

The worst-case estimate for this project budget transaction. Dated by the date field.

updated

[Read-only] Time the record was last updated or modified. See Date Fields.

Usage Guidelines

Review the following guidelines:

When adding a new project budget rule, SuiteProjects Pro checks the validity of the the project budget rule, and returns error 946 if invalid (see Error Codes). The following fields are sourced from the project budget rule: category, categoryid, customerid, itemid, job_codeid, productid, projectid, project_budget_groupid, project_taskid
When modifying an existing project budget rule, you cannot change the project_budget_ruleid or any of the fields sourced from the project budget rule.
To delete a project budget transaction, you must have edit access to the project budget group, and the project budget must not be approved or archived.
The API does not support project budget approvals.