{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [],
"deleted": []
},
"bm_appointment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_tasklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobdetails": {
"created": [],
"updated": [
{
"jd_id": 12792,
"jd_customerid": 5893,
"jd_contactid": 7310,
"jd_additionalcontacts": "7310",
"jd_templateid": 1,
"jd_jobmultiquoteid": 12796,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "11458",
"jd_jobstatus": 4,
"jd_contactaddid": 0,
"jd_orderstatus": 3,
"jd_accref": "LIVE0001",
"jd_invoiceno": "",
"jd_listprice": "568.18",
"jd_netprice": "568.18",
"jd_vat": "113.64",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 2,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "681.82",
"jd_grossprofit": "-15.00",
"jd_costprice": "306.59",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "681.82",
"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": "15.00",
"jd_endcustomeroverridevatprice": "3.00",
"jd_endcustomeroverridegrossprice": "18.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 13,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "20.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":1,\"41\":13,\"44\":\"\",\"45\":\"\",\"46\":\"Live Test\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"62535333\",\"54\":19,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":13,\"558\":\"\",\"612\":\"\",\"614\":\"\",\"615\":\"\"}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "20.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "12792",
"jd_createddate": 1748563200,
"jd_orderdate": 1748563200,
"jd_duedate": 1748822400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1748622249,
"jd_updatedat": 1748845900
}
],
"deleted": []
},
"bm_orderitem": {
"created": [
{
"oi_id": 80485,
"oi_jobid": 0,
"oi_jobtempid": "c058a347",
"oi_jobmultiquoteid": null,
"oi_productid": 279,
"oi_recipeid": 279,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 66,
"oi_customseq": 1,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":24910,\"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\":24910,\"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\":24912,\"labelname\":\"Product Type\",\"value\":\"22\",\"valueid\":\"1845\",\"type\":13,\"optionid\":\"22\",\"optionvalue\":[{\"id\":1845,\"fieldid\":24912,\"fieldoptionlinkid\":1845,\"optionid\":22,\"mainsupplier\":\"31\",\"blindtypecode\":null,\"optionname\":\"Eyelet 5 Blackout Lining_BGC\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":24912,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"22\",\"optionsvalue\":[{\"id\":1845,\"fieldid\":24912,\"fieldoptionlinkid\":1845,\"optionid\":22,\"mainsupplier\":\"31\",\"blindtypecode\":null,\"optionname\":\"Eyelet 5 Blackout Lining_BGC\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":24909,\"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\":24909,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24911,\"labelname\":\"Supplier\",\"value\":\"31\",\"valueid\":null,\"type\":17,\"optionid\":\"31\",\"optionvalue\":[{\"id\":31,\"optionid\":31,\"optionname\":\"Blinds 2 Go\",\"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\":24911,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"31\",\"optionsvalue\":[{\"id\":31,\"optionid\":31,\"optionname\":\"Blinds 2 Go\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1}]",
"oi_description": "Product Type: Eyelet 5 Blackout Lining_BGC, Supplier: Blinds 2 Go",
"oi_reportdescription": "##Product Type: Eyelet 5 Blackout Lining_BGC##,##Quantity: 1##,##Supplier: Blinds 2 Go##",
"oi_reporttitles": "##Product Type:<\/br>##Quantity:<\/br>##Supplier:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":23,\"value\":\"0.11\",\"formula\":\"If(MaterialType=\\\"Standard\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\/1000)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":2,\"value\":null,\"formula\":\"If(MaterialType=\\\"Standard\\\",Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":3,\"value\":\"44.88\",\"formula\":\"Heading_PriceTablePrice\",\"price\":\"44.88\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"44.88\"},{\"productionoveride\":0,\"id\":4,\"value\":\"2.50\",\"formula\":\"If(Heading=\\\"Eyelet5_BGC\\\",2,If(Heading=\\\"PencilPleat5_BGC\\\",2,If(Heading=\\\"TwinPleat5_BGC\\\",2,If(Heading=\\\"Eyelet5BlackoutLining_BGC\\\",2,If(Heading=\\\"PencilPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"TwinPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal+BO_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"MachinedEyelet_CC\\\",1.8,If(Heading=\\\"MachinedPencilPleat_CC\\\",2.5,If(Heading=\\\"MachinedWave_CC\\\",2.3,If(Heading=\\\"MachinedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"MachinedTwinPleat_CC\\\",2.2,If(Heading=\\\"HandFinishedEyelet_CC\\\",1.8,If(Heading=\\\"HandFinishedPencilPleat_CC\\\",2,If(Heading=\\\"HandFinishedWave_CC\\\",2.3,If(Heading=\\\"HandFinishedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"SlotTop_CC\\\",2,If(Heading=\\\"PencilPleat-HandFinished_PCC\\\",2,If(Heading=\\\"PinchPleat-HandFinished_PCC\\\",2,If(Heading=\\\"Eyelet-HandFinished_PCC\\\",2,If(Heading=\\\"Wave-HandFinished_PCC\\\",2,If(Heading=\\\"PencilPleat-Machined_PCC\\\",2,If(Heading=\\\"PinchPleat-Machined_PCC\\\",2,If(Heading=\\\"Eyelet-Machined_PCC\\\",2,If(Heading=\\\"Wave-Machined_PCC\\\",2,If(Heading=\\\"Eyelet_WGC\\\",2,If(Heading=\\\"PencilPleat_WGC\\\",2,If(Heading=\\\"Wave_WGC\\\",2.3,If(Heading=\\\"Wave(lessfull)_WGC\\\",2.1,If(Heading=\\\"TriplePinchPleat_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleat_WGC\\\",2.3,If(Heading=\\\"SinglePleat_WGC\\\",2,If(Heading=\\\"EyeletWideWidth_WGC\\\",2,If(Heading=\\\"PencilPleatWideWidth_WGC\\\",2,If(Heading=\\\"WaveWideWidth_WGC\\\",2.3,If(Heading=\\\"TriplePinchPleatWideWidth_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleatWideWidth_WGC\\\",2,If(Heading=\\\"SinglePleatWideWidth_WGC\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"2.50\"},{\"productionoveride\":0,\"id\":6,\"value\":null,\"formula\":\"If(PairorSingle=\\\"Pair\\\",Widths*2,Widths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":7,\"value\":\"0.11\",\"formula\":\"((FabricQty)+Extrafabrictoorder)*Quantity\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":8,\"value\":null,\"formula\":\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":9,\"value\":null,\"formula\":\"Round(Widths*3,1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":10,\"value\":null,\"formula\":\"RoundUp(Widths,0)-1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":11,\"value\":null,\"formula\":\"if(UnitType=\\\"Inches\\\",(JoiningAllowance*25.4)\\\/10,if(UnitType=\\\"cm\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\"inches\\\",(SideTurningsDeduction*25.4)\\\/10,if(UnitType=\\\"cm\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":5,\"value\":null,\"formula\":\"IF(PairorSingle=\\\"Pair\\\",RoundUp(IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0)\\\/2,RoundUp((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness)\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":12,\"value\":\"294.50\",\"formula\":\"IF(UnitType=\\\"mm\\\",DropfromSuspensionPoint\\\/10,IF(UnitType=\\\"cm\\\",DropfromSuspensionPoint,IF(UnitType=\\\"inch\\\",(DropfromSuspensionPoint*25.4)\\\/10,DropfromSuspensionPoint\\\/100)))+IF(UnitType=\\\"inch\\\",(HeadingTurn*25.4),IF(UnitType=\\\"cm\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\"inch\\\",(HemTurn*25.4),IF(UnitType=\\\"cm\\\",HemTurn*10,HemTurn))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":13,\"value\":null,\"formula\":\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\/(Fabric_Patternrepeat\\\/10),0),\\\"0\\\")\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":14,\"value\":\"294.50\",\"formula\":\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\/10,1),FinishedCutLengths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":15,\"value\":null,\"formula\":\"RoundUp(Widths*If(MaterialType=\\\"Standard\\\",(Fabric_FabricRollWidth\\\/10),(If(MaterialType=\\\"Continuous\\\",(Fabric_FabricRollDrop\\\/10),\\\"\\\"))),0)-(Totalseamsandturnings)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":16,\"value\":null,\"formula\":\"Round(IF(PairorSingle=\\\"Pair\\\", Round(((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+(Leftreturn\\\/10))+(Rightreturn\\\/10+Overlap\\\/10*2)+(Springbacktolerance*2))\\\/2,2), (IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+Leftreturn\\\/10+Rightreturn\\\/10+Springbacktolerance)),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":17,\"value\":null,\"formula\":\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":18,\"value\":null,\"formula\":\"Round((Spaceallowancesfinishedwidth\\\/10-(If(Leftreturn>0,Leftreturn\\\/10,Leftreturn\\\/10)+If(Overlap>0,Overlap\\\/10,Overlap\\\/10)))\\\/Qtyofspaces,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":19,\"value\":null,\"formula\":\"Round((RoundUp(Spaceallowancesfinishedwidth\\\/10,0)-((Leftreturn\\\/10)+(Overlap\\\/10)))\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\/10*2),1),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":20,\"value\":null,\"formula\":\"Qtyofspaces+1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":21,\"value\":null,\"formula\":\"Round((Pleatsallowance)\\\/(Qtyofpleats),1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":22,\"value\":\"245.00\",\"formula\":\"if(OR(Heading=\\\"Eyelet_WGC\\\",Heading=\\\"PencilPleat_WGC\\\",Heading=\\\"Wave_WGC\\\",Heading=\\\"TriplePinchPleat_WGC\\\",Heading=\\\"DoublePinchPleat_WGC\\\"),DropfromSuspensionPoint+200,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"245.00\"},{\"productionoveride\":0,\"id\":89,\"value\":null,\"formula\":\"(RoundUp((DropfromSuspensionPoint+290)\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\/1000\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":98,\"value\":null,\"formula\":\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":99,\"value\":null,\"formula\":\"if(Border<>\\\"\\\",(TotalCost*0.2),0)\",\"price\":\"0.00\",\"recipeid\":57,\"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": "[]",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "0.000",
"oi_netprice": "0.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "0.000",
"oi_vatvalue": "20.000",
"oi_vatselected": 1,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "0.000",
"oi_overrideprice": "0.000",
"oi_overridetype": 2,
"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": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[24910, 24912, 24909, 24911]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "80485",
"oi_productiondate": 1748864475,
"oi_createdat": 1748864475,
"oi_updatedat": 1748844723,
"oi_createdby": 14,
"oi_updatedby": null
},
{
"oi_id": 80486,
"oi_jobid": 0,
"oi_jobtempid": "c058a347",
"oi_jobmultiquoteid": null,
"oi_productid": 276,
"oi_recipeid": 276,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 67,
"oi_customseq": 2,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":24899,\"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\":24899,\"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\":24901,\"labelname\":\"Product Type\",\"value\":\"87\",\"valueid\":\"1842\",\"type\":13,\"optionid\":\"87\",\"optionvalue\":[{\"id\":1842,\"fieldid\":24901,\"fieldoptionlinkid\":1842,\"optionid\":87,\"mainsupplier\":\"15\",\"blindtypecode\":null,\"optionname\":\"Range 6+5per_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":0,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":24901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"87\",\"optionsvalue\":[{\"id\":1842,\"fieldid\":24901,\"fieldoptionlinkid\":1842,\"optionid\":87,\"mainsupplier\":\"15\",\"blindtypecode\":null,\"optionname\":\"Range 6+5per_EX_RB\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":24898,\"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\":24898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":24900,\"labelname\":\"Supplier\",\"value\":\"15\",\"valueid\":null,\"type\":17,\"optionid\":\"15\",\"optionvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"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\":24900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"15\",\"optionsvalue\":[{\"id\":15,\"optionid\":15,\"optionname\":\"Excel\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":1}]",
"oi_description": "Product Type: Range 6+5per_EX_RB, Supplier: Excel",
"oi_reportdescription": "##Product Type: Range 6+5per_EX_RB##,##Quantity: 1##,##Supplier: Excel##",
"oi_reporttitles": "##Product Type:<\/br>##Quantity:<\/br>##Supplier:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":23,\"value\":\"0.11\",\"formula\":\"If(MaterialType=\\\"Standard\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\/1000)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":2,\"value\":null,\"formula\":\"If(MaterialType=\\\"Standard\\\",Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\"Standard\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\",\"price\":\"0.00\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":3,\"value\":\"44.88\",\"formula\":\"Heading_PriceTablePrice\",\"price\":\"44.88\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"44.88\"},{\"productionoveride\":0,\"id\":4,\"value\":\"2.50\",\"formula\":\"If(Heading=\\\"Eyelet5_BGC\\\",2,If(Heading=\\\"PencilPleat5_BGC\\\",2,If(Heading=\\\"TwinPleat5_BGC\\\",2,If(Heading=\\\"Eyelet5BlackoutLining_BGC\\\",2,If(Heading=\\\"PencilPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"TwinPleat5BlackoutLining_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal_BGC\\\",2,If(Heading=\\\"Eyelet5Thermal+BO_BGC\\\",2,If(Heading=\\\"PencilPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"TwinPleat5Thermal+BO_BGC\\\",2,If(Heading=\\\"MachinedEyelet_CC\\\",1.8,If(Heading=\\\"MachinedPencilPleat_CC\\\",2.5,If(Heading=\\\"MachinedWave_CC\\\",2.3,If(Heading=\\\"MachinedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"MachinedTwinPleat_CC\\\",2.2,If(Heading=\\\"HandFinishedEyelet_CC\\\",1.8,If(Heading=\\\"HandFinishedPencilPleat_CC\\\",2,If(Heading=\\\"HandFinishedWave_CC\\\",2.3,If(Heading=\\\"HandFinishedTriplePinchPleat_CC\\\",2.2,If(Heading=\\\"SlotTop_CC\\\",2,If(Heading=\\\"PencilPleat-HandFinished_PCC\\\",2,If(Heading=\\\"PinchPleat-HandFinished_PCC\\\",2,If(Heading=\\\"Eyelet-HandFinished_PCC\\\",2,If(Heading=\\\"Wave-HandFinished_PCC\\\",2,If(Heading=\\\"PencilPleat-Machined_PCC\\\",2,If(Heading=\\\"PinchPleat-Machined_PCC\\\",2,If(Heading=\\\"Eyelet-Machined_PCC\\\",2,If(Heading=\\\"Wave-Machined_PCC\\\",2,If(Heading=\\\"Eyelet_WGC\\\",2,If(Heading=\\\"PencilPleat_WGC\\\",2,If(Heading=\\\"Wave_WGC\\\",2.3,If(Heading=\\\"Wave(lessfull)_WGC\\\",2.1,If(Heading=\\\"TriplePinchPleat_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleat_WGC\\\",2.3,If(Heading=\\\"SinglePleat_WGC\\\",2,If(Heading=\\\"EyeletWideWidth_WGC\\\",2,If(Heading=\\\"PencilPleatWideWidth_WGC\\\",2,If(Heading=\\\"WaveWideWidth_WGC\\\",2.3,If(Heading=\\\"TriplePinchPleatWideWidth_WGC\\\",2.5,If(Heading=\\\"DoublePinchPleatWideWidth_WGC\\\",2,If(Heading=\\\"SinglePleatWideWidth_WGC\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"2.50\"},{\"productionoveride\":0,\"id\":6,\"value\":null,\"formula\":\"If(PairorSingle=\\\"Pair\\\",Widths*2,Widths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":7,\"value\":\"0.11\",\"formula\":\"((FabricQty)+Extrafabrictoorder)*Quantity\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":\"0.11\"},{\"productionoveride\":0,\"id\":8,\"value\":null,\"formula\":\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":0,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":9,\"value\":null,\"formula\":\"Round(Widths*3,1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":10,\"value\":null,\"formula\":\"RoundUp(Widths,0)-1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":11,\"value\":null,\"formula\":\"if(UnitType=\\\"Inches\\\",(JoiningAllowance*25.4)\\\/10,if(UnitType=\\\"cm\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\"inches\\\",(SideTurningsDeduction*25.4)\\\/10,if(UnitType=\\\"cm\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":5,\"value\":null,\"formula\":\"IF(PairorSingle=\\\"Pair\\\",RoundUp(IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0)\\\/2,RoundUp((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"inch\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"inch\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))*DefaultFullness)\\\/If(MaterialType=\\\"Standard\\\",Fabric_FabricRollWidth\\\/10,Fabric_FabricRollDrop\\\/10),0))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":12,\"value\":\"294.50\",\"formula\":\"IF(UnitType=\\\"mm\\\",DropfromSuspensionPoint\\\/10,IF(UnitType=\\\"cm\\\",DropfromSuspensionPoint,IF(UnitType=\\\"inch\\\",(DropfromSuspensionPoint*25.4)\\\/10,DropfromSuspensionPoint\\\/100)))+IF(UnitType=\\\"inch\\\",(HeadingTurn*25.4),IF(UnitType=\\\"cm\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\"inch\\\",(HemTurn*25.4),IF(UnitType=\\\"cm\\\",HemTurn*10,HemTurn))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":13,\"value\":null,\"formula\":\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\/(Fabric_Patternrepeat\\\/10),0),\\\"0\\\")\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":14,\"value\":\"294.50\",\"formula\":\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\/10,1),FinishedCutLengths)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"294.50\"},{\"productionoveride\":0,\"id\":15,\"value\":null,\"formula\":\"RoundUp(Widths*If(MaterialType=\\\"Standard\\\",(Fabric_FabricRollWidth\\\/10),(If(MaterialType=\\\"Continuous\\\",(Fabric_FabricRollDrop\\\/10),\\\"\\\"))),0)-(Totalseamsandturnings)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":16,\"value\":null,\"formula\":\"Round(IF(PairorSingle=\\\"Pair\\\", Round(((IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+(Leftreturn\\\/10))+(Rightreturn\\\/10+Overlap\\\/10*2)+(Springbacktolerance*2))\\\/2,2), (IF(UnitType=\\\"mm\\\",WidthofTrackPole\\\/10,IF(UnitType=\\\"Inches\\\",(WidthofTrackPole*25.4)\\\/10,IF(UnitType=\\\"Inches\\\",WidthofTrackPole\\\/100,WidthofTrackPole)))+Leftreturn\\\/10+Rightreturn\\\/10+Springbacktolerance)),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":17,\"value\":null,\"formula\":\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":18,\"value\":null,\"formula\":\"Round((Spaceallowancesfinishedwidth\\\/10-(If(Leftreturn>0,Leftreturn\\\/10,Leftreturn\\\/10)+If(Overlap>0,Overlap\\\/10,Overlap\\\/10)))\\\/Qtyofspaces,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":19,\"value\":null,\"formula\":\"Round((RoundUp(Spaceallowancesfinishedwidth\\\/10,0)-((Leftreturn\\\/10)+(Overlap\\\/10)))\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\/10*2),1),0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":20,\"value\":null,\"formula\":\"Qtyofspaces+1\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":21,\"value\":null,\"formula\":\"Round((Pleatsallowance)\\\/(Qtyofpleats),1)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":22,\"value\":\"245.00\",\"formula\":\"if(OR(Heading=\\\"Eyelet_WGC\\\",Heading=\\\"PencilPleat_WGC\\\",Heading=\\\"Wave_WGC\\\",Heading=\\\"TriplePinchPleat_WGC\\\",Heading=\\\"DoublePinchPleat_WGC\\\"),DropfromSuspensionPoint+200,0)\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"245.00\"},{\"productionoveride\":0,\"id\":89,\"value\":null,\"formula\":\"(RoundUp((DropfromSuspensionPoint+290)\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\/1000\",\"price\":\"-\",\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":98,\"value\":null,\"formula\":\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\",\"price\":null,\"recipeid\":57,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":99,\"value\":null,\"formula\":\"if(Border<>\\\"\\\",(TotalCost*0.2),0)\",\"price\":\"0.00\",\"recipeid\":57,\"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\":3}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "0.000",
"oi_netprice": "0.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "0.000",
"oi_vatvalue": "20.000",
"oi_vatselected": 1,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "0.000",
"oi_overrideprice": "0.000",
"oi_overridetype": 2,
"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": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[24899, 24901, 24898, 24900]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "80486",
"oi_productiondate": 1748864495,
"oi_createdat": 1748864495,
"oi_updatedat": 1748844723,
"oi_createdby": 14,
"oi_updatedby": null
},
{
"oi_id": 80487,
"oi_jobid": 12792,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 12796,
"oi_productid": 191,
"oi_recipeid": 191,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":19392,\"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\":19391,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19393,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19394,\"labelname\":\"Size\",\"value\":\"Profile Only\",\"valueid\":\"54517\",\"type\":3,\"optionid\":\"37992\",\"optionvalue\":[{\"optionid\":37992,\"optionname\":\"Profile Only\",\"description\":\"\",\"optioncode\":4198,\"pricegroups\":\"\",\"optionqty\":1,\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":54517,\"forchildfieldoptionlinkid\":\"3_54517\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19395,\"labelname\":\"Width\",\"value\":\"900\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":19396,\"labelname\":\"Drop\",\"value\":\"900\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":19397,\"labelname\":\"Profile\",\"value\":\"C Series C110x150,C Series C130x160\",\"valueid\":\"54528,54539\",\"type\":3,\"optionid\":\"38010,38001\",\"optionvalue\":[{\"optionid\":38001,\"optionname\":\"C Series C110x150\",\"description\":\"\",\"optioncode\":27769,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":130.01,\"pricingtype\":\"\",\"fieldoptionlinkid\":54528,\"forchildfieldoptionlinkid\":\"3_54528\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":\"\",\"reportprice\":\"260.02\",\"fieldid\":54528},{\"optionid\":38010,\"optionname\":\"C Series C130x160\",\"description\":\"\",\"optioncode\":27773,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":146.58,\"pricingtype\":\"\",\"fieldoptionlinkid\":54539,\"forchildfieldoptionlinkid\":\"3_54539\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":2,\"optionimage\":\"\",\"reportprice\":\"293.16\",\"fieldid\":54539}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1,1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":19402,\"labelname\":\"Front Corner\",\"value\":\"U Upstand flange\",\"valueid\":\"54544\",\"type\":3,\"optionid\":\"38014\",\"optionvalue\":[{\"optionid\":38014,\"optionname\":\"U Upstand flange\",\"description\":\"\",\"optioncode\":74454,\"pricegroups\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":54544,\"forchildfieldoptionlinkid\":\"3_54544\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":\"\",\"reportprice\":\"0.00\",\"fieldid\":54544}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":19403,\"labelname\":\"Back Corner\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19400,\"labelname\":\"Front Corner\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19401,\"labelname\":\"Back Corner\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19410,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19411,\"labelname\":\"Blind Information\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19412,\"labelname\":\"Fitting\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19413,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":19414,\"labelname\":\"Workroom Notes\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Size: Profile Only, Width: 900, Drop: 900, Profile: C Series C110x150,C Series C130x160, Front Corner: U Upstand flange",
"oi_reportdescription": "##Quantity: 1##,##Size: Profile Only##,##Width: 900 mm##,##Drop: 900 mm##,##Profile: C Series C110x150,C Series C130x160##,##Front Corner: U Upstand flange##",
"oi_reporttitles": "##Quantity:
##Size:
##Width:
##Drop:
##Profile:
##Front Corner:",
"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": "276.590",
"oi_netprice": "553.180",
"oi_pricesfromoperations": null,
"oi_vatprice": "110.640",
"oi_vatvalue": "20.000",
"oi_vatselected": 1,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "663.820",
"oi_overrideprice": "0.000",
"oi_overridetype": 2,
"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": 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": "[19392, 19391, 19393, 19394, 19395, 19396, 19397, 19402, 19403, 19400, 19401, 19410, 19411, 19412, 19413, 19414]",
"oi_deviceplatform": 1,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "80487",
"oi_productiondate": 1748845872,
"oi_createdat": 1748845893,
"oi_updatedat": 1748845900,
"oi_createdby": 1,
"oi_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_notelist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_deliveryaddresssetting": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobchecklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_Invoice": {
"created": [],
"updated": [],
"deleted": []
},
"bm_InvoiceDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_invoice_credit_note": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNote": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNoteDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_job_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_OverPayment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_terms": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobmultiquote": {
"created": [],
"updated": [
{
"jmq_id": 12796,
"jmq_jobid": 12792,
"jmq_quotationname": "Q1",
"jmq_isdefault": 0,
"jmq_isaccepted": 1,
"jmq_isdeclined": 0,
"jmq_acceptanceplatform": 0,
"jmq_ismigrated": 0,
"jmq_listprice": "568.18",
"jmq_netprice": "568.18",
"jmq_vat": "113.64",
"jmq_isvaton": 1,
"jmq_deliverycost": "0.00",
"jmq_deliverycosttypeid": 1,
"jmq_overridetypeid": 2,
"jmq_orderformprice": "0.00",
"jmq_editpricebyid": 0,
"jmq_isroundon": 0,
"jmq_grossprice": "681.82",
"jmq_grossprofit": "-15.00",
"jmq_costprice": "306.59",
"jmq_overrideprice": null,
"jmq_overridenetprice": null,
"jmq_overridevatprice": null,
"jmq_overridegrossprice": null,
"jmq_amountoutstanding": "681.82",
"jmq_totpaid": "0.00",
"jmq_creditlimit": "0.00",
"jmq_creditbalance": "0.00",
"jmq_overdue": "0.00",
"jmq_userdefinedarray": "\"\"",
"jmq_deliverycostid": 0,
"jmq_iscostpriceon": 0,
"jmq_custompricefields": "",
"jmq_isonlineorder": 1,
"jmq_isonlineordersubmitted": 0,
"jmq_endcustomervatprice": null,
"jmq_endcustomeroverridetype": 1,
"jmq_endcustomeroverridevalue": null,
"jmq_endcustomeroverridenetprice": "15.00",
"jmq_endcustomeroverridevatprice": "3.00",
"jmq_endcustomeroverridegrossprice": "18.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": "20.000",
"jmq_cdeliveryvatperc": "20.000",
"id": "12796",
"jmq_duedate": 1748822400,
"jmq_sceduleddate": null,
"jmq_createdat": "0.000000",
"jmq_updatedat": "1748845900.000000",
"jmq_createdby": 13,
"jmq_updatedby": 1
}
],
"deleted": []
},
"bm_jobstatus_tracks": {
"created": [],
"updated": [],
"deleted": []
},
"bm_customindividuallogs": {
"created": [
{
"cl_id": 33245,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Line Item",
"cl_message": "new item has been created in Line Item for the product of Curtain 05",
"cl_event": "created",
"cl_subjectid": 80485,
"cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_parentid": 80485,
"cl_parentsubjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_causerid": 14,
"cl_changedfrom": "null",
"cl_changedto": "{\"Product Type\":\" Eyelet 5 Blackout Lining_BGC\",\" Supplier\":\" Blinds 2 Go\"}",
"cl_customproperties": "{\"attributes\":{\"oi_id\":80485,\"oi_jobid\":0,\"oi_jobtempid\":\"c058a347\",\"oi_jobmultiquoteid\":null,\"oi_credit_id\":0,\"oi_productid\":279,\"oi_recipeid\":279,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":66,\"oi_customseq\":1,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":24910,\\\"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\\\":24910,\\\"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\\\":24912,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"22\\\",\\\"valueid\\\":\\\"1845\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"22\\\",\\\"optionvalue\\\":[{\\\"id\\\":1845,\\\"fieldid\\\":24912,\\\"fieldoptionlinkid\\\":1845,\\\"optionid\\\":22,\\\"mainsupplier\\\":\\\"31\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Eyelet 5 Blackout Lining_BGC\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Product Type\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Type\\\",\\\"fieldid\\\":24912,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"22\\\",\\\"optionsvalue\\\":[{\\\"id\\\":1845,\\\"fieldid\\\":24912,\\\"fieldoptionlinkid\\\":1845,\\\"optionid\\\":22,\\\"mainsupplier\\\":\\\"31\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Eyelet 5 Blackout Lining_BGC\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"editruleoverride\\\":1},{\\\"id\\\":24909,\\\"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\\\":24909,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":24911,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"31\\\",\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"31\\\",\\\"optionvalue\\\":[{\\\"id\\\":31,\\\"optionid\\\":31,\\\"optionname\\\":\\\"Blinds 2 Go\\\",\\\"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\\\":24911,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"31\\\",\\\"optionsvalue\\\":[{\\\"id\\\":31,\\\"optionid\\\":31,\\\"optionname\\\":\\\"Blinds 2 Go\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Product Type: Eyelet 5 Blackout Lining_BGC, Supplier: Blinds 2 Go\",\"oi_onlinedescription\":\"Unit Type: mm, Quantity: 1, Supplier: Blinds 2 Go\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Product Type: Eyelet 5 Blackout Lining_BGC##,##Quantity: 1##,##Supplier: Blinds 2 Go##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Blinds 2 Go##\",\"oi_reporttitles\":\"##Product Type:<\\\/br>##Quantity:<\\\/br>##Supplier:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":23,\\\"value\\\":\\\"0.11\\\",\\\"formula\\\":\\\"If(MaterialType=\\\\\\\"Standard\\\\\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\\\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\\\\\/1000)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"0.11\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":2,\\\"value\\\":null,\\\"formula\\\":\\\"If(MaterialType=\\\\\\\"Standard\\\\\\\",Round((If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\\\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\\\",\\\"price\\\":\\\"0.00\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":3,\\\"value\\\":\\\"44.88\\\",\\\"formula\\\":\\\"Heading_PriceTablePrice\\\",\\\"price\\\":\\\"44.88\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"44.88\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":4,\\\"value\\\":\\\"2.50\\\",\\\"formula\\\":\\\"If(Heading=\\\\\\\"Eyelet5_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"MachinedEyelet_CC\\\\\\\",1.8,If(Heading=\\\\\\\"MachinedPencilPleat_CC\\\\\\\",2.5,If(Heading=\\\\\\\"MachinedWave_CC\\\\\\\",2.3,If(Heading=\\\\\\\"MachinedTriplePinchPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"MachinedTwinPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"HandFinishedEyelet_CC\\\\\\\",1.8,If(Heading=\\\\\\\"HandFinishedPencilPleat_CC\\\\\\\",2,If(Heading=\\\\\\\"HandFinishedWave_CC\\\\\\\",2.3,If(Heading=\\\\\\\"HandFinishedTriplePinchPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"SlotTop_CC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"PinchPleat-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"Wave-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"PinchPleat-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Wave-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet_WGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat_WGC\\\\\\\",2,If(Heading=\\\\\\\"Wave_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"Wave(lessfull)_WGC\\\\\\\",2.1,If(Heading=\\\\\\\"TriplePinchPleat_WGC\\\\\\\",2.5,If(Heading=\\\\\\\"DoublePinchPleat_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"SinglePleat_WGC\\\\\\\",2,If(Heading=\\\\\\\"EyeletWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleatWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"WaveWideWidth_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"TriplePinchPleatWideWidth_WGC\\\\\\\",2.5,If(Heading=\\\\\\\"DoublePinchPleatWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"SinglePleatWideWidth_WGC\\\\\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"2.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":6,\\\"value\\\":null,\\\"formula\\\":\\\"If(PairorSingle=\\\\\\\"Pair\\\\\\\",Widths*2,Widths)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":7,\\\"value\\\":\\\"0.11\\\",\\\"formula\\\":\\\"((FabricQty)+Extrafabrictoorder)*Quantity\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"0.11\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":8,\\\"value\\\":null,\\\"formula\\\":\\\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\\\",\\\"price\\\":null,\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":9,\\\"value\\\":null,\\\"formula\\\":\\\"Round(Widths*3,1)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":10,\\\"value\\\":null,\\\"formula\\\":\\\"RoundUp(Widths,0)-1\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":11,\\\"value\\\":null,\\\"formula\\\":\\\"if(UnitType=\\\\\\\"Inches\\\\\\\",(JoiningAllowance*25.4)\\\\\\\/10,if(UnitType=\\\\\\\"cm\\\\\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\\\\\"inches\\\\\\\",(SideTurningsDeduction*25.4)\\\\\\\/10,if(UnitType=\\\\\\\"cm\\\\\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":5,\\\"value\\\":null,\\\"formula\\\":\\\"IF(PairorSingle=\\\\\\\"Pair\\\\\\\",RoundUp(IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))*DefaultFullness\\\\\\\/If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_FabricRollWidth\\\\\\\/10,Fabric_FabricRollDrop\\\\\\\/10),0)\\\\\\\/2,RoundUp((IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))*DefaultFullness)\\\\\\\/If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_FabricRollWidth\\\\\\\/10,Fabric_FabricRollDrop\\\\\\\/10),0))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":12,\\\"value\\\":\\\"294.50\\\",\\\"formula\\\":\\\"IF(UnitType=\\\\\\\"mm\\\\\\\",DropfromSuspensionPoint\\\\\\\/10,IF(UnitType=\\\\\\\"cm\\\\\\\",DropfromSuspensionPoint,IF(UnitType=\\\\\\\"inch\\\\\\\",(DropfromSuspensionPoint*25.4)\\\\\\\/10,DropfromSuspensionPoint\\\\\\\/100)))+IF(UnitType=\\\\\\\"inch\\\\\\\",(HeadingTurn*25.4),IF(UnitType=\\\\\\\"cm\\\\\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\\\\\"inch\\\\\\\",(HemTurn*25.4),IF(UnitType=\\\\\\\"cm\\\\\\\",HemTurn*10,HemTurn))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"294.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":13,\\\"value\\\":null,\\\"formula\\\":\\\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\\\\\/(Fabric_Patternrepeat\\\\\\\/10),0),\\\\\\\"0\\\\\\\")\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":14,\\\"value\\\":\\\"294.50\\\",\\\"formula\\\":\\\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\\\\\/10,1),FinishedCutLengths)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"294.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":15,\\\"value\\\":null,\\\"formula\\\":\\\"RoundUp(Widths*If(MaterialType=\\\\\\\"Standard\\\\\\\",(Fabric_FabricRollWidth\\\\\\\/10),(If(MaterialType=\\\\\\\"Continuous\\\\\\\",(Fabric_FabricRollDrop\\\\\\\/10),\\\\\\\"\\\\\\\"))),0)-(Totalseamsandturnings)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":16,\\\"value\\\":null,\\\"formula\\\":\\\"Round(IF(PairorSingle=\\\\\\\"Pair\\\\\\\", Round(((IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))+(Leftreturn\\\\\\\/10))+(Rightreturn\\\\\\\/10+Overlap\\\\\\\/10*2)+(Springbacktolerance*2))\\\\\\\/2,2), (IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))+Leftreturn\\\\\\\/10+Rightreturn\\\\\\\/10+Springbacktolerance)),0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":17,\\\"value\\\":null,\\\"formula\\\":\\\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":18,\\\"value\\\":null,\\\"formula\\\":\\\"Round((Spaceallowancesfinishedwidth\\\\\\\/10-(If(Leftreturn>0,Leftreturn\\\\\\\/10,Leftreturn\\\\\\\/10)+If(Overlap>0,Overlap\\\\\\\/10,Overlap\\\\\\\/10)))\\\\\\\/Qtyofspaces,0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":19,\\\"value\\\":null,\\\"formula\\\":\\\"Round((RoundUp(Spaceallowancesfinishedwidth\\\\\\\/10,0)-((Leftreturn\\\\\\\/10)+(Overlap\\\\\\\/10)))\\\\\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\\\\\/10*2),1),0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":20,\\\"value\\\":null,\\\"formula\\\":\\\"Qtyofspaces+1\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":21,\\\"value\\\":null,\\\"formula\\\":\\\"Round((Pleatsallowance)\\\\\\\/(Qtyofpleats),1)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":22,\\\"value\\\":\\\"245.00\\\",\\\"formula\\\":\\\"if(OR(Heading=\\\\\\\"Eyelet_WGC\\\\\\\",Heading=\\\\\\\"PencilPleat_WGC\\\\\\\",Heading=\\\\\\\"Wave_WGC\\\\\\\",Heading=\\\\\\\"TriplePinchPleat_WGC\\\\\\\",Heading=\\\\\\\"DoublePinchPleat_WGC\\\\\\\"),DropfromSuspensionPoint+200,0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"245.00\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":89,\\\"value\\\":null,\\\"formula\\\":\\\"(RoundUp((DropfromSuspensionPoint+290)\\\\\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\\\\\/1000\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":98,\\\"value\\\":null,\\\"formula\\\":\\\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\\\",\\\"price\\\":null,\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":99,\\\"value\\\":null,\\\"formula\\\":\\\"if(Border<>\\\\\\\"\\\\\\\",(TotalCost*0.2),0)\\\",\\\"price\\\":\\\"0.00\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null}]\",\"oi_productiondate\":\"2025-06-02 11:41:15\",\"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\":\"[]\",\"oi_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":0,\\\"pricetableCostAfterSuppdisc\\\":0,\\\"priceTableCost\\\":0}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"0.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"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\":1,\"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_supid\":null,\"oi_status\":0,\"oi_createdby\":14,\"oi_createdat\":\"2025-06-02T11:41:15.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-06-02T06:11:31.000000Z\",\"oi_jsondataid\":\"[24910, 24912, 24909, 24911]\",\"oi_deviceplatform\":0,\"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,\"lineitem_id\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "Desktop",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "33245",
"cl_createdat": "1748844691.000000",
"cl_updatedat": null
},
{
"cl_id": 33246,
"cl_logname": "default",
"cl_type": null,
"cl_modulename": "Line Item",
"cl_message": "new item has been created in Line Item for the product of Curtain 02",
"cl_event": "created",
"cl_subjectid": 80486,
"cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_parentid": 80486,
"cl_parentsubjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_causerid": 14,
"cl_changedfrom": "null",
"cl_changedto": "{\"Product Type\":\" Range 6+5per_EX_RB\",\" Supplier\":\" Excel\"}",
"cl_customproperties": "{\"attributes\":{\"oi_id\":80486,\"oi_jobid\":0,\"oi_jobtempid\":\"c058a347\",\"oi_jobmultiquoteid\":null,\"oi_credit_id\":0,\"oi_productid\":276,\"oi_recipeid\":276,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":67,\"oi_customseq\":2,\"oi_productcustomseq\":1,\"oi_jsondata\":\"[{\\\"id\\\":24899,\\\"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\\\":24899,\\\"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\\\":24901,\\\"labelname\\\":\\\"Product Type\\\",\\\"value\\\":\\\"87\\\",\\\"valueid\\\":\\\"1842\\\",\\\"type\\\":13,\\\"optionid\\\":\\\"87\\\",\\\"optionvalue\\\":[{\\\"id\\\":1842,\\\"fieldid\\\":24901,\\\"fieldoptionlinkid\\\":1842,\\\"optionid\\\":87,\\\"mainsupplier\\\":\\\"15\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Range 6+5per_EX_RB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"issubfabric\\\":0,\\\"labelnamecode\\\":\\\"Product Type\\\",\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":null,\\\"widthfractiontext\\\":null,\\\"dropfractiontext\\\":null,\\\"dropfraction\\\":null,\\\"showfieldonjob\\\":1,\\\"showFieldOnCustomerPortal\\\":0,\\\"optionquantity\\\":null,\\\"globaledit\\\":false,\\\"numberfraction\\\":null,\\\"numberfractiontext\\\":null,\\\"fieldlevel\\\":1,\\\"fieldtypeid\\\":13,\\\"mandatory\\\":0,\\\"fieldname\\\":\\\"Product Type\\\",\\\"fieldid\\\":24901,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"87\\\",\\\"optionsvalue\\\":[{\\\"id\\\":1842,\\\"fieldid\\\":24901,\\\"fieldoptionlinkid\\\":1842,\\\"optionid\\\":87,\\\"mainsupplier\\\":\\\"15\\\",\\\"blindtypecode\\\":null,\\\"optionname\\\":\\\"Range 6+5per_EX_RB\\\",\\\"optionquantity\\\":1,\\\"subcount\\\":0,\\\"status\\\":0,\\\"subdatacount\\\":0}],\\\"editruleoverride\\\":1},{\\\"id\\\":24898,\\\"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\\\":24898,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":null,\\\"optionsvalue\\\":[],\\\"editruleoverride\\\":0},{\\\"id\\\":24900,\\\"labelname\\\":\\\"Supplier\\\",\\\"value\\\":\\\"15\\\",\\\"valueid\\\":null,\\\"type\\\":17,\\\"optionid\\\":\\\"15\\\",\\\"optionvalue\\\":[{\\\"id\\\":15,\\\"optionid\\\":15,\\\"optionname\\\":\\\"Excel\\\",\\\"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\\\":24900,\\\"subchild\\\":[],\\\"fieldInformation\\\":null,\\\"optiondefault\\\":\\\"15\\\",\\\"optionsvalue\\\":[{\\\"id\\\":15,\\\"optionid\\\":15,\\\"optionname\\\":\\\"Excel\\\",\\\"deleted\\\":0,\\\"optionquantity\\\":1}],\\\"editruleoverride\\\":1}]\",\"oi_description\":\"Product Type: Range 6+5per_EX_RB, Supplier: Excel\",\"oi_onlinedescription\":\"Unit Type: mm, Quantity: 1, Supplier: Excel\",\"oi_imagepath\":null,\"oi_reportdescription\":\"##Product Type: Range 6+5per_EX_RB##,##Quantity: 1##,##Supplier: Excel##\",\"oi_onlinereportdescription\":\"##Quantity: 1##, ##Supplier: Excel##\",\"oi_reporttitles\":\"##Product Type:<\\\/br>##Quantity:<\\\/br>##Supplier:\",\"oi_onlinereporttitles\":\"##Quantity:, ##Supplier:\",\"oi_productionformulajsondata\":\"[{\\\"productionoveride\\\":0,\\\"id\\\":23,\\\"value\\\":\\\"0.11\\\",\\\"formula\\\":\\\"If(MaterialType=\\\\\\\"Standard\\\\\\\",If(And(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat=0),((DropfromSuspensionPoint+290)*(TotalNoofwidths))\\\\\\\/1000,If(and(Fabric_FabricRollWidth<=1500,Fabric_Patternrepeat>0),(True),0)),(WidthofTrackPole*DefaultFullness)\\\\\\\/1000)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"0.11\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":2,\\\"value\\\":null,\\\"formula\\\":\\\"If(MaterialType=\\\\\\\"Standard\\\\\\\",Round((If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))+Round((If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_UnitCost*((FabricQty)+Extrafabrictoorder),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder)))\\\\\\\/100*FabricMarkUp),2,2),Fabric_UnitCost*((FabricQty)+Extrafabrictoorder))\\\",\\\"price\\\":\\\"0.00\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":3,\\\"value\\\":\\\"44.88\\\",\\\"formula\\\":\\\"Heading_PriceTablePrice\\\",\\\"price\\\":\\\"44.88\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"44.88\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":4,\\\"value\\\":\\\"2.50\\\",\\\"formula\\\":\\\"If(Heading=\\\\\\\"Eyelet5_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5BlackoutLining_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5Thermal_BGC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"TwinPleat5Thermal+BO_BGC\\\\\\\",2,If(Heading=\\\\\\\"MachinedEyelet_CC\\\\\\\",1.8,If(Heading=\\\\\\\"MachinedPencilPleat_CC\\\\\\\",2.5,If(Heading=\\\\\\\"MachinedWave_CC\\\\\\\",2.3,If(Heading=\\\\\\\"MachinedTriplePinchPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"MachinedTwinPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"HandFinishedEyelet_CC\\\\\\\",1.8,If(Heading=\\\\\\\"HandFinishedPencilPleat_CC\\\\\\\",2,If(Heading=\\\\\\\"HandFinishedWave_CC\\\\\\\",2.3,If(Heading=\\\\\\\"HandFinishedTriplePinchPleat_CC\\\\\\\",2.2,If(Heading=\\\\\\\"SlotTop_CC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"PinchPleat-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"Wave-HandFinished_PCC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"PinchPleat-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Wave-Machined_PCC\\\\\\\",2,If(Heading=\\\\\\\"Eyelet_WGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleat_WGC\\\\\\\",2,If(Heading=\\\\\\\"Wave_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"Wave(lessfull)_WGC\\\\\\\",2.1,If(Heading=\\\\\\\"TriplePinchPleat_WGC\\\\\\\",2.5,If(Heading=\\\\\\\"DoublePinchPleat_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"SinglePleat_WGC\\\\\\\",2,If(Heading=\\\\\\\"EyeletWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"PencilPleatWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"WaveWideWidth_WGC\\\\\\\",2.3,If(Heading=\\\\\\\"TriplePinchPleatWideWidth_WGC\\\\\\\",2.5,If(Heading=\\\\\\\"DoublePinchPleatWideWidth_WGC\\\\\\\",2,If(Heading=\\\\\\\"SinglePleatWideWidth_WGC\\\\\\\",2,0)))))))))))))))))))))))))))))))))))))))))))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"2.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":6,\\\"value\\\":null,\\\"formula\\\":\\\"If(PairorSingle=\\\\\\\"Pair\\\\\\\",Widths*2,Widths)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":7,\\\"value\\\":\\\"0.11\\\",\\\"formula\\\":\\\"((FabricQty)+Extrafabrictoorder)*Quantity\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"0.11\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":8,\\\"value\\\":null,\\\"formula\\\":\\\"(((FabricQty)+Extrafabrictoorder)*Quantity)*Lining_MakeupperWidth\\\",\\\"price\\\":null,\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":0,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":9,\\\"value\\\":null,\\\"formula\\\":\\\"Round(Widths*3,1)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":10,\\\"value\\\":null,\\\"formula\\\":\\\"RoundUp(Widths,0)-1\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":11,\\\"value\\\":null,\\\"formula\\\":\\\"if(UnitType=\\\\\\\"Inches\\\\\\\",(JoiningAllowance*25.4)\\\\\\\/10,if(UnitType=\\\\\\\"cm\\\\\\\",JoiningAllowance*10,JoiningAllowance))*(Numberofjoins)+ (if(UnitType=\\\\\\\"inches\\\\\\\",(SideTurningsDeduction*25.4)\\\\\\\/10,if(UnitType=\\\\\\\"cm\\\\\\\",(SideTurningsDeduction*10),SideTurningsDeduction)))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":5,\\\"value\\\":null,\\\"formula\\\":\\\"IF(PairorSingle=\\\\\\\"Pair\\\\\\\",RoundUp(IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))*DefaultFullness\\\\\\\/If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_FabricRollWidth\\\\\\\/10,Fabric_FabricRollDrop\\\\\\\/10),0)\\\\\\\/2,RoundUp((IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"inch\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))*DefaultFullness)\\\\\\\/If(MaterialType=\\\\\\\"Standard\\\\\\\",Fabric_FabricRollWidth\\\\\\\/10,Fabric_FabricRollDrop\\\\\\\/10),0))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":12,\\\"value\\\":\\\"294.50\\\",\\\"formula\\\":\\\"IF(UnitType=\\\\\\\"mm\\\\\\\",DropfromSuspensionPoint\\\\\\\/10,IF(UnitType=\\\\\\\"cm\\\\\\\",DropfromSuspensionPoint,IF(UnitType=\\\\\\\"inch\\\\\\\",(DropfromSuspensionPoint*25.4)\\\\\\\/10,DropfromSuspensionPoint\\\\\\\/100)))+IF(UnitType=\\\\\\\"inch\\\\\\\",(HeadingTurn*25.4),IF(UnitType=\\\\\\\"cm\\\\\\\",HeadingTurn*10,HeadingTurn))+IF(UnitType=\\\\\\\"inch\\\\\\\",(HemTurn*25.4),IF(UnitType=\\\\\\\"cm\\\\\\\",HemTurn*10,HemTurn))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"294.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":13,\\\"value\\\":null,\\\"formula\\\":\\\"IF(Fabric_Patternrepeat>0,RoundUp((DropfromSuspensionPoint+HeadingTurn+HemTurn)\\\\\\\/(Fabric_Patternrepeat\\\\\\\/10),0),\\\\\\\"0\\\\\\\")\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":14,\\\"value\\\":\\\"294.50\\\",\\\"formula\\\":\\\"IF(NoOfPatternRepeats>0,NoOfPatternRepeats * IF(Fabric_Patternrepeat>0,Fabric_Patternrepeat\\\\\\\/10,1),FinishedCutLengths)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"294.50\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":15,\\\"value\\\":null,\\\"formula\\\":\\\"RoundUp(Widths*If(MaterialType=\\\\\\\"Standard\\\\\\\",(Fabric_FabricRollWidth\\\\\\\/10),(If(MaterialType=\\\\\\\"Continuous\\\\\\\",(Fabric_FabricRollDrop\\\\\\\/10),\\\\\\\"\\\\\\\"))),0)-(Totalseamsandturnings)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":16,\\\"value\\\":null,\\\"formula\\\":\\\"Round(IF(PairorSingle=\\\\\\\"Pair\\\\\\\", Round(((IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))+(Leftreturn\\\\\\\/10))+(Rightreturn\\\\\\\/10+Overlap\\\\\\\/10*2)+(Springbacktolerance*2))\\\\\\\/2,2), (IF(UnitType=\\\\\\\"mm\\\\\\\",WidthofTrackPole\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",(WidthofTrackPole*25.4)\\\\\\\/10,IF(UnitType=\\\\\\\"Inches\\\\\\\",WidthofTrackPole\\\\\\\/100,WidthofTrackPole)))+Leftreturn\\\\\\\/10+Rightreturn\\\\\\\/10+Springbacktolerance)),0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":17,\\\"value\\\":null,\\\"formula\\\":\\\"((Finishedwidthoffabric)-(Spaceallowancesfinishedwidth))\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":18,\\\"value\\\":null,\\\"formula\\\":\\\"Round((Spaceallowancesfinishedwidth\\\\\\\/10-(If(Leftreturn>0,Leftreturn\\\\\\\/10,Leftreturn\\\\\\\/10)+If(Overlap>0,Overlap\\\\\\\/10,Overlap\\\\\\\/10)))\\\\\\\/Qtyofspaces,0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":19,\\\"value\\\":null,\\\"formula\\\":\\\"Round((RoundUp(Spaceallowancesfinishedwidth\\\\\\\/10,0)-((Leftreturn\\\\\\\/10)+(Overlap\\\\\\\/10)))\\\\\\\/if(Suspensionpointtowall>0,(Suspensionpointtowall\\\\\\\/10*2),1),0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":20,\\\"value\\\":null,\\\"formula\\\":\\\"Qtyofspaces+1\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":21,\\\"value\\\":null,\\\"formula\\\":\\\"Round((Pleatsallowance)\\\\\\\/(Qtyofpleats),1)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":22,\\\"value\\\":\\\"245.00\\\",\\\"formula\\\":\\\"if(OR(Heading=\\\\\\\"Eyelet_WGC\\\\\\\",Heading=\\\\\\\"PencilPleat_WGC\\\\\\\",Heading=\\\\\\\"Wave_WGC\\\\\\\",Heading=\\\\\\\"TriplePinchPleat_WGC\\\\\\\",Heading=\\\\\\\"DoublePinchPleat_WGC\\\\\\\"),DropfromSuspensionPoint+200,0)\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":\\\"245.00\\\"},{\\\"productionoveride\\\":0,\\\"id\\\":89,\\\"value\\\":null,\\\"formula\\\":\\\"(RoundUp((DropfromSuspensionPoint+290)\\\\\\\/Fabric_Patternrepeat,0)*Fabric_Patternrepeat)*(TotalNoofwidths)\\\\\\\/1000\\\",\\\"price\\\":\\\"-\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":98,\\\"value\\\":null,\\\"formula\\\":\\\"(Priceoftotalfabric+Makeupchargeoffabric+Makeupchargeoflining)\\\",\\\"price\\\":null,\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null},{\\\"productionoveride\\\":0,\\\"id\\\":99,\\\"value\\\":null,\\\"formula\\\":\\\"if(Border<>\\\\\\\"\\\\\\\",(TotalCost*0.2),0)\\\",\\\"price\\\":\\\"0.00\\\",\\\"recipeid\\\":57,\\\"stockupdate\\\":0,\\\"fieldid\\\":0,\\\"isdelete\\\":0,\\\"defaultstock\\\":1,\\\"fieldtype_id\\\":0,\\\"fractionvalue\\\":null}]\",\"oi_productiondate\":\"2025-06-02 11:41:35\",\"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_pricetablepriceevenbom\":\"{\\\"sellingPrice\\\":0,\\\"pricetableCostAfterSuppdisc\\\":0,\\\"priceTableCost\\\":0}\",\"oi_productionstatus\":null,\"oi_costoverride\":0,\"oi_costprice\":\"0.000\",\"oi_netprice\":\"0.000\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"0.000\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"0.000\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"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\":1,\"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_supid\":null,\"oi_status\":0,\"oi_createdby\":14,\"oi_createdat\":\"2025-06-02T11:41:35.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":\"2025-06-02T06:12:03.000000Z\",\"oi_jsondataid\":\"[24899, 24901, 24898, 24900]\",\"oi_deviceplatform\":0,\"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,\"lineitem_id\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "Desktop",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "33246",
"cl_createdat": "1748844723.000000",
"cl_updatedat": null
},
{
"cl_id": 33247,
"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 Blindspace",
"cl_event": "created",
"cl_subjectid": 80487,
"cl_subjecttype": "App\\Models\\Orderitem\\bm_orderitem",
"cl_parentid": 12792,
"cl_parentsubjecttype": "App\\Models\\Job\\bm_jobdetails",
"cl_causerid": 1,
"cl_changedfrom": "null",
"cl_changedto": "{\"Unit Type\":\" mm\",\" Quantity\":\" 1\",\" Size\":\" Profile Only\",\" Width\":\" 900\",\" Drop\":\" 900\",\" Profile\":\" C Series C110x150\",\"C Series C130x160\":\"C Series C130x160\",\" Front Corner\":\" U Upstand flange\"}",
"cl_customproperties": "{\"attributes\":{\"oi_id\":80487,\"oi_jobid\":12792,\"oi_jobtempid\":\"0\",\"oi_jobmultiquoteid\":12796,\"oi_credit_id\":0,\"oi_productid\":191,\"oi_recipeid\":191,\"oi_ruleid\":0,\"oi_qty\":1,\"oi_seq\":0,\"oi_customseq\":0,\"oi_productcustomseq\":0,\"oi_jsondata\":\"[{\\\"id\\\":19392,\\\"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\\\":19391,\\\"labelname\\\":\\\"Quantity\\\",\\\"value\\\":1,\\\"valueid\\\":\\\"\\\",\\\"type\\\":14,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19393,\\\"labelname\\\":\\\"Room\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19394,\\\"labelname\\\":\\\"Size\\\",\\\"value\\\":\\\"Profile Only\\\",\\\"valueid\\\":\\\"54517\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"37992\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":37992,\\\"optionname\\\":\\\"Profile Only\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":4198,\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":1,\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"fieldoptionlinkid\\\":54517,\\\"forchildfieldoptionlinkid\\\":\\\"3_54517\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":0,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\"}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19395,\\\"labelname\\\":\\\"Width\\\",\\\"value\\\":\\\"900\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":11,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":19396,\\\"labelname\\\":\\\"Drop\\\",\\\"value\\\":\\\"900\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":12,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":19397,\\\"labelname\\\":\\\"Profile\\\",\\\"value\\\":\\\"C Series C110x150,C Series C130x160\\\",\\\"valueid\\\":\\\"54528,54539\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"38010,38001\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":38001,\\\"optionname\\\":\\\"C Series C110x150\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":27769,\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":130.01,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":54528,\\\"forchildfieldoptionlinkid\\\":\\\"3_54528\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":2,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"260.02\\\",\\\"fieldid\\\":54528},{\\\"optionid\\\":38010,\\\"optionname\\\":\\\"C Series C130x160\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":27773,\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":146.58,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":54539,\\\"forchildfieldoptionlinkid\\\":\\\"3_54539\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":2,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"293.16\\\",\\\"fieldid\\\":54539}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1,1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":19402,\\\"labelname\\\":\\\"Front Corner\\\",\\\"value\\\":\\\"U Upstand flange\\\",\\\"valueid\\\":\\\"54544\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"38014\\\",\\\"optionvalue\\\":[{\\\"optionid\\\":38014,\\\"optionname\\\":\\\"U Upstand flange\\\",\\\"description\\\":\\\"\\\",\\\"optioncode\\\":74454,\\\"pricegroups\\\":\\\"\\\",\\\"optionqty\\\":\\\"1\\\",\\\"unittype\\\":\\\"Each\\\",\\\"unitcost\\\":0,\\\"pricingtype\\\":\\\"\\\",\\\"fieldoptionlinkid\\\":54544,\\\"forchildfieldoptionlinkid\\\":\\\"3_54544\\\",\\\"hasstock\\\":0,\\\"hasprice\\\":1,\\\"subdatacount\\\":0,\\\"optionimage\\\":\\\"\\\",\\\"reportprice\\\":\\\"0.00\\\",\\\"fieldid\\\":54544}],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"1\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":1},{\\\"id\\\":19403,\\\"labelname\\\":\\\"Back Corner\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19400,\\\"labelname\\\":\\\"Front Corner\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19401,\\\"labelname\\\":\\\"Back Corner\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19410,\\\"labelname\\\":\\\"Extras\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19411,\\\"labelname\\\":\\\"Blind Information\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19412,\\\"labelname\\\":\\\"Fitting\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":3,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19413,\\\"labelname\\\":\\\"Special Instructions\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0},{\\\"id\\\":19414,\\\"labelname\\\":\\\"Workroom Notes\\\",\\\"value\\\":\\\"\\\",\\\"valueid\\\":\\\"\\\",\\\"type\\\":18,\\\"optionid\\\":\\\"\\\",\\\"optionvalue\\\":[],\\\"fabricorcolor\\\":0,\\\"widthfraction\\\":\\\"\\\",\\\"widthfractiontext\\\":\\\"\\\",\\\"dropfraction\\\":\\\"\\\",\\\"dropfractiontext\\\":\\\"\\\",\\\"optionquantity\\\":\\\"\\\",\\\"numberfraction\\\":\\\"\\\",\\\"numberfractiontext\\\":\\\"\\\",\\\"editruleoverride\\\":0}]\",\"oi_description\":\"Unit Type: mm, Quantity: 1, Size: Profile Only, Width: 900, Drop: 900, Profile: C Series C110x150,C Series C130x160, Front Corner: U Upstand flange\",\"oi_onlinedescription\":null,\"oi_imagepath\":null,\"oi_reportdescription\":\"##Quantity: 1##,##Size: Profile Only##,##Width: 900 mm##,##Drop: 900 mm##,##Profile: C Series C110x150,C Series C130x160##,##Front Corner: U Upstand flange##\",\"oi_onlinereportdescription\":null,\"oi_reporttitles\":\"##Quantity:
##Size:
##Width:
##Drop:
##Profile:
##Front Corner:\",\"oi_onlinereporttitles\":null,\"oi_productionformulajsondata\":\"[]\",\"oi_productiondate\":\"2025-06-02 06:31:12\",\"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\":\"276.590\",\"oi_netprice\":\"553.180\",\"oi_pricesfromoperations\":null,\"oi_vatprice\":\"110.640\",\"oi_vatvalue\":\"20.000\",\"oi_vatselected\":1,\"oi_vattype\":1,\"oi_vatonoff\":1,\"oi_grossprice\":\"663.820\",\"oi_overrideprice\":\"0.000\",\"oi_overridetype\":2,\"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\":2,\"oi_endcustomeroverridevalue\":null,\"oi_endcustomeroverridenetprice\":\"0.000\",\"oi_endcustomeroverridevatprice\":\"0.000\",\"oi_endcustomeroverridegrossprice\":\"0.000\",\"oi_sage_flag\":0,\"oi_supid\":null,\"oi_status\":0,\"oi_createdby\":1,\"oi_createdat\":\"2025-06-02T06:31:33.000000Z\",\"oi_updatedby\":null,\"oi_updatedat\":null,\"oi_jsondataid\":\"[19392, 19391, 19393, 19394, 19395, 19396, 19397, 19402, 19403, 19400, 19401, 19410, 19411, 19412, 19413, 19414]\",\"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,\"lineitem_id\":null}}",
"cl_attachment": null,
"cl_deviceplatform": "android",
"cl_deviceipaddress": "",
"cl_devicenameversion": "",
"cl_devicelocation": "",
"cl_causertype": "App\\Models\\BMUsers",
"id": "33247",
"cl_createdat": "1748845900.000000",
"cl_updatedat": null
}
],
"updated": [],
"deleted": []
},
"bm_productInfo": {
"created": [],
"updated": [
{
"pi_productid": 61,
"pi_productname": "Roller Perfect Fit",
"pi_pcode": "117",
"pi_category": 3,
"pi_productgroup": 1,
"pi_producttype": 0,
"pi_qtyperunit": "0.00",
"pi_unitprice": "0.00",
"pi_costfactor": null,
"pi_commissionrate": "0.000",
"pi_commissionmethod": null,
"pi_reorderlevel": null,
"pi_taxclass": null,
"pi_serialno": null,
"pi_qtyinstock": null,
"pi_supplierid": null,
"pi_imagename": null,
"pi_currencyid": null,
"pi_supplierdefault": null,
"pi_productseqno": null,
"pi_domesticmarkup": "0.00",
"pi_contractmarkup": "0.00",
"pi_trademarkup": "0.00",
"pi_childsafe": null,
"pi_quantyshowhide": null,
"pi_compquantyshowhide": null,
"pi_stockcontrol": null,
"pi_productiontab": null,
"pi_fabriccolorcodehide": null,
"pi_defaultunitfornewcurtainsorder": null,
"pi_costpricecomesfrom": "2",
"pi_netpricecomesfrom": "2",
"pi_shuttercontract": "0.00",
"pi_shuttertrade": "0.00",
"pi_shutterdomestic": "0.00",
"pi_shutterecommerce": "0.00",
"pi_customerdiscount": null,
"pi_discountoverridesubwidth": null,
"pi_manufacturer_cost": null,
"pi_fabrichide": null,
"pi_hidecompparameter": null,
"pi_factorybarcodeproduct": null,
"pi_showhideproductorder": 1,
"pi_ecommercestatus": 0,
"pi_productdescription": "",
"pi_ecomproductdesc": null,
"pi_homeimage": null,
"pi_galleryimage": null,
"pi_innerpageimage": null,
"pi_frameimage": "[]",
"pi_ecommercecompmarkup": "0.00",
"pi_showframeminmax": null,
"pi_fabricdefaultdiscount": null,
"pi_productstatusmultiple": 2,
"pi_followproductionseq": 1,
"pi_productionformulasheetname": null,
"pi_productrules": null,
"pi_showexcelfromula": null,
"pi_supplierheading": null,
"pi_producttypehide": null,
"pi_dualproducttypeheading": "Fabric 2",
"pi_fabricheading": null,
"pi_dualproducttypeenable": 0,
"pi_fabricbeforeproducttype": null,
"pi_suppliermandatory": null,
"pi_showfabric": null,
"pi_ecommercesample": "1",
"pi_priceavalcheck": null,
"pi_showcomponentcode": null,
"pi_showmaxarea": null,
"pi_recessallowance": null,
"pi_deductionname": null,
"pi_deductionvalue": "0.00",
"pi_stackqty": null,
"pi_blindstype": null,
"pi_suppliershowhide": null,
"pi_pricealert": null,
"pi_metatitle": null,
"pi_metadescription": null,
"pi_metakeyword": null,
"pi_canonicaltag": null,
"pi_alttexttag": null,
"pi_headertag": "H1",
"pi_productimage": "[]",
"pi_workroom": 1,
"pi_mobileapp": 1,
"pi_jobtransfer": 1,
"pi_seq": 40,
"pi_status": 0,
"pi_createdby": 1,
"pi_defaultunittype": 2,
"pi_jobfraction": 1,
"pi_unittypeseq": "2,3,1,4",
"pi_deafultimage": "{\"defaultimage\":{\"framedefault\":\"\",\"productdefault\":\"\",\"backgrounddefault\":\"\",\"bannerdefault\":\"\"}}",
"pi_backgroundimage": "[]",
"pi_discountappliesto": "{\"optionschk\":1,\"operationschk\":1,\"pricetablechk\":1}",
"pi_ecomProductName": null,
"pi_productgroupseq": null,
"pi_unitypedata": "{\"1\":1,\"2\":1,\"3\":1,\"4\":1}",
"id": "61"
}
],
"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": [
{
"prm_id": 434144,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386404,
"prm_status": 0,
"id": "434144"
},
{
"prm_id": 434145,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386405,
"prm_status": 0,
"id": "434145"
},
{
"prm_id": 434146,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386406,
"prm_status": 0,
"id": "434146"
},
{
"prm_id": 434147,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386407,
"prm_status": 0,
"id": "434147"
},
{
"prm_id": 434148,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386408,
"prm_status": 0,
"id": "434148"
},
{
"prm_id": 434149,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386409,
"prm_status": 0,
"id": "434149"
},
{
"prm_id": 434150,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386410,
"prm_status": 0,
"id": "434150"
},
{
"prm_id": 434151,
"prm_recipeid": 61,
"prm_fieldtypeid": 5,
"prm_fieldvalueid": 386411,
"prm_status": 0,
"id": "434151"
}
],
"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": [
{
"pgmm_id": 386404,
"pgmm_fabriccolormapid": 15617,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 145,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 1,
"id": "386404"
},
{
"pgmm_id": 386405,
"pgmm_fabriccolormapid": 15618,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 145,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 2,
"id": "386405"
},
{
"pgmm_id": 386406,
"pgmm_fabriccolormapid": 15617,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 146,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 1,
"id": "386406"
},
{
"pgmm_id": 386407,
"pgmm_fabriccolormapid": 15618,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 146,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 2,
"id": "386407"
},
{
"pgmm_id": 386408,
"pgmm_fabriccolormapid": 15617,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 147,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 1,
"id": "386408"
},
{
"pgmm_id": 386409,
"pgmm_fabriccolormapid": 15618,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 147,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 2,
"id": "386409"
},
{
"pgmm_id": 386410,
"pgmm_fabriccolormapid": 15617,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 148,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 2,
"id": "386410"
},
{
"pgmm_id": 386411,
"pgmm_fabriccolormapid": 15618,
"pgmm_productmapid": 61,
"pgmm_categoryeditdetails": null,
"pgmm_groupmapid": 148,
"pgmm_fabricfieldid": 3938,
"pgmm_colorfieldid": 4071,
"pgmm_contactid": 0,
"pgmm_status": 0,
"pgmm_colorseq": 3,
"id": "386411"
}
],
"updated": [],
"deleted": []
},
"bm_productpricedetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fabriccolourmap": {
"created": [],
"updated": [],
"deleted": []
},
"bm_fabricdetails": {
"created": [],
"updated": [
{
"fd_id": 3118,
"fd_mtrlcategid": 5,
"fd_custmzdfabdetails": "{\"128\":\"Acacia\",\"129\":103419,\"130\":64,\"131\":\"\"}",
"fd_hasprice": 0,
"fd_status": 0,
"fd_seq": 0,
"id": "3118"
}
],
"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_orderitem": {
"71748845893": 80487
}
},
"timestamp": 1748845900
}