Coupa

Explore the interactive ERD

Table & Field Reference

country

Column	Type	Keys
`id`	Long	PK
`code`	String
`custom_fields`	Json
`name`	String

contract_type

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

approver

Column	Type	Keys
`id`	Long	PK
`approval_id`	Long	PKFK
`active`	Boolean
`approver_type`	String
`can_approve`	Boolean
`created_at`	Instant
`created_by_id`	Long
`description`	String
`mention_name`	String
`name`	String
`open`	Boolean
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

purchase_order_revision

Column	Type	Keys
`field_name`	String	PK
`purchase_order_revision_id`	Long	PK
`created_at`	Instant
`created_by`	Long
`exported`	Boolean
`from_value`	String
`last_exported_at`	Instant
`purchase_order_id`	Long
`revision`	Int
`to_value`	String

order_line_asset_tag_mapping

Column	Type	Keys
`asset_tag_id`	Long	PKFK
`order_line_id`	Long	PKFK

virtual_card_partner

Column	Type	Keys
`id`	Long	PK
`configuration`	String
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`issuing_bank`	String
`name`	String
`notes`	String
`payment_partner_type`	String
`support_contact_id`	Long
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

task

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`owner_id`	Long	FK
`resolved_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`description`	String
`due_date`	Instant
`duration`	Double
`linkable_id`	Long
`linkable_type`	String
`percentage`	Int
`resolved_at`	Instant
`start_date`	Instant
`status`	String
`task_id`	Long
`title`	String
`updated_at`	Instant

matching_allocation

Column	Type	Keys
`id`	Long	PK
`asn_line_id`	Long	FK
`inventory_transaction_id`	Long	FK
`invoice_line_id`	Long	FK
`order_line_id`	Long	FK
`uom_id`	Long	FK
`amount`	Double
`created_at`	Instant
`custom_fields`	Json
`inventory_transaction_match_reference`	String
`invoice_line_total`	Double
`manual_match`	Long
`quantity`	Double
`status`	String
`status_reason`	String
`updated_at`	Instant

order_header_change

Column	Type	Keys
`id`	Long	PK
`acknowledged_at`	Instant
`created_at`	Instant
`created_by_id`	Long
`current_approval_id`	Long
`custom_fields`	Json
`department_id`	Long
`exported`	Boolean
`justification`	String
`order_header_id`	Long
`payment_method`	String
`po_number`	String
`price_hidden`	Boolean
`reject_reason_id`	Long
`requisition_header_id`	Long
`ship_to_attention`	String
`status`	String
`supplier_initiated`	Boolean
`transmission_emails`	String
`transmission_method_override`	String
`updated_at`	Instant
`version`	Long

enterprise

Column	Type	Keys
`id`	Long	PK
`active_flag`	Boolean
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`system_flag`	Boolean
`tax_coding_enabled`	String
`updated_at`	Instant
`updated_by_id`	Long
`vendor_remit_to_required`	String

approval_limit

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`name`	String
`subject`	String
`updated_at`	Instant
`updated_by_id`	Long

legal_payment_receipt

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`buyer_bank_name`	String
`buyer_bank_reference`	String
`buyer_tax_number`	String
`check_number`	String
`created_at`	Instant
`currency_id`	Long
`custom_fields`	Json
`document_date`	String
`form_of_payment`	String
`payment_received_date`	String
`supplier_bank_reference`	String
`supplier_tax_number`	String
`updated_at`	Instant
`uuid`	String

expense_line_preapproval

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`created_at`	Instant
`currency_id`	Long
`custom_fields`	Json
`expense_report_preapproval_id`	Long
`updated_at`	Instant

supplier_address_mapping

Column	Type	Keys
`address_id`	Long	PKFK
`supplier_id`	Long	PKFK

supplier_preferred_commodities_mapping

Column	Type	Keys
`commodity_id`	Long	PKFK
`supplier_id`	Long	PKFK

user_working_warehouse_mapping

Column	Type	Keys
`user_id`	Long	PKFK
`warehouse_id`	Long	PKFK

currency

Column	Type	Keys
`id`	Long	PK
`code`	String
`created_by_id`	Long
`custom_fields`	Json
`decimals`	Long
`enabled`	Boolean
`name`	String
`symbol`	String
`updated_by_id`	Long

asn_header

Column	Type	Keys
`id`	Long	PK
`asn_number`	String
`bill_of_landing`	String
`container`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`delivery_date`	Instant
`export_flag`	Boolean
`gross_weight`	Double
`packing_slip`	String
`ship_date`	String
`ship_method`	String
`ship_note`	String
`ship_to_address_id`	Long
`ship_to_user_id`	Long
`ship_to_warehouse_id`	Long
`standard_carrier_alpha_code`	String
`status`	String
`supplier_id`	Long
`tracking_number`	String
`trailer`	String
`uom`	String
`updated_at`	Instant
`updated_by_id`	Long

expense_report_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`expense_report_id`	Long	PKFK

quote_response_line_easy_form_data_mapping

Column	Type	Keys
`easy_form_data_id`	Long	PKFK
`easy_form_id`	Long	PKFK
`quote_response_line_id`	Long	PKFK

project

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`additional_negotiated_savings`	String
`additional_planned_savings`	String
`additional_realized_savings`	String
`allow_users_to_view_member`	String
`commodity_id`	Long
`completion_percentage`	Long
`copy_project_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`display_date_range_warning`	Boolean
`enabled_tabs`	Json
`end_date`	Instant
`external_reference_number`	String
`mention_name`	String
`name`	String
`open`	Boolean
`project_id`	Long
`show_contracts_rollup_fields`	Boolean
`show_sourcing_rollup_fields`	Boolean
`show_suppliers_rollup_fields`	Boolean
`start_date`	Instant
`status`	String
`template_group`	Json
`updated_at`	Instant
`updated_by_id`	Long

data_file_source

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`end_time`	Instant
`file_content_type`	String
`file_file_name`	String
`file_file_size`	String
`integration_id`	Long
`integration_run_id`	Long
`progress`	Long
`records_count`	Long
`records_created`	Long
`records_updated`	Long
`result_text`	String
`source_for`	String
`start_time`	Instant
`status`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`upload_error_count`	Long

invoice_charge_tax_line_mapping

Column	Type	Keys
`invoice_charge_id`	Long	PKFK
`tax_line_id`	Long	PKFK

registered_company

Column	Type	Keys
`id`	Long	PK
`authorized_person_address`	String
`authorized_person_name`	String
`authorized_person_vat_id`	String
`chairman_of_the_board`	String
`commercial_register_number`	String
`company_registration_number`	String
`company_type`	String
`country_id`	Long
`court_of_registration`	String
`created_at`	Instant
`custom_fields`	Json
`date_of_registration`	Instant
`legal_type`	String
`liable_company`	String
`license_number`	String
`liquidation_remark`	String
`liquidator_name`	String
`managing_directors`	String
`name`	String
`permit_date`	String
`permit_number`	String
`place_of_registration`	String
`register_legal_entities`	String
`registered_seat`	String
`registration_authority`	String
`share_capital`	String
`sole_registration_code`	String
`tax_regime`	String
`unique_shareholder`	String
`updated_at`	Instant

account_type

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`legal_entity_name`	String
`name`	String
`primary_address_id`	Long
`primary_contact_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

supplier_address

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`attention`	String
`business_group_name`	String
`city`	String
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`external_src_name`	String
`external_src_ref`	String
`local_tax_number`	String
`location_code`	String
`name`	String
`postal_code`	String
`state`	String
`state_iso_code`	String
`street_1`	String
`street_2`	String
`street_3`	String
`street_4`	String
`updated_at`	Instant
`updated_by_id`	Long
`vat_country_id`	Long
`vat_number`	String

expense_line_imported_data

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`custom_fields`	Json
`description`	String

quote_response_line_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`quote_response_line_id`	Long	PKFK

lookup

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`fixed_depth`	Boolean
`level_10_name`	String
`level_1_name`	String
`level_2_name`	String
`level_3_name`	String
`level_4_name`	String
`level_5_name`	String
`level_6_name`	String
`level_7_name`	String
`level_8_name`	String
`level_9_name`	String
`name`	String
`updated_by_id`	Long

address_business_group_relation

Column	Type	Keys
`address_id`	Long	PKFK
`business_group_id`	Long	PKFK

invoice_failed_tolerance

Column	Type	Keys
`id`	Long	PK
`invoice_line_id`	Long	FK
`account_type_id`	Long
`breach_amount`	String
`breach_detail_1`	String
`breach_detail_2`	String
`breach_detail_3`	String
`breach_detail_4`	String
`breach_limit`	String
`code`	String
`created_at`	Instant
`custom_fields`	Json
`failable_id`	Long
`failable_type`	String
`resolution_strategy`	String
`resolved`	Boolean
`updated_at`	Instant

payment

Column	Type	Keys
`id`	Long	PK
`amount_paid`	Double
`check_number`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`notes`	String
`payable_id`	Long
`payable_type`	String
`payment_date`	Instant
`updated_at`	Instant
`updated_by_id`	Long

invoice_line

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	PKFK
`order_line_commodity_id`	Long	FK
`order_line_id`	Long	FK
`account_id`	Long
`accounting_total`	Double
`accounting_total_currency_id`	Long
`billing_note`	String
`bulk_price_id`	Long
`category`	String
`commodity_id`	Long
`company_uom`	String
`contract_id`	Long
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`customs_declaration_number`	String
`deductibility`	String
`delivery_note_number`	String
`description`	String
`discount_amount`	Double
`end_date`	Unknown
`handling_distribution_total`	Double
`hsn_sac_code`	String
`line_num`	Long
`line_type`	String
`match_reference`	String
`misc_distribution_total`	Double
`net_weight`	Double
`order_header_num`	String
`order_line_num`	String
`order_line_source_part_num`	String
`original_date_of_supply`	String
`period_id`	Long
`po_number`	String
`price`	Double
`price_per_uom`	Double
`property_tax_account`	String
`quantity`	Double
`shipping_distribution_total`	Double
`source_part_num`	String
`start_date`	Unknown
`status`	String
`subcategory`	String
`tax_amount`	Double
`tax_amount_engine`	String
`tax_code_id`	Long
`tax_description`	String
`tax_distribution_total`	Double
`tax_location`	String
`tax_rate`	String
`tax_supply_date`	Instant
`total`	Double
`type`	String
`unspsc`	String
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long
`weight_uom_id`	Long

withholding_tax_line

Column	Type	Keys
`id`	Long	PK
`invoice_line_id`	Long	FK
`amount`	Double
`base`	Double
`basis`	Double
`code`	String
`code_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`kind_of_factor`	String
`nature_of_tax`	String
`rate`	Double
`supplier_rate`	Double
`tax_code_id`	Long
`taxable_amount`	Double
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`withholding_amount`	Double

