{ "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 }, { "ctd_id": 1485, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"ZCLY8JWX\", \"63\": \"\", \"61\": 1, \"742\": 25, \"64\": 23}", "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,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,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,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,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,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559", "ctd_enabledproductonline": "4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,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,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,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,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "1485", "ctd_createdat": 1743495201, "ctd_updatedat": 1743495202, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 1486, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"61\": 1, \"63\": \"N\", \"64\": 23, \"742\": 25, \"62\": \"N0000001\"}", "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": "1486", "ctd_createdat": 1743495130, "ctd_updatedat": 1743495247, "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 }, { "cci_id": 2733, "cci_customerid": 1485, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"\",\"79\":\"\",\"78\":\"\",\"76\":\"\",\"81\":1,\"75\":1,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":35,\"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": "2733", "cci_createdat": 1743495202, "cci_updatedat": 1743495202, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 2734, "cci_customerid": 1486, "cci_templateid": 3, "roleid": 0, "cci_customizedarray": "{\"75\":1,\"77\":\"Naruto \",\"78\":\"748596321\",\"81\":6,\"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": 1, "cci_mobcustomertempid": 31743495130, "id": "2734", "cci_createdat": 1743495130, "cci_updatedat": 1743495247, "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 }, { "jd_id": 2772, "jd_customerid": 1485, "jd_contactid": 2733, "jd_additionalcontacts": "2733", "jd_templateid": 1, "jd_jobmultiquoteid": 2794, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2662", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "ZCLY8JWX", "jd_invoiceno": "", "jd_listprice": "114.26", "jd_netprice": "114.26", "jd_vat": "10.43", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "124.69", "jd_grossprofit": "0.00", "jd_costprice": "114.26", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "124.69", "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": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":23,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":1,\"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": "2772", "jd_createddate": 1743465600, "jd_orderdate": 1743465600, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743495202, "jd_updatedat": 1743495202 }, { "jd_id": 2773, "jd_customerid": 1486, "jd_contactid": 2734, "jd_additionalcontacts": "2734", "jd_templateid": 1, "jd_jobmultiquoteid": 2795, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2663", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "N0000001", "jd_invoiceno": "", "jd_listprice": "825.78", "jd_netprice": "825.78", "jd_vat": "74.56", "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": "900.34", "jd_grossprofit": "635.78", "jd_costprice": "190.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "780.34", "jd_totpaid": "120.00", "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": 40, "jd_updatedby": 40, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2663\",\"35\":\"N0000001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":40,\"44\":\"N\",\"45\":\"Naruto \",\"46\":\"\",\"47\":\"748596321\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":40,\"633\":6,\"705\":\"\",\"718\":1,\"757\":2,\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2773", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743495130, "jd_updatedat": 1743495248 } ], "updated": [ { "jd_id": 2769, "jd_customerid": 1482, "jd_contactid": 2730, "jd_additionalcontacts": "2730", "jd_templateid": 1, "jd_jobmultiquoteid": 2791, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2659", "jd_jobstatus": 6, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "GEOR0001", "jd_invoiceno": "IN406", "jd_listprice": "1138.78", "jd_netprice": "1138.78", "jd_vat": "103.91", "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": "1242.69", "jd_grossprofit": "0.00", "jd_costprice": "1138.78", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "1242.69", "jd_totpaid": "0.00", "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": 40, "jd_updatedby": 40, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2659\",\"35\":\"GEOR0001\",\"36\":6,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":40,\"44\":\"\",\"45\":\"George\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":40,\"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": "2769", "jd_createddate": 1743465600, "jd_orderdate": 1743465600, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494121, "jd_updatedat": 1743494385 }, { "jd_id": 2770, "jd_customerid": 1483, "jd_contactid": 2731, "jd_additionalcontacts": "2731", "jd_templateid": 1, "jd_jobmultiquoteid": 2792, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2660", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "OFFL0008", "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\":\"BD2660\",\"35\":\"OFFL0008\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":9,\"44\":\"\",\"45\":\"Offline@6\",\"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": "2770", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743494345, "jd_updatedat": 1743494451 }, { "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 }, { "jd_id": 2772, "jd_customerid": 1485, "jd_contactid": 2733, "jd_additionalcontacts": "2733", "jd_templateid": 1, "jd_jobmultiquoteid": 2794, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2662", "jd_jobstatus": 4, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "ZCLY8JWX", "jd_invoiceno": "", "jd_listprice": "114.26", "jd_netprice": "114.26", "jd_vat": "10.43", "jd_isvaton": 1, "jd_deliverycost": "0.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "124.69", "jd_grossprofit": "0.00", "jd_costprice": "114.26", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "124.69", "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": 1, "jd_updatedby": 1, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":23,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":1,\"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": "2772", "jd_createddate": 1743465600, "jd_orderdate": 1743465600, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743495202, "jd_updatedat": 1743495202 }, { "jd_id": 2773, "jd_customerid": 1486, "jd_contactid": 2734, "jd_additionalcontacts": "2734", "jd_templateid": 1, "jd_jobmultiquoteid": 2795, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "BD2663", "jd_jobstatus": 3, "jd_contactaddid": 0, "jd_orderstatus": 2, "jd_accref": "N0000001", "jd_invoiceno": "", "jd_listprice": "825.78", "jd_netprice": "825.78", "jd_vat": "74.56", "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": "900.34", "jd_grossprofit": "635.78", "jd_costprice": "190.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "780.34", "jd_totpaid": "120.00", "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": 40, "jd_updatedby": 40, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "9.125", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"BD2663\",\"35\":\"N0000001\",\"36\":3,\"37\":1,\"38\":\"\",\"39\":23,\"40\":2,\"41\":40,\"44\":\"N\",\"45\":\"Naruto \",\"46\":\"\",\"47\":\"748596321\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":35,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"470\":\"\",\"477\":\"\",\"584\":\"\",\"605\":\"\",\"606\":\"\",\"608\":40,\"633\":6,\"705\":\"\",\"718\":1,\"757\":2,\"countryText\":\"USA\"}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "9.125", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "2773", "jd_createddate": 1743465600, "jd_orderdate": null, "jd_duedate": 1743465600, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1743495130, "jd_updatedat": 1743495248 } ], "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 }, { "oi_id": 6562, "oi_jobid": 2772, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2794, "oi_productid": 18, "oi_recipeid": 18, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 17, "oi_jsondata": "[{\"id\":15104,\"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\":15104,\"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\":260,\"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\":260,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":261,\"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\":261,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2\",\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":263,\"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\":263,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":264,\"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\":264,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":265,\"labelname\":\"Width\",\"value\":\"1000\",\"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\":1,\"fieldname\":\"Width\",\"fieldid\":265,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":266,\"labelname\":\"Drop\",\"value\":\"2000\",\"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\":1,\"fieldname\":\"Drop\",\"fieldid\":266,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":262,\"labelname\":\"Product Type\",\"value\":243,\"valueid\":\"243\",\"type\":13,\"optionid\":243,\"optionvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"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\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":1,\"fieldname\":\"Product Type\",\"fieldid\":262,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":243,\"optionsvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":1047,\"labelname\":\"Fabric\",\"value\":\"Alta Blackout\",\"valueid\":\"2900\",\"type\":5,\"optionid\":\"2900\",\"optionvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"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\":1047,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":3757,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":701,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":2900,\"forchildsubfieldlinkid\":\"5_2_2900_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"8248\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":1047,\"hasstock\":1,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":1,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0,\"stock_not_available_err\":false,\"stock_not_available_name_array\":[]}],\"fieldInformation\":null,\"optiondefault\":\"2900\",\"optionsvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"editruleoverride\":1},{\"id\":3757,\"labelname\":\"Color\",\"value\":\"Frost\",\"valueid\":\"8248\",\"type\":5,\"optionid\":\"8248\",\"optionvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"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\":2,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":3757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"8248\",\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":267,\"labelname\":\"Scallops\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Scallops\",\"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\":\"Scallops\",\"fieldid\":267,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":268,\"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\":268,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":269,\"labelname\":\"Control Side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Side\",\"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\":269,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":270,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System 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\":\"System Type\",\"fieldid\":270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":272,\"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\":272,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":273,\"labelname\":\"Cassette\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Cassette\",\"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\":\"Cassette\",\"fieldid\":273,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":274,\"labelname\":\"Motorization\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorization\",\"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\":\"Motorization\",\"fieldid\":274,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":275,\"labelname\":\"Extras\",\"value\":\"Test Tube\",\"valueid\":\"19666\",\"type\":3,\"optionid\":\"4773\",\"optionvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Extras\",\"fieldid\":275,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"4773\",\"optionsvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"editruleoverride\":0},{\"id\":277,\"labelname\":\"Further Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Further Instructions\",\"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\":\"Further Instructions\",\"fieldid\":277,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Width: 1000, Drop: 2000, Product Type: FB Band D, Fabric: Alta Blackout, Color: Frost, Extras: Test Tube", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 1000 mm##,##Drop: 2000 mm##,##Product Type: FB Band D##,##Fabric: Alta Blackout##,##Color: Frost##,##Extras: Test Tube##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Color:<\/br>##Extras:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":1,\"value\":\"2.01\",\"formula\":\"Alloutputunit(Quantity_OptimizedFabricQty)*Quantity\",\"price\":\"40.26\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":\"8248\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2.01\"},{\"productionoveride\":0,\"id\":1285,\"value\":\"1.00\",\"formula\":\"Width*Quantity\",\"price\":\"10.00\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19666,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test Tube\",\"list_option_name\":\"Test Tube\",\"list_description\":null,\"list_option_code\":null,\"list_unit_type\":\"mm\",\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":1286,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19667,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1287,\"value\":null,\"formula\":\"Quantity*Width\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19668,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":26,\"value\":null,\"formula\":\"\\\"Decora\\\"\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":11260,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"optionname79\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2367,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":698,\"value\":\"0.990\",\"formula\":\"Width-Alloutputunit(10)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"0.990\"},{\"productionoveride\":0,\"id\":699,\"value\":\"1.980\",\"formula\":\"Drop-Alloutputunit(20)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.980\"},{\"productionoveride\":0,\"id\":700,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":186,\"process_id\":116,\"product_id\":18,\"phc_id\":186,\"pd_id\":116,\"name\":\"Assemble\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":69,\"process_id\":42,\"product_id\":18,\"phc_id\":69,\"pd_id\":42,\"name\":\"Stock pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":340,\"process_id\":186,\"product_id\":18,\"phc_id\":340,\"pd_id\":186,\"name\":\"dfsg\",\"phc_linkstations\":33,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"0.00\",\"phc_contractsellingprice\":\"0.00\",\"phc_tradesellingprice\":\"0.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"0.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"0.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"0.00\",\"price\":\"0.00\"},{\"link_id\":184,\"process_id\":114,\"product_id\":18,\"phc_id\":184,\"pd_id\":114,\"name\":\"Fabric cut\",\"phc_linkstations\":18,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"45 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":185,\"process_id\":115,\"product_id\":18,\"phc_id\":185,\"pd_id\":115,\"name\":\"Tube Cut\",\"phc_linkstations\":19,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"20.00\",\"phc_contractsellingprice\":\"20.00\",\"phc_tradesellingprice\":\"20.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"20.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"20.00\",\"Hour\\\/mins\":\"50 mins\",\"phc_processcostid\":1,\"markupprice\":\"20.00\",\"price\":\"0.00\"},{\"link_id\":68,\"process_id\":41,\"product_id\":18,\"phc_id\":68,\"pd_id\":41,\"name\":\"Office check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"30 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"64.00\",\"cost_with_discount\":\"64.00\",\"cost_with_markup\":\"64.00\",\"gross_price\":\"69.84\",\"vat_price\":\"5.84\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "114.260", "oi_netprice": "114.260", "oi_pricesfromoperations": null, "oi_vatprice": "10.430", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "124.690", "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": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "114.260", "oi_endcustomeroverridevatprice": "10.430", "oi_endcustomeroverridegrossprice": "124.690", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15104, 260, 261, 263, 264, 265, 266, 262, 1047, 3757, 267, 268, 269, 270, 272, 273, 274, 275, 277]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6562", "oi_productiondate": 1743514964, "oi_createdat": 1743514964, "oi_updatedat": 1743495202, "oi_createdby": 1, "oi_updatedby": 1 }, { "oi_id": 6563, "oi_jobid": 2773, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2795, "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\":1},{\"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\":\"509\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8606,\"labelname\":\"Drop\",\"value\":\"963\",\"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\":\"setup option\",\"valueid\":\"12239\",\"type\":3,\"optionid\":\"3900\",\"optionvalue\":[{\"optionid\":3900,\"optionname\":\"setup option\",\"description\":\"check stock updation\",\"optioncode\":\"078\",\"optionqty\":\"153\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":12239,\"forchildfieldoptionlinkid\":\"3_12239\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":12239}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"153\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 509, Drop: 963, Reverse Roll: setup option", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 509 mm##,##Drop: 963 mm##,##Reverse Roll: setup option##", "oi_reporttitles": "##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:##Reverse Roll:", "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": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6563", "oi_productiondate": 1743495138, "oi_createdat": 1743495180, "oi_updatedat": null, "oi_createdby": 40, "oi_updatedby": null }, { "oi_id": 6564, "oi_jobid": 2773, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2795, "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\":1},{\"id\":33,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"1\",\"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_2_28409_0\",\"minimumdiscount\":\"\",\"maximumdiscount\":\"\",\"subdatacount\":0,\"optionimage\":\"\",\"pricegroup\":\"n\",\"pricegroupid\":783}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8605,\"labelname\":\"Width\",\"value\":\"509\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":8606,\"labelname\":\"Drop\",\"value\":\"963\",\"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\":\"setup option\",\"valueid\":\"12239\",\"type\":3,\"optionid\":\"3900\",\"optionvalue\":[{\"optionid\":3900,\"optionname\":\"setup option\",\"description\":\"check stock updation\",\"optioncode\":\"078\",\"optionqty\":\"153\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":12239,\"forchildfieldoptionlinkid\":\"3_12239\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":12239}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"153\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1}]", "oi_description": "Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 509, Drop: 963, Reverse Roll: setup option", "oi_reportdescription": "##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 509 mm##,##Drop: 963 mm##,##Reverse Roll: setup option##", "oi_reporttitles": "##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:##Reverse Roll:", "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": "693.000", "oi_overridetype": 2, "oi_overridevalue": "693", "oi_overridenetprice": "635.780", "oi_overridevatprice": "57.220", "oi_overridegrossprice": "693.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 2, "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": 1, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6564", "oi_productiondate": 1743495138, "oi_createdat": 1743495208, "oi_updatedat": null, "oi_createdby": 40, "oi_updatedby": null } ], "updated": [ { "oi_id": 6562, "oi_jobid": 2772, "oi_jobtempid": "0", "oi_jobmultiquoteid": 2794, "oi_productid": 18, "oi_recipeid": 18, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 230, "oi_customseq": 1, "oi_productcustomseq": 17, "oi_jsondata": "[{\"id\":15104,\"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\":15104,\"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\":260,\"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\":260,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":261,\"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\":261,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2\",\"optionsvalue\":[{\"id\":2,\"optionid\":2,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":263,\"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\":263,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":264,\"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\":264,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":265,\"labelname\":\"Width\",\"value\":\"1000\",\"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\":1,\"fieldname\":\"Width\",\"fieldid\":265,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":266,\"labelname\":\"Drop\",\"value\":\"2000\",\"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\":1,\"fieldname\":\"Drop\",\"fieldid\":266,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":262,\"labelname\":\"Product Type\",\"value\":243,\"valueid\":\"243\",\"type\":13,\"optionid\":243,\"optionvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"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\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":1,\"fieldname\":\"Product Type\",\"fieldid\":262,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":243,\"optionsvalue\":[{\"id\":243,\"fieldid\":262,\"fieldoptionlinkid\":243,\"optionid\":243,\"mainsupplier\":\"2\",\"blindtypecode\":null,\"optionname\":\"FB Band D\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":1047,\"labelname\":\"Fabric\",\"value\":\"Alta Blackout\",\"valueid\":\"2900\",\"type\":5,\"optionid\":\"2900\",\"optionvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"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\":1047,\"subchild\":[{\"fieldtypeid\":5,\"labelnamecode\":\"Color\",\"fieldid\":3757,\"status\":0,\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":701,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"fabricorcolor\":2,\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"optionsbackup\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0},{\"optionid\":8249,\"optionname\":\"Platinum\",\"optioncode\":\"PLAT\",\"optionquantity\":1,\"fieldoptionlinkid\":8249,\"forchildfieldoptionlinkid\":\"5_3_8249_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editablecolumns\":[],\"subfieldlinkid\":2900,\"forchildsubfieldlinkid\":\"5_2_2900_1\",\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"optiondefault\":\"8248\",\"value\":null,\"issubfabric\":0,\"masterparentfieldid\":1047,\"hasstock\":1,\"subchild\":[],\"supplierid\":\"0\",\"editruleoverride\":1,\"linktopricegroup\":0,\"dualseq\":1,\"fieldInformation\":null,\"multiseq\":0,\"dumydata\":[],\"blindswidth\":0,\"stock_not_available_err\":false,\"stock_not_available_name_array\":[]}],\"fieldInformation\":null,\"optiondefault\":\"2900\",\"optionsvalue\":[{\"optionid\":2900,\"optionname\":\"Alta Blackout\",\"optioncode\":\"ROBALBO\",\"optionquantity\":1,\"fieldoptionlinkid\":2900,\"forchildfieldoptionlinkid\":\"5_2_2900_1\",\"optionimage\":null,\"subdatacount\":1,\"fabricmapid\":2900,\"pricegroup\":\"FB Band D\",\"pricegroupid\":243}],\"editruleoverride\":1},{\"id\":3757,\"labelname\":\"Color\",\"value\":\"Frost\",\"valueid\":\"8248\",\"type\":5,\"optionid\":\"8248\",\"optionvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"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\":2,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":3757,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"8248\",\"optionsvalue\":[{\"optionid\":8248,\"optionname\":\"Frost\",\"optioncode\":\"FROS\",\"optionquantity\":1,\"fieldoptionlinkid\":8248,\"forchildfieldoptionlinkid\":\"5_3_8248_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":null,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":267,\"labelname\":\"Scallops\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Scallops\",\"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\":\"Scallops\",\"fieldid\":267,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":268,\"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\":268,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":269,\"labelname\":\"Control Side\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Side\",\"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\":269,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":270,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System 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\":\"System Type\",\"fieldid\":270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":272,\"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\":272,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":273,\"labelname\":\"Cassette\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Cassette\",\"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\":\"Cassette\",\"fieldid\":273,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":274,\"labelname\":\"Motorization\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorization\",\"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\":\"Motorization\",\"fieldid\":274,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":275,\"labelname\":\"Extras\",\"value\":\"Test Tube\",\"valueid\":\"19666\",\"type\":3,\"optionid\":\"4773\",\"optionvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":1,\"fieldname\":\"Extras\",\"fieldid\":275,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"4773\",\"optionsvalue\":[{\"optionid\":4773,\"optionqty\":\"1\",\"optionname\":\"Test Tube\",\"optioncode\":null,\"description\":null,\"pricegroups\":null,\"unittype\":\"mm\",\"unitcost\":10,\"fieldoptionlinkid\":19666,\"forchildfieldoptionlinkid\":\"3_19666\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"10.00\",\"costprice\":10,\"costwithdiscount\":10,\"customersellingprice\":10,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":10}],\"editruleoverride\":0},{\"id\":277,\"labelname\":\"Further Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Further Instructions\",\"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\":\"Further Instructions\",\"fieldid\":277,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Width: 1000, Drop: 2000, Product Type: FB Band D, Fabric: Alta Blackout, Color: Frost, Extras: Test Tube", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 1000 mm##,##Drop: 2000 mm##,##Product Type: FB Band D##,##Fabric: Alta Blackout##,##Color: Frost##,##Extras: Test Tube##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Color:<\/br>##Extras:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":1,\"value\":\"2.01\",\"formula\":\"Alloutputunit(Quantity_OptimizedFabricQty)*Quantity\",\"price\":\"40.26\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":\"8248\",\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"2.01\"},{\"productionoveride\":0,\"id\":1285,\"value\":\"1.00\",\"formula\":\"Width*Quantity\",\"price\":\"10.00\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19666,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Test Tube\",\"list_option_name\":\"Test Tube\",\"list_description\":null,\"list_option_code\":null,\"list_unit_type\":\"mm\",\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":1286,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19667,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 2\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":1287,\"value\":null,\"formula\":\"Quantity*Width\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":19668,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Tube 3\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":26,\"value\":null,\"formula\":\"\\\"Decora\\\"\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":11260,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"optionname79\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":2367,\"value\":null,\"formula\":null,\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":698,\"value\":\"0.990\",\"formula\":\"Width-Alloutputunit(10)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"0.990\"},{\"productionoveride\":0,\"id\":699,\"value\":\"1.980\",\"formula\":\"Drop-Alloutputunit(20)\",\"price\":null,\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.980\"},{\"productionoveride\":0,\"id\":700,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"-\",\"recipeid\":18,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"}]", "oi_operationstatus": "0", "oi_scanstatus": "", "oi_operationworkroom_data": "[{\"link_id\":186,\"process_id\":116,\"product_id\":18,\"phc_id\":186,\"pd_id\":116,\"name\":\"Assemble\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":69,\"process_id\":42,\"product_id\":18,\"phc_id\":69,\"pd_id\":42,\"name\":\"Stock pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"12.00\",\"phc_contractsellingprice\":\"12.00\",\"phc_tradesellingprice\":\"12.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"12.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"12.00\",\"Hour\\\/mins\":\"15 mins\",\"phc_processcostid\":1,\"markupprice\":\"12.00\",\"price\":\"0.00\"},{\"link_id\":340,\"process_id\":186,\"product_id\":18,\"phc_id\":340,\"pd_id\":186,\"name\":\"dfsg\",\"phc_linkstations\":33,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"0.00\",\"phc_contractsellingprice\":\"0.00\",\"phc_tradesellingprice\":\"0.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"0.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"0.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"0.00\",\"price\":\"0.00\"},{\"link_id\":184,\"process_id\":114,\"product_id\":18,\"phc_id\":184,\"pd_id\":114,\"name\":\"Fabric cut\",\"phc_linkstations\":18,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"45 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":185,\"process_id\":115,\"product_id\":18,\"phc_id\":185,\"pd_id\":115,\"name\":\"Tube Cut\",\"phc_linkstations\":19,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"20.00\",\"phc_contractsellingprice\":\"20.00\",\"phc_tradesellingprice\":\"20.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"20.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"20.00\",\"Hour\\\/mins\":\"50 mins\",\"phc_processcostid\":1,\"markupprice\":\"20.00\",\"price\":\"0.00\"},{\"link_id\":68,\"process_id\":41,\"product_id\":18,\"phc_id\":68,\"pd_id\":41,\"name\":\"Office check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":1,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"30 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"}]", "oi_operationcalender_data": "[]", "oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"64.00\",\"cost_with_discount\":\"64.00\",\"cost_with_markup\":\"64.00\",\"gross_price\":\"69.84\",\"vat_price\":\"5.84\"}", "oi_pricecomesfrom_calculations": "[]", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "114.260", "oi_netprice": "114.260", "oi_pricesfromoperations": null, "oi_vatprice": "10.430", "oi_vatvalue": "9.125", "oi_vatselected": 44, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "124.690", "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": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "114.260", "oi_endcustomeroverridevatprice": "10.430", "oi_endcustomeroverridegrossprice": "124.690", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[15104, 260, 261, 263, 264, 265, 266, 262, 1047, 3757, 267, 268, 269, 270, 272, 273, 274, 275, 277]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "6562", "oi_productiondate": 1743514964, "oi_createdat": 1743514964, "oi_updatedat": 1743495202, "oi_createdby": 1, "oi_updatedby": 1 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 1235, "das_jobid": 2772, "das_appointmentaddress": 2733, "das_invoiceaddress": 2733, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "1235", "das_createdat": 1743495202, "das_updatedat": 1743495202, "das_createdby": 1, "das_updatedby": null } ], "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": 325, "jp_job_id": 2770, "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": "325", "jp_paiddate": 1743465600, "jp_createdat": 1743494440, "jp_updatedat": 1743494451, "jp_createdby": 9, "jp_updatedby": null }, { "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 }, { "jp_id": 327, "jp_job_id": 2773, "jp_amount": "20.000", "jp_amountoutstanding": "20.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "20.000", "jp_userid": 40, "jp_decription": "", "jp_deviceplatform": 1, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "327", "jp_paiddate": 1743465600, "jp_createdat": 1743495227, "jp_updatedat": 1743495248, "jp_createdby": 40, "jp_updatedby": null }, { "jp_id": 328, "jp_job_id": 2773, "jp_amount": "100.000", "jp_amountoutstanding": "100.000", "jp_paymentmethod": 14, "jp_paymentcategory": 1, "jp_paymenttype": 8, "jp_surchargetype": 2, "jp_surchargemethod": 2, "jp_surchargeamount": "0.000", "jp_surchargevalue": null, "jp_surchargetotal": "100.000", "jp_userid": 40, "jp_decription": "", "jp_deviceplatform": 1, "jp_status": 0, "jp_transfer": 0, "jp_transfer_id": null, "id": "328", "jp_paiddate": 1743465600, "jp_createdat": 1743495240, "jp_updatedat": 1743495248, "jp_createdby": 40, "jp_updatedby": null } ], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 9149, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 2, "termsName": "Standard", "termsDescription": "Testing Purpose<\/font>", "status": 0, "seq": 1, "id": "9149", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1722586185, "created_by": null, "updated_by": null }, { "termsid": 9150, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 2, "termsName": "Testing", "termsDescription": "On the way to customer", "status": 0, "seq": 2, "id": "9150", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1699013896, "created_by": 1, "updated_by": null }, { "termsid": 9151, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "Standard", "termsDescription": "Testing Purpose<\/font>", "status": 0, "seq": 1, "id": "9151", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1722585570, "created_by": null, "updated_by": null }, { "termsid": 9152, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "Testing", "termsDescription": "On the way to customer", "status": 0, "seq": 2, "id": "9152", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1722585570, "created_by": 1, "updated_by": null }, { "termsid": 9153, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 4, "termsName": "Standard", "termsDescription": "Testing Purpose<\/font>", "status": 0, "seq": 1, "id": "9153", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1722585570, "created_by": null, "updated_by": null }, { "termsid": 9154, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 4, "termsName": "Testing", "termsDescription": "On the way to customer", "status": 0, "seq": 2, "id": "9154", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1722585570, "created_by": 1, "updated_by": null }, { "termsid": 9155, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 2, "termsName": "Hap", "termsDescription": "RDFAYUh ]sghoisjg<\/font>
zsgsfh<\/font><\/div>", "status": 0, "seq": 4, "id": "9155", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1729580019, "created_by": 1, "updated_by": null }, { "termsid": 9156, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "Hap", "termsDescription": "RDFAYUh ]sghoisjg<\/font>
zsgsfh<\/font><\/div>", "status": 0, "seq": 3, "id": "9156", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1729580019, "created_by": 1, "updated_by": null }, { "termsid": 9157, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 4, "termsName": "Hap", "termsDescription": "RDFAYUh ]sghoisjg<\/font>
zsgsfh<\/font><\/div>", "status": 0, "seq": 3, "id": "9157", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1729580019, "created_by": 1, "updated_by": null }, { "termsid": 9158, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "hap 2", "termsDescription": "hap 3", "status": 0, "seq": 4, "id": "9158", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1730888314, "created_by": 1, "updated_by": null }, { "termsid": 9159, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 1, "termsName": "1", "termsDescription": "

