Track Time Body Fields
The following table describes some of the body fields available for mapping when you create a new track time record using the CSV Import Assistant.
|
Field |
Notes |
Required? |
|---|---|---|
|
Date |
The posting date of the transaction. Note that the date value should be specified according to the NetSuite formatting preferences of the person doing the import. You can view this preference at Home > Set Preferences. |
Yes, but if you do not include a date, the system creates a default mapping to today’s date. |
|
Duration |
The number of hours the employee worked. |
Yes |
|
Employee |
The employee ID of the person whose time is being logged. This value must point to an active employee listed at Lists > Employees > Employees. |
Yes |
|
External ID |
A unique identifier that can be used to update the record. |
No |
|
Location (if the Locations feature has been enabled) |
A location specified at Setup > Company > Locations. |
Yes |
Additional fields are also available. For details, see the SOAP Schema Browser’s time bill reference page. For information about using the SOAP Schema Browser, see SOAP Schema Browser.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.