contract_term

Column	Type	Keys
`id`	Long	PK
`contract_id`	Long	FK
`contract_term_type`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`tier_10_disc_pct`	Double
`tier_10_upper_bound`	Double
`tier_11_disc_pct`	Double
`tier_11_upper_bound`	Double
`tier_12_disc_pct`	Double
`tier_12_upper_bound`	Double
`tier_13_disc_pct`	Double
`tier_13_upper_bound`	Double
`tier_14_disc_pct`	Double
`tier_14_upper_bound`	Double
`tier_15_disc_pct`	Double
`tier_15_upper_bound`	Double
`tier_16_disc_pct`	Double
`tier_16_upper_bound`	Double
`tier_17_disc_pct`	Double
`tier_17_upper_bound`	Double
`tier_18_disc_pct`	Double
`tier_18_upper_bound`	Double
`tier_19_disc_pct`	Double
`tier_19_upper_bound`	Double
`tier_1_disc_pct`	Double
`tier_1_upper_bound`	Double
`tier_20_disc_pct`	Double
`tier_20_upper_bound`	Double
`tier_2_disc_pct`	Double
`tier_2_upper_bound`	Double
`tier_3_disc_pct`	Double
`tier_3_upper_bound`	Double
`tier_4_disc_pct`	Double
`tier_4_upper_bound`	Double
`tier_5_disc_pct`	Double
`tier_5_upper_bound`	Double
`tier_6_disc_pct`	Double
`tier_6_upper_bound`	Double
`tier_7_disc_pct`	Double
`tier_7_upper_bound`	Double
`tier_8_disc_pct`	Double
`tier_8_upper_bound`	Double
`tier_9_disc_pct`	Double
`tier_9_upper_bound`	Double
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`use_pct_discounts`	Boolean

supplier_restricted_account_type_mapping

Column	Type	Keys
`restricted_account_type_id`	Long	PKFK
`supplier_id`	Long	PKFK

cp_payment_detail

Column	Type	Keys
`id`	Long	PK
`cp_payment_id`	Long	PKFK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`updated_by_id`	Long	FK
`adjustment_total`	Double
`created_at`	Instant
`custom_fields`	Json
`discount_total`	String
`payable_document_type`	String
`payable_id`	Long
`payable_type`	String
`payment_id`	String
`payment_total`	Double
`source_transaction_id`	String
`source_transaction_reference`	String
`source_transaction_type`	String
`supplier_site`	String
`transaction_total`	Double
`updated_at`	Instant

asset_tag

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`inventory_balance_id`	Long
`note`	String
`order_line_id`	Long
`owner`	String
`received`	Boolean
`requisition_line_id`	Long
`serial_number`	String
`tag`	String
`updated_at`	Instant
`updated_by_id`	Long

order_line_change_allocation

Column	Type	Keys
`id`	Long	PK
`order_line_change_id`	Long	FK
`period_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`pct`	Double
`updated_at`	Instant
`updated_by_id`	Long

invoice_header_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`invoice_header_id`	Long	PKFK

order_line_allocation

Column	Type	Keys
`id`	Long	PK
`order_line_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`pct`	Double
`updated_at`	Instant
`updated_by_id`	Long

contract_template_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`contract_template_id`	Long	PKFK

easy_form_data

Column	Type	Keys
`easy_form_id`	Long	PK
`id`	Long	PK
`created_by_id`	Long	FK
`requested_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`name`	String
`rejected`	Boolean
`status`	String
`subject`	Json
`subject_id`	Long
`submitted_at`	Instant
`updated_at`	Instant

supplier_information_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`supplier_information_id`	Long	PKFK

tax_rate_type

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`effective_date`	Instant
`expiration_date`	Instant
`updated_at`	Instant
`updated_by_id`	Long

expense_per_diem_time_range_condition

Column	Type	Keys
`id`	Long	PK
`conjunction`	String
`created_at`	Instant
`custom_fields`	Json
`end_after`	Instant
`end_before`	Instant
`start_after`	Instant
`start_before`	Instant
`updated_at`	Instant

expense_violation

Column	Type	Keys
`id`	Long	PK
`expense_report_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`limit_exceeded`	Double
`receipt_missing`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

supplier_information_address_mapping

Column	Type	Keys
`address_id`	Long	PKFK
`supplier_information_id`	Long	PKFK

external_payment

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`document_amount`	Double
`document_date`	Instant
`document_number`	String
`document_type`	String
`due_date`	Instant
`paid_amount`	Double
`paid_date`	Instant
`payable_amount`	Double
`remaining_amount`	Double
`remittance_amount`	Double
`source_name`	String
`source_reference`	String
`status`	String
`updated_at`	Instant

user

Column	Type	Keys
`id`	Long	PK
`manager_id`	Long	FK
`account_security_type`	Long
`active`	Boolean
`aic_user`	Boolean
`analytics_user`	Boolean
`api_user`	Boolean
`approval_limit_id`	Long
`authentication_method`	String
`avatar_thumb_url`	String
`business_function`	String
`business_group_security_type`	Long
`ccw_user`	Boolean
`contract_approval_limit_id`	Long
`contract_self_approval_limit_id`	Long
`contracts_user`	Boolean
`country_of_residence_id`	Long
`created_at`	Instant
`created_by_id`	Long
`default_account_id`	Long
`default_account_type_id`	Long
`default_address_id`	Long
`default_currency_id`	Long
`default_locale`	String
`department_id`	Long
`edit_invoice_on_quick_entry`	Boolean
`email`	String
`employee_number`	String
`employee_payment_channel`	String
`escalation_threshold_id`	Long
`expense_approval_limit_id`	Long
`expense_self_approval_limit_id`	Long
`expense_user`	Boolean
`firstname`	String
`fullname`	String
`generate_password_and_notify`	String
`inventory_user`	Boolean
`invoice_approval_limit_id`	Long
`invoice_self_approval_limit_id`	Long
`lastname`	String
`login`	String
`mention_name`	String
`password`	String
`pcard_id`	Long
`purchasing_user`	Boolean
`requisition_approval_limit_id`	Long
`requisition_self_approval_limit_id`	Long
`salesforce_enabled`	Boolean
`salesforce_id`	String
`self_approval_limit_id`	Long
`seniority_level`	String
`sourcing_user`	Boolean
`spend_guard_user`	Boolean
`sso_identifier`	String
`updated_at`	Instant
`updated_by_id`	Long
`work_confirmation_approval_limit_id`	Long
`custom_fields_`

order_line

Column	Type	Keys
`id`	Long	PK
`order_header_id`	Long	PKFK
`currency_id`	Long	FK
`extra_line_attribute_id`	Long	FK
`account_id`	Long
`accounting_total`	Double
`accounting_total_currency_id`	Long
`bulk_price_id`	Long
`commodity_id`	Long
`contract_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`department_id`	Long
`description`	String
`end_date`	Unknown
`invoice_stop`	Boolean
`invoiced`	Double
`item_id`	Long
`line_num`	String
`manufacturer_name`	String
`manufacturer_part_number`	String
`match_type`	String
`need_by_date`	Instant
`order_header_number`	String
`period_id`	Long
`price`	Double
`quantity`	Double
`receipt_required`	Boolean
`received`	Double
`receiving_warehouse_id`	Long
`reporting_total`	Double
`requester_id`	Long
`savings_pct`	Double
`service_type`	String
`source_part_num`	String
`start_date`	Unknown
`status`	String
`sub_line_num`	Long
`supp_aux_part_num`	String
`supplier_order_number`	String
`supplier_site_id`	Long
`total`	Double
`type`	String
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long
`version`	Long

commodity_translation

Column	Type	Keys
`id`	Long	PK
`commodity_id`	Long
`created_at`	Instant
`custom_fields`	Json
`locale`	String
`name`	String
`updated_at`	Instant

order_header_change_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`order_header_change_id`	Long	PKFK

supplier_information_contact_mapping

Column	Type	Keys
`contact_id`	Long	PKFK
`supplier_information_id`	Long	PKFK

warehouse

Column	Type	Keys
`id`	Long	PK
`address_id`	Long	FK
`active_flag`	Boolean
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long
`warehouse_type_id`	Long

account_validation_rule

Column	Type	Keys
`id`	Long	PK
`account_type_id`	Long
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`error_message`	String
`name`	String
`segment_10_condition`	String
`segment_10_max`	String
`segment_11_condition`	String
`segment_11_max`	String
`segment_11_min`	String
`segment_12_condition`	String
`segment_12_max`	String
`segment_12_min`	String
`segment_13_condition`	String
`segment_13_max`	String
`segment_13_min`	String
`segment_14_condition`	String
`segment_14_max`	String
`segment_14_min`	String
`segment_15_condition`	String
`segment_15_max`	String
`segment_15_min`	String
`segment_16_condition`	String
`segment_16_max`	String
`segment_16_min`	String
`segment_17_condition`	String
`segment_17_max`	String
`segment_17_min`	String
`segment_18_condition`	String
`segment_18_max`	String
`segment_18_min`	String
`segment_19_condition`	String
`segment_19_max`	String
`segment_19_min`	String
`segment_1_condition`	String
`segment_1_max`	String
`segment_1_min`	String
`segment_20_condition`	String
`segment_20_max`	String
`segment_20_min`	String
`segment_2_condition`	String
`segment_2_max`	String
`segment_2_min`	String
`segment_3_condition`	String
`segment_3_max`	String
`segment_3_min`	String
`segment_4_condition`	String
`segment_4_max`	String
`segment_4_min`	String
`segment_5_condition`	String
`segment_5_max`	String
`segment_5_min`	String
`segment_6_condition`	String
`segment_6_max`	String
`segment_6_min`	String
`segment_7_condition`	String
`segment_7_max`	String
`segment_7_min`	String
`segment_8_condition`	String
`segment_8_max`	String
`segment_8_min`	String
`segment_9_condition`	String
`segment_9_max`	String
`segment_9_min`	String
`updated_at`	Instant
`updated_by_id`	Long

tagging

Column	Type	Keys
`document_id`	Long	PK
`document_type`	String	PK
`id`	Long	PK
`created_by_id`	Long	FK
`tag_id`	Long	FK
`active`	Boolean
`created_at`	Instant
`custom_fields`	Json
`description`	String

order_pad_line

Column	Type	Keys
`id`	Long	PK
`order_pad_id`	Long	PKFK
`supplier_id`	Long	FK
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`item_id`	Long
`key_item`	Boolean
`order_amount_method`	String
`order_pad_section_id`	Long
`par_level`	Double
`position`	Long
`updated_at`	Instant
`updated_by_id`	Long

quote_supplier

Column	Type	Keys
`id`	Long	PK
`quote_request_id`	Long	FK
`quote_response_id`	Long	FK
`contact_name`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`display_name`	String
`email`	String
`name`	String
`participation`	String
`public_profile_link`	String
`supplier_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

