FinDatEx TPT Validation Reference (V8.0)

Spec: /spec/tpt/TPT_V8_20260526.xlsx
Manifest: /spec/tpt/tpt-v8-info.json
Released: 2026-05-26 · Sheet: TPT V8.0
Profiles: Solvency II (SOLVENCY_II), IORP / EIOPA / ECB (IORP_EIOPA_ECB), NW 675 (NW_675), SST (FINMA) (SST)

Generated file — do not edit by hand. Regenerate via mvn -pl core -Pdocs exec:java -Dexec.args="docs/rules".

1. How this validator scores your file

The overall quality score is a weighted blend of five sub-scores. Only Severity.ERROR findings lower the score; WARNING and INFO are reported but ignored by the scorer.

Findings are routed to dimensions by their rule-id prefix:

2. Profiles

Selecting a profile in the UI tells the validator to enforce the M (mandatory) and C (conditional) flags from that profile's column in the spec. Multiple profiles can be selected simultaneously — a field is mandatory if any selected profile says so.

3. General rules

The engines below run on every applicable field/row independently of the template-specific cross-field block in §4.

Version rule

• Rule ID: XF-15/TPT_VERSION
• Severity: ERROR (INFO if the version cell is absent)
• Expected token: V8.0
• Trigger: the version cell of the file does not contain the expected token.
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

Presence engine (PRESENCE/{numKey}/{profile})

• What it checks: for every FieldSpec flagged M for an active profile and applicable to the row's CIC, the cell value must be non-empty.
• Severity: ERROR.
• Score impact: Each missing cell lowers MANDATORY_COMPLETENESS (40 %) by 1 / total mandatory slots, and lowers the per-profile PROFILE_COMPLETENESS leg (10 %, M-weighted 0.7).
• Active rule instances: 94 (one per field × profile).

Conditional-presence engine (COND_PRESENCE/{numKey}/{profile})

• What it checks: for every FieldSpec flagged C for an active profile and whose CIC applicability matches the row's CIC, the cell value must be non-empty.
• Severity: WARNING.
• Score impact: Each missing cell lowers PROFILE_COMPLETENESS (10 %, C-weighted 0.3) by 1 / total conditional slots. Severity = WARNING — does not affect MANDATORY_COMPLETENESS or FORMAT_CONFORMANCE.
• Active rule instances: 84 (one per CIC-restricted field × profile).

Format engine (FORMAT/{numKey})

• What it checks: every populated cell is validated against its codification kind: ISO 4217 currency, ISO 3166-A2 country, ISO 8601 date, NACE, CIC 4-char, alphanumeric length, numeric, closed-list membership.
• Severity: ERROR.
• Score impact: Each ERROR lowers FORMAT_CONFORMANCE (20 %) by 1 / non-empty cells. Closed-list mismatches (message contains "closed list") instead lower CLOSED_LIST_CONFORMANCE (15 %) by 1 / populated closed-list cells.
• Active rule instances: 154 (one per field).

ISIN engine (ISIN/{code}/{type})

• What it checks: when the type cell is 1 (ISIN), the code cell must be a 12-character alphanumeric value with a valid ISO 6166 Luhn checksum.
• Severity: ERROR.
• Score impact: Each ERROR lowers FORMAT_CONFORMANCE (20 %) by 1 / non-empty cells.
• ISIN/14/15 — code field 14, type field 15
• ISIN/68/69 — code field 68, type field 69

LEI engine (LEI/{code}/{type})

• What it checks: when the type cell is 1 (LEI), the code cell must be a 20-character ISO 17442 LEI with the mod-97 checksum.
• Severity: ERROR.
• Score impact: Each ERROR lowers FORMAT_CONFORMANCE (20 %) by 1 / non-empty cells.
• LEI/47/48 — code field 47, type field 48
• LEI/50/51 — code field 50, type field 51
• LEI/81/82 — code field 81, type field 82
• LEI/84/85 — code field 84, type field 85
• LEI/115/116 — code field 115, type field 116
• LEI/119/120 — code field 119, type field 120
• LEI/140/141 — code field 140, type field 141

External validation (opt-in)

