# Coupa schema ERD

Table and field reference for the Fivetran Coupa connector.

## Table & Field Reference

### invoice_header_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| invoice_header_id | Long | PK, FK |

### user_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| user_id | Long | PK, FK |

### requisition_line_asset_tag_mapping

| Column | Type | Keys |
| --- | --- | --- |
| asset_tag_id | Long | PK, FK |
| requisition_line_id | Long | PK, FK |

### 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 |  |

### 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_** |  |  |

### quote_request_attachment_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| quote_response_id | Long | PK, FK |
| custom_fields | Json |  |
| buyer** |  |  |

### 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 |  |

### 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 |  |

### user_approval_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_group_id | Long | PK, FK |
| user_id | Long | PK, FK |

### supplier_address_mapping

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### contract_current_parallel_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| contract_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### cp_payment_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| cp_payment_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### payment_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| payment_id | Long | PK, FK |

### inventory_transaction_asset_tag_mapping

| Column | Type | Keys |
| --- | --- | --- |
| asset_tag_id | Long | PK, FK |
| inventory_transaction_id | Long | PK, FK |

### invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| invoice_header_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### shipping_term_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| shipping_term_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### contract_template_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| contract_template_id | Long | PK, FK |

### 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 |  |

### project_user_mapping

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Long | PK, FK |
| user_id | Long | PK, FK |

### lookup_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| lookup_id | Long | PK, FK |

### inventory_transaction_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| inventory_transaction_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### quote_request_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| quote_request_attachment_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### expense_trip

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

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### payment_partner_account_type_mapping

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Long | PK, FK |
| account_type_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| payment_partner_id | Long | PK, FK |

### 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 |  |

### invoice_line_allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| invoice_header_id | Long | PK, FK |
| invoice_line_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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_information_contact_mapping

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| supplier_information_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### commodity_translation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| commodity_id | Long |  |
| created_at | Instant |  |
| custom_fields | Json |  |
| locale | String |  |
| name | 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 |  |

### expense_mileage_rate_type

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

### invoice_header_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| invoice_header_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### quote_request_lot

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| custom_fields | Json |  |
| expected_quantity | Long |  |
| name | String |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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_** |  |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### cp_payment_detail_allocation_mapping

| Column | Type | Keys |
| --- | --- | --- |
| payable_allocation_id | Long | PK, FK |
| payment_detail_id | Long | PK, FK |
| payment_id | Long | PK, FK |

### 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 |  |

### bulk_price

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

### 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 |  |

### business_entity_alternate_name

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| business_entity_id | Long | PK, FK |
| name | String |  |

### user_role_mapping

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Long | PK, FK |
| user_id | Long | PK, FK |

### expense_line_imported_data

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

### 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 |  |

### business_group_contract_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| contract_id | Long | PK, FK |

### address_business_group_relation

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| business_group_id | Long | PK, FK |

### 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 |  |

### user_can_expense_for_mapping

| Column | Type | Keys |
| --- | --- | --- |
| can_expense_for_id | Long | PK, FK |
| user_id | Long | PK, FK |

### 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_** |  |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### user_working_warehouse_mapping

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Long | PK, FK |
| warehouse_id | Long | PK, FK |

### quote_response_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| quote_response_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### business_entity_external_reference

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| business_entity_id | Long | PK, FK |
| name | String |  |
| type | String |  |
| value | String |  |

### quote_response_line_easy_form_data_mapping

| Column | Type | Keys |
| --- | --- | --- |
| easy_form_data_id | Long | PK, FK |
| easy_form_id | Long | PK, FK |
| quote_response_line_id | Long | PK, FK |

### 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 |  |

### expense_report_comment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Long | PK, FK |
| expense_report_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### order_header_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| order_header_id | Long | PK, FK |

### user_group_user_mapping

| Column | Type | Keys |
| --- | --- | --- |
| user_group_id | Long | PK, FK |
| user_id | Long | PK, FK |

### 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_header_change_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| order_header_change_id | Long | PK, FK |

### supplier_information_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| supplier_information_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### invoice_charge_tax_line_mapping

| Column | Type | Keys |
| --- | --- | --- |
| invoice_charge_id | Long | PK, FK |
| tax_line_id | Long | PK, FK |

### order_pad_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| order_pad_id | Long | PK, FK |

### user_account_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| account_group_id | Long | PK, FK |
| user_id | Long | PK, FK |

