API
/
SQL Account
/
SQL Account Customer

Beehexa Customization SQL Account Rest API (1.0)

SQL Account is an accounting software from Malaysia that is suitable for all businesses, from small businesses to large organizations. It is crucial to find a business solution that suits the nature of your business. The right accounting software will broaden the horizons and expand business opportunities for you.

This is a comprehensive REST API for managing SQL accounts. It provides endpoints for user authentication, customer data management, sales transactions, and stock control. Use this API to integrate your applications with the SQL Account software.

Metadata

KeyValue
releaseDate10 Mar 2025
keywordSQL Account Rest API
Download OpenAPI description
docs.json
docs.yaml
Languages
Servers
Mock server
https://docs.beehexa.com/_mock/api/sql-account/docs/
https://sqlaccountrestapi.beehexa.com/

SQL Account App

Provides authentication, system module retrieval, user actions, and application updates.

Operations

SQL Account BizObject

Manages business objects, including querying, creating, updating, and transferring entities.

Operations

SQL Account Customer

Handles customer data retrieval based on email, code, and date filters.

Operations

Retrieves customers by customer email

Request

This API fetches customers that match the provided customer email.

Path
emailstringrequired

The customer email to search.

Default ""
Example: [email protected]
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customers/email/[email protected]?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDPDCTOCRLIMITnumber or string
Example: "T"
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
AGINGONnumber or string
Example: "I"
One of:
number
ALLOWEXCEEDCREDITLIMITnumber or string
Example: "T"
One of:
number
AREAnumber or string
Example: "KL"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
BIZNATUREnumber or string
Example: ""
One of:
number
BRNnumber or string
Example: ""
One of:
number
BRN2number or string
Example: ""
One of:
number
BUSINESSUNITnumber or string
Example: ""
One of:
number
cdsBranchArray of objects(cdsBranch)
CODEnumber or string
Example: "300-A0001"
One of:
number
COMPANYCATEGORYnumber or string
Example: "----"
One of:
number
COMPANYNAMEnumber or string
Example: "A HOME FURNISHING & SERVICE"
One of:
number
COMPANYNAME2number or string
Example: ""
One of:
number
CONTROLACCOUNTnumber or string
Example: "300-000"
One of:
number
CREATIONDATEnumber or string
Example: "2023-02-25T00"
One of:
number
CREDITLIMITnumber or string
Example: 30000
One of:
number
CREDITTERMnumber or string
Example: "30 Days"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
GSTNOnumber or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: ""
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112184
NOTEnumber or string
Example: ""
One of:
number
OUTSTANDINGnumber or string
Example: 1455
One of:
number
OVERDUELIMITnumber or string
Example: 0
One of:
number
PEPPOLIDnumber or string
Example: ""
One of:
number
PRICETAGnumber or string
Example: ""
One of:
number
REMARKnumber or string
Example: ""
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEMENTTYPEnumber or string
Example: "O"
One of:
number
STATUSnumber or string
Example: "A"
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXnumber or string
Example: ""
One of:
number
TAXAREAnumber or string
Example: ""
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TAXEXPDATEnumber or string
Example: ""
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "CODE": "300-A0001",
    "CONTROLACCOUNT": "300-000",
    "COMPANYNAME": "A HOME FURNISHING & SERVICE",
    "COMPANYNAME2": "",
    "COMPANYCATEGORY": "----",
    "AREA": "KL",
    "AGENT": "Yuki",
    "BIZNATURE": "",
    "CREDITTERM": "30 Days",
    "CREDITLIMIT": 30000,
    "OVERDUELIMIT": 0,
    "STATEMENTTYPE": "O",
    "CURRENCYCODE": "----",
    "OUTSTANDING": 1455,
    "ALLOWEXCEEDCREDITLIMIT": "T",
    "ADDPDCTOCRLIMIT": "T",
    "AGINGON": "I",
    "STATUS": "A",
    "PRICETAG": "",
    "CREATIONDATE": "2023-02-25T00:00:00",
    "TAX": "",
    "TAXEXEMPTNO": "",
    "TAXEXPDATE": "",
    "BRN": "",
    "BRN2": "",
    "GSTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "SUBMISSIONTYPE": 0,
    "IRBM_CLASSIFICATION": "",
    "PEPPOLID": "",
    "BUSINESSUNIT": "",
    "TAXAREA": "",
    "ATTACHMENTS": "",
    "REMARK": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112184,
    "cdsBranch": [ … ]
  }
]

