# Ramp schema ERD

Table and field reference for the Fivetran Ramp connector.

## Table & Field Reference

### business_entity_account

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| business_entity_id | Unknown | PK, FK |
| bank_account_id | Unknown |  |
| classification | Unknown |  |
| created_at | Unknown |  |
| external_id | Unknown |  |
| external_name | Unknown |  |
| internal_id | Unknown |  |
| usage_type | Unknown |  |

### business_entity_location

| Column | Type | Keys |
| --- | --- | --- |
| business_entity_id | Unknown | PK, FK |
| location_id | Unknown | PK, FK |

### business_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connected_subsidiary_external_id | Unknown |  |
| connected_subsidiary_id | Unknown |  |
| connected_subsidiary_name | Unknown |  |
| currency | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |

### balance

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| available_card_limit | Double |  |
| available_flex_limit | Double |  |
| balance_including_pending | Double |  |
| card_balance_excluding_pending | Double |  |
| card_balance_including_pending | Double |  |
| card_limit | Double |  |
| flex_balance | Double |  |
| flex_limit | Double |  |
| float_balance_excluding_pending | Double |  |
| global_limit | Double |  |
| max_balance | Double |  |
| next_billing_date | Unknown |  |
| prev_billing_date | Unknown |  |
| statement_balance | Double |  |

### spend_program_allowed_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| spend_program_id | Unknown | PK, FK |
| allowed_category | Unknown |  |

### spend_program_allowed_vendor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| spend_program_id | Unknown | PK, FK |
| allowed_vendor | Unknown |  |

### spend_program_blocked_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| spend_program_id | Unknown | PK, FK |
| blocked_category | Unknown |  |

### spend_program_blocked_vendor

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| spend_program_id | Unknown | PK, FK |
| blocked_vendor | Unknown |  |

### spend_program

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| display_name | Unknown |  |
| icon | Unknown |  |
| is_shareable | Unknown |  |
| issue_physical_card_if_needed | Unknown |  |
| limit_amount | Unknown |  |
| limit_currency_code | Unknown |  |
| permitted_spend_type_primary_card_enabled | Unknown |  |
| permitted_spend_type_reimbursements_enabled | Unknown |  |
| restriction_auto_lock_date | Unknown |  |
| restriction_interval | Unknown |  |
| restriction_next_interval_reset | Unknown |  |
| restriction_start_of_interval | Unknown |  |
| temporary_limit_amount | Unknown |  |
| temporary_limit_currency_code | Unknown |  |
| transaction_amount_limit_amount | Unknown |  |
| transaction_amount_limit_currency_code | Unknown |  |

### reimbursement_receipt

| Column | Type | Keys |
| --- | --- | --- |
| receipt_id | String | PK |
| reimbursement_id | String | PK, FK |

### reimbursement_accouting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reimbursement_id | String | PK, FK |
| category_external_id | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| category_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### reimbursement_attendees

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| reimbursement_id | String | PK, FK |
| user_id | Unknown | FK |
| name | Unknown |  |

### reimbursement_line_item_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reimbursement_id | String | PK, FK |
| reimbursement_line_item_index | Unknown | PK, FK |
| category_external_id | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| category_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### reimbursement_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| reimbursement_id | String | PK, FK |
| amount_amount | Unknown |  |
| amount_currency_code | Unknown |  |

### reimbursement

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| merchant_id | Unknown | FK |
| user_id | Unknown | FK |
| accounting_date | Unknown |  |
| amount | Double |  |
| created_at | Unknown |  |
| currency | String |  |
| direction | String |  |
| distance | Unknown |  |
| entity_id | Unknown |  |
| memo | Unknown |  |
| merchant | String |  |
| original_reimbursement_amount | Unknown |  |
| original_reimbursement_currency_code | Unknown |  |
| payee_amount | Unknown |  |
| payee_currency_code | Unknown |  |
| payment_batch_id | Unknown |  |
| payment_id | Unknown |  |
| payment_processed_at | Unknown |  |
| spend_limit_id | Unknown |  |
| state | Unknown |  |
| submitted_at | Unknown |  |
| sync_status | Unknown |  |
| synced_at | Unknown |  |
| transaction_date | Unknown |  |
| trip_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### bill_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| category_info_external_id | Unknown |  |
| category_info_id | Unknown |  |
| category_info_name | Unknown |  |
| category_info_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |

### bill_inventory_line_item_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| bill_inventory_line_item_index | Unknown | PK, FK |
| category_info_external_id | Unknown |  |
| category_info_id | Unknown |  |
| category_info_name | Unknown |  |
| category_info_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |

### bill_inventory_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| memo | Unknown |  |
| unit_price_amount | Unknown |  |
| unit_price_currency_code | Unknown |  |
| unit_quantity | Unknown |  |

### bill_invoice_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| invoice_url | Unknown |  |

### bill_line_item_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| bill_line_item_index | Unknown | PK, FK |
| category_info_external_id | Unknown |  |
| category_info_id | Unknown |  |
| category_info_name | Unknown |  |
| category_info_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |

### bill_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| memo | Unknown |  |

### bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | FK |
| vendor_contact_id | Unknown | FK |
| vendor_id | Unknown | FK |
| accounting_date | Unknown |  |
| accounting_sync_date | Unknown |  |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| approval_status | Unknown |  |
| archived_at | Unknown |  |
| bill_owner_first_name | Unknown |  |
| bill_owner_id | Unknown |  |
| bill_owner_last_name | Unknown |  |
| created_at | Unknown |  |
| deep_link_url | Unknown |  |
| draft_bill_created_at | Unknown |  |
| due_at | Unknown |  |
| fx_conversion_rate | Unknown |  |
| invoice_number | Unknown |  |
| issued_at | Unknown |  |
| memo | Unknown |  |
| paid_at | Unknown |  |
| payment_amount | Unknown |  |
| payment_amount_currency_code | Unknown |  |
| payment_date | Unknown |  |
| payment_details_spend_limit_id | Unknown |  |
| payment_details_transaction_ids | Json |  |
| payment_effective_date | Unknown |  |
| payment_method | Unknown |  |
| payment_traceid | Unknown |  |
| payment_traceid_descriptor | Unknown |  |
| posting_date | Unknown |  |
| remote_id | Unknown |  |
| status | Unknown |  |
| status_summary | Unknown |  |
| sync_status | Unknown |  |
| vendor_memo | Unknown |  |
| vendor_remote_code | Unknown |  |
| vendor_remote_id | Unknown |  |
| vendor_remote_name | Unknown |  |

### merchant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| is_auto_approved | Unknown |  |
| name | Unknown |  |
| sk_category_name | Unknown |  |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | String | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| business_id | Unknown | FK |
| department_id | Unknown | FK |
| location_id | Unknown | FK |
| email | String |  |
| employee_id | Unknown |  |
| first_name | String |  |
| is_manager | Boolean |  |
| last_name | String |  |
| manager_id | String |  |
| phone | String |  |
| role | String |  |
| status | String |  |

### purchase_order_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| category_info_external_id | Unknown |  |
| category_info_id | Unknown |  |
| category_info_name | Unknown |  |
| category_info_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |

### purchase_order_transaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| transaction_id | Unknown | FK |

### purchase_order_bill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| bill_id | Unknown | FK |

### purchase_order_line_item_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| purchase_order_line_item_id | Unknown | PK, FK |
| category_info_external_id | Unknown |  |
| category_info_id | Unknown |  |
| category_info_name | Unknown |  |
| category_info_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| description | Unknown |  |
| remote_id | Unknown |  |
| unit_price_amount | Unknown |  |
| unit_price_currency_code | Unknown |  |
| unit_quantity | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | FK |
| user_id | Unknown | FK |
| vendor_id | Unknown | FK |
| amount | Unknown |  |
| amount_currency_code | Unknown |  |
| archived_at | Unknown |  |
| billing_status | Unknown |  |
| created_at | Unknown |  |
| creation_source | Unknown |  |
| memo | Unknown |  |
| name | Unknown |  |
| net_payment_terms | Unknown |  |
| owner_id | Unknown |  |
| promise_date | Unknown |  |
| purchase_order_number | Unknown |  |
| receipt_status | Unknown |  |
| spend_end_date | Unknown |  |
| spend_request_id | Unknown |  |
| spend_start_date | Unknown |  |
| spend_total_amount | Unknown |  |
| spend_total_currency_code | Unknown |  |
| three_way_match_enabled | Unknown |  |