• Off by default. Operators enable it via the Settings dialog (desktop) or the FINDATEX_WEB_EXTERNAL_ENABLED env var (web).
• ISIN lookup (OpenFIGI): field 14 (when type field 15 = 1); field 68 (when type field 69 = 1)
• LEI lookup (GLEIF): field 47 (when type field 48 = 1); field 50 (when type field 51 = 1); field 81 (when type field 82 = 1); field 84 (when type field 85 = 1); field 115 (when type field 116 = 1); field 119 (when type field 120 = 1); field 140 (when type field 141 = 1)
• Score impact: External-validation findings are advisory and do not affect any score dimension.

4. Cross-field rules

Each rule below fires per row when its trigger condition holds and the expected target field state is violated. The score impact column applies to every individual finding the rule emits.

XF-01/COMPLETE_SCR_DELIVERY — When field 11 (CompleteSCRDelivery) is "Y", every SCR contribution field 97..105b must be populated.

• Severity: ERROR
• Trigger: Field 11 (CompleteSCRDelivery) = Y
• Required: All SCR contribution fields 97..105b must be present.
• Source field(s): 11
• Target field(s): 97, 98, 99, 100, 101, 102, 103, 104, 105, 105a, 105b
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-04/POSITION_WEIGHT_SUM — Σ field 26 (Position weight) across all positions must be ≈ 1.0 within ±0.02.

• Severity: WARNING
• Trigger: At least one position has a populated field 26
• Required: Σ field 26 (Position weight) must be ≈ 1.0 within ±0.02.
• Source field(s): 26
• Target field(s): 26
• Score impact: Severity = WARNING — surfaced in the report but not factored into the score (only ERROR severity feeds CROSS_FIELD_CONSISTENCY).

XF-05/CASH_PERCENTAGE — Declared cash ratio (field 9) must match Σ MarketValuePC of CIC xx7x positions divided by TotalNetAssets, within ±0.05.

• Severity: WARNING
• Trigger: Σ MarketValuePC of CIC xx7x positions / TotalNetAssets
• Required: Field 9 must match within ±0.05.
• Source field(s): 5, 24
• Target field(s): 9
• Score impact: Severity = WARNING — surfaced in the report but not factored into the score (only ERROR severity feeds CROSS_FIELD_CONSISTENCY).

XF-06/NAV_PRICE_SHARES — TotalNetAssets (field 5) must match SharePrice (field 8) × Shares (field 8b) within ±0.01 relative tolerance.

• Severity: WARNING
• Trigger: Fields 5, 8, 8b are all populated
• Required: Field 5 must equal field 8 × field 8b within ±0.01 relative tolerance.
• Source field(s): 8, 8b
• Target field(s): 5
• Score impact: Severity = WARNING — surfaced in the report but not factored into the score (only ERROR severity feeds CROSS_FIELD_CONSISTENCY).

XF-08/COUPON_FREQUENCY — Field 38 (Coupon payment frequency) must be one of {0, 1, 2, 4, 12, 52}.

• Severity: ERROR
• Trigger: Field 38 (Coupon payment frequency) is populated
• Required: Value must be one of {0, 1, 2, 4, 12, 52}.
• Source field(s): 38
• Target field(s): 38
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-09/CUSTODIAN_PAIR — Custodian identification code (field 140) and its type indicator (field 141) must be paired: filling one without the other is a finding.

• Severity: ERROR
• Trigger: Field 140 or field 141 is populated
• Required: Both fields 140 and 141 must be populated as a pair.
• Source field(s): 140, 141
• Target field(s): 140, 141
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-10/INTEREST_RATE_TYPE — When field 32 (interest-rate type) is Floating/Variable, fields 34..37 are mandatory; when Fixed, field 33 (Coupon rate) is mandatory.

• Severity: ERROR
• Trigger: Field 32 is Floating/Variable, or Fixed
• Required: Floating/Variable → fields 34..37 mandatory; Fixed → field 33 mandatory.
• Source field(s): 32
• Target field(s): 33, 34, 35, 36, 37
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-12/DATE_ORDER — Field 7 (Reporting date) must not precede field 6 (Valuation date).

• Severity: ERROR
• Trigger: Fields 6 and 7 are both populated
• Required: Field 7 (Reporting date) must not precede field 6 (Valuation date).
• Source field(s): 6, 7
• Target field(s): 7
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-11/MATURITY_AFTER_REPORTING — Field 39 (Maturity date) must not precede field 7 (Reporting date) on any row whose CIC matches the spec's field-39 applicability scope (CIC 1, 2, 5, 6, 7 sub-codes 3/4/5, 8, A, B, C, D, E, F).

