Kyriba

Explore the interactive ERD

Table & Field Reference

bank_branch

Column	Type	Keys
`uuid`	Unknown	PK
`bank_uuid`	Unknown	FK
`account_location`	Unknown
`address_city`	Unknown
`address_country_code`	Unknown
`address_country_uuid`	Unknown
`address_state`	Unknown
`address_street_1`	Unknown
`address_street_2`	Unknown
`address_zip_code`	Unknown
`attachments`	Unknown
`bic`	Unknown
`code`	Unknown
`contact`	Unknown
`cut_off_time`	Unknown
`description`	Unknown
`id_code`	Unknown
`interface_code`	Unknown
`last_update_date`	LocalDate
`responder_code`	Unknown
`service_name`	Unknown
`time_zone`	Unknown
`user_zone_1`	Unknown
`user_zone_2`	Unknown
`user_zone_3`	Unknown
`user_zone_4`	Unknown
`user_zone_5`	Unknown

attachment

Column	Type	Keys
`uuid`	Unknown	PK
`entity_type`	Unknown

attachment_file_id

Column	Type	Keys
`attachment_uuid`	Unknown	PK
`index`	Unknown	PK
`name`	Unknown
`uuid`	Unknown

data_permission_profile

Column	Type	Keys
`uuid`	Unknown	PK
`company_ownership_uuid`	Unknown	FK
`code`	Unknown
`company_ownership_code`	Unknown
`description`	Unknown

budget_code

Column	Type	Keys
`uuid`	Unknown	PK
`grouping_code_uuid`	Unknown	FK
`code`	Unknown
`description`	Unknown
`hide_in_list`	Unknown
`type`	Unknown

process_template

Column	Type	Keys
`uuid`	Unknown	PK
`can_admin_ownership`	Unknown
`can_launch_only_ownership`	Unknown
`can_use_ownership`	Unknown
`category`	Unknown
`code`	Unknown
`description`	Unknown
`display_by_default`	Unknown
`initialized_automatically`	Unknown
`interface_code`	Unknown
`launch_when_opening`	Unknown
`module`	Unknown
`type`	Unknown

document

Column	Type	Keys
`uuid`	Unknown	PK
`currency_uuid`	Unknown	FK
`on_behalf_of_uuid`	Unknown	FK
`payment_budget_code_uuid`	Unknown	FK
`payment_debit_account_uuid`	Unknown	FK
`third_party_uuid`	Unknown	FK
`action_id`	Unknown
`advance_amount`	Unknown
`advance_rate`	Unknown
`alternate_supplier_code`	Unknown
`amount`	Unknown
`approval_date`	Unknown
`attachments`	Unknown
`balance`	Unknown
`batch_id`	Unknown
`buyer_code`	Unknown
`buyer_description`	Unknown
`buyer_fees`	Unknown
`buyer_interest_amount`	Unknown
`buyer_interest_days`	Unknown
`buyer_interest_rate`	Unknown
`buyer_uuid`	Unknown
`created_by`	Unknown
`creation_date`	Unknown
`credit_note_status`	Unknown
`discrepancy_date`	Unknown
`dispute_reason_code`	Unknown
`due_date`	Unknown
`early_payment_reference`	Unknown
`executed_payment_amount`	Unknown
`executed_payment_date`	Unknown
`executed_payment_reference`	Unknown
`executed_payment_status`	Unknown
`executed_payment_transaction_number`	Unknown
`export_marker_1`	Unknown
`export_marker_2`	Unknown
`export_marker_3`	Unknown
`extended_due_date`	Unknown
`funder_status`	Unknown
`invoice_date`	Unknown
`last_modification_date`	Instant
`last_modified_by`	Unknown
`linked_reference`	Unknown
`next_approval`	Unknown
`on_behalf_of_code`	Unknown
`origin`	Unknown
`original_amount`	Unknown
`payment_budget_code_code`	Unknown
`payment_debit_account_code`	Unknown
`payment_due_date`	Unknown
`payment_method`	Unknown
`payment_priority`	Unknown
`prediction_last_model_training_date`	Unknown
`prediction_last_prediction_date`	Unknown
`prediction_payment_date`	Unknown
`reason_for_cancellation`	Unknown
`reference`	Unknown
`remark`	Unknown
`status`	Unknown
`supplier_reference`	Unknown
`type`	Unknown
`user_zone_1`	Unknown
`user_zone_2`	Unknown
`user_zone_3`	Unknown
`user_zone_4`	Unknown
`user_zone_5`	Unknown
`version`	Unknown

