Expense Entry ASCII File Specification

Note

The use of the CSV format is preferred, however the ASCII format described here is an option.

Sequence
Field
Description
Rules

1 & alternating

Delimiter

The first character of each line will be the delimiter and each line item will be separated by a delimiter

REQUIRED - May be a forward slash "/" or CRLF  [Carriage Return/Line Feed]

2

User ID

User ID of person entering time as defined in Juris

REQUIRED - Max 4 characters or as defined in Define Fields

3

Client

Client Code as defined in Juris

REQUIRED - Max 12 characters or as defined in Define Fields

4

Matter

Matter code as defined in Juris

REQUIRED - Max 12 characters or as defined in Define Fields

5

Date

YYYYMMDD

REQUIRED

6

Expense Code

Expense code as defined in Juris

 

REQUIRED - MAX 4 Characters.

 

7

Summary Flag

Y or N

Optional:  Default will be Expense Code assignment.

8

Timekeeper

User ID of person entering item as defined in Juris

Optional unless Firm Options set to require Incurred By on Expense Entries.

9

Task Code

Task Code

Optional unless Matter set to Require Task Codes.

10

Expense Amount

Total amount of expense

REQUIRED

11

Description

Expense entry narrative description

REQUIRED:  Max 7500 characters

12

Double Delimiter

Each expense entry will end with a double delimiter

REQUIRED - May be a / or Carriage Return/Line Feed

 

EXAMPLES of ASCII format output:

/smgr/0100/1/19990115/del/n/jam//50.00/Delivery Expense.//

 

/smgr/0100/1/19990115/copy/n/jam//10.00/Copying Expense.//