• Severity: WARNING
• Trigger: Row CIC matches the field-39 applicability scope (CIC 1, 2, 5, 6, 7 sub-codes 3/4/5, 8, A, B, C, D, E, F) and field 39 is populated
• Required: Field 39 (Maturity date) must not precede field 7 (Reporting date).
• Source field(s): 7
• Target field(s): 39
• Score impact: Severity = WARNING — surfaced in the report but not factored into the score (only ERROR severity feeds CROSS_FIELD_CONSISTENCY).

XF-13/PIK — Field 146 (PIK) must be one of {0, 1, 2, 3, 4} and is meaningful only for bonds (CIC xx2x) and loans (CIC xx8x). Each PIK case mandates a specific subset of fields 32, 33, 38, 39, 40, 41 per the PIK guidelines.

• Severity: ERROR
• Trigger: Field 146 (PIK) is populated
• Required: Value must be one of {0,1,2,3,4} and case-specific fields must be present.
• Source field(s): 146
• Target field(s): 32, 33, 38, 39, 40, 41, 146
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-14/UNDERLYING_CIC — Field 67 (Underlying CIC) is mandatory whenever the spec's CIC applicability scope for field 67 covers the row's CIC — i.e. CIC 22, A, B, C, D4, D5, F. Other sub-codes within CIC 2 and CIC D are exempt.

• Severity: ERROR
• Trigger: Row CIC matches the field-67 applicability scope (CIC 22, A, B, C, D4, D5, F)
• Required: Field 67 (Underlying CIC) must be populated.
• Source field(s): 12
• Target field(s): 67
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-16/THIRD_CURRENCY_WEIGHT — Conditional presence of field 31

• Severity: ERROR
• Trigger: Field 29 is not blank
• Required: Field 31 must be non-empty.
• Source field(s): 29
• Target field(s): 31
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-17/INDEX_TYPE — Conditional presence of field 35

• Severity: ERROR
• Trigger: Field 34 is not blank
• Required: Field 35 must be non-empty.
• Source field(s): 34
• Target field(s): 35
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-17/INDEX_NAME — Conditional presence of field 36

• Severity: ERROR
• Trigger: Field 34 is not blank
• Required: Field 36 must be non-empty.
• Source field(s): 34
• Target field(s): 36
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-17/INDEX_MARGIN — Conditional presence of field 37

• Severity: ERROR
• Trigger: Field 34 is not blank
• Required: Field 37 must be non-empty.
• Source field(s): 34
• Target field(s): 37
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-18/CALL_PUT_DATE — Conditional presence of field 43

• Severity: ERROR
• Trigger: Field 42 ∈ [CAL, PUT]
• Required: Field 43 must be non-empty.
• Source field(s): 42
• Target field(s): 43
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-18/OPTION_DIRECTION — Conditional presence of field 44

• Severity: ERROR
• Trigger: Field 42 ∈ [CAL, PUT]
• Required: Field 44 must be non-empty.
• Source field(s): 42
• Target field(s): 44
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-19/STRIKE_PRICE — Conditional presence of field 45

• Severity: ERROR
• Trigger: Field 42 is not blank
• Required: Field 45 must be non-empty.
• Source field(s): 42
• Target field(s): 45
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-20/ISSUER_LEI_PRESENT — Conditional presence of field 47

• Severity: ERROR
• Trigger: Field 48 = "1"
• Required: Field 47 must be non-empty.
• Source field(s): 48
• Target field(s): 47
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-21/GROUP_LEI_PRESENT — Conditional presence of field 50

• Severity: ERROR
• Trigger: Field 51 = "1"
• Required: Field 50 must be non-empty.
• Source field(s): 51
• Target field(s): 50
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-22/UNDERLYING_GROUP_LEI — Conditional presence of field 84

• Severity: ERROR
• Trigger: Field 85 = "1"
• Required: Field 84 must be non-empty.
• Source field(s): 85
• Target field(s): 84
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-23/FUND_ISSUER_LEI — Conditional presence of field 115

• Severity: ERROR
• Trigger: Field 116 = "1"
• Required: Field 115 must be non-empty.
• Source field(s): 116
• Target field(s): 115
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-24/FUND_GROUP_LEI — Conditional presence of field 119

• Severity: ERROR
• Trigger: Field 120 = "1"
• Required: Field 119 must be non-empty.
• Source field(s): 120
• Target field(s): 119
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

XF-25/COLLATERAL_VALUE — Conditional presence of field 139

