API
/
SQL Account
/
SQL Account Stock Item

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

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

Retrieves stock items by code

Request

This API fetches stock items that match the provided code.

Path
codestringrequired

The code to search.

Default ""
Example: SEMI BOM
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/stock-items/code/SEMI BOM?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
BALSQTYnumber or string
Example: -5
One of:
number
BALSUOMQTYnumber or string
Example: 0
One of:
number
BOM_ASMCOSTnumber or string
Example: 0
One of:
number
BOM_LEADTIMEnumber or string
Example: 0
One of:
number
cdsUOMArray of objects(UOM)
CODEnumber or string
Example: "SEMI BOM"
One of:
number
COSTINGMETHODnumber or string
Example: 1
One of:
number
CREATIONDATEnumber or string
Example: "2024-08-08T00"
One of:
number
DEFUOM_PHnumber or string
Example: ""
One of:
number
DEFUOM_SLnumber or string
Example: ""
One of:
number
DEFUOM_STnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "SEMI BOM"
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: 18
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
ITEMTYPEnumber or string
Example: "B"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112180
LEADTIMEnumber or string
Example: 0
One of:
number
MAXQTYnumber or string
Example: 0
One of:
number
MINQTYnumber or string
Example: 0
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHTAXnumber or string
Example: ""
One of:
number
PICTUREnumber or string
Example: ""
One of:
number
PICTURECLASSnumber or string
Example: ""
One of:
number
REMARK1number or string
Example: ""
One of:
number
REMARK2number or string
Example: ""
One of:
number
REORDERLEVELnumber or string
Example: 0
One of:
number
REORDERQTYnumber or string
Example: 1
One of:
number
SCRIPTCODEnumber or string
Example: ""
One of:
number
SERIALNUMBERnumber or string
Example: "F"
One of:
number
SHELFnumber or string
Example: ""
One of:
number
SLTAXnumber or string
Example: ""
One of:
number
STOCKCONTROLnumber or string
Example: "T"
One of:
number
STOCKGROUPnumber or string
Example: "OTHERS"
One of:
number
STOCKMATRIXnumber or string
Example: ""
One of:
number
SUOMnumber or string
Example: ""
One of:
number
TARIFFnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "CODE": "SEMI BOM",
    "DESCRIPTION": "SEMI BOM",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "STOCKGROUP": "OTHERS",
    "STOCKCONTROL": "T",
    "COSTINGMETHOD": 1,
    "SERIALNUMBER": "F",
    "REMARK1": "",
    "REMARK2": "",
    "MINQTY": 0,
    "MAXQTY": 0,
    "REORDERLEVEL": 0,
    "REORDERQTY": 1,
    "SHELF": "",
    "SUOM": "",
    "ITEMTYPE": "B",
    "LEADTIME": 0,
    "BOM_LEADTIME": 0,
    "BOM_ASMCOST": 0,
    "SLTAX": "",
    "PHTAX": "",
    "TARIFF": "",
    "IRBM_CLASSIFICATION": 22,
    "STOCKMATRIX": "",
    "DEFUOM_ST": "",
    "DEFUOM_SL": "",
    "DEFUOM_PH": "",
    "SCRIPTCODE": "",
    "ISACTIVE": "T",
    "BALSQTY": -5,
    "BALSUOMQTY": 0,
    "CREATIONDATE": "2024-08-08T00:00:00",
    "PICTURE": "",
    "PICTURECLASS": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112180,
    "cdsUOM": [ … ]
  }
]

Retrieves stock items from a certain number of days ago

Request

Fetches stock items 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/stock-items/days-ago/1000?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
BALSQTYnumber or string
Example: -5
One of:
number
BALSUOMQTYnumber or string
Example: 0
One of:
number
BOM_ASMCOSTnumber or string
Example: 0
One of:
number
BOM_LEADTIMEnumber or string
Example: 0
One of:
number
cdsUOMArray of objects(UOM)
CODEnumber or string
Example: "SEMI BOM"
One of:
number
COSTINGMETHODnumber or string
Example: 1
One of:
number
CREATIONDATEnumber or string
Example: "2024-08-08T00"
One of:
number
DEFUOM_PHnumber or string
Example: ""
One of:
number
DEFUOM_SLnumber or string
Example: ""
One of:
number
DEFUOM_STnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "SEMI BOM"
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: 18
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
ITEMTYPEnumber or string
Example: "B"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112180
LEADTIMEnumber or string
Example: 0
One of:
number
MAXQTYnumber or string
Example: 0
One of:
number
MINQTYnumber or string
Example: 0
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHTAXnumber or string
Example: ""
One of:
number
PICTUREnumber or string
Example: ""
One of:
number
PICTURECLASSnumber or string
Example: ""
One of:
number
REMARK1number or string
Example: ""
One of:
number
REMARK2number or string
Example: ""
One of:
number
REORDERLEVELnumber or string
Example: 0
One of:
number
REORDERQTYnumber or string
Example: 1
One of:
number
SCRIPTCODEnumber or string
Example: ""
One of:
number
SERIALNUMBERnumber or string
Example: "F"
One of:
number
SHELFnumber or string
Example: ""
One of:
number
SLTAXnumber or string
Example: ""
One of:
number
STOCKCONTROLnumber or string
Example: "T"
One of:
number
STOCKGROUPnumber or string
Example: "OTHERS"
One of:
number
STOCKMATRIXnumber or string
Example: ""
One of:
number
SUOMnumber or string
Example: ""
One of:
number
TARIFFnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "CODE": "SEMI BOM",
    "DESCRIPTION": "SEMI BOM",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "STOCKGROUP": "OTHERS",
    "STOCKCONTROL": "T",
    "COSTINGMETHOD": 1,
    "SERIALNUMBER": "F",
    "REMARK1": "",
    "REMARK2": "",
    "MINQTY": 0,
    "MAXQTY": 0,
    "REORDERLEVEL": 0,
    "REORDERQTY": 1,
    "SHELF": "",
    "SUOM": "",
    "ITEMTYPE": "B",
    "LEADTIME": 0,
    "BOM_LEADTIME": 0,
    "BOM_ASMCOST": 0,
    "SLTAX": "",
    "PHTAX": "",
    "TARIFF": "",
    "IRBM_CLASSIFICATION": 22,
    "STOCKMATRIX": "",
    "DEFUOM_ST": "",
    "DEFUOM_SL": "",
    "DEFUOM_PH": "",
    "SCRIPTCODE": "",
    "ISACTIVE": "T",
    "BALSQTY": -5,
    "BALSUOMQTY": 0,
    "CREATIONDATE": "2024-08-08T00:00:00",
    "PICTURE": "",
    "PICTURECLASS": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112180,
    "cdsUOM": [ … ]
  }
]

