{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 3975, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"62\": \"MUFASA\", \"63\": \"Jk\", \"64\": 25, \"65\": \"\", \"66\": \"\", \"67\": \"\", \"68\": \"\", \"69\": \"\", \"70\": \"\", \"71\": \"\", \"72\": 36, \"73\": \"\", \"568\": \"\", \"600\": \"25\", \"617\": 1}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305", "ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "44", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "3975", "ctd_createdat": 1747739991, "ctd_updatedat": 1755241038, "ctd_createdby": 0, "ctd_updatedby": 1 }, { "ctd_id": 4151, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\":1,\"62\":\"NAMB0002\",\"63\":\"\",\"64\":\"\",\"600\":25}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330", "ctd_enabledproductonline": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "25", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4151", "ctd_createdat": 1752156444, "ctd_updatedat": 1755241551, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4148, "cci_customerid": 3975, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"82\":\"\",\"77\":\"Mk'\",\"79\":\"Mk'\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":12,\"62\":\"\",\"83\":1}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4148", "cci_createdat": 1747739991, "cci_updatedat": 1750662210, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4340, "cci_customerid": 4151, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"75\":12,\"76\":\"7299089943\",\"77\":\"Kalai\",\"78\":\"9943089943\",\"79\":\"Nambi\",\"81\":\"0\",\"82\":\"\",\"83\":1}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"86\":\"\",\"87\":\"\",\"88\":\"\",\"89\":\"\",\"90\":36,\"91\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4340", "cci_createdat": 1752156444, "cci_updatedat": 1755241551, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 10762, "app_description": "", "app_summary": "Measurer", "app_private": 1, "app_appointmentType": 62, "app_userId": 7, "app_orderId": 0, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 798, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": 0, "app_jobtimehour": "0", "app_jobtimeminute": "30", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": null, "id": "10762", "app_sdate": 1754956800, "app_edate": 1754956800, "app_stime": 1755232200, "app_etime": 1755234000, "app_sdatetime": 1754973000, "app_edatetime": 1754974800, "app_until": null, "app_createdAt": 1755241164, "app_updatedAt": 1755241164, "app_createdBy": 8, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 6397, "jd_customerid": 4151, "jd_contactid": 4340, "jd_additionalcontacts": "4340", "jd_templateid": 1, "jd_jobmultiquoteid": 6445, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ6360", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 5, "jd_accref": "NAMB0002", "jd_invoiceno": "", "jd_listprice": "61.88", "jd_netprice": "61.88", "jd_vat": "6.19", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 5, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "68.07", "jd_grossprofit": "1.33", "jd_costprice": "60.55", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "58.07", "jd_totpaid": "10.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 38, "jd_updatedby": 38, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":38,\"44\":\"\",\"45\":\"Kalai\",\"46\":\"Nambi\",\"47\":\"9943089943\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"7299089943\",\"287\":\"123\",\"288\":\"\",\"289\":\"\",\"551\":\"\",\"558\":\"0\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"16\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "6397", "jd_createddate": 1755216000, "jd_orderdate": 1755216000, "jd_duedate": 1764288000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1755240950, "jd_updatedat": 1755241096 }, { "jd_id": 6398, "jd_customerid": 3975, "jd_contactid": 4148, "jd_additionalcontacts": "4148", "jd_templateid": 1, "jd_jobmultiquoteid": 6446, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ6361", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 5, "jd_accref": "MUFASA", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "0.00", "jd_vat": "0.00", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 0, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "0.00", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "0.00", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 27, "jd_updatedby": null, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"62\":[\"\",\"MUFASA\"],\"83\":1,\"65\":\"\",\"66\":\"\",\"67\":\"\",\"68\":\"\",\"69\":\"\",\"70\":\"\",\"71\":\"\",\"72\":36,\"73\":\"\",\"568\":\"\",\"617\":1,\"287\":\"\",\"288\":\"\",\"37\":1,\"285\":12,\"33\":\"25\",\"45\":\"Mk'\",\"44\":\"Jk\",\"46\":\"Mk'\",\"39\":25,\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"54\":36,\"53\":\"\",\"286\":\"\",\"47\":\"\",\"558\":\"\",\"48\":\"\",\"41\":\"27\",\"551\":\"27\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "6398", "jd_createddate": 1755216000, "jd_orderdate": 1755216000, "jd_duedate": 1755216000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1755241038, "jd_updatedat": 1755241038 } ], "updated": [ { "jd_id": 6387, "jd_customerid": 4151, "jd_contactid": 4340, "jd_additionalcontacts": "4340", "jd_templateid": 1, "jd_jobmultiquoteid": 6435, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ6350", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 5, "jd_accref": "NAMB0002", "jd_invoiceno": "Invoice9820", "jd_listprice": "961.88", "jd_netprice": "961.88", "jd_vat": "96.19", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 5, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "1058.07", "jd_grossprofit": "451.33", "jd_costprice": "510.55", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1052.07", "jd_totpaid": "6.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": "", "jd_endcustomeroverridenetprice": "961.88", "jd_endcustomeroverridevatprice": "96.19", "jd_endcustomeroverridegrossprice": "1058.07", "jd_endcustomerdeliverycost": "", "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": "", "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 1, "jd_updatedby": 34, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":1,\"44\":\"\",\"45\":\"Kalai\",\"46\":\"Nambi\",\"47\":\"9943089943\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"7299089943\",\"287\":\"32\",\"288\":\"\",\"289\":\"\",\"551\":\"\",\"558\":\"0\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"32\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "6387", "jd_createddate": 1755129600, "jd_orderdate": 1755043200, "jd_duedate": 1755129600, "jd_sceduleddate": null, "jd_invoicedate": 1755216000, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1755170409, "jd_updatedat": 1755241472 }, { "jd_id": 6394, "jd_customerid": 4151, "jd_contactid": 4340, "jd_additionalcontacts": "4340", "jd_templateid": 1, "jd_jobmultiquoteid": 6442, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ6357", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 5, "jd_accref": "NAMB0002", "jd_invoiceno": "", "jd_listprice": "61.88", "jd_netprice": "61.88", "jd_vat": "6.19", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 5, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "68.07", "jd_grossprofit": "1.33", "jd_costprice": "60.55", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "48.07", "jd_totpaid": "20.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": 0, "jd_seq": 0, "jd_status": 0, "jd_createdby": 38, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ6357\",\"35\":\"NAMB0002\",\"36\":4,\"37\":1,\"38\":\"\",\"39\":\"\",\"40\":5,\"41\":38,\"44\":\"\",\"45\":\"Kalai\",\"46\":\"Nambi\",\"47\":\"9943089943\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"7299089943\",\"287\":\"32\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"0\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"123\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "6394", "jd_createddate": 1755216000, "jd_orderdate": 1755129600, "jd_duedate": 1764288000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1755181658, "jd_updatedat": 1755241551 }, { "jd_id": 6397, "jd_customerid": 4151, "jd_contactid": 4340, "jd_additionalcontacts": "4340", "jd_templateid": 1, "jd_jobmultiquoteid": 6445, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ6360", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 5, "jd_accref": "NAMB0002", "jd_invoiceno": "", "jd_listprice": "61.88", "jd_netprice": "61.88", "jd_vat": "6.19", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 5, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "68.07", "jd_grossprofit": "1.33", "jd_costprice": "60.55", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "58.07", "jd_totpaid": "10.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 0, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 38, "jd_updatedby": 38, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "10.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":38,\"44\":\"\",\"45\":\"Kalai\",\"46\":\"Nambi\",\"47\":\"9943089943\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"7299089943\",\"287\":\"123\",\"288\":\"\",\"289\":\"\",\"551\":\"\",\"558\":\"0\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"618\":\"16\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "10.000", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "jd_organizationid": 25, "id": "6397", "jd_createddate": 1755216000, "jd_orderdate": 1755216000, "jd_duedate": 1764288000, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1755240950, "jd_updatedat": 1755241096 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 33472, "oi_jobid": 6397, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6445, "oi_productid": 15, "oi_recipeid": 407, "oi_ruleid": 40, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":7231,\"labelname\":\"Location\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Location\",\"fieldid\":7231,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6893,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":6893,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":4438,\"labelname\":\"Supplier\",\"value\":\"13\",\"valueid\":null,\"type\":17,\"optionid\":\"13\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"SupplierDUK\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":4438,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"13\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":7242,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantityiudfh\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":7242,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4439,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width001\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":4439,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4440,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop002\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":4440,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4661,\"labelname\":\"Installation height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Installation heightIHG\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Installation height\",\"fieldid\":4661,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4442,\"labelname\":\"Measure to\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Measure toMT\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Measure to\",\"fieldid\":4442,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4444,\"labelname\":\"Fabric choice\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric choice\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric choice\",\"fieldid\":4444,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4446,\"labelname\":\"Control side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control sideCS\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control side\",\"fieldid\":4446,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4447,\"labelname\":\"Blind Lining\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind LiningRL\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind Lining\",\"fieldid\":4447,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4448,\"labelname\":\"Valance pelmet\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Valance pelmetVP\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Valance pelmet\",\"fieldid\":4448,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4449,\"labelname\":\"Operation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"OperationOP\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Operation\",\"fieldid\":4449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4468,\"labelname\":\"Product Type\",\"value\":\"378\",\"valueid\":\"456\",\"type\":13,\"optionid\":\"378\",\"optionvalue\":[{\"id\":456,\"fieldid\":4468,\"fieldoptionlinkid\":456,\"optionid\":378,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 1\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":4468,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"378\",\"optionsvalue\":[{\"id\":456,\"fieldid\":4468,\"fieldoptionlinkid\":456,\"optionid\":378,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 1\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":4652,\"labelname\":\"Headrail\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail\",\"fieldid\":4652,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4663,\"labelname\":\"Workroom instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom instructionsWIM\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Workroom instructions\",\"fieldid\":4663,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4664,\"labelname\":\"Fitters instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitters instructionsFII\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Fitters instructions\",\"fieldid\":4664,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4665,\"labelname\":\"Special instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special instructionsSIC\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special instructions\",\"fieldid\":4665,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17761,\"labelname\":\"ZN\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"ZN\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"ZN\",\"fieldid\":17761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Drapes UK, Width: 1000, Drop: 1000, Product Type: Price band 1", "oi_reportdescription": "##Supplier: Drapes UK##,##Quantity: 1##,##Width: 1000 mm##,##Drop: 1000 mm##,##Product Type: Price band 1##", "oi_reporttitles": "##Supplier:<\/br>##Quantity:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"sellingprice\":\"61.88\",\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"60.55\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "60.550", "oi_netprice": "61.880", "oi_pricesfromoperations": null, "oi_vatprice": "6.190", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "68.070", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 33471, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "61.880", "oi_endcustomeroverridevatprice": "6.190", "oi_endcustomeroverridegrossprice": "68.070", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7231, 6893, 4438, 7242, 4439, 4440, 4661, 4442, 4444, 4446, 4447, 4448, 4449, 4468, 4652, 4663, 4664, 4665, 17761]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33472", "oi_productiondate": 1764288000, "oi_createdat": 1755260738, "oi_updatedat": 1755240955, "oi_createdby": 38, "oi_updatedby": 38 }, { "oi_id": 33473, "oi_jobid": 6394, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6442, "oi_productid": 407, "oi_recipeid": 422, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":18849,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":18848,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":18850,\"labelname\":\"Supplier\",\"value\":3,\"valueid\":\"\",\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":18854,\"labelname\":\"Width\",\"value\":\"30\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"7_Inches_4_0.21875\",\"widthfractiontext\":\"7\/32\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":18855,\"labelname\":\"Drop\",\"value\":\"24\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"5_Inches_4_0.15625\",\"dropfractiontext\":\"5\/32\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":18851,\"labelname\":\"Product Type\",\"value\":509,\"valueid\":\"1177\",\"type\":13,\"optionid\":\"509\",\"optionvalue\":[{\"id\":1177,\"fieldid\":18851,\"fieldoptionlinkid\":1177,\"optionid\":509,\"mainsupplier\":3,\"blindtypecode\":\"\",\"optionname\":\"Price table 001\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":18852,\"labelname\":\"Fabric\",\"value\":\"\",\"valueid\":\"\",\"type\":22,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":18856,\"labelname\":\"Lining\",\"value\":\"\",\"valueid\":\"\",\"type\":2,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":18857,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Width: 30 7\/32, Drop: 24 5\/32", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 30 7\/32 Inches##,##Drop: 24 5\/32 Inches##", "oi_reporttitles": "##Quantity:##Supplier:##Width:##Drop:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[18849, 18848, 18850, 18854, 18855, 18851, 18852, 18856, 18857]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33473", "oi_productiondate": 1755240974, "oi_createdat": 1755240977, "oi_updatedat": null, "oi_createdby": 1, "oi_updatedby": 1 }, { "oi_id": 33474, "oi_jobid": 6394, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6442, "oi_productid": 317, "oi_recipeid": 328, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 3, "oi_customseq": 3, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":14174,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":14173,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":14175,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19018,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": null, "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[14174, 14173, 14175, 19018]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33474", "oi_productiondate": 1755241103, "oi_createdat": 1755241106, "oi_updatedat": null, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 33475, "oi_jobid": 6394, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6442, "oi_productid": 285, "oi_recipeid": 291, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 4, "oi_customseq": 4, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":9631,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9055,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9347,\"labelname\":\"Location\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9054,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9058,\"labelname\":\"System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9056,\"labelname\":\"Width\",\"value\":\"\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9057,\"labelname\":\"Projection\",\"value\":\"\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9059,\"labelname\":\"Fitting height\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9061,\"labelname\":\"Control side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9063,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9316,\"labelname\":\"Customer Special instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9317,\"labelname\":\"Fitters special instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9619,\"labelname\":\"Markilux special instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":9650,\"labelname\":\"manoj\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": null, "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[9631, 9055, 9347, 9054, 9058, 9056, 9057, 9059, 9061, 9063, 9316, 9317, 9619, 9650]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33475", "oi_productiondate": 1755241115, "oi_createdat": 1755241118, "oi_updatedat": null, "oi_createdby": 1, "oi_updatedby": null }, { "oi_id": 33476, "oi_jobid": 6394, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6442, "oi_productid": 342, "oi_recipeid": 353, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 5, "oi_customseq": 5, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":17501,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":\"4\",\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17500,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17502,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17503,\"labelname\":\"Width\",\"value\":\"\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"0_Inches_4_0\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17504,\"labelname\":\"Drop\",\"value\":\"\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"0_Inches_4_0\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17506,\"labelname\":\"Product Type\",\"value\":\"\",\"valueid\":\"\",\"type\":13,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17509,\"labelname\":\"Text Field\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":17510,\"labelname\":\"Numeric Field\",\"value\":\"\",\"valueid\":\"\",\"type\":6,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]", "oi_description": null, "oi_reportdescription": "##Quantity: 1##", "oi_reporttitles": "##Quantity:", "oi_productionformulajsondata": "[]", "oi_operationstatus": null, "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "[]", "oi_pricecomesfrom_calculations": "{}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "0.000", "oi_netprice": "0.000", "oi_pricesfromoperations": null, "oi_vatprice": "0.000", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "0.000", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "0.000", "oi_endcustomeroverridevatprice": "0.000", "oi_endcustomeroverridegrossprice": "0.000", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[17501, 17500, 17502, 17503, 17504, 17506, 17509, 17510]", "oi_deviceplatform": 2, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33476", "oi_productiondate": 1755241141, "oi_createdat": 1755241144, "oi_updatedat": null, "oi_createdby": 1, "oi_updatedby": null } ], "updated": [ { "oi_id": 33472, "oi_jobid": 6397, "oi_jobtempid": "0", "oi_jobmultiquoteid": 6445, "oi_productid": 15, "oi_recipeid": 407, "oi_ruleid": 40, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":7231,\"labelname\":\"Location\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Location\",\"fieldid\":7231,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":6893,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":2,\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"issubfabric\":0,\"labelnamecode\":\"Unit Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":34,\"mandatory\":0,\"fieldname\":\"Unit Type\",\"fieldid\":6893,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"editruleoverride\":0},{\"id\":4438,\"labelname\":\"Supplier\",\"value\":\"13\",\"valueid\":null,\"type\":17,\"optionid\":\"13\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"SupplierDUK\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":4438,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"13\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1},{\"id\":13,\"optionid\":13,\"optionname\":\"Drapes UK\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":7242,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantityiudfh\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":14,\"mandatory\":0,\"fieldname\":\"Quantity\",\"fieldid\":7242,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4439,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width001\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":4439,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4440,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop002\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":4440,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":4661,\"labelname\":\"Installation height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Installation heightIHG\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Installation height\",\"fieldid\":4661,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4442,\"labelname\":\"Measure to\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Measure toMT\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Measure to\",\"fieldid\":4442,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4444,\"labelname\":\"Fabric choice\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric choice\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric choice\",\"fieldid\":4444,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4446,\"labelname\":\"Control side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control sideCS\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control side\",\"fieldid\":4446,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4447,\"labelname\":\"Blind Lining\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind LiningRL\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Blind Lining\",\"fieldid\":4447,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4448,\"labelname\":\"Valance pelmet\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Valance pelmetVP\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Valance pelmet\",\"fieldid\":4448,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4449,\"labelname\":\"Operation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"OperationOP\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Operation\",\"fieldid\":4449,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4468,\"labelname\":\"Product Type\",\"value\":\"378\",\"valueid\":\"456\",\"type\":13,\"optionid\":\"378\",\"optionvalue\":[{\"id\":456,\"fieldid\":4468,\"fieldoptionlinkid\":456,\"optionid\":378,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 1\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":4468,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"378\",\"optionsvalue\":[{\"id\":456,\"fieldid\":4468,\"fieldoptionlinkid\":456,\"optionid\":378,\"mainsupplier\":\"13\",\"blindtypecode\":null,\"optionname\":\"Price band 1\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":4652,\"labelname\":\"Headrail\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Headrail\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Headrail\",\"fieldid\":4652,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4663,\"labelname\":\"Workroom instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Workroom instructionsWIM\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Workroom instructions\",\"fieldid\":4663,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4664,\"labelname\":\"Fitters instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitters instructionsFII\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Fitters instructions\",\"fieldid\":4664,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":4665,\"labelname\":\"Special instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special instructionsSIC\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special instructions\",\"fieldid\":4665,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":17761,\"labelname\":\"ZN\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"ZN\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"ZN\",\"fieldid\":17761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Drapes UK, Width: 1000, Drop: 1000, Product Type: Price band 1", "oi_reportdescription": "##Supplier: Drapes UK##,##Quantity: 1##,##Width: 1000 mm##,##Drop: 1000 mm##,##Product Type: Price band 1##", "oi_reporttitles": "##Supplier:<\/br>##Quantity:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"sellingprice\":\"61.88\",\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]", "oi_operationstatus": "", "oi_scanstatus": "", "oi_operationworkroom_data": "[]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"0.00\",\"cost_with_discount\":\"0.00\",\"cost_with_markup\":\"0.00\",\"gross_price\":\"0.00\",\"vat_price\":\"0.00\"}", "oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"60.55\",\"show_hide\":true,\"category\":3}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "60.550", "oi_netprice": "61.880", "oi_pricesfromoperations": null, "oi_vatprice": "6.190", "oi_vatvalue": "10.000", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "68.070", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 33471, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "61.880", "oi_endcustomeroverridevatprice": "6.190", "oi_endcustomeroverridegrossprice": "68.070", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7231, 6893, 4438, 7242, 4439, 4440, 4661, 4442, 4444, 4446, 4447, 4448, 4449, 4468, 4652, 4663, 4664, 4665, 17761]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "33472", "oi_productiondate": 1764288000, "oi_createdat": 1755260738, "oi_updatedat": 1755240955, "oi_createdby": 38, "oi_updatedby": 38 } ], "deleted": [] }, "bm_paymentlist": { "created": [ { "pl_id": 4162, "pl_orderid": "0", "pl_invoice_id": 0, "pl_customer_id": 4151, "pl_overpayment_id": 0, "pl_jobpayment_id": 0, "pl_amount": "18.00", "pl_paymentmethod": 14, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 2, "pl_surchargemethod": 2, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "18.00", "pl_userid": "34", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "4162", "pl_paiddate": 1755216000, "created_at": 1755241112, "updated_at": null, "created_by": 34, "updated_by": null }, { "pl_id": 4164, "pl_orderid": "0", "pl_invoice_id": 2744, "pl_customer_id": 4151, "pl_overpayment_id": 0, "pl_jobpayment_id": 0, "pl_amount": "1.00", "pl_paymentmethod": 14, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 2, "pl_surchargemethod": 2, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "1.00", "pl_userid": "34", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "4164", "pl_paiddate": 1754956800, "created_at": 1755241460, "updated_at": null, "created_by": 34, "updated_by": null }, { "pl_id": 4165, "pl_orderid": "0", "pl_invoice_id": 2744, "pl_customer_id": 4151, "pl_overpayment_id": 0, "pl_jobpayment_id": 0, "pl_amount": "5.00", "pl_paymentmethod": 14, "pl_paymentcategory": 1, "pl_paymenttype": 8, "pl_surchargetype": 2, "pl_surchargemethod": 2, "pl_surchargeamount": "0.00", "pl_surchargevalue": "0.00", "pl_surchargetotal": "5.00", "pl_userid": "34", "pl_decription": "", "pl_paymentinvoice": null, "pl_paymentstatus": 0, "pl_seq": 0, "pl_status": 0, "pl_refundtype": null, "pl_deviceplatform": 0, "id": "4165", "pl_paiddate": 1755216000, "created_at": 1755241472, "updated_at": null, "created_by": 34, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_notelist": { "created": [ { "nl_id": 105828, "nl_ordertempid": null, "nl_orderid": 6397, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Payment Added succesfully for this job amount (10)", "nl_manualNotes": "", "nl_createdby": "38", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105828", "nl_endddate": 1755216000, "nl_starttime": 1755277094, "created_at": 1755241094, "updated_at": 1755241094, "created_by": 38, "updated_by": null }, { "nl_id": 105829, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "payment added against invoice no (Invoice9818) amount (95)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105829", "nl_endddate": 1755216000, "nl_starttime": 1755277095, "created_at": 1755241095, "updated_at": 1755241095, "created_by": 34, "updated_by": null }, { "nl_id": 105830, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Over payment added (18)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105830", "nl_endddate": 1755216000, "nl_starttime": 1755277112, "created_at": 1755241112, "updated_at": 1755241112, "created_by": 34, "updated_by": null }, { "nl_id": 105831, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Payment deleted for this invoice (Invoice9818) amount (95.00)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105831", "nl_endddate": 1755216000, "nl_starttime": 1755277140, "created_at": 1755241140, "updated_at": 1755241140, "created_by": 34, "updated_by": null }, { "nl_id": 105832, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Payment deleted for this invoice (Invoice9818) amount (100.00)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105832", "nl_endddate": 1755216000, "nl_starttime": 1755277166, "created_at": 1755241166, "updated_at": 1755241166, "created_by": 34, "updated_by": null }, { "nl_id": 105833, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "payment added against invoice no (Invoice9818) amount (18.000)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105833", "nl_endddate": 1755216000, "nl_starttime": 1755277199, "created_at": 1755241199, "updated_at": 1755241199, "created_by": 34, "updated_by": null }, { "nl_id": 105834, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Payment deleted for this invoice (Invoice9818) amount (18.00)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105834", "nl_endddate": 1755216000, "nl_starttime": 1755277281, "created_at": 1755241281, "updated_at": 1755241281, "created_by": 34, "updated_by": null }, { "nl_id": 105835, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Invoice Deleted (Invoice9818)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105835", "nl_endddate": 1755216000, "nl_starttime": 1755277288, "created_at": 1755241288, "updated_at": 1755241288, "created_by": 34, "updated_by": null }, { "nl_id": 105836, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "Invoice Created (Invoice9820)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105836", "nl_endddate": 1755216000, "nl_starttime": 1755277425, "created_at": 1755241425, "updated_at": 1755241425, "created_by": 34, "updated_by": null }, { "nl_id": 105837, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "payment added against invoice no (Invoice9820) amount (1)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105837", "nl_endddate": 1755216000, "nl_starttime": 1755277460, "created_at": 1755241460, "updated_at": 1755241460, "created_by": 34, "updated_by": null }, { "nl_id": 105838, "nl_ordertempid": null, "nl_orderid": 6387, "nl_notescategory": 1, "nl_type": 26, "nl_platform": 3, "nl_desc": "payment added against invoice no (Invoice9820) amount (5)", "nl_manualNotes": "", "nl_createdby": "34", "nl_attachmnettext": null, "nl_attachmnetURL": null, "nl_isonlinenote": 1, "nl_seq": 0, "nl_status": 0, "nl_barcodeprocessid": null, "id": "105838", "nl_endddate": 1755216000, "nl_starttime": 1755277472, "created_at": 1755241472, "updated_at": 1755241472, "created_by": 34, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 6163, "das_jobid": 6397, "das_appointmentaddress": 4340, "das_invoiceaddress": 4340, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "6163", "das_createdat": 1755240950, "das_updatedat": 1755240950, "das_createdby": 38, "das_updatedby": null }, { "das_id": 6164, "das_jobid": 6398, "das_appointmentaddress": 0, "das_invoiceaddress": 0, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "6164", "das_createdat": 1755241038, "das_updatedat": 1755241038, "das_createdby": 27, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [ { "invoice_id": 2744, "job_id": 6387, "customer_id": 4151, "ref_no": "Invoice9820", "invoice_type": 2, "invoice_split_type": 2, "invoice_split_cal": 1, "invoice_split_cal_value": "10.000", "net_amount": "961.880", "vat_amount": "96.190", "gross_amount": "1058.070", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "10.000", "split_net_amount": "9.091", "split_vat_amount": "0.909", "outstanding_amount": "4.000", "paid_amount": "6.000", "paid_status": 2, "status": 0, "transfer": 0, "transfer_id": null, "id": "2744", "paymentDueDate": 1755820800, "invoiceDate": 1755216000, "transferDate": null, "createdat": 1755241425, "updatedat": 1755241472, "createdby": 34, "updatedby": 34 } ], "updated": [ { "invoice_id": 2744, "job_id": 6387, "customer_id": 4151, "ref_no": "Invoice9820", "invoice_type": 2, "invoice_split_type": 2, "invoice_split_cal": 1, "invoice_split_cal_value": "10.000", "net_amount": "961.880", "vat_amount": "96.190", "gross_amount": "1058.070", "delivery_amount": "0.000", "delivery": 0, "commission_amount": "0.000", "commission": 0, "total_amount": "10.000", "split_net_amount": "9.091", "split_vat_amount": "0.909", "outstanding_amount": "4.000", "paid_amount": "6.000", "paid_status": 2, "status": 0, "transfer": 0, "transfer_id": null, "id": "2744", "paymentDueDate": 1755820800, "invoiceDate": 1755216000, "transferDate": null, "createdat": 1755241425, "updatedat": 1755241472, "createdby": 34, "updatedby": 34 } ], "deleted": [ "2742" ] }, "bm_InvoiceDetails": { "created": [ { "ind_id": 15603, "ind_invoice_id": 2744, "ind_order_id": 33430, "ind_qty": 1, "ind_net_amount": "961.880", "ind_vat_amount": "96.190", "ind_gross_amount": "1058.070", "ind_status": 0, "id": "15603", "ind_createdat": 1755241425, "ind_updatedat": 1755241425, "ind_createdby": 34, "ind_updatedby": null } ], "updated": [], "deleted": [ "15601" ] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [ { "jp_id": 453, "jp_job_id": 6397, "jp_amount": "10.000", "jp_amountoutstanding": "10.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": "0.000", "jp_surchargetotal": "10.000", "jp_userid": 38, "jp_decription": "", "jp_deviceplatform": 0, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "453", "jp_paiddate": 1755216000, "jp_createdat": 1755241094, "jp_updatedat": 1755241094, "jp_createdby": 38, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [ { "op_id": 10, "op_customer_id": 4151, "op_payment_id": 4162, "op_total_amount": "18.000", "op_outstanding_amount": "0.000", "op_paid_amount": "18.000", "op_status": 0, "id": "10", "op_createdat": 1755241112, "op_updatedat": 1755241199, "op_createdby": 34, "op_updatedby": 34 } ], "updated": [ { "op_id": 10, "op_customer_id": 4151, "op_payment_id": 4162, "op_total_amount": "18.000", "op_outstanding_amount": "0.000", "op_paid_amount": "18.000", "op_status": 0, "id": "10", "op_createdat": 1755241112, "op_updatedat": 1755241199, "op_createdby": 34, "op_updatedby": 34 } ], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 25043, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 2, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "25043", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1722586185, "created_by": null, "updated_by": null }, { "termsid": 25044, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 2, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "25044", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1708073527, "created_by": 1, "updated_by": null }, { "termsid": 25045, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 2, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "25045", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1708073606, "created_by": 1, "updated_by": null }, { "termsid": 25046, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 2, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "25046", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1708073626, "created_by": 1, "updated_by": null }, { "termsid": 25047, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "25047", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 25048, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 3, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "25048", "created_at": 1755240950, "updated_at": 1755240950, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 25049, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 3, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "25049", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 25050, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 3, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "25050", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 25051, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "
50% deposit with order and balance due 3 days prior to <\/span>installation.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div><\/div>", "status": 0, "seq": 1, "id": "25051", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": null, "updated_by": null }, { "termsid": 25052, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 4, "termsName": "Agreed Terms", "termsDescription": "
50% deposit with order with 40% due 3 days prior to installation<\/span>
<\/div>
Final 10% payable to fitters on completion.<\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 2, "id": "25052", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 25053, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 4, "termsName": "Contract Terms", "termsDescription": "
30 day terms<\/span>
<\/div>
Invoice payment due 30 days from invoice date<\/div>
Payments can be made by BACS or credit\/debit card <\/div>
BACS details Account – Aquarius Blinds Account No – 40054837 Sort code – 09-06-66<\/div><\/div>

<\/div>", "status": 0, "seq": 3, "id": "25053", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null }, { "termsid": 25054, "orderid": 6397, "jobmultiquoteid": 6445, "isresportshow": 1, "termsCategory": 4, "termsName": "Special Terms", "termsDescription": "
Payment in full with order. <\/span>
<\/div>
Payments can be made by BACS or credit\/debit card<\/span>
<\/div>
BACS details<\/span>
<\/div>
Account – Aquarius Blinds<\/span>
<\/div>
Account No – 40054837<\/span>
<\/div>
Sort code – 09-06-66<\/span>
<\/div>
Please refer to AQ reference number when making payments<\/span><\/div>", "status": 0, "seq": 4, "id": "25054", "created_at": 1755240951, "updated_at": 1755240951, "terms_created_at": 1722585569, "created_by": 1, "updated_by": null } ], "updated": [], "deleted": [] }, "bm_jobmultiquote": { "created": [ { "jmq_id": 6445, "jmq_jobid": 6397, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "61.88", "jmq_netprice": "61.88", "jmq_vat": "6.19", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 5, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "68.07", "jmq_grossprofit": "1.33", "jmq_costprice": "60.55", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "58.07", "jmq_totpaid": "10.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "6445", "jmq_duedate": 1764288000, "jmq_sceduleddate": null, "jmq_createdat": "1755240950.000000", "jmq_updatedat": "1755241094.000000", "jmq_createdby": 38, "jmq_updatedby": 38 }, { "jmq_id": 6446, "jmq_jobid": 6398, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "0.00", "jmq_netprice": "0.00", "jmq_vat": "0.00", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 0, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "0.00", "jmq_grossprofit": "0.00", "jmq_costprice": "0.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "0.00", "jmq_totpaid": "0.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "\"\"", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "0.000", "jmq_cdeliveryvatperc": "0.000", "id": "6446", "jmq_duedate": 1755216000, "jmq_sceduleddate": null, "jmq_createdat": "1755241038.000000", "jmq_updatedat": "1755241038.000000", "jmq_createdby": 27, "jmq_updatedby": null } ], "updated": [ { "jmq_id": 6435, "jmq_jobid": 6387, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "961.88", "jmq_netprice": "961.88", "jmq_vat": "96.19", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 5, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "1058.07", "jmq_grossprofit": "451.33", "jmq_costprice": "510.55", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "1052.07", "jmq_totpaid": "6.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": "\"\"", "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": "", "jmq_endcustomeroverridenetprice": "961.88", "jmq_endcustomeroverridevatprice": "96.19", "jmq_endcustomeroverridegrossprice": "1058.07", "jmq_endcustomerdeliverycost": "", "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": "", "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "6435", "jmq_duedate": 1755129600, "jmq_sceduleddate": null, "jmq_createdat": "1755170409.000000", "jmq_updatedat": "1755241472.000000", "jmq_createdby": 1, "jmq_updatedby": 34 }, { "jmq_id": 6445, "jmq_jobid": 6397, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "61.88", "jmq_netprice": "61.88", "jmq_vat": "6.19", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 5, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "68.07", "jmq_grossprofit": "1.33", "jmq_costprice": "60.55", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "58.07", "jmq_totpaid": "10.00", "jmq_creditlimit": "0.00", "jmq_creditbalance": "0.00", "jmq_overdue": "0.00", "jmq_userdefinedarray": null, "jmq_deliverycostid": 0, "jmq_iscostpriceon": 0, "jmq_custompricefields": "", "jmq_isonlineorder": 1, "jmq_isonlineordersubmitted": 0, "jmq_endcustomervatprice": null, "jmq_endcustomeroverridetype": 1, "jmq_endcustomeroverridevalue": null, "jmq_endcustomeroverridenetprice": "0.00", "jmq_endcustomeroverridevatprice": "0.00", "jmq_endcustomeroverridegrossprice": "0.00", "jmq_endcustomerdeliverycost": null, "jmq_endcustomerdeliverycostinclvat": 1, "jmq_endcustomerfittingcost": null, "jmq_endcustomerfittingcostinclvat": 1, "jmq_onlinedeliveryaddreddtype": 0, "jmq_onlinedeliveryaddreddid": null, "jmq_commission": "[]", "jmq_commissionprice": "0.00", "jmq_commissionsetting": 0, "jmq_commissionaddedvalue": "0.00", "jmq_deliveryvatperc": "10.000", "jmq_cdeliveryvatperc": "10.000", "id": "6445", "jmq_duedate": 1764288000, "jmq_sceduleddate": null, "jmq_createdat": "1755240950.000000", "jmq_updatedat": "1755241094.000000", "jmq_createdby": 38, "jmq_updatedby": 38 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 7286, "jst_jobid": 6397, "jst_job_current_status": 1, "id": "7286", "jst_createdat": "1755240950.528615" }, { "jst_id": 7287, "jst_jobid": 6398, "jst_job_current_status": 4, "id": "7287", "jst_createdat": "1755241038.530275" }, { "jst_id": 7288, "jst_jobid": 6397, "jst_job_current_status": 4, "id": "7288", "jst_createdat": "1755241096.594053" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 76333, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 6397, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Aquarius Blinds\",\"Account Type\":\"Domestic\",\"Created By\":\"Kalai1\",\"First Name\":\"Kalai\",\"Last Name\":\"Nambi\",\"Mobile\":\"9943089943\",\"Country\":\"India\",\"Salutation\":\"Dr\",\"Phone\":\"7299089943\",\"Customer Ref\":\"123\",\"Role\":\"0\",\"Number\":\"16\",\"Additional Contacts\":\"4340\",\"Job Status\":\"Lead\",\"Order Status\":\"In Production\",\"Net Price\":\"61.88\",\"VAT Price\":\"6.19\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"Less Than\",\"Gross Price Amount\":\"68.07\",\"Gross Profit\":\"1.33\",\"Gross Profit Percentage\":\"2.15\",\"Total CostPrice\":\"60.55\",\"Amount Outstanding\":\"68.07\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Delivery Vat Percentage\":\"10.000\",\"Commission\":\"[]\",\"jd_onlineprefixseq\":\"25\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":6397,\"jd_customerid\":4151,\"jd_contactid\":4340,\"jd_additionalcontacts\":\"4340\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":\\\"\\\",\\\"41\\\":38,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Kalai\\\",\\\"46\\\":\\\"Nambi\\\",\\\"47\\\":\\\"9943089943\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":36,\\\"285\\\":12,\\\"286\\\":\\\"7299089943\\\",\\\"287\\\":\\\"123\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"551\\\":\\\"\\\",\\\"558\\\":\\\"0\\\",\\\"559\\\":1,\\\"610\\\":\\\"\\\",\\\"611\\\":\\\"\\\",\\\"612\\\":1,\\\"618\\\":\\\"16\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-15\",\"jd_orderdate\":\"0000-00-00\",\"jd_duedate\":\"0000-00-00\",\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":1,\"jd_contactaddid\":0,\"jd_orderstatus\":5,\"jd_accref\":\",NAMB0002\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"61.88\",\"jd_netprice\":\"61.88\",\"jd_vat\":\"6.19\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":5,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"68.07\",\"jd_grossprofit\":\"1.33\",\"jd_grossprofit_percentage\":\"2.15\",\"jd_costprice\":\"60.55\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"68.07\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":38,\"jd_createdat\":\"2025-08-15T06:55:50.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-15T06:55:50.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"10.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"10.000\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"25\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0,\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76333", "cl_createdat": "1755240950.000000", "cl_updatedat": null }, { "cl_id": 76351, "cl_logname": "QUEUE_40", "cl_type": "QUEUE_40", "cl_modulename": "Line Item", "cl_message": "Q1 - Line Item has been updated the field Production Date for the product of Roman blind", "cl_event": "modified", "cl_subjectid": 33472, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "{\"Production Date\":\"2025-08-15 12:25:38\"}", "cl_changedto": "{\"Production Date\":\"2025-11-28 00:00:00\"}", "cl_customproperties": "{\"attributes\":{\"oi_ruleid\":40,\"oi_productiondate\":\"2025-11-28 00:00:00\",\"oi_updatedat\":\"2025-08-15T06:55:55.000000Z\"},\"old\":{\"oi_ruleid\":0,\"oi_productiondate\":\"2025-08-15 12:25:38\",\"oi_updatedat\":\"2025-08-15T06:55:50.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76351", "cl_createdat": "1755240955.000000", "cl_updatedat": null }, { "cl_id": 76352, "cl_logname": "model", "cl_type": "QUEUE_40", "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 6397, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "{\"Production Due Date\":\"2025-08-15\"}", "cl_changedto": "{\"Production Due Date\":\"2025-11-28\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76352", "cl_createdat": "1755240955.000000", "cl_updatedat": null }, { "cl_id": 76353, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 6398, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6398, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Account Ref\":[\"\",\"MUFASA\"],\"Default Contact\":1,\"Country\":\"India\",\"Account Type\":\"Domestic\",\"Salutation\":\"Dr\",\"Organisation Name\":\"Aquarius Blinds\",\"First Name\":\"Mk'\",\"Company Name\":\"Jk\",\"Last Name\":\"Mk'\",\"Source\":\"Google\",\"Created By\":\"Sathar\",\"Account manager\":\"27\",\"Additional Contacts\":\"4148\",\"Order Date\":\"2025-08-15\",\"Production Due Date\":\"2025-08-15\",\"Job Status\":\"Order\",\"Order Status\":\"In Production\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"jd_isonlineorder\":1,\"End Customer Override Type\":1,\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Commission\":\"\\\"\\\"\",\"jd_onlineprefixseq\":\"43\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":6398,\"jd_customerid\":3975,\"jd_contactid\":4148,\"jd_additionalcontacts\":\"4148\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"62\\\":[\\\"\\\",\\\"MUFASA\\\"],\\\"83\\\":1,\\\"65\\\":\\\"\\\",\\\"66\\\":\\\"\\\",\\\"67\\\":\\\"\\\",\\\"68\\\":\\\"\\\",\\\"69\\\":\\\"\\\",\\\"70\\\":\\\"\\\",\\\"71\\\":\\\"\\\",\\\"72\\\":36,\\\"73\\\":\\\"\\\",\\\"568\\\":\\\"\\\",\\\"617\\\":1,\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"37\\\":1,\\\"285\\\":12,\\\"33\\\":\\\"25\\\",\\\"45\\\":\\\"Mk'\\\",\\\"44\\\":\\\"Jk\\\",\\\"46\\\":\\\"Mk'\\\",\\\"39\\\":25,\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"54\\\":36,\\\"53\\\":\\\"\\\",\\\"286\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"558\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"41\\\":\\\"27\\\",\\\"551\\\":\\\"27\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-08-15\",\"jd_orderdate\":\"2025-08-15\",\"jd_duedate\":\"2025-08-15\",\"jd_duedatechangedmanually\":0,\"jd_sceduleddate\":\"0000-00-00\",\"jd_invoicedate\":\"0000-00-00\",\"jd_completeddate\":\"0000-00-00\",\"jd_jobref\":null,\"jd_jobstatus\":4,\"jd_contactaddid\":0,\"jd_orderstatus\":5,\"jd_accref\":\"MUFASA\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"0.00\",\"jd_netprice\":\"0.00\",\"jd_vat\":\"0.00\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":0,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"0.00\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"0.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"0.00\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":\"\\\"\\\"\",\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_accountingsoftware_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":1,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":1,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":1,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":null,\"jd_organizationid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":27,\"jd_createdat\":\"2025-08-15T06:57:18.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-08-15T06:57:18.000000Z\",\"salesorderid\":null,\"jd_deviceplatform\":0,\"jd_fromjobref\":\"\",\"jd_fromdbname\":null,\"jd_importorder\":0,\"jd_quickquote\":0,\"jd_myob_flag\":0,\"jd_myobinvoiceid\":\"\",\"jd_qboflag\":0,\"jd_qboinvoiceid\":0,\"jd_qbodisplayname\":\"\",\"jd_deliveryvatperc\":\"0.000\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"0.000\",\"jd_commission\":\"\\\"\\\"\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":\"43\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":1,\"jd_rework_count\":0,\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76353", "cl_createdat": "1755241038.000000", "cl_updatedat": null }, { "cl_id": 76354, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "new item has been created in Quotation", "cl_event": "created", "cl_subjectid": 6446, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 6398, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":6446,\"jmq_jobid\":6398,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"2025-08-15\",\"List Price\":\"0.00\",\"Net Price\":\"0.00\",\"VAT Price\":\"0.00\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":0,\"Discount\":\"0.00\",\"jmq_editpricebyid\":0,\"Gross Price\":0,\"Gross Price Amount\":\"0.00\",\"Gross Profit\":\"0.00\",\"Total CostPrice\":\"0.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":1,\"Is Online Order Submitted\":0,\"End Customer Override Type\":1,\"End Customer Override Net Price\":\"0.00\",\"End Customer Override Vat Price\":\"0.00\",\"End Customer Override Gross Price\":\"0.00\",\"End Customer Delivery Cost Include Vat\":1,\"End Customer Fitting Cost Include Vat\":1,\"Online Delivery Addreddtype\":0,\"Commission\":\"\\\"\\\"\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"0.000\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}", "cl_customproperties": "{\"attributes\":{\"jmq_id\":6446,\"jmq_jobid\":6398,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"2025-08-15\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"0.00\",\"jmq_netprice\":\"0.00\",\"jmq_vat\":\"0.00\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":0,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":0,\"jmq_isroundon\":0,\"jmq_grossprice\":\"0.00\",\"jmq_grossprofit\":\"0.00\",\"jmq_costprice\":\"0.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"0.00\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_userdefinedarray\":null,\"jmq_deliverycostid\":0,\"jmq_iscostpriceon\":0,\"jmq_custompricefields\":\"\",\"jmq_isonlineorder\":1,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":1,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":1,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":1,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"\\\"\\\"\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"0.000\",\"jmq_cdeliveryvatperc\":\"0.000\",\"jmq_createdby\":27,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-08-15T06:57:18.000000Z\",\"jmq_updatedat\":\"2025-08-15T06:57:18.000000Z\",\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76354", "cl_createdat": "1755241038.000000", "cl_updatedat": null }, { "cl_id": 76355, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Job Ref No", "cl_event": "modified", "cl_subjectid": 6398, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6398, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"Job Ref No\":\"AQ6361\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobref\":\"AQ6361\"},\"old\":{\"jd_jobref\":null}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76355", "cl_createdat": "1755241038.000000", "cl_updatedat": null }, { "cl_id": 76356, "cl_logname": "default", "cl_type": null, "cl_modulename": "Alternative Address", "cl_message": "Alternative Address has been updated the fields Appointments Add,Invoice Add,Invoice Delivery Add,Purchase Add,Worksheet Add", "cl_event": "modified", "cl_subjectid": 6164, "cl_subjecttype": "App\\Models\\Job\\bm_deliveryaddresssetting", "cl_parentid": 6398, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "null", "cl_changedto": "{\"Appointments Add\":\"Default(Same as billing add)\",\"Invoice Add\":\"Default(Same as billing add)\",\"Invoice Delivery Add\":\"Default(Same as billing add)\",\"Purchase Add\":\"Default(Same as billing add)\",\"Worksheet Add\":\"Default(Same as billing add)\"}", "cl_customproperties": "{\"attributes\":{\"das_id\":6164,\"das_jobid\":6398,\"das_appointmentaddress\":0,\"das_invoiceaddress\":0,\"das_invoicedeliveryaddress\":0,\"das_purchaseaddress\":0,\"das_worksheetaddress\":0,\"das_createdby\":27,\"das_createdat\":\"2025-08-15T06:57:18.000000Z\",\"das_updatedby\":null,\"das_updatedat\":\"2025-08-15T06:57:18.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76356", "cl_createdat": "1755241038.000000", "cl_updatedat": null }, { "cl_id": 76357, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field jd_qbodisplayname", "cl_event": "modified", "cl_subjectid": 6398, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6398, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 27, "cl_changedfrom": "[]", "cl_changedto": "{\"jd_qbodisplayname\":\"Jk\"}", "cl_customproperties": "{\"attributes\":{\"jd_qbodisplayname\":\"Jk\"},\"old\":{\"jd_qbodisplayname\":\"\"}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76357", "cl_createdat": "1755241038.000000", "cl_updatedat": null }, { "cl_id": 76358, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid,jd_num_of_payments", "cl_event": "modified", "cl_subjectid": 6397, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "{\"Amount Outstanding\":\"68.07\",\"Total Paid\":\"0.00\",\"jd_num_of_payments\":0}", "cl_changedto": "{\"Amount Outstanding\":\"58.07\",\"Total Paid\":\"10.00\",\"jd_num_of_payments\":1}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"58.07\",\"jd_totpaid\":\"10.00\",\"jd_updatedat\":\"2025-08-15T06:58:14.000000Z\",\"jd_num_of_payments\":1},\"old\":{\"jd_amountoutstanding\":\"68.07\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-08-15T06:55:55.000000Z\",\"jd_num_of_payments\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76358", "cl_createdat": "1755241094.000000", "cl_updatedat": null }, { "cl_id": 76359, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105828, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Payment Added succesfully for this job amount (10)\",\"Created By\":\"Kalai1\",\"Date\":\"2025-08-15\",\"Time\":\"16:58:14\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105828,\"nl_ordertempid\":null,\"nl_orderid\":6397,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Payment Added succesfully for this job amount (10)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"38\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:58:14\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":38,\"created_at\":\"2025-08-15T06:58:14.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:58:14.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76359", "cl_createdat": "1755241094.000000", "cl_updatedat": null }, { "cl_id": 76360, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4161, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4161, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":2742,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"95.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"95.00\",\"User Entered\":\"Nagaraj\",\"Paid Date\":\"2025-08-15\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4161,\"pl_orderid\":\"0\",\"pl_invoice_id\":2742,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"95.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"95.00\",\"pl_userid\":\"34\",\"pl_paiddate\":\"2025-08-15\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":34,\"created_at\":\"2025-08-15T06:58:15.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76360", "cl_createdat": "1755241095.000000", "cl_updatedat": null }, { "cl_id": 76361, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105829, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (Invoice9818) amount (95)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"16:58:15\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105829,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (Invoice9818) amount (95)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:58:15\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T06:58:15.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:58:15.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76361", "cl_createdat": "1755241095.000000", "cl_updatedat": null }, { "cl_id": 76362, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"958.07\",\"Total Paid\":\"100.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"863.07\",\"Total Paid\":\"195.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"863.07\",\"jd_totpaid\":\"195.00\",\"jd_updatedby\":34,\"jd_updatedat\":\"2025-08-15T06:58:15.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"958.07\",\"jd_totpaid\":\"100.00\",\"jd_updatedby\":1,\"jd_updatedat\":\"2025-08-14T12:26:40.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76362", "cl_createdat": "1755241096.000000", "cl_updatedat": null }, { "cl_id": 76363, "cl_logname": "model", "cl_type": "QUEUE_39", "cl_modulename": "Job Status", "cl_message": "Job Status has been updated", "cl_event": "modified", "cl_subjectid": 6397, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "{\"Job Status\":\"Lead\"}", "cl_changedto": "{\"Job Status\":\"Order\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76363", "cl_createdat": "1755241096.000000", "cl_updatedat": null }, { "cl_id": 76364, "cl_logname": "QUEUE_39", "cl_type": "QUEUE_39", "cl_modulename": "Job", "cl_message": "Job has been updated the field Job Rework Enable", "cl_event": "modified", "cl_subjectid": 6397, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6397, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 38, "cl_changedfrom": "{\"Job Rework Enable\":\"Off\"}", "cl_changedto": "{\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_jobstatus\":4,\"jd_updatedat\":\"2025-08-15T06:58:16.000000Z\",\"jd_rework_enable\":1},\"old\":{\"jd_jobstatus\":1,\"jd_updatedat\":\"2025-08-15T06:58:14.000000Z\",\"jd_rework_enable\":0}}", "cl_attachment": null, "cl_deviceplatform": "", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76364", "cl_createdat": "1755241096.000000", "cl_updatedat": null }, { "cl_id": 76365, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4162, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4162, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":0,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"18.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"18.00\",\"User Entered\":\"Nagaraj\",\"Paid Date\":\"2025-08-15\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4162,\"pl_orderid\":\"0\",\"pl_invoice_id\":0,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"18.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"18.00\",\"pl_userid\":\"34\",\"pl_paiddate\":\"2025-08-15\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":34,\"created_at\":\"2025-08-15T06:58:32.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76365", "cl_createdat": "1755241112.000000", "cl_updatedat": null }, { "cl_id": 76366, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105830, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Over payment added (18)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"16:58:32\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105830,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Over payment added (18)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:58:32\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T06:58:32.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:58:32.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76366", "cl_createdat": "1755241112.000000", "cl_updatedat": null }, { "cl_id": 76367, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"863.07\",\"Total Paid\":\"195.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"958.07\",\"Total Paid\":\"100.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"958.07\",\"jd_totpaid\":\"100.00\",\"jd_updatedat\":\"2025-08-15T06:59:00.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"863.07\",\"jd_totpaid\":\"195.00\",\"jd_updatedat\":\"2025-08-15T06:58:16.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76367", "cl_createdat": "1755241140.000000", "cl_updatedat": null }, { "cl_id": 76368, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105831, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Payment deleted for this invoice (Invoice9818) amount (95.00)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"16:59:00\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105831,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Payment deleted for this invoice (Invoice9818) amount (95.00)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:59:00\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T06:59:00.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:59:00.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76368", "cl_createdat": "1755241140.000000", "cl_updatedat": null }, { "cl_id": 76369, "cl_logname": "default", "cl_type": null, "cl_modulename": "Appointment", "cl_message": "new item has been created in Appointment", "cl_event": "created", "cl_subjectid": 10762, "cl_subjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_parentid": 10762, "cl_parentsubjecttype": "App\\Models\\Calendar\\bm_appointment", "cl_causerid": 8, "cl_changedfrom": "null", "cl_changedto": "{\"Repeat On\":\"yearly on August 15\",\"app_summary\":\"Measurer\",\"Private\":\"enabled\",\"Appointment Type\":\"Measurer\",\"Staff\":\"Kristian\",\"Start Date & Time\":\"2025-08-12 04:30:00\",\"End Date & Time\":\"2025-08-12 05:00:00\",\"Appointment Status\":\"Test\",\"app_jobtimeminute\":\"30\",\"app_products\":\"[]\"}", "cl_customproperties": "{\"attributes\":{\"app_eventid\":10762,\"app_description\":\"\",\"app_summary\":\"Measurer\",\"app_private\":1,\"app_appointmentType\":62,\"app_userId\":7,\"app_orderId\":0,\"app_customerId\":0,\"app_isAllDay\":0,\"app_sdate\":\"2025-08-12\",\"app_edate\":\"2025-08-12\",\"app_stime\":\"04:30:00\",\"app_etime\":\"05:00:00\",\"app_sdatetime\":\"2025-08-12 04:30:00\",\"app_edatetime\":\"2025-08-12 05:00:00\",\"app_timezone\":\"Asia\\\/Calcutta\",\"app_latitude\":null,\"app_longitude\":null,\"app_parentappid\":null,\"app_recurrencerule\":null,\"app_userdefinedValue\":\"[]\",\"app_recurrenceexception\":null,\"app_recurrenceexception_date\":null,\"app_attachment\":null,\"guid\":\"\",\"app_outlookuid\":null,\"app_until\":null,\"app_staff\":\"\",\"app_appointtype\":\"\",\"app_confirmed\":0,\"app_coordinates\":\"\",\"app_travelHour\":\"0\",\"app_travelMinute\":\"0\",\"app_onsiteHour\":\"0\",\"app_onsiteMinute\":\"0\",\"app_location\":null,\"app_traveltime\":null,\"app_googleid\":\"0\",\"app_platform\":\"web\",\"app_cal_status\":798,\"app_status\":0,\"app_markasread\":0,\"app_statusInGoogle\":0,\"app_createdBy\":8,\"app_updatedBy\":null,\"app_createdAt\":\"2025-08-15T06:59:24.000000Z\",\"app_updatedAt\":\"2025-08-15T06:59:24.000000Z\",\"app_runid\":0,\"app_deliveryaddressid\":null,\"app_jobtimehour\":\"0\",\"app_jobtimeminute\":\"30\",\"app_products\":\"[]\",\"app_deviceplatform\":0,\"app_statusInOutlook\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76369", "cl_createdat": "1755241164.000000", "cl_updatedat": null }, { "cl_id": 76370, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"958.07\",\"Total Paid\":\"100.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"1058.07\",\"Total Paid\":\"0.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"1058.07\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-08-15T06:59:26.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"958.07\",\"jd_totpaid\":\"100.00\",\"jd_updatedat\":\"2025-08-15T06:59:08.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76370", "cl_createdat": "1755241166.000000", "cl_updatedat": null }, { "cl_id": 76371, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105832, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Payment deleted for this invoice (Invoice9818) amount (100.00)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"16:59:26\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105832,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Payment deleted for this invoice (Invoice9818) amount (100.00)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:59:26\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T06:59:26.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:59:26.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76371", "cl_createdat": "1755241166.000000", "cl_updatedat": null }, { "cl_id": 76372, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4163, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4163, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":2742,\"pl_customer_id\":4151,\"pl_overpayment_id\":10,\"pl_jobpayment_id\":0,\"Amount\":\"18.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"18.00\",\"User Entered\":\"Nagaraj\",\"Paid Date\":\"2025-08-15\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4163,\"pl_orderid\":\"0\",\"pl_invoice_id\":2742,\"pl_customer_id\":4151,\"pl_overpayment_id\":10,\"pl_jobpayment_id\":0,\"pl_amount\":\"18.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"18.00\",\"pl_userid\":\"34\",\"pl_paiddate\":\"2025-08-15\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":34,\"created_at\":\"2025-08-15T06:59:59.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76372", "cl_createdat": "1755241199.000000", "cl_updatedat": null }, { "cl_id": 76373, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105833, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (Invoice9818) amount (18.000)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"16:59:59\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105833,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (Invoice9818) amount (18.000)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"16:59:59\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T06:59:59.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T06:59:59.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76373", "cl_createdat": "1755241199.000000", "cl_updatedat": null }, { "cl_id": 76374, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"1058.07\",\"Total Paid\":\"0.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"1040.07\",\"Total Paid\":\"18.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"1040.07\",\"jd_totpaid\":\"18.00\",\"jd_updatedat\":\"2025-08-15T06:59:59.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"1058.07\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-08-15T06:59:26.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76374", "cl_createdat": "1755241199.000000", "cl_updatedat": null }, { "cl_id": 76375, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"1040.07\",\"Total Paid\":\"18.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"1058.07\",\"Total Paid\":\"0.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"1058.07\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-08-15T07:01:21.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"1040.07\",\"jd_totpaid\":\"18.00\",\"jd_updatedat\":\"2025-08-15T06:59:59.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76375", "cl_createdat": "1755241281.000000", "cl_updatedat": null }, { "cl_id": 76376, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105834, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Payment deleted for this invoice (Invoice9818) amount (18.00)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"17:01:21\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105834,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Payment deleted for this invoice (Invoice9818) amount (18.00)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"17:01:21\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T07:01:21.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T07:01:21.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76376", "cl_createdat": "1755241281.000000", "cl_updatedat": null }, { "cl_id": 76377, "cl_logname": "model", "cl_type": null, "cl_modulename": "Invoice Date", "cl_message": "Invoice Date has been updated", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Invoice Date\":\"2025-08-14\"}", "cl_changedto": "{\"Invoice Date\":\"0000-00-00\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76377", "cl_createdat": "1755241287.000000", "cl_updatedat": null }, { "cl_id": 76378, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field ", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Invoice No\":\"Invoice9818\"}", "cl_changedto": "[]", "cl_customproperties": "{\"attributes\":{\"jd_invoicedate\":\"0000-00-00\",\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-08-15T07:01:27.000000Z\"},\"old\":{\"jd_invoicedate\":\"2025-08-14\",\"jd_invoiceno\":\"Invoice9818\",\"jd_updatedat\":\"2025-08-15T07:01:21.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76378", "cl_createdat": "1755241287.000000", "cl_updatedat": null }, { "cl_id": 76379, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105835, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Deleted (Invoice9818)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"17:01:28\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105835,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Invoice Deleted (Invoice9818)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"17:01:28\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T07:01:28.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T07:01:28.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76379", "cl_createdat": "1755241288.000000", "cl_updatedat": null }, { "cl_id": 76380, "cl_logname": "model", "cl_type": null, "cl_modulename": "Invoice Date", "cl_message": "Invoice Date has been updated", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Invoice Date\":\"0000-00-00\"}", "cl_changedto": "{\"Invoice Date\":\"2025-08-15\"}", "cl_customproperties": "{}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76380", "cl_createdat": "1755241425.000000", "cl_updatedat": null }, { "cl_id": 76381, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the field Invoice No", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "[]", "cl_changedto": "{\"Invoice No\":\"Invoice9820\"}", "cl_customproperties": "{\"attributes\":{\"jd_invoicedate\":\"2025-08-15\",\"jd_invoiceno\":\"Invoice9820\",\"jd_updatedat\":\"2025-08-15T07:03:45.000000Z\"},\"old\":{\"jd_invoicedate\":\"0000-00-00\",\"jd_invoiceno\":\"\",\"jd_updatedat\":\"2025-08-15T07:01:32.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76381", "cl_createdat": "1755241425.000000", "cl_updatedat": null }, { "cl_id": 76382, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105836, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"Invoice Created (Invoice9820)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"17:03:45\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105836,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"Invoice Created (Invoice9820)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"17:03:45\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T07:03:45.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T07:03:45.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76382", "cl_createdat": "1755241425.000000", "cl_updatedat": null }, { "cl_id": 76383, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4164, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4164, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":2744,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"1.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"1.00\",\"User Entered\":\"Nagaraj\",\"Paid Date\":\"2025-08-12\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4164,\"pl_orderid\":\"0\",\"pl_invoice_id\":2744,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"1.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"1.00\",\"pl_userid\":\"34\",\"pl_paiddate\":\"2025-08-12\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":34,\"created_at\":\"2025-08-15T07:04:20.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76383", "cl_createdat": "1755241460.000000", "cl_updatedat": null }, { "cl_id": 76384, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105837, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (Invoice9820) amount (1)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"17:04:20\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105837,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (Invoice9820) amount (1)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"17:04:20\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T07:04:20.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T07:04:20.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76384", "cl_createdat": "1755241460.000000", "cl_updatedat": null }, { "cl_id": 76385, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"1058.07\",\"Total Paid\":\"0.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"1057.07\",\"Total Paid\":\"1.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"1057.07\",\"jd_totpaid\":\"1.00\",\"jd_updatedat\":\"2025-08-15T07:04:20.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"1058.07\",\"jd_totpaid\":\"0.00\",\"jd_updatedat\":\"2025-08-15T07:03:45.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76385", "cl_createdat": "1755241460.000000", "cl_updatedat": null }, { "cl_id": 76386, "cl_logname": "default", "cl_type": null, "cl_modulename": "Payments", "cl_message": "new item has been created in Payments", "cl_event": "created", "cl_subjectid": 4165, "cl_subjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_parentid": 4165, "cl_parentsubjecttype": "App\\Models\\Payment\\bm_paymentlist", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Order Id\":\"0\",\"pl_invoice_id\":2744,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"Amount\":\"5.00\",\"Payment Method\":\"stripe\",\"Payment Type\":\"Deposit\",\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"5.00\",\"User Entered\":\"Nagaraj\",\"Paid Date\":\"2025-08-15\",\"pl_myob_flag\":0,\"pl_qbo_flag\":0}", "cl_customproperties": "{\"attributes\":{\"pl_id\":4165,\"pl_orderid\":\"0\",\"pl_invoice_id\":2744,\"pl_customer_id\":4151,\"pl_overpayment_id\":0,\"pl_jobpayment_id\":0,\"pl_amount\":\"5.00\",\"pl_paymentmethod\":14,\"pl_paymentcategory\":1,\"pl_paymenttype\":8,\"pl_surchargetype\":2,\"pl_surchargemethod\":2,\"pl_surchargeamount\":\"0.00\",\"pl_surchargevalue\":\"0.00\",\"pl_surchargetotal\":\"5.00\",\"pl_userid\":\"34\",\"pl_paiddate\":\"2025-08-15\",\"pl_decription\":\"\",\"pl_paymentinvoice\":null,\"pl_paymentstatus\":0,\"pl_xero_flag\":0,\"pl_xerooverpaymentid\":\"\",\"pl_seq\":0,\"pl_status\":0,\"pl_refundtype\":null,\"created_by\":34,\"created_at\":\"2025-08-15T07:04:32.000000Z\",\"updated_by\":null,\"updated_at\":null,\"pl_deviceplatform\":0,\"pl_myob_flag\":0,\"pl_qbo_flag\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76386", "cl_createdat": "1755241472.000000", "cl_updatedat": null }, { "cl_id": 76387, "cl_logname": "default", "cl_type": null, "cl_modulename": "Notes", "cl_message": "new item has been created in Notes", "cl_event": "created", "cl_subjectid": 105838, "cl_subjecttype": "App\\Models\\Notes\\bm_notelist", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "null", "cl_changedto": "{\"Type\":\"System Notes\",\"Platform\":\"Ecommerce\",\"Description\":\"payment added against invoice no (Invoice9820) amount (5)\",\"Created By\":\"Nagaraj\",\"Date\":\"2025-08-15\",\"Time\":\"17:04:32\",\"Is online note\":\"Yes\"}", "cl_customproperties": "{\"attributes\":{\"nl_id\":105838,\"nl_ordertempid\":null,\"nl_orderid\":6387,\"nl_notescategory\":1,\"nl_type\":26,\"nl_platform\":3,\"nl_desc\":\"payment added against invoice no (Invoice9820) amount (5)\",\"nl_manualNotes\":\"\",\"nl_createdby\":\"34\",\"nl_endddate\":\"2025-08-15\",\"nl_starttime\":\"17:04:32\",\"nl_attachmnettext\":null,\"nl_attachmnetURL\":null,\"nl_isonlinenote\":1,\"nl_seq\":0,\"nl_status\":0,\"created_by\":34,\"created_at\":\"2025-08-15T07:04:32.000000Z\",\"updated_by\":null,\"updated_at\":\"2025-08-15T07:04:32.000000Z\",\"nl_barcodeprocessid\":null}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76387", "cl_createdat": "1755241472.000000", "cl_updatedat": null }, { "cl_id": 76388, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "Job has been updated the fields Amount Outstanding,Total Paid", "cl_event": "modified", "cl_subjectid": 6387, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 6387, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 34, "cl_changedfrom": "{\"Amount Outstanding\":\"1057.07\",\"Total Paid\":\"1.00\"}", "cl_changedto": "{\"Amount Outstanding\":\"1052.07\",\"Total Paid\":\"6.00\"}", "cl_customproperties": "{\"attributes\":{\"jd_amountoutstanding\":\"1052.07\",\"jd_totpaid\":\"6.00\",\"jd_updatedat\":\"2025-08-15T07:04:32.000000Z\"},\"old\":{\"jd_amountoutstanding\":\"1057.07\",\"jd_totpaid\":\"1.00\",\"jd_updatedat\":\"2025-08-15T07:04:20.000000Z\"}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "76388", "cl_createdat": "1755241472.000000", "cl_updatedat": null } ], "updated": [], "deleted": [] }, "bm_productInfo": { "created": [], "updated": [ { "pi_productid": 276, "pi_productname": "MUFASA", "pi_pcode": "541", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "1", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": null, "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 9, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "276" }, { "pi_productid": 331, "pi_productname": "Curtain 45", "pi_pcode": "827", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "1", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 1, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 1, "pi_status": 0, "pi_createdby": 11, "pi_defaultunittype": 2, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "331" }, { "pi_productid": 412, "pi_productname": "Test product", "pi_pcode": "7547", "pi_category": 3, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "2", "pi_netpricecomesfrom": "2", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": "Roller blinds are a type of window blind that is typically made from a polyester fabric wrapped around a plastic or metal roller. The roller may either be exposed or enclosed inside of a frame and can be placed at the top of the window recess or outside of the recess. To control the roller blind there is typically a chain or string on either side of the blind. When the side chain is pulled one direction the roller will raise, and if pulled in the opposite direction it will lower instead. We also produce a version of roller blinds with two layers of fabric, sometimes referred to as double roller blinds, for even greater control of light filtration through a window. Typically, one layer will be made of a sheer fabric that can be used to reduce glare, with a second layer that typically includes a blackout lining for even greater filtration when necessary.", "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 0, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 322, "pi_status": 0, "pi_createdby": 29, "pi_defaultunittype": 4, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "412" }, { "pi_productid": 424, "pi_productname": "Shutter DnG", "pi_pcode": "2778", "pi_category": 5, "pi_productgroup": 1, "pi_producttype": 0, "pi_qtyperunit": "0.00", "pi_unitprice": "0.00", "pi_costfactor": null, "pi_commissionrate": "0.000", "pi_commissionmethod": null, "pi_reorderlevel": null, "pi_taxclass": null, "pi_serialno": null, "pi_qtyinstock": null, "pi_supplierid": null, "pi_imagename": null, "pi_currencyid": null, "pi_supplierdefault": null, "pi_productseqno": null, "pi_domesticmarkup": "0.00", "pi_contractmarkup": "0.00", "pi_trademarkup": "0.00", "pi_childsafe": null, "pi_quantyshowhide": null, "pi_compquantyshowhide": null, "pi_stockcontrol": null, "pi_productiontab": null, "pi_fabriccolorcodehide": null, "pi_defaultunitfornewcurtainsorder": null, "pi_costpricecomesfrom": "3", "pi_netpricecomesfrom": "3", "pi_shuttercontract": "0.00", "pi_shuttertrade": "0.00", "pi_shutterdomestic": "0.00", "pi_shutterecommerce": "0.00", "pi_customerdiscount": null, "pi_discountoverridesubwidth": null, "pi_manufacturer_cost": null, "pi_fabrichide": null, "pi_hidecompparameter": null, "pi_factorybarcodeproduct": null, "pi_showhideproductorder": 1, "pi_ecommercestatus": 0, "pi_productdescription": null, "pi_ecomproductdesc": null, "pi_homeimage": null, "pi_galleryimage": null, "pi_innerpageimage": null, "pi_frameimage": "[]", "pi_ecommercecompmarkup": "0.00", "pi_showframeminmax": null, "pi_fabricdefaultdiscount": null, "pi_productstatusmultiple": null, "pi_followproductionseq": 1, "pi_productionformulasheetname": null, "pi_productrules": null, "pi_showexcelfromula": null, "pi_supplierheading": null, "pi_producttypehide": null, "pi_dualproducttypeheading": "Fabric 2", "pi_fabricheading": null, "pi_dualproducttypeenable": 0, "pi_fabricbeforeproducttype": null, "pi_suppliermandatory": null, "pi_showfabric": null, "pi_ecommercesample": "1", "pi_priceavalcheck": null, "pi_showcomponentcode": null, "pi_showmaxarea": null, "pi_recessallowance": null, "pi_deductionname": null, "pi_deductionvalue": "0.00", "pi_stackqty": null, "pi_blindstype": null, "pi_suppliershowhide": null, "pi_pricealert": null, "pi_metatitle": null, "pi_metadescription": null, "pi_metakeyword": null, "pi_canonicaltag": null, "pi_alttexttag": null, "pi_headertag": "H1", "pi_productimage": "[]", "pi_workroom": 0, "pi_mobileapp": 1, "pi_jobtransfer": 0, "pi_seq": 334, "pi_status": 0, "pi_createdby": 1, "pi_defaultunittype": 3, "pi_jobfraction": 1, "pi_unittypeseq": "2,3,1,4", "pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}", "pi_backgroundimage": "[]", "pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"materialchk\":1}", "pi_ecomProductName": null, "pi_productgroupseq": null, "pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}", "id": "424" } ], "deleted": [] }, "bm_fields": { "created": [ { "fi_fieldId": 19031, "fi_fieldName": "Location Text", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 331, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 29, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 1, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 20, "fi_supplierid": "0", "fi_mobile_app_quick_view": 1, "id": "19031" }, { "fi_fieldId": 19032, "fi_fieldName": "Location List", "fi_fieldCode": null, "fi_fieldparamid": "432", "fi_productId": 276, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 4, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 1, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 21, "fi_supplierid": "0", "fi_mobile_app_quick_view": 1, "id": "19032" } ], "updated": [ { "fi_fieldId": 15568, "fi_fieldName": "Product Type", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 331, "fi_fabricorcolor": 0, "fi_dualseq": 1, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 0, "fi_fieldType": 13, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 1, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 14, "fi_supplierid": "", "fi_mobile_app_quick_view": 0, "id": "15568" }, { "fi_fieldId": 19031, "fi_fieldName": "Location Text", "fi_fieldCode": null, "fi_fieldparamid": "", "fi_productId": 331, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 29, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 1, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 20, "fi_supplierid": "0", "fi_mobile_app_quick_view": 1, "id": "19031" }, { "fi_fieldId": 19032, "fi_fieldName": "Location List", "fi_fieldCode": null, "fi_fieldparamid": "432", "fi_productId": 276, "fi_fabricorcolor": 0, "fi_dualseq": 0, "fi_linktopricegroup": 0, "fi_issubfabric": 0, "fi_showFieldOnJob": 1, "fi_showFieldOnEcommerce": 0, "fi_showFieldOnCustomerPortal": 1, "fi_fieldType": 4, "fi_fieldLevel": 1, "fi_hasPrice": 0, "fi_defaultOption": "", "fi_selection": 0, "fi_isMandatory": 1, "fi_showhide": 1, "fi_active": 0, "fi_status": 0, "fi_seq": 21, "fi_supplierid": "0", "fi_mobile_app_quick_view": 1, "id": "19032" } ], "deleted": [] }, "bm_fieldOptionLink": { "created": [], "updated": [], "deleted": [] }, "bm_option": { "created": [ { "op_optionId": 3883, "op_jobtempid": "0", "op_fieldTypeId": 4, "op_optionType": 0, "op_customerType": "{\"1\":true,\"2\":true,\"3\":true}", "op_customisedformdata": "{\"432\":\"Hall\"}", "op_hasprice": 0, "op_hasstock": 0, "op_filterbycontacttype": 0, "op_filterbypricegroup": 0, "op_filterbysupplier": 0, "op_filterbyshuttertype": 0, "op_filterbyshuttersupplier": 0, "op_filterbyminmax": 0, "op_active": 0, "op_status": 0, "id": "3883" } ], "updated": [], "deleted": [] }, "bm_optionproduct": { "created": [], "updated": [], "deleted": [] }, "bm_linkedfieldswithproduct": { "created": [], "updated": [], "deleted": [] }, "bm_productionstatus": { "created": [], "updated": [], "deleted": [] }, "bm_productpricemap": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipe": { "created": [], "updated": [], "deleted": [] }, "bm_productrecipemap": { "created": [], "updated": [], "deleted": [] }, "bm_supproductcode": { "created": [], "updated": [], "deleted": [] }, "bm_rulesetup": { "created": [], "updated": [], "deleted": [] }, "bm_formulas": { "created": [], "updated": [], "deleted": [] }, "bm_customercommission": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupdetails": { "created": [], "updated": [], "deleted": [] }, "bm_productgroupmaterialmap": { "created": [], "updated": [], "deleted": [] }, "bm_productpricedetails": { "created": [], "updated": [], "deleted": [] }, "bm_fabriccolourmap": { "created": [], "updated": [], "deleted": [] }, "bm_fabricdetails": { "created": [], "updated": [], "deleted": [] }, "bm_colordetails": { "created": [], "updated": [], "deleted": [] }, "bm_optiondiscount": { "created": [], "updated": [], "deleted": [] }, "bm_optionpricebook": { "created": [], "updated": [], "deleted": [] }, "bm_allowances": { "created": [], "updated": [], "deleted": [] }, "bm_xyoptionpricedata": { "created": [], "updated": [], "deleted": [] }, "bm_delivery_cost_setup": { "created": [], "updated": [], "deleted": [] }, "bm_organizationdetails": { "created": [ { "organization_id": 25, "organizationname": "Aquarius Blinds", "address": "Unit 1-245", "address2": "Church Road", "addres3": null, "city": "Mitcham", "state": "Surrey", "country": null, "code": "CR4 3BH", "phone": "020 8288 1081", "mobile1": null, "mobile2": "01273 020587", "fax": null, "email3": null, "email1": "santhoshmanokaran@blindmatrix.com", "email2": null, "website": null, "logoname": "aqblinds-logo.png", "logo": "122250-aqblinds-logo.png", "vatnumber": "3211231244132133", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "SHADEWELL 1", "countryid": 48, "bankname": "Santander", "comregistrationno": "VAT No : 749 8363 77", "defaultsalestax": 1, "defaultsalestaxlabel": "MwSt", "accountnumber": "40054837", "currencyid": 48, "sortcode": "090666", "status": 0, "isdefault": 1, "id": "25", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 34 }, { "organization_id": 26, "organizationname": "Test Company", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 3, "bankname": null, "comregistrationno": null, "defaultsalestax": 2, "defaultsalestaxlabel": "HST", "accountnumber": null, "currencyid": 3, "sortcode": null, "status": 0, "isdefault": 0, "id": "26", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 1 }, { "organization_id": 29, "organizationname": "Test", "address": "11 King St", "address2": null, "addres3": null, "city": null, "state": null, "country": null, "code": "FK5 4HD", "phone": null, "mobile1": null, "mobile2": null, "fax": null, "email3": null, "email1": null, "email2": null, "website": null, "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": null, "countryid": 18, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": null, "currencyid": 18, "sortcode": null, "status": 0, "isdefault": 0, "id": "29", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 1 }, { "organization_id": 30, "organizationname": "Tesdt Live", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 2, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "MwSt", "accountnumber": null, "currencyid": 2, "sortcode": null, "status": 0, "isdefault": 0, "id": "30", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 18, "updated_by": null }, { "organization_id": 31, "organizationname": "Test Five", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 3, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "MwSt", "accountnumber": null, "currencyid": 3, "sortcode": null, "status": 0, "isdefault": 0, "id": "31", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 18, "updated_by": null }, { "organization_id": 32, "organizationname": "Test Six", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 2, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "MwSt", "accountnumber": null, "currencyid": 2, "sortcode": null, "status": 0, "isdefault": 0, "id": "32", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 18, "updated_by": null } ], "updated": [ { "organization_id": 25, "organizationname": "Aquarius Blinds", "address": "Unit 1-245", "address2": "Church Road", "addres3": null, "city": "Mitcham", "state": "Surrey", "country": null, "code": "CR4 3BH", "phone": "020 8288 1081", "mobile1": null, "mobile2": "01273 020587", "fax": null, "email3": null, "email1": "santhoshmanokaran@blindmatrix.com", "email2": null, "website": null, "logoname": "aqblinds-logo.png", "logo": "122250-aqblinds-logo.png", "vatnumber": "3211231244132133", "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "SHADEWELL 1", "countryid": 48, "bankname": "Santander", "comregistrationno": "VAT No : 749 8363 77", "defaultsalestax": 1, "defaultsalestaxlabel": "MwSt", "accountnumber": "40054837", "currencyid": 48, "sortcode": "090666", "status": 0, "isdefault": 1, "id": "25", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 34 }, { "organization_id": 26, "organizationname": "Test Company", "address": "null", "address2": "null", "addres3": "null", "city": "null", "state": "null", "country": null, "code": "null", "phone": "null", "mobile1": "null", "mobile2": "null", "fax": "null", "email3": "null", "email1": "null", "email2": "null", "website": "null", "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": "null", "countryid": 3, "bankname": null, "comregistrationno": null, "defaultsalestax": 2, "defaultsalestaxlabel": "HST", "accountnumber": null, "currencyid": 3, "sortcode": null, "status": 0, "isdefault": 0, "id": "26", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 1 }, { "organization_id": 29, "organizationname": "Test", "address": "11 King St", "address2": null, "addres3": null, "city": null, "state": null, "country": null, "code": "FK5 4HD", "phone": null, "mobile1": null, "mobile2": null, "fax": null, "email3": null, "email1": null, "email2": null, "website": null, "logoname": null, "logo": null, "vatnumber": null, "vatrate": null, "settlementdiscount": null, "reportemailbody": null, "domesticpaymentterms": null, "contractpaymentterms": null, "tradepaymentterms": null, "companyterms": null, "countryid": 18, "bankname": null, "comregistrationno": null, "defaultsalestax": 1, "defaultsalestaxlabel": "GST", "accountnumber": null, "currencyid": 18, "sortcode": null, "status": 0, "isdefault": 0, "id": "29", "created_at": 1755241038, "updated_at": 1755241038, "created_by": 1, "updated_by": 1 } ], "deleted": [] }, "bm_applicationSetup": { "created": [], "updated": [], "deleted": [] }, "bm_price_setup": { "created": [], "updated": [], "deleted": [] }, "bm_calendarsetup": { "created": [], "updated": [], "deleted": [] }, "bm_appointmenttype": { "created": [], "updated": [], "deleted": [] }, "bm_userWorkDay": { "created": [], "updated": [], "deleted": [] }, "bm_users": { "created": [], "updated": [], "deleted": [] }, "custom_fields": { "created": [], "updated": [], "deleted": [] }, "customfieldvalues": { "created": [], "updated": [], "deleted": [] } }, "synctodelete": { "bm_orderitem": { "71755240650": 33473, "71755241578": 33474, "71755241718": 33475, "71755241151": 33476 }, "bm_option": { "171755240653": 3883 } }, "timestamp": 1755241551 }