### receipt

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| transaction_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| receipt_url | String |  |

### card_spending_restriction_category

| Column | Type | Keys |
| --- | --- | --- |
| category_code | String | PK |
| card_id | String | PK, FK |

### card_spending_restriction_blocked_category

| Column | Type | Keys |
| --- | --- | --- |
| blocked_category_code | String | PK |
| card_id | String | PK, FK |

### card

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cardholder_id | Unknown | FK |
| created_at | Unknown |  |
| display_name | String |  |
| expiration | Unknown |  |
| fulfillment_fulfillment_status | String |  |
| fulfillment_shipping_date | Instant |  |
| fulfillment_shipping_eta | Instant |  |
| fulfillment_shipping_recipient_address_address_1 | String |  |
| fulfillment_shipping_recipient_address_city | String |  |
| fulfillment_shipping_recipient_address_country | String |  |
| fulfillment_shipping_recipient_address_first_name | String |  |
| fulfillment_shipping_recipient_address_last_name | String |  |
| fulfillment_shipping_recipient_address_postal_code | String |  |
| fulfillment_shipping_recipient_address_state | String |  |
| fulfillment_shipping_tracking_url | String |  |
| has_program_overidden | Boolean |  |
| is_physical | Boolean |  |
| last_four | String |  |
| spending_restrictions_amount | Double |  |
| spending_restrictions_auto_lock_date | Instant |  |
| spending_restrictions_interval | String |  |
| spending_restrictions_suspended | Boolean |  |
| spending_restrictions_transaction_amount_limit | Double |  |
| state | String |  |

### vendor_agreement_contract_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_agreement_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_name | Unknown |  |
| profile_picture_url | Unknown |  |

### vendor_agreement_custom_record_field_value

| Column | Type | Keys |
| --- | --- | --- |
| column_id | Unknown | PK |
| vendor_agreement_id | Unknown | PK, FK |
| column_display_name | Unknown |  |
| value_display_name | Unknown |  |
| value_type | Unknown |  |
| value_value | Unknown |  |

### vendor_agreement_draft_spend_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_agreement_id | Unknown | PK, FK |
| name | Unknown |  |
| source | Unknown |  |
| total_amount | Unknown |  |
| unified_request_id | Unknown |  |
| updated_at | Unknown |  |

### vendor_agreement_vendor_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_agreement_id | Unknown | PK, FK |
| first_name | Unknown |  |
| full_name | Unknown |  |
| last_name | Unknown |  |

### vendor_agreement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payee_id | Unknown | FK |
| auto_renewal | Unknown |  |
| available_actions | Json |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| days_remaining_end_date_used | Unknown |  |
| days_remaining_is_expired | Unknown |  |
| days_remaining_is_overdue | Unknown |  |
| days_remaining_num_days_until_end | Unknown |  |
| deleted_at | Unknown |  |
| department_id | Unknown |  |
| department_name | Unknown |  |
| description | Unknown |  |
| end_date | Unknown |  |
| has_approved_renewal_request | Unknown |  |
| is_snoozed | Unknown |  |
| is_up_for_renewal | Unknown |  |
| last_date_to_terminate | Unknown |  |
| latest_renewal_request_currency | Unknown |  |
| latest_renewal_request_id | Unknown |  |
| latest_renewal_request_name | Unknown |  |
| latest_renewal_request_request_status | Unknown |  |
| latest_renewal_request_submitted_at | Unknown |  |
| latest_renewal_request_total_amount_amount | Unknown |  |
| latest_renewal_request_total_amount_currency_code | Unknown |  |
| latest_renewal_request_total_amount_minor_unit_conversion_rate | Unknown |  |
| latest_renewal_request_unified_request_id | Unknown |  |
| latest_renewal_request_user_full_name | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| notifications_on | Unknown |  |
| payee_name | Unknown |  |
| renewal_status | Unknown |  |
| start_date | Unknown |  |
| total_value_amount | Unknown |  |
| total_value_currency_code | Unknown |  |
| total_value_minor_unit_conversion_rate | Unknown |  |
| updated_at | Unknown |  |