• Severity: ERROR
• Trigger: Field 138 ∈ [1, 2, 3]
• Required: Field 139 must be non-empty.
• Source field(s): 138
• Target field(s): 139
• Score impact: Each ERROR lowers CROSS_FIELD_CONSISTENCY (15 %) by 1 / max(distinct cross-field rules × rows, 1).

Field reference

One page per field, with its flag in every profile, the codification it must match and every rule that can fire on it.

• Field 11_Portfolio_identifying_data
• Field 22_Type_of_identification_code_for_the_fund_share_or_portfolio
• Field 33_Portfolio_name
• Field 44_Portfolio_currency_(B)
• Field 55_Net_asset_valuation_of_the_portfolio_or_the_share_class_in_portfolio_currency
• Field 66_Valuation_date
• Field 77_Reporting_date
• Field 88_Share_price
• Field 8b8b_Total_number_of_shares
• Field 99_Cash_ratio
• Field 1010_Portfolio_modified_duration
• Field 1111_Complete_SCR_delivery
• Field 1212_CIC_code_of_the_instrument
• Field 1313_Economic_zone_of_the_quotation_place
• Field 1414_Identification_code_of_the_instrument
• Field 1515_Type_of_identification_code_for_the_instrument
• Field 1616_Grouping_code_for_multiple_leg_instruments
• Field 1717_Instrument_name
• Field 17b17b_Asset_liability
• Field 1818_Quantity
• Field 1919_Nominal_amount
• Field 2020_Contract_size_for_derivatives
• Field 2121_Quotation_currency_(A)
• Field 2222_Market_valuation_in_quotation_currency_(A)
• Field 2323_Clean_market_valuation_in_quotation_currency_(A)
• Field 2424_Market_valuation_in_portfolio_currency_(B)
• Field 2525_Clean_market_valuation_in_portfolio_currency_(B)
• Field 2626_Valuation_weight
• Field 2727_Market_exposure_amount_in_quotation_currency_(A)
• Field 2828_Market_exposure_amount_in_portfolio_currency_(B)
• Field 2929_Market_exposure_amount_for_the_3rd_quotation_currency_(C)
• Field 3030_Market_exposure_in_weight
• Field 3131_Market_exposure_for_the_3rd_currency_in_weight_over_NAV
• Field 3232_Interest_rate_type
• Field 3333_Coupon_rate
• Field 3434_Interest_rate_reference_identification
• Field 3535_Identification_type_for_interest_rate_index
• Field 3636_Interest_rate_index_name
• Field 3737_Interest_rate_margin
• Field 3838_Coupon_payment_frequency
• Field 3939_Maturity_date
• Field 4040_Redemption_type
• Field 4141_Redemption_rate
• Field 4242_Callable_putable
• Field 4343_Call_put_date
• Field 4444_Issuer_bearer_option_exercise
• Field 4545_Strike_price_for_embedded_(call_put)_options
• Field 4646_Issuer_name
• Field 4747_Issuer_identification_code
• Field 4848_Type_of_identification_code_for_issuer
• Field 4949_Name_of_the_group_of_the_issuer
• Field 5050_Identification_of_the_group
• Field 5151_Type_of_identification_code_for_issuer_group
• Field 5252_Issuer_country
• Field 5353_Issuer_economic_area
• Field 5454_Economic_sector
• Field 5555_Covered_not_covered
• Field 5656_Securitisation
• Field 5757_Explicit_guarantee_by_the_country_of_issue
• Field 5858_Subordinated_debt
• Field 58b58b_Nature_of_the_tranche
• Field 5959_Credit_quality_step
• Field 6060_Call_Put_Cap_Floor
• Field 6161_Strike_price
• Field 6262_Conversion_factor_(convertibles)_concordance_factor_parity_(options)
• Field 6363_Effective_date_of_instrument
• Field 6464_Exercise_type
• Field 6565_Hedging_rolling
• Field 6767_CIC_of_the_underlying_asset
• Field 6868_Identification_code_of_the_underlying_asset
• Field 6969_Type_of_identification_code_for_the_underlying_asset
• Field 7070_Name_of_the_underlying_asset
• Field 7171_Quotation_currency_of_the_underlying_asset_(C)
• Field 7272_Last_valuation_price_of_the_underlying_asset
• Field 7373_Country_of_quotation_of_the_underlying_asset
• Field 7474_Economic_area_of_quotation_of_the_underlying_asset
• Field 7575_Coupon_rate_of_the_underlying_asset
• Field 7676_Coupon_payment_frequency_of_the_underlying_asset
• Field 7777_Maturity_date_of_the_underlying_asset
• Field 7878_Redemption_profile_of_the_underlying_asset
• Field 7979_Redemption_rate_of_the_underlying_asset
• Field 8080_Issuer_name_of_the_underlying_asset
• Field 8181_Issuer_identification_code_of_the_underlying_asset
• Field 8282_Type_of_issuer_identification_code_of_the_underlying_asset
• Field 8383_Name_of_the_group_of_the_issuer_of_the_underlying_asset
• Field 8484_Identification_of_the_group_of_the_underlying_asset
• Field 8585_Type_of_the_group_identification_code_of_the_underlying_asset
• Field 8686_Issuer_country_of_the_underlying_asset
• Field 8787_Issuer_economic_area_of_the_underlying_asset
• Field 8888_Explicit_guarantee_by_the_country_of_issue_of_the_underlying_asset
• Field 8989_Credit_quality_step_of_the_underlying_asset
• Field 9090_Modified_duration_to_maturity_date
• Field 9191_Modified_duration_to_next_option_exercise_date
• Field 9292_Credit_sensitivity
• Field 9393_Sensitivity_to_underlying_asset_price_(delta)
• Field 9494_Convexity_gamma_for_derivatives
• Field 94b94b_Vega
• Field 9595_Identification_of_the_original_portfolio_for_positions_embedded_in_a_fund
• Field 9797_SCR_mrkt_IR_up_weight_over_NAV
• Field 9898_SCR_mrkt_IR_down_weight_over_NAV
• Field 9999_SCR_mrkt_eq_type1_weight_over_NAV
• Field 100100_SCR_mrkt_eq_type2_weight_over_NAV
• Field 101101_SCR_mrkt_prop_weight_over_NAV
• Field 102102_SCR_mrkt_spread_bonds_weight_over_NAV
• Field 103103_SCR_mrkt_spread_structured_weight_over_NAV
• Field 104104_SCR_mrkt_spread_derivatives_up_weight_over_NAV
• Field 105105_SCR_mrkt_spread_derivatives_down_weight_over_NAV
• Field 105a105a_SCR_mrkt_FX_up_weight_over_NAV
• Field 105b105b_SCR_mrkt_FX_down_weight_over_NAV
• Field 106106_Asset_pledged_as_collateral
• Field 107107_Place_of_deposit
• Field 108108_Participation
• Field 110110_Valorisation_method
• Field 111111_Value_of_acquisition
• Field 112112_Credit_rating
• Field 113113_Rating_agency
• Field 114114_Issuer_economic_area
• Field 115115_Fund_issuer_code
• Field 116116_Fund_issuer_code_type
• Field 117117_Fund_issuer_name
• Field 118118_Fund_issuer_sector
• Field 119119_Fund_issuer_group_code
• Field 120120_Fund_issuer_group_code_type
• Field 121121_Fund_issuer_group_name
• Field 122122_Fund_issuer_country
• Field 123123_Fund_CIC
• Field 123a123a_Fund_custodian_country
• Field 124124_Duration
• Field 125125_Accrued_income_(Security Denominated Currency)
• Field 126126_Accrued_income_(Portfolio Denominated Currency)
• Field 127127_Bond_floor_(convertible_instrument_only)
• Field 128128_Option_premium_(convertible_instrument_only)
• Field 129129_Valuation_yield
• Field 130130_Valuation_z_spread
• Field 131131_Underlying_asset_category
• Field 132132_Infrastructure_investment
• Field 133133_custodian_name
• Field 134134_type1_private_equity_portfolio_eligibility
• Field 135135_type1_private_equity_issuer_beta
• Field 137137_Counterparty_sector
• Field 138138_Collateral_eligibility
• Field 139139_Collateral_Market_valuation_in_portfolio_currency
• Field 140140_Custodian_identification_code
• Field 141141_Type_of_custodian_identification_code
• Field 142142_Bail-in_Rule
• Field 143143_Maturity_date_expected
• Field 144144_Modified_duration_to_maturity_date_expected
• Field 145145_Credit_sensitivity_expected
• Field 146146_PIK
• Field 147147_Infrastructure_investment_additional_QRT
• Field 148148_Economic_sector_NACE
• Field 150150_LTEI_Fund_Elligibility
• Field 151151_Legislative_program_investment
• Field 10001000_TPT_Version