### user_address_mapping

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| user_id | Long | PK, FK |

### 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 |  |

### requisition_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| requisition_header_id | Long | PK, FK |
| 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 |  |

### business_entity_address_mapping

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| business_entity_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### easy_form_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| easy_form_id | Long | PK, FK |

### remit_to_address_tax_registration_mapping

| Column | Type | Keys |
| --- | --- | --- |
| remit_to_address_id | Long | PK, FK |
| tax_registration_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### virtual_card_partner_account_type_mapping

| Column | Type | Keys |
| --- | --- | --- |
| account_type_id | Long | PK, FK |
| virtual_card_partner_id | Long | PK, FK |

### 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 |  |

### inventory_organization_warehouse_mapping

| Column | Type | Keys |
| --- | --- | --- |
| inventory_organization_id | Long | PK, FK |
| warehouse_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### quote_request_attachment_response_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| quote_request_attachment_response_id | Long | PK, FK |

### supplier_remit_to_address_mapping

| Column | Type | Keys |
| --- | --- | --- |
| remit_to_address_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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 |  |

### order_header_change_order_line_change_mapping

| Column | Type | Keys |
| --- | --- | --- |
| order_header_change | Long | PK, FK |
| order_line_change | Long | PK, FK |

### 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 |  |

### 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 |  |

### expense_mileage_vehicle_type

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

### 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 |  |

### 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 |  |

### expense_trip_mileage_allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| expense_trip_mileage_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### business_entity_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| business_entity_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### contract_party_contract_mapping

| Column | Type | Keys |
| --- | --- | --- |
| contract_id | Long | PK, FK |
| contract_party_id | Long | PK, FK |

### inventory_transaction_valuation

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| inventory_transaction_id | Long | FK |
| custom_fields | Json |  |
| price | Double |  |
| quantity | Double |  |
| uom_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_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 |  |

### supplier_restricted_account_type_mapping

| Column | Type | Keys |
| --- | --- | --- |
| restricted_account_type_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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 |  |

### order_line_asset_tag_mapping

| Column | Type | Keys |
| --- | --- | --- |
| asset_tag_id | Long | PK, FK |
| order_line_id | Long | PK, FK |

### 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 |  |

### order_pad_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_pad_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### user_expenses_delegated_to_mapping

| Column | Type | Keys |
| --- | --- | --- |
| expenses_delgated_to_id | Long | PK, FK |
| user_id | Long | PK, FK |

### asn_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| asn_header_id | Long | PK, FK |
| 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 |  |

### address_tax_registration_relation

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| tax_registration_id | Long | PK, FK |

### supplier_contact_mapping

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### supplier_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| approval_id | Long | PK, FK |
| 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 |  |

### cp_account_type_mapping

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Long | PK, FK |
| account_type_id | Long | PK, FK |
| cp_payment_id | Long | PK, FK |

### order_pad_section

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

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### quote_request_user

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

### 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 |  |

### 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 |  |

### 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 |  |

### 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_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| quote_request_id | Long | PK, FK |

### 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 |  |

### supplier_preferred_commodities_mapping

| Column | Type | Keys |
| --- | --- | --- |
| commodity_id | Long | PK, FK |
| supplier_id | Long | PK, FK |

### 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_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 |  |

### 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 |  |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| code | String |  |
| custom_fields | Json |  |
| name | String |  |

### approver_group_user_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approver_id | Long | PK, FK |
| user_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### expense_trip_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| expense_trip_mileage_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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_** |  |  |

### supplier_information_address_mapping

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Long | PK, FK |
| supplier_information_id | Long | PK, FK |

### 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 |  |

### quote_response_line_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| quote_response_line_id | Long | PK, FK |

### project_business_group_mapping

| Column | Type | Keys |
| --- | --- | --- |
| business_group_id | Long | PK, FK |
| project_id | Long | PK, FK |

### 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 |  |

### dispute_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| invoice_header_id | Long | PK, FK |
| code | String |  |
| created_at | Instant |  |
| created_by_id | Long |  |
| custom_fields | Json |  |
| description | String |  |
| updated_at | Instant |  |
| updated_by_id | Long |  |

### requisition_header_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| requisition_header_id | Long | PK, FK |

### order_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_header_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### 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_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 |  |

### purchase_order_revision_change

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | Long | PK |
| entity_name | String | PK |
| field_name | String | PK |
| purchase_order_revision_id | Long | PK, FK |
| created | Boolean |  |
| field_type | String |  |
| from_id | Long |  |
| from_value | String |  |
| to_id | Long |  |
| to_value | String |  |

