Customer

SQL ACCOUNTING integration - customer

example script
purpose

payloadData["type"] = "AR_CUSTOMER"

to let the system know you integration with Customer

payloadData["payload"]["COMPANYNAME"] = data["Name"]

change ["COMPANYNAME"]. You can refer below 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

Last updated