Input and output templates
Clear Purchase Document Template
Format: CSV, XLS, XLSX (In the case of XLS or XLSX, Clear will read only the first sheet in the file).
Template:
pagePurchase Document Line ObjectIn addition to the fields in the Clear PR template, we support up to 10 additional fields that can be ingested into Clear as custom fields (eg. Tax codes / ERP usernames/others).
Ingestion Error
Format: CSV (irrespective of the input file)
Template with Sample Data:
The template of the file will be the same as the input file. However, in addition to the columns in the input file, there will be 2 additional columns that have "No. of Errors" and "Error Message".
Reconciliation Result
Format: GZIP File
This file will be in JSON Lines format where each line in the file is a separate JSON object.
Sample File:
Vendor File
Format: GZIP File
Sample File:
Last updated