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()	—	—

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 OpenAir.
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.