Rate Card Item

Name	Data Type	Import
created	DATE	—
currency	NOT_SET
current	NOT_SET
end	DATE
id	ID
job_code_id	ID
rate	NOT_SET
rate_card_id	ID
start	DATE
updated	DATE	—

Name

Data Type

Export

Import

created

DATE

Check mark

—

currency

NOT_SET

Check mark

current

NOT_SET

Check mark

end

DATE

Check mark

job_code_id

Check mark

rate

NOT_SET

Check mark

rate_card_id

Check mark

start

DATE

Check mark

updated

DATE

Check mark

—

The rate_card_item table includes historical rate card item information. To import current rate card item information, map the OpenAir field current to a constant set to 1 unless you have a matching field in your import CSV file.