### vendor_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK |
| vendor_id | Unknown | PK, FK |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounting_vendor_remote_id | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| billing_frequency | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| federal_tax_classification | Unknown |  |
| is_active | Unknown |  |
| is_deletable | Unknown |  |
| merchant_id | Unknown |  |
| name | Unknown |  |
| name_legal | Unknown |  |
| owner_id | Unknown |  |
| sk_category_id | Unknown |  |
| sk_category_name | Unknown |  |
| state | Unknown |  |
| tax_address_city | Unknown |  |
| tax_address_country | Unknown |  |
| tax_address_line_1 | Unknown |  |
| tax_address_line_2 | Unknown |  |
| tax_address_postal_code | Unknown |  |
| tax_address_state | Unknown |  |
| total_spend_all_time_amount | Unknown |  |
| total_spend_all_time_currency_code | Unknown |  |
| total_spend_all_time_minor_unit_conversion_rate | Unknown |  |
| total_spend_last_30_days_amount | Unknown |  |
| total_spend_last_30_days_currency_code | Unknown |  |
| total_spend_last_30_days_minor_unit_conversion_rate | Unknown |  |
| total_spend_last_365_days_amount | Unknown |  |
| total_spend_last_365_days_currency_code | Unknown |  |
| total_spend_last_365_days_minor_unit_conversion_rate | Unknown |  |
| total_spend_ytd_amount | Unknown |  |
| total_spend_ytd_currency_code | Unknown |  |
| total_spend_ytd_minor_unit_conversion_rate | Unknown |  |
| type | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

### limit_card

| Column | Type | Keys |
| --- | --- | --- |
| card_id | Unknown | PK, FK |
| limit_id | Unknown | PK, FK |
| is_ap_card | Unknown |  |
| via_new_product_or_service | Unknown |  |

### limit_category_whitelist

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| limit_id | Unknown | PK, FK |
| category_whitelist | Unknown |  |

### limit_allowed_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| limit_id | Unknown | PK, FK |
| allowed_category | Unknown |  |

### limit_vendor_blacklist

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| limit_id | Unknown | PK, FK |
| vendor_blacklist | Unknown |  |

### limit_users

| Column | Type | Keys |
| --- | --- | --- |
| limit_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### limits

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| spend_program_id | Unknown | FK |
| suspension_acting_user_id | Unknown | FK |
| balance_cleared_amount | Unknown |  |
| balance_cleared_currency_code | Unknown |  |
| balance_pending_amount | Unknown |  |
| balance_pending_currency_code | Unknown |  |
| balance_total_amount | Unknown |  |
| balance_total_currency_code | Unknown |  |
| created_at | Unknown |  |
| display_name | Unknown |  |
| entity_id | Unknown |  |
| has_program_overridden | Unknown |  |
| is_shareable | Unknown |  |
| limit_amount | Unknown |  |
| limit_currency_code | Unknown |  |
| permitted_spend_type_primary_card_enabled | Unknown |  |
| permitted_spend_type_reimbursements_enabled | Unknown |  |
| restriction_auto_lock_date | Unknown |  |
| restriction_interval | Unknown |  |
| restriction_next_interval_reset | Unknown |  |
| restriction_start_of_interval_date | Unknown |  |
| state | Unknown |  |
| suspension_inserted_at | Unknown |  |
| suspension_suspended_by_ramp | Unknown |  |
| temporary_limit_amount | Unknown |  |
| temporary_limit_currency_code | Unknown |  |
| transaction_amount_limit_amount | Unknown |  |
| transaction_amount_limit_currency_code | Unknown |  |

