Acumatica

Explore the interactive ERD

Table & Field Reference

sales_order_detail

Column	Type	Keys
`id`	Unknown	PK
`sales_order_id`	Unknown	PKFK
`sales_order_uuid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`purchase_order_uuid`	Unknown	PKFK
`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	PKFK
`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_`