Projectbillingtransaction

A project billing transaction [Projectbillingtransaction] is a transaction created automatically based on a project billing rule.

Review the Usage Guidelines for the Projectbillingtransaction object.

XML

SOAP

REST

Database table

Object

Projectbillingtransaction

oaProjectbillingtransaction

project_billing_transaction

Supported Commands

Add, Read, Modify, Delete

See Usage Guidelines

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

See Usage Guidelines

The Projectbillingtransaction object has the following properties:

XML / SOAP

Database

Description

agreementid

agreement_id

ID of the associated agreement.

categoryid

category_id

The ID of the associated category.

cost

cost

The cost per unit of measure for an E type. The fixed price for an F type. Dated by the date field.

cost_centerid

cost_center_id

The ID of the associated cost center.

created

created

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

currency

currency

The 3–letter currency code for the project billing transaction currency. Defaults to the currency field in the associated project billing rule. Can be set to any currency specified in Administration > Global Settings > Organization > Currencies > Multi-currency (if multi-currency is enabled on your account).

customerid

customer_id

The ID of the associated customer.

customerpoid

customerpo_id

ID of the associated customerpo.

date

date

The date of the transaction. See Date Fields.

description

description

Description associated with billing rule transaction.

fulfillmentid

fulfillment_id

The ID of the associated fulfillment record.

hour

hour

The number of hours for a T type.

id

id

[Read-only] Unique ID. Automatically assigned by OpenAir.

itemid

item_id

The ID of the associated item.

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 project billing rule transaction.

payroll_typeid

payroll_type_id

The ID of the associated payroll type.

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.

quantity

quantity

The quantity for an E or P type.

rate

rate

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

slip_stage_id

slip_stage_id

The ID of the slip stage.

slipid

slip_id

The ID of slip that was created.

taskid

task_id

The ID of the associated task.

ticketid

ticket_id

The ID of the associated ticket.

timetypeid

timetype_id

The ID of the associated time type.

total

total

[Read-only] The total monetary value. Dated by the date field.

type

type

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

um

um

The unit of measure for an E or P type.

updated

updated

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

userid

user_id

The ID of the associated user.

Usage Guidelines

The Projectbillingtransaction object supports only the Read (XML API) and read() (SOAP API) commands by default. Your company's OpenAir account can be configured to allow add, modify, upsert and delete operations for project billing transactions using the API.