These settings control the CSV file output format. You can configure the system to output multiple CSV files per document.. Each row in the table represents the configuration for a single CSV file.

Index

The CSV file index.

Output File

If selected, the system attempts to output a CSV file according to the specified configuration settings.

Filepath

Specifies the location of an alternate export directory for the CSV file group.

If left blank, the main export directory set against the Transformation Server instance that carries out document export is used. If no export directory is configured against the Transformation Server instance, the default export directory configured in the Solution Configuration Manager > Export Settings > Export Options. If this value is blank, or a specified directory does not exist, the CSV file export fails.

Filename

The naming convention for the CSV file if it is output on a document-by-document basis. This can be set to URN. This names the file according to the component of the image filename mapped in Solution Configuration Manager > Global Settings > Import Settings. If left blank, or set to anything else, the filename is set to the same name as the document filename.

File Type

The file extension for the output file. If left blank, .CSV is used by default.

File Prefix

The file prefix for the output file.

Separator

The separator that is used in the CSV file line. Based on user input, the system automatically cleanses any extracted data using this separator. It does this in order to maintain a consistent number of columns in the output. Illegal separators include the period, forward slash, and a backslash.

The chosen separator must be entered manually in the format configuration for each format line and line item configuration parameter.

Date Format

The desired date output format. If no entry is made, the system defaults to the output date format configured in the Solution Configuration Manager > Profile Settings > Date Settings.

If no entry is available in either locations, the default value of "DDMMYYYY" is used.

Date Separator

The separator that is used in conjunction with the date format setting above.

For example, if the date format above is "MMDDYYYY" and a hyphen is entered as the separator in this parameter. If the extracted date is "2nd November 2009," then the output is "11-02-2009."

Invoice Type

The filter applied to the CSV file so that output is controlled by the Value Invoice Type field. If this value is set to PO, the CSV file is only written if the invoice type is PO. If this value is set to NPO, the CSV file is only written if the invoice type is NO-PO.

Output Image

If selected, the original document image is output to the same directory as the CSV file. The document image relates to the original image Filename and Filetype.

Format Line 1 - 5

This parameter controls the format of each row that is output to the CSV file. Up to five rows can be output per CSV file.

For example, to output the TIFF name, the invoice number (1234) and the vendor number (ABC) are separated by a colon. The setting should contain the following.

<%TNM>:<%INO>:<%VID>

This value produces the following:

myFile.tif:1234:ABC

Additional text can also be included in the format. For example,

File=<%TNM>|InvoiceNumber=<%INO>|Vendor ID=<%VID>

would produce the following:

File=myFile.tif|Invoice Number=1234|VendorID=ABC

The structure of output in the CSV file is presented by the following symbols:

• <%TNM>. The name of the original imported file without a file path.

• <%TNF>. The name of the original imported file without the file path or a file extension.

• <%TND>. The name of the original imported file with the export directory file path.

• <%SDT>. The scan date in the format configured in the Solution Configuration Manager > Profile Settings > Date Settings.

• <%BNM>. The batch name.

• <%EID>. The employee ID.

• <%EFN>. The employee first name.

• <%ELN>. The employee last name.

• <%DTP>. The document type, such as INVOICE or CREDIT.

• <%ITP>. The invoice type, such as PO or NO-PO.

• <%IDT>. The invoice date.

• <%INO>. The invoice number.

• <%TAX>. The invoice tax amount.

• <%WTX>. The invoice withholding tax amount.

• <%DCT>. The invoice discount amount.

• <%MSC>. The invoice miscellaneous charge amount.

• <%CUR>. The invoice currency.

• <%TOT>. The invoice total.

• <%PST>. The Provincial Sales Tax/QST amount.

• <%HST>. The Harmonized Sales Tax amount.

• <%ICM>. The ICMS tax amount.

• <%PON>. The PO Number.

• <%URN>. The unique Reference Number.

• <%VID>. The vendor ID.

• <%IVD>. The internal Vendor ID.

• <%SID>. The site ID.

• <%VNM>. The vendor name.

• <%BTO>. The bill-to name.

• <%CCO>. The company code.

• <%POR>. The Payment Order Reference Number (POR).

• <%PSN>. The Payment Order Subscriber Number.

• <%KID>. The Payment Reference.

• <%ACC>. The account Number.

• <%BAC>. The bank Account Number.

• <%BCD>. The bank Account Code.

• <%EXC>. The exchange Rate.

• <%IVR>. The invalid Reason.

• <%ICD>. The invalid Reason Code.

• <%LNK>. The Document Link.

• <%ERP>. The ERP document key.

• <%EPT>. The ERP system PO type.

• <%BSU>. The business unit.

• <%DEL>. The delivery note.

• <%DLD>. The delivery date.

• <%DUE>. The due date.

• <%ISR>. The ISR retention amount.

• <%IBN>. The IBAN number.

• <%BIC>. The BIC / Swift code.

• <%REF>. Your ref.

• <%CNC>. Mainland China VAT invoice code.

• <%CNP>. Mainland China VAT invoice password.

• <%VVT>. Vendor VAT registration number.

• <%BVT>. Bill-to VAT registration number.

• <%MXU>. Mexican UUID number.

Line Item

This parameter controls the format of line item entries that are output to the CSV file. If left blank, no line item detail is output. One row is added to the CSV file for each line item.

To output the PO number, the PO line item number, and the total, this parameter should be set as follows.

<%LPO>_<%LPL>_<%LTO>

The available literals are as follows.

• <%LNO>. The invoice line item number.

• <%LPO>. The PO number.

• <%LPL>. The PO line item.

• <%LDS>. The PO line description.

• <%LMN>. The material number.

• <%LMG>. The material group.

• <%LQT>. The quantity.

• <%LUM>. The order unit of measure.

• <%LUP>. The unit price.

• <%LPU>. The order price unit of measure.

• <%LQU>. The quantity in order price unit of measure.

• <%LTO>. The line item total.

• <%LTC>. The tax code.

• <%LTJ>. The tax jurisdiction code.

• <%LST>. The SAP condition type.

• <%LSS>. The SAP condition step number.

• <%LSC>. The SAP condition count.

• <%LFV>. The freight vendor ID.

• <%LGN>. The goods receipt document number.

• <%LGY>. The goods receipt document year.

• <%LGI>. The goods receipt document item number.

• <%LSN>. The service entry sheet number.

• <%LSI>. The service entry sheet item number.

• <%LSD>. The subsequent debit/credit indicator.

• <%LLT>. The line type.

• <%LCD>. The charge code.

• <%LCI>. The charge code ID.

• <%LDL>. The Invoice Processing Agility line item.

• <%LPT>. The plant.

• <%LTY>. The ERP purchase order type.

• <%LBU>. The ERP purchasing business unit.

• <%LCC>. The company Code.

• <%LTR>. The VAT/tax rate.