Retrieves customers by customer code

Request

This API fetches customers that match the provided customer code. It supports pagination through limit and offset parameters.

Path
codestringrequired

The customer code to search.

Default ""
Example: 300-A0001
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customers/code/300-A0001?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDPDCTOCRLIMITnumber or string
Example: "T"
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
AGINGONnumber or string
Example: "I"
One of:
number
ALLOWEXCEEDCREDITLIMITnumber or string
Example: "T"
One of:
number
AREAnumber or string
Example: "KL"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
BIZNATUREnumber or string
Example: ""
One of:
number
BRNnumber or string
Example: ""
One of:
number
BRN2number or string
Example: ""
One of:
number
BUSINESSUNITnumber or string
Example: ""
One of:
number
cdsBranchArray of objects(cdsBranch)
CODEnumber or string
Example: "300-A0001"
One of:
number
COMPANYCATEGORYnumber or string
Example: "----"
One of:
number
COMPANYNAMEnumber or string
Example: "A HOME FURNISHING & SERVICE"
One of:
number
COMPANYNAME2number or string
Example: ""
One of:
number
CONTROLACCOUNTnumber or string
Example: "300-000"
One of:
number
CREATIONDATEnumber or string
Example: "2023-02-25T00"
One of:
number
CREDITLIMITnumber or string
Example: 30000
One of:
number
CREDITTERMnumber or string
Example: "30 Days"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
GSTNOnumber or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: ""
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112184
NOTEnumber or string
Example: ""
One of:
number
OUTSTANDINGnumber or string
Example: 1455
One of:
number
OVERDUELIMITnumber or string
Example: 0
One of:
number
PEPPOLIDnumber or string
Example: ""
One of:
number
PRICETAGnumber or string
Example: ""
One of:
number
REMARKnumber or string
Example: ""
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEMENTTYPEnumber or string
Example: "O"
One of:
number
STATUSnumber or string
Example: "A"
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXnumber or string
Example: ""
One of:
number
TAXAREAnumber or string
Example: ""
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TAXEXPDATEnumber or string
Example: ""
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "CODE": "300-A0001",
    "CONTROLACCOUNT": "300-000",
    "COMPANYNAME": "A HOME FURNISHING & SERVICE",
    "COMPANYNAME2": "",
    "COMPANYCATEGORY": "----",
    "AREA": "KL",
    "AGENT": "Yuki",
    "BIZNATURE": "",
    "CREDITTERM": "30 Days",
    "CREDITLIMIT": 30000,
    "OVERDUELIMIT": 0,
    "STATEMENTTYPE": "O",
    "CURRENCYCODE": "----",
    "OUTSTANDING": 1455,
    "ALLOWEXCEEDCREDITLIMIT": "T",
    "ADDPDCTOCRLIMIT": "T",
    "AGINGON": "I",
    "STATUS": "A",
    "PRICETAG": "",
    "CREATIONDATE": "2023-02-25T00:00:00",
    "TAX": "",
    "TAXEXEMPTNO": "",
    "TAXEXPDATE": "",
    "BRN": "",
    "BRN2": "",
    "GSTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "SUBMISSIONTYPE": 0,
    "IRBM_CLASSIFICATION": "",
    "PEPPOLID": "",
    "BUSINESSUNIT": "",
    "TAXAREA": "",
    "ATTACHMENTS": "",
    "REMARK": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112184,
    "cdsBranch": [ … ]
  }
]