### expense_report_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| expense_report_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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 |  |

### supplier_information_artifact

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| supplier_information_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### requisition_header_approval_mapping

| Column | Type | Keys |
| --- | --- | --- |
| approval_id | Long | PK, FK |
| requisition_header_id | Long | PK, FK |

### 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_attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| expense_line_id | Long | PK, FK |
| 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 |  |

### 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 |  |

### comment_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| comment_id | Long | PK, FK |

### invoice_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| supplier_id | Long | PK, FK |
| created_at | Instant |  |
| created_by_id | Long |  |
| custom_fields | Json |  |
| email | String |  |
| send_notification | Boolean |  |
| updated_at | Instant |  |
| updated_by_id | Long |  |

### 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_** |  |  |

### 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 |  |

### supplier_information_artifact_attachment_mapping

| Column | Type | Keys |
| --- | --- | --- |
| attachment_id | Long | PK, FK |
| supplier_information_artifact_id | Long | PK, FK |

### 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 |  |

### 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 |  |

### business_entity_account_owner

| Column | Type | Keys |
| --- | --- | --- |
| business_entity_id | Long | PK, FK |
| user_id | Long | PK, FK |
| created_at | Instant |  |
| created_by_id | Long |  |
| id | Long |  |
| updated_at | Instant |  |
| updated_by_id | Long |  |

### 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 |  |

## Relationships

