{
"status": "success",
"upcomingorder_list": {
"bm_customertemplatedata": {
"created": [],
"updated": [
{
"ctd_id": 3913,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 25, \"600\": 25, \"62\": \"RREN0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3913",
"ctd_createdat": 1747123210,
"ctd_updatedat": 1747123869,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3914,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"62\": \"HHAS0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": 25}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 1,
"ctd_foronlineisenable": 1,
"ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"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": "3914",
"ctd_createdat": 1747125071,
"ctd_updatedat": 1747125072,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 22,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 3, \"62\": \"CONW7211\", \"63\": \"Hillcroft School\", \"64\": 29, \"65\": \"kirija8890@gmail.com\", \"66\": \"\", \"67\": \"Chaldon Road \", \"68\": \"Surrey \", \"69\": \"\", \"70\": \"CR3 5PG\", \"71\": \"Caterham \", \"72\": 36, \"73\": \"\", \"568\": \"\", \"600\": 25}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": "0",
"ctd_defaultstaff": "",
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 1,
"ctd_foronlineisenable": 1,
"ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245",
"ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": "2",
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "22",
"ctd_createdat": 1706524844,
"ctd_updatedat": 1747130220,
"ctd_createdby": 1,
"ctd_updatedby": 10
},
{
"ctd_id": 3915,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"62\": \"LLEY0001\", \"63\": \"\", \"61\": \"4\", \"600\": 25, \"64\": 25}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 1,
"ctd_foronlineisenable": 1,
"ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"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": "3915",
"ctd_createdat": 1747126903,
"ctd_updatedat": 1747126903,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3916,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"62\": \"SRIH0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": 25}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 1,
"ctd_foronlineisenable": 1,
"ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"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": "3916",
"ctd_createdat": 1747127581,
"ctd_updatedat": 1747127720,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3917,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"62\": \"KKIR0001\", \"63\": \"\", \"61\": 1, \"600\": 25, \"64\": 25}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 1,
"ctd_foronlineisenable": 1,
"ctd_enabledproductdesktop": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"ctd_enabledproductonline": "3,4,6,8,9,10,11,12,13,14,15,18,20,21,23,24,25,27,29,30,31,32,33,34,138,144,146,147,148,150,161,177,183,184,185,188,195,196,197,198,199,200,201,202,203,204,206,207,208,210,213,215,216,217,221,222,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272",
"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": "3917",
"ctd_createdat": 1747127855,
"ctd_updatedat": 1747127855,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3918,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 2, \"64\": 25, \"600\": 25, \"62\": \"KKOW0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3918",
"ctd_createdat": 1747124143,
"ctd_updatedat": 1747127928,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3919,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 5, \"64\": 25, \"600\": 25, \"62\": \"LAVE0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3919",
"ctd_createdat": 1747124212,
"ctd_updatedat": 1747127928,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3920,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 25, \"600\": 25, \"62\": \"KKAV0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3920",
"ctd_createdat": 1747128167,
"ctd_updatedat": 1747128203,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3921,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 25, \"600\": 25, \"62\": \"LEON0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3921",
"ctd_createdat": 1747131042,
"ctd_updatedat": 1747131150,
"ctd_createdby": 0,
"ctd_updatedby": null
},
{
"ctd_id": 3922,
"ctd_createdfrom": 0,
"ctd_templateid": 2,
"ctd_moduleid": 3,
"ctd_latitude": "",
"ctd_longitude": "",
"ctd_leadimage": null,
"ctd_jobcustomoizedkeyvalue": "",
"ctd_customoizedkeyvalue": "{\"61\": 1, \"64\": 25, \"600\": 25, \"62\": \"GGRA0001\"}",
"ctd_deletedcustokeyvalue": "{}",
"ctd_isenablecustspecvatrate": 0,
"ctd_custspecvatrate": "0.00",
"ctd_vatregnum": null,
"ctd_custsurcharge": null,
"ctd_defaultdelcost": null,
"ctd_defaultapptype": null,
"ctd_defaultstaff": null,
"ctd_addcredit": "0.00",
"ctd_totredeemed": "0.00",
"ctd_balance": "0.00",
"ctd_creditlimit": "0.00",
"ctd_creditavailable": "0.00",
"ctd_overdue": 0,
"ctd_paymenttermstype": 0,
"ctd_paymenttermsvalue": 0,
"ctd_paymenttermsdesc": null,
"ctd_ishold": 0,
"ctd_jobview": 0,
"ctd_jobtypeview": 0,
"ctd_discount": "0.00",
"ctd_language": 0,
"ctd_notymsg": 0,
"ctd_onlinelogoname": null,
"ctd_onlinelogo": null,
"ctd_onlinesendemail": 0,
"ctd_fordesktopisenable": 0,
"ctd_foronlineisenable": 0,
"ctd_enabledproductdesktop": "0",
"ctd_enabledproductonline": "0",
"ctd_onlineproductmarkup": null,
"ctd_onlineendcustomeruseprefix": null,
"ctd_onlineendcustomersequence": null,
"ctd_onlinequotecustomerterms": null,
"ctd_onlinequotepaymentterms": null,
"ctd_onlineinvoicecustomerterms": null,
"ctd_onlineinvoicepaymentterms": null,
"ctd_seq": 0,
"ctd_status": 0,
"id": "3922",
"ctd_createdat": 1747131026,
"ctd_updatedat": 1747131563,
"ctd_createdby": 0,
"ctd_updatedby": null
}
],
"deleted": []
},
"bm_customercontactinfo": {
"created": [],
"updated": [
{
"cci_id": 3985,
"cci_customerid": 22,
"cci_templateid": 3,
"roleid": 2,
"cci_customizedarray": "{\"82\":\"kirija8890@gmail.com\",\"77\":\"Karthika\",\"79\":\"Ramesh\",\"78\":\"\",\"76\":\"\",\"81\":\"0\",\"75\":11,\"83\":0}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":36,\"86\":\"\",\"91\":\"\",\"88\":\"\"}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": "[null,null,null,null,null,null]",
"cci_isonlineportal": 1,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": "Karthika",
"cci_password": "Test@123",
"cci_confirmpassword": "Test@123",
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 0,
"cci_mobcustomertempid": 0,
"id": "3985",
"cci_createdat": 1745579210,
"cci_updatedat": 1747126885,
"cci_createdby": 10,
"cci_updatedby": 1
},
{
"cci_id": 4085,
"cci_customerid": 3913,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":1,\"77\":\"Renault \",\"79\":\"R\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31747123210,
"id": "4085",
"cci_createdat": 1747123211,
"cci_updatedat": 1747123869,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4086,
"cci_customerid": 3914,
"cci_templateid": 3,
"roleid": 1,
"cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Hasini\",\"79\":\"H\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":1,\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"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": "4086",
"cci_createdat": 1747125071,
"cci_updatedat": 1747125071,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4087,
"cci_customerid": 3915,
"cci_templateid": 3,
"roleid": 1,
"cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Leya\",\"79\":\"L\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":1,\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"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": "4087",
"cci_createdat": 1747126903,
"cci_updatedat": 1747126903,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4088,
"cci_customerid": 3916,
"cci_templateid": 3,
"roleid": 1,
"cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Hemasrii\",\"79\":\"Sri\",\"78\":\"77897755\",\"76\":\"\",\"81\":\"\",\"75\":1,\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"Rr Nagar , Kenchenhallli Street ,rr Nagar \",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"560098\"}",
"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": "4088",
"cci_createdat": 1747127582,
"cci_updatedat": 1747127582,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4089,
"cci_customerid": 3917,
"cci_templateid": 3,
"roleid": 1,
"cci_customizedarray": "{\"62\":\"\",\"82\":\"\",\"77\":\"Kiran\",\"79\":\"K\",\"78\":\"\",\"76\":\"\",\"81\":\"\",\"75\":1,\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"87\":\"\",\"89\":\"\",\"90\":4,\"86\":\"\",\"91\":\"\",\"88\":\"560098\"}",
"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": "4089",
"cci_createdat": 1747127855,
"cci_updatedat": 1747127855,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4090,
"cci_customerid": 3918,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":1,\"77\":\"Kowshik\",\"79\":\"K\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31747124143,
"id": "4090",
"cci_createdat": 1747124143,
"cci_updatedat": 1747127928,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4091,
"cci_customerid": 3919,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":3,\"77\":\"Laveis\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31747124212,
"id": "4091",
"cci_createdat": 1747124212,
"cci_updatedat": 1747127928,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4092,
"cci_customerid": 3920,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":1,\"77\":\"Kavi \",\"79\":\"K\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"88\":\"569008\",\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31747128167,
"id": "4092",
"cci_createdat": 1747128167,
"cci_updatedat": 1747128203,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4093,
"cci_customerid": 3921,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":11,\"77\":\"Caro\",\"79\":\"Leon\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 1,
"cci_mobcustomertempid": 31747131042,
"id": "4093",
"cci_createdat": 1747131042,
"cci_updatedat": 1747131150,
"cci_createdby": 0,
"cci_updatedby": null
},
{
"cci_id": 4094,
"cci_customerid": 3922,
"cci_templateid": 3,
"roleid": 0,
"cci_customizedarray": "{\"75\":2,\"77\":\"Granna\",\"79\":\"G\",\"83\":\"1\"}",
"cci_customizedarraydel": "{}",
"cci_addressinfo": "{\"88\":\"560099\",\"90\":4}",
"cci_ismarketingemails": 0,
"cci_smsverifystatus": 0,
"cci_isdocumentreceived": 0,
"cci_receiveddocfor": null,
"cci_isonlineportal": 0,
"cci_latitude": null,
"cci_longitude": null,
"cci_username": null,
"cci_password": null,
"cci_confirmpassword": null,
"cci_seq": 0,
"cci_status": 0,
"cci_deviceplatform": 2,
"cci_mobcustomertempid": 31747131026,
"id": "4094",
"cci_createdat": 1747131026,
"cci_updatedat": 1747131563,
"cci_createdby": 0,
"cci_updatedby": null
}
],
"deleted": []
},
"bm_appointment": {
"created": [
{
"app_eventid": 9944,
"app_description": null,
"app_summary": "AQ5528-Quote 10-Quote 10",
"app_private": 0,
"app_appointmentType": 64,
"app_userId": 2,
"app_orderId": 5519,
"app_customerId": 0,
"app_isAllDay": 0,
"app_timezone": "Asia\/Kolkata",
"app_latitude": 0,
"app_longitude": 0,
"app_parentappid": null,
"app_recurrencerule": null,
"app_userdefinedValue": "[]",
"app_recurrenceexception": null,
"app_attachment": "[\"\\\/storage\\\/attachments\\\/TESTING2TEST\\\/calendar\\\/9944_mobileattachment1747131563_0.jpg\",\"\\\/storage\\\/attachments\\\/TESTING2TEST\\\/calendar\\\/9944_mobileattachment1747131563_1.jpg\"]",
"guid": "",
"app_staff": "",
"app_appointtype": "",
"app_confirmed": 0,
"app_travelHour": "0",
"app_travelMinute": "0",
"app_onsiteHour": null,
"app_onsiteMinute": null,
"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": "0",
"app_jobtimeminute": "30",
"app_products": null,
"app_deviceplatform": 2,
"app_recurrenceexception_date": null,
"app_deliveryaddressid": 4084,
"id": "9944",
"app_sdate": 1747094400,
"app_edate": 1747094400,
"app_stime": 1747121423,
"app_etime": 1747123223,
"app_sdatetime": 1747121423,
"app_edatetime": 1747123223,
"app_until": null,
"app_createdAt": 1747123134,
"app_updatedAt": 1747131563,
"app_createdBy": 1,
"app_updatedBy": null
}
],
"updated": [],
"deleted": []
},
"bm_tasklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_jobdetails": {
"created": [
{
"jd_id": 5520,
"jd_customerid": 3913,
"jd_contactid": 4085,
"jd_additionalcontacts": "4085",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5544,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5529",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "RREN0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5529\",\"35\":\"RREN0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Renault \",\"46\":\"R\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5520",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747123211,
"jd_updatedat": 1747123869
},
{
"jd_id": 5521,
"jd_customerid": 3914,
"jd_contactid": 4086,
"jd_additionalcontacts": "4086",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5545,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5530",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "HHAS0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": "\"\"",
"jd_deliverycostid": 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": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":25,\"41\":1,\"44\":\"\",\"45\":\"Hasini\",\"46\":\"H\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5521",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747125071,
"jd_updatedat": 1747125072
},
{
"jd_id": 5522,
"jd_customerid": 22,
"jd_contactid": 3985,
"jd_additionalcontacts": "3985",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5546,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5531",
"jd_jobstatus": 4,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "CONW7211",
"jd_invoiceno": "",
"jd_listprice": "55.00",
"jd_netprice": "55.00",
"jd_vat": "12.10",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "67.10",
"jd_grossprofit": "0.00",
"jd_costprice": "55.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "67.10",
"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": "",
"jd_endcustomeroverridenetprice": "55.00",
"jd_endcustomeroverridevatprice": "12.10",
"jd_endcustomeroverridegrossprice": "67.10",
"jd_endcustomerdeliverycost": "",
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": "",
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":3,\"39\":29,\"41\":1,\"44\":\"Hillcroft School\",\"45\":\"Karthika\",\"46\":\"Ramesh\",\"47\":\"\",\"48\":\"kirija8890@gmail.com\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"0\",\"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": "5522",
"jd_createddate": 1747094400,
"jd_orderdate": 1747094400,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747126885,
"jd_updatedat": 1747130220
},
{
"jd_id": 5523,
"jd_customerid": 3915,
"jd_contactid": 4087,
"jd_additionalcontacts": "4087",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5547,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5532",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LLEY0001",
"jd_invoiceno": "",
"jd_listprice": "70.00",
"jd_netprice": "70.00",
"jd_vat": "15.40",
"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": "85.40",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "85.40",
"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": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":\"4\",\"39\":25,\"41\":1,\"44\":\"\",\"45\":\"Leya\",\"46\":\"L\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5523",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747126903,
"jd_updatedat": 1747126903
},
{
"jd_id": 5524,
"jd_customerid": 3916,
"jd_contactid": 4088,
"jd_additionalcontacts": "4088",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5548,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5533",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "SRIH0001",
"jd_invoiceno": "",
"jd_listprice": "70.00",
"jd_netprice": "70.00",
"jd_vat": "0.00",
"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": "70.00",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "70.00",
"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": "",
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": "",
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": "",
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"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\":25,\"41\":1,\"44\":\"\",\"45\":\"Hemasrii\",\"46\":\"Sri\",\"47\":\"77897755\",\"48\":\"\",\"49\":\"Rr Nagar , Kenchenhallli Street ,rr Nagar \",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560098\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"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": "5524",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747127582,
"jd_updatedat": 1747127720
},
{
"jd_id": 5525,
"jd_customerid": 3917,
"jd_contactid": 4089,
"jd_additionalcontacts": "4089",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5549,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5534",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKIR0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": "\"\"",
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 1,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"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\":25,\"41\":1,\"44\":\"\",\"45\":\"Kiran\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560098\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"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": "5525",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747127855,
"jd_updatedat": 1747127855
},
{
"jd_id": 5526,
"jd_customerid": 3918,
"jd_contactid": 4090,
"jd_additionalcontacts": "4090",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5550,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5535",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKOW0001",
"jd_invoiceno": "",
"jd_listprice": "19.10",
"jd_netprice": "89.10",
"jd_vat": "19.60",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "108.70",
"jd_grossprofit": "70.00",
"jd_costprice": "18.37",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "108.70",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5535\",\"35\":\"KKOW0001\",\"36\":1,\"37\":2,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kowshik\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5526",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747124143,
"jd_updatedat": 1747127929
},
{
"jd_id": 5527,
"jd_customerid": 3919,
"jd_contactid": 4091,
"jd_additionalcontacts": "4091",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5551,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5536",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LAVE0001",
"jd_invoiceno": "",
"jd_listprice": "18.37",
"jd_netprice": "88.37",
"jd_vat": "19.44",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "107.81",
"jd_grossprofit": "70.00",
"jd_costprice": "18.37",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "107.81",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5536\",\"35\":\"LAVE0001\",\"36\":1,\"37\":5,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Laveis\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":3,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5527",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747124212,
"jd_updatedat": 1747127929
},
{
"jd_id": 5528,
"jd_customerid": 3920,
"jd_contactid": 4092,
"jd_additionalcontacts": "4092",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5552,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5537",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKAV0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5537\",\"35\":\"KKAV0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kavi \",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"569008\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "0.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5528",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747128167,
"jd_updatedat": 1747128204
},
{
"jd_id": 5529,
"jd_customerid": 3921,
"jd_contactid": 4093,
"jd_additionalcontacts": "4093",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5553,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5538",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LEON0001",
"jd_invoiceno": "",
"jd_listprice": "400.00",
"jd_netprice": "400.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "400.00",
"jd_grossprofit": "0.00",
"jd_costprice": "400.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "350.00",
"jd_totpaid": "50.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5538\",\"35\":\"LEON0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Caro\",\"46\":\"Leon\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "0.000",
"jd_commission": null,
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5529",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747131043,
"jd_updatedat": 1747131288
},
{
"jd_id": 5530,
"jd_customerid": 3922,
"jd_contactid": 4094,
"jd_additionalcontacts": "4094",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5554,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5539",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "GGRA0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "70.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "70.00",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "70.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5539\",\"35\":\"GGRA0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Granna\",\"46\":\"G\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560099\",\"54\":4,\"285\":2,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5530",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747131026,
"jd_updatedat": 1747131563
}
],
"updated": [
{
"jd_id": 5517,
"jd_customerid": 22,
"jd_contactid": 3985,
"jd_additionalcontacts": "3985",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5541,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5526",
"jd_jobstatus": 6,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "CONW7211",
"jd_invoiceno": "Invoice9607",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": "\"\"",
"jd_deliverycostid": 1,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 1,
"jd_endcustomeroverridevalue": "",
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": "",
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": "",
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":3,\"39\":29,\"41\":1,\"44\":\"Hillcroft School\",\"45\":\"Karthika\",\"46\":\"Ramesh\",\"47\":\"\",\"48\":\"kirija8890@gmail.com\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"0\",\"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": "5517",
"jd_createddate": 1747008000,
"jd_orderdate": 1747094400,
"jd_duedate": 1747008000,
"jd_sceduleddate": null,
"jd_invoicedate": 1747094400,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747061184,
"jd_updatedat": 1747128372
},
{
"jd_id": 5519,
"jd_customerid": 3912,
"jd_contactid": 4084,
"jd_additionalcontacts": "4084",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5543,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5528",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "QUOT0009",
"jd_invoiceno": "",
"jd_listprice": "100.00",
"jd_netprice": "170.00",
"jd_vat": "37.40",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "207.40",
"jd_grossprofit": "70.00",
"jd_costprice": "100.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "207.40",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 10,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5528\",\"35\":\"QUOT0009\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"\",\"46\":\"Quote 10\",\"47\":\"\",\"48\":\"\",\"49\":\"Quote 10\",\"50\":\"\",\"51\":\"Quote 10\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": null,
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5519",
"jd_createddate": 1747008000,
"jd_orderdate": null,
"jd_duedate": 1747008000,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747058749,
"jd_updatedat": 1747131563
},
{
"jd_id": 5520,
"jd_customerid": 3913,
"jd_contactid": 4085,
"jd_additionalcontacts": "4085",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5544,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5529",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "RREN0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5529\",\"35\":\"RREN0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Renault \",\"46\":\"R\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5520",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747123211,
"jd_updatedat": 1747123869
},
{
"jd_id": 5521,
"jd_customerid": 3914,
"jd_contactid": 4086,
"jd_additionalcontacts": "4086",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5545,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5530",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "HHAS0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": "\"\"",
"jd_deliverycostid": 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": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":1,\"39\":25,\"41\":1,\"44\":\"\",\"45\":\"Hasini\",\"46\":\"H\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5521",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747125071,
"jd_updatedat": 1747125072
},
{
"jd_id": 5522,
"jd_customerid": 22,
"jd_contactid": 3985,
"jd_additionalcontacts": "3985",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5546,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5531",
"jd_jobstatus": 4,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "CONW7211",
"jd_invoiceno": "",
"jd_listprice": "55.00",
"jd_netprice": "55.00",
"jd_vat": "12.10",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "67.10",
"jd_grossprofit": "0.00",
"jd_costprice": "55.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "67.10",
"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": "",
"jd_endcustomeroverridenetprice": "55.00",
"jd_endcustomeroverridevatprice": "12.10",
"jd_endcustomeroverridegrossprice": "67.10",
"jd_endcustomerdeliverycost": "",
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": "",
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":3,\"39\":29,\"41\":1,\"44\":\"Hillcroft School\",\"45\":\"Karthika\",\"46\":\"Ramesh\",\"47\":\"\",\"48\":\"kirija8890@gmail.com\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":36,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"0\",\"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": "5522",
"jd_createddate": 1747094400,
"jd_orderdate": 1747094400,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747126885,
"jd_updatedat": 1747130220
},
{
"jd_id": 5523,
"jd_customerid": 3915,
"jd_contactid": 4087,
"jd_additionalcontacts": "4087",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5547,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5532",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LLEY0001",
"jd_invoiceno": "",
"jd_listprice": "70.00",
"jd_netprice": "70.00",
"jd_vat": "15.40",
"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": "85.40",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "85.40",
"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": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"33\":25,\"37\":\"4\",\"39\":25,\"41\":1,\"44\":\"\",\"45\":\"Leya\",\"46\":\"L\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5523",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747126903,
"jd_updatedat": 1747126903
},
{
"jd_id": 5524,
"jd_customerid": 3916,
"jd_contactid": 4088,
"jd_additionalcontacts": "4088",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5548,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5533",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "SRIH0001",
"jd_invoiceno": "",
"jd_listprice": "70.00",
"jd_netprice": "70.00",
"jd_vat": "0.00",
"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": "70.00",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "70.00",
"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": "",
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": "",
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": "",
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"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\":25,\"41\":1,\"44\":\"\",\"45\":\"Hemasrii\",\"46\":\"Sri\",\"47\":\"77897755\",\"48\":\"\",\"49\":\"Rr Nagar , Kenchenhallli Street ,rr Nagar \",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560098\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"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": "5524",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747127582,
"jd_updatedat": 1747127720
},
{
"jd_id": 5525,
"jd_customerid": 3917,
"jd_contactid": 4089,
"jd_additionalcontacts": "4089",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5549,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5534",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKIR0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": 0,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": "\"\"",
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 1,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 1,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 1,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": null,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"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\":25,\"41\":1,\"44\":\"\",\"45\":\"Kiran\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560098\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"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": "5525",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747127855,
"jd_updatedat": 1747127855
},
{
"jd_id": 5526,
"jd_customerid": 3918,
"jd_contactid": 4090,
"jd_additionalcontacts": "4090",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5550,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5535",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKOW0001",
"jd_invoiceno": "",
"jd_listprice": "19.10",
"jd_netprice": "89.10",
"jd_vat": "19.60",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "108.70",
"jd_grossprofit": "70.00",
"jd_costprice": "18.37",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "108.70",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5535\",\"35\":\"KKOW0001\",\"36\":1,\"37\":2,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kowshik\",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5526",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747124143,
"jd_updatedat": 1747127929
},
{
"jd_id": 5527,
"jd_customerid": 3919,
"jd_contactid": 4091,
"jd_additionalcontacts": "4091",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5551,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5536",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LAVE0001",
"jd_invoiceno": "",
"jd_listprice": "18.37",
"jd_netprice": "88.37",
"jd_vat": "19.44",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "107.81",
"jd_grossprofit": "70.00",
"jd_costprice": "18.37",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "107.81",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5536\",\"35\":\"LAVE0001\",\"36\":1,\"37\":5,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Laveis\",\"46\":\"\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":3,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5527",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747124212,
"jd_updatedat": 1747127929
},
{
"jd_id": 5528,
"jd_customerid": 3920,
"jd_contactid": 4092,
"jd_additionalcontacts": "4092",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5552,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5537",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "KKAV0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "0.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "0.00",
"jd_grossprofit": "0.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "0.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5537\",\"35\":\"KKAV0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Kavi \",\"46\":\"K\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"569008\",\"54\":4,\"285\":1,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "0.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5528",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747128167,
"jd_updatedat": 1747128204
},
{
"jd_id": 5529,
"jd_customerid": 3921,
"jd_contactid": 4093,
"jd_additionalcontacts": "4093",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5553,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5538",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "LEON0001",
"jd_invoiceno": "",
"jd_listprice": "400.00",
"jd_netprice": "400.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "0.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "400.00",
"jd_grossprofit": "0.00",
"jd_costprice": "400.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "350.00",
"jd_totpaid": "50.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "0.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5538\",\"35\":\"LEON0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Caro\",\"46\":\"Leon\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"\",\"54\":4,\"285\":11,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "0.000",
"jd_commission": null,
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5529",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": 1747094400,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747131043,
"jd_updatedat": 1747131288
},
{
"jd_id": 5530,
"jd_customerid": 3922,
"jd_contactid": 4094,
"jd_additionalcontacts": "4094",
"jd_templateid": 1,
"jd_jobmultiquoteid": 5554,
"jd_deletedcustokeyvalue": "{}",
"jd_jobref": "AQ5539",
"jd_jobstatus": 1,
"jd_contactaddid": 0,
"jd_orderstatus": 13,
"jd_accref": "GGRA0001",
"jd_invoiceno": "",
"jd_listprice": "0.00",
"jd_netprice": "70.00",
"jd_vat": "0.00",
"jd_isvaton": 1,
"jd_deliverycost": "70.00",
"jd_deliverycosttypeid": 1,
"jd_overridetypeid": 1,
"jd_orderformprice": "0.00",
"jd_editpricebyid": null,
"jd_isroundon": 0,
"jd_grossprice": "70.00",
"jd_grossprofit": "70.00",
"jd_costprice": "0.00",
"jd_overrideprice": null,
"jd_overridenetprice": null,
"jd_overridevatprice": null,
"jd_overridegrossprice": null,
"jd_amountoutstanding": "70.00",
"jd_totpaid": "0.00",
"jd_creditlimit": "0.00",
"jd_creditbalance": "0.00",
"jd_overdue": "0.00",
"jd_userdefinedarray": null,
"jd_deliverycostid": 0,
"jd_iscostpriceon": 0,
"jd_isonlineorder": 1,
"jd_isonlineordersubmitted": 0,
"jd_endcustomervatprice": null,
"jd_endcustomeroverridetype": 0,
"jd_endcustomeroverridevalue": null,
"jd_endcustomeroverridenetprice": "0.00",
"jd_endcustomeroverridevatprice": "0.00",
"jd_endcustomeroverridegrossprice": "0.00",
"jd_endcustomerdeliverycost": null,
"jd_endcustomerdeliverycostinclvat": 0,
"jd_endcustomerfittingcost": null,
"jd_endcustomerfittingcostinclvat": 0,
"jd_onlinedeliveryaddreddtype": 0,
"jd_onlinedeliveryaddreddid": 0,
"jd_seq": 0,
"jd_status": 0,
"jd_createdby": 1,
"jd_updatedby": 1,
"jd_deviceplatform": 0,
"jd_fromjobref": "",
"jd_importorder": 0,
"jd_quickquote": 0,
"jd_deliveryvatperc": "22.000",
"jd_fromdbname": null,
"jd_jobcustomoizedkeyvalue": "{\"32\":\"\",\"33\":25,\"34\":\"AQ5539\",\"35\":\"GGRA0001\",\"36\":1,\"37\":1,\"38\":\"\",\"39\":25,\"40\":13,\"41\":1,\"44\":\"\",\"45\":\"Granna\",\"46\":\"G\",\"47\":\"\",\"48\":\"\",\"49\":\"\",\"50\":\"\",\"51\":\"\",\"52\":\"\",\"53\":\"560099\",\"54\":4,\"285\":2,\"286\":\"\",\"287\":\"\",\"288\":\"\",\"289\":\"\",\"551\":1,\"558\":\"\",\"559\":1,\"610\":\"\",\"611\":\"\",\"612\":1,\"countryText\":\"Australia\",\"adminUser\":1}",
"jd_custompricefields": "",
"jd_cdeliveryvatperc": "22.000",
"jd_commission": "[]",
"jd_commissionprice": "0.00",
"jd_commissionsetting": 0,
"jd_commissionaddedvalue": "0.00",
"id": "5530",
"jd_createddate": 1747094400,
"jd_orderdate": null,
"jd_duedate": null,
"jd_sceduleddate": null,
"jd_invoicedate": null,
"jd_completeddate": null,
"jd_sageexportdate": null,
"jd_createdat": 1747131026,
"jd_updatedat": 1747131563
}
],
"deleted": []
},
"bm_orderitem": {
"created": [
{
"oi_id": 31040,
"oi_jobid": 5522,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 5546,
"oi_productid": 9,
"oi_recipeid": 9,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 19,
"oi_customseq": 1,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":6887,\"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\":6887,\"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\":319,\"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\":319,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":320,\"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\":320,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1\",\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":322,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":322,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":323,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"500\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":324,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":\"474\",\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":\"1\",\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"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\":321,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"474\",\"optionsvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":\"1\",\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Vision Panel Size\",\"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\":\"Vision Panel Size\",\"fieldid\":325,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":326,\"labelname\":\"Measure To\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Measure To\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Measure To\",\"fieldid\":326,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Controls\",\"fieldid\":327,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Brackets\",\"fieldid\":328,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":329,\"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\":329,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roll\",\"fieldid\":330,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"System Type\",\"fieldid\":331,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Tube Size\",\"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\":\"Tube Size\",\"fieldid\":332,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":335,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorisation\",\"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\":\"Motorisation\",\"fieldid\":333,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing\",\"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\",\"fieldid\":336,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":337,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product TypeDual\",\"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\":7270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "Supplier: Markilux, Width: 500, Drop: 500, Product Type: band z",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 500 mm##,##Product Type: band z##",
"oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"oi_scanstatus": "",
"oi_operationworkroom_data": "[{\"link_id\":2,\"process_id\":2,\"product_id\":9,\"phc_id\":2,\"pd_id\":2,\"name\":\"Stock Pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":3,\"process_id\":3,\"product_id\":9,\"phc_id\":3,\"pd_id\":3,\"name\":\"Fabric cut\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":4,\"process_id\":4,\"product_id\":9,\"phc_id\":4,\"pd_id\":4,\"name\":\"Tube cut\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":1,\"process_id\":1,\"product_id\":9,\"phc_id\":1,\"pd_id\":1,\"name\":\"Office Check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":5,\"process_id\":5,\"product_id\":9,\"phc_id\":5,\"pd_id\":5,\"name\":\"Assemble\",\"phc_linkstations\":5,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"}]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"55.00\",\"cost_with_discount\":\"55.00\",\"cost_with_markup\":\"55.00\",\"gross_price\":\"67.10\",\"vat_price\":\"12.10\"}",
"oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "55.000",
"oi_netprice": "55.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "12.100",
"oi_vatvalue": "22.000",
"oi_vatselected": 2,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "67.100",
"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": "55.000",
"oi_endcustomeroverridevatprice": "12.100",
"oi_endcustomeroverridegrossprice": "67.100",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "31040",
"oi_productiondate": 1747130422,
"oi_createdat": 1747130422,
"oi_updatedat": 1747126886,
"oi_createdby": 1,
"oi_updatedby": 1
},
{
"oi_id": 31041,
"oi_jobid": 5526,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 5550,
"oi_productid": 4,
"oi_recipeid": 4,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":6884,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":152,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":153,\"labelname\":\"Supplier\",\"value\":3,\"valueid\":\"\",\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":200,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":201,\"labelname\":\"Blind or Recess\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":202,\"labelname\":\"Width\",\"value\":\"610\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":203,\"labelname\":\"Drop\",\"value\":\"610\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":154,\"labelname\":\"Product Type\",\"value\":45,\"valueid\":\"45\",\"type\":13,\"optionid\":\"45\",\"optionvalue\":[{\"id\":45,\"fieldid\":154,\"fieldoptionlinkid\":45,\"optionid\":45,\"mainsupplier\":3,\"blindtypecode\":\"\",\"optionname\":\"Range AA\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":155,\"labelname\":\"Fabric\",\"value\":\"Scope\",\"valueid\":\"79\",\"type\":5,\"optionid\":\"79\",\"optionvalue\":[{\"optionid\":79,\"optionname\":\"Scope\",\"optioncode\":\"1\",\"optionquantity\":1,\"fieldoptionlinkid\":79,\"forchildfieldoptionlinkid\":\"5_2_79_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Range AA\",\"pricegroupid\":45}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":156,\"labelname\":\"Color\",\"value\":\"Bare\",\"valueid\":\"567\",\"type\":5,\"optionid\":\"567\",\"optionvalue\":[{\"optionid\":567,\"optionname\":\"Bare\",\"optioncode\":\"LP5460\",\"optionquantity\":1,\"fieldoptionlinkid\":567,\"forchildfieldoptionlinkid\":\"5_3_567_1\",\"minimumdiscount\":null,\"maximumdiscount\":null,\"optionimage\":\"\",\"subdatacount\":0}],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":204,\"labelname\":\"Bunch\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":205,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":206,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":466,\"labelname\":\"Bracket\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":467,\"labelname\":\"Blind Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":207,\"labelname\":\"Headrail System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":208,\"labelname\":\"Headrail Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":468,\"labelname\":\"Motorization\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":209,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":210,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Supplier: Decora, Width: 610, Drop: 610, Product Type: Range AA, Fabric: Scope, Color: Bare",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 610 mm##,##Drop: 610 mm##,##Product Type: Range AA##,##Fabric: Scope##,##Color: Bare##",
"oi_reporttitles": "##Quantity:
##Supplier:
##Width:
##Drop:
##Product Type:
##Fabric:
##Color:",
"oi_productionformulajsondata": "[]",
"oi_operationstatus": null,
"oi_scanstatus": "",
"oi_operationworkroom_data": "[]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "[]",
"oi_pricecomesfrom_calculations": "{}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "18.370",
"oi_netprice": "19.100",
"oi_pricesfromoperations": null,
"oi_vatprice": "4.200",
"oi_vatvalue": "22.000",
"oi_vatselected": 2,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "23.300",
"oi_overrideprice": "0.000",
"oi_overridetype": 1,
"oi_overridevalue": null,
"oi_overridenetprice": "0.000",
"oi_overridevatprice": "0.000",
"oi_overridegrossprice": "0.000",
"oi_ready": 0,
"oi_onhold": 0,
"oi_platformcreatedfrom": "web",
"oi_copiedfrom": 0,
"oi_isonlineorder": 0,
"oi_endcustomervatprice": null,
"oi_endcustomeroverridetype": 1,
"oi_endcustomeroverridevalue": null,
"oi_endcustomeroverridenetprice": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[6884, 152, 153, 200, 201, 202, 203, 154, 155, 156, 204, 205, 206, 466, 467, 207, 208, 468, 209, 210]",
"oi_deviceplatform": 1,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "31041",
"oi_productiondate": 1747124151,
"oi_createdat": 1747124182,
"oi_updatedat": 1747127929,
"oi_createdby": 1,
"oi_updatedby": null
},
{
"oi_id": 31042,
"oi_jobid": 5527,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 5551,
"oi_productid": 4,
"oi_recipeid": 4,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":6884,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":152,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":153,\"labelname\":\"Supplier\",\"value\":3,\"valueid\":\"\",\"type\":17,\"optionid\":\"3\",\"optionvalue\":[{\"id\":3,\"optionid\":3,\"optionname\":\"Decora\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":200,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":201,\"labelname\":\"Blind or Recess\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":202,\"labelname\":\"Width\",\"value\":\"610\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":203,\"labelname\":\"Drop\",\"value\":\"610\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":154,\"labelname\":\"Product Type\",\"value\":45,\"valueid\":\"45\",\"type\":13,\"optionid\":\"45\",\"optionvalue\":[{\"id\":45,\"fieldid\":154,\"fieldoptionlinkid\":45,\"optionid\":45,\"mainsupplier\":3,\"blindtypecode\":\"\",\"optionname\":\"Range AA\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":155,\"labelname\":\"Fabric\",\"value\":\"Scope\",\"valueid\":\"79\",\"type\":5,\"optionid\":\"79\",\"optionvalue\":[{\"optionid\":79,\"optionname\":\"Scope\",\"optioncode\":\"1\",\"optionquantity\":1,\"fieldoptionlinkid\":79,\"forchildfieldoptionlinkid\":\"5_2_79_1\",\"optionimage\":\"\",\"subdatacount\":1,\"pricegroup\":\"Range AA\",\"pricegroupid\":45}],\"fabricorcolor\":1,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":156,\"labelname\":\"Color\",\"value\":\"\",\"valueid\":\"\",\"type\":5,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":2,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":204,\"labelname\":\"Bunch\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":205,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":206,\"labelname\":\"Control Side\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":466,\"labelname\":\"Bracket\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":467,\"labelname\":\"Blind Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":207,\"labelname\":\"Headrail System\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":208,\"labelname\":\"Headrail Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":468,\"labelname\":\"Motorization\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":209,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":210,\"labelname\":\"Special Instructions\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0}]",
"oi_description": "Unit Type: mm, Quantity: 1, Supplier: Decora, Width: 610, Drop: 610, Product Type: Range AA, Fabric: Scope",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Decora##,##Width: 610 mm##,##Drop: 610 mm##,##Product Type: Range AA##,##Fabric: Scope##",
"oi_reporttitles": "##Quantity:
##Supplier:
##Width:
##Drop:
##Product Type:
##Fabric:",
"oi_productionformulajsondata": "[]",
"oi_operationstatus": null,
"oi_scanstatus": "",
"oi_operationworkroom_data": "[]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "[]",
"oi_pricecomesfrom_calculations": "{}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "18.370",
"oi_netprice": "18.370",
"oi_pricesfromoperations": null,
"oi_vatprice": "4.040",
"oi_vatvalue": "22.000",
"oi_vatselected": 2,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "22.410",
"oi_overrideprice": "0.000",
"oi_overridetype": 1,
"oi_overridevalue": null,
"oi_overridenetprice": "0.000",
"oi_overridevatprice": "0.000",
"oi_overridegrossprice": "0.000",
"oi_ready": 0,
"oi_onhold": 0,
"oi_platformcreatedfrom": "web",
"oi_copiedfrom": 0,
"oi_isonlineorder": 0,
"oi_endcustomervatprice": null,
"oi_endcustomeroverridetype": 1,
"oi_endcustomeroverridevalue": null,
"oi_endcustomeroverridenetprice": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[6884, 152, 153, 200, 201, 202, 203, 154, 155, 156, 204, 205, 206, 466, 467, 207, 208, 468, 209, 210]",
"oi_deviceplatform": 1,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "31042",
"oi_productiondate": 1747124217,
"oi_createdat": 1747124332,
"oi_updatedat": 1747127929,
"oi_createdby": 1,
"oi_updatedby": null
},
{
"oi_id": 31043,
"oi_jobid": 5529,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 5553,
"oi_productid": 9,
"oi_recipeid": 9,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 0,
"oi_customseq": 0,
"oi_productcustomseq": 0,
"oi_jsondata": "[{\"id\":6887,\"labelname\":\"Unit Type\",\"value\":2,\"valueid\":\"2\",\"type\":34,\"optionid\":\"2\",\"optionvalue\":[{\"optionid\":2,\"optionname\":\"mm\",\"optioncode\":\"\",\"optionquantity\":1,\"unittype\":0,\"unitcost\":0,\"pricingtype\":0,\"fieldoptionlinkid\":2,\"forchildfieldoptionlinkid\":\"34_2\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":319,\"labelname\":\"Quantity\",\"value\":1,\"valueid\":\"\",\"type\":14,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":320,\"labelname\":\"Supplier\",\"value\":1,\"valueid\":\"\",\"type\":17,\"optionid\":\"1\",\"optionvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":322,\"labelname\":\"Room\",\"value\":\"\",\"valueid\":\"\",\"type\":18,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":\"\",\"type\":11,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"200\",\"valueid\":\"\",\"type\":12,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":\"125mm\",\"valueid\":\"1061\",\"type\":3,\"optionid\":\"775\",\"optionvalue\":[{\"optionid\":775,\"optionname\":\"125mm\",\"optioncode\":\"\",\"optionqty\":\"1\",\"unittype\":\"Each\",\"unitcost\":0,\"pricingtype\":\"\",\"fieldoptionlinkid\":1061,\"forchildfieldoptionlinkid\":\"3_1061\",\"hasstock\":0,\"hasprice\":0,\"subdatacount\":0,\"optionimage\":\"\"}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"1\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1},{\"id\":326,\"labelname\":\"Measure To\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":329,\"labelname\":\"Chain Colour\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":\"\",\"valueid\":\"\",\"type\":3,\"optionid\":\"\",\"optionvalue\":[],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":474,\"valueid\":\"622\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":622,\"fieldid\":7270,\"fieldoptionlinkid\":622,\"optionid\":474,\"mainsupplier\":1,\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"fabricorcolor\":0,\"widthfraction\":\"\",\"widthfractiontext\":\"\",\"dropfraction\":\"\",\"dropfractiontext\":\"\",\"optionquantity\":\"\",\"numberfraction\":\"\",\"numberfractiontext\":\"\",\"editruleoverride\":1}]",
"oi_description": "Unit Type: mm, Quantity: 1, Supplier: Markilux, Width: 500, Drop: 200, Product Type: band z, Vision Panel Size: 125mm, Product Type: band z",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 200 mm##,##Product Type: band z##,##Vision Panel Size: 125mm##,##Product Type: band z##",
"oi_reporttitles": "##Quantity:
##Supplier:
##Width:
##Drop:
##Product Type:
##Vision Panel Size:
##Product Type:",
"oi_productionformulajsondata": "[]",
"oi_operationstatus": null,
"oi_scanstatus": "",
"oi_operationworkroom_data": "[]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "[]",
"oi_pricecomesfrom_calculations": "{}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "400.000",
"oi_netprice": "400.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "0.000",
"oi_vatvalue": "0.000",
"oi_vatselected": 0,
"oi_vattype": 2,
"oi_vatonoff": 1,
"oi_grossprice": "400.000",
"oi_overrideprice": "0.000",
"oi_overridetype": 1,
"oi_overridevalue": null,
"oi_overridenetprice": "0.000",
"oi_overridevatprice": "0.000",
"oi_overridegrossprice": "0.000",
"oi_ready": 0,
"oi_onhold": 0,
"oi_platformcreatedfrom": "web",
"oi_copiedfrom": 0,
"oi_isonlineorder": 0,
"oi_endcustomervatprice": null,
"oi_endcustomeroverridetype": 1,
"oi_endcustomeroverridevalue": null,
"oi_endcustomeroverridenetprice": "0.000",
"oi_endcustomeroverridevatprice": "0.000",
"oi_endcustomeroverridegrossprice": "0.000",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]",
"oi_deviceplatform": 1,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "31043",
"oi_productiondate": 1747131049,
"oi_createdat": 1747131106,
"oi_updatedat": 1747131151,
"oi_createdby": 1,
"oi_updatedby": null
}
],
"updated": [
{
"oi_id": 31040,
"oi_jobid": 5522,
"oi_jobtempid": "0",
"oi_jobmultiquoteid": 5546,
"oi_productid": 9,
"oi_recipeid": 9,
"oi_ruleid": 0,
"oi_qty": 1,
"oi_seq": 19,
"oi_customseq": 1,
"oi_productcustomseq": 1,
"oi_jsondata": "[{\"id\":6887,\"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\":6887,\"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\":319,\"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\":319,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":320,\"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\":320,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"1\",\"optionsvalue\":[{\"id\":1,\"optionid\":1,\"optionname\":\"Markilux\",\"deleted\":0,\"optionquantity\":1}],\"editruleoverride\":0},{\"id\":322,\"labelname\":\"Room\",\"value\":null,\"valueid\":null,\"type\":18,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Room\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":18,\"mandatory\":0,\"fieldname\":\"Room\",\"fieldid\":322,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":323,\"labelname\":\"Width\",\"value\":\"500\",\"valueid\":null,\"type\":11,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Width\",\"fabricorcolor\":0,\"widthfraction\":\"0_mm_3_0\",\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":11,\"mandatory\":0,\"fieldname\":\"Width\",\"fieldid\":323,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":324,\"labelname\":\"Drop\",\"value\":\"500\",\"valueid\":null,\"type\":12,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Drop\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":\"0_mm_3_0\",\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":12,\"mandatory\":0,\"fieldname\":\"Drop\",\"fieldid\":324,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":1},{\"id\":321,\"labelname\":\"Product Type\",\"value\":\"474\",\"valueid\":\"621\",\"type\":13,\"optionid\":\"474\",\"optionvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":\"1\",\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"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\":321,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":\"474\",\"optionsvalue\":[{\"id\":621,\"fieldid\":321,\"fieldoptionlinkid\":621,\"optionid\":474,\"mainsupplier\":\"1\",\"blindtypecode\":\"101\",\"optionname\":\"band z\",\"optionquantity\":1,\"subcount\":0,\"status\":0,\"subdatacount\":0}],\"editruleoverride\":1},{\"id\":325,\"labelname\":\"Vision Panel Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Vision Panel Size\",\"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\":\"Vision Panel Size\",\"fieldid\":325,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":326,\"labelname\":\"Measure To\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Measure To\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Measure To\",\"fieldid\":326,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":327,\"labelname\":\"Controls\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Controls\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Controls\",\"fieldid\":327,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":328,\"labelname\":\"Brackets\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Brackets\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Brackets\",\"fieldid\":328,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":329,\"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\":329,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":330,\"labelname\":\"Roll\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Roll\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Roll\",\"fieldid\":330,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":331,\"labelname\":\"System Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"System Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"System Type\",\"fieldid\":331,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":332,\"labelname\":\"Tube Size\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Tube Size\",\"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\":\"Tube Size\",\"fieldid\":332,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":335,\"labelname\":\"Control Type\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Control Type\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Control Type\",\"fieldid\":335,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":333,\"labelname\":\"Motorisation\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Motorisation\",\"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\":\"Motorisation\",\"fieldid\":333,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":336,\"labelname\":\"Fixing\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Fixing\",\"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\",\"fieldid\":336,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":337,\"labelname\":\"Extras\",\"value\":null,\"valueid\":null,\"type\":3,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Extras\",\"fabricorcolor\":0,\"widthfraction\":null,\"widthfractiontext\":null,\"dropfractiontext\":null,\"dropfraction\":null,\"showfieldonjob\":1,\"showFieldOnCustomerPortal\":1,\"optionquantity\":null,\"globaledit\":false,\"numberfraction\":null,\"numberfractiontext\":null,\"fieldlevel\":1,\"fieldtypeid\":3,\"mandatory\":0,\"fieldname\":\"Extras\",\"fieldid\":337,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0},{\"id\":7270,\"labelname\":\"Product Type\",\"value\":null,\"valueid\":null,\"type\":13,\"optionid\":null,\"optionvalue\":[],\"issubfabric\":0,\"labelnamecode\":\"Product TypeDual\",\"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\":7270,\"subchild\":[],\"fieldInformation\":null,\"optiondefault\":null,\"optionsvalue\":[],\"editruleoverride\":0}]",
"oi_description": "Supplier: Markilux, Width: 500, Drop: 500, Product Type: band z",
"oi_reportdescription": "##Quantity: 1##,##Supplier: Markilux##,##Width: 500 mm##,##Drop: 500 mm##,##Product Type: band z##",
"oi_reporttitles": "##Quantity:<\/br>##Supplier:<\/br>##Width:<\/br>##Drop:<\/br>##Product Type:",
"oi_productionformulajsondata": "[{\"productionoveride\":0,\"id\":null,\"value\":\"-\",\"formula\":null,\"price\":null,\"recipeid\":null,\"stockupdate\":0,\"fieldid\":null,\"isdelete\":0,\"defaultstock\":null,\"fieldtype_id\":0,\"fractionvalue\":null}]",
"oi_operationstatus": "0",
"oi_scanstatus": "",
"oi_operationworkroom_data": "[{\"link_id\":2,\"process_id\":2,\"product_id\":9,\"phc_id\":2,\"pd_id\":2,\"name\":\"Stock Pick\",\"phc_linkstations\":2,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"10 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":3,\"process_id\":3,\"product_id\":9,\"phc_id\":3,\"pd_id\":3,\"name\":\"Fabric cut\",\"phc_linkstations\":3,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":4,\"process_id\":4,\"product_id\":9,\"phc_id\":4,\"pd_id\":4,\"name\":\"Tube cut\",\"phc_linkstations\":4,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":1,\"process_id\":1,\"product_id\":9,\"phc_id\":1,\"pd_id\":1,\"name\":\"Office Check\",\"phc_linkstations\":1,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"10.00\",\"phc_contractsellingprice\":\"10.00\",\"phc_tradesellingprice\":\"10.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"10.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"10.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"10.00\",\"price\":\"0.00\"},{\"link_id\":5,\"process_id\":5,\"product_id\":9,\"phc_id\":5,\"pd_id\":5,\"name\":\"Assemble\",\"phc_linkstations\":5,\"quantity\":1,\"link_to\":\"WORKROOM\",\"phc_processhascost\":0,\"phc_processhastime\":1,\"phc_costtype\":2,\"phc_domesticsellingprice\":\"15.00\",\"phc_contractsellingprice\":\"15.00\",\"phc_tradesellingprice\":\"15.00\",\"phc_dynamiccontact5_sellingprice\":\"0.00\",\"phc_dynamiccontact6_sellingprice\":\"0.00\",\"phc_dynamiccontact7_sellingprice\":\"0.00\",\"phc_dynamiccontact8_sellingprice\":\"0.00\",\"phc_ecommercesellingprice\":\"15.00\",\"phc_customers\":0,\"phc_contacttype\":0,\"phc_hascontacttypeall\":1,\"phc_hascustomerstypeall\":1,\"cost_price\":\"15.00\",\"Hour\\\/mins\":\"5 mins\",\"phc_processcostid\":1,\"markupprice\":\"15.00\",\"price\":\"0.00\"}]",
"oi_operationcalender_data": "[]",
"oi_operation_calculations": "{\"calendar\":\"0.00\",\"workroom\":\"55.00\",\"cost_with_discount\":\"55.00\",\"cost_with_markup\":\"55.00\",\"gross_price\":\"67.10\",\"vat_price\":\"12.10\"}",
"oi_pricecomesfrom_calculations": "{\"label\":\"Price table cost\",\"unit_type\":\"-\",\"cost_price\":\"0.00\",\"show_hide\":true,\"category\":3}",
"oi_productionstatus": null,
"oi_costoverride": 0,
"oi_costprice": "55.000",
"oi_netprice": "55.000",
"oi_pricesfromoperations": null,
"oi_vatprice": "12.100",
"oi_vatvalue": "22.000",
"oi_vatselected": 2,
"oi_vattype": 1,
"oi_vatonoff": 1,
"oi_grossprice": "67.100",
"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": "55.000",
"oi_endcustomeroverridevatprice": "12.100",
"oi_endcustomeroverridegrossprice": "67.100",
"oi_sage_flag": 0,
"oi_status": 0,
"oi_jsondataid": "[6887, 319, 320, 322, 323, 324, 321, 325, 326, 327, 328, 329, 330, 331, 332, 335, 333, 336, 337, 7270]",
"oi_deviceplatform": 0,
"oi_custompricefields": "",
"oi_editransfer": 0,
"oi_apisup_orderid": 0,
"oi_commissionprice": "0.000",
"oi_commissionvatprice": "0.000",
"id": "31040",
"oi_productiondate": 1747130422,
"oi_createdat": 1747130422,
"oi_updatedat": 1747126886,
"oi_createdby": 1,
"oi_updatedby": 1
}
],
"deleted": []
},
"bm_paymentlist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_notelist": {
"created": [
{
"nl_id": 105015,
"nl_ordertempid": 0,
"nl_orderid": 5520,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 1,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105015",
"nl_endddate": 1747094400,
"nl_starttime": 1747123211,
"created_at": 1747123211,
"updated_at": 1747123869,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105016,
"nl_ordertempid": 0,
"nl_orderid": 5526,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 1,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105016",
"nl_endddate": 1747094400,
"nl_starttime": 1747124143,
"created_at": 1747124143,
"updated_at": 1747127929,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105017,
"nl_ordertempid": 0,
"nl_orderid": 5527,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 1,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105017",
"nl_endddate": 1747094400,
"nl_starttime": 1747124212,
"created_at": 1747124212,
"updated_at": 1747127929,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105018,
"nl_ordertempid": 0,
"nl_orderid": 5528,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 1,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105018",
"nl_endddate": 1747094400,
"nl_starttime": 1747128167,
"created_at": 1747128167,
"updated_at": 1747128204,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105019,
"nl_ordertempid": null,
"nl_orderid": 5517,
"nl_notescategory": 1,
"nl_type": 26,
"nl_platform": 3,
"nl_desc": "Invoice Created (Invoice9607)",
"nl_manualNotes": "",
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 1,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105019",
"nl_endddate": 1747094400,
"nl_starttime": 1747148172,
"created_at": 1747128372,
"updated_at": 1747128372,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105020,
"nl_ordertempid": 0,
"nl_orderid": 5529,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 1,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105020",
"nl_endddate": 1747094400,
"nl_starttime": 1747131043,
"created_at": 1747131043,
"updated_at": 1747131150,
"created_by": 1,
"updated_by": null
},
{
"nl_id": 105021,
"nl_ordertempid": 0,
"nl_orderid": 5530,
"nl_notescategory": 1,
"nl_type": 17,
"nl_platform": 2,
"nl_desc": "New job has been created in job",
"nl_manualNotes": null,
"nl_createdby": "1",
"nl_attachmnettext": null,
"nl_attachmnetURL": null,
"nl_isonlinenote": 0,
"nl_seq": 0,
"nl_status": 0,
"nl_barcodeprocessid": null,
"id": "105021",
"nl_endddate": 1747094400,
"nl_starttime": 1747131026,
"created_at": 1747131026,
"updated_at": 1747131563,
"created_by": 1,
"updated_by": null
}
],
"updated": [],
"deleted": []
},
"bm_deliveryaddresssetting": {
"created": [
{
"das_id": 5403,
"das_jobid": 5521,
"das_appointmentaddress": 4086,
"das_invoiceaddress": 4086,
"das_invoicedeliveryaddress": 0,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5403",
"das_createdat": 1747125072,
"das_updatedat": 1747125072,
"das_createdby": 1,
"das_updatedby": null
},
{
"das_id": 5404,
"das_jobid": 5522,
"das_appointmentaddress": 3985,
"das_invoiceaddress": 3985,
"das_invoicedeliveryaddress": 0,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5404",
"das_createdat": 1747126886,
"das_updatedat": 1747126886,
"das_createdby": 1,
"das_updatedby": null
},
{
"das_id": 5405,
"das_jobid": 5523,
"das_appointmentaddress": 4087,
"das_invoiceaddress": 4087,
"das_invoicedeliveryaddress": 0,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5405",
"das_createdat": 1747126903,
"das_updatedat": 1747126903,
"das_createdby": 1,
"das_updatedby": null
},
{
"das_id": 5406,
"das_jobid": 5524,
"das_appointmentaddress": 4088,
"das_invoiceaddress": 4088,
"das_invoicedeliveryaddress": 0,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5406",
"das_createdat": 1747127582,
"das_updatedat": 1747127582,
"das_createdby": 1,
"das_updatedby": null
},
{
"das_id": 5407,
"das_jobid": 5525,
"das_appointmentaddress": 4089,
"das_invoiceaddress": 4089,
"das_invoicedeliveryaddress": 0,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5407",
"das_createdat": 1747127855,
"das_updatedat": 1747127855,
"das_createdby": 1,
"das_updatedby": null
},
{
"das_id": 5408,
"das_jobid": 5529,
"das_appointmentaddress": 4093,
"das_invoiceaddress": 4093,
"das_invoicedeliveryaddress": 4093,
"das_purchaseaddress": 0,
"das_worksheetaddress": 0,
"id": "5408",
"das_createdat": 1747131151,
"das_updatedat": 1747131151,
"das_createdby": 1,
"das_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_jobchecklist": {
"created": [],
"updated": [],
"deleted": []
},
"bm_Invoice": {
"created": [
{
"invoice_id": 2557,
"job_id": 5517,
"customer_id": 22,
"ref_no": "Invoice9607",
"invoice_type": 1,
"invoice_split_type": 0,
"invoice_split_cal": 0,
"invoice_split_cal_value": "0.000",
"net_amount": "70.000",
"vat_amount": "15.400",
"gross_amount": "85.400",
"delivery_amount": "70.000",
"delivery": 0,
"commission_amount": "0.000",
"commission": 0,
"total_amount": "85.400",
"split_net_amount": "0.000",
"split_vat_amount": "0.000",
"outstanding_amount": "85.400",
"paid_amount": "0.000",
"paid_status": 1,
"status": 0,
"transfer": 0,
"transfer_id": null,
"id": "2557",
"paymentDueDate": 1747094400,
"invoiceDate": 1747094400,
"transferDate": null,
"createdat": 1747128372,
"updatedat": 1747128372,
"createdby": 1,
"updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_InvoiceDetails": {
"created": [
{
"ind_id": 15075,
"ind_invoice_id": 2557,
"ind_order_id": 31038,
"ind_qty": 1,
"ind_net_amount": "0.000",
"ind_vat_amount": "0.000",
"ind_gross_amount": "0.000",
"ind_status": 0,
"id": "15075",
"ind_createdat": 1747128372,
"ind_updatedat": 1747128372,
"ind_createdby": 1,
"ind_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_invoice_credit_note": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNote": {
"created": [],
"updated": [],
"deleted": []
},
"bm_CreditNoteDetails": {
"created": [],
"updated": [],
"deleted": []
},
"bm_job_paymentlist": {
"created": [
{
"jp_id": 357,
"jp_job_id": 5529,
"jp_amount": "50.000",
"jp_amountoutstanding": "50.000",
"jp_paymentmethod": 14,
"jp_paymentcategory": 1,
"jp_paymenttype": 8,
"jp_surchargetype": 2,
"jp_surchargemethod": 2,
"jp_surchargeamount": "1.500",
"jp_surchargevalue": "3.000",
"jp_surchargetotal": "51.500",
"jp_userid": 0,
"jp_decription": "",
"jp_deviceplatform": 0,
"jp_status": 0,
"jp_transfer": 0,
"jp_transfer_id": null,
"id": "357",
"jp_paiddate": 1747094400,
"jp_createdat": 1747131288,
"jp_updatedat": 1747131288,
"jp_createdby": 0,
"jp_updatedby": null
}
],
"updated": [],
"deleted": []
},
"bm_OverPayment": {
"created": [],
"updated": [],
"deleted": []
},
"bm_terms": {
"created": [
{
"termsid": 15946,
"orderid": 5521,
"jobmultiquoteid": 5545,
"isresportshow": 1,
"termsCategory": 2,
"termsName": "Standard",
"termsDescription": "