Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

COLUMN HEADER

FIELD DESCRIPTION

FORMAT

REQUIRED

JobNum

Job number the time entry applies to

Number

Yes

EmpNum

ID of the person the time entry belongs to. Use the same number used in the employee import

This can be found as the RefKey in employee settings if you no longer have the import file.

WorkBook Resource ID (WB Employee ID) can also be used in case the employee is created manually in WorkBook.

Example: if the WB employee ID = 578, then the value in this column will be WB#578.

Number & Letters

Yes

AId

Employee activity ID: Value must reference an activity ID that already exists in WorkBook.

Activities are created and managed via the settings module> price lists & activities > activities

Number

Yes

RegDate

Date the time entry should be registered to

Date
E.g. your local date format xx/xx/yy

Yes

HrsQty

Number of hours for time entry

Number

Yes

HrsCost

Hourly cost to the agency for this time entry

Number

Yes

HrsSale

Hourly sales/charge out rate for this time entry

Number

Yes

SupplementalDescr

A field to include the time entry description

Text

Postdate

Date the time entry should be posted

Date
E.g. your local date format xx/xx/yy

Yes

Journalno

To include in Finance use 0, to exclude from Finance use -1

Note

Talk to your WorkBook Consultant about what number to use

Number

Yes

RefRecId

Leave this field blank

Leave blank

No

IsBillable

Is the time entry billable?

Number

0 = No

1 = Yes

Yes

TaskRefKey

To assign the time entry to a specific task, use the tasks' reference key. This can be found on the individual task

Number

No

WBTaskId

To assign the time entry to a specific task, use the tasks' ID number. Go to task settings to find the ID

Number

No

Editable

Allow the time entry to be editable after the import

this only takes effect if it’s not imported with Journal -1

Number

0 = Not Editable

1 = Editable

Yes

ForApproval

Leave blank

Number

No

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
sorttitle
cqllabel in ( "import-clients" , "import-contacts" , "import-creditors" , "import-debtors" , "import-employees" , "import-suppliers" , "import-vendors" )