payment_file

Column	Type	Keys
`uuid`	Unknown	PK
`creation_date_time`	Unknown
`file_name`	Unknown
`last_ack_bank_ack`	Unknown
`last_ack_kyriba_ack`	Unknown
`last_ack_time`	Unknown
`next_action`	Unknown
`status`	Unknown

payment_transfer_status

Column	Type	Keys
`uuid`	Unknown	PK
`ack_info_last_ack`	Unknown
`ack_info_last_ack_time`	Instant
`ack_info_reason_code`	Unknown
`ack_info_reason_description`	Unknown
`file_name`	Unknown
`next_action`	Unknown
`reference`	Unknown
`remittance_2_batch_id`	Unknown
`remittance_2_status`	Unknown
`remittance_batch_id`	Unknown
`remittance_identifier_1`	Unknown
`remittance_identifier_2`	Unknown
`remittance_status`	Unknown
`repository_code`	Unknown
`repository_uuid`	Unknown
`status`	Unknown
`transaction_number`	Unknown

company_group

Column	Type	Keys
`uuid`	Unknown	PK
`leader_uuid`	Unknown	FK
`code`	Unknown
`counterparty`	Unknown
`description`	Unknown
`intermediary`	Unknown
`leader_code`	Unknown

data_permission_profile_permission

Column	Type	Keys
`uuid`	Unknown	PK
`data_permission_profile_uuid`	Unknown	PKFK
`code`	Unknown
`data_type`	Unknown
`permission_function`	Unknown
`permission_type`	Unknown
`subtype`	Unknown

bank

Column	Type	Keys
`uuid`	Unknown	PK
`default_group_uuid`	Unknown	FK
`parent_counterparty_uuid`	Unknown	FK
`third_party_uuid`	Unknown	FK
`attachments`	Unknown
`code`	Unknown
`contact`	Unknown
`counter_party_info`	Unknown
`country_code`	Unknown
`deal_identifier`	Unknown
`description`	Unknown
`external_code`	Unknown
`intercompany`	Unknown
`interface_code`	Unknown
`intermediary_info`	Unknown
`internal_counterparty`	Unknown
`last_update_date`	Unknown
`net_debit_and_credit_exposure`	Unknown
`net_settlements`	Unknown
`risk_tier_code`	Unknown
`risk_tier_uuid`	Unknown

data_permission_entity_type

Column	Type	Keys
`value`	Unknown	PK
`description`	Unknown

account_group

Column	Type	Keys
`uuid`	Unknown	PK
`pooling_account_uuid`	Unknown	FK
`code`	Unknown
`description`	Unknown
`pooling_account_code`	Unknown

data_permission_profile_entity

Column	Type	Keys
`uuid`	Unknown	PK
`data_permission_profile_uuid`	Unknown	PKFK
`code`	Unknown
`description`	Unknown

fraud_detection_transfer_screened_with_alert_alert

Column	Type	Keys
`index`	Unknown	PK
`fraud_detection_transfer_screened_with_alert_uuid`	Unknown	PKFK
`alert_uuid`	Unknown
`description`	Unknown
`status`	Unknown

fraud_detection_transfer_screened_with_alert

Column	Type	Keys
`uuid`	Unknown	PK
`screening_context`	Unknown

company

