Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

File specifications

Invoice spreadsheet file specifications - Matter Data fields

Refer to the following table for invoice spreadsheet file specifications for Matter Data, including field names, data types, and length limits, and field values:
Field name
Data type
Max length
Field value
Case No.
Character
100
N/A
Claim/Registration No.
Character
40
N/A
Client Number (vendor billing #)
Character
N/A
N/A
#2 Company Person
Character
255
N/A
Associated Matter Data
Character
50
N/A
Associated Matter ID
Character
50
N/A
Beginning-of-File Delimiter
Radio Button
N/A
No
 or
Yes
. If
Yes
, select a Delimiter and decide if it's on a separate line.
Beginning-of-Row Delimiter
Radio Button
N/A
No
 or
Yes
. If
Yes
, select a Delimiter.
Case No.
Character
100
N/A
Claim/Registration No.
Character
40
N/A
Tax Details - Client Tax ID
Number
N/A
N/A
Invoice Data (part 2) - Comments to Firm
Character
N/A
N/A
Constant - Constant
Character
50
N/A
Country (in Matter)
Character
100
N/A
Country (Invoice)
Character
100
N/A
Custom Field - Custom Currency Field #1
Currency
N/A
N/A
Custom Field - Custom Currency Field #10
Currency
N/A
N/A
Custom Field - Custom Currency Field #11
Currency
N/A
N/A
Custom Field - Custom Currency Field #2
Currency
N/A
N/A
Custom Field - Custom Currency Field #3
Currency
N/A
N/A
Custom Field - Custom Currency Field #4
Currency
N/A
N/A
Custom Field - Custom Currency Field #5
Currency
N/A
N/A
Custom Field - Custom Currency Field #6 (Closing)
Currency
N/A
N/A
Custom Field - Custom Currency Field #7
Currency
N/A
N/A
Custom Field - Custom Currency Field #8
Currency
N/A
N/A
Custom Field - Custom Currency Field #9
Currency
N/A
N/A
Custom Field - Custom Date Field #1
Date
N/A
N/A
Custom Field - Custom Date Field #10
Date
N/A
N/A
Custom Field - Custom Date Field #11
Date
N/A
N/A
Custom Field - Custom Date Field #2
Date
N/A
N/A
Custom Field - Custom Date Field #3
Date
N/A
N/A
Custom Field - Custom Date Field #4
Date
N/A
N/A
Custom Field - Custom Date Field #5 (Closing)
Date
N/A
N/A
Custom Field - Custom Date Field #6
Date
N/A
N/A
Custom Field - Custom Date Field #7
Date
N/A
N/A
Custom Field - Custom Date Field #8
Date
N/A
N/A
Custom Field - Custom Date Field #9
Date
N/A
N/A
Custom Field - Custom Dropdown Field #1
Character
N/A
N/A
Custom Field - Custom Currency Field #1
Currency
N/A
N/A
Custom Field - Custom Currency Field #10
Currency
N/A
N/A
Custom Field - Custom Currency Field #11
Currency
N/A
N/A
Custom Field - Custom Currency Field #2
Currency
N/A
N/A
Custom Field - Custom Currency Field #3
Currency
N/A
N/A
Custom Field - Custom Currency Field #4
Currency
N/A
N/A
Custom Field - Custom Currency Field #5
Currency
N/A
N/A
Custom Field - Custom Currency Field #6 (Closing)
Currency
N/A
N/A
Custom Field - Custom Currency Field #7
Currency
N/A
N/A
Custom Field - Custom Currency Field #8
Currency
N/A
N/A
Custom Field - Custom Currency Field #9
Currency
N/A
N/A
Custom Field - Custom Date Field #1
Date
N/A
N/A
Custom Field - Custom Date Field #10
Date
N/A
N/A
Custom Field - Custom Date Field #11
Date
N/A
N/A
Custom Field - Custom Date Field #2
Date
N/A
N/A
Custom Field - Custom Date Field #3
Date
N/A
N/A
Custom Field - Custom Date Field #4
Date
N/A
N/A
Custom Field - Custom Date Field #5 (Closing)
Date
N/A
N/A
Custom Field - Custom Date Field #6
Date
N/A
N/A
Custom Field - Custom Date Field #7
Date
N/A
N/A
Custom Field - Custom Date Field #8
Date
N/A
N/A
Custom Field - Custom Date Field #9
Date
N/A
N/A
Custom Field - Custom Dropdown Field #1
Character
N/A
N/A
Custom Field - Custom Dropdown Field #10
Character
N/A
N/A
Custom Field - Custom Dropdown Field #11
Character
N/A
N/A
Custom Field - Custom Dropdown Field #13
Character
N/A
N/A
Custom Field - Custom Dropdown Field #14
Character
N/A
N/A
Custom Field - Custom Dropdown Field #15
Character
N/A
N/A
Custom Field - Custom Dropdown Field #16 (Closing)
Character
N/A
N/A
Custom Field - Custom Dropdown Field #17
Character
N/A
N/A
Custom Field - Custom Dropdown Field #18
Character
N/A
N/A
Custom Field - Custom Dropdown Field #19
Character
N/A
N/A
Custom Field - Custom Dropdown Field #2
Character
N/A
N/A
Custom Field - Custom Dropdown Field #20
Character
N/A
N/A
Custom Field - Custom Dropdown Field #21
Character
N/A
N/A
Custom Field - Custom Dropdown Field #22
Character
N/A
N/A
Custom Field - Custom Dropdown Field #23
Character
N/A
N/A
Custom Field - Custom Dropdown Field #24
Character
N/A
N/A
Custom Field - Custom Dropdown Field #25
Character
N/A
N/A
Custom Field - Custom Dropdown Field #26
Character
N/A
N/A
Custom Field - Custom Dropdown Field #27
Character
N/A
N/A
Custom Field - Custom Dropdown Field #28
Character
N/A
N/A
Custom Field - Custom Dropdown Field #29
Character
N/A
N/A
Custom Field - Custom Dropdown Field #3
Character
N/A
N/A
Custom Field - Custom Dropdown Field #30
Character
N/A
N/A
Custom Field - Custom Dropdown Field #31
Character
N/A
N/A
Custom Field - Custom Dropdown Field #4
Character
N/A
N/A
Custom Field - Custom Dropdown Field #5
Character
N/A
N/A
Custom Field - Custom Dropdown Field #6
Character
N/A
N/A
Custom Field - Custom Dropdown Field #7
Character
N/A
N/A
Custom Field - Custom Dropdown Field #8
Character
N/A
N/A
Custom Field - Custom Dropdown Field #9
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #1
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #10
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #11
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #2
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #3
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #4
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #5
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #6 (Closing)
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #7
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #8
Character
N/A
N/A
Custom Field - Custom Multi-Pick List Field #9
Character
N/A
N/A
Custom Field - Custom Number Field #1
Number
N/A
N/A
Custom Field - Custom Number Field #10
Number
N/A
N/A
Custom Field - Custom Number Field #11
Number
N/A
N/A
Custom Field - Custom Number Field #2
Number
N/A
N/A
Custom Field - Custom Number Field #3
Number
N/A
N/A
Custom Field - Custom Number Field #4 (Closing)
Number
N/A
N/A
Custom Field - Custom Number Field #5
Number
N/A
N/A
Custom Field - Custom Number Field #6
Number
N/A
N/A
Custom Field - Custom Number Field #7
Number
N/A
N/A
Custom Field - Custom Number Field #8
Number
N/A
N/A
Custom Field - Custom Number Field #9
Number
N/A
N/A
Custom Field - Custom Text Area Field #1
Character
1000
N/A
Custom Field - Custom Text Area Field #2
Character
1000
N/A
Custom Field - Custom Text Area Field #3 (Closing)
Character
1000
N/A
Custom Field - Custom Text Field #1
Character
100
N/A
Custom Field - Custom Text Field #10
Character
100
N/A
Custom Field - Custom Text Field #11 (Closing)
Character
100
N/A
Custom Field - Custom Text Field #12
Character
100
N/A
Custom Field - Custom Text Field #13
Character
100
N/A
Custom Field - Custom Text Field #14
Character
100
N/A
Custom Field - Custom Text Field #15
Character
100
N/A
Custom Field - Custom Text Field #16
Character
100
N/A
Custom Field - Custom Text Field #17
Character
100
N/A
Custom Field - Custom Text Field #18
Character
100
N/A
Custom Field - Custom Text Field #19
Character
100
N/A
Custom Field - Custom Text Field #2
Character
100
N/A
Custom Field - Custom Text Field #20
Character
100
N/A
Custom Field - Custom Text Field #21
Character
100
N/A
Custom Field - Custom Text Field #3
Character
100
N/A
Custom Field - Custom Text Field #4
Character
100
N/A
Custom Field - Custom Text Field #5
Character
100
N/A
Custom Field - Custom Text Field #6
Character
100
N/A
Custom Field - Custom Text Field #7
Character
100
N/A
Custom Field - Custom Text Field #8
Character
100
N/A
Custom Field - Custom Text Field #9
Character
100
N/A
Custom Field - Custom Tiered Picklist #1
Character
N/A
N/A
Custom Field - Custom Tiered Picklist #2
Character
N/A
N/A
Custom Field - Custom Tiered Picklist #3
Character
N/A
N/A
Custom Field - Custom Tiered Picklist #4
Character
N/A
N/A
Custom Field - Custom Tiered Picklist #5
Character
N/A
N/A
Invoice Approval Route
Currency
50
N/A
Lead Company Person
Character
100
N/A
Matter Group
Character
35
N/A
Matter ID
Character
100
N/A
Matter Short Name
Character
100
N/A
Matter Tracker ID
Character
16
N/A
Matter Type (Template)
Character
N/A
N/A
Organizational Unit
Character
N/A
N/A
Practice Group
Character
N/A
N/A
State/Providence
Character
N/A
N/A
Substantive Law
Character
301
N/A

This article applies to:

  • Product: Legal Tracker
  • Audiences: Company