Details API
This API is for selecting Purpose by its code and user.
Table of Contents
Show
API Definition
| Field | Details |
|---|---|
| Endpoint | /api/sales-order-detail/{id} |
| Method | GET |
| Authentication | Required |
Request
| Header | Value |
|---|---|
| Authorization | Value |
| Content-type | application/json |
Query Parameters:
| Parameter | Type | Required | Description |
|---|---|---|---|
| id | integer | Yes | ID of the sales order detail |
Request Body:
- None
Response
Success (200):
{
"data": {
"model": {
"batch_no": "",
"del_date": "2025-03-27 00:00:00",
"description": "MINT APPLE CUP",
"disc_amt": "0.000000",
"disc_local_amt": "0.000000",
"disc_percent_01": "0.0000",
"disc_percent_02": "0.0000",
"disc_percent_03": "0.0000",
"disc_percent_04": "0.0000",
"disc_percent_05": "0.0000",
"disc_percent_06": "0.0000",
"disc_percent_07": "0.0000",
"disc_percent_08": "0.0000",
"expiry_date": "1970-01-01 00:00:00",
"foc_flag": "0",
"hdr_id": "19166",
"is_closed": "0",
"item_id": "5001",
"line_no": "1",
"list_price": "0.0000",
"location_id": "1",
"net_amt": "0.000000",
"net_local_amt": "0.000000",
"order_amt": "0.000000",
"order_local_amt": "0.000000",
"price": "0.000000",
"price_disc": 0,
"promo_qty": "0.0000",
"promo_uuid": null,
"promotion_hdr_id": "0",
"qty": "0.0000",
"remark": "test1\ntest2",
"sent_qty": "0.0000",
"serial_no": "",
"shelf_id": "1",
"stock_rotation_id": "1",
"tax_amt": "0.000000",
"tax_group_id": "1",
"tax_id_01": "1",
"tax_id_02": "0",
"tax_id_03": "0",
"tax_id_04": "0",
"tax_local_amt": "0.000000",
"tax_percent_01": "6.00",
"tax_percent_02": "0.00",
"tax_percent_03": "0.00",
"tax_percent_04": "0.00",
"uom_id": "4",
"uom_rate": "24.000000",
"userdate_01": "1970-01-01 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00",
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"usernumber_01": "0.0000",
"usernumber_02": "0.0000",
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"useryesno_01": "0",
"useryesno_02": "0",
"useryesno_03": "0",
"useryesno_04": "0"
},
"item": {
"value": "5001",
"label": "041052",
"sublabel": "Chocolate Biscuit",
"item_price": [
{
"id": 12168,
"item_id": 5001,
"price_group_id": 0,
"uom_id": 4,
"currency_id": 1,
"unit_price": "21.1200",
"valid_from": "1970-01-02 07:30:00",
"valid_to": "2024-12-31 00:00:00",
"created": "2019-04-03 11:24:14",
"createdby": 1,
"updated": "2022-11-01 11:10:24",
"updatedby": 1
},
{
"id": 12169,
"item_id": 5001,
"price_group_id": 0,
"uom_id": 5,
"currency_id": 1,
"unit_price": "0.8800",
"valid_from": "1970-01-02 07:30:00",
"valid_to": "2024-12-31 00:00:00",
"created": "2019-04-03 11:24:46",
"createdby": 1,
"updated": "2022-11-01 11:10:13",
"updatedby": 1
}
]
},
"item_price": 0,
"uom": {
"value": "4",
"label": "CTN",
"rate": "24.000000"
},
"tax_group": {
"value": "1",
"label": "SR"
},
"department_dropdown": {
"value": "1",
"label": "Egg-Brooding Farm"
},
"cost_center_dropdown": {
"value": "1",
"label": "Brooding Farm 01"
},
"purpose_dropdown": {
"value": "3",
"label": "Laskar Fertiliser Sdn Bhd"
},
"currency_rate": "1.000000",
"customer_id": "1806",
"division_default_id": "1",
"division_id": "3",
"doc_date": "2025-03-27 00:00:00",
"inventory": {
"onHandQty": "-13 CTN ",
"reserved_qty": "2 CTN ",
"available_qty": "-15 CTN "
},
"location_dropdown": [
{
"label": "D06",
"value": "1"
},
{
"label": "XMAIN",
"value": "2"
},
{
"label": "DW01-GOOD",
"value": "51"
}
],
"page_title": "",
"price_history": {
"_1_dtl_id": "173757",
"_1_hdr_id": "17353",
"_1_price": "0.7500",
"_1_disc_percent_01": "5.0000",
"_1_disc_percent_02": "0.0000",
"_1_disc_percent_03": "0.0000",
"_1_disc_percent_04": "0.0000",
"_1_hdr_disc_percent_01": "0.0000",
"_1_hdr_disc_percent_02": "0.0000",
"_1_hdr_disc_percent_03": "0.0000",
"_1_hdr_disc_percent_04": "0.0000",
"_1_amt_bfr_tax": "2.85",
"_1_doc_date": "2019-05-27",
"_1_doc_code": "IN0700331",
"_1_ref_code": null,
"_1_uom": "PACK",
"_1_disc_percent": "5%+0%+0%+0%",
"_1_hdr_disc_percent": "",
"_1_qty": 4,
"_1_tax": "",
"_1_useryesno_01": "",
"_1_salesman_code": "demo2",
"_1_branch_name": "",
"_1_so_code": "CC0700004184",
"_1_link": "/eficoreapi/?r=doInvHdr/viewInvoice&id=17353",
"_1_promo_code": "PQT-BISCUIT",
"_1_batch_no": "PQW100025",
"_2_dtl_id": "173723",
"_2_hdr_id": "17344",
"_2_price": "18.0000",
"_2_disc_percent_01": "0.0000",
"_2_disc_percent_02": "0.0000",
"_2_disc_percent_03": "0.0000",
"_2_disc_percent_04": "0.0000",
"_2_hdr_disc_percent_01": "0.0000",
"_2_hdr_disc_percent_02": "0.0000",
"_2_hdr_disc_percent_03": "0.0000",
"_2_hdr_disc_percent_04": "0.0000",
"_2_amt_bfr_tax": "54.00",
"_2_doc_date": "2019-05-26",
"_2_doc_code": "IN0700317",
"_2_ref_code": null,
"_2_uom": "CTN",
"_2_disc_percent": "",
"_2_hdr_disc_percent": "",
"_2_qty": 3,
"_2_tax": "",
"_2_useryesno_01": "",
"_2_salesman_code": "demo2",
"_2_branch_name": "",
"_2_so_code": "CC0700002184",
"_2_link": "/eficoreapi/?r=doInvHdr/viewInvoice&id=17344",
"_2_promo_code": "",
"_2_batch_no": "PQW100025",
"_3_dtl_id": "173718",
"_3_hdr_id": "17343",
"_3_price": "0.7500",
"_3_disc_percent_01": "0.0000",
"_3_disc_percent_02": "0.0000",
"_3_disc_percent_03": "0.0000",
"_3_disc_percent_04": "0.0000",
"_3_hdr_disc_percent_01": "0.0000",
"_3_hdr_disc_percent_02": "0.0000",
"_3_hdr_disc_percent_03": "0.0000",
"_3_hdr_disc_percent_04": "0.0000",
"_3_amt_bfr_tax": "4.50",
"_3_doc_date": "2019-05-26",
"_3_doc_code": "IN0700316",
"_3_ref_code": null,
"_3_uom": "PACK",
"_3_disc_percent": "",
"_3_hdr_disc_percent": "",
"_3_qty": 6,
"_3_tax": "",
"_3_useryesno_01": "",
"_3_salesman_code": "demo2",
"_3_branch_name": "",
"_3_so_code": "CC0700001184",
"_3_link": "/eficoreapi/?r=doInvHdr/viewInvoice&id=17343",
"_3_promo_code": "",
"_3_batch_no": "PQW100025",
"_r1_dtl_id": null,
"_r1_hdr_id": null,
"_r1_price": null,
"_r1_disc_percent_01": null,
"_r1_disc_percent_02": null,
"_r1_disc_percent_03": null,
"_r1_disc_percent_04": null,
"_r1_hdr_disc_percent_01": null,
"_r1_hdr_disc_percent_02": null,
"_r1_hdr_disc_percent_03": null,
"_r1_hdr_disc_percent_04": null,
"_r1_amt_bfr_tax": null,
"_r1_doc_date": null,
"_r1_doc_code": null,
"_r1_ref_code": null,
"_r1_uom": null,
"_r1_disc_percent": null,
"_r1_hdr_disc_percent": null,
"_r1_qty": null,
"_r1_tax": null,
"_r1_useryesno_01": null,
"_r1_link": null,
"_r1_batch_no": null,
"_r2_dtl_id": null,
"_r2_hdr_id": null,
"_r2_price": null,
"_r2_disc_percent_01": null,
"_r2_disc_percent_02": null,
"_r2_disc_percent_03": null,
"_r2_disc_percent_04": null,
"_r2_hdr_disc_percent_01": null,
"_r2_hdr_disc_percent_02": null,
"_r2_hdr_disc_percent_03": null,
"_r2_hdr_disc_percent_04": null,
"_r2_amt_bfr_tax": null,
"_r2_doc_date": null,
"_r2_doc_code": null,
"_r2_ref_code": null,
"_r2_uom": null,
"_r2_disc_percent": null,
"_r2_hdr_disc_percent": null,
"_r2_qty": null,
"_r2_tax": null,
"_r2_useryesno_01": null,
"_r2_link": null,
"_r2_batch_no": null,
"_r3_dtl_id": null,
"_r3_hdr_id": null,
"_r3_price": null,
"_r3_disc_percent_01": null,
"_r3_disc_percent_02": null,
"_r3_disc_percent_03": null,
"_r3_disc_percent_04": null,
"_r3_hdr_disc_percent_01": null,
"_r3_hdr_disc_percent_02": null,
"_r3_hdr_disc_percent_03": null,
"_r3_hdr_disc_percent_04": null,
"_r3_amt_bfr_tax": null,
"_r3_doc_date": null,
"_r3_doc_code": null,
"_r3_ref_code": null,
"_r3_uom": null,
"_r3_disc_percent": null,
"_r3_hdr_disc_percent": null,
"_r3_qty": null,
"_r3_tax": null,
"_r3_useryesno_01": null,
"_r3_link": null,
"_r3_batch_no": null
},
"return_price_history": {
"_1_dtl_id": null,
"_1_hdr_id": null,
"_1_price": null,
"_1_disc_percent_01": null,
"_1_disc_percent_02": null,
"_1_disc_percent_03": null,
"_1_disc_percent_04": null,
"_1_hdr_disc_percent_01": null,
"_1_hdr_disc_percent_02": null,
"_1_hdr_disc_percent_03": null,
"_1_hdr_disc_percent_04": null,
"_1_amt_bfr_tax": null,
"_1_doc_date": null,
"_1_doc_code": null,
"_1_ref_code": null,
"_1_uom": null,
"_1_disc_percent": null,
"_1_hdr_disc_percent": null,
"_1_qty": null,
"_1_tax": null,
"_1_useryesno_01": null,
"_1_salesman_code": null,
"_1_branch_name": null,
"_1_so_code": null,
"_1_link": null,
"_1_promo_code": null,
"_1_batch_no": null,
"_2_dtl_id": null,
"_2_hdr_id": null,
"_2_price": null,
"_2_disc_percent_01": null,
"_2_disc_percent_02": null,
"_2_disc_percent_03": null,
"_2_disc_percent_04": null,
"_2_hdr_disc_percent_01": null,
"_2_hdr_disc_percent_02": null,
"_2_hdr_disc_percent_03": null,
"_2_hdr_disc_percent_04": null,
"_2_amt_bfr_tax": null,
"_2_doc_date": null,
"_2_doc_code": null,
"_2_ref_code": null,
"_2_uom": null,
"_2_disc_percent": null,
"_2_hdr_disc_percent": null,
"_2_qty": null,
"_2_tax": null,
"_2_useryesno_01": null,
"_2_salesman_code": null,
"_2_branch_name": null,
"_2_so_code": null,
"_2_link": null,
"_2_promo_code": null,
"_2_batch_no": null,
"_3_dtl_id": null,
"_3_hdr_id": null,
"_3_price": null,
"_3_disc_percent_01": null,
"_3_disc_percent_02": null,
"_3_disc_percent_03": null,
"_3_disc_percent_04": null,
"_3_hdr_disc_percent_01": null,
"_3_hdr_disc_percent_02": null,
"_3_hdr_disc_percent_03": null,
"_3_hdr_disc_percent_04": null,
"_3_amt_bfr_tax": null,
"_3_doc_date": null,
"_3_doc_code": null,
"_3_ref_code": null,
"_3_uom": null,
"_3_disc_percent": null,
"_3_hdr_disc_percent": null,
"_3_qty": null,
"_3_tax": null,
"_3_useryesno_01": null,
"_3_salesman_code": null,
"_3_branch_name": null,
"_3_so_code": null,
"_3_link": null,
"_3_promo_code": null,
"_3_batch_no": null,
"_r1_dtl_id": "",
"_r1_hdr_id": "",
"_r1_price": "",
"_r1_disc_percent_01": "",
"_r1_disc_percent_02": "",
"_r1_disc_percent_03": "",
"_r1_disc_percent_04": "",
"_r1_hdr_disc_percent_01": "",
"_r1_hdr_disc_percent_02": "",
"_r1_hdr_disc_percent_03": "",
"_r1_hdr_disc_percent_04": "",
"_r1_amt_bfr_tax": null,
"_r1_doc_date": "",
"_r1_doc_code": "",
"_r1_ref_code": null,
"_r1_uom": "",
"_r1_disc_percent": "",
"_r1_hdr_disc_percent": "",
"_r1_qty": "",
"_r1_tax": "",
"_r1_useryesno_01": "",
"_r1_link": "",
"_r1_batch_no": "",
"_r2_dtl_id": "",
"_r2_hdr_id": "",
"_r2_price": "",
"_r2_disc_percent_01": "",
"_r2_disc_percent_02": "",
"_r2_disc_percent_03": "",
"_r2_disc_percent_04": "",
"_r2_hdr_disc_percent_01": "",
"_r2_hdr_disc_percent_02": "",
"_r2_hdr_disc_percent_03": "",
"_r2_hdr_disc_percent_04": "",
"_r2_amt_bfr_tax": null,
"_r2_doc_date": "",
"_r2_doc_code": "",
"_r2_ref_code": null,
"_r2_uom": "",
"_r2_disc_percent": "",
"_r2_hdr_disc_percent": "",
"_r2_qty": "",
"_r2_tax": "",
"_r2_useryesno_01": "",
"_r2_link": "",
"_r2_batch_no": "",
"_r3_dtl_id": "",
"_r3_hdr_id": "",
"_r3_price": "",
"_r3_disc_percent_01": "",
"_r3_disc_percent_02": "",
"_r3_disc_percent_03": "",
"_r3_disc_percent_04": "",
"_r3_hdr_disc_percent_01": "",
"_r3_hdr_disc_percent_02": "",
"_r3_hdr_disc_percent_03": "",
"_r3_hdr_disc_percent_04": "",
"_r3_amt_bfr_tax": null,
"_r3_doc_date": "",
"_r3_doc_code": "",
"_r3_ref_code": null,
"_r3_uom": "",
"_r3_disc_percent": "",
"_r3_hdr_disc_percent": "",
"_r3_qty": "",
"_r3_tax": "",
"_r3_useryesno_01": "",
"_r3_link": "",
"_r3_batch_no": ""
},
"shelf_dropdown": [
{
"label": "",
"value": "1"
}
],
"soDtlField": {
"id": "261",
"hdr_id": "19166",
"dtl_id": "176093",
"num_of_crate": "2.0000",
"crate_weight": "2.0000",
"total_crate_weight": "2.0000",
"gross_weight": "2.0000",
"num_of_bird": "2.0000",
"usermediumtext_01": null,
"usermediumtext_02": null,
"usermediumtext_03": null,
"usermediumtext_04": null,
"userlongtext_01": null,
"userlongtext_02": null,
"userlongtext_03": null,
"userlongtext_04": null,
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"userfield_05": "",
"userfield_06": "",
"userfield_07": "",
"userfield_08": "",
"userfield_09": "",
"userfield_10": "",
"usernumber_01": "1.0000",
"usernumber_02": "1.0000",
"usernumber_03": "3.0000",
"usernumber_04": "0.0000",
"usernumber_05": "0.0000",
"usernumber_06": "0.0000",
"usernumber_07": "0.0000",
"usernumber_08": "0.0000",
"usernumber_09": "0.0000",
"usernumber_10": "0.0000",
"useryesno_01": "0",
"useryesno_02": "0",
"useryesno_03": "0",
"useryesno_04": "0",
"useryesno_05": "0",
"useryesno_06": "0",
"useryesno_07": "0",
"useryesno_08": "0",
"useryesno_09": "0",
"useryesno_10": "0",
"userdate_01": "1970-01-01 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00",
"userdate_05": "1970-01-01 00:00:00",
"userdate_06": "1970-01-01 00:00:00",
"userdate_07": "1970-01-01 00:00:00",
"userdate_08": "1970-01-01 00:00:00",
"userdate_09": "1970-01-01 00:00:00",
"userdate_10": "1970-01-01 00:00:00",
"created": "2025-03-27 11:31:58",
"createdby": "1",
"updated": "2025-04-16 18:20:19",
"updatedby": "1"
},
"stock_rotation_dropdown": [
{
"label": "-",
"value": "1",
"color": "ffffff"
}
],
"settings": {
"salesPriceDisc": "1",
"salesDiscLevel": "4",
"salesDiscAmtByUOM": "0",
"soLockDtlDesc": "0",
"salesOrderHdrDelDate": "0",
"docCharLimit": "1",
"showDetailFields": "1"
}
},
"success": true
}
Note/Business Logic
- None
Permission
- None
Pricing
API Definition
| Field | Details |
|---|---|
| Endpoint | /api/sales-order-detail/calculate-amount |
| Method | POST |
| Authentication | Required |
Request
| Header | Value |
|---|---|
| Authorization | Value |
| Content-type | application/json |
Query Parameters:
- None
Request Body:
| Parameter | Type | Required | Description |
|---|---|---|---|
| data | array | Yes | multiple objects |
Example data JSON:
{
"data": {
"hdr_id": "19317",
"id": 0,
"line_no": 1,
"qty": "4.0000",
"price": "7.300000",
"list_price": "7.300000",
"item": {
"value": 8224,
"label": "QQ CAT (CHICKEN & TUNA) 900G x12 PACK",
"sublabel": "QQ CAT (CHICKEN & TUNA) 900G x12 PACK"
},
"uom": {
"value": 5,
"label": "PACK",
"rate": "1.000000"
},
"location": {
"value": 1,
"label": "D06"
},
"uom_rate": "1.000000",
"usernumber_03": "0.0000",
"order_amt": "29.2000",
"net_amt": "28.2000",
"disc_amt": "1.000000",
"price_disc": 1,
"usernumber_01": "1",
"disc_mode": 0,
"disc_percent_01": -1,
"disc_percent_02": 0,
"disc_percent_03": 0,
"disc_percent_04": 0
}
}
Response
Success (200):
{
"data": {
"hdr_id": "19317",
"item_id": 8224,
"location_id": 1,
"uom_id": 5,
"line_no": 1,
"qty": "4.0000",
"price": "7.300000",
"list_price": "7.3000",
"uom_rate": "1.000000",
"usernumber_03": "0.0000",
"order_amt": 29.2,
"net_amt": 28.2,
"disc_amt": 1,
"price_disc": 1,
"usernumber_01": "1",
"disc_mode": 0,
"disc_percent_01": -1,
"disc_percent_02": 0,
"disc_percent_03": 0,
"disc_percent_04": 0,
"useryesno_03": 0,
"remark": "",
"usernumber_02": 0,
"tax_amt": 0,
"tax_id_01": 0,
"tax_percent_01": 0,
"tax_id_02": 0,
"tax_percent_02": 0,
"tax_id_03": 0,
"tax_percent_03": 0,
"tax_id_04": 0,
"tax_percent_04": 0,
"order_local_amt": 29.2,
"disc_local_amt": 1,
"tax_local_amt": 0,
"net_local_amt": 28.2,
"available_qty": "4 PACK",
"header": {
"id": 19317,
"doc_code": "BOF000113",
"ref_code": "",
"doc_date": "2025-04-29 00:00:00",
"order_type": "w",
"company_id": 1,
"customer_id": 7635,
"salesman_id": 1,
"project_id": 1,
"division_id": 3,
"term_id": 3,
"term_code": "30DAYS",
"term_day": 30,
"branch_id": 0,
"branch_code": "",
"area_id": 95,
"area_code": "",
"del_address_01": "",
"del_address_02": "",
"del_address_03": "",
"del_address_04": "",
"del_attention": "",
"del_postcode": "",
"del_phone_01": "",
"del_phone_02": "",
"del_fax_01": "",
"del_fax_02": "",
"description": "Sales Order",
"currency_rate": "1.000000",
"currency_id": 1,
"disc_percent_01": "0.0000",
"disc_percent_02": "0.0000",
"disc_percent_03": "0.0000",
"disc_percent_04": "0.0000",
"disc_percent_05": "0.0000",
"disc_percent_06": "0.0000",
"disc_percent_07": "0.0000",
"disc_percent_08": "0.0000",
"disc_amt": "0.000000",
"disc_local_amt": "0.000000",
"tax_group_id": 0,
"tax_id_01": 0,
"tax_percent_01": "0.00",
"tax_id_02": 0,
"tax_percent_02": "0.00",
"tax_id_03": 0,
"tax_percent_03": "0.00",
"tax_id_04": 0,
"tax_percent_04": "0.00",
"tax_amt": "0.000000",
"tax_local_amt": "0.000000",
"order_amt": "173.200000",
"order_local_amt": "173.200000",
"net_amt": "173.200000",
"net_local_amt": "173.200000",
"remark_01": "Do not delete this",
"remark_02": "",
"is_printed": 0,
"is_exported": 0,
"status": 0,
"voided": "1970-01-01 00:00:00",
"voidedby": 0,
"void_reason_id": 0,
"void_remark": "",
"location_check_in_id": 0,
"lorry_num": "",
"k2_ref_no_01": "",
"k2_ref_no_02": "",
"k2_date": "2025-04-28 00:00:00",
"incoterms": "",
"created": "2025-04-29T15:27:59.000000Z",
"createdby": 1,
"updated": "2025-05-22T11:50:53.000000Z",
"updatedby": 1,
"userfield_01": "",
"userfield_02": "r",
"userfield_03": "",
"userfield_04": "",
"usernumber_01": "0.0000",
"usernumber_02": "0.0000",
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"useryesno_01": 0,
"useryesno_02": 0,
"useryesno_03": 0,
"useryesno_04": 0,
"userdate_01": "2025-04-29 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00"
},
"item": {
"id": 8224,
"code": "1 QCT",
"ref_code": "",
"description": "QQ CAT (CHICKEN & TUNA) 900G x12 PACK",
"type": "p",
"status": "a",
"item_group_id": 669,
"item_group_01_id": 1,
"item_group_02_id": 1,
"item_group_03_id": 0,
"uom_id": 5,
"purchase_uom_id": 5,
"sales_uom_id": 5,
"location_id": 1,
"shelf_id": 1,
"shelf_life": 0,
"is_sales_item": 1,
"is_purchase_item": 1,
"is_service_item": 0,
"is_stock_item": 1,
"is_serialno_item": 0,
"is_batch_item": 0,
"is_part_item": 0,
"is_divisible": 0,
"is_discount": 0,
"is_explode": 0,
"barcode": "",
"barcode_type": "",
"stock_currency_id": 1,
"stock_valuation_type": "STD",
"sales_tax_code": "1",
"purchase_tax_code": "11",
"gl_account_sales": "",
"gl_account_salesreturn": "",
"gl_account_cashsales": "",
"gl_account_purchase": "",
"gl_account_cashpurchase": "",
"gl_account_purchasereturn": "",
"min_odr_qty": "0.0000",
"qty_per_pack": "0.0000",
"packing_uom_id": 1,
"gross_weight": "0.0000",
"gross_weight_uom_id": 2,
"net_weight": "0.0000",
"net_weight_uom_id": 2,
"thickness": "0.0000",
"thickness_uom_id": "3",
"length": "0.0000",
"length_uom_id": 3,
"width": "0.0000",
"width_uom_id": 3,
"height": "0.0000",
"height_uom_id": 3,
"density": "0.0000",
"dimension": "",
"uptodate_cost": "0.0000",
"average_cost": "0.0000",
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"usernumber_01": "0.0000",
"usernumber_02": "0.0000",
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"useryesno_01": 0,
"useryesno_02": 0,
"useryesno_03": 0,
"useryesno_04": 0,
"useryesno_05": 0,
"useryesno_06": 0,
"useryesno_07": 0,
"useryesno_08": 0,
"description1": null,
"description2": "",
"longdescription1": "",
"longdescription2": "",
"percentage1": "0.0000",
"percentage2": "0.0000",
"picture": null,
"classification_code": "",
"amount": "0.000000",
"start_date": null,
"due_date": null,
"item_claim": 0,
"created": "2022-06-15 12:03:05",
"createdby": 1,
"updated": "2022-06-15 12:03:05",
"updatedby": 1
}
},
"success": true
}
Note/Business Logic
- None
Permission
- None
Update
API Definition
| Field | Details |
|---|---|
| Endpoint | /api/update-detail |
| Method | POST |
| Authentication | Required |
Request
| Header | Value |
|---|---|
| Authorization | Value |
| Content-type | application/json |
Query Parameters:
- None
Request Body:
| Parameter | Type | Required | Description |
|---|---|---|---|
| id | integer | yes | The ID of the detail |
| division_id | integer | yes | The ID of the division |
| customer_id | integer | yes | The ID of the customer |
| currency_rate | integer | yes | Currency rate |
| doc_date | string | yes | Document date |
| hdr_id | integer | yes | Document header ID |
| line_no | integer | yes | Line No |
| item | object | yes | Object of the item |
| location | object | yes | Object of location |
| shelf | object | yes | Object of shelf |
| stock_rotation | object | no | Object of stock rotation |
| batch_no | integer | no | Inventory No |
| serial_no | string | no | Batch Serial Number |
| expiry_date | string | yes | Expiry date |
| userdate_01 | string | yes | Additional user date |
| inventory | object | no | Object of inventory |
| qty | integer | yes | Quantity of the Item |
| uom | object | yes | Unit of Measurement for selected item |
| list_price | integer | yes | Listing price of the selected item |
| price_disc | integer | no | Price discount based on raw amount |
| order_amt | integer | yes | Total order amount |
| order_local_amt | integer | yes | Total order amount rounded |
| disc_mode | integer | yes | Discount mode. Can be either 0 = percentage or 1 = amount mode. |
| usernumber_01 | string | yes | Additional column |
| disc_percent_01 | integer | no | If discount mode = 0, this must has value. Else, it must be -1 |
| disc_percent_02 | integer | no | Percentage discount 02 |
| disc_percent_03 | integer | no | Percentage discount 03 |
| disc_percent_04 | integer | no | Percentage discount 04 |
| disc_amt | integer | no | Discount amount using mode = 1 = amount |
| tax_group_id | integer | no | Tax group selection |
| tax_percent_01 | integer | no | Tax amount in percentage amount |
| tax_amt | integer | no | Tax amount in raw amount |
| tax_local_amt | integer | no | Rounded tax amount |
| net_amt | integer | yes | Net amount |
| net_local_amt | integer | yes | Rounded net amount |
| remark1 | integer | no | Remark 01 |
| remark2 | integer | no | Remark 02 |
| remark3 | integer | no | Remark 03 |
| remark4 | integer | no | Remark 04 |
Example Request Body JSON:
{
"id": "175882",
"division_id": "3",
"customer_id": "5126",
"currency_rate": "1.000000",
"doc_date": "2024-12-09 00:00:00",
"hdr_id": "19067",
"line_no": "1",
"item": {
"value": 8189,
"sublabel": "CAT LITTER BOX 002 SIZE:50.5x38x23(L)"
},
"location": {
"value": 1
},
"shelf": {
"value": 1
},
"stock_rotation": {
"value": 1
},
"batch_no": "",
"serial_no": "",
"expiry_date": "1970-01-01 00:00:00",
"userdate_01": "1970-01-01 00:00:00",
"inventory": {
"value": ""
},
"qty": "3.0000",
"uom": {
"value": "1",
"rate": "1.000000"
},
"list_price": "82.800000",
"price_disc": "0",
"order_amt": "248.400000",
"order_local_amt": "248.400000",
"disc_mode": "1",
"usernumber_01": "7.4500",
"disc_percent_01": "-1.0000",
"disc_percent_02": "0.0000",
"disc_percent_03": "0.0000",
"disc_percent_04": "0.0000",
"disc_amt": "7.450000",
"tax_group_id": "",
"tax_percent_01": "0.00",
"tax_amt": "0.000000",
"tax_local_amt": "0.000000",
"net_amt": "240.950000",
"net_local_amt": "240.950000",
"remark1": "",
"remark2": "",
"remark3": "",
"remark4": ""
}
Response
Success (200):
{
"data": {
"location_dropdown": {
"1": "D06",
"2": "XMAIN",
"51": "DW01-GOOD"
},
"shelf_dropdown": {
"1": ""
},
"stock_rotation_dropdown": {
"1": ["-", "ffffff"]
},
"doc_date": "2024-12-09 00:00:00",
"currency_rate": "1.000000",
"customer_id": "5126",
"division_id": "3",
"batch_dropdown": [],
"uom_dropdown": {
"1": "UNIT"
},
"model": {
"id": "175882",
"hdr_id": "19067",
"line_no": "1",
"item_id": "8189",
"location_id": 1,
"uom_id": "1",
"uom_rate": "1.0000",
"price": 82.8,
"list_price": "82.800000",
"description": "CAT LITTER BOX 002 SIZE:50.5x38x23(L)",
"shelf_id": 1,
"batch_no": "",
"serial_no": "",
"stock_rotation_id": 1,
"promotion_hdr_id": 0,
"expiry_date": "1970-01-01 00:00:00",
"del_date": "2024-12-09 00:00:00",
"qty": "3.0000",
"sent_qty": "0.0000",
"disc_percent_01": -1,
"disc_percent_02": "0.0000",
"disc_percent_03": "0.0000",
"disc_percent_04": "0.0000",
"disc_percent_05": "0.0000",
"disc_percent_06": "0.0000",
"disc_percent_07": "0.0000",
"disc_percent_08": "0.0000",
"disc_amt": 7.45,
"disc_local_amt": 7.45,
"tax_group_id": 0,
"tax_id_01": 0,
"tax_percent_01": 0,
"tax_id_02": 0,
"tax_percent_02": 0,
"tax_id_03": 0,
"tax_percent_03": 0,
"tax_id_04": 0,
"tax_percent_04": 0,
"tax_amt": 0,
"tax_local_amt": 0,
"order_amt": 248.4,
"order_local_amt": 248.4,
"net_amt": 240.95,
"net_local_amt": 240.95,
"remark": "",
"is_closed": "0",
"foc_flag": "0",
"promo_uuid": "",
"promo_qty": "0.0000",
"created": "2024-12-09 18:09:13",
"createdby": "1",
"updated": "2025-03-19 13:56:38",
"updatedby": "1",
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"usernumber_01": "7.4500",
"usernumber_02": 0,
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"useryesno_01": "0",
"useryesno_02": "0",
"useryesno_03": 0,
"useryesno_04": "0",
"userdate_01": "1970-01-01 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00"
},
"inventory": {
"id": "7389",
"item_id": "8189",
"location_id": "1",
"shelf_id": "1",
"serial_no": "",
"batch_no": "",
"stock_rotation_id": "1",
"expiry_date": "1970-01-01 00:00:00",
"ob_qty": "0.0000",
"ob_currency_id": "1",
"ob_cost": "0.0000",
"balance_qty": "42.0000",
"reserved_qty": "0.0000",
"company_id": "1",
"created": "2024-07-19 15:35:10",
"createdby": "1",
"updated": "2025-03-19 10:01:39",
"updatedby": "1",
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"usernumber_01": "0.0000",
"usernumber_02": "0.0000",
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"useryesno_01": "0",
"useryesno_02": "0",
"useryesno_03": "0",
"useryesno_04": "0",
"userdate_01": "1970-01-01 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00"
},
"sales_odr_dtl": {
"modelClass": "SalesOdrDtl",
"model": {
"id": null,
"hdr_id": null,
"line_no": null,
"item_id": null,
"location_id": null,
"uom_id": null,
"uom_rate": null,
"price": null,
"list_price": null,
"description": null,
"shelf_id": null,
"batch_no": null,
"serial_no": null,
"stock_rotation_id": null,
"promotion_hdr_id": null,
"expiry_date": null,
"del_date": null,
"qty": null,
"sent_qty": null,
"disc_percent_01": null,
"disc_percent_02": null,
"disc_percent_03": null,
"disc_percent_04": null,
"disc_percent_05": null,
"disc_percent_06": null,
"disc_percent_07": null,
"disc_percent_08": null,
"disc_amt": null,
"disc_local_amt": null,
"tax_group_id": null,
"tax_id_01": null,
"tax_percent_01": null,
"tax_id_02": null,
"tax_percent_02": null,
"tax_id_03": null,
"tax_percent_03": null,
"tax_id_04": null,
"tax_percent_04": null,
"tax_amt": null,
"tax_local_amt": null,
"order_amt": null,
"order_local_amt": null,
"net_amt": null,
"net_local_amt": null,
"remark": null,
"is_closed": null,
"foc_flag": null,
"promo_uuid": null,
"promo_qty": null,
"created": null,
"createdby": null,
"updated": null,
"updatedby": null,
"userfield_01": null,
"userfield_02": null,
"userfield_03": null,
"userfield_04": null,
"usernumber_01": null,
"usernumber_02": null,
"usernumber_03": null,
"usernumber_04": null,
"useryesno_01": null,
"useryesno_02": null,
"useryesno_03": null,
"useryesno_04": null,
"userdate_01": null,
"userdate_02": null,
"userdate_03": null,
"userdate_04": null
},
"keyAttribute": null
},
"price_history": {
"_1_dtl_id": "188269",
"_1_hdr_id": "21497",
"_1_price": "82.8000",
"_1_disc_percent_01": "7.4500",
"_1_disc_percent_02": "0.0000",
"_1_disc_percent_03": "0.0000",
"_1_disc_percent_04": "0.0000",
"_1_hdr_disc_percent_01": "0.0000",
"_1_hdr_disc_percent_02": "0.0000",
"_1_hdr_disc_percent_03": "0.0000",
"_1_hdr_disc_percent_04": "0.0000",
"_1_amt_bfr_tax": "240.95",
"_1_doc_date": "2024-11-21",
"_1_doc_code": "IN0300036",
"_1_ref_code": null,
"_1_uom": "UNIT",
"_1_disc_percent": "($)7.45",
"_1_hdr_disc_percent": "",
"_1_qty": 3,
"_1_tax": "",
"_1_useryesno_01": "R",
"_1_salesman_code": "admin",
"_1_branch_name": "",
"_1_so_code": null,
"_1_link": "/eficoreapi/?r=doInvHdr/viewInvoice&id=21497",
"_1_promo_code": "",
"_1_batch_no": "",
"_2_dtl_id": "",
"_2_hdr_id": "",
"_2_price": "",
"_2_disc_percent_01": "",
"_2_disc_percent_02": "",
"_2_disc_percent_03": "",
"_2_disc_percent_04": "",
"_2_hdr_disc_percent_01": "",
"_2_hdr_disc_percent_02": "",
"_2_hdr_disc_percent_03": "",
"_2_hdr_disc_percent_04": "",
"_2_amt_bfr_tax": "",
"_2_doc_date": "",
"_2_doc_code": "",
"_2_ref_code": null,
"_2_uom": "",
"_2_disc_percent": "",
"_2_hdr_disc_percent": "",
"_2_qty": "",
"_2_tax": "",
"_2_useryesno_01": "",
"_2_salesman_code": "",
"_2_branch_name": "",
"_2_so_code": "",
"_2_link": "",
"_2_promo_code": "",
"_2_batch_no": "",
"_3_dtl_id": "",
"_3_hdr_id": "",
"_3_price": "",
"_3_disc_percent_01": "",
"_3_disc_percent_02": "",
"_3_disc_percent_03": "",
"_3_disc_percent_04": "",
"_3_hdr_disc_percent_01": "",
"_3_hdr_disc_percent_02": "",
"_3_hdr_disc_percent_03": "",
"_3_hdr_disc_percent_04": "",
"_3_amt_bfr_tax": "",
"_3_doc_date": "",
"_3_doc_code": "",
"_3_ref_code": null,
"_3_uom": "",
"_3_disc_percent": "",
"_3_hdr_disc_percent": "",
"_3_qty": "",
"_3_tax": "",
"_3_useryesno_01": "",
"_3_salesman_code": "",
"_3_branch_name": "",
"_3_so_code": "",
"_3_link": "",
"_3_promo_code": "",
"_3_batch_no": "",
"_r1_dtl_id": null,
"_r1_hdr_id": null,
"_r1_price": null,
"_r1_disc_percent_01": null,
"_r1_disc_percent_02": null,
"_r1_disc_percent_03": null,
"_r1_disc_percent_04": null,
"_r1_hdr_disc_percent_01": null,
"_r1_hdr_disc_percent_02": null,
"_r1_hdr_disc_percent_03": null,
"_r1_hdr_disc_percent_04": null,
"_r1_amt_bfr_tax": null,
"_r1_doc_date": null,
"_r1_doc_code": null,
"_r1_ref_code": null,
"_r1_uom": null,
"_r1_disc_percent": null,
"_r1_hdr_disc_percent": null,
"_r1_qty": null,
"_r1_tax": null,
"_r1_useryesno_01": null,
"_r1_link": null,
"_r1_batch_no": null,
"_r2_dtl_id": null,
"_r2_hdr_id": null,
"_r2_price": null,
"_r2_disc_percent_01": null,
"_r2_disc_percent_02": null,
"_r2_disc_percent_03": null,
"_r2_disc_percent_04": null,
"_r2_hdr_disc_percent_01": null,
"_r2_hdr_disc_percent_02": null,
"_r2_hdr_disc_percent_03": null,
"_r2_hdr_disc_percent_04": null,
"_r2_amt_bfr_tax": null,
"_r2_doc_date": null,
"_r2_doc_code": null,
"_r2_ref_code": null,
"_r2_uom": null,
"_r2_disc_percent": null,
"_r2_hdr_disc_percent": null,
"_r2_qty": null,
"_r2_tax": null,
"_r2_useryesno_01": null,
"_r2_link": null,
"_r2_batch_no": null,
"_r3_dtl_id": null,
"_r3_hdr_id": null,
"_r3_price": null,
"_r3_disc_percent_01": null,
"_r3_disc_percent_02": null,
"_r3_disc_percent_03": null,
"_r3_disc_percent_04": null,
"_r3_hdr_disc_percent_01": null,
"_r3_hdr_disc_percent_02": null,
"_r3_hdr_disc_percent_03": null,
"_r3_hdr_disc_percent_04": null,
"_r3_amt_bfr_tax": null,
"_r3_doc_date": null,
"_r3_doc_code": null,
"_r3_ref_code": null,
"_r3_uom": null,
"_r3_disc_percent": null,
"_r3_hdr_disc_percent": null,
"_r3_qty": null,
"_r3_tax": null,
"_r3_useryesno_01": null,
"_r3_link": null,
"_r3_batch_no": null
},
"return_price_history": {
"_1_dtl_id": null,
"_1_hdr_id": null,
"_1_price": null,
"_1_disc_percent_01": null,
"_1_disc_percent_02": null,
"_1_disc_percent_03": null,
"_1_disc_percent_04": null,
"_1_hdr_disc_percent_01": null,
"_1_hdr_disc_percent_02": null,
"_1_hdr_disc_percent_03": null,
"_1_hdr_disc_percent_04": null,
"_1_amt_bfr_tax": null,
"_1_doc_date": null,
"_1_doc_code": null,
"_1_ref_code": null,
"_1_uom": null,
"_1_disc_percent": null,
"_1_hdr_disc_percent": null,
"_1_qty": null,
"_1_tax": null,
"_1_useryesno_01": null,
"_1_salesman_code": null,
"_1_branch_name": null,
"_1_so_code": null,
"_1_link": null,
"_1_promo_code": null,
"_1_batch_no": null,
"_2_dtl_id": null,
"_2_hdr_id": null,
"_2_price": null,
"_2_disc_percent_01": null,
"_2_disc_percent_02": null,
"_2_disc_percent_03": null,
"_2_disc_percent_04": null,
"_2_hdr_disc_percent_01": null,
"_2_hdr_disc_percent_02": null,
"_2_hdr_disc_percent_03": null,
"_2_hdr_disc_percent_04": null,
"_2_amt_bfr_tax": null,
"_2_doc_date": null,
"_2_doc_code": null,
"_2_ref_code": null,
"_2_uom": null,
"_2_disc_percent": null,
"_2_hdr_disc_percent": null,
"_2_qty": null,
"_2_tax": null,
"_2_useryesno_01": null,
"_2_salesman_code": null,
"_2_branch_name": null,
"_2_so_code": null,
"_2_link": null,
"_2_promo_code": null,
"_2_batch_no": null,
"_3_dtl_id": null,
"_3_hdr_id": null,
"_3_price": null,
"_3_disc_percent_01": null,
"_3_disc_percent_02": null,
"_3_disc_percent_03": null,
"_3_disc_percent_04": null,
"_3_hdr_disc_percent_01": null,
"_3_hdr_disc_percent_02": null,
"_3_hdr_disc_percent_03": null,
"_3_hdr_disc_percent_04": null,
"_3_amt_bfr_tax": null,
"_3_doc_date": null,
"_3_doc_code": null,
"_3_ref_code": null,
"_3_uom": null,
"_3_disc_percent": null,
"_3_hdr_disc_percent": null,
"_3_qty": null,
"_3_tax": null,
"_3_useryesno_01": null,
"_3_salesman_code": null,
"_3_branch_name": null,
"_3_so_code": null,
"_3_link": null,
"_3_promo_code": null,
"_3_batch_no": null,
"_r1_dtl_id": "",
"_r1_hdr_id": "",
"_r1_price": "",
"_r1_disc_percent_01": "",
"_r1_disc_percent_02": "",
"_r1_disc_percent_03": "",
"_r1_disc_percent_04": "",
"_r1_hdr_disc_percent_01": "",
"_r1_hdr_disc_percent_02": "",
"_r1_hdr_disc_percent_03": "",
"_r1_hdr_disc_percent_04": "",
"_r1_amt_bfr_tax": null,
"_r1_doc_date": "",
"_r1_doc_code": "",
"_r1_ref_code": null,
"_r1_uom": "",
"_r1_disc_percent": "",
"_r1_hdr_disc_percent": "",
"_r1_qty": "",
"_r1_tax": "",
"_r1_useryesno_01": "",
"_r1_link": "",
"_r1_batch_no": "",
"_r2_dtl_id": "",
"_r2_hdr_id": "",
"_r2_price": "",
"_r2_disc_percent_01": "",
"_r2_disc_percent_02": "",
"_r2_disc_percent_03": "",
"_r2_disc_percent_04": "",
"_r2_hdr_disc_percent_01": "",
"_r2_hdr_disc_percent_02": "",
"_r2_hdr_disc_percent_03": "",
"_r2_hdr_disc_percent_04": "",
"_r2_amt_bfr_tax": null,
"_r2_doc_date": "",
"_r2_doc_code": "",
"_r2_ref_code": null,
"_r2_uom": "",
"_r2_disc_percent": "",
"_r2_hdr_disc_percent": "",
"_r2_qty": "",
"_r2_tax": "",
"_r2_useryesno_01": "",
"_r2_link": "",
"_r2_batch_no": "",
"_r3_dtl_id": "",
"_r3_hdr_id": "",
"_r3_price": "",
"_r3_disc_percent_01": "",
"_r3_disc_percent_02": "",
"_r3_disc_percent_03": "",
"_r3_disc_percent_04": "",
"_r3_hdr_disc_percent_01": "",
"_r3_hdr_disc_percent_02": "",
"_r3_hdr_disc_percent_03": "",
"_r3_hdr_disc_percent_04": "",
"_r3_amt_bfr_tax": null,
"_r3_doc_date": "",
"_r3_doc_code": "",
"_r3_ref_code": null,
"_r3_uom": "",
"_r3_disc_percent": "",
"_r3_hdr_disc_percent": "",
"_r3_qty": "",
"_r3_tax": "",
"_r3_useryesno_01": "",
"_r3_link": "",
"_r3_batch_no": ""
},
"so_dtl_field": {
"id": "249",
"hdr_id": "19067",
"dtl_id": "175882",
"num_of_crate": "0.0000",
"crate_weight": "0.0000",
"total_crate_weight": "0.0000",
"gross_weight": "0.0000",
"num_of_bird": "0.0000",
"usermediumtext_01": null,
"usermediumtext_02": null,
"usermediumtext_03": null,
"usermediumtext_04": null,
"userlongtext_01": null,
"userlongtext_02": null,
"userlongtext_03": null,
"userlongtext_04": null,
"userfield_01": "",
"userfield_02": "",
"userfield_03": "",
"userfield_04": "",
"userfield_05": "",
"userfield_06": "",
"userfield_07": "",
"userfield_08": "",
"userfield_09": "",
"userfield_10": "",
"usernumber_01": "7.4500",
"usernumber_02": "0.0000",
"usernumber_03": "0.0000",
"usernumber_04": "0.0000",
"usernumber_05": "0.0000",
"usernumber_06": "0.0000",
"usernumber_07": "0.0000",
"usernumber_08": "0.0000",
"usernumber_09": "0.0000",
"usernumber_10": "0.0000",
"useryesno_01": "0",
"useryesno_02": "0",
"useryesno_03": "0",
"useryesno_04": "0",
"useryesno_05": "0",
"useryesno_06": "0",
"useryesno_07": "0",
"useryesno_08": "0",
"useryesno_09": "0",
"useryesno_10": "0",
"userdate_01": "1970-01-01 00:00:00",
"userdate_02": "1970-01-01 00:00:00",
"userdate_03": "1970-01-01 00:00:00",
"userdate_04": "1970-01-01 00:00:00",
"userdate_05": "1970-01-01 00:00:00",
"userdate_06": "1970-01-01 00:00:00",
"userdate_07": "1970-01-01 00:00:00",
"userdate_08": "1970-01-01 00:00:00",
"userdate_09": "1970-01-01 00:00:00",
"userdate_10": "1970-01-01 00:00:00",
"created": "2025-03-19 10:04:33",
"createdby": "1",
"updated": "2025-03-19 13:56:38",
"updatedby": "1"
},
"settings": {
"salesPriceDisc": "1",
"salesDiscLevel": "4",
"salesDiscAmtByUOM": "0",
"soLockDtlDesc": "0",
"salesOrderHdrDelDate": "0",
"docCharLimit": "1",
"showDetailFields": "1"
}
},
"success": true
}
Note/Business Logic
- None
Permission
- None
Delete
API Definition
| Field | Details |
|---|---|
| Endpoint | /api/delete |
| Method | POST |
| Authentication | Required |
Request
| Header | Value |
|---|---|
| Authorization | Value |
| Content-type | application/json |
Query Parameters:
- None
Request Body:
| Parameter | Type | Required | Description |
|---|---|---|---|
| id | array | yes | array of integer for The ID of the detail |
| hdr_id | integer | yes | The ID of the Document header |
Example Request Body JSON:
{
"id": [176063],
"hdr_id": 19067
}
Response
Success (200):
{
"data": {
"success": true,
"status": 200,
"message": "Successfully deleted"
},
"success": true
}
Note/Business Logic
- None
Permission
- None