{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [
{
"ctd_id": 1484,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 23, \"742\": 25, \"62\": \"OFFL0009\"}",
"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": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "1484",
"ctd_createdat": 1743494522,
"ctd_updatedat": 1743494590,
"ctd_createdby": 0,
"ctd_updatedby": null
}
],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [
{
"cci_id": 2732,
"cci_customerid": 1484,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":1,\"77\":\"Offline@7\",\"81\":1,\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"90\":35}",
"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": 2,
"cci_mobcustomertempid": 31743494522,
"id": "2732",
"cci_createdat": 1743494522,
"cci_updatedat": 1743494590,
"cci_createdby": 0,
"cci_updatedby": null
}
],
"deleted": []
},
"bm_appointment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_tasklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobdetails": {
"created": [
{
"jd_id": 2771,
"jd_customerid": 1484,
"jd_contactid": 2732,
"jd_additionalcontacts": "2732",
"jd_templateid": 1,
"jd_jobmultiquoteid": 2793,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "BD2661",
"jd_jobstatus": 3,
"jd_contactaddid": 0,
"jd_orderstatus": 2,
"jd_accref": "OFFL0009",
"jd_invoiceno": "",
"jd_listprice": "190.00",
"jd_netprice": "190.00",
"jd_vat": "17.34",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "207.34",
"jd_grossprofit": "95.00",
"jd_costprice": "95.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "207.34",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 9,
"jd_updatedby": 9,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "9.125",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2661\",\"35\":\"OFFL0009\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@7\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "9.125",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "2771",
"jd_createddate": 1743465600,
"jd_orderdate": null,
"jd_duedate": 1743465600,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1743494522,
"jd_updatedat": 1743494590
}
],
"updated": [
{
"jd_id": 2771,
"jd_customerid": 1484,
"jd_contactid": 2732,
"jd_additionalcontacts": "2732",
"jd_templateid": 1,
"jd_jobmultiquoteid": 2793,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "BD2661",
"jd_jobstatus": 3,
"jd_contactaddid": 0,
"jd_orderstatus": 2,
"jd_accref": "OFFL0009",
"jd_invoiceno": "",
"jd_listprice": "190.00",
"jd_netprice": "190.00",
"jd_vat": "17.34",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "207.34",
"jd_grossprofit": "95.00",
"jd_costprice": "95.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "207.34",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 9,
"jd_updatedby": 9,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "9.125",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2661\",\"35\":\"OFFL0009\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@7\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":9,\"633\":1,\"705\":\"\",\"718\":1,\"757\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "9.125",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "2771",
"jd_createddate": 1743465600,
"jd_orderdate": null,
"jd_duedate": 1743465600,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1743494522,
"jd_updatedat": 1743494590
}
],
"deleted": []
},
"bm_orderitem": {
"created": [
{
"oi_id": 6550,
"oi_jobid": 2760,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 2782,
"oi_productid": 5,
"oi_recipeid": 5,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 230,
"oi_customseq": 1,
"oi_productcustomseq": 668,
"oi_jsondata": "[{\"id\":15091,\"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\":15091,\"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\":33,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"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\":33,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":34,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"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\":34,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":36,\"labelname\":\"Slat Colour\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Slat Colour\",\"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\":13,\"mandatory\":0,\"fieldname\":\"Slat Colour\",\"fieldid\":36,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":61,\"labelname\":\"Color\",\"value\":null,\"valueid\":null,\"type\":20,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":20,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":61,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8605,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":8605,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8606,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":8606,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13885,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control 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\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":13885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":2084,\"labelname\":\"Reverse Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Reverse Roll\",\"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\":\"Reverse Roll\",\"fieldid\":2084,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "",
"oi_reportdescription": "##Quantity: 1##",
"oi_reporttitles": "##Quantity:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2374,\"value\":null,\"formula\":\"Quantity*10\",\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":873,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":19217,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Dimmer Emitter 4 Channels SOURCE\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":455,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":5,\"stockupdate\":0,\"fieldid\":12239,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"setup option\",\"list_option_name\":\"setup option\",\"list_description\":\"check stock updation\",\"list_option_code\":\"078\",\"list_unit_type\":\"Each\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2476,\"value\":null,\"formula\":\"Width\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2477,\"value\":null,\"formula\":\"Drop\",\"price\":\"-\",\"recipeid\":5,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"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\":\"0.00\",\"show_hide\":true,\"category\":4}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "0.000",
"oi_netprice": "0.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "0.000",
"oi_vatvalue": "9.125",
"oi_vatselected": 44,
"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": "[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "6550",
"oi_productiondate": 1743510181,
"oi_createdat": 1743510181,
"oi_updatedat": 1743490393,
"oi_createdby": 37,
"oi_updatedby": 37
},
{
"oi_id": 6551,
"oi_jobid": 2762,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 2784,
"oi_productid": 25,
"oi_recipeid": 25,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 230,
"oi_customseq": 1,
"oi_productcustomseq": 4,
"oi_jsondata": "[{\"id\":15111,\"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\":15111,\"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\":1748,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"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\":1748,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1749,\"labelname\":\"Supplier\",\"value\":null,\"valueid\":null,\"type\":17,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"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\":1749,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1751,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"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\":\"Room\",\"fieldid\":1751,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1752,\"labelname\":\"Blind or Recess\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Blind or Recess\",\"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 or Recess\",\"fieldid\":1752,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1753,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":1753,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1754,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":1754,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1750,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product 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\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":1750,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1766,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":1766,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1755,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"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\":\"Controls\",\"fieldid\":1755,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1756,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"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\":\"Brackets\",\"fieldid\":1756,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1757,\"labelname\":\"Bead Depth\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Bead Depth\",\"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\":\"Bead Depth\",\"fieldid\":1757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1758,\"labelname\":\"Rail Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Rail Colour\",\"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\":\"Rail Colour\",\"fieldid\":1758,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1759,\"labelname\":\"Side Rails\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Rails\",\"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\":\"Side Rails\",\"fieldid\":1759,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1760,\"labelname\":\"Side Profile\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Side Profile\",\"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\":\"Side Profile\",\"fieldid\":1760,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":1761,\"labelname\":\"Control Rod\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Rod\",\"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 Rod\",\"fieldid\":1761,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":14400,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"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\":\"Extras\",\"fieldid\":14400,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "",
"oi_reportdescription": "##Quantity: 1##",
"oi_reporttitles": "##Quantity:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2170,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2171,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2453,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":763,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":25,\"stockupdate\":0,\"fieldid\":3770,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"OptTest\",\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"oi_scanstatus": "",
"oi_operationworkroom_data": "[{\"link_id\":344,\"process_id\":190,\"product_id\":25,\"phc_id\":344,\"pd_id\":190,\"name\":\"SAMPLE ASSEM\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":345,\"process_id\":191,\"product_id\":25,\"phc_id\":345,\"pd_id\":191,\"name\":\"SAMPLE dispatch\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"},{\"link_id\":343,\"process_id\":189,\"product_id\":25,\"phc_id\":343,\"pd_id\":189,\"name\":\"sample officeCH\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"5.00\",\"phc_contractsellingprice\":\"5.00\",\"phc_tradesellingprice\":\"5.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"5.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"5.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"5.00\",\"price\":\"0.00\"}]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"15.00\",\"cost_with_discount\":\"15.00\",\"cost_with_markup\":\"15.00\",\"gross_price\":\"16.37\",\"vat_price\":\"1.37\"}",
"oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "15.000",
"oi_netprice": "15.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "1.370",
"oi_vatvalue": "9.125",
"oi_vatselected": 44,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "16.370",
"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": "15.750",
"oi_endcustomeroverridevatprice": "1.440",
"oi_endcustomeroverridegrossprice": "17.190",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[15111, 1748, 1749, 1751, 1752, 1753, 1754, 1750, 1766, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 14400]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "6551",
"oi_productiondate": 1743510246,
"oi_createdat": 1743510246,
"oi_updatedat": 1743490460,
"oi_createdby": 37,
"oi_updatedby": 37
},
{
"oi_id": 6552,
"oi_jobid": 2763,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 2785,
"oi_productid": 558,
"oi_recipeid": 711,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 230,
"oi_customseq": 1,
"oi_productcustomseq": 2,
"oi_jsondata": "[{\"id\":24667,\"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\":24667,\"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\":24666,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":null,\"type\":14,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Quantity\",\"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\":24666,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24668,\"labelname\":\"Supplier\",\"value\":2,\"valueid\":null,\"type\":17,\"optionid\":2,\"optionvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"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\":24668,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":2,\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":24669,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":24669,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24670,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":24670,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24671,\"labelname\":\"Price band\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Price band\",\"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\":13,\"mandatory\":0,\"fieldname\":\"Price band\",\"fieldid\":24671,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24672,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":24672,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24674,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"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\":\"Extras\",\"fieldid\":24674,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24675,\"labelname\":\"fff\",\"value\":null,\"valueid\":null,\"type\":4,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fff\",\"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\":4,\"mandatory\":0,\"fieldname\":\"fff\",\"fieldid\":24675,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24676,\"labelname\":\"fg\",\"value\":null,\"valueid\":null,\"type\":29,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"fg\",\"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\":29,\"mandatory\":0,\"fieldname\":\"fg\",\"fieldid\":24676,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "Supplier: Decora",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##",
"oi_reporttitles": "##Quantity:<\/br>##Supplier:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"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\":\"0.00\",\"show_hide\":true,\"category\":3}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "0.000",
"oi_netprice": "0.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "0.000",
"oi_vatvalue": "9.125",
"oi_vatselected": 44,
"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": "[24667, 24666, 24668, 24669, 24670, 24671, 24672, 24674, 24675, 24676]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "6552",
"oi_productiondate": 1743510279,
"oi_createdat": 1743510279,
"oi_updatedat": 1743490490,
"oi_createdby": 37,
"oi_updatedby": 37
},
{
"oi_id": 6561,
"oi_jobid": 2771,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 2793,
"oi_productid": 5,
"oi_recipeid": 5,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":15091,\"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\":33,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":34,\"labelname\":\"Supplier\",\"value\":\"53\",\"valueid\":\"\",\"type\":17,\"optionid\":\"53\",\"optionvalue\":[{\"id\":53,\"optionid\":53,\"optionname\":\"Live Source\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":36,\"labelname\":\"Slat Colour\",\"value\":783,\"valueid\":\"831\",\"type\":13,\"optionid\":\"783\",\"optionvalue\":[{\"id\":831,\"fieldid\":36,\"fieldoptionlinkid\":831,\"optionid\":783,\"mainsupplier\":\"53\",\"blindtypecode\":\"1\",\"optionname\":\"n\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":61,\"labelname\":\"Color\",\"value\":\"666\",\"valueid\":\"28409\",\"type\":20,\"optionid\":\"28409\",\"optionvalue\":[{\"optionid\":28409,\"optionname\":\"666\",\"optioncode\":\"\",\"optionquantity\":1,\"fieldoptionlinkid\":28409,\"forchildfieldoptionlinkid\":\"20_3_28409_1\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"optionimage\":\"\",\"subdatacount\":0,\"pricegroup\":\"n\",\"pricegroupid\":783}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8605,\"labelname\":\"Width\",\"value\":\"1000\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8606,\"labelname\":\"Drop\",\"value\":\"1000\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":13885,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":2084,\"labelname\":\"Reverse Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 1000, Drop: 1000",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 1000 mm##,##Drop: 1000 mm##",
"oi_reporttitles": "##Quantity:
##Supplier:
##Slat Colour:
##Color:
##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": "95.000",
"oi_netprice": "190.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "17.340",
"oi_vatvalue": "9.125",
"oi_vatselected": 44,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "207.340",
"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": "[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]",
"oi_deviceplatform": 2,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "6561",
"oi_productiondate": 1743494528,
"oi_createdat": 1743494555,
"oi_updatedat": null,
"oi_createdby": 9,
"oi_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_notelist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_deliveryaddresssetting": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobchecklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_Invoice": {
"created": [],
"updated": [],
"deleted": []
},
"bm_InvoiceDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_invoice_credit_note": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNote": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNoteDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_job_paymentlist": {
"created": [
{
"jp_id": 326,
"jp_job_id": 2771,
"jp_amount": "207.340",
"jp_amountoutstanding": "207.340",
"jp_paymentmethod": 14,
"jp_paymentcategory": 1,
"jp_paymenttype": 8,
"jp_surchargetype": 2,
"jp_surchargemethod": 2,
"jp_surchargeamount": "0.000",
"jp_surchargevalue": null,
"jp_surchargetotal": "207.340",
"jp_userid": 9,
"jp_decription": "",
"jp_deviceplatform": 2,
"jp_status": 0,
"jp_transfer": 0,
"jp_transfer_id": null,
"id": "326",
"jp_paiddate": 1743465600,
"jp_createdat": 1743494571,
"jp_updatedat": 1743494590,
"jp_createdby": 9,
"jp_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_OverPayment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_terms": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobmultiquote": {
"created": [
{
"jmq_id": 2793,
"jmq_jobid": 2771,
"jmq_quotationname": "Q1",
"jmq_isdefault": 0,
"jmq_isaccepted": 1,
"jmq_isdeclined": 0,
"jmq_acceptanceplatform": 0,
"jmq_ismigrated": 0,
"jmq_listprice": "190.00",
"jmq_netprice": "190.00",
"jmq_vat": "17.34",
"jmq_isvaton": 1,
"jmq_deliverycost": "0.00",
"jmq_deliverycosttypeid": 1,
"jmq_overridetypeid": 1,
"jmq_orderformprice": "0.00",
"jmq_editpricebyid": null,
"jmq_isroundon": 0,
"jmq_grossprice": "207.34",
"jmq_grossprofit": "95.00",
"jmq_costprice": "95.00",
"jmq_overrideprice": null,
"jmq_overridenetprice": null,
"jmq_overridevatprice": null,
"jmq_overridegrossprice": null,
"jmq_amountoutstanding": "0.00",
"jmq_totpaid": "207.34",
"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": 0,
"jmq_isonlineordersubmitted": 0,
"jmq_endcustomervatprice": null,
"jmq_endcustomeroverridetype": 0,
"jmq_endcustomeroverridevalue": null,
"jmq_endcustomeroverridenetprice": "0.00",
"jmq_endcustomeroverridevatprice": "0.00",
"jmq_endcustomeroverridegrossprice": "0.00",
"jmq_endcustomerdeliverycost": null,
"jmq_endcustomerdeliverycostinclvat": 0,
"jmq_endcustomerfittingcost": null,
"jmq_endcustomerfittingcostinclvat": 0,
"jmq_onlinedeliveryaddreddtype": 0,
"jmq_onlinedeliveryaddreddid": null,
"jmq_commission": "[]",
"jmq_commissionprice": "0.00",
"jmq_commissionsetting": 0,
"jmq_commissionaddedvalue": "0.00",
"jmq_deliveryvatperc": "9.125",
"jmq_cdeliveryvatperc": "9.125",
"id": "2793",
"jmq_duedate": 1743465600,
"jmq_sceduleddate": null,
"jmq_createdat": "1743494522.000000",
"jmq_updatedat": "1743494590.000000",
"jmq_createdby": 9,
"jmq_updatedby": 9
}
],
"updated": [
{
"jmq_id": 2793,
"jmq_jobid": 2771,
"jmq_quotationname": "Q1",
"jmq_isdefault": 0,
"jmq_isaccepted": 1,
"jmq_isdeclined": 0,
"jmq_acceptanceplatform": 0,
"jmq_ismigrated": 0,
"jmq_listprice": "190.00",
"jmq_netprice": "190.00",
"jmq_vat": "17.34",
"jmq_isvaton": 1,
"jmq_deliverycost": "0.00",
"jmq_deliverycosttypeid": 1,
"jmq_overridetypeid": 1,
"jmq_orderformprice": "0.00",
"jmq_editpricebyid": null,
"jmq_isroundon": 0,
"jmq_grossprice": "207.34",
"jmq_grossprofit": "95.00",
"jmq_costprice": "95.00",
"jmq_overrideprice": null,
"jmq_overridenetprice": null,
"jmq_overridevatprice": null,
"jmq_overridegrossprice": null,
"jmq_amountoutstanding": "0.00",
"jmq_totpaid": "207.34",
"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": 0,
"jmq_isonlineordersubmitted": 0,
"jmq_endcustomervatprice": null,
"jmq_endcustomeroverridetype": 0,
"jmq_endcustomeroverridevalue": null,
"jmq_endcustomeroverridenetprice": "0.00",
"jmq_endcustomeroverridevatprice": "0.00",
"jmq_endcustomeroverridegrossprice": "0.00",
"jmq_endcustomerdeliverycost": null,
"jmq_endcustomerdeliverycostinclvat": 0,
"jmq_endcustomerfittingcost": null,
"jmq_endcustomerfittingcostinclvat": 0,
"jmq_onlinedeliveryaddreddtype": 0,
"jmq_onlinedeliveryaddreddid": null,
"jmq_commission": "[]",
"jmq_commissionprice": "0.00",
"jmq_commissionsetting": 0,
"jmq_commissionaddedvalue": "0.00",
"jmq_deliveryvatperc": "9.125",
"jmq_cdeliveryvatperc": "9.125",
"id": "2793",
"jmq_duedate": 1743465600,
"jmq_sceduleddate": null,
"jmq_createdat": "1743494522.000000",
"jmq_updatedat": "1743494590.000000",
"jmq_createdby": 9,
"jmq_updatedby": 9
}
],
"deleted": []
},
"bm_jobstatus_tracks": {
"created": [
{
"jst_id": 2955,
"jst_jobid": 2771,
"jst_job_current_status": 3,
"id": "2955",
"jst_createdat": "1743494590.827917"
}
],
"updated": [],
"deleted": []
},
"bm_customindividuallogs": {
"created": [
{
"cl_id": 47405,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Job",
"cl_message": "new job has been created in Job",
"cl_event": "created",
"cl_subjectid": 2771,
"cl_subjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_parentid": 2771,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 9,
"cl_changedfrom": "null",
"cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"\":2,\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"Pruthvi\",\"First Name\":\"Offline@7\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":9,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2732\",\"Production Due Date\":\"2025-03-31\",\"Job Ref No\":\"BD2661\",\"Job Status\":\"Quote\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"190.00\",\"VAT Price\":\"17.34\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"207.34\",\"Gross Profit\":\"95.00\",\"Total CostPrice\":\"95.00\",\"Total Paid\":\"207.34\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}",
"cl_customproperties": "{\"attributes\":{\"jd_id\":2771,\"jd_customerid\":1484,\"jd_contactid\":2732,\"jd_additionalcontacts\":\"2732\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2661\\\",\\\"35\\\":\\\"OFFL0009\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":9,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Offline@7\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":9,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-03-31\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"BD2661\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"OFFL0009\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"190.00\",\"jd_netprice\":\"190.00\",\"jd_vat\":\"17.34\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":null,\"jd_isroundon\":0,\"jd_grossprice\":\"207.34\",\"jd_grossprofit\":\"95.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"95.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"0.00\",\"jd_totpaid\":\"207.34\",\"jd_creditlimit\":\"0.00\",\"jd_creditbalance\":\"0.00\",\"jd_overdue\":\"0.00\",\"jd_userdefinedarray\":null,\"jd_deliverycostid\":0,\"jd_iscostpriceon\":0,\"jd_xero_flag\":0,\"jd_isonlineorder\":1,\"jd_isonlineordersubmitted\":0,\"jd_endcustomervatprice\":null,\"jd_endcustomeroverridetype\":0,\"jd_endcustomeroverridevalue\":null,\"jd_endcustomeroverridenetprice\":\"0.00\",\"jd_endcustomeroverridevatprice\":\"0.00\",\"jd_endcustomeroverridegrossprice\":\"0.00\",\"jd_endcustomerdeliverycost\":null,\"jd_endcustomerdeliverycostinclvat\":0,\"jd_endcustomerfittingcost\":null,\"jd_endcustomerfittingcostinclvat\":0,\"jd_onlinedeliveryaddreddtype\":0,\"jd_onlinedeliveryaddreddid\":0,\"jd_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":9,\"jd_createdat\":\"2025-04-01T08:02:02.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T08:03:10.000000Z\",\"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\":\"9.125\",\"jd_custompricefields\":\"\",\"jd_cdeliveryvatperc\":\"9.125\",\"jd_commission\":\"[]\",\"jd_commissionprice\":\"0.00\",\"jd_commissionsetting\":0,\"jd_commissionaddedvalue\":\"0.00\",\"jd_onlineprefixseq\":null,\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":0,\"jd_rework_count\":0}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "47405",
"cl_createdat": "1743494590.000000",
"cl_updatedat": null
},
{
"cl_id": 47406,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Quotation",
"cl_message": "Q1 has been generated in BD2661",
"cl_event": "created",
"cl_subjectid": 2793,
"cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel",
"cl_parentid": 2771,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 9,
"cl_changedfrom": "null",
"cl_changedto": "{\"jmq_id\":2793,\"jmq_jobid\":2771,\"Quotation Name\":\"Q1\",\"jmq_isdefault\":0,\"Quotation\":\"Accepted\",\"jmq_isdeclined\":0,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"Production Due Date\":\"0000-00-00\",\"List Price\":\"190.00\",\"Net Price\":\"190.00\",\"VAT Price\":\"17.34\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"207.34\",\"Gross Profit\":\"95.00\",\"Total CostPrice\":\"95.00\",\"Amount Outstanding\":\"0.00\",\"Total Paid\":\"207.34\",\"jmq_creditlimit\":\"0.00\",\"jmq_creditbalance\":\"0.00\",\"jmq_overdue\":\"0.00\",\"jmq_deliverycostid\":0,\"Total Cost Price\":0,\"jmq_isonlineorder\":0,\"Is Online Order Submitted\":0,\"End Customer Override Type\":0,\"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\":0,\"End Customer Fitting Cost Include Vat\":0,\"Online Delivery Addreddtype\":0,\"Commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"Delivery Vat Percentage\":\"9.125\",\"Gross Profit Percentage\":\"0.00\",\"jmq_ready\":0}",
"cl_customproperties": "{\"attributes\":{\"jmq_id\":2793,\"jmq_jobid\":2771,\"jmq_quotationname\":\"Q1\",\"jmq_isdefault\":0,\"jmq_isaccepted\":1,\"jmq_isdeclined\":0,\"jmq_esignflag\":null,\"jmq_acceptanceplatform\":0,\"jmq_ismigrated\":0,\"jmq_duedate\":\"0000-00-00\",\"jmq_sceduleddate\":\"0000-00-00\",\"jmq_listprice\":\"190.00\",\"jmq_netprice\":\"190.00\",\"jmq_vat\":\"17.34\",\"jmq_isvaton\":1,\"jmq_deliverycost\":\"0.00\",\"jmq_deliverycosttypeid\":1,\"jmq_overridetypeid\":1,\"jmq_orderformprice\":\"0.00\",\"jmq_editpricebyid\":null,\"jmq_isroundon\":0,\"jmq_grossprice\":\"207.34\",\"jmq_grossprofit\":\"95.00\",\"jmq_costprice\":\"95.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"0.00\",\"jmq_totpaid\":\"207.34\",\"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\":0,\"jmq_isonlineordersubmitted\":0,\"jmq_endcustomervatprice\":null,\"jmq_endcustomeroverridetype\":0,\"jmq_endcustomeroverridevalue\":null,\"jmq_endcustomeroverridenetprice\":\"0.00\",\"jmq_endcustomeroverridevatprice\":\"0.00\",\"jmq_endcustomeroverridegrossprice\":\"0.00\",\"jmq_endcustomerdeliverycost\":null,\"jmq_endcustomerdeliverycostinclvat\":0,\"jmq_endcustomerfittingcost\":null,\"jmq_endcustomerfittingcostinclvat\":0,\"jmq_onlinedeliveryaddreddtype\":0,\"jmq_onlinedeliveryaddreddid\":null,\"jmq_commission\":\"[]\",\"jmq_commissionprice\":\"0.00\",\"jmq_commissionsetting\":0,\"jmq_commissionaddedvalue\":\"0.00\",\"jmq_deliveryvatperc\":\"9.125\",\"jmq_cdeliveryvatperc\":\"9.125\",\"jmq_createdby\":9,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T08:02:02.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "47406",
"cl_createdat": "1743494590.000000",
"cl_updatedat": null
},
{
"cl_id": 47407,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Job",
"cl_message": "Job has been updated the field Multi Quote Id",
"cl_event": "modified",
"cl_subjectid": 2771,
"cl_subjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_parentid": 2771,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 9,
"cl_changedfrom": "[]",
"cl_changedto": "{\"Multi Quote Id\":2793}",
"cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2793},\"old\":{\"jd_jobmultiquoteid\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "47407",
"cl_createdat": "1743494590.000000",
"cl_updatedat": null
},
{
"cl_id": 47408,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Line Item",
"cl_message": "Q1 - new item has been created in Line Item for the product of Wooden Venetians",
"cl_event": "created",
"cl_subjectid": 6561,
"cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_parentid": 2771,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 9,
"cl_changedfrom": "null",
"cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Live Source\",\" Slat Colour\":\" n\",\" Color\":\" 666\",\" Width\":\" 1000\",\" Drop\":\" 1000\"}",
"cl_customproperties": "{\"attributes\":{\"oi_id\":6561,\"oi_jobid\":2771,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2793,\"oi_credit_id\":0,\"oi_productid\":5,\"oi_recipeid\":5,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":15091,\\\"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\\\":33,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":34,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"53\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":17,\\\"optionid\\\":\\\"53\\\",\\\"optionvalue\\\":[{\\\"id\\\":53,\\\"optionid\\\":53,\\\"optionname\\\":\\\"Live Source\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":36,\\\"labelname\\\":\\\"Slat Colour\\\",\\\"value\\\":783,\\\"valueid\\\":\\\"831\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"783\\\",\\\"optionvalue\\\":[{\\\"id\\\":831,\\\"fieldid\\\":36,\\\"fieldoptionlinkid\\\":831,\\\"optionid\\\":783,\\\"mainsupplier\\\":\\\"53\\\",\\\"blindtypecode\\\":\\\"1\\\",\\\"optionname\\\":\\\"n\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":61,\\\"labelname\\\":\\\"Color\\\",\\\"value\\\":\\\"666\\\",\\\"valueid\\\":\\\"28409\\\",\\\"type\\\":20,\\\"optionid\\\":\\\"28409\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":28409,\\\"optionname\\\":\\\"666\\\",\\\"optioncode\\\":\\\"\\\",\\\"optionquantity\\\":1,\\\"fieldoptionlinkid\\\":28409,\\\"forchildfieldoptionlinkid\\\":\\\"20_3_28409_1\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"optionimage\\\":\\\"\\\",\\\"subdatacount\\\":0,\\\"pricegroup\\\":\\\"n\\\",\\\"pricegroupid\\\":783}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8605,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"1000\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8606,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"1000\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":13885,\\\"labelname\\\":\\\"Control Type\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":2084,\\\"labelname\\\":\\\"Reverse Roll\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 1000, Drop: 1000\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 1000 mm##,##Drop: 1000 mm##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:
##Supplier:
##Slat Colour:
##Color:
##Width:
##Drop:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 08:02:08\",\"oi_operationstatus\":null,\"oi_scanstatus\":\"\",\"oi_operationworkroom_data\":\"[]\",\"oi_operationcalender_data\":\"[]\",\"oi_operation_calculations\":\"[]\",\"oi_pricecomesfrom_calculations\":\"{}\",\"oi_pricetablepriceevenbom\":\"{}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"95.000\",\"oi_netprice\":\"190.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"17.340\",\"oi_vatvalue\":\"9.125\",\"oi_vatselected\":44,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"207.340\",\"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_platformlastupdatedfrom\":\"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_createdby\":9,\"oi_createdat\":\"2025-04-01T08:02:35.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]\",\"oi_deviceplatform\":2,\"oi_custompricefields\":\"\",\"oi_editransfer\":0,\"oi_apisup_orderid\":0,\"oi_commissionprice\":\"0.000\",\"oi_commissionvatprice\":\"0.000\",\"oi_jsondatabackup\":\"\",\"oi_stockdeduct\":0,\"oi_deductedstockdetails\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "47408",
"cl_createdat": "1743494590.000000",
"cl_updatedat": null
},
{
"cl_id": 47409,
"cl_logname": "model",
"cl_type": null,
"cl_modulename": "Production Due Date",
"cl_message": "Production Due Date has been updated",
"cl_event": "modified",
"cl_subjectid": 2771,
"cl_subjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_parentid": 2771,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 9,
"cl_changedfrom": "{\"Production Due Date\":\"2025-03-31\"}",
"cl_changedto": "{\"Production Due Date\":\"2025-04-01\"}",
"cl_customproperties": "{}",
"cl_attachment": null,
"cl_deviceplatform": "ios",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "47409",
"cl_createdat": "1743494590.000000",
"cl_updatedat": null
}
],
"updated": [],
"deleted": []
},
"bm_productInfo": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fields": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fieldOptionLink": {
"created": [],
"updated": [],
"deleted": []
},
"bm_option": {
"created": [],
"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": [],
"updated": [],
"deleted": []
},
"bm_applicationSetup": {
"created": [],
"updated": [],
"deleted": []
}
},
"synctodelete": {
"bm_customercontactinfo": {
"51743494522": 2732
},
"bm_customertemplatedata": {
"31743494522": 1484
},
"bm_jobdetails": {
"41743494522": 2771
},
"bm_jobmultiquote": {
"141743494522": 2793
},
"bm_orderitem": {
"71743494555": 6561
},
"bm_job_paymentlist": {
"81743494571": 326
}
},
"timestamp": 1743494590
}