<\/font><\/div>", "status": 0, "seq": 4, "id": "9159", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738231328, "created_by": 40, "updated_by": null }, { "termsid": 9160, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 2, "termsName": "monkey", "termsDescription": "im bharani<\/font>", "status": 0, "seq": 5, "id": "9160", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851021, "created_by": 40, "updated_by": null }, { "termsid": 9161, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "monkey", "termsDescription": "im bharani<\/font>", "status": 0, "seq": 5, "id": "9161", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851021, "created_by": 40, "updated_by": null }, { "termsid": 9162, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 4, "termsName": "monkey", "termsDescription": "im bharani<\/font>", "status": 0, "seq": 4, "id": "9162", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851021, "created_by": 40, "updated_by": null }, { "termsid": 9163, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 2, "termsName": "donkey", "termsDescription": "samme bharani<\/font>", "status": 0, "seq": 6, "id": "9163", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851119, "created_by": 40, "updated_by": null }, { "termsid": 9164, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 3, "termsName": "donkey", "termsDescription": "samme bharani<\/font>", "status": 0, "seq": 6, "id": "9164", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851119, "created_by": 40, "updated_by": null }, { "termsid": 9165, "orderid": 2772, "jobmultiquoteid": 2794, "isresportshow": 1, "termsCategory": 4, "termsName": "donkey", "termsDescription": "samme bharani<\/font>", "status": 0, "seq": 5, "id": "9165", "created_at": 1743495203, "updated_at": 1743495203, "terms_created_at": 1738851119, "created_by": 40, "updated_by": null } ], "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 }, { "jmq_id": 2794, "jmq_jobid": 2772, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "114.26", "jmq_netprice": "114.26", "jmq_vat": "10.43", "jmq_isvaton": 1, "jmq_deliverycost": "0.00", "jmq_deliverycosttypeid": 1, "jmq_overridetypeid": 1, "jmq_orderformprice": "0.00", "jmq_editpricebyid": 0, "jmq_isroundon": 0, "jmq_grossprice": "124.69", "jmq_grossprofit": "0.00", "jmq_costprice": "114.26", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "124.69", "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": "9.125", "jmq_cdeliveryvatperc": "9.125", "id": "2794", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743495202.000000", "jmq_updatedat": "1743495202.000000", "jmq_createdby": 1, "jmq_updatedby": null }, { "jmq_id": 2795, "jmq_jobid": 2773, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "825.78", "jmq_netprice": "825.78", "jmq_vat": "74.56", "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": "900.34", "jmq_grossprofit": "635.78", "jmq_costprice": "190.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "780.34", "jmq_totpaid": "120.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": 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": "2795", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743495130.000000", "jmq_updatedat": "1743495248.000000", "jmq_createdby": 40, "jmq_updatedby": 40 } ], "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 }, { "jmq_id": 2795, "jmq_jobid": 2773, "jmq_quotationname": "Q1", "jmq_isdefault": 0, "jmq_isaccepted": 1, "jmq_isdeclined": 0, "jmq_acceptanceplatform": 0, "jmq_ismigrated": 0, "jmq_listprice": "825.78", "jmq_netprice": "825.78", "jmq_vat": "74.56", "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": "900.34", "jmq_grossprofit": "635.78", "jmq_costprice": "190.00", "jmq_overrideprice": null, "jmq_overridenetprice": null, "jmq_overridevatprice": null, "jmq_overridegrossprice": null, "jmq_amountoutstanding": "780.34", "jmq_totpaid": "120.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": 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": "2795", "jmq_duedate": 1743465600, "jmq_sceduleddate": null, "jmq_createdat": "1743495130.000000", "jmq_updatedat": "1743495248.000000", "jmq_createdby": 40, "jmq_updatedby": 40 } ], "deleted": [] }, "bm_jobstatus_tracks": { "created": [ { "jst_id": 2954, "jst_jobid": 2770, "jst_job_current_status": 3, "id": "2954", "jst_createdat": "1743494416.185510" }, { "jst_id": 2955, "jst_jobid": 2771, "jst_job_current_status": 3, "id": "2955", "jst_createdat": "1743494590.827917" }, { "jst_id": 2956, "jst_jobid": 2772, "jst_job_current_status": 4, "id": "2956", "jst_createdat": "1743495202.387753" }, { "jst_id": 2957, "jst_jobid": 2773, "jst_job_current_status": 3, "id": "2957", "jst_createdat": "1743495247.856214" } ], "updated": [], "deleted": [] }, "bm_customindividuallogs": { "created": [ { "cl_id": 47400, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "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@6\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":9,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2731\",\"Production Due Date\":\"2025-03-31\",\"Job Ref No\":\"BD2660\",\"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\",\"Amount Outstanding\":\"207.34\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2770,\"jd_customerid\":1483,\"jd_contactid\":2731,\"jd_additionalcontacts\":\"2731\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2660\\\",\\\"35\\\":\\\"OFFL0008\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":9,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"Offline@6\\\",\\\"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\":\"BD2660\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"OFFL0008\",\"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\":\"207.34\",\"jd_totpaid\":\"0.00\",\"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-01T07:59:05.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T08:00:15.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": "47400", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47401, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in BD2660", "cl_event": "created", "cl_subjectid": 2792, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":2792,\"jmq_jobid\":2770,\"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\":\"0.00\",\"Total CostPrice\":\"95.00\",\"Amount Outstanding\":\"207.34\",\"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\":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\":2792,\"jmq_jobid\":2770,\"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\":\"0.00\",\"jmq_costprice\":\"95.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"207.34\",\"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\":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-01T07:59:05.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": "47401", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47402, "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": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 9, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":2792}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2792},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "ios", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47402", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47403, "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": 6560, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2770, "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\":6560,\"oi_jobid\":2770,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2792,\"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 07:59:13\",\"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-01T07:59:42.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": "47403", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "cl_id": 47404, "cl_logname": "model", "cl_type": null, "cl_modulename": "Production Due Date", "cl_message": "Production Due Date has been updated", "cl_event": "modified", "cl_subjectid": 2770, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2770, "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": "47404", "cl_createdat": "1743494416.000000", "cl_updatedat": null }, { "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 }, { "cl_id": 47411, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2772, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2772, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 1, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"admin\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":1,\"Role\":1,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2733\",\"Order Date\":\"2025-04-01\",\"Job Status\":\"Order\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"114.26\",\"VAT Price\":\"10.43\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"124.69\",\"Total CostPrice\":\"114.26\",\"Amount Outstanding\":\"124.69\",\"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\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\",\"Job Rework Enable\":\"On\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2772,\"jd_customerid\":1485,\"jd_contactid\":2733,\"jd_additionalcontacts\":\"2733\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"33\\\":25,\\\"37\\\":1,\\\"39\\\":23,\\\"41\\\":1,\\\"44\\\":\\\"\\\",\\\"45\\\":\\\"\\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":1,\\\"633\\\":1,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":1}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":\"2025-04-01\",\"jd_duedate\":\"0000-00-00\",\"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\":2,\"jd_accref\":\"\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"114.26\",\"jd_netprice\":\"114.26\",\"jd_vat\":\"10.43\",\"jd_isvaton\":1,\"jd_deliverycost\":\"0.00\",\"jd_deliverycosttypeid\":1,\"jd_overridetypeid\":1,\"jd_orderformprice\":\"0.00\",\"jd_editpricebyid\":0,\"jd_isroundon\":0,\"jd_grossprice\":\"124.69\",\"jd_grossprofit\":\"0.00\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"114.26\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"124.69\",\"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_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_sageexportdate\":null,\"jd_sage_flag\":0,\"jd_sage200_flag\":0,\"jd_seq\":0,\"jd_status\":0,\"jd_ready\":0,\"jd_createdby\":1,\"jd_createdat\":\"2025-04-01T08:13:22.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T08:13:22.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\":\"\",\"jd_fromjobrefwhole\":\"''\",\"jd_couponcodeid\":null,\"jd_endcustomerquotation\":0,\"jd_isrework\":0,\"jd_rework_enable\":1,\"jd_rework_count\":0}}", "cl_attachment": null, "cl_deviceplatform": "Desktop", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47411", "cl_createdat": "1743495202.000000", "cl_updatedat": null }, { "cl_id": 47435, "cl_logname": "default", "cl_type": null, "cl_modulename": "Job", "cl_message": "new job has been created in Job", "cl_event": "created", "cl_subjectid": 2773, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2773, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Organisation Name\":\"Blind Design (uk) Ltd\",\"\":\"USA\",\"Account Type\":\"Domestic\",\"Source\":\"WEB\",\"Created By\":\"Bharani\",\"Company Name\":\"N\",\"First Name\":\"Naruto \",\"Mobile\":\"748596321\",\"Country\":\"USA\",\"Salutation\":\"Mr.\",\"Check Box6\":\"Disabled\",\"Check Box5\":\"Disabled\",\"Assigned to\":40,\"Role\":6,\"Date4\":\"2025-04-01\",\"Additional Contacts\":\"2734\",\"Production Due Date\":\"2025-04-01\",\"Job Ref No\":\"BD2663\",\"Job Status\":\"Quote\",\"Order Status\":\"Ready to Start\",\"Net Price\":\"825.78\",\"VAT Price\":\"74.56\",\"VAT\":\"Enabled\",\"Delivery Cost\":\"All Options\",\"Gross Price Amount\":\"900.34\",\"Gross Profit\":\"635.78\",\"Total CostPrice\":\"190.00\",\"Amount Outstanding\":\"780.34\",\"Total Paid\":\"120.00\",\"jd_isonlineorder\":1,\"Delivery Vat Percentage\":\"9.125\",\"Commission\":\"[]\",\"jd_fromjobrefwhole\":\"''\"}", "cl_customproperties": "{\"attributes\":{\"jd_id\":2773,\"jd_customerid\":1486,\"jd_contactid\":2734,\"jd_additionalcontacts\":\"2734\",\"jd_templateid\":1,\"jd_jobmultiquoteid\":null,\"jd_jobcustomoizedkeyvalue\":\"{\\\"32\\\":\\\"\\\",\\\"33\\\":25,\\\"34\\\":\\\"BD2663\\\",\\\"35\\\":\\\"N0000001\\\",\\\"36\\\":3,\\\"37\\\":1,\\\"38\\\":\\\"\\\",\\\"39\\\":23,\\\"40\\\":2,\\\"41\\\":40,\\\"44\\\":\\\"N\\\",\\\"45\\\":\\\"Naruto \\\",\\\"46\\\":\\\"\\\",\\\"47\\\":\\\"748596321\\\",\\\"48\\\":\\\"\\\",\\\"49\\\":\\\"\\\",\\\"50\\\":\\\"\\\",\\\"51\\\":\\\"\\\",\\\"52\\\":\\\"\\\",\\\"53\\\":\\\"\\\",\\\"54\\\":35,\\\"285\\\":1,\\\"286\\\":\\\"\\\",\\\"287\\\":\\\"\\\",\\\"288\\\":\\\"\\\",\\\"289\\\":\\\"\\\",\\\"470\\\":\\\"\\\",\\\"477\\\":\\\"\\\",\\\"584\\\":\\\"\\\",\\\"605\\\":\\\"\\\",\\\"606\\\":\\\"\\\",\\\"608\\\":40,\\\"633\\\":6,\\\"705\\\":\\\"\\\",\\\"718\\\":1,\\\"757\\\":2,\\\"countryText\\\":\\\"USA\\\"}\",\"jd_deletedcustokeyvalue\":\"{}\",\"jd_createddate\":\"2025-04-01\",\"jd_orderdate\":null,\"jd_duedate\":\"2025-04-01\",\"jd_sceduleddate\":null,\"jd_invoicedate\":null,\"jd_completeddate\":null,\"jd_jobref\":\"BD2663\",\"jd_jobstatus\":3,\"jd_contactaddid\":0,\"jd_orderstatus\":2,\"jd_accref\":\"N0000001\",\"jd_invoiceno\":\"\",\"jd_listprice\":\"825.78\",\"jd_netprice\":\"825.78\",\"jd_vat\":\"74.56\",\"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\":\"900.34\",\"jd_grossprofit\":\"635.78\",\"jd_grossprofit_percentage\":\"0.00\",\"jd_costprice\":\"190.00\",\"jd_overrideprice\":null,\"jd_overridenetprice\":null,\"jd_overridevatprice\":null,\"jd_overridegrossprice\":null,\"jd_amountoutstanding\":\"780.34\",\"jd_totpaid\":\"120.00\",\"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\":40,\"jd_createdat\":\"2025-04-01T08:12:10.000000Z\",\"jd_updatedby\":null,\"jd_updatedat\":\"2025-04-01T08:14:07.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": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47435", "cl_createdat": "1743495247.000000", "cl_updatedat": null }, { "cl_id": 47436, "cl_logname": "default", "cl_type": null, "cl_modulename": "Quotation", "cl_message": "Q1 has been generated in BD2663", "cl_event": "created", "cl_subjectid": 2795, "cl_subjecttype": "App\\Models\\JobMultiQuotePivotModel", "cl_parentid": 2773, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"jmq_id\":2795,\"jmq_jobid\":2773,\"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\":\"825.78\",\"Net Price\":\"825.78\",\"VAT Price\":\"74.56\",\"VAT\":1,\"jmq_deliverycost\":\"0.00\",\"Delivery Cost\":1,\"jmq_overridetypeid\":1,\"Discount\":\"0.00\",\"Gross Price\":0,\"Gross Price Amount\":\"900.34\",\"Gross Profit\":\"635.78\",\"Total CostPrice\":\"190.00\",\"Amount Outstanding\":\"780.34\",\"Total Paid\":\"120.00\",\"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\":2795,\"jmq_jobid\":2773,\"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\":\"825.78\",\"jmq_netprice\":\"825.78\",\"jmq_vat\":\"74.56\",\"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\":\"900.34\",\"jmq_grossprofit\":\"635.78\",\"jmq_costprice\":\"190.00\",\"jmq_overrideprice\":null,\"jmq_overridenetprice\":null,\"jmq_overridevatprice\":null,\"jmq_overridegrossprice\":null,\"jmq_amountoutstanding\":\"780.34\",\"jmq_totpaid\":\"120.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\":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\":40,\"jmq_updatedby\":null,\"jmq_createdat\":\"2025-04-01T08:12:10.000000Z\",\"jmq_updatedat\":null,\"jmq_grossprofit_percentage\":\"0.00\",\"jmq_ready\":0}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47436", "cl_createdat": "1743495247.000000", "cl_updatedat": null }, { "cl_id": 47437, "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": 2773, "cl_subjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_parentid": 2773, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "[]", "cl_changedto": "{\"Multi Quote Id\":2795}", "cl_customproperties": "{\"attributes\":{\"jd_jobmultiquoteid\":2795},\"old\":{\"jd_jobmultiquoteid\":null}}", "cl_attachment": null, "cl_deviceplatform": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47437", "cl_createdat": "1743495247.000000", "cl_updatedat": null }, { "cl_id": 47438, "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": 6563, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2773, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Live Source\",\" Slat Colour\":\" n\",\" Color\":\" 666\",\" Width\":\" 509\",\" Drop\":\" 963\",\" Reverse Roll\":\" setup option\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6563,\"oi_jobid\":2773,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2795,\"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\\\":1},{\\\"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\\\":\\\"509\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8606,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"963\\\",\\\"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\\\":\\\"setup option\\\",\\\"valueid\\\":\\\"12239\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3900\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3900,\\\"optionname\\\":\\\"setup option\\\",\\\"description\\\":\\\"check stock updation\\\",\\\"optioncode\\\":\\\"078\\\",\\\"optionqty\\\":\\\"153\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":12239,\\\"forchildfieldoptionlinkid\\\":\\\"3_12239\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":12239}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"153\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 509, Drop: 963, Reverse Roll: setup option\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 509 mm##,##Drop: 963 mm##,##Reverse Roll: setup option##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:##Reverse Roll:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 08:12:18\",\"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\":40,\"oi_createdat\":\"2025-04-01T08:13:00.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]\",\"oi_deviceplatform\":1,\"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": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47438", "cl_createdat": "1743495247.000000", "cl_updatedat": null }, { "cl_id": 47439, "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": 6564, "cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem", "cl_parentid": 2773, "cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails", "cl_causerid": 40, "cl_changedfrom": "null", "cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Supplier\":\" Live Source\",\" Slat Colour\":\" n\",\" Color\":\" 666\",\" Width\":\" 509\",\" Drop\":\" 963\",\" Reverse Roll\":\" setup option\"}", "cl_customproperties": "{\"attributes\":{\"oi_id\":6564,\"oi_jobid\":2773,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":2795,\"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\\\":1},{\\\"id\\\":33,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"1\\\",\\\"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_2_28409_0\\\",\\\"minimumdiscount\\\":\\\"\\\",\\\"maximumdiscount\\\":\\\"\\\",\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"pricegroup\\\":\\\"n\\\",\\\"pricegroupid\\\":783}],\\\"fabricorcolor\\\":2,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8605,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"509\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":8606,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"963\\\",\\\"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\\\":\\\"setup option\\\",\\\"valueid\\\":\\\"12239\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"3900\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":3900,\\\"optionname\\\":\\\"setup option\\\",\\\"description\\\":\\\"check stock updation\\\",\\\"optioncode\\\":\\\"078\\\",\\\"optionqty\\\":\\\"153\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":12239,\\\"forchildfieldoptionlinkid\\\":\\\"3_12239\\\",\\\"hasstock\\\":1,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":12239}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"153\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Supplier: Live Source, Slat Colour: n, Color: 666, Width: 509, Drop: 963, Reverse Roll: setup option\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Supplier: Live Source##,##Slat Colour: n##,##Color: 666##,##Width: 509 mm##,##Drop: 963 mm##,##Reverse Roll: setup option##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:##Supplier:##Slat Colour:##Color:##Width:##Drop:##Reverse Roll:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-04-01 08:12:18\",\"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\":\"693.000\",\"oi_overridetype\":2,\"oi_overridevalue\":\"693\",\"oi_overridenetprice\":\"635.780\",\"oi_overridevatprice\":\"57.220\",\"oi_overridegrossprice\":\"693.000\",\"oi_ready\":0,\"oi_onhold\":0,\"oi_platformcreatedfrom\":\"web\",\"oi_platformlastupdatedfrom\":\"web\",\"oi_copiedfrom\":0,\"oi_isonlineorder\":0,\"oi_endcustomervatprice\":null,\"oi_endcustomeroverridetype\":2,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_status\":0,\"oi_createdby\":40,\"oi_createdat\":\"2025-04-01T08:13:28.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[15091, 33, 34, 36, 61, 8605, 8606, 13885, 2084]\",\"oi_deviceplatform\":1,\"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": "android", "cl_deviceipaddress": "", "cl_devicenameversion": "", "cl_devicelocation": "", "cl_causertype": "App\\Models\\BMUsers", "id": "47439", "cl_createdat": "1743495248.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": { "51743495130": 2734 }, "bm_customertemplatedata": { "31743495130": 1486 }, "bm_jobdetails": { "41743495130": 2773 }, "bm_jobmultiquote": { "141743495130": 2795 }, "bm_orderitem": { "71743495180": 6563, "71743495208": 6564 }, "bm_job_paymentlist": { "81743495227": 327, "81743495240": 328 } }, "timestamp": 1743495247 }