Ramp
Explore the interactive ERD
Table & Field Reference
business_entity_account
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
business_entity_id | Unknown | PKFK |
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 | PKFK |
location_id | Unknown | PKFK |
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 | PKFK |
allowed_category | Unknown |
spend_program_allowed_vendor
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
spend_program_id | Unknown | PKFK |
allowed_vendor | Unknown |
spend_program_blocked_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
spend_program_id | Unknown | PKFK |
blocked_category | Unknown |
spend_program_blocked_vendor
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
spend_program_id | Unknown | PKFK |
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 | PKFK |
reimbursement_accouting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reimbursement_id | String | PKFK |
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 | PKFK |
user_id | Unknown | FK |
name | Unknown |
reimbursement_line_item_accounting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reimbursement_id | String | PKFK |
reimbursement_line_item_index | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
bill_inventory_line_item_index | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
invoice_url | Unknown |
bill_line_item_accounting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bill_id | Unknown | PKFK |
bill_line_item_index | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
transaction_id | Unknown | FK |
purchase_order_bill
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purchase_order_id | Unknown | PKFK |
bill_id | Unknown | FK |
purchase_order_line_item_accounting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
purchase_order_line_item_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
card_spending_restriction_blocked_category
| Column | Type | Keys |
|---|---|---|
blocked_category_code | String | PK |
card_id | String | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
limit_id | Unknown | PKFK |
is_ap_card | Unknown | |
via_new_product_or_service | Unknown |
limit_category_whitelist
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
limit_id | Unknown | PKFK |
category_whitelist | Unknown |
limit_allowed_category
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
limit_id | Unknown | PKFK |
allowed_category | Unknown |
limit_vendor_blacklist
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
limit_id | Unknown | PKFK |
vendor_blacklist | Unknown |
limit_users
| Column | Type | Keys |
|---|---|---|
limit_id | Unknown | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
created_at | Instant | |
id | String | |
memo | String | |
type | String |
transaction_accounting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transaction_id | String | PKFK |
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 | PKFK |
user_id | Unknown | FK |
name | Unknown |
transaction_line_item_accounting_field_selection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transaction_line_item_index | Unknown | PKFK |
transaction_line_item_transaction_id | String | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 |