{
	"name": "form/nc/nc-bank/convert/bank-statement-definition-fi.json",
	"info": "see 4D xml_ASCII_IMPORT() for char_maps",
	"record_separator": "\r\n",
	"remove_double_space": true,
	"char_map": [
		{ "from": "{", "to": "ä" },
		{ "from": "[", "to": "Ä" },
		{ "from": "ï¿½", "to": "Ä" },
		{ "from": "|", "to": "ö" },
		{ "from": "\\", "to": "Ö" },
		{ "from": "]", "to": "Å" }
	],
	"char_map-not-in-use": [
		{ "from": "todo-this", "to": "å" },
		{ "from": "&amp;", "to": "&" },
		{ "from": "&lt;", "to": "<" },
		{ "from": "&gt;", "to": ">" },
		{ "from": "&quot;", "to": "\"" },
		{ "from": "&apos;", "to": "'" }
	],
	"definition": {
		"record_type": {
			"field": [{ "field": "type", "field_length": 3 }]
		},
		"T00": {
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T00" },
				{ "field_length": 3, "data_type": "number", "must_equal": 322 },
				{ "field": "version", "field_length": 3, "must_equal": "100" },
				{ "field": "account", "field_length": 14, "data_type": "alpha" },
				{
					"field": "statement_number",
					"field_length": 3,
					"data_type": "alpha"
				},
				{
					"field": "start_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				},
				{
					"field": "end_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				},
				{
					"field": "entry_date",
					"field_length": 10,
					"data_type": "timestamp",
					"format": "YYMMDDhhmm"
				},
				{ "field": "customer", "field_length": 17, "data_type": "alpha" },
				{
					"field": "start_balance_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				},
				{
					"field": "start_balance",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{
					"field": "record_count",
					"field_length": 6,
					"data_type": "number",
					"optional": true
				},
				{
					"field": "currency",
					"field_length": 3,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account_name",
					"field_length": 30,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account_limit",
					"field_length": 18,
					"data_type": "number",
					"decimals": 2,
					"optional": true
				},
				{ "field": "account_owner", "field_length": 35, "data_type": "alpha" },
				{ "field": "bank", "field_length": 40, "data_type": "alpha" },
				{
					"field": "bank_2",
					"field_length": 40,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info",
					"field_length": 30,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "iban",
					"field_length": 18,
					"data_type": "alpha",
					"optional": true
				},
				{ "field_length": 1 },
				{
					"field": "bic",
					"field_length": 11,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"T03": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T03" },
				{ "field_length": 3, "data_type": "number", "must_equal": 322 },
				{ "field": "version", "field_length": 3, "must_equal": "100" },
				{
					"field": "account",
					"field_length": 14,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "spare_1",
					"field_length": 15,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "entry_date",
					"field_length": 10,
					"data_type": "timestamp",
					"format": "YYMMDDhhmm",
					"optional": true
				},
				{
					"field": "customer",
					"field_length": 17,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "spare_2",
					"field_length": 25,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "record_count",
					"field_length": 6,
					"data_type": "number",
					"optional": true
				},
				{
					"field": "currency",
					"field_length": 3,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "spare_3",
					"field_length": 48,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account_owner",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank",
					"field_length": 40,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_2",
					"field_length": 40,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "spare_4",
					"field_length": 60,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"T10": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T10" },
				{ "field_length": 3, "data_type": "number", "must_equal": 188 },
				{ "field": "event_number", "field_length": 6, "data_type": "number" },
				{
					"field": "archive_id",
					"field_length": 18,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "entry_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				},
				{
					"field": "value_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD",
					"optional": true
				},
				{
					"field": "payment_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD",
					"optional": true
				},
				{
					"field": "event_type",
					"field_length": 1,
					"data_type": "alpha",
					"convert_value": {
						"1": "pano",
						"2": "otto",
						"3": "panon korjaus",
						"4": "oton korjaus",
						"9": "hylätty tapahtuma"
					}
				},
				{ "field": "event_code", "field_length": 3, "data_type": "alpha" },
				{
					"field": "event_info",
					"optional": true,
					"field_length": 35,
					"data_type": "alpha"
				},
				{
					"field": "amount",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{ "field": "receipt_code", "field_length": 1 },
				{ "field": "transmission_method", "field_length": 1 },
				{
					"field": "name",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "name_source",
					"field_length": 1,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account",
					"field_length": 14,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account_changed",
					"field_length": 1,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "reference",
					"field_length": 20,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "form",
					"field_length": 8,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "level",
					"field_length": 1,
					"data_type": "number",
					"optional": true
				}
			]
		},
		"T11": {
			"content_to": "T10",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T11" },
				{ "field_length": 3, "data_type": "number" },
				{ "field": "info_type", "field_length": 2, "data_type": "alpha" },
				{
					"field": "info",
					"data_type": "alpha",
					"field_definition": {
						"tag_start": "info_type_",
						"field": "info_type"
					}
				}
			]
		},
		"T30": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T30" },
				{ "field_length": 3, "data_type": "number", "must_equal": 71 },
				{ "field": "event_number", "field_length": 6, "data_type": "number" },
				{ "field": "archive_id", "field_length": 18, "data_type": "alpha" },
				{
					"field": "entry_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD",
					"optional": true
				},
				{
					"field": "info",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"T40": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T40" },
				{ "field_length": 3, "data_type": "number", "must_equal": 50 },
				{
					"field": "entry_date",
					"field_length": 6,
					"data_type": "timestamp",
					"format": "YYMMDD"
				},
				{
					"field": "balance",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{
					"field": "available_balance",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				}
			]
		},
		"T50": {
			"content_to": "T40",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T50" },
				{ "field_length": 3, "data_type": "number", "must_equal": 67 },
				{
					"field": "period",
					"field_length": 1,
					"data_type": "alpha",
					"convert_value": {
						"1": 1,
						"2": 2,
						"3": 3,
						"4": 4
					}
				},
				{
					"field": "period_date",
					"field_length": 6,
					"data_type": "timestamp",
					"format": "YYMMDD"
				},
				{ "field": "deposit_count", "field_length": 8, "data_type": "number" },
				{
					"field": "deposit",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{ "field": "withdraw_count", "field_length": 8, "data_type": "number" },
				{
					"field": "withdraw",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				}
			]
		},
		"T51": {
			"content_to": "T50",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T51" },
				{ "field_length": 3, "data_type": "number", "must_equal": 67 },
				{ "field": "period", "field_length": 1, "data_type": "alpha" },
				{
					"field": "period_date",
					"field_length": 6,
					"data_type": "timestamp",
					"format": "YYMMDD"
				},
				{ "field": "withdraw_count", "field_length": 8, "data_type": "number" },
				{
					"field": "withdraw",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{ "field": "deposit_count", "field_length": 8, "data_type": "number" },
				{
					"field": "deposit",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				}
			]
		},
		"T60": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T60" },
				{ "field_length": 3, "data_type": "number" },
				{ "field": "bank", "field_length": 3, "data_type": "alpha" },
				{ "field": "info", "data_type": "alpha" }
			]
		},
		"T70": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T70" },
				{ "field_length": 3, "data_type": "number" },
				{ "field": "bank", "field_length": 3, "data_type": "alpha" },
				{
					"field": "info",
					"data_type": "alpha",
					"field_definition": { "tag_start": "info_type_T70" }
				}
			]
		},
		"info_type_T70": {
			"info": "free info for T70",
			"field": [
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha"
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 80,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"T80": {
			"content_to": "T00",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T80" },
				{ "field_length": 3, "data_type": "number", "must_equal": 188 },
				{ "field": "event_number", "field_length": 6, "data_type": "number" },
				{
					"field": "archive_id",
					"field_length": 18,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "entry_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				},
				{
					"field": "value_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD",
					"optional": true
				},
				{
					"field": "payment_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD",
					"optional": true
				},
				{
					"field": "event_type",
					"field_length": 1,
					"data_type": "alpha",
					"convert_value": {
						"1": "pano",
						"2": "otto",
						"3": "panon korjaus",
						"4": "oton korjaus",
						"9": "hylätty tapahtuma"
					}
				},
				{ "field": "event_code", "field_length": 3, "data_type": "alpha" },
				{
					"field": "event_info",
					"optional": true,
					"field_length": 35,
					"data_type": "alpha"
				},
				{
					"field": "amount",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{ "field": "receipt_code", "field_length": 1 },
				{ "field": "transmission_method", "field_length": 1 },
				{
					"field": "name",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "name_source",
					"field_length": 1,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account",
					"field_length": 14,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "account_changed",
					"field_length": 1,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "reference",
					"field_length": 20,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "form",
					"field_length": 8,
					"data_type": "alpha",
					"optional": true
				},
				{ "field": "level", "field_length": 1, "data_type": "number" }
			]
		},
		"T81": {
			"info": "same as T11",
			"content_to": "T80",
			"field": [
				{ "field": "record_type", "field_length": 3, "must_equal": "T11" },
				{ "field_length": 3, "data_type": "number" },
				{ "field": "info_type", "field_length": 2, "data_type": "alpha" },
				{
					"field": "info",
					"data_type": "alpha",
					"field_definition": {
						"tag_start": "info_type_",
						"field": "info_type"
					}
				}
			]
		},
		"info_type_00": {
			"info": "free info for T11 and T81",
			"field": [
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha"
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "info_text",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_01": {
			"info": "event amount info for T11 and T81",
			"field": [{ "field": "event_count", "field_length": 8, "data_type": "number" }]
		},
		"info_type_02": {
			"info": "event amount info",
			"field": [
				{
					"field": "customer_number",
					"field_length": 10,
					"data_type": "alpha",
					"optional": true
				},
				{ "field_length": 1, "data_type": "alpha" },
				{ "field": "invoice_number", "field_length": 15, "data_type": "alpha" },
				{ "field_length": 1, "data_type": "alpha" },
				{
					"field": "invoice_date",
					"field_length": 6,
					"data_type": "date",
					"format": "YYMMDD"
				}
			]
		},
		"info_type_03": {
			"info": "card info",
			"field": [
				{ "field": "card_number", "field_length": 19, "data_type": "alpha" },
				{ "field_length": 1, "data_type": "alpha", "optional": true },
				{
					"field": "seller_archive_id",
					"field_length": 14,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_04": {
			"info": "correction event info",
			"field": [
				{
					"field": "original_archive_id",
					"field_length": 18,
					"data_type": "alpha"
				}
			]
		},
		"info_type_05": {
			"info": "currency event info",
			"field": [
				{
					"field": "event_amount",
					"field_length": 19,
					"data_type": "number",
					"decimals": 2
				},
				{ "field_length": 1, "data_type": "alpha", "optional": true },
				{ "field": "currency_id", "field_length": 3, "data_type": "alpha" },
				{ "field_length": 1, "data_type": "alpha", "optional": true },
				{
					"field": "currency_rate",
					"field_length": 11,
					"data_type": "number",
					"decimals": 7
				},
				{
					"field": "currency_reference",
					"field_length": 6,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_06": {
			"info": "client info",
			"field": [
				{
					"field": "client_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha"
				},
				{
					"field": "client_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_07": {
			"info": "bank info",
			"field": [
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha"
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "bank_info",
					"type": "array",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_08": {
			"info": "payment subject info",
			"field": [
				{
					"field": "payment_subject_code",
					"field_length": 3,
					"data_type": "alpha"
				},
				{ "field_length": 1, "data_type": "alpha", "optional": true },
				{ "field": "payment_subject", "field_length": 31, "data_type": "alpha" }
			]
		},
		"info_type_09": {
			"info": "receiver / payer info",
			"field": [
				{
					"field": "receiver_payer_name",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		},
		"info_type_11": {
			"info": "sepa info",
			"field": [
				{
					"field": "payer_reference",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "receiver_iban",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "receiver_bic",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "receiver_name",
					"field_length": 70,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "payer_name",
					"field_length": 70,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "payer_identifier",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				},
				{
					"field": "sepa_archive_id",
					"field_length": 35,
					"data_type": "alpha",
					"optional": true
				}
			]
		}
	}
}
