API
/
SQL Account
/
SQL Account Sales Invoice

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

Retrieves sales invoices by document number

Request

This API fetches sales invoices that match the provided document number.

Path
documentNumberstringrequired

The document number to search.

Default ""
Example: IV-00001
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/sales-invoices/docno/IV-00001?limit=1&offset=0'

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
ADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
ADDRESS3number or string
Example: ""
One of:
number
ADDRESS4number or string
Example: ""
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
EIV_UTCstring
Example: ""
LASTMODIFIEDnumber
Example: 1730460182
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
ATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
BRANCHNAMEnumber or string
Example: "BILLING"
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
CCnumber or string
Example: ""
One of:
number
cdsDocDetailArray of objects(SaleInvoiceDetail)
CITYnumber or string
Example: ""
One of:
number
CODEnumber or string
Example: "300-T0001"
One of:
number
COMPANYNAMEnumber or string
Example: "THAI TEA TRADING"
One of:
number
COUNTRYnumber or string
Example: ""
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
DADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
DADDRESS3number or string
Example: ""
One of:
number
DADDRESS4number or string
Example: ""
One of:
number
DATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
DCITYnumber or string
Example: ""
One of:
number
DCOUNTRYnumber or string
Example: ""
One of:
number
DELIVERYTERMnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DFAX1number or string
Example: ""
One of:
number
DMOBILEnumber or string
Example: ""
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11T00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DOCREF1number or string
Example: ""
One of:
number
DOCREF2number or string
Example: ""
One of:
number
DOCREF3number or string
Example: ""
One of:
number
DOCREF4number or string
Example: ""
One of:
number
DPHONE1number or string
Example: "03-3816 1027"
One of:
number
DPOSTCODEnumber or string
Example: ""
One of:
number
DSTATEnumber or string
Example: ""
One of:
number
D_AMOUNTnumber or string
Example: 0
One of:
number
EIVDATETIMEnumber or string
Example: ""
One of:
number
FAX1number or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
INCOTERMSnumber or string
Example: ""
One of:
number
IRBM_INTERNALIDnumber or string
Example: ""
One of:
number
IRBM_LONGIDnumber or string
Example: ""
One of:
number
IRBM_STATUSnumber or string
Example: 0
One of:
number
IRBM_UUIDnumber or string
Example: ""
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
MOBILEnumber or string
Example: ""
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHONE1number or string
Example: "03-3816 1027"
One of:
number
POSTCODEnumber or string
Example: ""
One of:
number
POSTDATEnumber or string
Example: "2024-06-11T00"
One of:
number
PRINTCOUNTnumber or string
Example: 0
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SHIPPERnumber or string
Example: "----"
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEnumber or string
Example: ""
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXDATEnumber or string
Example: "2024-06-11T00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
TRANSFERABLEnumber or string
Example: "T"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
VALIDITYnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "EIVDATETIME": "",
    "CODE": "300-T0001",
    "COMPANYNAME": "THAI TEA TRADING",
    "ADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "ADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "ADDRESS3": "",
    "ADDRESS4": "",
    "POSTCODE": "",
    "CITY": "",
    "STATE": "",
    "COUNTRY": "",
    "PHONE1": "03-3816 1027",
    "MOBILE": "",
    "EIV_UTC": "",
    "FAX1": "",
    "ATTENTION": "Mr. Leonard",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "TERMS": "60 Days",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "SHIPPER": "----",
    "DESCRIPTION": "Sales",
    "CANCELLED": "F",
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "D_AMOUNT": 0,
    "VALIDITY": "",
    "DELIVERYTERM": "",
    "CC": "",
    "DOCREF1": "",
    "DOCREF2": "",
    "DOCREF3": "",
    "DOCREF4": "",
    "BRANCHNAME": "BILLING",
    "DADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "DADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "DADDRESS3": "",
    "DADDRESS4": "",
    "DPOSTCODE": "",
    "DCITY": "",
    "DSTATE": "",
    "DCOUNTRY": "",
    "DATTENTION": "Mr. Leonard",
    "DPHONE1": "03-3816 1027",
    "DMOBILE": "",
    "DFAX1": "",
    "TAXEXEMPTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "INCOTERMS": "",
    "LASTMODIFIED": 1730460182,
    "SUBMISSIONTYPE": 0,
    "IRBM_STATUS": 0,
    "IRBM_INTERNALID": "",
    "IRBM_UUID": "",
    "IRBM_LONGID": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "TRANSFERABLE": "T",
    "UPDATECOUNT": "",
    "PRINTCOUNT": 0,
    "cdsDocDetail": [ … ]
  }
]

