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 - Invoice Data (part 2)

Refer to the following table for invoice spreadsheet file specifications for Invoice Data (part 2), including field names, data types, and length limits, and field values:
Field name
Data type
Max length
Field value
Allocation Comments To AP
Character
N/A
N/A
Accounts Payable Route
Character
25
N/A
Active
Checkbox
None
No
 or
Yes
. If
Yes
, this format is available for use.
Approvers - Accounting Code Reviewer
Character
N/A
N/A
Approvers - Accounting Code Reviewer's Employee ID
Character
N/A
N/A
Approvers - Billing Guideline Approver's Comments
Character
N/A
N/A
Approvers - Billing Guideline Reviewer
Character
N/A
N/A
Approvers - Billing Guideline Reviewer's Employee ID
Character
N/A
N/A
Approvers - Final Approver
Character
100
Auto Approved if automatically approved
Approvers - Final Approver's Comments
Character
1000
N/A
Approvers - Final Approver's Employee ID
Character
N/A
N/A
Approvers - Level 1 Approver
Character
N/A
N/A
Approvers - Level 1 Approver's Comments
Character
N/A
N/A
Approvers - Level 1 Approver's Employee ID
Character
N/A
N/A
Approvers - Level 10 Approver
Character
N/A
N/A
Approvers - Level 10 Approver's Comments
Character
N/A
N/A
Approvers - Level 10 Approver's Employee ID
Character
N/A
N/A
Approvers - Level 2 Approver
Character
255
N/A
Approvers - Level 2 Approver's Comments
Character
1000
N/A
Approvers - Level 2 Approver's Employee ID
Character
50
N/A
Approvers - Level 3 Approver
Character
255
N/A
Approvers - Level 3 Approver's Comments
Character
1000
N/A
Approvers - Level 3 Approver's Employee ID
Character
50
N/A
Approvers - Level 4 Approver
Character
255
N/A
Approvers - Level 4 Approver's Comments
Character
1000
N/A
Approvers - Level 4 Approver's Employee ID
Character
50
N/A
Approvers - Level 5 Approver
Character
255
N/A
Approvers - Level 5 Approver's Comments
Character
1000
N/A
Approvers - Level 5 Approver's Employee ID
Character
50
N/A
Approvers - Level 6 Approver
Character
255
N/A
Approvers - Level 6 Approver's Comments
Character
1000
N/A
Approvers - Level 6 Approver's Employee ID
Character
50
N/A
Approvers - Level 7 Approver
Character
255
N/A
Approvers - Level 7 Approver's Comments
Character
1000
N/A
Approvers - Level 7 Approver's Employee ID
Character
50
N/A
Approvers - Level 8 Approver
Character
255
N/A
Approvers - Level 8 Approver's Comments
Character
1000
N/A
Approvers - Level 8 Approver's Employee ID
Character
50
N/A
Approvers - Level 9 Approver
Character
255
N/A
Approvers - Level 9 Approver's Comments
Character
1000
N/A
Approvers - Level 9 Approver's Employee ID
Character
50
N/A
Billed to Address - City
Character
100
N/A
Billed to Address - Client Name
Character
120
N/A
Billed to Address - Country
Character
100
N/A
Billed to Address - State/Province
Character
100
N/A
Billed to Address - Street 1
Character
255
N/A
Billed to Address - Street 2
Character
255
N/A
Billed to Address - Tax ID
Character
20
N/A
Billed to Address - Zip/Postal Code
Character
25
N/A
Billing Period End Date
Date
N/A
N/A
Billing Period Start Date
Date
N/A
N/A
Client Number (vendor billing #)
Character
20
N/A
Comments to firm
Character
1000
N/A
Date Approved
Date
N/A
N/A
Date Format
Dropdown
N/A
N/A
Date Invoice Posted
Date
N/A
N/A
Date of Invoice
Date
N/A
N/A
End-of-File Delimiter
Radio Button
N/A
N/A
End-of-Row Delimiter
Radio Button
N/A
N/A
File Extension
Character
N/A
N/A
File Format
Radio Button
N/A
N/A
Client Number (vendor billing #)
Character
N/A
N/A
Comments to Firm
Character
N/A
N/A
Date Approved
Date
N/A
N/A
Date Invoice Posted
Date
N/A
N/A
Invoice Document File Name
Character
255
N/A
Invoice Submitter
Character
20
N/A
Invoice Summary File Name
Character
N/A
N/A
Law Firm Matter Name
Character
35
N/A
Matter Number (vendor billing #)
Character
25
N/A
PO Number
Character
5000
N/A
Supporting Document File Name
Character
N/A
N/A
Type of Invoice
Character
12
N/A
Vendor Invoice Description/Comment
Character
5000
N/A

This article applies to:

  • Product: Legal Tracker
  • Audiences: Company