Column	Type	Keys
`uuid`	Unknown	PK
`default_group_uuid`	Unknown	FK
`address_country_code`	Unknown
`address_country_uuid`	Unknown
`business_identifier_other_identifier_type`	Unknown
`business_identifier_other_identifier_value`	Unknown
`business_identifier_txp`	Unknown
`code`	Unknown
`description_1`	Unknown
`description_2`	Unknown
`interface_code`	Unknown
`short_code`	Unknown

currency

Column	Type	Keys
`uuid`	Unknown	PK
`code`	Unknown
`delivery_float`	Unknown
`description`	Unknown
`hide_in_list`	Unknown
`number_of_decimals`	Unknown
`reference`	Unknown

supplier_user

Column	Type	Keys
`uuid`	Unknown	PK
`company_ownership_uuid`	Unknown	FK
`third_party_uuid`	Unknown	FK
`access_profile_code`	Unknown
`access_profile_uuid`	Unknown
`code`	Unknown
`company_ownership_code`	Unknown
`creation_date`	Unknown
`description_1`	Unknown
`email`	Unknown
`first_name`	Unknown
`interface_code`	Unknown
`last_name`	Unknown
`last_update_date`	Instant
`sso_identity`	Unknown
`system_administrator`	Unknown
`third_party_code`	Unknown

supplier_service_access

Column	Type	Keys
`uuid`	Unknown	PK
`company_ownership_uuid`	Unknown	FK
`third_party_uuid`	Unknown	FK
`buyer_code`	Unknown
`buyer_uuid`	Unknown
`dispute_management`	Unknown
`early_payment`	Unknown
`early_payment_automatic_early_payment`	Unknown
`early_payment_simulation_only`	Unknown
`invoice_auction`	Unknown
`invoice_discounting`	Unknown
`invoice_information`	Unknown
`maturity_payment`	Unknown

bank_balance_by_statement

Column	Type	Keys
`account_code`	Unknown	PK
`account_statement_identifier`	Unknown	PK
`balance_date`	LocalDate	PK
`balance_amount`	Unknown
`balance_currency_code`	Unknown
`last_known_balance_date`	Unknown

payment_transaction_summary_detail_accounting_information

Column	Type	Keys
`index`	Unknown	PK
`payment_transaction_summary_detail_end_to_end_id`	Unknown	PK
`issuer_account`	Unknown
`issuer_amount`	Unknown
`issuer_currency`	Unknown

payment_transaction_summary_detail_custom_field

Column	Type	Keys
`index`	Unknown	PK
`payment_transaction_summary_detail_end_to_end_id`	Unknown	PK
`name`	Unknown
`value`	Unknown

payment_transaction_summary_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`file_uuid`	Unknown	FK
`amount`	Unknown
`counterparty_bank_account_id`	Unknown
`counterparty_bank_identifier`	Unknown
`counterparty_name`	Unknown
`currency`	Unknown
`end_to_end_id`	Unknown
`file_name`	Unknown
`issuer_bank_account_id`	Unknown
`issuer_bank_identifier`	Unknown
`issuer_name`	Unknown
`reason_code`	Unknown
`reason_description`	Unknown
`remittance_info`	Unknown
`status_code`	Unknown
`status_last_ack`	Unknown
`status_last_ack_time`	Unknown
`status_uetr`	Unknown
`transaction_date`	Unknown

payment_file_log

Column	Type	Keys
`uuid`	Unknown	PK
`payment_file_uuid`	Unknown	PKFK
`log`	Unknown
`status`	Unknown

cash_balance_by_statement

Column	Type	Keys
`account_statement_identifier`	Unknown	PK
`balance_date`	LocalDate	PK
`amount`	Unknown
`currency_code`	Unknown
`date_type`	Unknown

early_payment_interest_term

