{ "status": "success", "upcomingorder_list": { "bm_customertemplatedata": { "created": [], "updated": [ { "ctd_id": 3999, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"ARIA0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": \"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_enabledproductonline": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "3999", "ctd_createdat": 1748415487, "ctd_updatedat": 1748415488, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4000, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\":\"TEST0012\",\"63\":\"\",\"61\":1,\"600\":25,\"64\":\"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_enabledproductonline": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4000", "ctd_createdat": 1748415886, "ctd_updatedat": 1748415949, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4001, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"ERTE0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": \"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_enabledproductonline": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4001", "ctd_createdat": 1748415930, "ctd_updatedat": 1748415931, "ctd_createdby": 0, "ctd_updatedby": null }, { "ctd_id": 4002, "ctd_createdfrom": 0, "ctd_templateid": 2, "ctd_moduleid": 3, "ctd_latitude": "", "ctd_longitude": "", "ctd_leadimage": null, "ctd_jobcustomoizedkeyvalue": "", "ctd_customoizedkeyvalue": "{\"62\": \"ASFD0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": \"\"}", "ctd_deletedcustokeyvalue": "{}", "ctd_isenablecustspecvatrate": 0, "ctd_custspecvatrate": "0.00", "ctd_vatregnum": null, "ctd_custsurcharge": null, "ctd_defaultdelcost": null, "ctd_defaultapptype": null, "ctd_defaultstaff": null, "ctd_addcredit": "0.00", "ctd_totredeemed": "0.00", "ctd_balance": "0.00", "ctd_creditlimit": "0.00", "ctd_creditavailable": "0.00", "ctd_overdue": 0, "ctd_paymenttermstype": 0, "ctd_paymenttermsvalue": 0, "ctd_paymenttermsdesc": null, "ctd_ishold": 0, "ctd_jobview": 0, "ctd_jobtypeview": 0, "ctd_discount": "0.00", "ctd_language": 0, "ctd_notymsg": 0, "ctd_onlinelogoname": null, "ctd_onlinelogo": null, "ctd_onlinesendemail": 0, "ctd_fordesktopisenable": 1, "ctd_foronlineisenable": 1, "ctd_enabledproductdesktop": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_enabledproductonline": "4,8,9,10,11,12,13,14,15,20,21,23,24,31,32,138,207,208,246,247,248,249,250,251,271,272,275,276,277,282,285,287,297,298,306,307,308,309,310,311,312,313", "ctd_onlineproductmarkup": null, "ctd_onlineendcustomeruseprefix": null, "ctd_onlineendcustomersequence": "1", "ctd_onlinequotecustomerterms": null, "ctd_onlinequotepaymentterms": null, "ctd_onlineinvoicecustomerterms": null, "ctd_onlineinvoicepaymentterms": null, "ctd_seq": 0, "ctd_status": 0, "id": "4002", "ctd_createdat": 1748417602, "ctd_updatedat": 1748417602, "ctd_createdby": 0, "ctd_updatedby": null } ], "deleted": [] }, "bm_customercontactinfo": { "created": [], "updated": [ { "cci_id": 4173, "cci_customerid": 3999, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Aarthi\",\"79\":\"Ari\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":7,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4173", "cci_createdat": 1748415487, "cci_updatedat": 1748415487, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4174, "cci_customerid": 4000, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Tesr\",\"79\":\"Tes\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":12,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4174", "cci_createdat": 1748415887, "cci_updatedat": 1748415887, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4175, "cci_customerid": 4001, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Test\",\"79\":\"Er\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":12,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4175", "cci_createdat": 1748415930, "cci_updatedat": 1748415930, "cci_createdby": 0, "cci_updatedby": null }, { "cci_id": 4176, "cci_customerid": 4002, "cci_templateid": 3, "roleid": 1, "cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Sfdsa\",\"79\":\"Asfd\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":12,\"83\":\"1\"}", "cci_customizedarraydel": "{}", "cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}", "cci_ismarketingemails": 0, "cci_smsverifystatus": 0, "cci_isdocumentreceived": 0, "cci_receiveddocfor": null, "cci_isonlineportal": 0, "cci_latitude": null, "cci_longitude": null, "cci_username": null, "cci_password": null, "cci_confirmpassword": null, "cci_seq": 0, "cci_status": 0, "cci_deviceplatform": 0, "cci_mobcustomertempid": 0, "id": "4176", "cci_createdat": 1748417602, "cci_updatedat": 1748417602, "cci_createdby": 0, "cci_updatedby": null } ], "deleted": [] }, "bm_appointment": { "created": [ { "app_eventid": 10020, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 4174, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10020", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415887, "app_updatedAt": 1748415887, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10021, "app_description": "", "app_summary": "AQ5677-Test Er-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5678, "app_customerId": 4175, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4175, "id": "10021", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415931, "app_updatedAt": 1748415931, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10022, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10022", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415949, "app_updatedAt": 1748415949, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10023, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10023", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415959, "app_updatedAt": 1748415959, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10024, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10024", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415970, "app_updatedAt": 1748415970, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10025, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10025", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415987, "app_updatedAt": 1748415987, "app_createdBy": 22, "app_updatedBy": null }, { "app_eventid": 10026, "app_description": "", "app_summary": "AQ5676-Tesr Tes-Leave", "app_private": 0, "app_appointmentType": 70, "app_userId": 22, "app_orderId": 5677, "app_customerId": 0, "app_isAllDay": 0, "app_timezone": "Asia\/Calcutta", "app_latitude": null, "app_longitude": null, "app_parentappid": null, "app_recurrencerule": null, "app_userdefinedValue": "[]", "app_recurrenceexception": null, "app_attachment": null, "guid": "", "app_staff": "", "app_appointtype": "", "app_confirmed": 0, "app_travelHour": "0", "app_travelMinute": "0", "app_onsiteHour": "0", "app_onsiteMinute": "0", "app_location": null, "app_traveltime": null, "app_googleid": "0", "app_platform": "web", "app_cal_status": 868, "app_status": 0, "app_markasread": 0, "app_statusInGoogle": 0, "app_runid": null, "app_jobtimehour": "1", "app_jobtimeminute": "0", "app_products": "[]", "app_deviceplatform": 0, "app_recurrenceexception_date": null, "app_deliveryaddressid": 4174, "id": "10026", "app_sdate": 1748390400, "app_edate": 1748390400, "app_stime": 1748413800, "app_etime": 1748417400, "app_sdatetime": 1748413800, "app_edatetime": 1748417400, "app_until": null, "app_createdAt": 1748415999, "app_updatedAt": 1748415999, "app_createdBy": 22, "app_updatedBy": null } ], "updated": [], "deleted": [] }, "bm_tasklist": { "created": [], "updated": [], "deleted": [] }, "bm_jobdetails": { "created": [ { "jd_id": 5676, "jd_customerid": 3999, "jd_contactid": 4173, "jd_additionalcontacts": "4173", "jd_templateid": 1, "jd_jobmultiquoteid": 5703, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5675", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ARIA0001", "jd_invoiceno": "", "jd_listprice": "260.00", "jd_netprice": "260.00", "jd_vat": "20.16", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "280.16", "jd_grossprofit": "80.00", "jd_costprice": "180.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "280.16", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":14,\"44\":\"\",\"45\":\"Aarthi\",\"46\":\"Ari\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":7,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5676", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748390400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415487, "jd_updatedat": 1748417882 }, { "jd_id": 5677, "jd_customerid": 4000, "jd_contactid": 4174, "jd_additionalcontacts": "4174", "jd_templateid": 1, "jd_jobmultiquoteid": 5704, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5676", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0012", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 22, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":22,\"44\":\"\",\"45\":\"Tesr\",\"46\":\"Tes\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":22,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5677", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415887, "jd_updatedat": 1748415887 }, { "jd_id": 5678, "jd_customerid": 4001, "jd_contactid": 4175, "jd_additionalcontacts": "4175", "jd_templateid": 1, "jd_jobmultiquoteid": 5705, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5677", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ERTE0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 22, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":22,\"44\":\"\",\"45\":\"Test\",\"46\":\"Er\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":22,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5678", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415931, "jd_updatedat": 1748415931 }, { "jd_id": 5679, "jd_customerid": 4002, "jd_contactid": 4176, "jd_additionalcontacts": "4176", "jd_templateid": 1, "jd_jobmultiquoteid": 5706, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5678", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ASFD0001", "jd_invoiceno": "", "jd_listprice": "70.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 15, "jd_updatedby": 15, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":15,\"44\":\"\",\"45\":\"Sfdsa\",\"46\":\"Asfd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":15,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5679", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417602, "jd_updatedat": 1748417602 } ], "updated": [ { "jd_id": 5676, "jd_customerid": 3999, "jd_contactid": 4173, "jd_additionalcontacts": "4173", "jd_templateid": 1, "jd_jobmultiquoteid": 5703, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5675", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ARIA0001", "jd_invoiceno": "", "jd_listprice": "260.00", "jd_netprice": "260.00", "jd_vat": "20.16", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "280.16", "jd_grossprofit": "80.00", "jd_costprice": "180.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "280.16", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 14, "jd_updatedby": 14, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":14,\"44\":\"\",\"45\":\"Aarthi\",\"46\":\"Ari\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":7,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":14,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5676", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": 1748390400, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415487, "jd_updatedat": 1748417882 }, { "jd_id": 5677, "jd_customerid": 4000, "jd_contactid": 4174, "jd_additionalcontacts": "4174", "jd_templateid": 1, "jd_jobmultiquoteid": 5704, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5676", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "TEST0012", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 22, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":22,\"44\":\"\",\"45\":\"Tesr\",\"46\":\"Tes\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":22,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5677", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415887, "jd_updatedat": 1748415887 }, { "jd_id": 5678, "jd_customerid": 4001, "jd_contactid": 4175, "jd_additionalcontacts": "4175", "jd_templateid": 1, "jd_jobmultiquoteid": 5705, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5677", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ERTE0001", "jd_invoiceno": "", "jd_listprice": "0.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "0.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 22, "jd_updatedby": 22, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "0.000", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":22,\"44\":\"\",\"45\":\"Test\",\"46\":\"Er\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":22,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "0.000", "jd_commission": "\"\"", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5678", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748415931, "jd_updatedat": 1748415931 }, { "jd_id": 5679, "jd_customerid": 4002, "jd_contactid": 4176, "jd_additionalcontacts": "4176", "jd_templateid": 1, "jd_jobmultiquoteid": 5706, "jd_deletedcustokeyvalue": "{}", "jd_jobref": "AQ5678", "jd_jobstatus": 1, "jd_contactaddid": 0, "jd_orderstatus": 13, "jd_accref": "ASFD0001", "jd_invoiceno": "", "jd_listprice": "70.00", "jd_netprice": "70.00", "jd_vat": "5.43", "jd_isvaton": 1, "jd_deliverycost": "70.00", "jd_deliverycosttypeid": 1, "jd_overridetypeid": 1, "jd_orderformprice": "0.00", "jd_editpricebyid": 0, "jd_isroundon": 0, "jd_grossprice": "75.43", "jd_grossprofit": "70.00", "jd_costprice": "0.00", "jd_overrideprice": null, "jd_overridenetprice": null, "jd_overridevatprice": null, "jd_overridegrossprice": null, "jd_amountoutstanding": "75.43", "jd_totpaid": "0.00", "jd_creditlimit": "0.00", "jd_creditbalance": "0.00", "jd_overdue": "0.00", "jd_userdefinedarray": "\"\"", "jd_deliverycostid": 1, "jd_iscostpriceon": 0, "jd_isonlineorder": 1, "jd_isonlineordersubmitted": 0, "jd_endcustomervatprice": null, "jd_endcustomeroverridetype": 1, "jd_endcustomeroverridevalue": null, "jd_endcustomeroverridenetprice": "0.00", "jd_endcustomeroverridevatprice": "0.00", "jd_endcustomeroverridegrossprice": "0.00", "jd_endcustomerdeliverycost": null, "jd_endcustomerdeliverycostinclvat": 1, "jd_endcustomerfittingcost": null, "jd_endcustomerfittingcostinclvat": 1, "jd_onlinedeliveryaddreddtype": 0, "jd_onlinedeliveryaddreddid": null, "jd_seq": 0, "jd_status": 0, "jd_createdby": 15, "jd_updatedby": 15, "jd_deviceplatform": 0, "jd_fromjobref": "", "jd_importorder": 0, "jd_quickquote": 0, "jd_deliveryvatperc": "7.750", "jd_fromdbname": null, "jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":\"\",\"41\":15,\"44\":\"\",\"45\":\"Sfdsa\",\"46\":\"Asfd\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":12,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":15,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}", "jd_custompricefields": "", "jd_cdeliveryvatperc": "7.750", "jd_commission": "[]", "jd_commissionprice": "0.00", "jd_commissionsetting": 0, "jd_commissionaddedvalue": "0.00", "id": "5679", "jd_createddate": 1748390400, "jd_orderdate": null, "jd_duedate": null, "jd_sceduleddate": null, "jd_invoicedate": null, "jd_completeddate": null, "jd_sageexportdate": null, "jd_createdat": 1748417602, "jd_updatedat": 1748417602 } ], "deleted": [] }, "bm_orderitem": { "created": [ { "oi_id": 31278, "oi_jobid": 5675, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5702, "oi_productid": 298, "oi_recipeid": 307, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":11304,\"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\":11304,\"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\":10885,\"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\":10885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10886,\"labelname\":\"Supplier\",\"value\":14,\"valueid\":null,\"type\":17,\"optionid\":14,\"optionvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplierroll23\",\"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\":10886,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":14,\"optionsvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":10887,\"labelname\":\"Location\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Location\",\"fieldid\":10887,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10888,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Widthroll21\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":10888,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10889,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"DropRoll22\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":10889,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":11303,\"labelname\":\"Fitting height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting heightosihc\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Fitting height\",\"fieldid\":11303,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10890,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":10890,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10902,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":10902,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10891,\"labelname\":\"Fabric Roll\",\"value\":\"Standard Roll Fabric\",\"valueid\":\"79068\",\"type\":3,\"optionid\":\"1133\",\"optionvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79068,\"forchildfieldoptionlinkid\":\"3_79068\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Fabric Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fabric Roll\",\"fieldid\":10891,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1133\",\"optionsvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79068,\"forchildfieldoptionlinkid\":\"3_79068\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10892,\"labelname\":\"Fitting\",\"value\":\"Face Fit Blind\",\"valueid\":\"79070\",\"type\":3,\"optionid\":\"1135\",\"optionvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79070,\"forchildfieldoptionlinkid\":\"3_79070\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":\"1\"}],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":10892,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1135\",\"optionsvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79070,\"forchildfieldoptionlinkid\":\"3_79070\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":\"1\"}],\"editruleoverride\":0},{\"id\":10893,\"labelname\":\"Operation side\",\"value\":\"Right Hand\",\"valueid\":\"79072\",\"type\":3,\"optionid\":\"1137\",\"optionvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79072,\"forchildfieldoptionlinkid\":\"3_79072\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Operation sidevvry\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Operation side\",\"fieldid\":10893,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1137\",\"optionsvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79072,\"forchildfieldoptionlinkid\":\"3_79072\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10894,\"labelname\":\"Roller tube\",\"value\":\"White 40mm Components And Steel Coated Brackets\",\"valueid\":\"79074\",\"type\":3,\"optionid\":\"1139\",\"optionvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79074,\"forchildfieldoptionlinkid\":\"3_79074\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Roller tube\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roller tube\",\"fieldid\":10894,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1139\",\"optionsvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79074,\"forchildfieldoptionlinkid\":\"3_79074\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10895,\"labelname\":\"Chain Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Chain Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Chain Colour\",\"fieldid\":10895,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10896,\"labelname\":\"Fixing Plate\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing Plate\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fixing Plate\",\"fieldid\":10896,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10897,\"labelname\":\"Fascia\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fascia\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fascia\",\"fieldid\":10897,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10898,\"labelname\":\"Bottom Bars\",\"value\":\"Sewn In Bottom Bar\",\"valueid\":\"79114\",\"type\":3,\"optionid\":\"1179\",\"optionvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79114,\"forchildfieldoptionlinkid\":\"3_79114\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Bottom Bars\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Bottom Bars\",\"fieldid\":10898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1179\",\"optionsvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79114,\"forchildfieldoptionlinkid\":\"3_79114\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10899,\"labelname\":\"Motor\",\"value\":\"Rts Yewdale Motor\",\"valueid\":\"79127\",\"type\":3,\"optionid\":\"1192\",\"optionvalue\":[{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric\",\"unittype\":\"Each\",\"unitcost\":100,\"fieldoptionlinkid\":79127,\"forchildfieldoptionlinkid\":\"3_79127\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"160.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":160,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":80,\"sellingpriceType\":\"1\"}],\"issubfabric\":0,\"labelnamecode\":\"Motor\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Motor\",\"fieldid\":10899,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1192\",\"optionsvalue\":[{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric\",\"unittype\":\"Each\",\"unitcost\":100,\"fieldoptionlinkid\":79127,\"forchildfieldoptionlinkid\":\"3_79127\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"160.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":160,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":80,\"sellingpriceType\":\"1\"}],\"editruleoverride\":1},{\"id\":10900,\"labelname\":\"Special options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special options\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Special options\",\"fieldid\":10900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10901,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":10901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":11306,\"labelname\":\"Crank control\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Crank controlidsjcn\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Crank control\",\"fieldid\":11306,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: AQ Blinds, Fabric Roll: Standard Roll Fabric, Fitting: Face Fit Blind, Operation side: Right Hand, Roller tube: White 40mm Components And Steel Coated Brackets, Bottom Bars: Sewn In Bottom Bar, Motor: Rts Yewdale Motor", "oi_reportdescription": "##Quantity: 1##,##Supplier: AQ Blinds##,##Fabric Roll: Standard Roll Fabric##,##Fitting: Face Fit Blind##,##Operation side: Right Hand##,##Roller tube: White 40mm Components And Steel Coated Brackets##,##Bottom Bars: Sewn In Bottom Bar##,##Motor: Rts Yewdale Motor##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Fabric Roll:<\/br>##Fitting:<\/br>##Operation side:<\/br>##Roller tube:<\/br>##Bottom Bars:<\/br>##Motor:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":141,\"value\":null,\"formula\":\"DropRoll22\",\"price\":null,\"recipeid\":307,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":183,\"value\":\"1.00\",\"formula\":\"Motor_RtsYewdaleMotor_OptionQty\",\"price\":\"100.00\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":79127,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Rts Yewdale Motor\",\"list_option_name\":\"Rts Yewdale Motor\",\"list_description\":null,\"list_option_code\":\"AQR58\",\"list_unit_type\":\"Each\",\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":135,\"value\":\"-30.00\",\"formula\":\"Widthroll21-30\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"-30.00\"},{\"productionoveride\":0,\"id\":136,\"value\":\"-40.00\",\"formula\":\"Widthroll21-40\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"-40.00\"},{\"productionoveride\":0,\"id\":137,\"value\":\"300.00\",\"formula\":\"DropRoll22+300\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"300.00\"},{\"productionoveride\":0,\"id\":140,\"value\":null,\"formula\":\"Round((DropRoll22+DropAllowance)\\\/1000)\",\"price\":\"-\",\"recipeid\":307,\"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": "100.000", "oi_netprice": "160.000", "oi_pricesfromoperations": null, "oi_vatprice": "12.400", "oi_vatvalue": "7.750", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "172.400", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "160.000", "oi_endcustomeroverridevatprice": "12.400", "oi_endcustomeroverridegrossprice": "172.400", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[11304, 10885, 10886, 10887, 10888, 10889, 11303, 10890, 10902, 10891, 10892, 10893, 10894, 10895, 10896, 10897, 10898, 10899, 10900, 10901, 11306]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31278", "oi_productiondate": 1748390400, "oi_createdat": 1748432794, "oi_updatedat": 1748413454, "oi_createdby": 11, "oi_updatedby": 11 }, { "oi_id": 31279, "oi_jobid": 5674, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5701, "oi_productid": 298, "oi_recipeid": 307, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 4, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":11304,\"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\":11304,\"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\":10885,\"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\":10885,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10886,\"labelname\":\"Supplier\",\"value\":14,\"valueid\":null,\"type\":17,\"optionid\":14,\"optionvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplierroll23\",\"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\":10886,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":14,\"optionsvalue\":[{\"id\":14,\"optionid\":14,\"optionname\":\"AQ Blinds\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":10887,\"labelname\":\"Location\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Location\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Location\",\"fieldid\":10887,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10888,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Widthroll21\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":10888,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10889,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"DropRoll22\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":10889,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":11303,\"labelname\":\"Fitting height\",\"value\":null,\"valueid\":null,\"type\":6,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fitting heightosihc\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":6,\"mandatory\":0,\"fieldname\":\"Fitting height\",\"fieldid\":11303,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10890,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":10890,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10902,\"labelname\":\"Fabric\",\"value\":null,\"valueid\":null,\"type\":5,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":5,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":10902,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10891,\"labelname\":\"Fabric Roll\",\"value\":\"Standard Roll Fabric\",\"valueid\":\"79068\",\"type\":3,\"optionid\":\"1133\",\"optionvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79068,\"forchildfieldoptionlinkid\":\"3_79068\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Fabric Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fabric Roll\",\"fieldid\":10891,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1133\",\"optionsvalue\":[{\"optionid\":1133,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR01\",\"optionname\":\"Standard Roll Fabric\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79068,\"forchildfieldoptionlinkid\":\"3_79068\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10892,\"labelname\":\"Fitting\",\"value\":\"Face Fit Blind\",\"valueid\":\"79070\",\"type\":3,\"optionid\":\"1135\",\"optionvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79070,\"forchildfieldoptionlinkid\":\"3_79070\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":\"1\"}],\"issubfabric\":0,\"labelnamecode\":\"Fitting\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fitting\",\"fieldid\":10892,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1135\",\"optionsvalue\":[{\"optionid\":1135,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR03\",\"optionname\":\"Face Fit Blind\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79070,\"forchildfieldoptionlinkid\":\"3_79070\",\"hasstock\":0,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"0.00\",\"costprice\":0,\"costwithdiscount\":0,\"customersellingprice\":0,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":0,\"sellingpriceType\":\"1\"}],\"editruleoverride\":0},{\"id\":10893,\"labelname\":\"Operation side\",\"value\":\"Right Hand\",\"valueid\":\"79072\",\"type\":3,\"optionid\":\"1137\",\"optionvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79072,\"forchildfieldoptionlinkid\":\"3_79072\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Operation sidevvry\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Operation side\",\"fieldid\":10893,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1137\",\"optionsvalue\":[{\"optionid\":1137,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR05\",\"optionname\":\"Right Hand\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79072,\"forchildfieldoptionlinkid\":\"3_79072\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10894,\"labelname\":\"Roller tube\",\"value\":\"White 40mm Components And Steel Coated Brackets\",\"valueid\":\"79074\",\"type\":3,\"optionid\":\"1139\",\"optionvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79074,\"forchildfieldoptionlinkid\":\"3_79074\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Roller tube\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roller tube\",\"fieldid\":10894,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1139\",\"optionsvalue\":[{\"optionid\":1139,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR07\",\"optionname\":\"White 40mm Components And Steel Coated Brackets\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79074,\"forchildfieldoptionlinkid\":\"3_79074\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10895,\"labelname\":\"Chain Colour\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Chain Colour\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Chain Colour\",\"fieldid\":10895,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10896,\"labelname\":\"Fixing Plate\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing Plate\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fixing Plate\",\"fieldid\":10896,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10897,\"labelname\":\"Fascia\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fascia\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Fascia\",\"fieldid\":10897,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10898,\"labelname\":\"Bottom Bars\",\"value\":\"Sewn In Bottom Bar\",\"valueid\":\"79114\",\"type\":3,\"optionid\":\"1179\",\"optionvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79114,\"forchildfieldoptionlinkid\":\"3_79114\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Bottom Bars\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Bottom Bars\",\"fieldid\":10898,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1179\",\"optionsvalue\":[{\"optionid\":1179,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR47\",\"optionname\":\"Sewn In Bottom Bar\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric,Group H fabric\",\"unittype\":\"Each\",\"unitcost\":0,\"fieldoptionlinkid\":79114,\"forchildfieldoptionlinkid\":\"3_79114\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":0},{\"id\":10899,\"labelname\":\"Motor\",\"value\":\"Rts Yewdale Motor\",\"valueid\":\"79127\",\"type\":3,\"optionid\":\"1192\",\"optionvalue\":[{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric\",\"unittype\":\"Each\",\"unitcost\":100,\"fieldoptionlinkid\":79127,\"forchildfieldoptionlinkid\":\"3_79127\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"160.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":160,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":80,\"sellingpriceType\":\"1\"}],\"issubfabric\":0,\"labelnamecode\":\"Motor\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Motor\",\"fieldid\":10899,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1192\",\"optionsvalue\":[{\"optionid\":1192,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"AQR58\",\"optionname\":\"Rts Yewdale Motor\",\"pricegroups\":\"Price group B fabric,Price group C fabric,Price group D fabric,Price group E fabric,Price group F fabric,Price group G fabric,Group G + 10% fabric,Group G + 20% fabric\",\"unittype\":\"Each\",\"unitcost\":100,\"fieldoptionlinkid\":79127,\"forchildfieldoptionlinkid\":\"3_79127\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"160.00\",\"costprice\":100,\"costwithdiscount\":100,\"customersellingprice\":160,\"customermarkupvalue\":2,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":80,\"sellingpriceType\":\"1\"}],\"editruleoverride\":1},{\"id\":10900,\"labelname\":\"Special options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special options\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Special options\",\"fieldid\":10900,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10901,\"labelname\":\"Special Instructions\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Special Instructions\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Special Instructions\",\"fieldid\":10901,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":11306,\"labelname\":\"Crank control\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Crank controlidsjcn\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Crank control\",\"fieldid\":11306,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: AQ Blinds, Fabric Roll: Standard Roll Fabric, Fitting: Face Fit Blind, Operation side: Right Hand, Roller tube: White 40mm Components And Steel Coated Brackets, Bottom Bars: Sewn In Bottom Bar, Motor: Rts Yewdale Motor", "oi_reportdescription": "##Quantity: 1##,##Supplier: AQ Blinds##,##Fabric Roll: Standard Roll Fabric##,##Fitting: Face Fit Blind##,##Operation side: Right Hand##,##Roller tube: White 40mm Components And Steel Coated Brackets##,##Bottom Bars: Sewn In Bottom Bar##,##Motor: Rts Yewdale Motor##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Fabric Roll:<\/br>##Fitting:<\/br>##Operation side:<\/br>##Roller tube:<\/br>##Bottom Bars:<\/br>##Motor:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":141,\"value\":null,\"formula\":\"DropRoll22\",\"price\":null,\"recipeid\":307,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":183,\"value\":\"1.00\",\"formula\":\"Motor_RtsYewdaleMotor_OptionQty\",\"price\":\"100.00\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":79127,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Rts Yewdale Motor\",\"list_option_name\":\"Rts Yewdale Motor\",\"list_description\":null,\"list_option_code\":\"AQR58\",\"list_unit_type\":\"Each\",\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":135,\"value\":\"-30.00\",\"formula\":\"Widthroll21-30\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"-30.00\"},{\"productionoveride\":0,\"id\":136,\"value\":\"-40.00\",\"formula\":\"Widthroll21-40\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"-40.00\"},{\"productionoveride\":0,\"id\":137,\"value\":\"300.00\",\"formula\":\"DropRoll22+300\",\"price\":\"-\",\"recipeid\":307,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"300.00\"},{\"productionoveride\":0,\"id\":140,\"value\":null,\"formula\":\"Round((DropRoll22+DropAllowance)\\\/1000)\",\"price\":\"-\",\"recipeid\":307,\"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": "100.000", "oi_netprice": "160.000", "oi_pricesfromoperations": null, "oi_vatprice": "12.400", "oi_vatvalue": "7.750", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "172.400", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 0, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "160.000", "oi_endcustomeroverridevatprice": "12.400", "oi_endcustomeroverridegrossprice": "172.400", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[11304, 10885, 10886, 10887, 10888, 10889, 11303, 10890, 10902, 10891, 10892, 10893, 10894, 10895, 10896, 10897, 10898, 10899, 10900, 10901, 11306]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31279", "oi_productiondate": 1748390400, "oi_createdat": 1748433286, "oi_updatedat": 1748413539, "oi_createdby": 3985, "oi_updatedby": 3985 }, { "oi_id": 31280, "oi_jobid": 5676, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5703, "oi_productid": 297, "oi_recipeid": 306, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":10880,\"labelname\":\"Unit Type\",\"value\":\"3\",\"valueid\":\"3\",\"type\":34,\"optionid\":\"3\",\"optionvalue\":[{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"34_3\"}],\"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\":10880,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3\",\"optionsvalue\":[{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"34_3\"}],\"editruleoverride\":1},{\"id\":10879,\"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\":10879,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10881,\"labelname\":\"Supplier\",\"value\":\"3\",\"valueid\":null,\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":10881,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":10882,\"labelname\":\"Copy\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Copy\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Copy\",\"fieldid\":10882,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10883,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":10883,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10884,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":10884,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13432,\"labelname\":\"Product Type\",\"value\":509,\"valueid\":\"868\",\"type\":13,\"optionid\":509,\"optionvalue\":[{\"id\":868,\"fieldid\":13432,\"fieldoptionlinkid\":868,\"optionid\":509,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Price table 001\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":13432,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":509,\"optionsvalue\":[{\"id\":868,\"fieldid\":13432,\"fieldoptionlinkid\":868,\"optionid\":509,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Price table 001\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":13433,\"labelname\":\"Fabric\",\"value\":\"Heaven 3\",\"valueid\":\"5125\",\"type\":22,\"optionid\":\"5125\",\"optionvalue\":[{\"optionid\":5125,\"optionname\":\"Heaven 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5125,\"forchildfieldoptionlinkid\":\"22_2_5125_0\",\"subdatacount\":1,\"pricegroup\":\"Price table 001\",\"pricegroupid\":509}],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":22,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":13433,\"subchild\":[{\"fieldtypeid\":22,\"fieldid\":13585,\"status\":0,\"labelnamecode\":\"Color\",\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":2,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionsvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[],\"subchild\":[],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"hasstock\":1,\"optiondefault\":\"16662\",\"value\":\"16662\",\"fabricorcolor\":2,\"subfieldlinkid\":\"5125\",\"issubfabric\":0,\"forchildsubfieldlinkid\":\"22_2_5125_0\",\"masterparentfieldid\":13433,\"dualseq\":0,\"linktopricegroup\":0,\"fieldInformation\":null,\"multiseq\":1,\"editruleoverride\":1,\"dumydata\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"blindswidth\":0,\"stock_not_available_err\":true,\"stock_not_available_name_array\":[\"Feather 3\"]}],\"fieldInformation\":null,\"optiondefault\":\"5125\",\"optionsvalue\":[{\"optionid\":5125,\"optionname\":\"Heaven 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5125,\"forchildfieldoptionlinkid\":\"22_2_5125_0\",\"subdatacount\":1,\"pricegroup\":\"Price table 001\",\"pricegroupid\":509}],\"editruleoverride\":1},{\"id\":13585,\"labelname\":\"Color\",\"value\":\"Feather 3\",\"valueid\":\"16662\",\"type\":22,\"optionid\":\"16662\",\"optionvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":22,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":13585,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"16662\",\"optionsvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":13586,\"labelname\":\"Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Options\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Options\",\"fieldid\":13586,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Product Type: Price table 001, Fabric: Heaven 3, Color: Feather 3", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Product Type: Price table 001##,##Fabric: Heaven 3##,##Color: Feather 3##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Color:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":128,\"value\":null,\"formula\":\"Width\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":78667,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Curtain Rail\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":129,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"10.00\",\"recipeid\":306,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":130,\"value\":null,\"formula\":\"Width\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":131,\"value\":null,\"formula\":\"Drop\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":184,\"value\":null,\"formula\":\"ProductType_PriceTablePrice\",\"price\":null,\"recipeid\":306,\"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": "10.000", "oi_netprice": "20.000", "oi_pricesfromoperations": null, "oi_vatprice": "1.550", "oi_vatvalue": "7.750", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "21.550", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "20.000", "oi_endcustomeroverridevatprice": "1.550", "oi_endcustomeroverridegrossprice": "21.550", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[10880, 10879, 10881, 10882, 10883, 10884, 13432, 13433, 13585, 13586]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31280", "oi_productiondate": 1748390400, "oi_createdat": 1748435305, "oi_updatedat": 1748417880, "oi_createdby": 14, "oi_updatedby": 14 }, { "oi_id": 31281, "oi_jobid": 5676, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5703, "oi_productid": 251, "oi_recipeid": 253, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 2, "oi_customseq": 2, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":7326,\"labelname\":\"Unit Type\",\"value\":4,\"valueid\":\"4\",\"type\":34,\"optionid\":4,\"optionvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"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\":7326,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":4,\"optionsvalue\":[{\"optionid\":4,\"optionname\":\"Inches\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":4,\"forchildfieldoptionlinkid\":\"34_4\"}],\"editruleoverride\":0},{\"id\":7325,\"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\":7325,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7327,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":null,\"type\":17,\"optionid\":1,\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"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\":7327,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":1,\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":7328,\"labelname\":\"W\",\"value\":null,\"valueid\":null,\"type\":8,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"W\",\"fabricorcolor\":0,\"widthfraction\":\"0_Inches_1_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":8,\"mandatory\":0,\"fieldname\":\"W\",\"fieldid\":7328,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7329,\"labelname\":\"D\",\"value\":null,\"valueid\":null,\"type\":10,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"D\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_Inches_1_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":10,\"mandatory\":0,\"fieldname\":\"D\",\"fieldid\":7329,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7330,\"labelname\":\"Material\",\"value\":null,\"valueid\":null,\"type\":21,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Material\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":21,\"mandatory\":0,\"fieldname\":\"Material\",\"fieldid\":7330,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7401,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":7401,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":8456,\"labelname\":\"Copy\",\"value\":\"1 Channel\",\"valueid\":\"23924\",\"type\":3,\"optionid\":\"2683\",\"optionvalue\":[{\"optionid\":2683,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"TH1\",\"optionname\":\"1 Channel\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":170,\"fieldoptionlinkid\":23924,\"forchildfieldoptionlinkid\":\"3_23924\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"170.00\",\"costprice\":170,\"costwithdiscount\":170,\"customersellingprice\":170,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":170,\"sellingpriceType\":1}],\"issubfabric\":0,\"labelnamecode\":\"Copy\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":\"1\",\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Copy\",\"fieldid\":8456,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"2683\",\"optionsvalue\":[{\"optionid\":2683,\"optionqty\":\"1\",\"description\":null,\"optioncode\":\"TH1\",\"optionname\":\"1 Channel\",\"pricegroups\":null,\"unittype\":\"Each\",\"unitcost\":170,\"fieldoptionlinkid\":23924,\"forchildfieldoptionlinkid\":\"3_23924\",\"hasstock\":1,\"hasprice\":1,\"subdatacount\":0,\"optionimage\":null,\"reportprice\":\"170.00\",\"costprice\":170,\"costwithdiscount\":170,\"customersellingprice\":170,\"customermarkupvalue\":1,\"optiontype\":1,\"quantity\":1,\"optionnetprice\":170,\"sellingpriceType\":1}],\"editruleoverride\":1}]", "oi_description": "Supplier: Markilux, Copy: 1 Channel", "oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Copy: 1 Channel##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Copy:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":87,\"value\":\"2.00\",\"formula\":\"Quantity*2\",\"price\":\"340.00\",\"recipeid\":253,\"stockupdate\":0,\"fieldid\":23924,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"1 Channel\",\"fractionvalue\":\"2.00\"}]", "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\":\"Shutter cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":5}", "oi_productionstatus": null, "oi_costoverride": 0, "oi_costprice": "170.000", "oi_netprice": "170.000", "oi_pricesfromoperations": null, "oi_vatprice": "13.180", "oi_vatvalue": "7.750", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "183.180", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "170.000", "oi_endcustomeroverridevatprice": "13.180", "oi_endcustomeroverridegrossprice": "183.180", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[7326, 7325, 7327, 7328, 7329, 7330, 7401, 8456]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31281", "oi_productiondate": 1748437386, "oi_createdat": 1748437386, "oi_updatedat": 1748417880, "oi_createdby": 14, "oi_updatedby": null } ], "updated": [ { "oi_id": 31280, "oi_jobid": 5676, "oi_jobtempid": "0", "oi_jobmultiquoteid": 5703, "oi_productid": 297, "oi_recipeid": 306, "oi_ruleid": 0, "oi_qty": 1, "oi_seq": 1, "oi_customseq": 1, "oi_productcustomseq": 1, "oi_jsondata": "[{\"id\":10880,\"labelname\":\"Unit Type\",\"value\":\"3\",\"valueid\":\"3\",\"type\":34,\"optionid\":\"3\",\"optionvalue\":[{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"34_3\"}],\"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\":10880,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3\",\"optionsvalue\":[{\"optionid\":3,\"optionname\":\"m\",\"optioncode\":null,\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":3,\"forchildfieldoptionlinkid\":\"34_3\"}],\"editruleoverride\":1},{\"id\":10879,\"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\":10879,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10881,\"labelname\":\"Supplier\",\"value\":\"3\",\"valueid\":null,\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"issubfabric\":0,\"labelnamecode\":\"Supplier\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":17,\"mandatory\":0,\"fieldname\":\"Supplier\",\"fieldid\":10881,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"3\",\"optionsvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":10882,\"labelname\":\"Copy\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Copy\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Copy\",\"fieldid\":10882,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10883,\"labelname\":\"Width\",\"value\":null,\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0___0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":10883,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":10884,\"labelname\":\"Drop\",\"value\":null,\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0___0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":10884,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":13432,\"labelname\":\"Product Type\",\"value\":509,\"valueid\":\"868\",\"type\":13,\"optionid\":509,\"optionvalue\":[{\"id\":868,\"fieldid\":13432,\"fieldoptionlinkid\":868,\"optionid\":509,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Price table 001\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"issubfabric\":0,\"labelnamecode\":\"Product Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":13,\"mandatory\":0,\"fieldname\":\"Product Type\",\"fieldid\":13432,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":509,\"optionsvalue\":[{\"id\":868,\"fieldid\":13432,\"fieldoptionlinkid\":868,\"optionid\":509,\"mainsupplier\":\"3\",\"blindtypecode\":null,\"optionname\":\"Price table 001\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":0},{\"id\":13433,\"labelname\":\"Fabric\",\"value\":\"Heaven 3\",\"valueid\":\"5125\",\"type\":22,\"optionid\":\"5125\",\"optionvalue\":[{\"optionid\":5125,\"optionname\":\"Heaven 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5125,\"forchildfieldoptionlinkid\":\"22_2_5125_0\",\"subdatacount\":1,\"pricegroup\":\"Price table 001\",\"pricegroupid\":509}],\"issubfabric\":0,\"labelnamecode\":\"Fabric\",\"fabricorcolor\":1,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":22,\"mandatory\":0,\"fieldname\":\"Fabric\",\"fieldid\":13433,\"subchild\":[{\"fieldtypeid\":22,\"fieldid\":13585,\"status\":0,\"labelnamecode\":\"Color\",\"fieldname\":\"Color\",\"field_has_sub_option\":1,\"selection\":0,\"seq\":2,\"mandatory\":0,\"fieldlevel\":2,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionsvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"optionsbackup\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editablecolumns\":[],\"subchild\":[],\"optionsselectedcolumns\":{\"optionid\":\"Option Id\",\"optionname\":\"Color Name\",\"optioncode\":\"Color Code\"},\"hasstock\":1,\"optiondefault\":\"16662\",\"value\":\"16662\",\"fabricorcolor\":2,\"subfieldlinkid\":\"5125\",\"issubfabric\":0,\"forchildsubfieldlinkid\":\"22_2_5125_0\",\"masterparentfieldid\":13433,\"dualseq\":0,\"linktopricegroup\":0,\"fieldInformation\":null,\"multiseq\":1,\"editruleoverride\":1,\"dumydata\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"blindswidth\":0,\"stock_not_available_err\":true,\"stock_not_available_name_array\":[\"Feather 3\"]}],\"fieldInformation\":null,\"optiondefault\":\"5125\",\"optionsvalue\":[{\"optionid\":5125,\"optionname\":\"Heaven 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":5125,\"forchildfieldoptionlinkid\":\"22_2_5125_0\",\"subdatacount\":1,\"pricegroup\":\"Price table 001\",\"pricegroupid\":509}],\"editruleoverride\":1},{\"id\":13585,\"labelname\":\"Color\",\"value\":\"Feather 3\",\"valueid\":\"16662\",\"type\":22,\"optionid\":\"16662\",\"optionvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"issubfabric\":0,\"labelnamecode\":\"Color\",\"fabricorcolor\":2,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":2,\"fieldtypeid\":22,\"mandatory\":0,\"fieldname\":\"Color\",\"fieldid\":13585,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"16662\",\"optionsvalue\":[{\"optionid\":16662,\"optionname\":\"Feather 3\",\"optioncode\":null,\"optionquantity\":1,\"fieldoptionlinkid\":16662,\"forchildfieldoptionlinkid\":\"22_16662\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"subdatacount\":0,\"optionimage\":null}],\"editruleoverride\":1},{\"id\":13586,\"labelname\":\"Options\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Options\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Options\",\"fieldid\":13586,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]", "oi_description": "Supplier: Decora, Product Type: Price table 001, Fabric: Heaven 3, Color: Feather 3", "oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Product Type: Price table 001##,##Fabric: Heaven 3##,##Color: Feather 3##", "oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Product Type:<\/br>##Fabric:<\/br>##Color:", "oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":128,\"value\":null,\"formula\":\"Width\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":78667,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":3,\"option_name\":\"Curtain Rail\",\"fractionvalue\":null},{\"productionoveride\":0,\"id\":129,\"value\":\"1.00\",\"formula\":\"Quantity\",\"price\":\"10.00\",\"recipeid\":306,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":\"1.00\"},{\"productionoveride\":0,\"id\":130,\"value\":null,\"formula\":\"Width\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":131,\"value\":null,\"formula\":\"Drop\",\"price\":null,\"recipeid\":306,\"stockupdate\":0,\"fieldid\":0,\"isdelete\":0,\"defaultstock\":1,\"fieldtype_id\":0,\"fractionvalue\":null},{\"productionoveride\":0,\"id\":184,\"value\":null,\"formula\":\"ProductType_PriceTablePrice\",\"price\":null,\"recipeid\":306,\"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": "10.000", "oi_netprice": "20.000", "oi_pricesfromoperations": null, "oi_vatprice": "1.550", "oi_vatvalue": "7.750", "oi_vatselected": 1, "oi_vattype": 1, "oi_vatonoff": 1, "oi_grossprice": "21.550", "oi_overrideprice": "0.000", "oi_overridetype": 1, "oi_overridevalue": null, "oi_overridenetprice": "0.000", "oi_overridevatprice": "0.000", "oi_overridegrossprice": "0.000", "oi_ready": 0, "oi_onhold": 0, "oi_platformcreatedfrom": "web", "oi_copiedfrom": 0, "oi_isonlineorder": 1, "oi_endcustomervatprice": null, "oi_endcustomeroverridetype": 1, "oi_endcustomeroverridevalue": null, "oi_endcustomeroverridenetprice": "20.000", "oi_endcustomeroverridevatprice": "1.550", "oi_endcustomeroverridegrossprice": "21.550", "oi_sage_flag": 0, "oi_status": 0, "oi_jsondataid": "[10880, 10879, 10881, 10882, 10883, 10884, 13432, 13433, 13585, 13586]", "oi_deviceplatform": 0, "oi_custompricefields": "", "oi_editransfer": 0, "oi_apisup_orderid": 0, "oi_commissionprice": "0.000", "oi_commissionvatprice": "0.000", "id": "31280", "oi_productiondate": 1748390400, "oi_createdat": 1748435305, "oi_updatedat": 1748417880, "oi_createdby": 14, "oi_updatedby": 14 } ], "deleted": [] }, "bm_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_notelist": { "created": [], "updated": [], "deleted": [] }, "bm_deliveryaddresssetting": { "created": [ { "das_id": 5547, "das_jobid": 5676, "das_appointmentaddress": 4173, "das_invoiceaddress": 4173, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5547", "das_createdat": 1748415488, "das_updatedat": 1748415488, "das_createdby": 14, "das_updatedby": null }, { "das_id": 5548, "das_jobid": 5677, "das_appointmentaddress": 4174, "das_invoiceaddress": 4174, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5548", "das_createdat": 1748415887, "das_updatedat": 1748415887, "das_createdby": 22, "das_updatedby": null }, { "das_id": 5549, "das_jobid": 5678, "das_appointmentaddress": 4175, "das_invoiceaddress": 4175, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5549", "das_createdat": 1748415931, "das_updatedat": 1748415931, "das_createdby": 22, "das_updatedby": null }, { "das_id": 5550, "das_jobid": 5679, "das_appointmentaddress": 4176, "das_invoiceaddress": 4176, "das_invoicedeliveryaddress": 0, "das_purchaseaddress": 0, "das_worksheetaddress": 0, "id": "5550", "das_createdat": 1748417602, "das_updatedat": 1748417602, "das_createdby": 15, "das_updatedby": null } ], "updated": [], "deleted": [] }, "bm_jobchecklist": { "created": [], "updated": [], "deleted": [] }, "bm_Invoice": { "created": [], "updated": [], "deleted": [] }, "bm_InvoiceDetails": { "created": [], "updated": [], "deleted": [] }, "bm_invoice_credit_note": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNote": { "created": [], "updated": [], "deleted": [] }, "bm_CreditNoteDetails": { "created": [], "updated": [], "deleted": [] }, "bm_job_paymentlist": { "created": [], "updated": [], "deleted": [] }, "bm_OverPayment": { "created": [], "updated": [], "deleted": [] }, "bm_terms": { "created": [ { "termsid": 17566, "orderid": 5676, "jobmultiquoteid": 5703, "isresportshow": 1, "termsCategory": 2, "termsName": "Standard", "termsDescription": "