# Acumatica schema ERD

Table and field reference for the Fivetran Acumatica connector.

## Table & Field Reference

### sales_order_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |
| sales_order_uuid | Unknown | PK, FK |
| account_cd | Unknown | FK |
| alternate_id | Unknown |  |
| amount | Unknown |  |
| auto_create_issue | Unknown |  |
| average_cost | Unknown |  |
| branch | Unknown |  |
| calculate_discounts_on_import | Unknown |  |
| completed | Unknown |  |
| customer_order_nbr | Unknown |  |
| discount_amount | Unknown |  |
| discount_code | Unknown |  |
| discount_percent | Unknown |  |
| discounted_unit_price | Unknown |  |
| extended_price | Unknown |  |
| free_item | Unknown |  |
| inventory_id | Unknown |  |
| last_modified_date | Unknown |  |
| line_description | Unknown |  |
| line_nbr | Unknown |  |
| line_type | Unknown |  |
| location | Unknown |  |
| manual_discount | Unknown |  |
| mark_for_po | Unknown |  |
| note | Unknown |  |
| open_qty | Unknown |  |
| operation | Unknown |  |
| order_qty | Unknown |  |
| overship_threshold | Unknown |  |
| po_source | Unknown |  |
| project_task | Unknown |  |
| qty_on_shipment | Unknown |  |
| reason_code | Unknown |  |
| requested_on | Unknown |  |
| salesperson_id | Unknown |  |
| sched_order_date | Unknown |  |
| ship_on | Unknown |  |
| ship_to_location | Unknown |  |
| shipping_rule | Unknown |  |
| tax_category | Unknown |  |
| tax_zone | Unknown |  |
| unbilled_amount | Unknown |  |
| undership_threshold | Unknown |  |
| unit_cost | Unknown |  |
| unit_price | Unknown |  |
| uom | Unknown |  |
| warehouse_id | Unknown |  |
| custom_** |  |  |

### sales_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| contact_id | Unknown | FK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| approved | Unknown |  |
| base_currency_id | Unknown |  |
| bill_to_address_override | Unknown |  |
| bill_to_contact_override | Unknown |  |
| cash_account | Unknown |  |
| control_total | Unknown |  |
| credit_hold | Unknown |  |
| currency_rate | Unknown |  |
| currency_rate_type_id | Unknown |  |
| customer_order | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| destination_warehouse_id | Unknown |  |
| disable_automatic_discount_update | Unknown |  |
| effective_date | Unknown |  |
| external_ref | Unknown |  |
| hold | Unknown |  |
| is_tax_valid | Unknown |  |
| last_modified | Unknown |  |
| last_modified_datetime | Instant |  |
| line_total | Unknown |  |
| location_id | Unknown |  |
| note | Unknown |  |
| order_total | Unknown |  |
| order_type | Unknown |  |
| ordered_qty | Unknown |  |
| payment_method | Unknown |  |
| preferred_warehouse_id | Unknown |  |
| project | Unknown |  |
| reciprocal_rate | Unknown |  |
| requested_on | Unknown |  |
| ship_to_address_override | Unknown |  |
| ship_to_contact_override | Unknown |  |
| ship_via | Unknown |  |
| status | Unknown |  |
| tax_total | Unknown |  |
| custom_** |  |  |

### stockitem_warehouse_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| stockitem_id | Unknown | PK, FK |
| default_issue_location | Unknown |  |
| default_receipt_location | Unknown |  |
| inventory_account | Unknown |  |
| inventory_subaccount | Unknown |  |
| is_default | Unknown |  |
| note | Unknown |  |
| override | Unknown |  |
| override_preferred_vendor | Unknown |  |
| override_std_cost | Unknown |  |
| preferred_vendor | Unknown |  |
| price_override | Unknown |  |
| product_manager | Unknown |  |
| product_workgroup | Unknown |  |
| qty_on_hand | Unknown |  |
| service_level | Unknown |  |
| status | Unknown |  |
| warehouse_id | Unknown |  |
| custom_** |  |  |