virtual_card_partner_account_type_mapping

Column	Type	Keys
`account_type_id`	Long	PKFK
`virtual_card_partner_id`	Long	PKFK

order_line_change

Column	Type	Keys
`id`	Long	PK
`order_header_change_id`	Long	FK
`order_line_id`	Long	FK
`commodity_id`	Long
`created_at`	Instant
`custom_fields`	Json
`description`	String
`line_num`	String
`need_by_date`	Instant
`pending_delete`	Boolean
`price`	Double
`quantity`	Double
`savings_pct`	Double
`source_part_num`	String
`total`	Double
`updated_at`	Instant

quote_request_attachment

Column	Type	Keys
`id`	Long	PK
`quote_request_id`	Long	FK
`allow_to_respond`	Boolean
`custom_fields`	Json
`instruction`	String
`name`	String
`response_required`	Boolean

expense_report_preapproval

Column	Type	Keys
`id`	Long	PK
`expense_report_id`	Long	FK
`amount`	Double
`created_at`	Instant
`currency_id`	Long
`custom_fields`	Json
`expense_preapproval_id`	Long
`updated_at`	Instant

supplier

Column	Type	Keys
`id`	Long	PK
`account_number`	String
`allow_change_requests`	Boolean
`allow_csp_access_without_two_factor`	String
`allow_cxml_invoicing`	Boolean
`allow_inv_choose_billing_account`	Boolean
`allow_inv_from_connect`	Boolean
`allow_inv_no_backing_doc_from_connect`	Boolean
`allow_inv_unbacked_lines_from_connect`	Boolean
`buyer_hold`	Boolean
`commodity_id`	Long
`corporate_url`	String
`coupa_connect_secret`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`cxml_domain`	String
`cxml_http_password`	String
`cxml_http_username`	String
`cxml_identity`	String
`cxml_invoice_buyer_domain`	String
`cxml_invoice_buyer_identity`	String
`cxml_invoice_secret`	String
`cxml_invoice_supplier_domain`	String
`cxml_invoice_supplier_identity`	String
`cxml_protocol`	String
`cxml_secret`	String
`cxml_ssl_version`	String
`cxml_supplier_domain`	String
`cxml_supplier_identity`	String
`cxml_url`	String
`default_locale`	String
`disable_cert_verify`	Boolean
`display_name`	String
`duns`	String
`enterprise_id`	Long
`hold_invoices_for_ap_review`	Boolean
`invoice_matching_level`	String
`name`	String
`number`	String
`on_hold`	Boolean
`parent_id`	Long
`payment_method`	String
`payment_term_id`	Long
`po_change_method`	String
`po_email`	String
`po_method`	String
`primary_address_id`	Long
`primary_contact_id`	Long
`savings_pct`	Double
`send_invoices_to_approvals`	Boolean
`shipping_term_id`	Long
`status`	String
`storefront_url`	String
`tax_code_id`	Long
`tax_id`	String
`updated_at`	Instant
`updated_by_id`	Long
`website`	String

user_approval_group_mapping

Column	Type	Keys
`approval_group_id`	Long	PKFK
`user_id`	Long	PKFK

expense_mileage_tier_rule

Column	Type	Keys
`id`	Long	PK
`expense_mileage_config_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`distance_range_start`	Long
`expense_mileage_rate_type_id`	Long
`name`	String
`updated_at`	Instant

contract_party_contract_mapping

Column	Type	Keys
`contract_id`	Long	PKFK
`contract_party_id`	Long	PKFK

req_line_allocation

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`requisition_line_id`	Long	FK
`updated_by_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`custom_fields`	Json
`pct`	Double
`updated_at`	Instant

form

Column	Type	Keys
`id`	Long	PK
`quote_request_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`form_type`	String
`name`	String
`status`	String
`updated_at`	Instant
`updated_by_id`	Long

payment_partner

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`support_contact_id`	Long	FK
`updated_by_id`	Long	FK
`code`	String
`created_at`	Instant
`custom_fields`	Json
`description`	String
`is_active`	Boolean
`is_default`	Boolean
`is_deleted`	Boolean
`issuing_bank`	String
`name`	String
`payment_partner_type`	String
`type`	String
`updated_at`	Instant
`config_`

requisition_line_asset_tag_mapping

Column	Type	Keys
`asset_tag_id`	Long	PKFK
`requisition_line_id`	Long	PKFK

user_group

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`can_approve`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`mention_name`	String
`name`	String
`open`	Boolean
`owner_id`	Long
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

supplier_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`supplier_id`	Long	PKFK

supplier_information_artifact_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`supplier_information_artifact_id`	Long	PKFK

user_can_expense_for_mapping

Column	Type	Keys
`can_expense_for_id`	Long	PKFK
`user_id`	Long	PKFK

quote_request

Column	Type	Keys
`id`	Long	PK
`currency_id`	Long	FK
`negotiated_savings_currency_id`	Long	FK
`planned_savings_currency_id`	Long	FK
`allow_award_individual_line_items`	Boolean
`allow_multiple_response`	Boolean
`automatic_bid_unsealing`	Boolean
`comments`	String
`commodity_id`	Long
`created_at`	Instant
`custom_fields`	Json
`description`	String
`end_time`	Instant
`event_type`	String
`negotiated_savings`	Double
`original_id`	Long
`planned_savings`	Double
`public`	Boolean
`sealed_bids`	Boolean
`sealing_type`	String
`start_on_submit`	Boolean
`start_time`	Instant
`state`	String
`timezone`	String

account_group

Column	Type	Keys
`id`	Long	PK
`account_type_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`segment_10_col`	String
`segment_10_op`	String
`segment_10_val`	String
`segment_11_col`	String
`segment_11_op`	String
`segment_11_val`	String
`segment_12_col`	String
`segment_12_op`	String
`segment_12_val`	String
`segment_13_col`	String
`segment_13_op`	String
`segment_13_val`	String
`segment_14_col`	String
`segment_14_op`	String
`segment_14_val`	String
`segment_15_col`	String
`segment_15_op`	String
`segment_15_val`	String
`segment_16_col`	String
`segment_16_op`	String
`segment_16_val`	String
`segment_17_col`	String
`segment_17_op`	String
`segment_17_val`	String
`segment_18_col`	String
`segment_18_op`	String
`segment_18_val`	String
`segment_19_col`	String
`segment_19_op`	String
`segment_19_val`	String
`segment_1_col`	String
`segment_1_op`	String
`segment_1_val`	String
`segment_20_col`	String
`segment_20_op`	String
`segment_20_val`	String
`segment_2_col`	String
`segment_2_op`	String
`segment_2_val`	String
`segment_3_col`	String
`segment_3_op`	String
`segment_3_val`	String
`segment_4_col`	String
`segment_4_op`	String
`segment_4_val`	String
`segment_5_col`	String
`segment_5_op`	String
`segment_5_val`	String
`segment_6_col`	String
`segment_6_op`	String
`segment_6_val`	String
`segment_7_col`	String
`segment_7_op`	String
`segment_7_val`	String
`segment_8_col`	String
`segment_8_op`	String
`segment_8_val`	String
`segment_9_col`	String
`segment_9_op`	String
`segment_9_val`	String
`updated_at`	Instant
`updated_by_id`	Long

business_entity_account_owner

Column	Type	Keys
`business_entity_id`	Long	PKFK
`user_id`	Long	PKFK
`created_at`	Instant
`created_by_id`	Long
`id`	Long
`updated_at`	Instant
`updated_by_id`	Long

address_tax_registration_relation

Column	Type	Keys
`address_id`	Long	PKFK
`tax_registration_id`	Long	PKFK

supplier_remit_to

Column	Type	Keys
`id`	Long	PK
`city`	String
`company_registration_number`	String
`country_id`	Long
`created_at`	Instant
`custom_fields`	Json
`disclosure`	String
`name`	String
`postal_code`	String
`preferred_language`	String
`registered_company_id`	Long
`state`	String
`street_1`	String
`street_2`	String
`supplier_name`	String
`tax_number`	String
`tax_prefix`	String
`updated_at`	Instant

user_group_membership

