Revenue_recognition_transaction

A revenue recognition transaction [Revenue_recognition_transaction] is a transaction created based on a revenue recognition rule.

—	XML	SOAP	REST	Database table
Object	`Revenue_recognition_transaction`	`oaRevenue_recognition_transaction`	—	`revenue_recognition_transaction`
Supported Commands	`Add`, `Read`, `Modify`	`add()`, `read()`, `modify()`, `upsert()`	—	—

—

XML

SOAP

REST

Database table

Object

Revenue_recognition_transaction

oaRevenue_recognition_transaction

—

revenue_recognition_transaction

Supported Commands

Add, Read, Modify

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

—

The Revenue_recognition_transaction object has the following standard properties:

Note:

Revenue_recognition_transaction object properties may also include custom fields. The object type supports the custom equal to read method and the enable_custom read attribute.

XML / SOAP	Database	Description
`acct_code`	`acct_code`	Optional accounting system code for integration with external accounting systems.
`acct_date`	`acct_date`	The accounting period date of the transaction. See Date Fields.
`agreementid`	`agreement_id`	The ID of the associated agreement.
`categoryid`	`category_id`	The ID of the associated category.
`category_<N>id` where `<N>` is an integer from `1` to `5`	`category_<N>_id` where `<N>` is an integer from `1` to `5`	The ID of the associated `category_<N>`. Mutually exclusive with project_task_id.
`cost_center_id`	`cost_center_id`	The ID of the associated cost center.
`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`	The ID of the associated customer.
`customerpo_id`	`customerpo_id`	The ID of the associated customerpo.
`date`	`date`	The date of the transaction. See Date Fields.
`decimal_hours`	—	The number of decimal hours.
`hour`	`hour`	The number of hours for a T type.
`id`	`id`	[Read-only] Unique ID. Automatically assigned by SuiteProjects Pro.
`is_from_open_stage`	`is_from_open_stage`	A 1/0 field indicating that the revenue recognition transaction was added to the revenue container from the virtual open stage, otherwise the transaction was added through revenue container revenue_recognition_transaction generation logic. If revenue_container_id is zero, revenue_stage_id should be 0 and is_from_open_stage should be 0.
`job_codeid`	`job_code_id`	The ID of the associated job code.
`minute`	`minute`	The number of minutes for a T type.
`notes`	`notes`	Notes associated with this revenue recognition transaction.
`offsetsid`	`offsets_id`	The ID of the revenue_recognition_transaction which this revenue_recognition_transaction offsets.
`originatingid`	`originating_id`	The ID of the originating revenue_recognition_transaction forthis revenue_recognition_transaction.
`percent_complete`	`percent_complete`	[Read-only] The calculated percent complete value if it is a type P transaction.
`portfolio_projectid`	`portfolio_project_id`	The ID of the associated portfolio project
`project_billing_ruleid`	`project_billing_rule_id`	The ID of the associated project billing rule.
`project_taskid`	`project_task_id`	The ID of the associated project task.
`projectid`	`project_id`	The ID of the associated project.
`rate`	`rate`	The hourly rate for a T type. Dated by the date field.
`recognition_type`	`recognition_type`	Recognition type: R -revenue C -cost O -other
`revenue_containerid`	`revenue_container_id`	The ID of the associated revenue_container once posted.
`revenue_recognition_ruleid`	`revenue_recognition_rule_id`	The ID of the associated rule.
`revenue_stageid`	`revenue_stage_id`	The ID of the associated revenue stage.
`slipid`	`slip_id`	The ID of the associated slip.
`taskid`	`task_id`	The ID of the associated task.
`ticketid`	`ticket_id`	The ID of the associated ticket.
`total`	`total`	The amount of the transaction. Dated by the date field.
`type`	`type`	The type of the transaction. Matches the type field in revenue_recognition_rule.
`updated`	`updated`	[Read-only] Time the record was last updated or modified. See Date Fields.
`userid`	`user_id`	The ID of the associated user.

XML / SOAP

Database

Description

acct_code

Optional accounting system code for integration with external accounting systems.

acct_date

The accounting period date of the transaction. See Date Fields.

agreementid

agreement_id

The ID of the associated agreement.

categoryid

category_id

The ID of the associated category.

category_<N>id where <N> is an integer from 1 to 5

category_<N>_id where <N> is an integer from 1 to 5

The ID of the associated category_<N>. Mutually exclusive with project_task_id.

cost_center_id

The ID of the associated cost center.

created

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

currency

Currency for the money fields in the record.

customerid

customer_id

The ID of the associated customer.

customerpo_id

The ID of the associated customerpo.

date

The date of the transaction. See Date Fields.

decimal_hours

—

The number of decimal hours.

hour

The number of hours for a T type.

id

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

is_from_open_stage

A 1/0 field indicating that the revenue recognition transaction was added to the revenue container from the virtual open stage, otherwise the transaction was added through revenue container revenue_recognition_transaction generation logic. If revenue_container_id is zero, revenue_stage_id should be 0 and is_from_open_stage should be 0.

job_codeid

job_code_id

The ID of the associated job code.

minute

The number of minutes for a T type.

notes

Notes associated with this revenue recognition transaction.

offsetsid

offsets_id

The ID of the revenue_recognition_transaction which this revenue_recognition_transaction offsets.

originatingid

originating_id

The ID of the originating revenue_recognition_transaction forthis revenue_recognition_transaction.

percent_complete

[Read-only] The calculated percent complete value if it is a type P transaction.

portfolio_projectid

portfolio_project_id

The ID of the associated portfolio project

project_billing_ruleid

project_billing_rule_id

The ID of the associated project billing rule.

project_taskid

project_task_id

The ID of the associated project task.

projectid

project_id

The ID of the associated project.

rate

The hourly rate for a T type. Dated by the date field.

recognition_type

Recognition type:

R -revenue
C -cost
O -other

revenue_containerid

revenue_container_id

The ID of the associated revenue_container once posted.

revenue_recognition_ruleid

revenue_recognition_rule_id

The ID of the associated rule.

revenue_stageid

revenue_stage_id

The ID of the associated revenue stage.

slipid

slip_id

The ID of the associated slip.

taskid

task_id

The ID of the associated task.

ticketid

ticket_id

The ID of the associated ticket.

total

The amount of the transaction. Dated by the date field.

type

The type of the transaction. Matches the type field in revenue_recognition_rule.

updated

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

userid

user_id

The ID of the associated user.