### stockitem

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| abc_code | Unknown |  |
| auto_incremental_value | Unknown |  |
| average_cost | Unknown |  |
| base_uom | Unknown |  |
| cogs_account | Unknown |  |
| cogs_subaccount | Unknown |  |
| content | Unknown |  |
| default_issue_location | Unknown |  |
| default_price | Unknown |  |
| default_receipt_location | Unknown |  |
| default_warehouse | Unknown |  |
| description | Unknown |  |
| dimension_volume | Unknown |  |
| dimension_weight | Unknown |  |
| discount_account | Unknown |  |
| discount_subaccount | Unknown |  |
| image_url | Unknown |  |
| inventory_account | Unknown |  |
| inventory_id | Unknown |  |
| inventory_subaccount | Unknown |  |
| is_a_kit | Unknown |  |
| item_class | Unknown |  |
| item_status | Unknown |  |
| item_type | Unknown |  |
| landed_cost_variance_account | Unknown |  |
| landed_cost_variance_subaccount | Unknown |  |
| last_cost | Unknown |  |
| last_modified | Unknown |  |
| last_modified_datetime | Instant |  |
| last_std_cost | Unknown |  |
| lot_serial_class | Unknown |  |
| markup | Unknown |  |
| max_cost | Unknown |  |
| min_cost | Unknown |  |
| min_markup | Unknown |  |
| msrp | Unknown |  |
| note | Unknown |  |
| pending_std_cost | Unknown |  |
| po_accrual_account | Unknown |  |
| po_accrual_subaccount | Unknown |  |
| posting_class | Unknown |  |
| price_class | Unknown |  |
| price_manager | Unknown |  |
| price_workgroup | Unknown |  |
| product_manager | Unknown |  |
| product_workgroup | Unknown |  |
| purchase_price_variance_account | Unknown |  |
| purchase_price_variance_subaccount | Unknown |  |
| purchase_uom | Unknown |  |
| reason_code_subaccount | Unknown |  |
| sales_account | Unknown |  |
| sales_subaccount | Unknown |  |
| sales_uom | Unknown |  |
| standard_cost_revaluation_account | Unknown |  |
| standard_cost_revaluation_subaccount | Unknown |  |
| standard_cost_variance_account | Unknown |  |
| standard_cost_variance_subaccount | Unknown |  |
| tax_category | Unknown |  |
| valuation_method | Unknown |  |
| volume_uom | Unknown |  |
| weight_uom | Unknown |  |
| custom_** |  |  |

### currency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| active | Unknown |  |
| created_date_time | Unknown |  |
| currency_symbol | Unknown |  |
| decimal_precision | Unknown |  |
| description | Unknown |  |
| last_modified_datetime | Instant |  |
| note | Unknown |  |
| use_for_accounting | Unknown |  |
| custom_** |  |  |

### journal_transaction_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| journal_transaction_id | Unknown | PK, FK |
| account_cd | Unknown | FK |
| branch | Unknown |  |
| credit_amount | Unknown |  |
| debit_amount | Unknown |  |
| description | Unknown |  |
| is_non_pm | Unknown |  |
| line_nbr | Unknown |  |
| non_billable | Unknown |  |
| note | Unknown |  |
| project | Unknown |  |
| project_task | Unknown |  |
| project_transaction_id | Unknown |  |
| qty | Unknown |  |
| reference_nbr | Unknown |  |
| subaccount | Unknown |  |
| transaction_description | Unknown |  |
| uom | Unknown |  |
| vendor_or_customer | Unknown |  |
| custom_** |  |  |