Column	Type	Keys
`id`	Long	PK
`user_group_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`owner`	Boolean
`participant`	Boolean
`updated_at`	Instant

integration_run

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`end_time`	Instant
`integration_id`	Long
`records_processed`	Long
`start_time`	Instant
`status`	String
`total_records`	Long
`updated_at`	Instant

announcement

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`announceable_id`	Long
`announceable_type`	String
`created_at`	Instant
`important`	Boolean
`is_new`	Boolean
`message`	String
`short_description`	String
`start_at`	Instant
`subject`	String
`summary`	String
`updated_at`	Instant

expense_policy

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`allow_divisor`	Boolean
`allow_divisor_end_date`	Boolean
`allow_itemization`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`divisor_end_name`	String
`divisor_start_name`	String
`divisor_uom_name`	String
`limit_amount`	Double
`limit_type`	String
`requires_receipt`	Boolean
`restrict_itemization_categories`	Boolean
`summary`	String
`text`	String
`updated_at`	Instant
`updated_by_id`	Long

tax_registration

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`local`	Boolean
`number`	String
`owner_id`	Long
`owner_type`	String
`updated_at`	Instant
`updated_by_id`	Long

reason_insight

Column	Type	Keys
`id`	Long	PK
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`reason_type`	String
`updated_at`	Instant
`updated_by_id`	Long

project_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`project_id`	Long	PKFK

comment

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`commentable_id`	Long
`commentable_type`	String
`comments`	String
`created_at`	Instant
`custom_fields`	Json
`reason_code`	String
`to_supplier`	Boolean
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

expense_per_diem_config

Column	Type	Keys
`id`	Long	PK
`country_id`	Long
`created_at`	Instant
`custom_fields`	Json
`deductions_section_label`	String
`policy_description`	String
`policy_title`	String
`rule_set_type`	String
`scope`	String
`updated_at`	Instant

inventory_txn_allocation

Column	Type	Keys
`id`	Long	PK
`inventory_transaction_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`pct`	Double
`period_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

supplier_risk_aware_feed

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`number_field_01`	Double
`number_field_02`	Double
`number_field_03`	Double
`number_field_04`	Double
`number_field_05`	Double
`number_field_06`	Double
`number_field_07`	Double
`number_field_08`	Double
`number_field_09`	Double
`number_field_10`	Double
`supplier_id`	Long
`updated_at`	Instant

expense_trip

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`expense_trip_mileage_id`	Long
`updated_at`	Instant

payment_partner_account_type_mapping

Column	Type	Keys
`account_id`	Long	PKFK
`account_type_id`	Long	PKFK
`payment_id`	Long	PKFK
`payment_partner_id`	Long	PKFK

order_pad_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`order_pad_id`	Long	PKFK

supplier_information

Column	Type	Keys
`id`	Long	PK
`commodity_id`	String	FK
`currency_id`	Long	FK
`default_commodity_id`	Long	FK
`payment_term_id`	Long	FK
`shipping_term_id`	Long	FK
`supplier_id`	Long	FK
`tax_code_id`	Long	FK
`user_id`	Long	FK
`allow_cxml_invoicing`	Boolean
`allow_inv_choose_billing_account`	Boolean
`allow_inv_from_connect`	Boolean
`allow_inv_no_backing_doc_from_connect`	Boolean
`allow_inv_unbacked_lines_from_connect`	Boolean
`backend_system_catalog`	String
`backend_system_invoicing`	String
`buyer_hold`	Boolean
`buyer_id`	Long
`classification_detail`	Json
`comment`	String
`comment_source`	String
`country_of_operation_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`cxml_domain`	String
`cxml_http_username`	String
`cxml_identity`	String
`cxml_protocol`	String
`cxml_secret`	String
`cxml_ssl_version`	String
`cxml_supplier_domain`	String
`cxml_supplier_identity`	String
`cxml_url`	String
`default_invoice_email`	String
`disable_cert_verify`	Boolean
`display_name`	String
`diversities`	Json
`duns_number`	String
`duplicate_exists`	Boolean
`enterprise_detail`	Json
`estimated_spend_amount`	Double
`fed_reportable`	Boolean
`federal_tax_num`	String
`goods_services_provided`	String
`govt_agency_interaction`	String
`govt_agency_interaction_indicator`	Boolean
`govt_allegation_fraud_bribery`	String
`govt_allegation_fraud_bribery_indicator`	Boolean
`hold_invoices_for_ap_review`	Boolean
`hold_payment`	String
`hold_payment_indicator`	Boolean
`inbound_invoice_domain`	String
`inco_terms`	String
`income_type`	String
`industry`	String
`insurance_detail`	Json
`intl_other_explanation`	String
`intl_tax_classification`	String
`intl_tax_num`	String
`invoice_amount_limit`	String
`invoice_inbound_emails`	String
`invoice_matching_level`	String
`last_exported_at`	String
`logo_content_type`	String
`logo_file_name`	String
`logo_file_size`	Long
`logo_updated_at`	Instant
`minority_designation_id`	Long
`minority_indicator`	Boolean
`minority_type_id`	Long
`name`	String
`one_time_supplier`	Boolean
`organization_type`	String
`parent_company_name`	String
`pay_group`	String
`payment_terms_id`	Long
`po_change_method`	String
`po_email`	String
`po_method`	String
`policy_for_bribery_corruption`	String
`policy_for_bribery_corruption_indicator`	Boolean
`preferred_currency_id`	Long
`preferred_language_id`	Long
`risk_detail`	Json
`savings_pct`	Double
`scope_three_emissions`	Boolean
`send_invoices_to_approvals`	Boolean
`separate_remit_to`	Boolean
`status`	String
`supplier_name`	String
`supplier_number`	String
`supplier_region`	String
`tax_classification`	String
`tax_detail`	Json
`tax_exempt_other_explanation`	String
`tax_region`	String
`third_party_interaction`	String
`third_party_interaction_indicator`	Boolean
`updated_at`	Instant
`updated_by_id`	Long
`website`	String

bulk_price

Column	Type	Keys
`id`	Long	PK
`conversion_denominator`	Double
`conversion_numerator`	Double
`custom_fields`	Json
`price`	Double
`qty`	Double
`uom_id`	Long

contract_current_parallel_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`contract_id`	Long	PKFK

purpose

Column	Type	Keys
`id`	Long	PK
`address_id`	Long	FK
`contact_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`kind`	String
`name`	String
`updated_at`	Instant

user_group_user_mapping

Column	Type	Keys
`user_group_id`	Long	PKFK
`user_id`	Long	PKFK

expense_policy_violation

Column	Type	Keys
`id`	Long	PK
`expense_report_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`limit_exceeded`	Double
`receipt_missing`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

quote_request_attachment_response

Column	Type	Keys
`id`	Long	PK
`quote_response_id`	Long	PKFK
`custom_fields`	Json
`buyer`

inspection_code

Column	Type	Keys
`id`	Long	PK
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`updated_at`	Instant
`updated_by_id`	Long

pcard

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`cvv`	String
`expiry`	String
`name`	String
`nickname`	String
`number`	String
`shared`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

business_group

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

expense_line_per_diem

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`destination`	String
`end_at`	Instant
`end_at_timezone`	String
`start_at`	Instant
`start_at_timezone`	String
`updated_at`	Instant

business_entity_address_mapping

Column	Type	Keys
`address_id`	Long	PKFK
`business_entity_id`	Long	PKFK

approver_group_user_mapping

Column	Type	Keys
`approver_id`	Long	PKFK
`user_id`	Long	PKFK

business_entity_alternate_name

Column	Type	Keys
`id`	Long	PK
`business_entity_id`	Long	PKFK
`name`	String

expense_line_tax

Column	Type	Keys
`id`	Long	PK
`expense_line_id`	Long	FK
`amount`	Double
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`std_amount`	Double
`tax_code_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

order_line_attribute

Column	Type	Keys
`id`	Long	PK
`order_line_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`end_date`	Instant
`start_date`	Instant
`updated_at`	Instant
`updated_by_id`	Long
`work_confirmer_email`	String

lookup_value

Column	Type	Keys
`id`	Long	PK
`lookup_id`	Long	FK
`account_type_id`	Long
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`depth`	Long
`description`	String
`external_ref_code`	String
`external_ref_num`	String
`is_default`	Boolean
`name`	String
`parent_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

expense_mileage_region

Column	Type	Keys
`id`	Long	PK
`country_id`	Long
`created_at`	Instant
`custom_fields`	Json
`location_id`	String
`name`	String
`updated_at`	Instant

supplier_item

Column	Type	Keys
`id`	Long	PK
`contract_id`	Long	FK
`contract_term_id`	Long	FK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`item_id`	Long	FK
`supplier_id`	Long	FK
`updated_by_id`	Long	FK
`availability`	String
`availability_date`	Instant
`created_at`	Instant
`custom_fields`	Json
`lead_time`	Long
`manufacturer`	String
`minimum_order_quantity`	Double
`order_increment`	Double
`preferred`	Boolean
`price`	Double
`price_change`	String
`price_tier_1`	Double
`price_tier_10`	Double
`price_tier_11`	Double
`price_tier_12`	Double
`price_tier_13`	Double
`price_tier_14`	Double
`price_tier_15`	Double
`price_tier_16`	Double
`price_tier_17`	Double
`price_tier_18`	Double
`price_tier_19`	Double
`price_tier_2`	Double
`price_tier_20`	Double
`price_tier_3`	Double
`price_tier_4`	Double
`price_tier_5`	Double
`price_tier_6`	Double
`price_tier_7`	Double
`price_tier_8`	Double
`price_tier_9`	Double
`savings_pct`	Double
`supplier_aux_part_num`	String
`supplier_part_num`	String
`unspsc_code`	String
`updated_at`	Instant

invoice_reconciliation_line

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	FK
`amount`	Double
`amount_paid`	Double
`category`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`notes`	String
`payable_id`	Long
`payable_type`	String
`payment_date`	Instant
`updated_at`	Instant
`updated_by_id`	Long

charge_allocation

Column	Type	Keys
`id`	Long	PK
`charge_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`pct`	Double
`period_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

supplier_remit_to_address_mapping

Column	Type	Keys
`remit_to_address_id`	Long	PKFK
`supplier_id`	Long	PKFK

business_entity

Column	Type	Keys
`id`	Long	PK
`country_of_origin_id`	Long	FK
`primary_contact_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`display_name`	String
`formation_type`	String
`name`	String
`status`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

contact

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`email`	String
`name_additional`	String
`name_family`	String
`name_fullname`	String
`name_given`	String
`name_prefix`	String
`name_suffix`	String
`notes`	String
`photo`	String
`updated_at`	Instant
`updated_by_id`	Long

order_pad_section

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`name`	String
`position`	Long
`updated_at`	Instant

expense_mileage_vehicle_type

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`name`	String
`updated_at`	Instant

quote_request_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`quote_request_id`	Long	PKFK

contract_template

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`authoring_method`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`hierarchy_type`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

inventory_organization

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`created_at`	Instant
`currency_id`	Long
`custom_fields`	Json
`fulfillment_type`	String
`updated_at`	Instant

quote_response

Column	Type	Keys
`id`	Long	PK
`quote_request_id`	Long	FK
`awarded`	Boolean
`comments`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`position`	Long
`promoted`	Boolean
`quote_request_original_id`	String
`quote_request_revision`	String
`state`	String
`submitted_at`	Instant
`updated_at`	Instant
`updated_by_id`	Long

warehouse_type

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

account

Column	Type	Keys
`id`	Long	PK
`account_type_id`	Long
`active`	Boolean
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`segment_1`	String
`segment_10`	String
`segment_11`	String
`segment_12`	String
`segment_13`	String
`segment_14`	String
`segment_15`	String
`segment_16`	String
`segment_17`	String
`segment_18`	String
`segment_19`	String
`segment_2`	String
`segment_20`	String
`segment_3`	String
`segment_4`	String
`segment_5`	String
`segment_6`	String
`segment_7`	String
`segment_8`	String
`segment_9`	String
`updated_at`	Instant
`updated_by_id`	Long

expense_report_comment_mapping

Column	Type	Keys
`comment_id`	Long	PKFK
`expense_report_id`	Long	PKFK

expense_report_event_history