### business

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| active | Boolean |  |
| billing_address_address_1 | String |  |
| billing_address_city | String |  |
| billing_address_country | String |  |
| billing_address_postal_code | String |  |
| billing_address_state | String |  |
| business_name_legal | String |  |
| business_name_on_card | String |  |
| created_time | Instant |  |
| enforce_sso | Boolean |  |
| initial_approved_limit | Double |  |
| is_integrated_with_slack | Boolean |  |
| is_reimbursements_enabled | Boolean |  |
| limit_locked | Boolean |  |
| phone | String |  |
| website | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| entity_id | Unknown |  |
| name | String |  |

### transaction_accounting_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | String | PK, FK |
| category_id | String |  |
| category_name | String |  |
| tracking_category_remote_id | String |  |
| tracking_category_remote_name | String |  |
| tracking_category_remote_type | String |  |

### transaction_policy_violation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | String | PK, FK |
| created_at | Instant |  |
| id | String |  |
| memo | String |  |
| type | String |  |

### transaction_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | String | PK, FK |
| category_external_id | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| category_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### transaction_attendees

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | String | PK, FK |
| user_id | Unknown | FK |
| name | Unknown |  |

### transaction_line_item_accounting_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_line_item_index | Unknown | PK, FK |
| transaction_line_item_transaction_id | String | PK, FK |
| category_external_id | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| category_type | Unknown |  |
| external_code | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### transaction_line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | String | PK, FK |
| amount_amount | Unknown |  |
| amount_currency_code | Unknown |  |
| converted_amount | Unknown |  |
| converted_currency_code | Unknown |  |

### transaction_merchant_receipt

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | String | PK, FK |
| commodity_code | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| quantity | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| unit_cost | Unknown |  |

### transaction_dispute

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| transaction_id | String | PK, FK |
| created_at | Instant |  |
| memo | String |  |
| type | String |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| card_holder_department_id | Unknown | FK |
| card_holder_location_id | Unknown | FK |
| card_holder_user_id | Unknown | FK |
| card_id | Unknown | FK |
| limit_id | Unknown | FK |
| spend_program_id | Unknown | FK |
| accounting_date | Unknown |  |
| amount | Double |  |
| currency_code | Unknown |  |
| entity_id | Unknown |  |
| memo | String |  |
| merchant_category_code | String |  |
| merchant_category_code_description | String |  |
| merchant_data_auto_rental | Unknown |  |
| merchant_data_flight | Unknown |  |
| merchant_data_fuel | Unknown |  |
| merchant_data_lodging | Unknown |  |
| merchant_data_reference | Unknown |  |
| merchant_descriptor | String |  |
| merchant_id | String |  |
| merchant_location_city | Unknown |  |
| merchant_location_country | Unknown |  |
| merchant_location_postal_code | Unknown |  |
| merchant_location_state | Unknown |  |
| merchant_name | String |  |
| original_transaction_amount_amount | Unknown |  |
| original_transaction_amount_currency_code | Unknown |  |
| receipts | Json |  |
| settlement_date | Unknown |  |
| sk_category_id | String |  |
| sk_category_name | String |  |
| state | String |  |
| sync_status | Unknown |  |
| synced_at | Unknown |  |
| trip_id | Unknown |  |
| trip_name | Unknown |  |
| updated_at | Instant |  |
| user_transaction_time | Unknown |  |

## Relationships