Retrieves sales invoices from a certain number of days ago

Request

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

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
ADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
ADDRESS3number or string
Example: ""
One of:
number
ADDRESS4number or string
Example: ""
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
EIV_UTCstring
Example: ""
LASTMODIFIEDnumber
Example: 1730460182
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
ATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
BRANCHNAMEnumber or string
Example: "BILLING"
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
CCnumber or string
Example: ""
One of:
number
cdsDocDetailArray of objects(SaleInvoiceDetail)
CITYnumber or string
Example: ""
One of:
number
CODEnumber or string
Example: "300-T0001"
One of:
number
COMPANYNAMEnumber or string
Example: "THAI TEA TRADING"
One of:
number
COUNTRYnumber or string
Example: ""
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
DADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
DADDRESS3number or string
Example: ""
One of:
number
DADDRESS4number or string
Example: ""
One of:
number
DATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
DCITYnumber or string
Example: ""
One of:
number
DCOUNTRYnumber or string
Example: ""
One of:
number
DELIVERYTERMnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DFAX1number or string
Example: ""
One of:
number
DMOBILEnumber or string
Example: ""
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11T00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DOCREF1number or string
Example: ""
One of:
number
DOCREF2number or string
Example: ""
One of:
number
DOCREF3number or string
Example: ""
One of:
number
DOCREF4number or string
Example: ""
One of:
number
DPHONE1number or string
Example: "03-3816 1027"
One of:
number
DPOSTCODEnumber or string
Example: ""
One of:
number
DSTATEnumber or string
Example: ""
One of:
number
D_AMOUNTnumber or string
Example: 0
One of:
number
EIVDATETIMEnumber or string
Example: ""
One of:
number
FAX1number or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
INCOTERMSnumber or string
Example: ""
One of:
number
IRBM_INTERNALIDnumber or string
Example: ""
One of:
number
IRBM_LONGIDnumber or string
Example: ""
One of:
number
IRBM_STATUSnumber or string
Example: 0
One of:
number
IRBM_UUIDnumber or string
Example: ""
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
MOBILEnumber or string
Example: ""
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHONE1number or string
Example: "03-3816 1027"
One of:
number
POSTCODEnumber or string
Example: ""
One of:
number
POSTDATEnumber or string
Example: "2024-06-11T00"
One of:
number
PRINTCOUNTnumber or string
Example: 0
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SHIPPERnumber or string
Example: "----"
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEnumber or string
Example: ""
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXDATEnumber or string
Example: "2024-06-11T00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
TRANSFERABLEnumber or string
Example: "T"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
VALIDITYnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "EIVDATETIME": "",
    "CODE": "300-T0001",
    "COMPANYNAME": "THAI TEA TRADING",
    "ADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "ADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "ADDRESS3": "",
    "ADDRESS4": "",
    "POSTCODE": "",
    "CITY": "",
    "STATE": "",
    "COUNTRY": "",
    "PHONE1": "03-3816 1027",
    "MOBILE": "",
    "EIV_UTC": "",
    "FAX1": "",
    "ATTENTION": "Mr. Leonard",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "TERMS": "60 Days",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "SHIPPER": "----",
    "DESCRIPTION": "Sales",
    "CANCELLED": "F",
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "D_AMOUNT": 0,
    "VALIDITY": "",
    "DELIVERYTERM": "",
    "CC": "",
    "DOCREF1": "",
    "DOCREF2": "",
    "DOCREF3": "",
    "DOCREF4": "",
    "BRANCHNAME": "BILLING",
    "DADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "DADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "DADDRESS3": "",
    "DADDRESS4": "",
    "DPOSTCODE": "",
    "DCITY": "",
    "DSTATE": "",
    "DCOUNTRY": "",
    "DATTENTION": "Mr. Leonard",
    "DPHONE1": "03-3816 1027",
    "DMOBILE": "",
    "DFAX1": "",
    "TAXEXEMPTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "INCOTERMS": "",
    "LASTMODIFIED": 1730460182,
    "SUBMISSIONTYPE": 0,
    "IRBM_STATUS": 0,
    "IRBM_INTERNALID": "",
    "IRBM_UUID": "",
    "IRBM_LONGID": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "TRANSFERABLE": "T",
    "UPDATECOUNT": "",
    "PRINTCOUNT": 0,
    "cdsDocDetail": [ … ]
  }
]

