Mapping Sub Fields

The fields in this grid relate to the fields in the Mapping Fields grid. When you select a row in the Mapping Fields grid, any associated sub fields are displayed in the Mapping Sub Fields grid.

• Mapping ID - The mapping ID is displayed.
• Group - The name of the group is displayed.
• Field Number - The field number is displayed.
• Sub field Number - The sub field number is displayed.
• Field Label - The field label is displayed.
• Field Name - The field name is displayed.
• Column Name - The column name is displayed.
• Starting Position - Use if the sub-field is to be based on a position in the primary field, otherwise use a parse string to indicate the starting point of the sub-field.
• Ending Position - Use if the sub-field is to be based on a position in the primary field, otherwise use the size to indicate the ending point of the sub-field.
• Is Amount - This indicates that this is an amount field having the number of decimals appear according to how the bank defines the decimal places. A typical use would have 10.00 appear as 1000 with implied decimals as 2 places.
• Is Date - Select this field if you are defining a date field. The date must be in the bank’s format, and the format must be acceptable for the database.
• Code List Type - This is a viable type for the EFT Type and Format Type.
• Value Conversion ID - Conversion required to change the bank statement record into an Infor SyteLine accepted record.
• Parse String - This is the beginning string of a parsed field. For example PaymentType: "Customer" would indicate that this is a customer type record. Not applicable if starting and ending position is defined.
• Size - This is the number of characters used to define the Parse String. PaymentType: would need a minimum of 8 characters to represent "Customer". Not applicable if starting and ending position is defined.