Retrieves stock items from a specific date

Request

Fetches stock items 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/stock-items/from-date/2020-01-01?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ATTACHMENTSnumber or string
Example: ""
One of:
number
BALSQTYnumber or string
Example: -5
One of:
number
BALSUOMQTYnumber or string
Example: 0
One of:
number
BOM_ASMCOSTnumber or string
Example: 0
One of:
number
BOM_LEADTIMEnumber or string
Example: 0
One of:
number
cdsUOMArray of objects(UOM)
CODEnumber or string
Example: "SEMI BOM"
One of:
number
COSTINGMETHODnumber or string
Example: 1
One of:
number
CREATIONDATEnumber or string
Example: "2024-08-08T00"
One of:
number
DEFUOM_PHnumber or string
Example: ""
One of:
number
DEFUOM_SLnumber or string
Example: ""
One of:
number
DEFUOM_STnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "SEMI BOM"
One of:
number
DESCRIPTION2number or string
Example: ""
One of:
number
DESCRIPTION3number or string
Example: ""
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
IRBM_CLASSIFICATIONnumber or string
Example: 18
One of:
number
ISACTIVEnumber or string
Example: "T"
One of:
number
ITEMTYPEnumber or string
Example: "B"
One of:
number
LASTMODIFIEDinteger(int64)
Example: 1723112180
LEADTIMEnumber or string
Example: 0
One of:
number
MAXQTYnumber or string
Example: 0
One of:
number
MINQTYnumber or string
Example: 0
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHTAXnumber or string
Example: ""
One of:
number
PICTUREnumber or string
Example: ""
One of:
number
PICTURECLASSnumber or string
Example: ""
One of:
number
REMARK1number or string
Example: ""
One of:
number
REMARK2number or string
Example: ""
One of:
number
REORDERLEVELnumber or string
Example: 0
One of:
number
REORDERQTYnumber or string
Example: 1
One of:
number
SCRIPTCODEnumber or string
Example: ""
One of:
number
SERIALNUMBERnumber or string
Example: "F"
One of:
number
SHELFnumber or string
Example: ""
One of:
number
SLTAXnumber or string
Example: ""
One of:
number
STOCKCONTROLnumber or string
Example: "T"
One of:
number
STOCKGROUPnumber or string
Example: "OTHERS"
One of:
number
STOCKMATRIXnumber or string
Example: ""
One of:
number
SUOMnumber or string
Example: ""
One of:
number
TARIFFnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "CODE": "SEMI BOM",
    "DESCRIPTION": "SEMI BOM",
    "DESCRIPTION2": "",
    "DESCRIPTION3": "",
    "STOCKGROUP": "OTHERS",
    "STOCKCONTROL": "T",
    "COSTINGMETHOD": 1,
    "SERIALNUMBER": "F",
    "REMARK1": "",
    "REMARK2": "",
    "MINQTY": 0,
    "MAXQTY": 0,
    "REORDERLEVEL": 0,
    "REORDERQTY": 1,
    "SHELF": "",
    "SUOM": "",
    "ITEMTYPE": "B",
    "LEADTIME": 0,
    "BOM_LEADTIME": 0,
    "BOM_ASMCOST": 0,
    "SLTAX": "",
    "PHTAX": "",
    "TARIFF": "",
    "IRBM_CLASSIFICATION": 22,
    "STOCKMATRIX": "",
    "DEFUOM_ST": "",
    "DEFUOM_SL": "",
    "DEFUOM_PH": "",
    "SCRIPTCODE": "",
    "ISACTIVE": "T",
    "BALSQTY": -5,
    "BALSUOMQTY": 0,
    "CREATIONDATE": "2024-08-08T00:00:00",
    "PICTURE": "",
    "PICTURECLASS": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "LASTMODIFIED": 1723112180,
    "cdsUOM": [ … ]
  }
]

SQL Account Stock Item Template

Provides access to predefined stock item templates for inventory standardization.

Operations