Retrieves sales invoices from a specific date

Request

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

Responses

Returns the details of the business object

Bodyapplication/jsonArray [
ADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
ADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
ADDRESS3number or string
Example: ""
One of:
number
ADDRESS4number or string
Example: ""
One of:
number
AGENTnumber or string
Example: "Yuki"
One of:
number
EIV_UTCstring
Example: ""
LASTMODIFIEDnumber
Example: 1730460182
AREAnumber or string
Example: "Selangor"
One of:
number
ATTACHMENTSnumber or string
Example: ""
One of:
number
ATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
BRANCHNAMEnumber or string
Example: "BILLING"
One of:
number
CANCELLEDnumber or string
Example: "F"
One of:
number
CCnumber or string
Example: ""
One of:
number
cdsDocDetailArray of objects(SaleInvoiceDetail)
CITYnumber or string
Example: ""
One of:
number
CODEnumber or string
Example: "300-T0001"
One of:
number
COMPANYNAMEnumber or string
Example: "THAI TEA TRADING"
One of:
number
COUNTRYnumber or string
Example: ""
One of:
number
CURRENCYCODEnumber or string
Example: "----"
One of:
number
CURRENCYRATEnumber or string
Example: 1
One of:
number
DADDRESS1number or string
Example: "No 45, Jalan Batu Tiga Klang,"
One of:
number
DADDRESS2number or string
Example: "42000, Pelabuhan Klang, Selangor."
One of:
number
DADDRESS3number or string
Example: ""
One of:
number
DADDRESS4number or string
Example: ""
One of:
number
DATTENTIONnumber or string
Example: "Mr. Leonard"
One of:
number
DCITYnumber or string
Example: ""
One of:
number
DCOUNTRYnumber or string
Example: ""
One of:
number
DELIVERYTERMnumber or string
Example: ""
One of:
number
DESCRIPTIONnumber or string
Example: "Sales"
One of:
number
DFAX1number or string
Example: ""
One of:
number
DMOBILEnumber or string
Example: ""
One of:
number
DOCAMTnumber or string
Example: 800
One of:
number
DOCDATEnumber or string
Example: "2024-06-11T00"
One of:
number
DOCKEYnumber or string
Example: 1
One of:
number
DOCNOnumber or string
Example: "IV-00001"
One of:
number
DOCNOEXnumber or string
Example: ""
One of:
number
DOCREF1number or string
Example: ""
One of:
number
DOCREF2number or string
Example: ""
One of:
number
DOCREF3number or string
Example: ""
One of:
number
DOCREF4number or string
Example: ""
One of:
number
DPHONE1number or string
Example: "03-3816 1027"
One of:
number
DPOSTCODEnumber or string
Example: ""
One of:
number
DSTATEnumber or string
Example: ""
One of:
number
D_AMOUNTnumber or string
Example: 0
One of:
number
EIVDATETIMEnumber or string
Example: ""
One of:
number
FAX1number or string
Example: ""
One of:
number
IDNOnumber or string
Example: ""
One of:
number
IDTYPEnumber or string
Example: 0
One of:
number
INCOTERMSnumber or string
Example: ""
One of:
number
IRBM_INTERNALIDnumber or string
Example: ""
One of:
number
IRBM_LONGIDnumber or string
Example: ""
One of:
number
IRBM_STATUSnumber or string
Example: 0
One of:
number
IRBM_UUIDnumber or string
Example: ""
One of:
number
LOCALDOCAMTnumber or string
Example: 800
One of:
number
MOBILEnumber or string
Example: ""
One of:
number
NOTEnumber or string
Example: ""
One of:
number
PHONE1number or string
Example: "03-3816 1027"
One of:
number
POSTCODEnumber or string
Example: ""
One of:
number
POSTDATEnumber or string
Example: "2024-06-11T00"
One of:
number
PRINTCOUNTnumber or string
Example: 0
One of:
number
PROJECTnumber or string
Example: "----"
One of:
number
SALESTAXNOnumber or string
Example: ""
One of:
number
SERVICETAXNOnumber or string
Example: ""
One of:
number
SHIPPERnumber or string
Example: "----"
One of:
number
SICnumber or string
Example: ""
One of:
number
STATEnumber or string
Example: ""
One of:
number
SUBMISSIONTYPEnumber or string
Example: 0
One of:
number
TAXDATEnumber or string
Example: "2024-06-11T00"
One of:
number
TAXEXEMPTNOnumber or string
Example: ""
One of:
number
TERMSnumber or string
Example: "60 Days"
One of:
number
TINnumber or string
Example: ""
One of:
number
TOURISMNOnumber or string
Example: ""
One of:
number
TRANSFERABLEnumber or string
Example: "T"
One of:
number
UPDATECOUNTnumber or string
Example: ""
One of:
number
VALIDITYnumber or string
Example: ""
One of:
number
]
Response
application/json
[
  {
    "DOCKEY": 1,
    "DOCNO": "IV-00001",
    "DOCNOEX": "",
    "DOCDATE": "2024-06-11T00:00:00",
    "POSTDATE": "2024-06-11T00:00:00",
    "TAXDATE": "2024-06-11T00:00:00",
    "EIVDATETIME": "",
    "CODE": "300-T0001",
    "COMPANYNAME": "THAI TEA TRADING",
    "ADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "ADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "ADDRESS3": "",
    "ADDRESS4": "",
    "POSTCODE": "",
    "CITY": "",
    "STATE": "",
    "COUNTRY": "",
    "PHONE1": "03-3816 1027",
    "MOBILE": "",
    "EIV_UTC": "",
    "FAX1": "",
    "ATTENTION": "Mr. Leonard",
    "AREA": "Selangor",
    "AGENT": "Yuki",
    "PROJECT": "----",
    "TERMS": "60 Days",
    "CURRENCYCODE": "----",
    "CURRENCYRATE": 1,
    "SHIPPER": "----",
    "DESCRIPTION": "Sales",
    "CANCELLED": "F",
    "DOCAMT": 800,
    "LOCALDOCAMT": 800,
    "D_AMOUNT": 0,
    "VALIDITY": "",
    "DELIVERYTERM": "",
    "CC": "",
    "DOCREF1": "",
    "DOCREF2": "",
    "DOCREF3": "",
    "DOCREF4": "",
    "BRANCHNAME": "BILLING",
    "DADDRESS1": "No 45, Jalan Batu Tiga Klang,",
    "DADDRESS2": "42000, Pelabuhan Klang, Selangor.",
    "DADDRESS3": "",
    "DADDRESS4": "",
    "DPOSTCODE": "",
    "DCITY": "",
    "DSTATE": "",
    "DCOUNTRY": "",
    "DATTENTION": "Mr. Leonard",
    "DPHONE1": "03-3816 1027",
    "DMOBILE": "",
    "DFAX1": "",
    "TAXEXEMPTNO": "",
    "SALESTAXNO": "",
    "SERVICETAXNO": "",
    "TIN": "",
    "IDTYPE": 0,
    "IDNO": "",
    "TOURISMNO": "",
    "SIC": "",
    "INCOTERMS": "",
    "LASTMODIFIED": 1730460182,
    "SUBMISSIONTYPE": 0,
    "IRBM_STATUS": 0,
    "IRBM_INTERNALID": "",
    "IRBM_UUID": "",
    "IRBM_LONGID": "",
    "ATTACHMENTS": "",
    "NOTE": "",
    "TRANSFERABLE": "T",
    "UPDATECOUNT": "",
    "PRINTCOUNT": 0,
    "cdsDocDetail": [ … ]
  }
]

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