Column	Type	Keys
`id`	Long	PK
`expense_report_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`status`	String
`updated_at`	Instant
`updated_by_id`	Long

attachment

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`file_url`	String
`intent`	String
`linked_to`	String
`text`	String
`type`	String
`updated_at`	Instant
`url`	String

requisition_header_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`requisition_header_id`	Long	PKFK

virtual_card

Column	Type	Keys
`id`	Long	PK
`order_header_id`	Long	FK
`card_number`	String
`card_type`	String
`coupa_pay_id`	Long
`created_at`	Instant
`created_by_id`	Long
`credit_account`	String
`currency_id`	Long
`custom_fields`	Json
`document_id`	Long
`document_type`	String
`expiry_month`	Long
`expiry_year`	Long
`external_ref_id`	String
`name`	String
`payment_partner_id`	Long
`requested_by_id`	Long
`status`	String
`total_booked`	Double
`total_charged`	Double
`updated_at`	Instant
`updated_by_id`	Long
`valid_from`	Instant
`valid_to`	Instant

purchase_order_revision_change

Column	Type	Keys
`entity_id`	Long	PK
`entity_name`	String	PK
`field_name`	String	PK
`purchase_order_revision_id`	Long	PKFK
`created`	Boolean
`field_type`	String
`from_id`	Long
`from_value`	String
`to_id`	Long
`to_value`	String

period

Column	Type	Keys
`id`	Long	PK
`account_type_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`end_date`	Instant
`is_open`	Boolean
`name`	String
`segment_1`	String
`segment_10`	String
`segment_11`	String
`segment_12`	String
`segment_13`	String
`segment_14`	String
`segment_15`	String
`segment_16`	String
`segment_17`	String
`segment_18`	String
`segment_19`	String
`segment_2`	String
`segment_20`	String
`segment_3`	String
`segment_4`	String
`segment_5`	String
`segment_6`	String
`segment_7`	String
`segment_8`	String
`segment_9`	String
`start_date`	Instant
`updated_at`	Instant
`updated_by_id`	Long

expense_category

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`attendee_tracking_enabled`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`expense_mileage_config_id`	Long
`expense_per_diem_config_id`	Long
`expense_policy_id`	Long
`name`	String
`scope`	String
`tax_enabled`	Boolean
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

department

Column	Type	Keys
`id`	Long	PK
`active`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

expense_attendee

Column	Type	Keys
`id`	Long	PK
`expense_line_id`	Long	PKFK
`user_id`	Long	FK
`active`	Boolean
`company`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`expense_attendee_type_custom_field_1`	String
`expense_attendee_type_custom_field_10`	String
`expense_attendee_type_custom_field_2`	String
`expense_attendee_type_custom_field_3`	String
`expense_attendee_type_custom_field_4`	String
`expense_attendee_type_custom_field_5`	String
`expense_attendee_type_custom_field_6`	String
`expense_attendee_type_custom_field_7`	String
`expense_attendee_type_custom_field_8`	String
`expense_attendee_type_custom_field_9`	String
`expense_attendee_type_id`	Long
`expense_attendee_type_name`	String
`first_name`	String
`last_name`	String
`title`	String
`updated_at`	Instant
`updated_by_id`	Long

easy_form_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`easy_form_id`	Long	PKFK

inventory_transaction

Column	Type	Keys
`id`	Long	PK
`account_id`	Long
`asn_header_id`	Long
`asn_line_id`	Long
`barcode`	String
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`exported`	Boolean
`from_warehouse_id`	Long
`from_warehouse_location_id`	Long
`inspection_code_id`	Long
`item_id`	Long
`last_exported_at`	Instant
`match_reference`	String
`order_line_id`	Long
`price`	Double
`quantity`	Double
`receipts_batch_id`	Long
`received_weight`	Double
`rfid_tag`	String
`soft_close_for_receiving`	Boolean
`status`	String
`to_warehouse_id`	Long
`to_warehouse_location_id`	Long
`total`	Double
`transaction_date`	Instant
`type`	String
`uom_id`	Long
`updated_at`	Instant
`adjustment_`

inventory_transaction_valuation

Column	Type	Keys
`id`	Long	PK
`inventory_transaction_id`	Long	FK
`custom_fields`	Json
`price`	Double
`quantity`	Double
`uom_id`	Long

cp_account

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`payment_partner_id`	Long	FK
`updated_by_id`	Long	FK
`account_kind`	String
`account_name`	String
`account_type_ids`	String
`coupa_pay_id`	Long
`created_at`	Instant
`custom_fields`	Json
`digital_check_signature_viewpost_status`	String
`document_types`	Json
`payment_option`	String
`physical_check_signature_presence`	Boolean
`pmx_disbursing_id`	String
`positive_pay_partner`	Json
`print_and_mail_partner_name`	String
`source_name`	String
`source_reference`	String
`status`	String
`supported_transfer_types`	Json
`updated_at`	Instant

invoice_charge_allocation

Column	Type	Keys
`id`	Long	PK
`invoice_charge_id`	Long	FK
`account_id`	Long
`amount`	Double
`billing_note`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`pct`	Double
`updated_at`	Instant
`updated_by_id`	Long

invoice_header

Column	Type	Keys
`id`	Long	PK
`abandon_reason_id`	Long
`account_type_id`	Long
`advance_payment_received_amount`	Double
`amount_due`	Double
`bill_to_address_id`	Long
`buyer_tax_registration_id`	Long
`canceled`	Boolean
`cash_accounting_scheme_reference`	String
`channel`	String
`clearance_document`	String
`comments`	String
`compliant`	Boolean
`confirmation`	String
`contract_id`	Long
`coupa_accelerate_status`	String
`created_at`	Instant
`created_by_id`	Long
`credit_note_differences_with_original_invoice`	Double
`credit_reason`	String
`currency_id`	Long
`custom_fields`	Json
`customer_accounting_tax`	Double
`customs_declaration_date`	Instant
`customs_declaration_number`	String
`customs_office`	String
`date_of_discovery_of_facts_decisive_for_correction`	Instant
`date_received`	Instant
`delivery_date`	Instant
`delivery_number`	String
`destination_country_id`	Long
`discount_amount`	Double
`discount_due_date`	Instant
`discount_percent`	Double
`dispute_method`	String
`document_type`	String
`early_payment_provisions`	String
`exchange_rate`	Double
`exported`	Boolean
`folio_number`	String
`form_of_payment`	String
`gross_total`	Double
`handling_amount`	Double
`image_scan`	String
`image_scan_url`	String
`inbox_name`	String
`internal_note`	String
`invoice_date`	Instant
`invoice_from_address_id`	Long
`invoice_number`	String
`issuance_place`	String
`last_exported_at`	String
`late_payment_penalties`	String
`legal_destination_country_id`	Long
`line_level_taxation`	Boolean
`lock_version_key`	Long
`margin_scheme`	String
`misc_amount`	Double
`net_due_date`	String
`origin_country_id`	Long
`origin_currency_gross`	Double
`origin_currency_net`	Double
`original_invoice_date`	Instant
`original_invoice_number`	String
`paid`	Boolean
`payment_channel`	String
`payment_date`	Instant
`payment_method`	String
`payment_notes`	String
`payment_order_reference`	String
`payment_term_id`	Long
`remit_to_address_id`	Long
`requested_by_id`	Long
`reverse_charge_reference`	String
`self_billing_reference`	String
`sender_email`	String
`series`	String
`ship_from_address_id`	Long
`ship_to_address_id`	Long
`shipping_amount`	Double
`shipping_term_id`	Long
`show_tax_information`	Boolean
`status`	String
`supplier_created`	String
`supplier_id`	Long
`supplier_note`	String
`supplier_remit_to_id`	Long
`supplier_tax_registration_id`	Long
`supplier_total`	Double
`tax_amount`	Double
`tax_amount_engine`	String
`tax_code_id`	Long
`tax_due_to_supplier`	Double
`tax_rate`	String
`taxes_in_origin_country_currency`	Double
`tolerance_failures`	String
`total_with_taxes`	Double
`type_of_receipt`	String
`type_of_relationship`	String
`updated_at`	Instant
`updated_by_id`	Long
`use_of_invoice`	String
`withholding_tax_override`	Double

integration

Column	Type	Keys
`id`	Long	PK
`business_object`	String
`code`	String
`created_at`	Instant
`custom_fields`	Json
`direction`	String
`end_system`	String
`end_system_type`	String
`integration_type`	String
`name`	String
`standard`	Boolean
`updated_at`	Instant

integration_contacts

Column	Type	Keys
`id`	Long	PK
`supplier_id`	Long	FK
`contact_alert_type`	String
`contactable_id`	Long
`contactable_type`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`updated_at`	Instant
`updated_by_id`	Long

payment_term

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`days_for_discount_payment`	Long
`days_for_net_payment`	Long
`description`	String
`discount_rate`	Double
`updated_at`	Instant
`updated_by_id`	Long

reason_insight_event

Column	Type	Keys
`id`	Long	PK
`contract_id`	Long	FK
`comment`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`eventable_id`	Long
`eventable_type`	String
`reason_insight_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

user_address_mapping

Column	Type	Keys
`address_id`	Long	PKFK
`user_id`	Long	PKFK

lookup_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`lookup_id`	Long	PKFK

expense_mileage_config

Column	Type	Keys
`id`	Long	PK
`accumulation_period_start_day_month`	Instant
`country_id`	Long
`created_at`	Instant
`custom_fields`	Json
`distance_unit`	String
`expense_mileage_tier_rules`	Json
`mileage_accumulation_rule_enabled`	Boolean
`passenger_count_prompt`	String
`passenger_count_rule_enabled`	Boolean
`region_prompt`	String
`region_rule_enabled`	Boolean
`require_address`	Boolean
`show_map`	Boolean
`simple_fixed_rate_amount`	Double
`simple_fixed_rate_currency_id`	Long
`simple_fixed_rate_enabled`	Boolean
`updated_at`	Instant
`vehicle_type_prompt`	String
`vehicle_type_rule_enabled`	Boolean

invoice_line_allocation

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	PKFK
`invoice_line_id`	Long	PKFK
`account_id`	Long
`amount`	Double
`billing_note`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`handling_distribution_total`	Double
`misc_distribution_total`	Double
`pct`	Double
`period_id`	Long
`shipping_distribution_total`	Double
`tax_distribution_total`	Double
`updated_at`	Instant
`updated_by_id`	Long

order_header_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`order_header_id`	Long	PKFK

quote_response_line

Column	Type	Keys
`id`	Long	PK
`quote_response_id`	Long	PKFK
`shipping_term_id`	Long	FK
`awarded`	Boolean
`cost_element_values`	Json
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`item_description`	String
`item_part_number`	String
`lead_time`	Long
`lot_id`	Long
`price_amount`	Double
`price_currency_id`	Long
`quantity`	Double
`quote_request_line_id`	Long
`reporting_price_amount`	Double
`supplier_item_name`	String
`updated_at`	Instant
`updated_by_id`	Long

per_diem_deduction

Column	Type	Keys
`id`	Long	PK
`expense_line_daily_per_diem_id`	Long	FK
`expense_per_diem_deduction_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`deduction_applied`	String
`updated_at`	Instant