### journal_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| batch_nbr | Unknown |  |
| branch_id | Unknown |  |
| created_date_time | Unknown |  |
| description | Unknown |  |
| hold | Unknown |  |
| last_modified_datetime | Instant |  |
| ledger_id | Unknown |  |
| module | Unknown |  |
| note | Unknown |  |
| post_period | Unknown |  |
| status | Unknown |  |
| transaction_date | Unknown |  |
| custom_** |  |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| customer_id | Unknown | FK |
| application_date | Unknown |  |
| applied_to_document | Unknown |  |
| branch | Unknown |  |
| card_account_nbr | Unknown |  |
| cash_account | Unknown |  |
| description | Unknown |  |
| hold | Unknown |  |
| last_modified_datetime | Instant |  |
| note | Unknown |  |
| payment_amount | Unknown |  |
| payment_method | Unknown |  |
| payment_ref | Unknown |  |
| processing_center_id | Unknown |  |
| reference_nbr | Unknown |  |
| save_card | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### invoice_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_cd | Unknown | FK |
| invoice_id | Unknown | FK |
| amount | Unknown |  |
| branch | Unknown |  |
| calculate_discounts_on_import | Unknown |  |
| discount_amount | Unknown |  |
| extended_price | Unknown |  |
| inventory_id | Unknown |  |
| last_modified_datetime | Instant |  |
| line_nbr | Unknown |  |
| note | Unknown |  |
| project_task | Unknown |  |
| qty | Unknown |  |
| subaccount | Unknown |  |
| transaction_description | Unknown |  |
| unit_price | Unknown |  |
| uom | Unknown |  |
| custom_** |  |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| bill_to_contact_override | Unknown |  |
| billing_printed | Unknown |  |
| created_date_time | Unknown |  |
| customer_order | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| hold | Unknown |  |
| is_tax_valid | Unknown |  |
| last_modified_datetime | Instant |  |
| link_ar_account | Unknown |  |
| link_branch | Unknown |  |
| location_id | Unknown |  |
| note | Unknown |  |
| post_period | Unknown |  |
| project | Unknown |  |
| reference_nbr | Unknown |  |
| ship_to_contact_override | Unknown |  |
| status | Unknown |  |
| tax_total | Unknown |  |
| term | Unknown |  |
| type | Unknown |  |
| custom_** |  |  |

### financial_period

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_date_time | Unknown |  |
| financial_year | Unknown |  |
| last_modified_datetime | Instant |  |
| nbr_of_period | Unknown |  |
| note | Unknown |  |
| start_date | Unknown |  |
| user_defined_period | Unknown |  |
| custom_** |  |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| currency_id | Unknown | FK |
| account_cd | Unknown |  |
| account_class | Unknown |  |
| account_group | Unknown |  |
| active | Unknown |  |
| cash_account | Unknown |  |
| chart_of_accounts_order | Unknown |  |
| created_date_time | Unknown |  |
| description | Unknown |  |
| last_modified_datetime | Instant |  |
| note | Unknown |  |
| post_option | Unknown |  |
| require_unit | Unknown |  |
| revaluation_rate_type | Unknown |  |
| secured | Unknown |  |
| type | Unknown |  |
| use_default_subaccount | Unknown |  |
| custom_** |  |  |

### purchase_order_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| purchase_order_uuid | Unknown | PK, FK |
| account_cd | Unknown | FK |
| alternate_id | Unknown |  |
| branch_id | Unknown |  |
| calculate_discounts_on_import | Unknown |  |
| cancelled | Unknown |  |
| complete_on | Unknown |  |
| completed | Unknown |  |
| description | Unknown |  |
| extended_cost | Unknown |  |
| inventory_id | Unknown |  |
| line_description | Unknown |  |
| line_nbr | Unknown |  |
| line_type | Unknown |  |
| max_receipt_percent | Unknown |  |
| min_receipt_percent | Unknown |  |
| note | Unknown |  |
| order_nbr | Unknown |  |
| order_qty | Unknown |  |
| order_type | Unknown |  |
| orig_po_nbr | Unknown |  |
| orig_po_type | Unknown |  |
| project | Unknown |  |
| project_task | Unknown |  |
| promised | Unknown |  |
| qty_on_receipt | Unknown |  |
| receipt_action | Unknown |  |
| received_amount | Unknown |  |
| requested | Unknown |  |
| subaccount | Unknown |  |
| tax_category | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| warehouse_id | Unknown |  |
| custom_** |  |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| currency_id | Unknown | FK |
| vendor_id | Unknown | FK |
| base_currency_id | Unknown |  |
| branch | Unknown |  |
| control_total | Unknown |  |
| currency_effective_date | Unknown |  |
| currency_rate | Unknown |  |
| currency_rate_type_id | Unknown |  |
| currency_reciprocal_rate | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| hold | Unknown |  |
| last_modified_datetime | Instant |  |
| line_total | Unknown |  |
| location | Unknown |  |
| note | Unknown |  |
| order_total | Unknown |  |
| owner | Unknown |  |
| project | Unknown |  |
| promised_on | Unknown |  |
| status | Unknown |  |
| tax_total | Unknown |  |
| terms | Unknown |  |
| type | Unknown |  |
| vendor_ref | Unknown |  |
| vendor_tax_zone | Unknown |  |
| custom_** |  |  |