- business_entity_account(business_entity_id) → business_entity(id)
- business_entity_location(location_id) → location(id)
- business_entity_location(business_entity_id) → business_entity(id)
- spend_program_allowed_category(spend_program_id) → spend_program(id)
- spend_program_allowed_vendor(spend_program_id) → spend_program(id)
- spend_program_blocked_category(spend_program_id) → spend_program(id)
- spend_program_blocked_vendor(spend_program_id) → spend_program(id)
- reimbursement_receipt(reimbursement_id) → reimbursement(id)
- reimbursement_accouting_field_selection(reimbursement_id) → reimbursement(id)
- reimbursement_attendees(user_id) → users(id)
- reimbursement_attendees(reimbursement_id) → reimbursement(id)
- reimbursement_line_item_accounting_field_selection(reimbursement_id) → reimbursement_line_item(reimbursement_id)
- reimbursement_line_item_accounting_field_selection(reimbursement_line_item_index) → reimbursement_line_item(index)
- reimbursement_line_item(reimbursement_id) → reimbursement(id)
- reimbursement(user_id) → users(id)
- reimbursement(merchant_id) → merchant(id)
- bill_accounting_field_selection(bill_id) → bill(id)
- bill_inventory_line_item_accounting_field_selection(bill_id) → bill_inventory_line_item(bill_id)
- bill_inventory_line_item_accounting_field_selection(bill_inventory_line_item_index) → bill_inventory_line_item(index)
- bill_inventory_line_item(bill_id) → bill(id)
- bill_invoice_url(bill_id) → bill(id)
- bill_line_item_accounting_field_selection(bill_id) → bill_line_item(bill_id)
- bill_line_item_accounting_field_selection(bill_line_item_index) → bill_line_item(index)
- bill_line_item(bill_id) → bill(id)
- bill(entity_id) → business_entity(id)
- bill(vendor_contact_id) → vendor_contact(contact_id)
- bill(vendor_id) → vendor(id)
- user_custom_field(user_id) → users(id)
- users(department_id) → department(id)
- users(location_id) → location(id)
- users(business_id) → business(id)
- purchase_order_accounting_field_selection(purchase_order_id) → purchase_order(id)
- purchase_order_transaction(transaction_id) → transaction(id)
- purchase_order_transaction(purchase_order_id) → purchase_order(id)
- purchase_order_bill(bill_id) → bill(id)
- purchase_order_bill(purchase_order_id) → purchase_order(id)
- purchase_order_line_item_accounting_field_selection(purchase_order_id) → purchase_order_line_item(purchase_order_id)
- purchase_order_line_item_accounting_field_selection(purchase_order_line_item_id) → purchase_order_line_item(id)
- purchase_order_line_item(purchase_order_id) → purchase_order(id)
- purchase_order(user_id) → users(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(entity_id) → business_entity(id)
- receipt(transaction_id) → transaction(id)
- receipt(user_id) → users(id)
- card_spending_restriction_category(card_id) → card(id)
- card_spending_restriction_blocked_category(card_id) → card(id)
- card(cardholder_id) → users(id)
- vendor_agreement_contract_owner(vendor_agreement_id) → vendor_agreement(id)
- vendor_agreement_custom_record_field_value(vendor_agreement_id) → vendor_agreement(id)
- vendor_agreement_draft_spend_request(vendor_agreement_id) → vendor_agreement(id)
- vendor_agreement_vendor_owner(vendor_agreement_id) → vendor_agreement(id)
- vendor_agreement(payee_id) → vendor(id)
- vendor_contact(vendor_id) → vendor(id)
- limit_card(card_id) → card(id)
- limit_card(limit_id) → limits(id)
- limit_category_whitelist(limit_id) → limits(id)
- limit_allowed_category(limit_id) → limits(id)
- limit_vendor_blacklist(limit_id) → limits(id)
- limit_users(user_id) → users(id)
- limit_users(limit_id) → limits(id)
- limits(spend_program_id) → spend_program(id)
- limits(suspension_acting_user_id) → users(id)
- transaction_accounting_category(transaction_id) → transaction(id)
- transaction_policy_violation(transaction_id) → transaction(id)
- transaction_accounting_field_selection(transaction_id) → transaction(id)
- transaction_attendees(user_id) → users(id)
- transaction_attendees(transaction_id) → transaction(id)
- transaction_line_item_accounting_field_selection(transaction_line_item_transaction_id) → transaction_line_item(transaction_id)
- transaction_line_item_accounting_field_selection(transaction_line_item_index) → transaction_line_item(index)
- transaction_line_item(transaction_id) → transaction(id)
- transaction_merchant_receipt(transaction_id) → transaction(id)
- transaction_dispute(transaction_id) → transaction(id)
- transaction(card_id) → card(id)
- transaction(spend_program_id) → spend_program(id)
- transaction(limit_id) → limits(id)
- transaction(card_holder_department_id) → department(id)
- transaction(card_holder_location_id) → location(id)
- transaction(card_holder_user_id) → users(id)