expense_line_mileage_allocation

Column	Type	Keys
`id`	Long	PK
`expense_line_mileage_id`	Long	FK
`applied_distance`	Double
`applied_distance_`	String
`applied_rate`	Double
`created_at`	Instant
`custom_fields`	Json
`expense_mileage_rate_type_id`	Long
`updated_at`	Instant

expense_artifact

Column	Type	Keys
`id`	Long	PK
`expense_line_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`external_src_ref`	String
`image_content_type`	String
`image_file_name`	String
`image_file_size`	String
`ocr_status`	String
`source_content_type`	String
`source_file_name`	String
`source_file_size`	String
`updated_at`	Instant
`updated_by_id`	Long
`url`	String

commodity

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`category`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`deductibility`	String
`name`	String
`parent_id`	Long
`subcategory`	String
`updated_at`	Instant
`updated_by_id`	Long

integration_history_record

Column	Type	Keys
`id`	Long	PK
`integration_run_id`	Long	FK
`inventory_transaction_id`	Long	FK
`invoice_header_id`	Long	FK
`order_header_id`	Long	FK
`contact_alert_type`	String
`created_at`	Instant
`created_by_id`	Long
`creation_method`	String
`custom_fields`	Json
`document_id`	Long
`document_revision`	Long
`document_status`	String
`document_type`	String
`external_id`	String
`integration_id`	Long
`resolved`	Boolean
`status`	String
`updated_at`	Instant
`updated_by_id`	Long

supplier_information_address

Column	Type	Keys
`id`	Long	PK
`account_type_item`	String
`active`	Boolean
`address_name`	String
`bank_account_number`	String
`bank_address`	String
`bank_city`	String
`bank_code`	String
`bank_country_id`	Long
`bank_postal_code`	String
`bank_routing_number`	String
`bank_state_region`	String
`bic`	String
`bic_routing_code`	String
`bsb_number`	String
`city`	String
`country_id`	Long
`created_at`	String
`created_by_id`	Long
`csp_rta_id`	Long
`custom_field_1`	Json
`custom_field_10`	Json
`custom_field_11`	Json
`custom_field_12`	Json
`custom_field_13`	Json
`custom_field_14`	Json
`custom_field_15`	Json
`custom_field_16`	Json
`custom_field_17`	Json
`custom_field_18`	Json
`custom_field_19`	Json
`custom_field_2`	Json
`custom_field_20`	Json
`custom_field_3`	Json
`custom_field_4`	Json
`custom_field_5`	Json
`custom_field_6`	Json
`custom_field_7`	Json
`custom_field_8`	Json
`custom_field_9`	Json
`email`	String
`iban_number`	String
`ifsc`	String
`intermediary_bank_name`	String
`international_bank_account_number`	String
`kind`	String
`location_code`	String
`name_on_bank_account`	String
`payment_method_item`	String
`po_box`	String
`po_box_postal_code`	String
`postal_code`	String
`sort_code`	String
`state_iso_code`	String
`state_region`	String
`street_address`	String
`street_address_2`	String
`street_address_3`	String
`street_address_4`	String
`supplier_information_id`	Long
`swift_code`	String
`transit_number_and_institution_number`	String
`updated_at`	Instant
`updated_by_id`	Long
`virtual_card_email`	String
`wire_routing_number`	String
`bank_fax_phone_`
`bank_work_phone_`

expense_line_mileage

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`description`	String
`distance`	Double
`distance_unit`	String
`end_address`	String
`expense_mileage_region_id`	Long
`expense_mileage_vehicle_type_id`	Long
`name`	String
`passenger_count`	Long
`round_trip`	Boolean
`start_address`	String
`updated_at`	Instant

shipping_term_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`shipping_term_id`	Long	PKFK

invoice_email

Column	Type	Keys
`id`	Long	PK
`supplier_id`	Long	PKFK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`email`	String
`send_notification`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

user_role_mapping

Column	Type	Keys
`role_id`	Long	PKFK
`user_id`	Long	PKFK

shipping_term

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`updated_at`	Instant
`updated_by_id`	Long

supplier_contact_mapping

Column	Type	Keys
`contact_id`	Long	PKFK
`supplier_id`	Long	PKFK

order_header

Column	Type	Keys
`id`	Long	PK
`acknowledged_at`	String
`acknowledged_flag`	Boolean
`change_type`	String
`coupa_accelerate_status`	String
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`exported`	Boolean
`internal_revision`	Long
`invoice_stop`	Boolean
`last_exported_at`	Instant
`payment_method`	String
`payment_term_id`	Long
`pcard_id`	Long
`po_number`	String
`price_hidden`	Boolean
`requester_id`	Long
`requisition_header_id`	Long
`ship_to_address_id`	Long
`ship_to_attention`	String
`ship_to_user_id`	Long
`shipping_term_id`	Long
`status`	String
`supplier_id`	Long
`transmission_emails`	String
`transmission_method_override`	String
`transmission_status`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`version`	Long

quote_request_lot

Column	Type	Keys
`id`	Long	PK
`custom_fields`	Json
`expected_quantity`	Long
`name`	String

budget_line_adjustment

Column	Type	Keys
`id`	Long	PK
`budget_line_id`	Long	FK
`accounting_total`	Double
`adjuster_id`	Long
`adjuster_type`	String
`adjustment_amount`	Double
`amount`	Double
`budget_remaining`	Double
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`description`	String
`price`	Double
`quantity`	Double
`reason`	String

expense_trip_segment

Column	Type	Keys
`id`	Long	PK
`expense_trip_mileage_id`	Long	PKFK
`created_at`	Instant
`custom_fields`	Json
`end_at`	Instant
`end_location`	String
`end_location_id`	String
`is_travel_segment`	Boolean
`segment_type`	String
`start_at`	Instant
`start_location`	String
`start_location_id`	String
`updated_at`	Instant

inventory_transaction_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`inventory_transaction_id`	Long	PKFK

asn_line

Column	Type	Keys
`id`	Long	PK
`asn_header_id`	Long	PKFK
`comments`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`invoice_line_id`	Long
`item_id`	Long
`line_num`	String
`match_reference`	String
`order_line_id`	Long
`quantity`	Double
`received_qty`	Double
`review_reason`	String
`soft_close_for_receiving`	Boolean
`status`	String
`supplier_aux_part_num`	String
`supplier_part_num`	String
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

budget_line

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`description`	String
`error_on_overrun`	Boolean
`notes`	String
`overrun_calculation`	Long
`owner_id`	Long
`owner_is_approver`	Long
`period_id`	Long
`remaining`	Double
`remaining_budget`	Double
`segment_1`	String
`segment_10`	String
`segment_11`	String
`segment_12`	String
`segment_13`	String
`segment_14`	String
`segment_15`	String
`segment_16`	String
`segment_17`	String
`segment_18`	String
`segment_19`	String
`segment_2`	String
`segment_20`	String
`segment_3`	String
`segment_4`	String
`segment_5`	String
`segment_6`	String
`segment_7`	String
`segment_8`	String
`segment_9`	String
`updated_at`	Instant
`updated_by_id`	Long

project_user_mapping

Column	Type	Keys
`project_id`	Long	PKFK
`user_id`	Long	PKFK

expense_per_diem_rule_condition

Column	Type	Keys
`id`	Long	PK
`expense_per_diem_rule_id`	Long	FK
`comparator`	String
`created_at`	Instant
`custom_fields`	Json
`lhs`	String
`rhs`	String
`updated_at`	Instant

expense_trip_mileage_allocation

Column	Type	Keys
`id`	Long	PK
`expense_trip_mileage_id`	Long	PKFK
`allocation_applied_distance_distance`	String
`allocation_applied_distance_unit`	String
`allocation_applied_rate_amount`	String
`allocation_applied_rate_currency_code`	String
`created_at`	Instant
`custom_fields`	Json
`expense_mileage_rate_type_id`	Long
`updated_at`	Instant

remit_to_address_tax_registration_mapping

Column	Type	Keys
`remit_to_address_id`	Long	PKFK
`tax_registration_id`	Long	PKFK

inventory_organization_warehouse_mapping

Column	Type	Keys
`inventory_organization_id`	Long	PKFK
`warehouse_id`	Long	PKFK

user_account_group_mapping

Column	Type	Keys
`account_group_id`	Long	PKFK
`user_id`	Long	PKFK

remit_to_address

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`city`	String
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`external_src_name`	String
`external_src_ref`	String
`local_tax_number`	String
`name`	String
`postal_code`	String
`remit_to_code`	String
`state`	String
`street_1`	String
`street_2`	String
`updated_at`	Instant
`updated_by_id`	Long
`vat_country_id`	Long
`vat_number`	String

unit_of_measure

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`allowable_precision`	Long
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`updated_at`	Instant
`updated_by_id`	Long

user_address

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`attention`	String
`business_group_name`	String
`city`	String
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`external_src_name`	String
`external_src_ref`	String
`local_tax_number`	String
`location_code`	String
`name`	String
`postal_code`	String
`state`	String
`state_iso_code`	String
`street_1`	String
`street_2`	String
`street_3`	String
`street_4`	String
`updated_at`	Instant
`updated_by_id`	Long
`vat_country_id`	Long
`vat_number`	String

invoice_payment_receipt

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	FK
`amount`	Double
`clearance_document`	String
`created_at`	Instant
`custom_fields`	Json
`document_uuid`	String
`exchange_rate`	Double
`legal_payment_receipt_id`	Long
`payment_method`	String
`updated_at`	Instant

expense_preapproval

Column	Type	Keys
`id`	Long	PK
`available_amount_currency_id`	Long	FK
`created_by_id`	Long	FK
`currency_id`	Long	FK
`for_user_id`	Long	FK
`updated_by_id`	Long	FK
`amount`	Double
`available`	Boolean
`available_amount`	Double
`created_at`	Instant
`custom_fields`	Json
`description`	String
`end_date`	Instant
`start_date`	Instant
`type`	String
`updated_at`	Instant

requisition_header

Column	Type	Keys
`id`	Long	PK
`receiving_warehouse_id`	Long	FK
`approver_id`	Long
`buyer_note`	String
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`current_approval_id`	Long
`custom_fields`	Json
`department_id`	Long
`exported`	Boolean
`justification`	String
`line_count`	Long
`mobile_total`	Double
`need_by_date`	Instant
`pcard_id`	Long
`price_hidden`	Boolean
`reject_reason_comment`	String
`req_title`	String
`requested_by_id`	Long
`ship_to_address_id`	Long
`ship_to_attention`	String
`status`	String
`submitted_at`	String
`total`	Double
`updated_at`	Instant
`updated_by_id`	Long

tag

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	FK
`invoice_line_id`	Long	FK
`quote_request_id`	Long	FK
`requisition_header_id`	Long	FK
`requisition_line_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`name`	String
`system_tag`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

