Skip to main content
File specifications

Invoice spreadsheet file specifications - Invoice Data (part 1) fields

Refer to the following table for invoice spreadsheet file specifications for Invoice Data (part 1), including field names, data types, and length limits, and field values:
Field name
Data type
Max length
Field value
Date of Invoice
Date of Invoice
Date
N/A
Invoice Currency
Currency
note
Codes are according to ISO 4217
Character
3
Invoice Number
Character
128
N/A
Number of Allocations
Number
N/A
N/A
Other Invoice Amounts - Adjustment to Expenses
Currency
note
This is the company's adjustment to expenses
N/A
N/A
Other Invoice Amounts - Adjustment to Fees
Currency
note
This is the company's adjustment to fees
N/A
N/A
Other Invoice Amounts - Adjustment to Tax
Currency
note
This is the company's adjustment to VAT
N/A
N/A
Other Invoice Amounts - Amount of Expenses Paid by 3rd Party
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Amount of Fees Paid by 3rd Party
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Amount of Tax paid by 3rd Party
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Approved Expenses
Currency
N/A
N/A
Other Invoice Amounts - Approved Fees
Currency
N/A
N/A
Other Invoice Amounts - Approved Tax
Currency
N/A
N/A
Other Invoice Amounts - Billed Expenses
Currency
N/A
N/A
Other Invoice Amounts - Billed Fees
Currency
N/A
N/A
Other Invoice Amounts - Billed Tax
Currency
N/A
N/A
Other Invoice Amounts - Discount to Expenses
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Discount to Fees
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Discount to Tax
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Expenses Withheld
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Fees Withheld
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Other Invoice Amounts - Tax Withheld
Currency
note
Always 0. This will be used in a future release.
N/A
N/A
Row Number
Number
N/A
N/A
Total Approved
Total Approved
Currency
N/A
Tracker Invoice ID
Character
N/A
N/A

This article applies to:

  • Product: Legal Tracker
  • Audiences: Company