Skip to main content
File specifications

Invoice spreadsheet file specifications - AP Exchange Data fields

Refer to the following table for invoice spreadsheet file specifications for AP Exchange Data, including field names, data types, and length limits, and field values:
Field name
Data type
Max length
Field value
AP Batch Date
Date
N/A
N/A
AP Batch Date and Time
Date Time
note
Time is displayed in 24 hour (Military Time) format as hh:mm. All times are captured in Pacific Standard Time.
N/A
N/A
AP Batch Run By
Last Name, First
255
N/A
AP Batch Time
Time
note
Time is displayed in 12 hour (Standard Time) format as hh:mm. All times are captured in Pacific Standard Time.
N/A
N/A
AP Batch Unique ID
Character
9
N/A
Number of Invoices
Number
N/A
N/A
Total - All Invoices - Approved
Number
N/A
N/A
Total - All Invoices - Billed
Number
N/A
N/A
Total - Credit Invoices Only - Approved
Number
N/A
N/A
Total - Credit Invoices Only - Billed
Number
N/A
N/A
Total - Debit Invoices Only - Approved
Number
N/A
N/A
Total - Debit Invoices Only - Billed
Number
N/A
N/A

This article applies to:

  • Product: Legal Tracker
  • Audiences: Firm