Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
A valid request URL is required to generate request examples[
{
"id": 29,
"project_id": 5,
"position": 5,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-100"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "WALL STORAGE UNIT"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "CABINET GABIN"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "CABINET GABIN IN OAK - SLATE GREY"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "W - 1000MM X H - 1400MM X D - 400MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": "Approved w/ comments"
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"http://www.hartodesign.fr/storage/gabin-cabinet-grisardoise.html"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$1,200.00",
"calculated_value": 1200
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$660.00",
"calculated_value": 660
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$1,320.00",
"calculated_value": 1320
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-1,200.00",
"calculated_value": -1200
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 28,
"project_id": 5,
"position": 6,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-101"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "WALL CABINETS"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "8",
"calculated_value": 8
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "WALL CABINETS"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "BRIDGE SHELFS"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "H - 770MM X L - 1030MM X W - 230MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.bolia.com/en-gb/products/04-060-02_11255927"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$120.00",
"calculated_value": 120
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$16.50",
"calculated_value": 16.5
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$132.00",
"calculated_value": 132
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-120.00",
"calculated_value": -120
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-06-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 8,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 6,
"quantity": 2,
"area_multiplier": 1
},
{
"area_id": 7,
"quantity": 1,
"area_multiplier": 2
},
{
"area_id": 5,
"quantity": 2,
"area_multiplier": 2
}
]
},
{
"id": 27,
"project_id": 5,
"position": 7,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-102"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "DESK CHAIR"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "DESK CHAIR"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "NULITE 28040"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "H - 1050MM TO 1150MM W - 655MM X D - 540MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": "Rejected"
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": "SAMPLEP-2 / Draft\nSAMPLEP-1 / Draft"
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-3 / Draft\nSAMPLEP-2 / Draft\nSAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"http://luxy.com/prodotto/nulite/28040"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$200.00",
"calculated_value": 200
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$110.00",
"calculated_value": 110
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$220.00",
"calculated_value": 220
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-200.00",
"calculated_value": -200
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-09-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 26,
"project_id": 5,
"position": 8,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-103"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "DESK"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "SOCIETY TABLE"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "AJ52-16070 SOCIETY TABLE"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "ARM HEIGHT- 440MM TO 540MM SEAT HEIGHT - 440MM TO 540MM\""
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.carlhansen.com/en/collection/desk/aj52-160x70/society-table--160-x-70-cm--walnut-oil-black/variant/1403"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$700.00",
"calculated_value": 700
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$385.00",
"calculated_value": 385
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$770.00",
"calculated_value": 770
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-700.00",
"calculated_value": -700
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 25,
"project_id": 5,
"position": 9,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-104"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "CEILING LAMP"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "CEILING LAMP"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "LEAVES PENDANT"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.bolia.com/en-gb/products/20-120-01_6893458"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$330.00",
"calculated_value": 330
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$660.00",
"calculated_value": 660
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-600.00",
"calculated_value": -600
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-06-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
}
]{
"error": "Unauthorized"
}{
"error": "Forbidden"
}{
"error": "Not Found"
}lists the items in the project
A valid request URL is required to generate request examples[
{
"id": 29,
"project_id": 5,
"position": 5,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-100"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "WALL STORAGE UNIT"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "CABINET GABIN"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "CABINET GABIN IN OAK - SLATE GREY"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "W - 1000MM X H - 1400MM X D - 400MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": "Approved w/ comments"
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"http://www.hartodesign.fr/storage/gabin-cabinet-grisardoise.html"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$1,200.00",
"calculated_value": 1200
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$660.00",
"calculated_value": 660
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$1,320.00",
"calculated_value": 1320
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-1,200.00",
"calculated_value": -1200
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 28,
"project_id": 5,
"position": 6,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-101"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "WALL CABINETS"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "8",
"calculated_value": 8
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "WALL CABINETS"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "BRIDGE SHELFS"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "H - 770MM X L - 1030MM X W - 230MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.bolia.com/en-gb/products/04-060-02_11255927"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$120.00",
"calculated_value": 120
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$16.50",
"calculated_value": 16.5
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$132.00",
"calculated_value": 132
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$15.00",
"calculated_value": 15
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-120.00",
"calculated_value": -120
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-06-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 8,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 6,
"quantity": 2,
"area_multiplier": 1
},
{
"area_id": 7,
"quantity": 1,
"area_multiplier": 2
},
{
"area_id": 5,
"quantity": 2,
"area_multiplier": 2
}
]
},
{
"id": 27,
"project_id": 5,
"position": 7,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-102"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "DESK CHAIR"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "DESK CHAIR"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "NULITE 28040"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "H - 1050MM TO 1150MM W - 655MM X D - 540MM"
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": "Rejected"
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": "SAMPLEP-2 / Draft\nSAMPLEP-1 / Draft"
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-3 / Draft\nSAMPLEP-2 / Draft\nSAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"http://luxy.com/prodotto/nulite/28040"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$200.00",
"calculated_value": 200
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$110.00",
"calculated_value": 110
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$220.00",
"calculated_value": 220
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$100.00",
"calculated_value": 100
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-200.00",
"calculated_value": -200
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-09-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 26,
"project_id": 5,
"position": 8,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-103"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "DESK"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "SOCIETY TABLE"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "AJ52-16070 SOCIETY TABLE"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": "ARM HEIGHT- 440MM TO 540MM SEAT HEIGHT - 440MM TO 540MM\""
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.carlhansen.com/en/collection/desk/aj52-160x70/society-table--160-x-70-cm--walnut-oil-black/variant/1403"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$700.00",
"calculated_value": 700
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$385.00",
"calculated_value": 385
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$770.00",
"calculated_value": 770
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$350.00",
"calculated_value": 350
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-700.00",
"calculated_value": -700
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
},
{
"id": 25,
"project_id": 5,
"position": 9,
"state": "active",
"division": {
"id": 10,
"name": "Furnishings",
"code": "FU",
"key": "12_furnishings",
"children": []
},
"vendor_id": 12,
"revit_id": null,
"column_values": [
{
"column": {
"id": 1,
"key": "model_status",
"name": "Item Status",
"type": "model_status",
"position": 1,
"property": "project"
},
"displayed_value": "Draft"
},
{
"column": {
"id": 2,
"key": "project_management_approve_by",
"name": "Approve by",
"type": "entity_time_range",
"position": 2,
"property": "project"
}
},
{
"column": {
"id": 3,
"key": "project_management_order_by",
"name": "Order by",
"type": "entity_time_range",
"position": 3,
"property": "project"
}
},
{
"column": {
"id": 4,
"key": "project_management_deliver_by",
"name": "Deliver by",
"type": "entity_time_range",
"position": 4,
"property": "project"
}
},
{
"column": {
"id": 5,
"key": "project_management_install_by",
"name": "Install by",
"type": "entity_time_range",
"position": 5,
"property": "project"
}
},
{
"column": {
"id": 6,
"key": "project_item_uid",
"name": "Project Item UID",
"type": "project_item_uid",
"position": 6,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 7,
"key": "symbol",
"name": "Tag/CAD Ref.",
"type": "text",
"position": 7,
"property": "project"
},
"displayed_value": "XO-104"
},
{
"column": {
"id": 8,
"key": "product_type",
"name": "Product Type",
"type": "text",
"position": 8,
"property": "product"
},
"displayed_value": "CEILING LAMP"
},
{
"column": {
"id": 9,
"key": "quantity",
"name": "QTY",
"type": "quantity",
"position": 9,
"property": "project"
},
"displayed_value": "2",
"calculated_value": 2
},
{
"column": {
"id": 10,
"key": "images",
"name": "Images",
"type": "images",
"position": 10,
"property": "product"
},
"images": []
},
{
"column": {
"id": 11,
"key": "name",
"name": "Product Name",
"type": "text",
"position": 11,
"property": "product"
},
"displayed_value": "CEILING LAMP"
},
{
"column": {
"id": 12,
"key": "sku",
"name": "Model #",
"type": "text",
"position": 12,
"property": "product"
},
"displayed_value": "LEAVES PENDANT"
},
{
"column": {
"id": 13,
"key": "material_type",
"name": "Material Type",
"type": "text",
"position": 13,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 14,
"key": "unit_of_measurement",
"name": "Unit",
"type": "list",
"position": 14,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 15,
"key": "fabric_finish",
"name": "Fabric Finish",
"type": "text",
"position": 15,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 16,
"key": "color",
"name": "Color",
"type": "dimensions",
"position": 16,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 17,
"key": "dimensions",
"name": "Dimension",
"type": "dimensions",
"position": 17,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 18,
"key": "description",
"name": "Description",
"type": "text",
"position": 18,
"property": "product"
},
"displayed_value": ""
},
{
"column": {
"id": 19,
"key": "rfq_quotes_statuses",
"name": "RFQ # / Status",
"type": "rfq_quotes_statuses",
"position": 19,
"property": "project"
},
"displayed_value": "RFQ-1 / Draft\nRFQ-2 / Draft\nRFQ-3 / Draft"
},
{
"column": {
"id": 20,
"key": "supplier_entity_link",
"name": "Supplier",
"type": "contact_entity_link",
"position": 20,
"property": "project"
},
"supplier": {
"id": 12,
"name": "Sample supplier",
"data": {
"notes": {
"value": {
"value": "This is a sample supplier"
}
},
"account": {
"value": {
"vat": null,
"terms": null,
"currency": "USD",
"lead_time": null,
"credit_limit": null,
"account_number": null,
"registration_number": null
}
},
"address": {
"value": [
{
"id": 12,
"city": "New York",
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"state": "New York",
"country": "United States of America",
"contacts": {
"value": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"note": "This is a sample supplier",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"priority": "primary"
}
]
},
"priority": "primary",
"post_code": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"team_region_id": null
}
]
},
"company_details": {
"value": {
"email": "info_1@supplier.com",
"status": "Approved",
"website": "www.supplier.com",
"language": null,
"password": "Password",
"user_name": "Username",
"company_name": "Sample supplier"
}
}
},
"addresses": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"phone": "0123456789",
"postcode": "10001",
"address_line_1": "A street address",
"address_line_2": null,
"city": "New York",
"state": "New York",
"country": "United States of America"
}
],
"people": [
{
"id": 12,
"name": "Sample First Name Sample Last Name",
"email": "info_1@supplier.com",
"phone": "0123456789",
"position": null,
"note": "This is a sample supplier"
}
],
"categories": [
{
"id": 2,
"type": "supplier"
}
]
}
},
{
"column": {
"id": 21,
"key": "external_approval",
"name": "External Approval",
"type": "list",
"position": 21,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 23,
"key": "warehouse_shipment_entity_link",
"name": "Ship to address",
"type": "contact_entity_link",
"position": 23,
"property": "project"
}
},
{
"column": {
"id": 24,
"key": "purchase_orders",
"name": "Purchase order # / Status",
"type": "purchase_orders",
"position": 24,
"property": "project"
},
"displayed_value": "PO-1 / Draft PO"
},
{
"column": {
"id": 25,
"key": "supplier_invoices",
"name": "Supplier Invoice # / Status",
"type": "supplier_invoices",
"position": 25,
"property": "project"
},
"displayed_value": "Invoice 1 / Draft"
},
{
"column": {
"id": 26,
"key": "client_proposals",
"name": "Sales Quote # / Status",
"type": "client_proposals",
"position": 26,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 27,
"key": "invoices",
"name": "Client Invoice # / Status",
"type": "invoices",
"position": 27,
"property": "project"
},
"displayed_value": "SAMPLEP-1 / Draft"
},
{
"column": {
"id": 28,
"key": "po_create_date",
"name": "PO create date",
"type": "po_create_date",
"position": 28,
"property": "project"
},
"displayed_value": "PO-1 / Aug-07-26"
},
{
"column": {
"id": 29,
"key": "order_by_date",
"name": "Order by Date",
"type": "date",
"position": 29,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 30,
"key": "manufacturer_entity_link",
"name": "Manufacturer / Contact book",
"type": "contact_entity_link",
"position": 30,
"property": "product"
},
"manufacturer": null
},
{
"column": {
"id": 31,
"key": "order_lead_time",
"name": "Order Lead Time",
"type": "text",
"position": 31,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 32,
"key": "assignee",
"name": "Assignee",
"type": "assignee",
"position": 32,
"property": "project"
},
"users": []
},
{
"column": {
"id": 33,
"key": "status",
"name": "Status",
"type": "list",
"position": 33,
"property": "project"
},
"displayed_value": "Selection in progress"
},
{
"column": {
"id": 34,
"key": "url",
"name": "Link",
"type": "url",
"position": 34,
"property": "product"
},
"urls": [
"https://www.bolia.com/en-gb/products/20-120-01_6893458"
]
},
{
"column": {
"id": 35,
"key": "docs",
"name": "Docs",
"type": "docs",
"position": 35,
"property": "product"
},
"docs": []
},
{
"column": {
"id": 36,
"key": "note",
"name": "Notes",
"type": "text",
"position": 36,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 37,
"key": "library_uid",
"name": "Library UID",
"type": "library_uid",
"position": 37,
"property": "product"
}
},
{
"column": {
"id": 38,
"key": "product_block_name",
"name": "Block Name",
"type": "text",
"position": 38,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 39,
"key": "created_at",
"name": "Creation Date",
"type": "created_at",
"position": 39,
"property": "product"
}
},
{
"column": {
"id": 40,
"key": "__my_profit__",
"name": "My Profit ⓢ",
"type": "number",
"position": 40,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 41,
"key": "__client_price__",
"name": "Client Price ⓢ",
"type": "number",
"position": 41,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 42,
"key": "__client_saving__",
"name": "Client Saving ⓢ",
"type": "number",
"position": 42,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 43,
"key": "__profit__",
"name": "Markup % ⓢ",
"type": "number",
"position": 43,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 44,
"key": "__extended_cost__",
"name": "Extended Trade Cost ⓢ",
"type": "number",
"position": 44,
"property": "pricing"
},
"displayed_value": "$600.00",
"calculated_value": 600
},
{
"column": {
"id": 45,
"key": "__tax_on_purchase__",
"name": "Tax on Purchase ⓢ",
"type": "tax_rates",
"position": 45,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 46,
"key": "__client_costs__",
"name": "Client Soft Costs ⓢ",
"type": "number",
"position": 46,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 47,
"key": "__actual_margin_percent__",
"name": "Actual Margin % ⓢ",
"type": "number",
"position": 47,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 48,
"key": "__client_total__",
"name": "Client Total ⓢ",
"type": "number",
"position": 48,
"property": "pricing"
},
"displayed_value": "$330.00",
"calculated_value": 330
},
{
"column": {
"id": 49,
"key": "__extended_client_total__",
"name": "Extended Client Total ⓢ",
"type": "number",
"position": 49,
"property": "pricing"
},
"displayed_value": "$660.00",
"calculated_value": 660
},
{
"column": {
"id": 50,
"key": "__additional_costs__",
"name": "Internal Soft Costs ⓢ",
"type": "number",
"position": 50,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 51,
"key": "__customs_and_duties__",
"name": "Customs and Duties ⓢ",
"type": "number",
"position": 51,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 52,
"key": "__component_build_cost__",
"name": "Component Build Cost ⓢ",
"type": "number",
"position": 52,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 53,
"key": "__fabrication_and_labor__",
"name": "Fabrication & Labor ⓢ",
"type": "number",
"position": 53,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 54,
"key": "__unit_cost__",
"name": "Trade Price ⓢ",
"type": "number",
"position": 54,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 55,
"key": "__trade_discount__",
"name": "Trade Discount ⓢ",
"type": "number",
"position": 55,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 56,
"key": "__list_price__",
"name": "Retail Price ⓢ",
"type": "number",
"position": 56,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 57,
"key": "__full_cost__",
"name": "Cost Price ⓢ",
"type": "number",
"position": 57,
"property": "pricing"
},
"displayed_value": "$300.00",
"calculated_value": 300
},
{
"column": {
"id": 58,
"key": "__budget_variance__",
"name": "Budget Variance ⓢ",
"type": "number",
"position": 58,
"property": "pricing"
},
"displayed_value": "$-600.00",
"calculated_value": -600
},
{
"column": {
"id": 59,
"key": "__total_planned_budget__",
"name": "Total Planned Budget ⓢ",
"type": "number",
"position": 59,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 60,
"key": "__soft_costs_allowance__",
"name": "Soft Costs Allowance ⓢ",
"type": "number",
"position": 60,
"property": "pricing"
},
"displayed_value": "0.00%",
"calculated_value": 0
},
{
"column": {
"id": 61,
"key": "__estimated_price__",
"name": "Planned Price ⓢ",
"type": "number",
"position": 61,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 62,
"key": "__extended_planned_price__",
"name": "Extended Planned Price ⓢ",
"type": "number",
"position": 62,
"property": "pricing"
},
"displayed_value": "$0.00",
"calculated_value": 0
},
{
"column": {
"id": 63,
"key": "po_ship_to",
"name": "PO Ship to",
"type": "po_ship_to",
"position": 63,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 64,
"key": "order_tracking_delivery_by",
"name": "Delivery By",
"type": "date",
"position": 64,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 65,
"key": "po_bill_to",
"name": "PO Bill to",
"type": "po_bill_to",
"position": 65,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 66,
"key": "est_ship_date",
"name": "Estimated ship date",
"type": "est_ship_date",
"position": 66,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 67,
"key": "po_shipped_date",
"name": "Shipped date",
"type": "po_shipped_date",
"position": 67,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 68,
"key": "est_delivery_date",
"name": "Estimated delivery date",
"type": "est_delivery_date",
"position": 68,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 69,
"key": "po_received_date",
"name": "Date received",
"type": "po_received_date",
"position": 69,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 70,
"key": "purchase_order_quantity",
"name": "Actual Ordered QTY",
"type": "purchase_order_quantity",
"position": 70,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 71,
"key": "qty_received",
"name": "QTY Received",
"type": "qty_received",
"position": 71,
"property": "project"
},
"displayed_value": "0.0",
"calculated_value": 0
},
{
"column": {
"id": 72,
"key": "shipment_status",
"name": "Shipment Status",
"type": "shipment_status",
"position": 72,
"property": "project"
},
"displayed_value": "Not yet shipped"
},
{
"column": {
"id": 73,
"key": "shipment_tracking_num",
"name": "Tracking Number",
"type": "shipment_tracking_num",
"position": 73,
"property": "project"
},
"displayed_value": "NUM1"
},
{
"column": {
"id": 74,
"key": "purchasing_notes",
"name": "Purchasing Notes",
"type": "text",
"position": 74,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 75,
"key": "installation_date",
"name": "Installation Date",
"type": "date",
"position": 75,
"property": "project"
},
"displayed_value": "2022-06-15"
},
{
"column": {
"id": 76,
"key": "installation_status",
"name": "Installation Status",
"type": "list",
"position": 76,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 77,
"key": "installation_notes",
"name": "Installation notes",
"type": "text",
"position": 77,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 78,
"key": "installation_docs",
"name": "Installation Docs",
"type": "docs",
"position": 78,
"property": "project"
},
"docs": []
},
{
"column": {
"id": 79,
"key": "__docs_for_design_approval__",
"name": "Documents for Design Approval",
"type": "multiple_select",
"position": 79,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 80,
"key": "installed_by",
"name": "Installed By",
"type": "text",
"position": 80,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 81,
"key": "__furnished_and_installed_by__",
"name": "Furnished & Installed By",
"type": "list",
"position": 81,
"property": "project"
},
"displayed_value": ""
},
{
"column": {
"id": 82,
"key": "__tax_rates__",
"name": "Client Sales Tax ⓢ",
"type": "tax_rates",
"position": 82,
"property": "pricing"
},
"displayed_value": "Sample Tax (10.0%)",
"calculated_value": 0.1
},
{
"column": {
"id": 83,
"key": "lead_time_days",
"name": "Lead Time (Days)",
"type": "duration_days",
"position": 83,
"property": "project"
},
"displayed_value": ""
}
],
"child_item_ids": [],
"quantity": 2,
"extra_quantity": 0,
"area_quantities": [
{
"area_id": 5,
"quantity": 1,
"area_multiplier": 2
}
]
}
]{
"error": "Unauthorized"
}{
"error": "Forbidden"
}{
"error": "Not Found"
}1 <= x <= 100x >= 1OK
active, removed Show child attributes
Show child attributes
Show child attributes