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 - Vendor Data fields

Refer to the following table for invoice spreadsheet file specifications for Vendor Data, including field names, data types, and length limits, and field values:
Field name
Data type
Max length
Field value
Lead Outside Counsel
Character
255
N/A
Office Vendor Number - Office Vendor Number
Character
note
You can select from the available vendor numbers defined by your company.
16
N/A
Vendor Name
Character
160
N/A
Vendor Name (short)
Character
30
N/A
Vendor Office Address - Vendor Billing City
Character
N/A
N/A
Vendor Office Address - Vendor Billing Country
Character
N/A
N/A
Vendor Office Address - Vendor Billing State/Providence
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 1 (Streets 1-6 fields contain firm's banking info)
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 2
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 3
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 4
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 5
Character
N/A
N/A
Vendor Office Address - Vendor Billing Street 6
Character
N/A
N/A
Vendor Office Address - Vendor Billing Zip/Postal Code
Character
N/A
N/A
Vendor Office Address - Vendor Office City
Character
N/A
N/A
Vendor Office Address - Vendor Office Country
Character
N/A
N/A
Vendor Office Address - Vendor Office State/Providence
Character
N/A
N/A
Vendor Office Address - Vendor Office Street 1
Character
N/A
N/A
Vendor Office Address - Vendor Office Street 2
Character
N/A
N/A
Vendor Office Address - Vendor Office Zip/Postal Code
Character
N/A
N/A
Vendor Office Name
Character
20
N/A
Vendor Office Tax ID
Character
note
This is the Vendor Tax ID by office.
16
N/A
Vendor Office Address – Vendor Office Street 1
Character
255
N/A
Vendor Office Address – Vendor Office Street 2
Character
255
N/A
Vendor Office Address – Vendor Office City
Character
100
N/A
Vendor Office Address - Vendor Office State/Province
Character
100
N/A
Vendor Office Address - Vendor Office Zip/Postal Code
Character
25
N/A
Vendor Office Address - Vendor Office Country
Character
30
N/A
Vendor Office Address - Vendor Billing Street 1
Character
150
N/A
Vendor Office Address - Vendor Billing Street 2
Character
150
N/A
Vendor Office Address - Vendor Billing Street 3
Character
150
N/A
Vendor Office Address - Vendor Billing Street 4
Character
150
N/A
Vendor Office Address - Vendor Billing Street 5
Character
150
N/A
Vendor Office Address - Vendor Billing Street 6
Character
150
N/A
Vendor Office Address - Vendor Billing City
Character
65
N/A
Vendor Office Address - Vendor Billing State/Province
Character
100
N/A
Vendor Office Address - Vendor Billing Zip/Postal Code
Character
25
N/A
Vendor Office Address - Vendor Billing Country
Character
100
N/A
Office Vendor Number - Office Vendor Number
Character
200
N/A

This article applies to:

  • Product: Legal Tracker
  • Audiences: Company