> For the complete documentation index, see [llms.txt](https://inistate.gitbook.io/home/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://inistate.gitbook.io/home/advanced/integration/accounting-1/customer.md).

# Customer

**SQL ACCOUNTING integration - customer**

<table><thead><tr><th width="495">example script</th><th>purpose</th></tr></thead><tbody><tr><td><pre><code>payloadData["type"] = "AR_CUSTOMER"
</code></pre></td><td>to let the system know you integration with Customer</td></tr><tr><td><pre><code>payloadData["payload"]["COMPANYNAME"] = data["Name"]
</code></pre></td><td>change ["COMPANYNAME"]. You can refer below table</td></tr></tbody></table>

| UI             | mapping field | type | remarks                                                            |
| -------------- | ------------- | ---- | ------------------------------------------------------------------ |
| Company        | COMPANYNAME   | text |                                                                    |
| Code           | CODE          | text |                                                                    |
| Currency       | CURRENCYCODE  | text | map to Currency (need to make sure the Currency code exist in SQL) |
| Address line 1 | ADDRESS1      | text |                                                                    |
| Address line 2 | ADDRESS2      | text |                                                                    |
| Address line 3 | ADDRESS3      | text |                                                                    |
| Address line 4 | ADDRESS4      | text |                                                                    |
| Attention      | ATTENTION     | text |                                                                    |
| Phone          | PHONE1        | text |                                                                    |
| Email          | EMAIL         | text |                                                                    |