expense_line_daily_per_diem

Column	Type	Keys
`id`	Long	PK
`expense_line_per_diem_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`expense_per_diem_rate_type_id`	Long
`max_rate`	String
`per_diem_rate`	String
`rate_applied`	String
`rate_destination`	String
`updated_at`	Instant

integration_error

Column	Type	Keys
`id`	Long	PK
`integration_run_id`	Long	FK
`contact_alert_type`	String
`created_at`	Instant
`created_by_id`	Long
`creation_method`	String
`custom_fields`	Json
`document_id`	Long
`document_revision`	Long
`document_status`	String
`document_type`	String
`external_id`	String
`integration_filename`	String
`integration_id`	Long
`resolved`	Boolean
`status`	String
`updated_at`	Instant
`updated_by_id`	Long

quote_request_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`quote_request_attachment_id`	Long	PKFK

dispute_reason

Column	Type	Keys
`id`	Long	PK
`invoice_header_id`	Long	PKFK
`code`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`updated_at`	Instant
`updated_by_id`	Long

requisition_header_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`requisition_header_id`	Long	PKFK

order_pad

Column	Type	Keys
`id`	Long	PK
`add_all_items`	Boolean
`any_supplier`	Boolean
`base_value`	Double
`base_value_currency_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`locked`	Boolean
`name`	String
`updated_at`	Instant
`updated_by_id`	Long
`use_base_value`	Boolean

integration_record_response

Column	Type	Keys
`id`	Long	PK
`integration_error_id`	Long	FK
`integration_history_record_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`response_code`	String
`response_message`	String
`updated_at`	Instant
`updated_by_id`	Long

quote_request_user

Column	Type	Keys
`id`	Long	PK
`quote_request_id`	Long	FK
`user_id`	Long	FK
`attitude`	String
`custom_fields`	Json

quote_request_line

Column	Type	Keys
`id`	Long	PK
`commodity_id`	Long	FK
`quote_request_id`	Long	FK
`quote_request_lot_id`	Long	FK
`creatable_form_id`	Long
`creatable_form_type`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`extra_line_attribute_id`	Long
`need_by_date`	String
`price_amount`	Double
`price_currency_id`	Long
`quantity`	Double
`reporting_price_amount`	Double
`type`	String
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long
`weight`	Long

expense_attendee_type

Column	Type	Keys
`id`	Long	PK
`expense_category_id`	Long	FK
`attendee_src`	String
`created_at`	Instant
`custom_fields`	Json
`name`	String
`updated_at`	Instant

expense_mileage_rate_type

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`name`	String
`rate_type`	String
`updated_at`	Instant

cp_payment

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`pay_from_account_id`	Long	FK
`pay_from_currency_id`	Long	FK
`pay_to_account_id`	Long	FK
`pay_to_currency_id`	Long	FK
`reporting_currency_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`digital_check_check_number`	String
`digital_check_id`	Long
`digital_check_status`	String
`error_text`	String
`exchange_rate`	Double
`exported`	Boolean
`external_ref_id`	Long
`last_exported_at`	Instant
`line_num`	Long
`pay_from_total`	Double
`pay_to_total`	Double
`payment_batch_description`	String
`payment_batch_id`	Long
`payment_batch_status`	String
`released_at`	Instant
`reporting_pay_from_total`	Double
`reporting_pay_to_total`	Double
`status`	String
`updated_at`	Instant
`payee_`

charge

Column	Type	Keys
`id`	Long	PK
`account_type_id`	String	FK
`accounting_currency_id`	Long	FK
`order_header_id`	Long	FK
`payment_partner_id`	Long	FK
`supplier_id`	Long	FK
`virtual_card_id`	Long	FK
`accounting_total`	Double
`card_provider_account`	String
`charge_date`	Instant
`coupa_pay_id`	String
`coupa_pay_statement_id`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`document_id`	Long
`document_type`	String
`expense_holding_account_id`	Long
`exported`	Boolean
`external_ref_id`	String
`holding_account_id`	Long
`issuer_reconciliation_id`	String
`last_exported_at`	Instant
`legal_entity_name`	String
`mcc`	String
`merchant_currency_id`	Long
`merchant_reference`	String
`merchant_total`	Double
`order_header_currency`	String
`order_header_number`	String
`order_header_total`	String
`posting_date`	Instant
`statement_id`	Long
`statement_name`	String
`supplier_name`	String
`total`	Double
`updated_at`	Instant
`updated_by_id`	Long

supplier_information_artifact

Column	Type	Keys
`id`	Long	PK
`supplier_information_id`	Long	PKFK
`supplier_id`	Long	FK
`artifact_meta_type`	String
`artifact_type`	String
`created_at`	Instant
`created_by_id`	Long
`description`	String
`effective_date`	Instant
`expiry_date`	Instant
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

cp_payment_detail_allocation_mapping

Column	Type	Keys
`payable_allocation_id`	Long	PKFK
`payment_detail_id`	Long	PKFK
`payment_id`	Long	PKFK

tax_rate

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`customer_accounting`	Boolean
`effective_date`	Instant
`exempt`	Boolean
`expiration_date`	Instant
`percentage`	Double
`reverse_charge`	Boolean
`tax_description`	String
`tax_rate_type_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

item

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`allow_partial_quantity`	Boolean
`commodity_id`	Long
`connect_item_id`	Long
`consumption_quantity`	Long
`consumption_uom_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`external_image_url`	String
`image_url`	String
`inventory_lot_tracking_enabled`	Boolean
`item_number`	String
`item_type`	String
`manufacturer_name`	String
`manufacturer_part_number`	String
`name`	String
`net_weight`	Double
`net_weight_uom_id`	Long
`pack_qty`	Double
`pack_uom_id`	Long
`pack_weight`	Double
`receive_catch_weight`	Boolean
`receiving_form_id`	Long
`reorder_point`	Double
`require_asset_tag`	Boolean
`require_inspection`	Boolean
`storage_quantity`	Long
`storage_uom_id`	Long
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long
`use_pack_weight`	Boolean

tax_code

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`code`	String
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`effective_date`	Instant
`percentage`	Double
`tax_rate_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

exchange_rate

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`from_currency_id`	Long
`rate`	Double
`rate_date`	Instant
`to_currency_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

warehouse_location

Column	Type	Keys
`id`	Long	PK
`warehouse_id`	Long	FK
`aisle`	String
`bin`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`level`	String
`name`	String
`updated_at`	Instant
`updated_by_id`	Long
`warehouse_name`	String

upload_error

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`field_errors`	Json
`field_with_error`	String
`first_column`	String
`row`	Long
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`value`	String

business_entity_external_reference

Column	Type	Keys
`id`	Long	PK
`business_entity_id`	Long	PKFK
`name`	String
`type`	String
`value`	String

requisition_line

Column	Type	Keys
`id`	Long	PK
`requisition_header_id`	Long	PKFK
`order_line_id`	Long	FK
`account_id`	Long
`commodity_id`	Long
`contract_id`	Long
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`description`	String
`end_date`	Unknown
`item_id`	Long
`line_num`	Long
`line_type`	String
`need_by_date`	Instant
`order_pad_line_id`	Long
`payment_term_id`	Long
`period_id`	Long
`punchout_site_id`	Long
`quantity`	Double
`receipt_required`	Boolean
`shipping_term_id`	Long
`source`	String
`source_part_num`	String
`source_type`	String
`start_date`	Unknown
`status`	String
`sub_line_num`	Long
`supp_aux_part_num`	String
`supplier_id`	Long
`supplier_site_id`	Long
`total`	Double
`transmission_emails`	String
`transmission_method_override`	String
`unit_price`	Double
`unspsc_code`	String
`uom_id`	Long
`updated_at`	Instant
`updated_by_id`	Long

inventory_transaction_asset_tag_mapping

Column	Type	Keys
`asset_tag_id`	Long	PKFK
`inventory_transaction_id`	Long	PKFK

payment_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`payment_id`	Long	PKFK

invoice_header_approval_mapping

Column	Type	Keys
`approval_id`	Long	PKFK
`invoice_header_id`	Long	PKFK

user_business_group_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`user_id`	Long	PKFK

expense_line_allocation

Column	Type	Keys
`id`	Long	PK
`expense_line_id`	Long	FK
`account_id`	Long
`amount`	Double
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`pct`	Double
`read_only`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

quote_request_line_attribute

Column	Type	Keys
`id`	Long	PK
`completed`	Boolean
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`end_date`	Instant
`manager_id`	Long
`start_date`	Instant
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`work_confirmer_email`	String

quote_request_attachment_response_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`quote_request_attachment_response_id`	Long	PKFK

invoice_charge

Column	Type	Keys
`id`	Long	PK
`accounting_total_currency_id`	Double	FK
`invoice_header_id`	Long	FK
`account_id`	Long
`billing_note`	String
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`distributed`	Boolean
`line_num`	Long
`pct`	Double
`period_id`	Long
`total`	Double
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

role

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`name`	String
`omnipotent`	Boolean
`system_role`	Boolean
`updated_at`	Instant
`updated_by_id`	Long

contract_party

Column	Type	Keys
`id`	Long	PK
`bill_to_address_id`	Long
`business_name`	String
`clma_id`	Long
`contact_name`	String
`contact_title`	String
`counterparty_role`	String
`created_at`	Instant
`custom_fields`	Json
`email`	String
`entity_name`	String
`mail_to_address_id`	Long
`updated_at`	Instant

tax_line