Retrieves customers from a certain number of days ago

Request

Fetches customers based on the number of days before the current date.

Path
daysinteger(int32)required

The number of days ago to search.

Default 0
Example: 1000
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customers/days-ago/1000?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDPDCTOCRLIMITnumber or string
Example: "T"
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
AGINGONnumber or string
Example: "I"
One of:
number
ALLOWEXCEEDCREDITLIMITnumber or string
Example: "T"
One of:
number
AREAnumber or string
Example: "KL"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
BIZNATUREnumber or string
Example: ""
One of:
number
BRNnumber or string
Example: ""
One of:
number
BRN2number or string
Example: ""
One of:
number
BUSINESSUNITnumber or string
Example: ""
One of:
number
cdsBranchArray of objects(cdsBranch)
CODEnumber or string
Example: "300-A0001"
One of:
number
COMPANYCATEGORYnumber or string
Example: "----"
One of:
number
COMPANYNAMEnumber or string
Example: "A HOME FURNISHING & SERVICE"
One of:
number
COMPANYNAME2number or string
Example: ""
One of:
number
CONTROLACCOUNTnumber or string
Example: "300-000"
One of:
number
CREATIONDATEnumber or string
Example: "2023-02-25T00"
One of:
number
CREDITLIMITnumber or string
Example: 30000
One of:
number
CREDITTERMnumber or string
Example: "30 Days"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
GSTNOnumber or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: ""
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112184
NOTEnumber or string
Example: ""
One of:
number
OUTSTANDINGnumber or string
Example: 1455
One of:
number
OVERDUELIMITnumber or string
Example: 0
One of:
number
PEPPOLIDnumber or string
Example: ""
One of:
number
PRICETAGnumber or string
Example: ""
One of:
number
REMARKnumber or string
Example: ""
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEMENTTYPEnumber or string
Example: "O"
One of:
number
STATUSnumber or string
Example: "A"
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXnumber or string
Example: ""
One of:
number
TAXAREAnumber or string
Example: ""
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TAXEXPDATEnumber or string
Example: ""
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "CODE": "300-A0001",
    "CONTROLACCOUNT": "300-000",
    "COMPANYNAME": "A HOME FURNISHING & SERVICE",
    "COMPANYNAME2": "",
    "COMPANYCATEGORY": "----",
    "AREA": "KL",
    "AGENT": "Yuki",
    "BIZNATURE": "",
    "CREDITTERM": "30 Days",
    "CREDITLIMIT": 30000,
    "OVERDUELIMIT": 0,
    "STATEMENTTYPE": "O",
    "CURRENCYCODE": "----",
    "OUTSTANDING": 1455,
    "ALLOWEXCEEDCREDITLIMIT": "T",
    "ADDPDCTOCRLIMIT": "T",
    "AGINGON": "I",
    "STATUS": "A",
    "PRICETAG": "",
    "CREATIONDATE": "2023-02-25T00:00:00",
    "TAX": "",
    "TAXEXEMPTNO": "",
    "TAXEXPDATE": "",
    "BRN": "",
    "BRN2": "",
    "GSTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "SUBMISSIONTYPE": 0,
    "IRBM_CLASSIFICATION": "",
    "PEPPOLID": "",
    "BUSINESSUNIT": "",
    "TAXAREA": "",
    "ATTACHMENTS": "",
    "REMARK": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112184,
    "cdsBranch": [ … ]
  }
]

Retrieves customers from a specific date

Request

Fetches customers recorded from a given date onward.

Path
datestringrequired

The date in YYYY-MM-DD format.

Default ""
Example: 2020-01-01
Query
limitinteger(int32)

Maximum number of results to return (default: 100).

Default 100
Example: limit=1
offsetinteger(int32)

Offset for pagination (default: 0).

Default 0
Example: offset=0
curl -i -X GET \
  'https://docs.beehexa.com/_mock/api/sql-account/docs/api/customers/from-date/2020-01-01?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDPDCTOCRLIMITnumber or string
