Project Billing Transaction
|
Name |
Data Type |
Export |
Import |
|---|---|---|---|
|
agreementid |
ID |
|
|
|
categoryid |
ID |
|
|
|
cost |
DECIMAL |
|
|
|
cost_centerid |
ID |
|
|
|
created |
DATE |
|
— |
|
currency |
TEXT |
|
|
|
customerid |
ID |
|
|
|
customerpoid |
ID |
|
|
|
date |
DATE |
|
|
|
description |
TEXT |
|
|
|
hour |
DECIMAL |
|
|
|
id |
ID |
|
|
|
itemid |
ID |
|
|
|
job_codeid |
ID |
|
|
|
minute |
DECIMAL |
|
|
|
notes |
TEXT |
|
|
|
payroll_typeid |
ID |
|
|
|
project_billing_ruleid |
ID |
|
|
|
project_taskid |
ID |
|
|
|
projectid |
ID |
|
|
|
quantity |
DECIMAL |
|
|
|
rate |
DECIMAL |
|
|
|
slip_stage_id |
ID |
|
|
|
slipid |
ID |
|
|
|
taskid |
ID |
|
|
|
ticketid |
ID |
|
|
|
timetypeid |
ID |
|
|
|
total |
DECIMAL |
|
|
|
type |
CHAR |
|
|
|
um |
TEXT |
|
|
|
updated |
DATE |
|
— |
|
userid |
ID |
|
|
Guidelines
Import requires the Modify Project Billing Transaction Using OpenAir API feature enabled. Otherwise, the Integration Manager log shows "OA type Projectbillingtransaction failed to import. Error Code: 1; Error Description: Unknown Error". To enable the Modify Project Billing Transaction Using OpenAir API feature, contact OpenAir Customer Support