Column	Type	Keys
`id`	Long	PK
`charge_id`	Long	FK
`invoice_line_id`	Long	FK
`amount`	Double
`base`	Double
`code`	String
`code_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`description`	String
`kind_of_factor`	String
`nature_of_tax`	String
`rate`	Double
`supplier_rate`	Double
`tax_code_id`	Long
`taxable_amount`	Double
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`withholding_amount`	Double

order_header_change_order_line_change_mapping

Column	Type	Keys
`order_header_change`	Long	PKFK
`order_line_change`	Long	PKFK

comment_attachment_mapping

Column	Type	Keys
`attachment_id`	Long	PKFK
`comment_id`	Long	PKFK

expense_report

Column	Type	Keys
`id`	Long	PK
`audit_score`	Long
`auditor_note`	String
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`expensed_by_id`	Long
`exported`	Boolean
`external_src_name`	String
`external_src_ref`	String
`last_exported_at`	String
`paid`	Boolean
`past_due`	Boolean
`payment_channel`	String
`payment_id`	Long
`reimbursable_total_amount`	Double
`reimbursable_total_currency_id`	Long
`reject_reason`	String
`report_due_date`	String
`status`	String
`submitted_at`	Instant
`submitted_by_id`	Long
`title`	String
`total`	Double
`updated_at`	Instant
`updated_by_id`	Long

approval

Column	Type	Keys
`id`	Long	PK
`easy_form_id`	Long	FK
`approvable_id`	Long
`approvable_type`	String
`approval_chain_id`	Long
`approval_date`	Instant
`approved_by_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`delegate_id`	Long
`note`	String
`parent_approval_id`	Long
`position`	Long
`status`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

statement

Column	Type	Keys
`id`	Long	PK
`coupa_pay_id`	Long
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_fields`	Json
`exported`	Boolean
`external_ref_id`	String
`last_exported_at`	Instant
`name`	String
`number_of_lines`	Long
`payment_partner_id`	Long
`statement_date`	Instant
`total`	Double
`updated_at`	Instant
`updated_by_id`	Long

expense_per_diem_deduction

Column	Type	Keys
`id`	Long	PK
`expense_per_diem_config_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`effective_date`	Instant
`enabled`	Boolean
`expense_per_diem_deduction_type_id`	Long
`label`	String
`updated_at`	Instant

online_store

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`login`	String
`password`	String
`updated_at`	Instant
`url`	String

business_group_contract_mapping

Column	Type	Keys
`business_group_id`	Long	PKFK
`contract_id`	Long	PKFK

expense_line

Column	Type	Keys
`id`	Long	PK
`audit_status_updated_by_id`	Long	FK
`expense_line_mileage_id`	Long	FK
`expense_report_id`	Long	FK
`order_line_id`	Long	FK
`receipt_total_currency_id`	Long	FK
`account_id`	Long
`accounting_total`	Double
`accounting_total_currency_id`	Long
`amount`	Double
`approved_amount`	Double
`audit_status_active`	Boolean
`audit_status_created_at`	Instant
`audit_status_id`	Long
`audit_status_name`	String
`audit_status_updated_at`	Instant
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`custom_field_1`	Json
`custom_field_10`	Json
`custom_field_11`	Json
`custom_field_12`	Json
`custom_field_13`	Json
`custom_field_14`	Json
`custom_field_15`	Json
`custom_field_16`	Json
`custom_field_17`	Json
`custom_field_18`	Json
`custom_field_19`	Json
`custom_field_2`	Json
`custom_field_3`	Json
`custom_field_4`	Json
`custom_field_5`	Json
`custom_field_6`	Json
`custom_field_7`	Json
`custom_field_8`	Json
`custom_field_9`	Json
`custom_fields`	Json
`description`	String
`divisor`	Double
`employee_reimbursable`	Boolean
`end_date`	Instant
`exchange_rate`	Double
`expense_category_custom_field_1`	String
`expense_category_custom_field_10`	String
`expense_category_custom_field_2`	String
`expense_category_custom_field_3`	String
`expense_category_custom_field_4`	String
`expense_category_custom_field_5`	String
`expense_category_custom_field_6`	String
`expense_category_custom_field_7`	String
`expense_category_custom_field_8`	String
`expense_category_custom_field_9`	String
`expense_category_id`	Long
`expense_date`	Instant
`expense_line_imported_data_id`	Long
`expense_line_per_diem_id`	Long
`expense_line_preapproval_id`	Long
`expense_trip_id`	Long
`external_src_data`	String
`external_src_name`	String
`external_src_ref`	String
`foreign_currency_amount`	Double
`foreign_currency_id`	Long
`frugality`	String
`integration_id`	Long
`line_number`	Long
`merchant`	String
`over_limit`	Boolean
`parent_expense_line_id`	Long
`parent_external_src_data`	String
`parent_external_src_name`	String
`parent_external_src_ref`	String
`period_id`	Long
`reason`	String
`receipt_total_amount`	Double
`reporting_total`	Double
`requires_receipt`	Boolean
`start_date`	Instant
`status`	String
`suggested_exchange_rate_id`	Long
`type`	String
`updated_at`	Instant
`updated_by_id`	Long

easy_form_widget_data

Column	Type	Keys
`easy_form_widget_id`	Long	PK
`id`	Long	PK
`created_by_id`	Long	FK
`easy_form_id`	Long	FK
`easy_form_response_id`	Long	FK
`updated_by_id`	Long	FK
`answer`	Json
`created_at`	Instant
`encrypted_answer`	Json
`field_name`	String
`type`	String
`updated_at`	Instant
`widget_label`	String
`widget_type`	String

business_entity_relationship

Column	Type	Keys
`id`	Long	PK
`business_entity_id`	Long	PKFK
`related_business_entity_id`	Long	FK
`created_at`	Instant
`created_by_id`	Long
`relationship_type`	String
`status`	String
`updated_at`	Instant
`updated_by_id`	Long

contract

Column	Type	Keys
`id`	Long	PK
`amended_contract_type`	String
`auto_extend_end_date_for_renewal`	Boolean
`clma_id`	Long
`consent`	String
`contract_owner_id`	Long
`contract_type_custom_field_1`	String
`contract_type_custom_field_10`	String
`contract_type_custom_field_2`	String
`contract_type_custom_field_3`	String
`contract_type_custom_field_4`	String
`contract_type_custom_field_5`	String
`contract_type_custom_field_6`	String
`contract_type_custom_field_7`	String
`contract_type_custom_field_8`	String
`contract_type_custom_field_9`	String
`contract_type_id`	Long
`created_at`	Instant
`created_by_id`	Long
`currency_id`	Long
`current_approval_id`	Long
`custom_fields`	Json
`default_account_id`	Long
`department_id`	Long
`description`	String
`end_date`	Instant
`execution_date`	Instant
`external_contract_id`	String
`fill_with_counterparty`	Boolean
`is_default`	Boolean
`legal_agreement_url`	String
`length_of_notice_unit`	String
`length_of_notice_value`	String
`master_contract_id`	Long
`max_commit`	Double
`maximum_value`	Double
`min_commit`	Double
`minimum_value`	Double
`name`	String
`no_of_renewals`	String
`number`	String
`order_window_tz`	String
`parent_id`	Long
`payment_term_id`	Long
`po_message`	String
`preferred`	Boolean
`proxy_supplier_id`	Long
`published_date`	String
`quote_response_id`	Long
`renewal_length_unit`	String
`renewal_length_value`	String
`requisition_message`	String
`savings_pct`	Double
`shipping_term_id`	Long
`source`	String
`source_id`	String
`source_type`	String
`start_date`	Instant
`status`	String
`stop_spend_based_on_max_value`	String
`strict_invoicing_rules`	Boolean
`submitter_id`	Long
`supplier_account`	String
`supplier_id`	Long
`supplier_invoiceable`	Boolean
`term_type`	String
`terminated`	Boolean
`termination_notice`	String
`termination_notice_length_unit`	String
`termination_notice_length_value`	String
`terms`	String
`type`	String
`updated_at`	Instant
`updated_by_id`	Long
`use_online_signing`	Boolean
`use_order_window`	Boolean
`used_for_buying`	Boolean
`version`	Long
`whose_paper`	String
`contractDetail_`

punchout_site

Column	Type	Keys
`id`	Long	PK
`created_by_id`	Long	FK
`updated_by_id`	Long	FK
`contract_id`	Long
`created_at`	Instant
`custom_fields`	Json
`disable_cert_verify`	Boolean
`domain`	String
`identity`	String
`is_from_coupa_checkout`	Boolean
`name`	String
`protocol`	String
`secret`	String
`sender_domain`	String
`sender_identity`	String
`ssl_version`	String
`supplier_id`	Long
`supports_edit`	Boolean
`supports_inspect`	Boolean
`updated_at`	Instant
`url`	String

payable_allocation

Column	Type	Keys
`id`	Long	PK
`payable_from_currency_id`	Long	FK
`payable_to_currency_id`	Long	FK
`bypass_strict_validations`	Boolean
`exported`	Boolean
`last_exported_at`	Instant
`payable_from_amount`	Double
`payable_from_id`	Int
`payable_from_type`	String
`payable_to_amount`	Double
`payable_to_id`	Long
`payable_to_type`	String
`payment_reference_id`	Long
`payment_reference_type`	String
`reason_code`	String
`source`	String
`source_transaction_from_id`	String
`source_transaction_from_reference`	String
`source_transaction_from_type`	String
`source_transaction_to_id`	String
`source_transaction_to_reference`	String
`source_transaction_to_type`	String
`status`	String

address

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`attention`	String
`business_group_name`	String
`city`	String
`country_id`	Long
`created_at`	Instant
`created_by_id`	Long
`custom_fields`	Json
`external_src_name`	String
`external_src_ref`	String
`local_tax_number`	String
`location_code`	String
`name`	String
`postal_code`	String
`state`	String
`state_iso_code`	String
`street_1`	String
`street_2`	String
`street_3`	String
`street_4`	String
`updated_at`	Instant
`updated_by_id`	Long
`vat_country_id`	Long
`vat_number`	String

expense_per_diem_rule

Column	Type	Keys
`id`	Long	PK
`expense_per_diem_config_id`	Long	FK
`created_at`	Instant
`custom_fields`	Json
`effective_date`	Instant
`enabled`	Boolean
`end_after`	Instant
`end_before`	Instant
`expense_per_diem_rate_type_id`	Long
`expense_per_diem_time_range_condition_id`	Long
`hours`	Double
`label`	String
`rank`	Long
`rate_frequency`	String
`rate_location_type`	String
`rate_logic`	Long
`rate_percentage`	Double
`rule_type`	String
`start_after`	Instant
`start_before`	Instant
`updated_at`	Instant

cp_account_type_mapping

Column	Type	Keys
`account_id`	Long	PKFK
`account_type_id`	Long	PKFK
`cp_payment_id`	Long	PKFK

expense_trip_mileage

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`custom_fields`	Json
`expense_mileage_region_id`	Long
`expense_mileage_vehicle_type_id`	Long
`original_distance`	String
`passenger_count`	Long
`total_distance`	String
`total_distance_unit`	String
`updated_at`	Instant

user_expenses_delegated_to_mapping

Column	Type	Keys
`expenses_delgated_to_id`	Long	PKFK
`user_id`	Long	PKFK