Skip to main content
Buyerquest Community

Accounting_Entity

Accounting_Entity - BuyerQuest Integration Center

Accounting Entity

Data Model

Link to Importer Documentation: Accounting

 

Details for Key Fields

Table Name: buyerquest_accounting_label

Field Name Notes
Label

Accounting Group Name

is_optional

0 = no

1= yes

is_filterable

0 = no

1 = yes

position Integer Ranking
has_child_values

0 = no

1 = yes (this is a parent group)

has_parent_values

0 = no

1 = yes (this has a parent group)

parent_label_id Accounting ID of Parent

 

 

Table Name: buyerquest_accounting_value

Field Name Notes
id

Accounting Value ID

name

Accounting Value Name

description Accounting Value Description
status

0 = disabled

1 = enabled

is_default

0 = no

1 = yes

parent_id Reporting ID of Accounting Value

 

Table Name: buyerquest_accounting_customer_default_value

Field Name Notes
label 

Name of Accounting Label

value_id ID of Accounting Value

 

Table Name: buyerquest_favorite_accounting

Field Name Notes
account_name

Favorite Accounting Name

is_valid

0 = not valid

1 = yes

account_data Template:
[{“<Group 1 accounting_id>”:{“id":"<Group 1 accounting_id>","value”:”<Accounting Value id> ‘ - ‘ <Accounting Value name>”},
"<Group 2 accounting_id>":{"id":"<Group 2 accounting_id>","value":"<Accounting Value id> ‘ - ‘ <Accounting Value name>"},
"<Group 3 accounting_id>":{"id":"<Group 3 accounting_id>","value":"<Accounting Value id> ‘ - ‘ <Accounting Value name>"},
“<Group 4 accounting_id>”:{“id":"<Group 4 accounting_id>","value":"<Accounting Value id> ‘ - ‘ <Accounting Value name>"},
"allocation":{"id":"allocation","value”:”<Allocation Percentage>“}}]