### bill_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| vendor_id | Unknown | FK |
| application_date | Unknown |  |
| cash_account | Unknown |  |
| description | Unknown |  |
| detail | Json |  |
| hold | Unknown |  |
| last_modified_datetime | Instant |  |
| note | Unknown |  |
| payment_amount | Unknown |  |
| payment_method | Unknown |  |
| payment_ref | Unknown |  |
| reference_nbr | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| unapplied_balance | Unknown |  |
| custom_** |  |  |

### bill_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | PK, FK |
| account_cd | Unknown | FK |
| amount | Unknown |  |
| branch | Unknown |  |
| calculate_discount_on_import | Unknown |  |
| description | Unknown |  |
| extended_cost | Unknown |  |
| inventory_id | Unknown |  |
| non_billable | Unknown |  |
| note | Unknown |  |
| po_line | Unknown |  |
| po_order_nbr | Unknown |  |
| po_order_type | Unknown |  |
| po_receipt_line | Unknown |  |
| po_receipt_nbr | Unknown |  |
| po_receipt_type | Unknown |  |
| project | Unknown |  |
| project_task | Unknown |  |
| qty | Unknown |  |
| subaccount | Unknown |  |
| tax_category | Unknown |  |
| transaction_description | Unknown |  |
| unit_cost | Unknown |  |
| uom | Unknown |  |
| custom_** |  |  |

### bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| currency_id | Unknown | FK |
| amount | Unknown |  |
| approved_for_payment | Unknown |  |
| balance | Unknown |  |
| branch_id | Unknown |  |
| cash_account | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| hold | Unknown |  |
| is_tax_valid | Unknown |  |
| last_modified_datetime | Instant |  |
| location_id | Unknown |  |
| note | Unknown |  |
| post_period | Unknown |  |
| project | Unknown |  |
| reference_nbr | Unknown |  |
| status | Unknown |  |
| tax_total | Unknown |  |
| term | Unknown |  |
| type | Unknown |  |
| vendor | Unknown |  |
| vendor_ref | Unknown |  |
| custom_** |  |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| currency_id | Unknown | FK |
| account_ref | Unknown |  |
| ap_account | Unknown |  |
| ap_subaccount | Unknown |  |
| cash_account | Unknown |  |
| created_date_time | Unknown |  |
| currency_rate_type | Unknown |  |
| enable_currency_override | Unknown |  |
| enable_rate_override | Unknown |  |
| f_1099_box | Unknown |  |
| f_1099_vendor | Unknown |  |
| fatca | Unknown |  |
| fob_point | Unknown |  |
| foreign_entity | Unknown |  |
| landed_cost_vendor | Unknown |  |
| last_modified_datetime | Instant |  |
| lead_time_day | Unknown |  |
| location_name | Unknown |  |
| max_receipt | Unknown |  |
| min_receipt | Unknown |  |
| note | Unknown |  |
| parent_account | Unknown |  |
| pay_separately | Unknown |  |
| payment_by | Unknown |  |
| payment_lead_time_day | Unknown |  |
| payment_method | Unknown |  |
| print_order | Unknown |  |
| receipt_action | Unknown |  |
| receiving_branch | Unknown |  |
| remittance_address_override | Unknown |  |
| remittance_contact_override | Unknown |  |
| send_orders_by_email | Unknown |  |
| ship_via | Unknown |  |
| shipping_address_override | Unknown |  |
| shipping_contact_override | Unknown |  |
| shipping_terms | Unknown |  |
| status | Unknown |  |
| tax_registration_id | Unknown |  |
| tax_zone | Unknown |  |
| term | Unknown |  |
| threshold_receipt | Unknown |  |
| vendor_class | Unknown |  |
| vendor_is_labor_union | Unknown |  |
| vendor_is_tax_agency | Unknown |  |
| vendor_name | Unknown |  |
| warehouse | Unknown |  |
| custom_** |  |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| uuid | Unknown | PK |
| currency_id | Unknown | FK |
| account_ref | Unknown |  |
| auto_apply_payment | Unknown |  |
| billing_address_override | Unknown |  |
| billing_contact_override | Unknown |  |
| created_date_time | Unknown |  |
| currency_rate_type | Unknown |  |
| customer_class | Unknown |  |
| customer_name | Unknown |  |
| enable_currency_override | Unknown |  |
| enable_rate_override | Unknown |  |
| enable_write_off | Unknown |  |
| fob_point | Unknown |  |
| last_modified_datetime | Instant |  |
| lead_timeday | Unknown |  |
| location_name | Unknown |  |
| main_contact_address_address_line_1 | Unknown |  |
| main_contact_address_address_line_2 | Unknown |  |
| main_contact_address_city | Unknown |  |
| main_contact_address_country | Unknown |  |
| main_contact_address_first_name | Unknown |  |
| main_contact_address_id | Unknown |  |
| main_contact_address_job_title | Unknown |  |
| main_contact_address_last_name | Unknown |  |
| main_contact_address_middle_name | Unknown |  |
| main_contact_address_note | Unknown |  |
| main_contact_address_phone_1 | Unknown |  |
| main_contact_address_phone_1_type | Unknown |  |
| main_contact_address_phone_2 | Unknown |  |
| main_contact_address_phone_2_type | Unknown |  |
| main_contact_address_postal_code | Unknown |  |
| main_contact_address_state | Unknown |  |
| main_contact_address_title | Unknown |  |
| main_contact_address_web_site | Unknown |  |
| main_contact_attention | Unknown |  |
| main_contact_company_name | Unknown |  |
| main_contact_contact_id | Unknown |  |
| main_contact_display_name | Unknown |  |
| main_contact_email | Unknown |  |
| main_contact_fax | Unknown |  |
| main_contact_first_name | Unknown |  |
| main_contact_job_title | Unknown |  |
| main_contact_last_name | Unknown |  |
| main_contact_middle_name | Unknown |  |
| main_contact_note | Unknown |  |
| main_contact_phone_1 | Unknown |  |
| main_contact_phone_1_type | Unknown |  |
| main_contact_phone_2 | Unknown |  |
| main_contact_phone_2_type | Unknown |  |
| main_contact_title | Unknown |  |
| main_contact_uuid | Unknown |  |
| main_contact_website | Unknown |  |
| multi_currency_statement | Unknown |  |
| note | Unknown |  |
| order_priority | Unknown |  |
| parent_record | Unknown |  |
| price_class_id | Unknown |  |
| print_invoice | Unknown |  |
| print_statement | Unknown |  |
| residential_delivery | Unknown |  |
| saturday_delivery | Unknown |  |
| send_invoice_by_email | Unknown |  |
| send_statement_by_email | Unknown |  |
| ship_via | Unknown |  |
| shipping_address_override | Unknown |  |
| shipping_branch | Unknown |  |
| shipping_contact_override | Unknown |  |
| shipping_rule | Unknown |  |
| shipping_term | Unknown |  |
| shipping_zone_id | Unknown |  |
| statement_cycle_id | Unknown |  |
| statement_type | Unknown |  |
| status | Unknown |  |
| tax_registration_id | Unknown |  |
| tax_zone | Unknown |  |
| term | Unknown |  |
| warehouse_id | Unknown |  |
| write_off_limit | Unknown |  |
| custom_** |  |  |