Column	Type	Keys
`uuid`	Unknown	PK
`currency_uuid`	Unknown	FK
`ownership_company_uuid`	Unknown	FK
`third_party_category_uuid`	Unknown	FK
`third_party_uuid`	Unknown	FK
`buyer_code`	Unknown
`buyer_uuid`	Unknown
`created_by`	Unknown
`creation_date`	Unknown
`funder_code`	Unknown
`funder_uuid`	Unknown
`interest_bearer`	Unknown
`interest_calculation_method`	Unknown
`last_modification_date`	Unknown
`last_modified_by`	Unknown
`program_type`	Unknown
`version`	Unknown

cash_flow_code

Column	Type	Keys
`uuid`	Unknown	PK
`budget_code_uuid`	Unknown	FK
`code`	Unknown
`description`	Unknown
`hide_in_list`	Unknown
`type`	Unknown

user_group

Column	Type	Keys
`uuid`	Unknown	PK
`ownership_company_uuid`	Unknown	FK
`code`	Unknown
`description`	Unknown
`ownership_company_code`	Unknown

cash_flow

Column	Type	Keys
`uuid`	Unknown	PK
`account_uuid`	Unknown	FK
`budget_code_uuid`	Unknown	FK
`flow_amount_currency_uuid`	Unknown	FK
`flow_code_uuid`	Unknown	FK
`accounting_date`	Unknown
`actual_mode`	Unknown
`description`	Unknown
`flow_amount`	Unknown
`flow_id`	Unknown
`gl_status`	Unknown
`origin`	Unknown
`reference`	Unknown
`status`	Unknown
`transaction_date`	Unknown
`update_date_time`	Instant
`value_date`	Unknown

data_permission_entity

Column	Type	Keys
`uuid`	Unknown	PK
`data_permission_uuid`	Unknown	PKFK
`code`	Unknown

fraud_detection_transfer_to_be_screened

Column	Type	Keys
`uuid`	Unknown	PK
`counterparty_bank_account_currency_code`	Unknown	FK
`currency_code`	Unknown	FK
`fee_currency_code`	Unknown	FK
`ordering_customer_company_code`	Unknown	FK
`ordering_customer_default_group_code`	Unknown	FK
`payor_company_code`	Unknown	FK
`payor_default_group_code`	Unknown	FK
`additional_correspondent_account_id`	Unknown
`additional_correspondent_bic`	Unknown
`additional_correspondent_description_1`	Unknown
`additional_correspondent_description_2`	Unknown
`amount`	Unknown
`beneficiary_date`	Unknown
`beneficiary_name`	Unknown
`beneficiary_third_party_type`	Unknown
`correspondent_account_id`	Unknown
`correspondent_bic`	Unknown
`correspondent_description_1`	Unknown
`correspondent_description_2`	Unknown
`counterparty_address_country_code`	Unknown
`counterparty_bank_account_id`	Unknown
`counterparty_bank_identifier`	Unknown
`counterparty_name`	Unknown
`counterparty_name_2`	Unknown
`counterparty_third_party_type`	Unknown
`counterparty_type`	Unknown
`erp_approver`	Unknown
`fee_account_id`	Unknown
`fee_assessment`	Unknown
`ordering_customer_country_code`	Unknown
`payor_country_code`	Unknown
`reason_1`	Unknown
`reason_2`	Unknown
`reason_3`	Unknown
`reason_4`	Unknown
`screening_context`	Unknown
`transaction_code_code`	Unknown
`transaction_code_uuid`	Unknown
`transaction_date`	Unknown
`transaction_number`	Unknown
`transaction_type`	Unknown
`value_date`	Unknown
`version`	Unknown

user_detail

Column	Type	Keys
`uuid`	Unknown	PK
`company_ownership_uuid`	Unknown	FK
`data_permission_profile_uuid`	Unknown	FK
`access_profile_code`	Unknown
`access_profile_uuid`	Unknown
`active`	Unknown
`api_user`	Unknown
`can_modify_intercompany_cashflow_actual_value_date`	Unknown
`code`	Unknown
`company_ownership_code`	Unknown
`data_permission_profile_code`	Unknown
`description`	Unknown
`email`	Unknown
`first_name`	Unknown
`interface_code`	Unknown
`language_setting`	Unknown
`last_login_date`	Unknown
`last_name`	Unknown
`payment_administrator`	Unknown
`product_subscriptions_bundle`	Unknown
`system_administrator`	Unknown