Example: "T"
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
AGINGONnumber or string
Example: "I"
One of:
number
ALLOWEXCEEDCREDITLIMITnumber or string
Example: "T"
One of:
number
AREAnumber or string
Example: "KL"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
BIZNATUREnumber or string
Example: ""
One of:
number
BRNnumber or string
Example: ""
One of:
number
BRN2number or string
Example: ""
One of:
number
BUSINESSUNITnumber or string
Example: ""
One of:
number
cdsBranchArray of objects(cdsBranch)
CODEnumber or string
Example: "300-A0001"
One of:
number
COMPANYCATEGORYnumber or string
Example: "----"
One of:
number
COMPANYNAMEnumber or string
Example: "A HOME FURNISHING & SERVICE"
One of:
number
COMPANYNAME2number or string
Example: ""
One of:
number
CONTROLACCOUNTnumber or string
Example: "300-000"
One of:
number
CREATIONDATEnumber or string
Example: "2023-02-25T00"
One of:
number
CREDITLIMITnumber or string
Example: 30000
One of:
number
CREDITTERMnumber or string
Example: "30 Days"
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
GSTNOnumber or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: ""
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112184
NOTEnumber or string
Example: ""
One of:
number
OUTSTANDINGnumber or string
Example: 1455
One of:
number
OVERDUELIMITnumber or string
Example: 0
One of:
number
PEPPOLIDnumber or string
Example: ""
One of:
number
PRICETAGnumber or string
Example: ""
One of:
number
REMARKnumber or string
Example: ""
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEMENTTYPEnumber or string
Example: "O"
One of:
number
STATUSnumber or string
Example: "A"
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXnumber or string
Example: ""
One of:
number
TAXAREAnumber or string
Example: ""
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TAXEXPDATEnumber or string
Example: ""
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "CODE": "300-A0001",
    "CONTROLACCOUNT": "300-000",
    "COMPANYNAME": "A HOME FURNISHING & SERVICE",
    "COMPANYNAME2": "",
    "COMPANYCATEGORY": "----",
    "AREA": "KL",
    "AGENT": "Yuki",
    "BIZNATURE": "",
    "CREDITTERM": "30 Days",
    "CREDITLIMIT": 30000,
    "OVERDUELIMIT": 0,
    "STATEMENTTYPE": "O",
    "CURRENCYCODE": "----",
    "OUTSTANDING": 1455,
    "ALLOWEXCEEDCREDITLIMIT": "T",
    "ADDPDCTOCRLIMIT": "T",
    "AGINGON": "I",
    "STATUS": "A",
    "PRICETAG": "",
    "CREATIONDATE": "2023-02-25T00:00:00",
    "TAX": "",
    "TAXEXEMPTNO": "",
    "TAXEXPDATE": "",
    "BRN": "",
    "BRN2": "",
    "GSTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "SUBMISSIONTYPE": 0,
    "IRBM_CLASSIFICATION": "",
    "PEPPOLID": "",
    "BUSINESSUNIT": "",
    "TAXAREA": "",
    "ATTACHMENTS": "",
    "REMARK": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112184,
    "cdsBranch": [ … ]
  }
]

SQL Account Customer Invoice

Retrieves customer invoices based on document numbers, date filters, and transaction history.

Operations

SQL Account Customer Payment

Manages customer payments, including retrieval by document number and payment history tracking.

Operations

SQL Account History

Provides access to system logs, log details, and historical transaction downloads.

Operations

SQL Account Sales Invoice

Retrieves sales invoices by document number and filters based on transaction dates.

Operations

SQL Account Sales Order

Handles sales orders, including retrieval by document number and transaction history.

Operations

SQL Account Stock Adjustment

Manages stock adjustments, including retrieval by document number and date-based filters.

Operations

SQL Account Stock Item

Retrieves stock item details based on code and historical transaction data.

Operations

SQL Account Stock Item Template

Provides access to predefined stock item templates for inventory standardization.

Operations