{ "REPORT_COMMON": { "CLIENT": { "FC_ID": 21, "FC_COMPANY": "ANALYSTIC TEST ACCOUNT (GREEN)", "FC_DATEFORMAT": "DD/MM/YYYY", "FC_WEIGHTDISPLAYSETTING": "KG", "FC_RAWMATERIALSDECIMALPLACES": 4, "FC_TERMSPDF_SO": null, "FC_TERMSPDF_PDO": null, "FC_TERMSPDF_PO": "TC_PO_LINESHEET_(55).PDF", "FC_SIGNATUREFILE": "SIG_SIGNATURE_DEMO.JPG", "VAT_TEXT": "VAT", "ISUMBRELLA": 0 }, "BARCODE": { "FC_BARCODE_LABELS_STYLE": 19, "FC_BARCODE_LABELS_ID": 1, "FC_BARCODE_RETAIL_TEXT": "" }, "LABEL": { "FC_LABEL_LBID": 1, "FC_LABEL_STYLE": 3 }, "USER": { "US_ID": 2407, "US_USERNAME": "PETE", "FULLNAME": "PETER HOARE" }, "SEASON": { "PP_ID": 2, "PP_SEASON": "A/W 2006" }, "CURRENCY": { "CR_ID": 1, "CR_CURRENCY": "GBP", "CR_SYMBOL": "£", "CR_ISO4217": "GBP" }, "PERMISSIONS": [ { "KEY": "Barcode" }, { "KEY": "Barcodes" }, { "KEY": "ChangeSeasonOrders" }, { "KEY": "Client Inventory" }, { "KEY": "Company details Edit" }, { "KEY": "Connectors" }, { "KEY": "CONNECTORS BESPOKE" }, { "KEY": "CONNECTORS IPAD" }, { "KEY": "CONNECTORS SHOPIFY" }, { "KEY": "CONNECTORS WOOCOMMERCE" }, { "KEY": "ConsolidateOrders" }, { "KEY": "Currencies" }, { "KEY": "Customer Categories" }, { "KEY": "Customer On Hold Status" }, { "KEY": "Customer Priorities" }, { "KEY": "Customer Territories" }, { "KEY": "Customers" }, { "KEY": "Customers Set On Hold Status" }, { "KEY": "CustomersImport" }, { "KEY": "CustomReportEditor" }, { "KEY": "CustomReports" }, { "KEY": "CustomReportViewer" }, { "KEY": "Data Purge" }, { "KEY": "EDI" }, { "KEY": "Fabrics" }, { "KEY": "Factoring" }, { "KEY": "Gross profit" }, { "KEY": "InventoryRAvailable" }, { "KEY": "InventoryRBasic" }, { "KEY": "InventoryReports" }, { "KEY": "IPAD" }, { "KEY": "IPAD_ATS" }, { "KEY": "Line Sheet" }, { "KEY": "Make Costs" }, { "KEY": "Manufacturer cats" }, { "KEY": "Manufacturers" }, { "KEY": "Order Tags" }, { "KEY": "Order Tracker" }, { "KEY": "Orders" }, { "KEY": "OrdersChangeSeason" }, { "KEY": "OrdersConfirmationImport" }, { "KEY": "OrdersConfirmationLockUnlock" }, { "KEY": "OrdersConfirmationPrintUnlocked" }, { "KEY": "OrdersCreditNoteLockUnlock" }, { "KEY": "OrdersCreditNotePrintUnlocked" }, { "KEY": "OrdersDeliveryNoteLockUnlock" }, { "KEY": "OrdersDeliveryNotePrintUnlocked" }, { "KEY": "OrdersEditAll" }, { "KEY": "OrdersInvoiceLockUnlock" }, { "KEY": "OrdersInvoicePrintUnlocked" }, { "KEY": "OrdersManageSubDocs" }, { "KEY": "OrdersProformaLockUnlock" }, { "KEY": "OrdersProformaPrintUnlocked" }, { "KEY": "OrdersReturnAuthorisationLockUnlock" }, { "KEY": "OrdersReturnAuthorisationPrintUnlocked" }, { "KEY": "OrdersScanning" }, { "KEY": "OrdersSelfApprove" }, { "KEY": "OrdersViewAll" }, { "KEY": "P Stock Inventory" }, { "KEY": "PCWithdraw" }, { "KEY": "Pick Allocation" }, { "KEY": "PickAllocation" }, { "KEY": "Price List" }, { "KEY": "ProdBookIn" }, { "KEY": "ProdBookOut" }, { "KEY": "ProdBookOutAdd" }, { "KEY": "ProdBookOutLockUnlock" }, { "KEY": "ProdBookOutPrintWhenUnlocked" }, { "KEY": "Product Analysis" }, { "KEY": "Product Categories" }, { "KEY": "Product Categorisation" }, { "KEY": "Product Costings" }, { "KEY": "ProductCostingsImport" }, { "KEY": "Production Order" }, { "KEY": "Production phase" }, { "KEY": "ProductionScanning" }, { "KEY": "PStockInventoryAdjustments" }, { "KEY": "PStockInventoryImport" }, { "KEY": "PStockInventoryMoveStock" }, { "KEY": "PStockInventorySetOpeningStock" }, { "KEY": "Purchase Orders" }, { "KEY": "PurchaseOrderLockUnlock" }, { "KEY": "PurchaseOrderPrintWhenUnlocked" }, { "KEY": "QuickBooks" }, { "KEY": "Raw Materials" }, { "KEY": "RawMaterialsImport" }, { "KEY": "Reports" }, { "KEY": "ReportsBarcodes" }, { "KEY": "ReportsCostProfit" }, { "KEY": "ReportsCustomer" }, { "KEY": "ReportsManufacturer" }, { "KEY": "ReportsMaterials" }, { "KEY": "ReportsOrders" }, { "KEY": "ReportsProduction" }, { "KEY": "ReportsProducts" }, { "KEY": "ReportsPurchase" }, { "KEY": "ReportsQuantities" }, { "KEY": "ReportsSupplier" }, { "KEY": "ReportsUser" }, { "KEY": "Reviso" }, { "KEY": "RM Stock Inventory" }, { "KEY": "RMStockInventoryAdjustments" }, { "KEY": "RMStockInventoryImport" }, { "KEY": "RMStockInventoryMoveStock" }, { "KEY": "RMStockInventorySetOpeningStock" }, { "KEY": "Scanning" }, { "KEY": "ScheduledReportEditor" }, { "KEY": "ScheduledReports" }, { "KEY": "Settings" }, { "KEY": "Settings Bank Details" }, { "KEY": "Settings BOM Material Types" }, { "KEY": "Settings Customer Account Manager" }, { "KEY": "Settings Customer Note Tags" }, { "KEY": "Settings Customer Payment Terms" }, { "KEY": "Settings Customer Shipping Terms" }, { "KEY": "Settings Default Manufacturing Type" }, { "KEY": "Settings Documents" }, { "KEY": "Settings Email Templates" }, { "KEY": "Settings Material Categories" }, { "KEY": "Settings Material Note Tags" }, { "KEY": "Settings Material Units Of Measurement" }, { "KEY": "Settings Order Note Tags" }, { "KEY": "Settings Order RA and CN Tags" }, { "KEY": "Settings Product Customs Types" }, { "KEY": "Settings Product Note Tags" }, { "KEY": "Settings Purchase Order Note Tags" }, { "KEY": "Settings Size Block" }, { "KEY": "Settings System" }, { "KEY": "Settings_Customers" }, { "KEY": "Settings_General" }, { "KEY": "Settings_Materials" }, { "KEY": "Settings_Products" }, { "KEY": "Settings_SalesOrders" }, { "KEY": "Size categories" }, { "KEY": "SOFromProdOrder" }, { "KEY": "SuperAdmin" }, { "KEY": "Supplier categories" }, { "KEY": "Suppliers" }, { "KEY": "SYNC CENTRE QUICKBOOKS" }, { "KEY": "SYNC CENTRE RESEND DATA" }, { "KEY": "SYNC CENTRE REVISO" }, { "KEY": "SYNC CENTRE SAGE" }, { "KEY": "SYNC CENTRE XERO API" }, { "KEY": "SYNC CENTRE XERO CSV" }, { "KEY": "User details Edit" }, { "KEY": "User Management" }, { "KEY": "Xero" } ] }, "REPORT_DEFINITION": { "TITLE": "This Is The Report Title" }, "ORDER": { "ID": 2615416, "OR_F2ITCLIENTID": 21, "OR_NUMBER": "SO-00141", "OR_SONUMBER": null, "OR_SEASON": 2, "OR_ORDERTYPEID": 1, "OR_CONFIRMATIONID": null, "OR_DELNOTEID": null, "OR_INVOICEID": null, "OR_STATUSID": null, "OR_CUSTOMERID": 53, "OR_CONFDATE": "2020-07-20T17:05:34", "OR_ORDERID": "", "OR_ORDERREF": "My Order Ref", "OR_CONTACTINFO": "SDFS D\r\n dgdg f\r\n dgf dgf\r\ndfgd fg", "OR_INCLUDEVAT": true, "OR_CUSTOMERREF": "Their Customer Ref", "OR_SHIPPER": "DGF", "OR_SHIPPINGTERMS": "DFG", "OR_DELIVERYPERIOD": "Our Delivery Period", "OR_PAYMENTTERMS": "These are our payment terms.\nEnd of payment terms", "OR_DISCOUNT": 1645.7, "OR_TRANSPORTCHARGE": 0, "OR_NUMCARTONS": "", "OR_WEIGHT": "", "OR_DIMENSIONS": "", "OR_CURRENCYID": 1, "OR_EXCHANGERATE": 0, "OR_PROFORMADEPOSIT": 0, "OR_PROFORMABALANCE": 0, "OR_ACTIVE": true, "OR_BANKDETAILSSRC": -1, "OR_CREATEDUSID": 2407, "OR_CREATEDDATE": "2020-07-20T17:05:34", "OR_MODIFIEDUSID": 2407, "OR_MODIFIEDDATE": "2020-07-29T12:18:03", "OR_COMMENTS": "These are our comments about the order.\n\nEnd of comments!", "OR_LOCKED": false, "OR_COMPLETE": false, "OR_OWNEDUSID": 2407, "OR_APPROVED": true, "OR_APPROVEDUSID": 2407, "OR_APPROVEDDATE": "2020-07-20T17:05:33.403", "OR_LOCKEDUSID": null, "OR_LOCKEDDATE": null, "OR_COMPLETEUSID": null, "OR_COMPLETEDATE": null, "OR_DISCOUNT_PERCENTAGE": 5, "OR_PAYMENT_DUE_DAYS": 30, "OR_PAID": false, "OR_DISCOUNT_METHOD": "P", "OR_WAREHOUSEID": 4, "OR_EXTERNALREF": "D3033257-FFF3-43E0-9B29-F68E4E33C0A3", "OR_IPAD_ORDER_CODE": null, "OR_SHIPPED_MOD_DATE": null, "OR_DTSQID": null, "OR_OGID": 1739, "OR_SETTLEMENTDISCOUNT": 0, "OR_SETTLEMENTDISCOUNT_PERCENTAGE": 0, "OR_DELIVERYDATESTART": "2020-08-01T00:00:00", "OR_DELIVERYDATECANCEL": "2020-08-31T00:00:00", "OR_VATAPPLICABLE": true, "OR_RETURNTOSTOCK": false, "OR_SOFPO_DO_ID": 0, "OR_AUTOMATEDBATCHREF": null, "OR_CUSTOMERPRIORITY_LDID": 9803, "OR_AIRWAYBILL": "", "OR_CREDITNOTETAG_LDID": 0, "OR_PAIDDATE": null, "OR_PAIDUSID": null, "OR_PAYMENTRECEIVED": 0, "OR_DEPOSITDEDUCTION": 0, "OR_ISDEPOSITDOC": false, "OR_ISQTY": false, "OR_CREATEDFROM_ORID": null, "OR_FORCEDCLOSED": false, "OR_TOBEDELETED": false, "OR_STORE_OCTID": 8136016, "OR_CONTACT_OCTID": 8136017, "OR_DELIVERY_OCTID": 8136018, "OR_SHIPPER_OCTID": 8136020, "OR_ACCOUNT_OCTID": 8136019, "OR_FACTORINGTERMS": 0, "OR_FACTORINGSTATUS": null, "OR_FACTORINGAPPROVEDAMOUNT": null, "OR_FACTORINGRESPONSE": null, "DOCKET_DO_DOCKETID": null, "DOCKET_FC_COMPANY": null, "CALCS_HAS_ACTIVE_SUB_DOCS": true, "CALCS_HAS_INACTIVE_SUB_DOCS": false, "CALCS_HAS_PICK_TICKET_DOCS": false, "CALCS_HAS_DELIVERY_NOTE_DOCS": false, "CALCS_HAS_NOTE": false, "CALCS_ISUSED": true, "CONTACT_STORE": { "ID": 8136016, "OCT_ORID": 2615416, "OCT_TYPE": "P", "OCT_CTID": 71608, "OCT_ISHISTORIC": false, "OCT_ADDRESS": "CAMARGUE\r\n DF SDF S\r\nSDFS\r\nSDFSDF\r\nSD\r\nFSD FYGF\r\nUnited Kingdom", "OCT_BUILDINGNUMBERORNAME": null, "OCT_NAME": "", "OCT_ADDRESS1": "DF SDF S", "OCT_ADDRESS2": "SDFS", "OCT_ADDRESS3": "SDFSDF", "OCT_TOWN": "SD", "OCT_SRLID": null, "OCT_POSTCODE": "FSD FYGF", "OCT_COUNTRYID": 1, "OCT_DESCRIPTION": "", "OCT_LOCATION_REFERENCE": "", "OCT_CONTACT": "", "OCT_EMAIL": "", "OCT_TEL": "", "OCT_MOB": "", "OCT_FAX": "" }, "CONTACT_CONTACT": { "ID": 8136017, "OCT_ORID": 2615416, "OCT_TYPE": "C", "OCT_CTID": 142386, "OCT_ISHISTORIC": false, "OCT_ADDRESS": "SDFS D\r\n dgdg f\r\n dgf dgf\r\ndfgd fg", "OCT_BUILDINGNUMBERORNAME": null, "OCT_NAME": "", "OCT_ADDRESS1": "", "OCT_ADDRESS2": "", "OCT_ADDRESS3": "", "OCT_TOWN": "", "OCT_SRLID": null, "OCT_POSTCODE": "", "OCT_COUNTRYID": null, "OCT_DESCRIPTION": "", "OCT_LOCATION_REFERENCE": "", "OCT_CONTACT": "SDFS D", "OCT_EMAIL": "dgdg f", "OCT_TEL": "dgf dgf", "OCT_MOB": "dfgd fg", "OCT_FAX": "dgf df" }, "CONTACT_DELIVERY": { "ID": 8136018, "OCT_ORID": 2615416, "OCT_TYPE": "D", "OCT_CTID": 31, "OCT_ISHISTORIC": false, "OCT_ADDRESS": "", "OCT_BUILDINGNUMBERORNAME": null, "OCT_NAME": "", "OCT_ADDRESS1": null, "OCT_ADDRESS2": null, "OCT_ADDRESS3": null, "OCT_TOWN": null, "OCT_SRLID": null, "OCT_POSTCODE": null, "OCT_COUNTRYID": null, "OCT_DESCRIPTION": null, "OCT_LOCATION_REFERENCE": null, "OCT_CONTACT": null, "OCT_EMAIL": null, "OCT_TEL": null, "OCT_MOB": null, "OCT_FAX": null }, "CONTACT_ACCOUNT": { "ID": 8136019, "OCT_ORID": 2615416, "OCT_TYPE": "A", "OCT_CTID": 426906, "OCT_ISHISTORIC": false, "OCT_ADDRESS": "", "OCT_BUILDINGNUMBERORNAME": null, "OCT_NAME": "", "OCT_ADDRESS1": null, "OCT_ADDRESS2": null, "OCT_ADDRESS3": null, "OCT_TOWN": null, "OCT_SRLID": null, "OCT_POSTCODE": null, "OCT_COUNTRYID": null, "OCT_DESCRIPTION": "", "OCT_LOCATION_REFERENCE": "", "OCT_CONTACT": null, "OCT_EMAIL": null, "OCT_TEL": null, "OCT_MOB": "", "OCT_FAX": null }, "CONTACT_SHIPPER": { "ID": 8136020, "OCT_ORID": 2615416, "OCT_TYPE": "S", "OCT_CTID": 355776, "OCT_ISHISTORIC": false, "OCT_ADDRESS": "DGF", "OCT_BUILDINGNUMBERORNAME": null, "OCT_NAME": "DGF", "OCT_ADDRESS1": "", "OCT_ADDRESS2": "", "OCT_ADDRESS3": "", "OCT_TOWN": "", "OCT_SRLID": null, "OCT_POSTCODE": "", "OCT_COUNTRYID": null, "OCT_DESCRIPTION": "", "OCT_LOCATION_REFERENCE": "", "OCT_CONTACT": null, "OCT_EMAIL": null, "OCT_TEL": null, "OCT_MOB": "", "OCT_FAX": null }, "ITEM": [ { "ID": 28604906, "OI_ORDERID": 2615416, "OI_PRODUCTID": 126811, "OI_PRODUCTID_DETAIL": [ { "ID": 126811, "PC_PRODUCTSTYLE": "A", "PC_FABRICCODE": "A", "PC_COLOUR": "A", "PC_ACTIVE": true, "PC_IMAGEFILE_URL": "https://dev-black.zedonk.biz/client_product_images/21/PI126811.JPG", "CALC_VISIBLE": true, "CALC_WHOLESALEMARKUP_ID": 2, "CALC_RETAILMARKUP_ID": 2 } ], "OI_PRICE": 1000.52, "OI_DOCKETID": null, "OI_DOID": null, "OI_COMMENT": "first comment", "OI_PCINST": 1, "OI_SEQ": 5, "OI_WITHDRAWN": false, "CALC_USEDPRODUCT": 0, "QUANTITY": { "Q1_CALC_DNPT": 0, "Q1_ID": 141844690, "Q1_OQ_ISFORCED": null, "Q1_OQ_ORDERLINEITEMID": 28604906, "Q1_OQ_QUANTITY": 10, "Q1_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q1_OQ_QUANTITYRECEIVED": 0, "Q1_OQ_QUANTITYRS": 0, "Q1_OQ_SEQ": 100, "Q1_OQ_SIZE": "8", "Q2_CALC_DNPT": 0, "Q2_ID": 141844691, "Q2_OQ_ISFORCED": null, "Q2_OQ_ORDERLINEITEMID": 28604906, "Q2_OQ_QUANTITY": 0, "Q2_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q2_OQ_QUANTITYRECEIVED": 0, "Q2_OQ_QUANTITYRS": 0, "Q2_OQ_SEQ": 200, "Q2_OQ_SIZE": "10", "Q3_CALC_DNPT": 0, "Q3_ID": 141844692, "Q3_OQ_ISFORCED": null, "Q3_OQ_ORDERLINEITEMID": 28604906, "Q3_OQ_QUANTITY": 0, "Q3_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q3_OQ_QUANTITYRECEIVED": 0, "Q3_OQ_QUANTITYRS": 0, "Q3_OQ_SEQ": 300, "Q3_OQ_SIZE": "12", "Q4_CALC_DNPT": 0, "Q4_ID": 141844693, "Q4_OQ_ISFORCED": null, "Q4_OQ_ORDERLINEITEMID": 28604906, "Q4_OQ_QUANTITY": 0, "Q4_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q4_OQ_QUANTITYRECEIVED": 0, "Q4_OQ_QUANTITYRS": 0, "Q4_OQ_SEQ": 400, "Q4_OQ_SIZE": "14", "Q5_CALC_DNPT": 0, "Q5_ID": 141844694, "Q5_OQ_ISFORCED": null, "Q5_OQ_ORDERLINEITEMID": 28604906, "Q5_OQ_QUANTITY": 0, "Q5_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q5_OQ_QUANTITYRECEIVED": 0, "Q5_OQ_QUANTITYRS": 0, "Q5_OQ_SEQ": 500, "Q5_OQ_SIZE": "16", "Q6_CALC_DNPT": 0, "Q6_ID": 141844695, "Q6_OQ_ISFORCED": null, "Q6_OQ_ORDERLINEITEMID": 28604906, "Q6_OQ_QUANTITY": 0, "Q6_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q6_OQ_QUANTITYRECEIVED": 0, "Q6_OQ_QUANTITYRS": 0, "Q6_OQ_SEQ": 600, "Q6_OQ_SIZE": "18" } }, { "ID": 28604907, "OI_ORDERID": 2615416, "OI_PRODUCTID": 459778, "OI_PRODUCTID_DETAIL": [ { "ID": 459778, "PC_PRODUCTSTYLE": "A", "PC_FABRICCODE": "B", "PC_COLOUR": "C1", "PC_ACTIVE": true, "PC_IMAGEFILE_URL": null, "CALC_VISIBLE": true, "CALC_WHOLESALEMARKUP_ID": 2, "CALC_RETAILMARKUP_ID": 2 } ], "OI_PRICE": 55.55, "OI_DOCKETID": null, "OI_DOID": null, "OI_COMMENT": "second comment", "OI_PCINST": 1, "OI_SEQ": 10, "OI_WITHDRAWN": false, "CALC_USEDPRODUCT": 0, "QUANTITY": { "Q1_CALC_DNPT": 0, "Q1_ID": 141844696, "Q1_OQ_ISFORCED": null, "Q1_OQ_ORDERLINEITEMID": 28604907, "Q1_OQ_QUANTITY": 10, "Q1_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q1_OQ_QUANTITYRECEIVED": 0, "Q1_OQ_QUANTITYRS": 0, "Q1_OQ_SEQ": 100, "Q1_OQ_SIZE": "8", "Q2_CALC_DNPT": 0, "Q2_ID": 141844697, "Q2_OQ_ISFORCED": null, "Q2_OQ_ORDERLINEITEMID": 28604907, "Q2_OQ_QUANTITY": 0, "Q2_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q2_OQ_QUANTITYRECEIVED": 0, "Q2_OQ_QUANTITYRS": 0, "Q2_OQ_SEQ": 200, "Q2_OQ_SIZE": "10", "Q3_CALC_DNPT": 0, "Q3_ID": 141844698, "Q3_OQ_ISFORCED": null, "Q3_OQ_ORDERLINEITEMID": 28604907, "Q3_OQ_QUANTITY": 0, "Q3_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q3_OQ_QUANTITYRECEIVED": 0, "Q3_OQ_QUANTITYRS": 0, "Q3_OQ_SEQ": 300, "Q3_OQ_SIZE": "12", "Q4_CALC_DNPT": 0, "Q4_ID": 141844699, "Q4_OQ_ISFORCED": null, "Q4_OQ_ORDERLINEITEMID": 28604907, "Q4_OQ_QUANTITY": 0, "Q4_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q4_OQ_QUANTITYRECEIVED": 0, "Q4_OQ_QUANTITYRS": 0, "Q4_OQ_SEQ": 400, "Q4_OQ_SIZE": "14", "Q5_CALC_DNPT": 0, "Q5_ID": 141844700, "Q5_OQ_ISFORCED": null, "Q5_OQ_ORDERLINEITEMID": 28604907, "Q5_OQ_QUANTITY": 0, "Q5_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q5_OQ_QUANTITYRECEIVED": 0, "Q5_OQ_QUANTITYRS": 0, "Q5_OQ_SEQ": 500, "Q5_OQ_SIZE": "16", "Q6_CALC_DNPT": 0, "Q6_ID": 141844701, "Q6_OQ_ISFORCED": null, "Q6_OQ_ORDERLINEITEMID": 28604907, "Q6_OQ_QUANTITY": 0, "Q6_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q6_OQ_QUANTITYRECEIVED": 0, "Q6_OQ_QUANTITYRS": 0, "Q6_OQ_SEQ": 600, "Q6_OQ_SIZE": "18" } }, { "ID": 28604909, "OI_ORDERID": 2615416, "OI_PRODUCTID": 1108766, "OI_PRODUCTID_DETAIL": [ { "ID": 1108766, "PC_PRODUCTSTYLE": "sizetest", "PC_FABRICCODE": "sizetest", "PC_COLOUR": "sizetest", "PC_ACTIVE": true, "PC_IMAGEFILE_URL": "https://dev-black.zedonk.biz/client_product_images/21/PI1108766.JPG", "CALC_VISIBLE": true, "CALC_WHOLESALEMARKUP_ID": null, "CALC_RETAILMARKUP_ID": null } ], "OI_PRICE": 66.66, "OI_DOCKETID": null, "OI_DOID": null, "OI_COMMENT": "third comment", "OI_PCINST": 1, "OI_SEQ": 15, "OI_WITHDRAWN": false, "CALC_USEDPRODUCT": 0, "QUANTITY": { "Q1_CALC_DNPT": 0, "Q1_ID": 141844708, "Q1_OQ_ISFORCED": null, "Q1_OQ_ORDERLINEITEMID": 28604909, "Q1_OQ_QUANTITY": 5, "Q1_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q1_OQ_QUANTITYRECEIVED": 0, "Q1_OQ_QUANTITYRS": 0, "Q1_OQ_SEQ": 100, "Q1_OQ_SIZE": "S", "Q2_CALC_DNPT": 0, "Q2_ID": 141844709, "Q2_OQ_ISFORCED": null, "Q2_OQ_ORDERLINEITEMID": 28604909, "Q2_OQ_QUANTITY": 6, "Q2_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q2_OQ_QUANTITYRECEIVED": 0, "Q2_OQ_QUANTITYRS": 0, "Q2_OQ_SEQ": 200, "Q2_OQ_SIZE": "M", "Q3_CALC_DNPT": 0, "Q3_ID": 141844710, "Q3_OQ_ISFORCED": null, "Q3_OQ_ORDERLINEITEMID": 28604909, "Q3_OQ_QUANTITY": 7, "Q3_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q3_OQ_QUANTITYRECEIVED": 0, "Q3_OQ_QUANTITYRS": 0, "Q3_OQ_SEQ": 300, "Q3_OQ_SIZE": "L" } }, { "ID": 28604910, "OI_ORDERID": 2615416, "OI_PRODUCTID": 119179, "OI_PRODUCTID_DETAIL": [ { "ID": 119179, "PC_PRODUCTSTYLE": "SCOTFORD", "PC_FABRICCODE": "SCOTFORD", "PC_COLOUR": "SCOTFORD", "PC_ACTIVE": true, "PC_IMAGEFILE_URL": null, "CALC_VISIBLE": true, "CALC_WHOLESALEMARKUP_ID": 2, "CALC_RETAILMARKUP_ID": 2 } ], "OI_PRICE": 77.77, "OI_DOCKETID": null, "OI_DOID": null, "OI_COMMENT": "fourth comment", "OI_PCINST": 1, "OI_SEQ": 20, "OI_WITHDRAWN": false, "CALC_USEDPRODUCT": 0, "QUANTITY": { "Q1_CALC_DNPT": 0, "Q1_ID": 141844711, "Q1_OQ_ISFORCED": null, "Q1_OQ_ORDERLINEITEMID": 28604910, "Q1_OQ_QUANTITY": 2, "Q1_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q1_OQ_QUANTITYRECEIVED": 0, "Q1_OQ_QUANTITYRS": 0, "Q1_OQ_SEQ": 100, "Q1_OQ_SIZE": "1", "Q2_CALC_DNPT": 0, "Q2_ID": 141844712, "Q2_OQ_ISFORCED": null, "Q2_OQ_ORDERLINEITEMID": 28604910, "Q2_OQ_QUANTITY": 4, "Q2_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q2_OQ_QUANTITYRECEIVED": 0, "Q2_OQ_QUANTITYRS": 0, "Q2_OQ_SEQ": 200, "Q2_OQ_SIZE": "2", "Q3_CALC_DNPT": 0, "Q3_ID": 141844713, "Q3_OQ_ISFORCED": null, "Q3_OQ_ORDERLINEITEMID": 28604910, "Q3_OQ_QUANTITY": 6, "Q3_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q3_OQ_QUANTITYRECEIVED": 0, "Q3_OQ_QUANTITYRS": 0, "Q3_OQ_SEQ": 300, "Q3_OQ_SIZE": "3", "Q4_CALC_DNPT": 0, "Q4_ID": 141844714, "Q4_OQ_ISFORCED": null, "Q4_OQ_ORDERLINEITEMID": 28604910, "Q4_OQ_QUANTITY": 8, "Q4_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q4_OQ_QUANTITYRECEIVED": 0, "Q4_OQ_QUANTITYRS": 0, "Q4_OQ_SEQ": 400, "Q4_OQ_SIZE": "4", "Q5_CALC_DNPT": 0, "Q5_ID": 141844715, "Q5_OQ_ISFORCED": null, "Q5_OQ_ORDERLINEITEMID": 28604910, "Q5_OQ_QUANTITY": 10, "Q5_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q5_OQ_QUANTITYRECEIVED": 0, "Q5_OQ_QUANTITYRS": 0, "Q5_OQ_SEQ": 500, "Q5_OQ_SIZE": "5", "Q6_CALC_DNPT": 0, "Q6_ID": 141844716, "Q6_OQ_ISFORCED": null, "Q6_OQ_ORDERLINEITEMID": 28604910, "Q6_OQ_QUANTITY": 12, "Q6_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q6_OQ_QUANTITYRECEIVED": 0, "Q6_OQ_QUANTITYRS": 0, "Q6_OQ_SEQ": 600, "Q6_OQ_SIZE": "6", "Q7_CALC_DNPT": 0, "Q7_ID": 141844717, "Q7_OQ_ISFORCED": null, "Q7_OQ_ORDERLINEITEMID": 28604910, "Q7_OQ_QUANTITY": 14, "Q7_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q7_OQ_QUANTITYRECEIVED": 0, "Q7_OQ_QUANTITYRS": 0, "Q7_OQ_SEQ": 700, "Q7_OQ_SIZE": "7", "Q8_CALC_DNPT": 0, "Q8_ID": 141844718, "Q8_OQ_ISFORCED": null, "Q8_OQ_ORDERLINEITEMID": 28604910, "Q8_OQ_QUANTITY": 16, "Q8_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q8_OQ_QUANTITYRECEIVED": 0, "Q8_OQ_QUANTITYRS": 0, "Q8_OQ_SEQ": 800, "Q8_OQ_SIZE": "8", "Q9_CALC_DNPT": 0, "Q9_ID": 141844719, "Q9_OQ_ISFORCED": null, "Q9_OQ_ORDERLINEITEMID": 28604910, "Q9_OQ_QUANTITY": 18, "Q9_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q9_OQ_QUANTITYRECEIVED": 0, "Q9_OQ_QUANTITYRS": 0, "Q9_OQ_SEQ": 900, "Q9_OQ_SIZE": "9", "Q10_CALC_DNPT": 0, "Q10_ID": 141844720, "Q10_OQ_ISFORCED": null, "Q10_OQ_ORDERLINEITEMID": 28604910, "Q10_OQ_QUANTITY": 20, "Q10_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q10_OQ_QUANTITYRECEIVED": 0, "Q10_OQ_QUANTITYRS": 0, "Q10_OQ_SEQ": 1000, "Q10_OQ_SIZE": "10", "Q11_CALC_DNPT": 0, "Q11_ID": 141844721, "Q11_OQ_ISFORCED": null, "Q11_OQ_ORDERLINEITEMID": 28604910, "Q11_OQ_QUANTITY": 22, "Q11_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q11_OQ_QUANTITYRECEIVED": 0, "Q11_OQ_QUANTITYRS": 0, "Q11_OQ_SEQ": 1100, "Q11_OQ_SIZE": "11", "Q12_CALC_DNPT": 0, "Q12_ID": 141844722, "Q12_OQ_ISFORCED": null, "Q12_OQ_ORDERLINEITEMID": 28604910, "Q12_OQ_QUANTITY": 24, "Q12_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q12_OQ_QUANTITYRECEIVED": 0, "Q12_OQ_QUANTITYRS": 0, "Q12_OQ_SEQ": 1200, "Q12_OQ_SIZE": "12", "Q13_CALC_DNPT": 0, "Q13_ID": 141844723, "Q13_OQ_ISFORCED": null, "Q13_OQ_ORDERLINEITEMID": 28604910, "Q13_OQ_QUANTITY": 26, "Q13_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q13_OQ_QUANTITYRECEIVED": 0, "Q13_OQ_QUANTITYRS": 0, "Q13_OQ_SEQ": 1300, "Q13_OQ_SIZE": "13", "Q14_CALC_DNPT": 0, "Q14_ID": 141844724, "Q14_OQ_ISFORCED": null, "Q14_OQ_ORDERLINEITEMID": 28604910, "Q14_OQ_QUANTITY": 28, "Q14_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q14_OQ_QUANTITYRECEIVED": 0, "Q14_OQ_QUANTITYRS": 0, "Q14_OQ_SEQ": 1400, "Q14_OQ_SIZE": "14", "Q15_CALC_DNPT": 0, "Q15_ID": 141844725, "Q15_OQ_ISFORCED": null, "Q15_OQ_ORDERLINEITEMID": 28604910, "Q15_OQ_QUANTITY": 30, "Q15_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q15_OQ_QUANTITYRECEIVED": 0, "Q15_OQ_QUANTITYRS": 0, "Q15_OQ_SEQ": 1500, "Q15_OQ_SIZE": "15", "Q16_CALC_DNPT": 0, "Q16_ID": 141844726, "Q16_OQ_ISFORCED": null, "Q16_OQ_ORDERLINEITEMID": 28604910, "Q16_OQ_QUANTITY": 32, "Q16_OQ_QUANTITYPRODUCTIONDELIVERED": 0, "Q16_OQ_QUANTITYRECEIVED": 0, "Q16_OQ_QUANTITYRS": 0, "Q16_OQ_SEQ": 1600, "Q16_OQ_SIZE": "16" } } ] } }