cash_balance

Column	Type	Keys
`balance_date`	LocalDate	PK
`account_uuid`	Unknown	PKFK
`amount`	Unknown
`currency_code`	Unknown
`date_type`	Unknown

bank_balance

Column	Type	Keys
`account_code`	Unknown	PK
`balance_date`	LocalDate	PK
`account_uuid`	Unknown	PKFK
`balance_amount`	Unknown
`balance_currency_code`	Unknown
`last_known_balance_date`	Unknown
`statement_identifier`	Unknown

data_permission

Column	Type	Keys
`uuid`	Unknown	PK
`ownership_company_uuid`	Unknown	FK
`code`	Unknown
`description`	Unknown
`entity_type`	Unknown

bank_group

Column	Type	Keys
`uuid`	Unknown	PK
`leader_uuid`	Unknown	FK
`code`	Unknown
`counterparty`	Unknown
`description`	Unknown
`intermediary`	Unknown
`leader_code`	Unknown

third_party_category

Column	Type	Keys
`uuid`	Unknown	PK
`code`	Unknown
`description`	Unknown
`purpose`	Unknown
`version`	Unknown

third_party

Column	Type	Keys
`uuid`	Unknown	PK
`company_ownership_uuid`	Unknown	FK
`active_status`	Unknown
`address_country_code`	Unknown
`address_country_uuid`	Unknown
`business_identifier_other_identifier_type`	Unknown
`business_identifier_other_identifier_value`	Unknown
`code`	Unknown
`company_ownership_code`	Unknown
`creation_date`	Unknown
`name`	Unknown
`name_2`	Unknown
`update_date`	LocalDate

account

Column	Type	Keys
`uuid`	Unknown	PK
`bank_uuid`	Unknown	FK
`branch_uuid`	Unknown	FK
`company_uuid`	Unknown	FK
`currency_uuid`	Unknown	FK
`default_group_uuid`	Unknown	FK
`account_available_for_payments`	Unknown
`account_category_10_code`	Unknown
`account_category_10_uuid`	Unknown
`account_category_1_code`	Unknown
`account_category_1_uuid`	Unknown
`account_category_2_code`	Unknown
`account_category_2_uuid`	Unknown
`account_category_3_code`	Unknown
`account_category_3_uuid`	Unknown
`account_category_4_code`	Unknown
`account_category_4_uuid`	Unknown
`account_category_5_code`	Unknown
`account_category_5_uuid`	Unknown
`account_category_6_code`	Unknown
`account_category_6_uuid`	Unknown
`account_category_7_code`	Unknown
`account_category_7_uuid`	Unknown
`account_category_8_code`	Unknown
`account_category_8_uuid`	Unknown
`account_category_9_code`	Unknown
`account_category_9_uuid`	Unknown
`active_status`	Unknown
`attachments`	Unknown
`ban_code`	Unknown
`branch_description`	Unknown
`calendar_code`	Unknown
`calendar_uuid`	Unknown
`closed_account`	Unknown
`closing_date`	Unknown
`code`	Unknown
`company_code`	Unknown
`country_code`	Unknown
`creation_date`	Unknown
`default_group_code`	Unknown
`description`	Unknown
`description_2`	Unknown
`documents`	Unknown
`gl_account_code`	Unknown
`gl_account_uuid`	Unknown
`iban_code`	Unknown
`internal_account_code`	Unknown
`marker_1`	Unknown
`marker_2`	Unknown
`marker_3`	Unknown
`signatory_users`	Unknown
`statement_identifier`	Unknown
`status`	Unknown
`type`	Unknown
`update_date`	LocalDate
`zba_identifier`	Unknown