Loaded Cost

Name

Data Type

Export

Import

cost

NOT_SET

Check mark

Check mark

created

DATE

Check mark

Check mark

currency

NOT_SET

Check mark

Check mark

current

NOT_SET

Check mark

Check mark

customerid

ID

Check mark

Check mark

end

DATE

Check mark

Check mark

external_id

TEXT

Check mark

Check mark

id

ID

Check mark

Check mark

lc_level

NOT_SET

Check mark

Check mark

project_taskid

ID

Check mark

Check mark

projectid

ID

Check mark

Check mark

start

DATE

Check mark

Check mark

updated

DATE

Check mark

Check mark

userid

ID

Check mark

Check mark

user_<field_name>

See User

Check mark

Guidelines

The loaded_cost table includes historical user loaded cost information. To import current user loaded cost information, map the OpenAir field current to a constant set to 1 unless you have a matching field in your import CSV file.