## Relationships

- sales_order_detail(account_cd) → account(account_cd)
- sales_order_detail(sales_order_uuid) → sales_order(uuid)
- sales_order_detail(sales_order_id) → sales_order(id)
- sales_order(currency_id) → currency(id)
- sales_order(customer_id) → customer(id)
- sales_order(contact_id) → customer(main_contact_contact_id)
- stockitem_warehouse_detail(stockitem_id) → stockitem(id)
- journal_transaction_detail(account_cd) → account(account_cd)
- journal_transaction_detail(journal_transaction_id) → journal_transaction(id)
- journal_transaction(currency_id) → currency(id)
- payment(currency_id) → currency(id)
- payment(customer_id) → customer(id)
- invoice_detail(account_cd) → account(account_cd)
- invoice_detail(invoice_id) → invoice(id)
- invoice(customer_id) → customer(id)
- account(currency_id) → currency(id)
- purchase_order_detail(account_cd) → account(account_cd)
- purchase_order_detail(purchase_order_uuid) → purchase_order(uuid)
- purchase_order_detail(purchase_order_id) → purchase_order(id)
- purchase_order(currency_id) → currency(id)
- purchase_order(vendor_id) → vendor(id)
- bill_payment(currency_id) → currency(id)
- bill_payment(vendor_id) → vendor(id)
- bill_detail(account_cd) → account(account_cd)
- bill_detail(bill_id) → bill(id)
- bill(currency_id) → currency(id)
- vendor(currency_id) → currency(id)
- customer(currency_id) → currency(id)