- invoice_header_attachment_mapping(invoice_header_id) → invoice_header(id)
- invoice_header_attachment_mapping(attachment_id) → attachment(id)
- user_business_group_mapping(user_id) → user(id)
- user_business_group_mapping(business_group_id) → business_group(id)
- requisition_line_asset_tag_mapping(requisition_line_id) → requisition_line(id)
- requisition_line_asset_tag_mapping(asset_tag_id) → asset_tag(id)
- payment_partner(currency_id) → currency(id)
- payment_partner(support_contact_id) → contact(id)
- payment_partner(created_by_id) → user(id)
- payment_partner(updated_by_id) → user(id)
- quote_request_attachment_response(quote_response_id) → quote_response(id)
- user_approval_group_mapping(user_id) → user(id)
- user_approval_group_mapping(approval_group_id) → user_group(id)
- supplier_address_mapping(supplier_id) → supplier(id)
- supplier_address_mapping(address_id) → address(id)
- quote_request_attachment(quote_request_id) → quote_request(id)
- order_line_change(order_header_change_id) → order_header_change(id)
- order_line_change(order_line_id) → order_line(id)
- order_line_change_allocation(period_id) → period(id)
- order_line_change_allocation(order_line_change_id) → order_line_change(id)
- contract_current_parallel_approval_mapping(contract_id) → contract(id)
- contract_current_parallel_approval_mapping(approval_id) → approval(id)
- order_line_attribute(order_line_id) → order_line(id)
- cp_payment_detail(cp_payment_id) → cp_payment(id)
- cp_payment_detail(currency_id) → currency(id)
- cp_payment_detail(created_by_id) → user(id)
- cp_payment_detail(updated_by_id) → user(id)
- integration_contacts(supplier_id) → supplier(id)
- supplier_item(contract_id) → contract(id)
- supplier_item(contract_term_id) → contract_term(id)
- supplier_item(created_by_id) → user(id)
- supplier_item(updated_by_id) → user(id)
- supplier_item(currency_id) → currency(id)
- supplier_item(item_id) → item(id)
- supplier_item(supplier_id) → supplier(id)
- payment_business_group_mapping(payment_id) → payment(id)
- payment_business_group_mapping(business_group_id) → business_group(id)
- inventory_transaction_asset_tag_mapping(inventory_transaction_id) → inventory_transaction(id)
- inventory_transaction_asset_tag_mapping(asset_tag_id) → asset_tag(id)
- invoice_line(invoice_header_id) → invoice_header(id)
- invoice_line(order_line_commodity_id) → commodity(id)
- invoice_line(order_line_id) → order_line(id)
- integration_record_response(integration_error_id) → integration_error(id)
- integration_record_response(integration_history_record_id) → integration_history_record(id)
- per_diem_deduction(expense_line_daily_per_diem_id) → expense_line_daily_per_diem(id)
- per_diem_deduction(expense_per_diem_deduction_id) → expense_per_diem_deduction(id)
- shipping_term_business_group_mapping(shipping_term_id) → shipping_term(id)
- shipping_term_business_group_mapping(business_group_id) → business_group(id)
- invoice_failed_tolerance(invoice_line_id) → invoice_line(id)
- contract_template_business_group_mapping(contract_template_id) → contract_party(id)
- contract_template_business_group_mapping(business_group_id) → business_group(id)
- project_user_mapping(project_id) → project(id)
- project_user_mapping(user_id) → user(id)
- lookup_business_group_mapping(lookup_id) → lookup(id)
- lookup_business_group_mapping(business_group_id) → business_group(id)
- inventory_transaction_attachment_mapping(inventory_transaction_id) → inventory_transaction(id)
- inventory_transaction_attachment_mapping(attachment_id) → attachment(id)
- reason_insight_event(contract_id) → contract(id)
- quote_request_attachment_mapping(quote_request_attachment_id) → quote_request_attachment(id)
- quote_request_attachment_mapping(attachment_id) → attachment(id)
- integration_error(integration_run_id) → integration_run(id)
- charge_allocation(charge_id) → charge(id)
- external_payment(currency_id) → currency(id)
- external_payment(created_by_id) → user(id)
- external_payment(updated_by_id) → user(id)
- payment_partner_account_type_mapping(payment_id) → cp_payment(id)
- payment_partner_account_type_mapping(account_id) → cp_account(id)
- payment_partner_account_type_mapping(payment_partner_id) → payment_partner(id)
- payment_partner_account_type_mapping(account_type_id) → account_type(id)
- lookup_value(lookup_id) → lookup(id)
- invoice_line_allocation(invoice_header_id) → invoice_header(id)
- invoice_line_allocation(invoice_line_id) → invoice_line(id)
- easy_form_data(created_by_id) → user(id)
- easy_form_data(updated_by_id) → user(id)
- easy_form_data(requested_by_id) → user(id)
- purpose(address_id) → address(id)
- purpose(contact_id) → contact(id)
- easy_form_widget_data(easy_form_id) → easy_form_data(id)
- easy_form_widget_data(easy_form_response_id) → easy_form_data(id)
- easy_form_widget_data(created_by_id) → user(id)
- easy_form_widget_data(updated_by_id) → user(id)
- supplier_information_contact_mapping(supplier_information_id) → supplier_information(id)
- supplier_information_contact_mapping(contact_id) → contact(id)
- warehouse(address_id) → address(id)
- expense_line(expense_line_mileage_id) → expense_line_mileage(id)
- expense_line(expense_report_id) → expense_report(id)
- expense_line(order_line_id) → order_line(id)
- expense_line(receipt_total_currency_id) → currency(id)
- expense_line(audit_status_updated_by_id) → user(id)
- online_store(created_by_id) → user(id)
- online_store(updated_by_id) → user(id)
- invoice_header_approval_mapping(invoice_header_id) → invoice_header(id)
- invoice_header_approval_mapping(approval_id) → approval(id)
- invoice_reconciliation_line(invoice_header_id) → invoice_header(id)
- expense_mileage_tier_rule(expense_mileage_config_id) → expense_mileage_config(id)
- supplier_information(commodity_id) → commodity(id)
- supplier_information(currency_id) → currency(id)
- supplier_information(default_commodity_id) → commodity(id)
- supplier_information(payment_term_id) → payment_term(id)
- supplier_information(shipping_term_id) → shipping_term(id)
- supplier_information(supplier_id) → supplier(id)
- supplier_information(tax_code_id) → tax_code(id)
- supplier_information(user_id) → user(id)
- payable_allocation(payable_from_currency_id) → currency(id)
- payable_allocation(payable_to_currency_id) → currency(id)
- tax_line(invoice_line_id) → invoice_line(id)
- tax_line(charge_id) → charge(id)
- expense_line_daily_per_diem(expense_line_per_diem_id) → expense_line_per_diem(id)
- cp_payment_detail_allocation_mapping(payment_id) → cp_payment(id)
- cp_payment_detail_allocation_mapping(payment_detail_id) → cp_payment_detail(id)
- cp_payment_detail_allocation_mapping(payable_allocation_id) → payable_allocation(id)
- punchout_site(created_by_id) → user(id)
- punchout_site(updated_by_id) → user(id)
- requisition_header(receiving_warehouse_id) → warehouse(id)
- business_entity_alternate_name(business_entity_id) → business_entity(id)
- user_role_mapping(user_id) → user(id)
- user_role_mapping(role_id) → role(id)
- business_group_contract_mapping(business_group_id) → business_group(id)
- business_group_contract_mapping(contract_id) → contract(id)
- address_business_group_relation(address_id) → address(id)
- address_business_group_relation(business_group_id) → business_group(id)
- virtual_card(order_header_id) → order_header(id)
- user_can_expense_for_mapping(user_id) → user(id)
- user_can_expense_for_mapping(can_expense_for_id) → user(id)
- cp_payment(pay_from_account_id) → cp_account(id)
- cp_payment(pay_to_account_id) → cp_account(id)
- cp_payment(pay_from_currency_id) → currency(id)
- cp_payment(reporting_currency_id) → currency(id)
- cp_payment(pay_to_currency_id) → currency(id)
- cp_payment(created_by_id) → user(id)
- cp_payment(updated_by_id) → user(id)
- user_working_warehouse_mapping(user_id) → user(id)
- user_working_warehouse_mapping(warehouse_id) → warehouse(id)
- quote_response_line(quote_response_id) → quote_response(id)
- quote_response_line(shipping_term_id) → shipping_term(id)
- business_entity_external_reference(business_entity_id) → business_entity(id)
- quote_response_line_easy_form_data_mapping(easy_form_id) → easy_form_data(id)
- quote_response_line_easy_form_data_mapping(easy_form_data_id) → easy_form_data(id)
- quote_response_line_easy_form_data_mapping(quote_response_line_id) → quote_response_line(id)
- expense_report_comment_mapping(expense_report_id) → expense_report(id)
- expense_report_comment_mapping(comment_id) → comment(id)
- expense_report_preapproval(expense_report_id) → expense_report(id)
- order_line_allocation(order_line_id) → order_line(id)
- approval(easy_form_id) → easy_form_data(id)
- user_group_membership(user_group_id) → user_group(id)
- user_group_membership(user_id) → user(id)
- quote_supplier(quote_request_id) → quote_request(id)
- quote_supplier(quote_response_id) → quote_response(id)
- order_header_attachment_mapping(order_header_id) → order_header(id)
- order_header_attachment_mapping(attachment_id) → attachment(id)
- user_group_user_mapping(user_id) → user(id)
- user_group_user_mapping(user_group_id) → user_group(id)
- expense_line_tax(expense_line_id) → expense_line(id)
- order_header_change_approval_mapping(order_header_change_id) → order_header_change(id)
- order_header_change_approval_mapping(approval_id) → approval(id)
- supplier_information_business_group_mapping(supplier_information_id) → supplier_information(id)
- supplier_information_business_group_mapping(business_group_id) → business_group(id)
- invoice_charge_tax_line_mapping(invoice_charge_id) → invoice_charge(id)
- invoice_charge_tax_line_mapping(tax_line_id) → tax_line(id)
- order_pad_business_group_mapping(business_group_id) → business_group(id)
- order_pad_business_group_mapping(order_pad_id) → order_pad(id)
- user_account_group_mapping(user_id) → user(id)
- user_account_group_mapping(account_group_id) → account_group(id)
- user_address_mapping(user_id) → user(id)
- user_address_mapping(address_id) → address(id)
- expense_per_diem_rule(expense_per_diem_config_id) → expense_per_diem_config(id)
- requisition_line(requisition_header_id) → requisition_header(id)
- requisition_line(order_line_id) → order_line(id)
- business_entity_address_mapping(business_entity_id) → business_entity(id)
- business_entity_address_mapping(address_id) → address(id)
- business_entity(country_of_origin_id) → country(id)
- business_entity(primary_contact_id) → contact(id)
- expense_policy_violation(expense_report_id) → expense_report(id)
- easy_form_approval_mapping(easy_form_id) → easy_form_data(id)
- easy_form_approval_mapping(approval_id) → approval(id)
- remit_to_address_tax_registration_mapping(remit_to_address_id) → remit_to_address(id)
- remit_to_address_tax_registration_mapping(tax_registration_id) → tax_registration(id)
- budget_line_adjustment(budget_line_id) → budget_line(id)
- virtual_card_partner_account_type_mapping(virtual_card_partner_id) → virtual_card_partner(id)
- virtual_card_partner_account_type_mapping(account_type_id) → account_type(id)
- inventory_organization_warehouse_mapping(inventory_organization_id) → inventory_organization(id)
- inventory_organization_warehouse_mapping(warehouse_id) → warehouse(id)
- invoice_charge(accounting_total_currency_id) → currency(id)
- invoice_charge(invoice_header_id) → invoice_header(id)
- quote_request_attachment_response_mapping(quote_request_attachment_response_id) → quote_request_attachment_response(quote_response_id)
- quote_request_attachment_response_mapping(attachment_id) → attachment(id)
- supplier_remit_to_address_mapping(supplier_id) → supplier(id)
- supplier_remit_to_address_mapping(remit_to_address_id) → remit_to_address(id)
- inventory_organization(user_id) → user(id)
- order_header_change_order_line_change_mapping(order_header_change) → order_header_change(id)
- order_header_change_order_line_change_mapping(order_line_change) → order_line_change(id)
- expense_trip_mileage_allocation(expense_trip_mileage_id) → expense_trip_mileage(id)
- quote_request_line(commodity_id) → commodity(id)
- quote_request_line(quote_request_id) → quote_request(id)
- quote_request_line(quote_request_lot_id) → quote_request_lot(id)
- req_line_allocation(created_by_id) → user(id)
- req_line_allocation(updated_by_id) → user(id)
- req_line_allocation(requisition_line_id) → requisition_line(id)
- business_entity_relationship(business_entity_id) → business_entity(id)
- business_entity_relationship(related_business_entity_id) → business_entity(id)
- expense_per_diem_rule_condition(expense_per_diem_rule_id) → expense_per_diem_rule(id)
- contract_party_contract_mapping(contract_party_id) → contract_party(id)
- contract_party_contract_mapping(contract_id) → contract(id)
- inventory_transaction_valuation(inventory_transaction_id) → inventory_transaction(id)
- expense_preapproval(available_amount_currency_id) → currency(id)
- expense_preapproval(created_by_id) → user(id)
- expense_preapproval(currency_id) → currency(id)
- expense_preapproval(for_user_id) → user(id)
- expense_preapproval(updated_by_id) → user(id)
- supplier_restricted_account_type_mapping(supplier_id) → supplier(id)
- supplier_restricted_account_type_mapping(restricted_account_type_id) → account_type(id)
- order_line_asset_tag_mapping(order_line_id) → order_line(id)
- order_line_asset_tag_mapping(asset_tag_id) → asset_tag(id)
- expense_violation(expense_report_id) → expense_report(id)
- order_pad_line(order_pad_id) → order_pad(id)
- order_pad_line(supplier_id) → supplier(id)
- comment(created_by_id) → user(id)
- user_expenses_delegated_to_mapping(user_id) → user(id)
- user_expenses_delegated_to_mapping(expenses_delgated_to_id) → user(id)
- asn_line(asn_header_id) → asn_header(id)
- address_tax_registration_relation(address_id) → address(id)
- address_tax_registration_relation(tax_registration_id) → tax_registration(id)
- supplier_contact_mapping(supplier_id) → supplier(id)
- supplier_contact_mapping(contact_id) → contact(id)
- quote_response(quote_request_id) → quote_request(id)
- supplier_business_group_mapping(supplier_id) → supplier(id)
- supplier_business_group_mapping(business_group_id) → business_group(id)
- contract_term(contract_id) → contract(id)
- approver(approval_id) → approval(id)
- cp_account_type_mapping(cp_payment_id) → cp_payment(id)
- cp_account_type_mapping(account_id) → cp_account(id)
- cp_account_type_mapping(account_type_id) → account_type(id)
- expense_attendee_type(expense_category_id) → expense_category(id)
- cp_account(payment_partner_id) → payment_partner(id)
- cp_account(currency_id) → currency(id)
- cp_account(created_by_id) → user(id)
- cp_account(updated_by_id) → user(id)
- quote_request_user(user_id) → user(id)
- quote_request_user(quote_request_id) → quote_request(id)
- task(created_by_id) → user(id)
- task(owner_id) → user(id)
- task(resolved_by_id) → user(id)
- task(updated_by_id) → user(id)
- expense_line_allocation(expense_line_id) → expense_line(id)
- quote_request_business_group_mapping(quote_request_id) → quote_request(id)
- quote_request_business_group_mapping(business_group_id) → business_group(id)
- form(quote_request_id) → quote_request(id)
- supplier_preferred_commodities_mapping(supplier_id) → supplier(id)
- supplier_preferred_commodities_mapping(commodity_id) → commodity(id)
- integration_history_record(integration_run_id) → integration_run(id)
- integration_history_record(inventory_transaction_id) → inventory_transaction(id)
- integration_history_record(invoice_header_id) → invoice_header(id)
- integration_history_record(order_header_id) → order_header(id)
- withholding_tax_line(invoice_line_id) → invoice_line(id)
- approver_group_user_mapping(user_id) → user(id)
- approver_group_user_mapping(approver_id) → approver(id)
- warehouse_location(warehouse_id) → warehouse(id)
- expense_trip_segment(expense_trip_mileage_id) → expense_trip_mileage(id)
- expense_artifact(expense_line_id) → expense_line(id)
- invoice_charge_allocation(invoice_charge_id) → invoice_charge(id)
- charge(account_type_id) → account_type(id)
- charge(order_header_id) → order_header(id)
- charge(supplier_id) → supplier(id)
- charge(virtual_card_id) → virtual_card(id)
- charge(accounting_currency_id) → currency(id)
- charge(payment_partner_id) → payment_partner(id)
- inventory_txn_allocation(inventory_transaction_id) → inventory_transaction(id)
- expense_line_mileage_allocation(expense_line_mileage_id) → expense_line_mileage(id)
- tagging(tag_id) → tag(id)
- tagging(created_by_id) → user(id)
- supplier_information_address_mapping(supplier_information_id) → supplier_information(id)
- supplier_information_address_mapping(address_id) → supplier_information_address(id)
- quote_response_line_attachment_mapping(quote_response_line_id) → quote_response_line(id)
- quote_response_line_attachment_mapping(attachment_id) → attachment(id)
- project_business_group_mapping(project_id) → project(id)
- project_business_group_mapping(business_group_id) → business_group(id)
- dispute_reason(invoice_header_id) → invoice_header(id)
- requisition_header_attachment_mapping(requisition_header_id) → requisition_header(id)
- requisition_header_attachment_mapping(attachment_id) → attachment(id)
- order_line(order_header_id) → order_header(id)
- order_line(extra_line_attribute_id) → order_line_attribute(id)
- order_line(currency_id) → currency(id)
- matching_allocation(inventory_transaction_id) → inventory_transaction(id)
- matching_allocation(asn_line_id) → asn_line(id)
- matching_allocation(invoice_line_id) → invoice_line(id)
- matching_allocation(order_line_id) → order_line(id)
- matching_allocation(uom_id) → unit_of_measure(id)
- purchase_order_revision_change(purchase_order_revision_id) → purchase_order_revision(field_name)
- expense_report_approval_mapping(expense_report_id) → expense_report(id)
- expense_report_approval_mapping(approval_id) → approval(id)
- invoice_payment_receipt(invoice_header_id) → invoice_header(id)
- announcement(created_by_id) → user(id)
- announcement(updated_by_id) → user(id)
- supplier_information_artifact(supplier_information_id) → supplier_information(id)
- supplier_information_artifact(supplier_id) → supplier(id)
- requisition_header_approval_mapping(requisition_header_id) → requisition_header(id)
- requisition_header_approval_mapping(approval_id) → approval(id)
- tag(invoice_line_id) → invoice_line(id)
- tag(quote_request_id) → quote_request(id)
- tag(requisition_line_id) → requisition_line(id)
- tag(requisition_header_id) → requisition_header(id)
- tag(invoice_header_id) → invoice_header(id)
- expense_attendee(user_id) → user(id)
- expense_attendee(expense_line_id) → expense_line(id)
- expense_per_diem_deduction(expense_per_diem_config_id) → expense_per_diem_config(id)
- comment_attachment_mapping(attachment_id) → attachment(id)
- comment_attachment_mapping(comment_id) → comment(id)
- invoice_email(supplier_id) → supplier(id)
- user(manager_id) → user(id)
- expense_report_event_history(expense_report_id) → expense_report(id)
- supplier_information_artifact_attachment_mapping(supplier_information_artifact_id) → supplier_information_artifact(id)
- supplier_information_artifact_attachment_mapping(attachment_id) → attachment(id)
- business_entity_account_owner(user_id) → user(id)
- business_entity_account_owner(business_entity_id) → business_entity(id)
- quote_request(currency_id) → currency(id)
- quote_request(negotiated_savings_currency_id) → currency(id)
- quote_request(planned_savings_currency_id) → currency(id)