Property file configuration

The Property file is located at:

SharedFolders/BatchClassIdentifier/lim/DocumentTypeName.DatatableName.properties

If this Property file does not exist, go to the Default.properties file located at:

SharedFolders/BatchClassIdentifier/lim/Default.properties

The following is the Property Files table with details:

MATCHING_ALGO_MAPPING

It should be defined in the order of priority. Its default value is:

part_number:Part
No,SEARCH_IN_DESC:part_number,item_description:Description,unit_price:Unit
Price

By default, matching is done on the basis of part number. If no match is found, then matching is done by searching part number of PO in invoice description. If still no match is found, the item descriptions are matched and lastly the unit price is matched.

It is defined as {name of po column:name of invoice column, …}.

SEARCH_IN_DESC:part_number: This defines that part_number of PO table should be
searched in description of invoice table for matching.

MAPPING_CONFIG

This property defines the name of PO column and the corresponding data table column. It is required for the copy purposes.

For example, if po_line column is a column name in PO table and PO Line is the corresponding column name in data table then it is defined as:

po_line:PO Line

Similarly, all columns are defined as comma separated.

MAPPING_CONFIG=part_number:Part
No,unit_price:Unit
Price,available_quantity:Quantity,item_description:Description,po_line:PO
Line

Property placeholder	Default value	Description	Allowed values	Comment
PO_TABLE	PO_CONFIGURATION	Name of the PO table in database.	The name of data base table.
PO_COLUMNS_TO_DISPLAY	All the PO column names	The names of all PO columns to display at the UI.	The names of all PO columns to display at the UI.	Column names are case sensitive.
INVOICE_COLUMNS_TO_DISPLAY	All the Invoice columns names.	The names of all invoice columns to display at the UI.	The names of all invoice columns to display at the UI.	Column names are case insensitive.
DLF_TO_DISPLAY_TOP	All Document Level Fields in a batch class.	The document level fields to be displayed at top panel. If this property contains field names that are also to be displayed at the bottom, then that fields are skipped.	The document level fields to be displayed at top panel.	Names are case insensitive.
DLF_TO_DISPLAY_BOTTTOM	Sub Total, Invoice Total, Tax	The document level fields to be displayed at bottom panel.	The document level fields to be displayed at bottom panel.	Names are case insensitive.
DLF_COMMENT	Comment	The comment document level field to add any comment in batch.xml in case no PO match is found.	The name of comment field configured in batch class.	This field is case insensitive.
PO_COLUMNS_FILTER	po_number	The name of PO table columns based on which PO results will be filtered.	The name of PO columns on which results should be filtered.	PO column names are case sensitive.
DLF_po_number	PO Number	The name of PO Number Document level field in batch class needed for executing search query.	The name of Document Level Field in batch class.	Property value is case insensitive.
PO_NUMBER	po_number	The name of PO number column in PO table.	The name of PO number column in PO table.	Property value is case sensitive.
MATCHING_ALGO_MAPPING	part_number, SEARCH_IN_DESC, item_description, unit_price	The priority based on which matching algorithm should be executed.
INVOICE_POLINE	PO Line	The name of PO Line column in data table needed for matching purposes.	The name of PO Line column in data table.	Property value is case insensitive.
PO_POLINE	po_line	The name of PO Line column in PO table needed for matching purposes.	The name of PO Line column in PO table.	Property value is case sensitive.
PO_QUANTITY	available_quantity	The name of available quantity column in PO table needed for matching purposes.	The name of available quantity column in PO table.	Property value is case sensitive.
PO_PRICE	unit_price	The name of unit price column in PO table needed for matching purposes.	The name of unit price column in PO table.	Property value is case sensitive.
INVOICE_QUANTITY	Quantity	The name of quantity column in data table needed for matching purposes.	The name of quantity column in data table.	Property value is case insensitive.
INVOICE_PRICE	Unit Price	The name of unit price column in data table needed for matching purpose.	The name of unit price column in data table.	Property value is case insensitive.
INVOICE_DESC	Description	The name of description column in data table needed for matching purposes.	The name of description column in data table.	Property value is case insensitive.
MAPPING_CONFIG	part_number,unit_price, available_quantity,item_description,po_line	The column in PO table which should be mapped to datatable column. Required for copy purposes.		Property value is case insensitive.
TOLERANCE	0	The allowable tolerance for 2 way matching.	Any positive integer value.
DLF_TOTAL	Invoice Total	The name of total document level field in batch class. Required in second phase.	The name of total document level field in batch class.	Property value is case insensitive.
DLF_SUB_TOTAL	Sub Total	The name of sub-total document level field in batch class. Required in second phase.	The name of sub-total document level field in batch class.	Property value is case insensitive.
FILTERABLE_PO_COLUMNS	part_number	Comma separated names of PO columns on which filters can be applied.	The name of PO columns.	PO column names are case sensitive.
DATASOURCE_NAME	jdbc/ephesoft	Name of data source from which PO configuration is retrieved.	Data source name	Data source name is case sensitive.

Property file configuration

Search results

Search tips