{
  "LogInInformation": {
    "Server":"scpc99.unige.ch",
    "Port": "3306"
  },
  
  "Applications": {
	"CadenceInstallDir": "C:\\Cadence\\SPB_16.6\\",
	"Allegro":"tools\\pcb\\bin\\allegro.exe",
	"AllegroViewer": "tools\\pcb\\bin\\allegro_viewer_plus.exe",
	"TempPath": "c:\\temp\\",
	"Capture": "tools\\capture\\capture.exe",
	"PCBtools": "L:\\PCB_lib\\templates\\scripts\\PCB_PCBtools.exe",
	"UserGuide": "L:\\user guide PCB.pdf",
	"SSHPath": "C:\\Program Files (x86)\\SSH Communications Security\\SSH Secure Shell",
	"SM902Path": "V:\\Workshop\\SM902\\Projects\\",
	"LinuxProjectPath": "/RAID/samba/dvpelec/projects/",
	"BugReport": "http://dpnc.unige.ch/~favrey/mantisbt/login_page.php",
	"Versions": "http://dpnc.unige.ch/~favrey/DVPELEC/Readme-Versions.txt",
	"DefaultImagePath": "L:\\Datasheets\\Packages\\Images",
	"DefaultDatasheetPath": "L:\\Datasheets\\Components",
	"DefaultProjectPath": "V:\\EnCours",
	"DefaultCasePath": "L:\\PCB_lib\\symbols",
	"DefaultSchematicLibPath": "L:\\CAPTURE_LIB",
  },
  
  "SqlListPNDesign": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 70
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 250
            },
            {
              "Field": "Schematic Part",
              "Index": 4,
              "Width": 200
            },
            {
              "Field": "Value",
              "Index": 5,
              "Width": 80
            },
            {
              "Field": "Tolerance",
              "Index": 6,
              "Width": 50
            },
            {
              "Field": "Rating",
              "Index": 7,
              "Width": 50
            },
            {
              "Field": "Design Status Note",
              "Index": 10,
              "Width": 150
            },
            {
              "Field": "Ambient Operating Temperature - Ta Min °C",
              "Index": 11,
              "Width": 70
            },
            {
              "Field": "Ambient Operating Temperature - Ta Max °C",
              "Index": 12,
              "Width": 70
            },
            {
              "Field": "Temperature Coefficient Ratio - TCR (ppm/K)",
              "Index": 13,
              "Width": 100
            },
            {
              "Field": "PACKAGE_HEIGHT_MAX",
              "Index": 18,
              "Width": 120
            },
            {
              "Field": "PCB_Footprint",
              "Index": 14,
              "Width": 300
            },
            {
              "Field": "ALT_SYMBOLS",
              "Index": 15,
              "Width": 200
            }
          ]
        },
        {
          "TableName": "PartType",
          "Columns": [
            {
              "Field": "Part Type",
              "Index": 2,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "Case",
          "Columns": [
            {
              "Field": "Case",
              "Index": 3,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "DesignStatusL1",
          "Columns": [
            {
              "Field": "Design Status Level 1",
              "Index": 8,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "DesignStatusL2",
          "Columns": [
            {
              "Field": "Design Status Level 2",
              "Index": 9,
              "Width": 90
            }
          ]
        },
        {
          "TableName": "ECADStatus",
          "Columns": [
            {
              "Field": "ECAD status",
              "Index": 16,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "WorkflowStatus",
          "Columns": [
            {
              "Field": "Workflow Status",
              "Index": 17,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Type",
          "TableName2": "PartType",
          "Field2": "Part Type"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Case",
          "TableName2": "Case",
          "Field2": "Case"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Design Status (1st Level)",
          "TableName2": "DesignStatusL1",
          "Field2": "N°"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Design Status (2nd Level)",
          "TableName2": "DesignStatusL2",
          "Field2": "N°"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "ECAD Status",
          "TableName2": "ECADStatus",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "WorkflowStatus",
          "TableName2": "WorkflowStatus",
          "Field2": "ID"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },  
  "SqlListPNAll": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 70
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 250
            },
            {
              "Field": "Long Description",
              "Index": 2,
              "Width": 300
            },
            {
              "Field": "Schematic Part",
              "Index": 5,
              "Width": 250
            },
            {
              "Field": "Value",
              "Index": 6,
              "Width": 100
            },
            {
              "Field": "Tolerance",
              "Index": 7,
              "Width": 100
            },
            {
              "Field": "Rating",
              "Index": 8,
              "Width": 50
            },
            {
              "Field": "Design Status Note",
              "Index": 11,
              "Width": 150
            },
            {
              "Field": "Comment",
              "Index": 13,
              "Width": 185
            },
            {
              "Field": "Ambient Operating Temperature - Ta Min °C",
              "Index": 16,
              "Width": 70
            },
            {
              "Field": "Ambient Operating Temperature - Ta Max °C",
              "Index": 17,
              "Width": 70
            },
            {
              "Field": "Storage Temperature - Ts Min °C",
              "Index": 18,
              "Width": 100
            },
            {
              "Field": "Storage Temperature - Ts Max °C",
              "Index": 19,
              "Width": 100
            },
            {
              "Field": "Temperature Coefficient Ratio - TCR (ppm/K)",
              "Index": 20,
              "Width": 100
            },
            {
              "Field": "PACKAGE_HEIGHT_MAX",
              "Index": 26,
              "Width": 180
            },
            {
              "Field": "PCB_Footprint",
              "Index": 21,
              "Width": 300
            },
            {
              "Field": "ALT_SYMBOLS",
              "Index": 22,
              "Width": 200
            }
          ]
        },
        {
          "TableName": "PartType",
          "Columns": [
            {
              "Field": "Part Type",
              "Index": 3,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "Case",
          "Columns": [
            {
              "Field": "Case",
              "Index": 4,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "DesignStatusL1",
          "Columns": [
            {
              "Field": "Design Status Level 1",
              "Index": 9,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "DesignStatusL2",
          "Columns": [
            {
              "Field": "Design Status Level 2",
              "Index": 10,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "CatalogOrCustom",
          "Columns": [
            {
              "Field": "Catalog or custom",
              "Index": 12,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "RoHSCompliant",
          "Columns": [
            {
              "Field": "RoHS Compliant",
              "Index": 14,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "LeadFreeProcComp",
          "Columns": [
            {
              "Field": "Lead Free Process Compatible",
              "Index": 15,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "MultiSourceStatus",
          "Columns": [
            {
              "Field": "Multi-source status",
              "Index": 23,
              "Width": 150
            }
          ]
        },
        {
          "TableName": "ECADStatus",
          "Columns": [
            {
              "Field": "ECAD status",
              "Index": 24,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "WorkflowStatus",
          "Columns": [
            {
              "Field": "Workflow Status",
              "Index": 25,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Type",
          "TableName2": "PartType",
          "Field2": "Part Type"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Case",
          "TableName2": "Case",
          "Field2": "Case"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Design Status (1st Level)",
          "TableName2": "DesignStatusL1",
          "Field2": "N°"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Design Status (2nd Level)",
          "TableName2": "DesignStatusL2",
          "Field2": "N°"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Catalog or Custom",
          "TableName2": "CatalogOrCustom",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "RoHS Compliant",
          "TableName2": "RoHSCompliant",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Lead Free Process Compatible",
          "TableName2": "LeadFreeProcComp",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Multi-Source Status",
          "TableName2": "MultiSourceStatus",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "ECAD Status",
          "TableName2": "ECADStatus",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "WorkflowStatus",
          "TableName2": "WorkflowStatus",
          "Field2": "ID"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "SqlListPNStock": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 70
            },
            {
              "Field": "Stock",
              "Index": 7,
              "Width": 70
            },
            {
              "Field": "Cabinet/Shelf",
              "Index": 8,
              "Width": 80
            },
            {
              "Field": "Drawer",
              "Index": 9,
              "Width": 80
            },
            {
              "Field": "Box",
              "Index": 10,
              "Width": 50
            },
			{
              "Field": "Reserved",
              "Index": 12,
              "Width": 50
            },				
            {
              "Field": "On Order",
              "Index": 13,
              "Width": 50
            },			
			{
              "Field": "Planned Use",
              "Index": 14,
              "Width": 70
            },			
			{
              "Field": "Remark",
              "Index": 15,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 250
            },
            {
              "Field": "Value",
              "Index": 4,
              "Width": 80
            },
            {
              "Field": "Tolerance",
              "Index": 5,
              "Width": 70
            },
            {
              "Field": "Rating",
              "Index": 6,
              "Width": 70
            }
          ]
        },
        {
          "TableName": "Case",
          "Columns": [
            {
              "Field": "Case",
              "Index": 3,
              "Width": 120
            }
          ]
        },		
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 11,
              "Width": 100
            }
          ]
        },       
        {
          "TableName": "PartType",
          "Columns": [
            {
              "Field": "Part Type",
              "Index": 2,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "Stock",
          "Field1": "Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Case",
          "TableName2": "Case",
          "Field2": "Case"
        },		
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        },
		{
          "TableName1": "PartNumber",
          "Field1": "Part Type",
          "TableName2": "PartType",
          "Field2": "Part Type"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "SqlListPNQuality": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 70
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 250
            },
            {
              "Field": "Value",
              "Index": 4,
              "Width": 80
            },
            {
              "Field": "Tolerance",
              "Index": 5,
              "Width": 50
            },
            {
              "Field": "Rating",
              "Index": 6,
              "Width": 50
            },
            {
              "Field": "Comment",
              "Index": 8,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "PartType",
          "Columns": [
            {
              "Field": "Part Type",
              "Index": 2,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "Case",
          "Columns": [
            {
              "Field": "Case",
              "Index": 3,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "CatalogOrCustom",
          "Columns": [
            {
              "Field": "Catalog or custom",
              "Index": 7,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "RoHSCompliant",
          "Columns": [
            {
              "Field": "RoHS Compliant",
              "Index": 9,
              "Width": 50
            }
          ]
        },
        {
          "TableName": "LeadFreeProcComp",
          "Columns": [
            {
              "Field": "Lead Free Process Compatible",
              "Index": 10,
              "Width": 50
            }
          ]
        },
        {
          "TableName": "MultiSourceStatus",
          "Columns": [
            {
              "Field": "Multi-source status",
              "Index": 11,
              "Width": 130
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Type",
          "TableName2": "PartType",
          "Field2": "Part Type"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Case",
          "TableName2": "Case",
          "Field2": "Case"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Catalog or Custom",
          "TableName2": "CatalogOrCustom",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "RoHS Compliant",
          "TableName2": "RoHSCompliant",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Lead Free Process Compatible",
          "TableName2": "LeadFreeProcComp",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Multi-Source Status",
          "TableName2": "MultiSourceStatus",
          "Field2": "ID"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "FilterPN": {
    "Filter": {
      "NbTextBox": 31,
      "NbColumn": 5,
      "VerticalSpace": -3,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 2,
      "WidthColumn": [
        275,
        255,
        265,
        225,
        155
      ]
    },
    "TextBox": [
      {
        "TableName": "PartNumber",
        "Field": "Part Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Short Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Long Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false, true, false, false]
      },
      {
        "TableName": "PartType",
        "Field": "Part Type",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "DesignStatusL1",
        "Field": "Design Status Level 1",
        "Type": "SmartList",
        "Description": "Design Status (1st Level) :",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "DesignStatusL2",
        "Field": "Design Status Level 2",
        "Type": "SmartList",
        "Description": "Design Status (2nd Level) :",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Design Status Note",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "CatalogOrCustom",
        "Field": "Catalog or custom",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [false, true, false, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false, true, false, true]
      },
      {
        "TableName": "RoHSCompliant",
        "Field": "RoHS Compliant",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [false, true, false, true]
      },
      {
        "TableName": "LeadFreeProcComp",
        "Field": "Lead Free Process Compatible",
        "Type": "SmartList",
        "Description": "Lead Free Process Comp :",
        "Enabled": [false, true, false, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Ambient Operating Temperature - Ta Min °C",
        "Type": "SmartTextBox",
        "Description": "Ambient Op Temp (min) :",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Ambient Operating Temperature - Ta Max °C",
        "Type": "SmartTextBox",
        "Description": "Ambient Op Temp (max) :",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "Case",
        "Field": "Case",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Schematic Part",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Storage Temperature - Ts Min °C",
        "Type": "SmartTextBox",
        "Description": "Storage Temp (min) :",
        "Enabled": [false, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Storage Temperature - Ts Max °C",
        "Type": "SmartTextBox",
        "Description": "Storage Temp (max) :",
        "Enabled": [false, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Temperature Coefficient Ratio - TCR (ppm/K)",
        "Type": "SmartTextBox",
        "Description": "Temp Coeff Ratio\nTCR (ppm/K) :",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "PartNumber",
        "Field": "Value",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Tolerance",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Rating",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, true, true]
      },
      {
        "TableName": "Case",
        "Field": "Allegro_PCB_Footprint",
        "Type": "SmartTextBox",
        "Description": "PCB_Footprint",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "Case",
        "Field": "ALT_SYMBOLS",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "MultiSourceStatus",
        "Field": "Multi-source status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [false, true, false, true]
      },
      {
        "TableName": "ECADStatus",
        "Field": "ECAD status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "WorkflowStatus",
        "Field": "Workflow Status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true, true, false, false]
      },
      {
        "TableName": "Stock",
        "Field": "Stock",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false, false, true, false]
      },
      {
        "TableName": "Stock",
        "Field": "Cabinet/Shelf",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false, false, true, false]
      },
      {
        "TableName": "Stock",
        "Field": "Drawer",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false, false, true, false]
      },
      {
        "TableName": "Stock",
        "Field": "On Order",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [false, false, true, false]
      },
	  {
        "TableName": "Stock",
        "Field": "Reserved",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [false, false, true, false],
		"PlaceOnRightOfControl": [29, 80]
      }
    ]
  },
  
  "SqlListMPN": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "MfrPartNumber",
          "Columns": [
            {
              "Field": "ID",
              "Index": 0,
              "Width": 60
            },
            {
              "Field": "Mfr Item No",
              "Index": 2,
              "Width": 200
            },
            {
              "Field": "Quality Status Note",
              "Index": 6,
              "Width": 200
            },
            {
              "Field": "Comment",
              "Index": 7,
              "Width": 150
            },
            {
              "Field": "PDF",
              "Index": 8,
              "Width": 150
            },
            {
              "Field": "PDF2",
              "Index": 13,
              "Width": 75
            },
            {
              "Field": "PDF3",
              "Index": 14,
              "Width": 75
            }
          ]
        },
        {
          "TableName": "MfrName",
          "Columns": [
            {
              "Field": "Manufacturer Name",
              "Index": 1,
              "Width": 180
            }
          ]
        },
        {
          "TableName": "PurchasingStatus",
          "Columns": [
            {
              "Field": "Purchasing Status",
              "Index": 3,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "QualityStatusL1",
          "Columns": [
            {
              "Field": "Quality Status Level 1",
              "Index": 4,
              "Width": 170
            }
          ]
        },
        {
          "TableName": "QualityStatusL2",
          "Columns": [
            {
              "Field": "Quality Status Level 2",
              "Index": 5,
              "Width": 170
            }
          ]
        },
        {
          "TableName": "MfrRoHSCompliant",
          "Columns": [
            {
              "Field": "Mfr RoHS compliant",
              "Index": 9,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "MfrLeadFreeProcComp",
          "Columns": [
            {
              "Field": "Mfr lead free process compatible",
              "Index": 10,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "PurchasingQualityStatus",
          "Columns": [
            {
              "Field": "Purchasing and quality status",
              "Index": 11,
              "Width": 120
            }
          ]
        },
        {
          "TableName": "WorkflowStatus",
          "Columns": [
            {
              "Field": "Workflow Status",
              "Index": 12,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Manufacturer Name",
          "TableName2": "MfrName",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing Status",
          "TableName2": "PurchasingStatus",
          "Field2": "N°"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Quality Status (1st Level)",
          "TableName2": "QualityStatusL1",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Quality Status (2nd Level)",
          "TableName2": "QualityStatusL2",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Mfr RoHS Compliant",
          "TableName2": "MfrRoHSCompliant",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Mfr Lead Free Process Compatible",
          "TableName2": "MfrLeadFreeProcComp",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing & Quality Status",
          "TableName2": "PurchasingQualityStatus",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "WorkflowStatus",
          "TableName2": "WorkflowStatus",
          "Field2": "ID"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "FilterMPN": {
    "Filter": {
      "NbTextBox": 12,
      "NbColumn": 3,
      "VerticalSpace": -3,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        380,
        350,
        360
      ]
    },
    "TextBox": [
      {
        "TableName": "MfrName",
        "Field": "Manufacturer Name",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Mfr Item No",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PurchasingStatus",
        "Field": "Purchasing Status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "QualityStatusL1",
        "Field": "Quality Status Level 1",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "QualityStatusL2",
        "Field": "Quality Status Level 2",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Quality Status Note",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "PDF",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrRoHSCompliant",
        "Field": "Mfr RoHS compliant",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrLeadFreeProcComp",
        "Field": "Mfr lead free process compatible",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PurchasingQualityStatus",
        "Field": "Purchasing and quality status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
	  {
        "TableName": "WorkflowStatus",
        "Field": "Workflow Status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
    ]
  },

  "SqlListCase": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "Case",
          "Columns": [
            {
              "Field": "Case",
              "Index": 0,
              "Width": 180
            },
            {
              "Field": "Pin Number",
              "Index": 1,
              "Width": 50
            },
            {
              "Field": "PDF",
              "Index": 2,
              "Width": 50
            },
            {
              "Field": "Comment",
              "Index": 3,
              "Width": 220
            },
            {
              "Field": "Height (mm)",
              "Index": 4,
              "Width": 60
            },
            {
              "Field": "Length (mm)",
              "Index": 5,
              "Width": 60
            },
            {
              "Field": "Width (mm)",
              "Index": 6,
              "Width": 60
            },
            {
              "Field": "Jedec Name",
              "Index": 7,
              "Width": 200
            },
            {
              "Field": "Allegro_PCB_Footprint",
              "Index": 8,
              "Width": 190
            },
            {
              "Field": "ALT_SYMBOLS",
              "Index": 9,
              "Width": 300
            },
            {
              "Field": "Image",
              "Index": 10,
              "Width": 150
            },
            {
              "Field": "PDF2",
              "Index": 11,
              "Width": 50
            },
            {
              "Field": "PDF3",
              "Index": 12,
              "Width": 50
            },
            {
              "Field": "Path",
              "Index": 13,
              "Width": 280
            }
          ]
        },
        {
          "TableName": "WorkflowStatus",
          "Columns": [
            {
              "Field": "Workflow Status",
              "Index": 14,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
	    {
          "TableName1": "Case",
          "Field1": "WorkflowStatus",
          "TableName2": "WorkflowStatus",
          "Field2": "ID"
        }
	  ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "FilterCase": {
    "Filter": {
      "NbTextBox": 12,
      "NbColumn": 3,
      "VerticalSpace": -3,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        380,
        300,
        360
      ]
    },
    "TextBox": [
      {
        "TableName": "Case",
        "Field": "Case",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Jedec Name",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },	  
      {
        "TableName": "Case",
        "Field": "Path",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },	  
      {
        "TableName": "Case",
        "Field": "Pin Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },	  
      {
        "TableName": "Case",
        "Field": "Height (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Length (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Width (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "PDF",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Allegro_PCB_Footprint",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "ALT_SYMBOLS",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
	  {
        "TableName": "WorkflowStatus",
        "Field": "Workflow Status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      }
    ]
  },

  "SqlListPCBA": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PCBAssembly",
          "Columns": [
            {
              "Field": "PCB",
              "Index": 0,
              "Width": 100
            },
            {
              "Field": "Description",
              "Index": 1,
              "Width": 250
            },
            {
              "Field": "Revision",
              "Index": 2,
              "Width": 50
            },
            {
              "Field": "Date Import",
              "Index": 3,
              "Width": 100
            },
            {
              "Field": "Designer",
              "Index": 4,
              "Width": 80
            },
            {
              "Field": "Remarks",
              "Index": 6,
              "Width": 180
            },
            {
              "Field": "User",
              "Index": 7,
              "Width": 100
            },
            {
              "Field": "Archived",
              "Index": 8,
              "Width": 60
            },
            {
              "Field": "Date Creation",
              "Index": 9,
              "Width": 100
            },
            {
              "Field": "Remarks (2)",
              "Index": 10,
              "Width": 180
            },
            {
              "Field": "Schematic PDF",
              "Index": 11,
              "Width": 120
            },
            {
              "Field": "Layout PDF",
              "Index": 12,
              "Width": 120
            },
            {
              "Field": "PCB tech file",
              "Index": 13,
              "Width": 120
            },
            {
              "Field": "Path",
              "Index": 14,
              "Width": 120
            },
            {
              "Field": "Protected",
              "Index": 15,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "Projects",
          "Columns": [
            {
              "Field": "Project",
              "Index": 5,
              "Width": 90
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "Projects",
          "Field1": "ID",
          "TableName2": "PCBAssembly",
          "Field2": "Project"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "FilterPCBA": {
    "Filter": {
      "NbTextBox": 12,
      "NbColumn": 4,
      "VerticalSpace": -3,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        275,
        245,
        255,
        215
      ]
    },
    "TextBox": [
      {
        "TableName": "PCBAssembly",
        "Field": "PCB",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Revision",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Date Import",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
		"IsDateTime": true
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Designer",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Projects",
        "Field": "Project",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Remarks",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "User",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Archived",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Date Creation",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
		"IsDateTime": true
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Remarks (2)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Protected",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true]
      }		  
    ]
  },

  "InsertFilterPartNumber": {
    "Filter": {
      "NbTextBox": 24,
      "NbColumn": 2,
      "VerticalSpace": 0,
      "HorizontalSpace": 20,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        530,
        450
      ]
    },
    "TextBox": [
      {
        "TableName": "PartNumber",
        "Field": "Part Number",
        "Type": "SmartTextBox",
        "Description": "Part Number: *",
        "Enabled": [true],
        "DefaultValue": "$Last"
      },
      {
        "TableName": "PartNumber",
        "Field": "Short Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Long Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "DesignStatusL1",
        "Field": "Design Status Level 1",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Design Status (1st Level)",
        "DefaultValue": "Approved for design",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "PartType",
        "Field": "Part Type",
        "Type": "SmartList",
        "Description": "Part Type: *",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Part Type",
        "DefaultValue": "AOP"
      },
      {
        "TableName": "DesignStatusL2",
        "Field": "Design Status Level 2",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Design Status (2nd Level)",
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "Design Status Note",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "CatalogOrCustom",
        "Field": "Catalog or custom",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Catalog or Custom",
        "DefaultValue": "Catalog"
      },
      {
        "TableName": "PartNumber",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "RoHSCompliant",
        "Field": "RoHS Compliant",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "RoHS Compliant",
        "DefaultValue": "Yes",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "LeadFreeProcComp",
        "Field": "Lead Free Process Compatible",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Lead Free Process Compatible",
        "DefaultValue": "Yes",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "PartNumber",
        "Field": "Ambient Operating\nTemperature - Ta Min °C",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "PartNumber",
        "Field": "Ambient Operating\nTemperature - Ta Max °C",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "Case",
        "Field": "Case",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PartNumber",
        "FieldDest": "Case",
        "DefaultValue": "TEMP"
      },
      {
        "TableName": "PartNumber",
        "Field": "Schematic Part",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "L:\\CAPTURE_LIB\\"
      },
      {
        "TableName": "PartNumber",
        "Field": "Storage Temperature - Ts Min °C",
        "Type": "SmartTextBox",
        "Description": "Storage Temp (min):",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "PartNumber",
        "Field": "Storage Temperature - Ts Max °C",
        "Type": "SmartTextBox",
        "Description": "Storage Temp (max):",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "PartNumber",
        "Field": "Temperature Coefficient Ratio - TCR (ppm/K)",
        "Type": "SmartTextBox",
        "Description": "Temp Coeff Ratio - TCR (ppm/K)",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "PartNumber",
        "Field": "Value",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "Tolerance",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "Rating",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "PACKAGE_HEIGHT_MAX",
        "Type": "SmartTextBox",
        "Description": "Height(mm):",
        "Enabled": [true],
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "PCB_Footprint",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false],
        "DefaultValue": ""
      },
      {
        "TableName": "PartNumber",
        "Field": "ALT_SYMBOLS",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false],
        "DefaultValue": ""
      }
    ]
  },

  "SqlListPNDetailsStock": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 80
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 180
            },
            {
              "Field": "Long Description",
              "Index": 2,
              "Width": 250
            },
            {
              "Field": "Part Type",
              "Index": 3,
              "Width": 120
            },
            {
              "Field": "Schematic part",
              "Index": 6,
              "Width": 180
            },
            {
              "Field": "Case",
              "Index": 7,
              "Width": 180
            }
          ]
        },
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Stock(DEFAULT)0",
              "Index": 4,
              "Width": 60,
              "Alias": "Stock"
            }
          ]
        },
        {
          "TableName": "DesignStatusL1",
          "Columns": [
            {
              "Field": "Design Status Level 1",
              "Index": 5,
              "Width": 120
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Number",
          "TableName2": "Stock",
          "Field2": "Part Number"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Design Status (1st Level)",
          "TableName2": "DesignStatusL1",
          "Field2": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },
  "SqlListPNDetailsMPN": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "MfrName",
          "Columns": [
            {
              "Field": "Manufacturer Name",
              "Index": 0,
              "Width": 150
            }
          ]
        },
        {
          "TableName": "MfrPartNumber",
          "Columns": [
            {
              "Field": "Mfr Item No",
              "Index": 1,
              "Width": 150
            },
            {
              "Field": "PDF",
              "Index": 3,
              "Width": 80
            },
            {
              "Field": "Quality Status Note",
              "Index": 7,
              "Width": 280
            },
            {
              "Field": "PDF2",
              "Index": 11,
              "Width": 80
            },
            {
              "Field": "PDF3",
              "Index": 12,
              "Width": 80
            },
            {
              "Field": "ID",
              "Index": 100,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "PurchasingQualityStatus",
          "Columns": [
            {
              "Field": "Purchasing and quality status",
              "Index": 2,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "PurchasingStatus",
          "Columns": [
            {
              "Field": "Purchasing Status",
              "Index": 4,
              "Width": 140
            }
          ]
        },
        {
          "TableName": "QualityStatusL1",
          "Columns": [
            {
              "Field": "Quality Status Level 1",
              "Index": 5,
              "Width": 220
            }
          ]
        },
        {
          "TableName": "QualityStatusL2",
          "Columns": [
            {
              "Field": "Quality Status Level 2",
              "Index": 6,
              "Width": 220
            }
          ]
        },
        {
          "TableName": "MfrRoHSCompliant",
          "Columns": [
            {
              "Field": "Mfr RoHS compliant",
              "Index": 8,
              "Width": 160
            }
          ]
        },
        {
          "TableName": "MfrLeadFreeProcComp",
          "Columns": [
            {
              "Field": "Mfr lead free process compatible",
              "Index": 9,
              "Width": 160
            }
          ]
        },
        {
          "TableName": "PartNumberAssembly",
          "Columns": [
            {
              "Field": "Quantity",
              "Index": 10,
              "Width": 160
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Manufacturer Name",
          "TableName2": "MfrName",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing & Quality Status",
          "TableName2": "PurchasingQualityStatus",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing Status",
          "TableName2": "PurchasingStatus",
          "Field2": "N°"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Quality Status (1st Level)",
          "TableName2": "QualityStatusL1",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Quality Status (2nd Level)",
          "TableName2": "QualityStatusL2",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Mfr RoHS Compliant",
          "TableName2": "MfrRoHSCompliant",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Mfr lead free process compatible",
          "TableName2": "MfrLeadFreeProcComp",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "ID",
          "TableName2": "PartNumberAssembly",
          "Field2": "Mfr Part Number ID"
        }
      ]
    },

    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 100,
      "TextToDisplay": "Total :"
    }
  },

  "SqlListStockDetailsStock": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 120
            },
            {
              "Field": "Stock",
              "Index": 1,
              "Width": 100
            },	
            {
              "Field": "Cabinet/Shelf",
              "Index": 3,
              "Width": 120
            },
            {
              "Field": "Drawer",
              "Index": 4,
              "Width": 100
            },
            {
              "Field": "Box",
              "Index": 5,
              "Width": 100
            },
            {
              "Field": "Reserved",
              "Index": 7,
              "Width": 70
            },				
            {
              "Field": "Remark",
              "Index": 9,
              "Width": 230
            },			
            {
              "Field": "ID",
              "Index": 10,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 6,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "Stock",
          "Restriction": "Part Number=$CurrentPN"
        },
		{
          "Table": "Stock",
          "Restriction": "On Order=0"
        }
      ]
    }
  },
  "SqlListStockDetailsOnOrder": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 120
            },
            {
              "Field": "Stock",
              "Index": 1,
              "Width": 100
            },		
            {
              "Field": "Cabinet/Shelf",
              "Index": 3,
              "Width": 120,
			  "Alias": "Remark"
            },
            {
              "Field": "Drawer",
              "Index": 4,
              "Width": 100,
			  "Alias": "Distributor"
            },
            {
              "Field": "Box",
              "Index": 5,
              "Width": 100,
			  "Alias": "User"
            },
            {
              "Field": "Remark",
              "Index": 7,
              "Width": 230,
			  "Alias": "PCBA prod."
            },
            {
              "Field": "Planned Use",
              "Index": 8,
              "Width": 100
            },			
            {
              "Field": "ID",
              "Index": 10,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 6,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "Stock",
          "Restriction": "Part Number=$CurrentPN"
        },
		{
          "Table": "Stock",
          "Restriction": "On Order=1"
        }
      ]
    }
  },
  "SqlListStockDetailsInPrep": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "PN",
              "Index": 0,
              "Width": 120,
              "Alias": "Part Number"
            },
            {
              "Field": "Delivered Qty",
              "Index": 1,
              "Width": 100,
              "Alias": "In prep Qty"
            }
          ]
        },
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "MFG Order",
              "Index": 2,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "PCBA",
              "Index": 3,
              "Width": 200
            },
            {
              "Field": "Boards Qty",
              "Index": 4,
              "Width": 300
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "BL",
          "Field1": "MFG Order",
          "TableName2": "MFGorder",
          "Field2": "MFG Order"
        }
      ],
      "Conditions": [
        {
          "Table": "BOMorder",
          "Restriction": "PN=$CurrentPN"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=0"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        }
      ]
    }
  },
  "SqlListStockDetailsPotRet": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "PN",
              "Index": 0,
              "Width": 120,
              "Alias": "Part Number"
            },
            {
              "Field": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty",
              "Index": 1,
              "Width": 100,
              "Alias": "Potential return Qty"
            }
          ]
        },
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "MFG Order",
              "Index": 2,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "PCBA",
              "Index": 3,
              "Width": 200
            },
            {
              "Field": "Boards Qty",
              "Index": 4,
              "Width": 300
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "BL",
          "Field1": "MFG Order",
          "TableName2": "MFGorder",
          "Field2": "MFG Order"
        }
      ],
      "Conditions": [
        {
          "Table": "BOMorder",
          "Restriction": "PN=$CurrentPN"
        },
        {
          "Table": "BOMorder",
          "Restriction": "Returned=0"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=1"
        },
        {
          "Table": "",
          "Restriction": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty=>0"
        }
      ]
    }
  },
  "InsertFilterStock": {
    "Filter": {
      "NbTextBox": 11,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 20,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        420
      ]
    },
    "TextBox": [
      {
        "TableName": "Stock",
        "Field": "ID",
        "Type": "SmartTextBox",
        "Description": "ID: *",
        "Enabled": [false],
        "DefaultValue": "$Last"
      },
      {
        "TableName": "Stock",
        "Field": "Part Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "ReadOnly": true
      },
      {
        "TableName": "Stock",
        "Field": "Stock",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "0"
      },
      {
        "TableName": "Stock",
        "Field": "On Order",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "0"
      },
	  {
        "TableName": "Stock",
        "Field": "Reserved",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true],
        "DefaultValue": "0"
      },	  
      {
        "TableName": "Stock",
        "Field": "Cabinet/Shelf",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Stock",
        "Field": "Drawer",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Stock",
        "Field": "Box",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Conditioning",
        "Field": "Conditioning",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "Stock",
        "FieldDest": "Conditioning"
      },
      {
        "TableName": "Stock",
        "Field": "Remark",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Stock",
        "Field": "Planned Use",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      }
    ]
  },

  "InsertFilterCase": {
    "Filter": {
      "NbTextBox": 14,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 20,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        420
      ]
    },
    "TextBox": [
      {
        "TableName": "Case",
        "Field": "Case",
        "Type": "SmartTextBox",
        "Description": "Case: *",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Pin Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "PDF",
        "Type": "SmartTextBox",
        "Description": "PDF1: ",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "PDF2",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "PDF3",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Height (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Length (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Width (mm)",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Jedec Name",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      }, 
      {
        "TableName": "Case",
        "Field": "Allegro_PCB_Footprint",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "ALT_SYMBOLS",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Image",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Case",
        "Field": "Path",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      }
    ]
  },

  "SqlListSearchPNinPCBA": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "PCB",
              "Index": 0,
              "Width": 180
            },
            {
              "Field": "Part Reference",
              "Index": 2,
              "Width": 300
            },
            {
              "Field": "Short Description",
              "Index": 3,
              "Width": 270
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 1,
              "Width": 180
            }
          ]
        },
        {
          "TableName": "PartType"
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Number",
          "TableName2": "BOM",
          "Field2": "Part Number"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Part Type",
          "TableName2": "PartType",
          "Field2": "Part Type"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Associated PCBAs : "
    }
  },
  "FilterSearchPNinPCBA": {
    "Filter": {
      "NbTextBox": 3,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        520
      ]
    },
    "TextBox": [
      {
        "TableName": "PartNumber",
        "Field": "Case",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [true]
      },
      {
        "TableName": "PartNumber",
        "Field": "Short Description",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [true]
      },
      {
        "TableName": "PartType",
        "Field": "Part Type",
        "Type": "SmartList",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [true]
      }
    ]
  },

  "InsertFilterPCBA": {
    "Filter": {
      "NbTextBox": 10,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 0,
      "HorizontalPaddingLeft": 0,
      "WidthColumn": [
        420
      ]
    },
    "TextBox": [
      {
        "TableName": "PCBAssembly",
        "Field": "PCB",
        "Type": "SmartTextBox",
        "Description": "PCBA : *",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Description",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Revision",
        "Type": "SmartTextBox",
        "Description": "Revision PCBA :",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Designer",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "Projects",
        "Field": "Project",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "PCBAssembly",
        "FieldDest": "Project"
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Remarks",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Remarks (2)",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "User",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Date Creation",
        "Type": "SmartTextBox",
        "Comment : Space in order to place the calendar button": "",
        "Description": "Date Creation :        ",
        "Enabled": [true],
        "ReadOnly": true,
		"IsDateTime": true
      },
      {
        "TableName": "PCBAssembly",
        "Field": "Path",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      }	  
    ]
  },

  "SqlListPCBADetails": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PCBAssembly",
          "Columns": [
            {
              "Field": "PCB",
              "Index": 0,
              "Width": 230
            },
            {
              "Field": "Description",
              "Index": 1,
              "Width": 285
            },
            {
              "Field": "Date Import",
              "Index": 2,
              "Width": 280
            },
            {
              "Field": "Archived",
              "Index": 3,
              "Width": 180
            },
            {
              "Field": "Import OK",
              "Index": 4,
              "Width": 180,
              "Alias": "Import Status"
            }
          ]
        }
      ],
      "Conditions": [
        {
          "Table": "PCBAssembly",
          "Restriction": "PCB=$CurrentPCB"
        }
      ]
    }
  },
  "FilterPCBADetails": {
    "Filter": {
      "NbTextBox": 10,
      "NbColumn": 5,
      "VerticalSpace": 0,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 2,
      "WidthColumn": [
        270,
        310,
        220,
        290,
        107
      ]
    },
    "TextBox": [
      {
        "TableName": "BOM",
        "Field": "Part Reference",
        "Type": "SmartTextBox",
        "Description": "",

        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Part Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Short Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Value",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Item Number",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Quantity",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "NoExport",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Modified",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Added",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true]
      }
    ]
  },
  "SqlListPCBADetailsBOM": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Part Reference",
              "Index": 0,
              "Width": 80
            },
            {
              "Field": "Part Number",
              "Index": 1,
              "Width": 100
            },
            {
              "Field": "Short Description",
              "Index": 2,
              "Width": 270
            },
            {
              "Field": "Value",
              "Index": 3,
              "Width": 80
            },
            {
              "Field": "Item Number",
              "Index": 4,
              "Width": 60
            },
            {
              "Field": "Quantity",
              "Index": 5,
              "Width": 55
            },
            {
              "Field": "Comment",
              "Index": 6,
              "Width": 220
            },
            {
              "Field": "NoExport",
              "Index": 7,
              "Width": 80
            },
            {
              "Field": "Modified",
              "Index": 8,
              "Width": 60
            },
            {
              "Field": "Added",
              "Index": 9,
              "Width": 60
            },
            {
              "Field": "SC_PN",
              "Index": 10,
              "Width": 90
            },
            {
              "Field": "BOM ID",
              "Index": 11,
              "Width": -1
            }
          ]
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "BOM List: "
    }
  },
  "BomTableCondensed": {
    "ColumnToCondense": {
      "Alias": "Part Reference",
      "Index": 0,
      "Width": 520
    },
    "ColumnConsistence": [
      {
        "Alias": "Short Description",
        "Index": 2,
        "Width": 250
      },
      {
        "Alias": "Part Number",
        "Index": 1,
        "Width": 80
      },
      {
        "Alias": "Value",
        "Index": 4,
        "Width": 80
      },
      {
        "Alias": "SC_PN",
        "Index": 5,
        "Width": 100
      }
    ],
    "CoutingColumn": {
      "Alias": "PN Qty",
      "Index": 3,
      "Width": 80
    }
  },

  "ImportBOM": {
    "CountValues": [
      "NC",
      "SC",
      "TP|VIS"
    ],
    "CheckValues": [
      "Quantity=1"
    ],
    "CheckInfoPN": [
      {
        "PNFieldName": "Short Description",
        "BOMFieldName": "Short Description",
        "TErrorBOM": "Warning"
      },
      {
        "PNFieldName": "Value",
        "BOMFieldName": "Value",
        "TErrorBOM": "Error"
      },
      {
        "PNFieldName": "PCB_Footprint",
        "BOMFieldName": "PCB Footprint",
        "TErrorBOM": "Error"
      },
      {
        "PNFieldName": "ALT_SYMBOLS",
        "BOMFieldName": "ALT_SYMBOLS",
        "TErrorBOM": "Error"
      }
    ]
  },
  "ExportBOM": {
    "WidthColumn": [
      4.86,
      12,
      53.29,
      6.43,
      70,
      27.43,
      10.14,
      33.71,
      9.29,
      60
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$PCB"
      ],
      [
        "Description :",
        "",
        "$Description"
      ],
      [
        " ",
        " ",
        " "
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": "220,220,220"
    },
    "Comment : PN Qty is managed in the program and is at the last index": "",
    "BOMTable": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=NC,Not Mounted,(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Alias": "Part Number"
            },
            {
              "Field": "(IF)BOM.Value=NC,,(IF)BOM.Value!=SC,BOM.Short Description,(CONCAT)Short-Circuit PN replaced by : ,PartNumber.Short Description",
              "Index": 1,
              "Alias": "Description"
            },
            {
              "Comment : will be count when the datatable will be condensed": "",
              "Field": "$PN Qty",
              "Index": 2
            },
            {
              "Field": "Part Reference",
              "Index": 3
            }
          ]
        },
        {
          "TableName": "PartNumber"
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumber",
          "Field1": "Part Number",
          "TableName2": "BOM",
          "Field2": "SC_PN"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        }
      ]
    },
    "BomTableCondensed": {
      "ColumnToCondense": {
        "Alias": "Part Reference",
        "Index": 3
      },
      "ColumnConsistence": [
        {
          "Alias": "Description",
          "Index": 1
        },
        {
          "Alias": "Part Number",
          "Index": 0
        }
      ],
      "CoutingColumn": {
        "Alias": "PN Qty",
        "Index": 2
      }
    },
    "TableToExport": {
      "Tables": [
        {
          "TableName": "MfrPartNumber",
          "Columns": [
            {
              "Field": "Mfr Item No",
              "Index": 4,
              "Alias": "Mfr PN"
            },
            {
              "Field": "Comment",
              "Index": 8
            }
          ]
        },
        {
          "TableName": "PartNumberAssembly",
          "Columns": [
            {
              "Field": "Quantity",
              "Index": 5,
              "Alias": "Mfr PN Qty"
            }
          ]
        },
        {
          "TableName": "MfrName",
          "Columns": [
            {
              "Field": "Manufacturer Name",
              "Index": 6
            }
          ]
        },
        {
          "TableName": "PurchasingQualityStatus",
          "Columns": [
            {
              "Field": "Purchasing and quality status",
              "Index": 7,
              "Alias": "Status"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "PartNumberAssembly",
          "Field1": "Mfr Part Number ID",
          "TableName2": "MfrPartNumber",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Manufacturer Name",
          "TableName2": "MfrName",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing & Quality Status",
          "TableName2": "PurchasingQualityStatus",
          "Field2": "ID"
        },
        {
          "--Comment Link with the BOM": "",
          "TableName1": "PartNumberAssembly",
          "Field1": "Part Number",
          "TableName2": "BOM",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "PurchasingQualityStatus",
          "Restriction": "Purchasing and quality status=!Forbidden"
        },
        {
          "Table": "PartNumberAssembly",
          "Restriction": "Part Number=$CurrentPN"
        }
      ]
    },
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "LeftHeaderPDF": "BILL OF MATERIAL",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportBOMAssembly": {
    "WidthColumn": [
      4.86,
      12,
      53.29,
      6.43,
      70,
      27.43,
      33.71
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$PCB"
      ],
      [
        "Description :",
        "",
        "$Description"
      ],
      [
        " ",
        " ",
        " "
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": "220,220,220"
    },
    "Comment : PN Qty is managed in the program and is at the last index": "",
    "BOMTable": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Alias": "Description"
            },
            {
              "Field": "$PN Qty",
              "Index": 2
            },
            {
              "Field": "Part Reference",
              "Index": 3
            },
            {
              "Field": "Value",
              "Index": -1
            },
            {
              "Field": "SC_PN",
              "Index": -1
            }
          ]
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "PCB=$PCB"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=$ReplacePart Number:NC:Not Mounted"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        }
      ]
    },
    "TableToExport": {
      "Tables": [
        {
          "TableName": "MfrPartNumber",
          "Columns": [
            {
              "Field": "Mfr Item No",
              "Index": 4,
              "Alias": "Mfr PN"
            }
          ]
        },
        {
          "TableName": "MfrName",
          "Columns": [
            {
              "Field": "Manufacturer Name",
              "Index": 5
            }
          ]
        },
        {
          "TableName": "PartNumberAssembly"
        },
        {
          "TableName": "PurchasingQualityStatus"
        }
      ],
      "Associations": [
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Manufacturer Name",
          "TableName2": "MfrName",
          "Field2": "ID"
        },
        {
          "TableName1": "PartNumberAssembly",
          "Field1": "Mfr Part Number ID",
          "TableName2": "MfrPartNumber",
          "Field2": "ID"
        },
        {
          "TableName1": "MfrPartNumber",
          "Field1": "Purchasing & Quality Status",
          "TableName2": "PurchasingQualityStatus",
          "Field2": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "PurchasingQualityStatus",
          "Restriction": "Purchasing and quality status=!Forbidden"
        },
        {
          "Table": "PartNumberAssembly",
          "Restriction": "Part Number=$CurrentPN"
        }
      ]
    },
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "LeftHeaderPDF": "BILL OF MATERIAL",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },

  "SqlListPCBAStockDetails": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PCBAssembly",
          "Columns": [
            {
              "Field": "PCB",
              "Index": 0,
              "Width": 230
            },
            {
              "Field": "Description",
              "Index": 1,
              "Width": 450
            },
            {
              "Field": "Date Import",
              "Index": 2,
              "Width": 280
            },
            {
              "Field": "Archived",
              "Index": 3,
              "Width": 180
            }
          ]
        }
      ],
      "Conditions": [
        {
          "Table": "PCBAssembly",
          "Restriction": "PCB=$CurrentPCB"
        }
      ]
    }
  },
  "SqlListPCBAStockDetailsAll": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "$This is the fusion of the following parameters, so this is just a parameters to display the columns order/width",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 100
            },
            {
              "Field": "Description",
              "Index": 1,
              "Width": 200
            },
            {
              "Field": "Location",
              "Index": 2,
              "Width": 250
            },
            {
              "Field": "Unitary Qty",
              "Index": 3,
              "Width": -1
            },
            {
              "Field": "Required Qty",
              "Index": 4,
              "Width": 100
            },
            {
              "Field": "Stock Qty",
              "Index": 5,
              "Width": 100
            },
            {
              "Field": "Remaining Stock Qty",
              "Index": 6,
              "Width": 100
            },
            {
              "Field": "Conditioning",
              "Index": 7,
              "Width": 80
            },
            {
              "Field": "On Order",
              "Index": 8,
              "Width": 50
            },
			{
              "Field": "Reserved",
              "Index": 9,
              "Width": 50
            },
            {
              "Field": "Planned Use",
              "Index": 10,
              "Width": 50
            },
            {
              "Field": "Remark",
              "Index": 11,
              "Width": -1
            }
          ]
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "BOM stock List:"
    }
  },
  "SqlListPCBAStockDetailsDetails": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 200,
              "Alias": "Description"
            },
            {
              "Field": "(CONCAT)Stock.Cabinet/Shelf(DEFAULT)'',\\,Stock.Drawer(DEFAULT)'',\\,Stock.Box(DEFAULT)''",
              "Index": 2,
              "Width": 250,
              "Alias": "Location"
            },
            {
              "Field": "Stock.Stock(DEFAULT)0(DEFAULT)(minus)$CurrentPCBQty(multiply)(COUNT)Part Number(COUNT)",
              "Index": 6,
              "Width": 100,
              "Alias": "Remaining Stock Qty"
            }
          ]
        },
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Stock(DEFAULT)0",
              "Index": 5,
              "Width": 100,
              "Alias": "Stock Qty"
            },
            {
              "Field": "On Order",
              "Index": 8,
              "Width": 50
            },
			{
              "Field": "Reserved",
              "Index": 9,
              "Width": 50
            },
            {
              "Field": "Planned Use",
              "Index": 10,
              "Width": 50
            },			
            {
              "Field": "Remark",
              "Index": 11,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 7,
              "Width": 170
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 100
            },
            {
              "Field": "(COUNT)Part Number",
              "Index": 3,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$CurrentPCBQty(multiply)(COUNT)Part Number",
              "Index": 4,
              "Width": 100,
              "Alias": "Required Qty"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "Stock",
          "Field2": "Part Number"
        },
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        },
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "BOM",
          "Field": "Part Number"
        },
        {
          "TableName": "Stock",
          "Field": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "BOM stock List:"
    }
  },
  "SqlListPCBAStockDetailsSum": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 490,
              "Alias": "Description"
            },
            {
              "Field": "$CurrentPCBQty(multiply)(COUNT)Part Number",
              "Index": 2,
              "Width": 160,
              "Alias": "Required Qty"
            },
            {
              "Field": "$Remaining Stock Qty",
              "Index": 4,
              "Width": 160
            },
            {
              "Field": "$Stock Sum",
              "Index": 3,
              "Width": 160
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 175
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "$BOM",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "$BOM",
          "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "BOM stock List:"
    }
  },
  "SqlListPCBAStockDetailsInPrep": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL"
        },
        {
          "TableName": "MFGorder"
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "Delivered Qty",
              "Index": 5,
              "Width": 100,
              "Alias": "Stock Qty"
            }
          ]
        },
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 355,
              "Alias": "Description"
            },
            {
              "Field": "(CONCAT)In prep for ,MFGorder.PCBA,: MFG order N°,MFGorder.MFG Order",
              "Index": 2,
              "Width": 355,
              "Alias": "Location"
            },
            {
              "Field": "(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 3,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$CurrentPCBQty(multiply)(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 4,
              "Width": 120,
              "Alias": "Required Qty"
            },
            {
              "Field": "BOMorder.Delivered Qty(minus)$CurrentPCBQty(multiply)(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 6,
              "Width": 120,
              "Alias": "Remaining Stock Qty"
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "$Value+BOMorder",
          "Field1": "$CurrentPCB+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "BL",
          "Restriction": "Sent=0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "BOMorder",
          "Field": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListPCBAStockDetailsPotRet": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL"
        },
        {
          "TableName": "MFGorder"
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty",
              "Index": 5,
              "Width": 100,
              "Alias": "Stock Qty"
            }
          ]
        },
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 365,
              "Alias": "Description"
            },
            {
              "Field": "(CONCAT)Sent for ,MFGorder.PCBA,: MFG order N°,MFGorder.MFG Order",
              "Index": 2,
              "Width": 350,
              "Alias": "Location"
            },
            {
              "Field": "(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 3,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$CurrentPCBQty(multiply)(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 4,
              "Width": 120,
              "Alias": "Required Qty"
            },
            {
              "Field": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty(minus)$CurrentPCBQty(multiply)(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 6,
              "Width": 120,
              "Alias": "Remaining Stock Qty"
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "$Value+BOMorder",
          "Field1": "$CurrentPCB+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "BL",
          "Restriction": "Sent=1"
        },
        {
          "Table": "BOMorder",
          "Restriction": "Returned=0"
        },
        {
          "Table": "",
          "Restriction": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty=>0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "BOMorder",
          "Field": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },

  "SqlListMfrOrderMfr": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFG Order",
              "Index": 0,
              "Width": 80
            },
            {
              "Field": "Boards Qty",
              "Index": 1,
              "Width": 80
            },
            {
              "Field": "Batch",
              "Index": 6,
              "Width": 90
            },
            {
              "Field": "User",
              "Index": 7,
              "Width": 60
            },
            {
              "Field": "Order",
              "Index": 8,
              "Width": 100,
              "Alias": "Unige/cern Order"
            },
            {
              "Field": "Date",
              "Index": 9,
              "Width": 100,
              "Alias": "Order Date"
            },
            {
              "Field": "Offer link",
              "Index": 13,
              "Width": 245
            }
          ]
        },
        {
          "TableName": "TypeMFGOrder",
          "Columns": [
            {
              "Field": "Type",
              "Index": 11,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "DN N°",
              "Index": 2,
              "Width": 60
            },
            {
              "Field": "Emission Date",
              "Index": 3,
              "Width": 100,
              "Alias": "DN Date"
            },
            {
              "Field": "Sent",
              "Index": 4,
              "Width": 40,
              "Alias": "DN Sent"
            },
            {
              "Field": "ToPT",
              "Index": 5,
              "Width": 40,
              "Alias": "To PT"
            },			
            {
              "Field": "Remark",
              "Index": 12,
              "Width": 120,
              "Alias": "DN Remark"
            }			
          ]
        },
        {
          "TableName": "Manufacturer",
          "Columns": [
            {
              "Field": "MFG Name",
              "Index": 10,
              "Width": 80
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "Type",
          "TableName2": "TypeMFGOrder",
          "Field2": "ID"
        },
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "MFGorder",
          "Field1": "MFG ID",
          "TableName2": "Manufacturer",
          "Field2": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "MFGorder",
          "Restriction": "PCBA=$CurrentPCB"
        }
      ]
    }
  },
  "SqlListMfrOrderDeliveryStockOnly": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "(CONCAT)Stock:,Stock.Cabinet/Shelf(DEFAULT)'',\\,Stock.Drawer(DEFAULT)'',\\,Stock.Box(DEFAULT)''",
              "Index": 2,
              "Width": 260,
              "Alias": "Location"
            },
            {
              "Field": "(COUNT)Part Number",
              "Index": 3,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$CurrentPCBQty(COUNT)Part Number",
              "Index": 4,
              "Width": 100,
              "Alias": "Required Qty"
            },
            {
              "Field": "Stock.Stock(minus)$CurrentPCBQty(COUNT)Part Number(COUNT)(DEFAULT)0",
              "Index": 6,
              "Width": 100,
              "Alias": "Remaining Stock Qty"
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 225,
              "Alias": "Description"
            }
          ]
        },
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Stock(DEFAULT)0",
              "Index": 5,
              "Width": 100,
              "Alias": "Stock Qty"
            },
			{
              "Field": "On Order",
              "Index": 8,
              "Width": 50,
            },
			{
              "Field": "Reserved",
              "Index": 9,
              "Width": 50,
            },
			{
              "Field": "Planned Use",
              "Index": 10,
              "Width": 50,
            },
			{
              "Field": "Remark",
              "Index": 11,
              "Width": 100,
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 7,
              "Width": 170
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Part Number",
          "TableName2": "Stock",
          "Field2": "Part Number"
        },
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        }
      ],
      "GroupBys": [
        {
          "TableName": "PartNumber",
          "Field": "Part Number"
        },
        {
          "TableName": "Stock",
          "Field": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliverySentOnly": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "(CONCAT)Sent with DN N°,BL.DN N°",
              "Index": 2,
              "Width": 200,
              "Alias": "Location"
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 4,
              "Width": 180,
              "Alias": "Required Qty"
            }
          ]
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "Delivered Qty",
              "Index": 5,
              "Width": 180,
              "Alias": "In prep/Sent Qty"
            },
            {
              "Field": "Returned",
              "Index": 6,
              "Width": 180
            },
            {
              "Field": "Unitary Qty",
              "Index": 3,
              "Width": -1
            },
            {
              "Field": "N°",
              "Index": 100,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "BOM"
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 315,
              "Alias": "Description"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "MFGorder+BOMorder",
          "Field1": "PCBA+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "PN",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "MFGorder",
          "Restriction": "MFG Order=$SelectedMFGOrder"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=1"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "PartNumber",
          "Field": "Part Number"
        },
        {
          "TableName": "BL",
          "Field": "DN N°"
        },
        {
          "TableName": "BOMorder",
          "Field": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliveryInPrep": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "(CONCAT)In preparation for DN N°,BL.DN N°",
              "Index": 2,
              "Width": 300,
              "Alias": "Location"
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 4,
              "Width": 180,
              "Alias": "Required Qty"
            }
          ]
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "Delivered Qty",
              "Index": 5,
              "Width": 200,
              "Alias": "In prep/Sent Qty"
            },
            {
              "Field": "Unitary Qty",
              "Index": 3,
              "Width": -1
            },
            {
              "Field": "N°",
              "Index": 100,
              "Width": -1,
              "Comment : This field will be rewrite and place at the 1st position when the table will be exported. This field is usefull for the stock management": ""
            }
          ]
        },
        { 
          "TableName": "BOM"
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 355,
              "Alias": "Description"
            },
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 120,
              "Alias": "Part Number"
            }

          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "MFGorder+BOMorder",
          "Field1": "PCBA+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "PN",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "MFGorder",
          "Restriction": "MFG Order=$SelectedMFGOrder"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "BOMorder",
          "Field": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliverySuppliedByMfr": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "(CONCAT)Supplied by MFR",
              "Index": 2,
              "Width": 300,
              "Alias": "Location"
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 4,
              "Width": 180,
              "Alias": "Required Qty"
            }
          ]
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "Delivered Qty",
              "Index": 5,
              "Width": 180,
              "Alias": "In prep/Sent Qty"
            },
            {
              "Field": "Unitary Qty",
              "Index": 3,
              "Width": -1
            },
            {
              "Field": "N°",
              "Index": 100,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "BOM"
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 390,
              "Alias": "Description"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "MFGorder+BOMorder",
          "Field1": "PCBA+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "PN",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "MFGorder",
          "Restriction": "MFG Order=$SelectedMFGOrder"
        },
        {
          "Table": "MFGorder",
          "Restriction": "PCBA=$CurrentPCB"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=1"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "PartNumber",
          "Field": "Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliverySynthesis": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "(COUNT)(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$Location",
              "Index": 3,
              "Width": 120
            },
            {
              "Field": "$CurrentPCBQty(COUNT)Part Number",
              "Index": 4,
              "Width": 130,
              "Alias": "Required Qty"
            },
            {
              "Field": "$Stock Qty",
              "Index": 5,
              "Width": 130
            },
            {
              "Field": "$In prep/Sent Qty",
              "Index": 6,
              "Width": 130
            },
            {
              "Field": "$Remaining Stock Qty",
              "Index": 7,
              "Width": 130
            },
            {
              "Field": "$Conditioning",
              "Index": 8,
              "Width": 220
            },
            {
              "Field": "$Returned",
              "Index": 9,
              "Width": 120
            }
          ]
        },
		{
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 1,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 2,
              "Width": 480,
              "Alias": "Description"
            }
          ]
        },
        {
          "TableName": "MFGorder"
        }
      ],
      "Associations": [
        {
          "TableName1": "$BOM",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        },
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "$No Table",
          "Field2": "$SelectedMFGOrder"
        }
      ],
      "GroupBys": [
        {
          "TableName": "$BOM",
          "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliveryStockAll": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "(CONCAT)Stock:,Stock.Cabinet/Shelf(DEFAULT)'',\\,Stock.Drawer(DEFAULT)'',\\,Stock.Box(DEFAULT)''",
              "Index": 2,
              "Width": 200,
              "Alias": "Location"
            },
            {
              "Field": "(COUNT)Part Number",
              "Index": 3,
              "Width": -1,
              "Alias": "Unitary Qty"
            },
            {
              "Field": "$CurrentPCBQty(COUNT)Part Number",
              "Index": 4,
              "Width": 100,
              "Alias": "Required Qty"
            },
            {
              "Field": "$In prep/Sent Qty",
              "Index": 6,
              "Width": 100
            },
            {
              "Field": "$N°",
              "Index": 100,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 200,
              "Alias": "Description"
            }
          ]
        },
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Stock(DEFAULT)0",
              "Index": 5,
              "Width": 100,
              "Alias": "Stock Qty"
            },
			{
              "Field": "On Order",
              "Index": 8,
              "Width": 50,
            },
			{
              "Field": "Reserved",
              "Index": 9,
              "Width": 50,
            },			
			{
              "Field": "Planned Use",
              "Index": 10,
              "Width": 50,
            },			
			{
              "Field": "Remark",
              "Index": 11,
              "Width": 100,
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 7,
              "Width": 150
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "$SpecificPN in BOM table where SC_PN is replaced by the corresponding PN",
          "Field1": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        },
        {
          "TableName1": "PartNumber",
          "Field1": "Part Number",
          "TableName2": "Stock",
          "Field2": "Part Number"
        },
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        }
      ],
      "GroupBys": [
        {
          "TableName": "PartNumber",
          "Field": "Part Number"
        },
        {
          "TableName": "Stock",
          "Field": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },
  "SqlListMfrOrderDeliveryReturned": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "(CONCAT)Sent with DN N°,BL.DN N°",
              "Index": 2,
              "Width": 240,
              "Alias": "Location"
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 4,
              "Width": 180,
              "Alias": "Required Qty"
            }
          ]
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "BOMorder.Delivered Qty(minus)MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 5,
              "Width": 180,
              "Alias": "Returned Qty"
            },
            {
              "Field": "Unitary Qty",
              "Index": 3,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "BOM"
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Width": 100,
              "Alias": "Part Number"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 455,
              "Alias": "Description"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "MFGorder+BOMorder",
          "Field1": "PCBA+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "PN",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "MFGorder",
          "Restriction": "MFG Order=$SelectedMFGOrder"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=1"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!NC"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        },
        {
          "Table": "BOM",
          "Restriction": "PCB=$CurrentPCB"
        },
        {
          "Table": "BOMorder",
          "Restriction": "Returned=1"
        },
        {
          "Table": "PartNumber",
          "Restriction": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number=PartNumber.Part Number"
        }
      ],
      "GroupBys": [
        {
          "TableName": "PartNumber",
          "Field": "Part Number"
        },
        {
          "TableName": "BOMorder",
          "Field": "N°"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 50,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Delivery Note list:"
    }
  },

  "InsertFilterMFGOrder": {
    "Filter": {
      "NbTextBox": 11,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 20,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        480
      ]
    },
    "TextBox": [
      {
        "TableName": "MFGorder",
        "Field": "MFG Order",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "$Last",
        "Enabled": [false]
      },
      {
        "TableName": "MFGorder",
        "Field": "PCBA",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "ReadOnly": true
      },
      {
        "TableName": "MFGorder",
        "Field": "Boards Qty",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MFGorder",
        "Field": "Date",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
		"IsDateTime": true
      },
      {
        "TableName": "MFGorder",
        "Field": "Batch",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MFGorder",
        "Field": "User",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MFGorder",
        "Field": "Order",
        "Type": "SmartTextBox",
        "Description": "Order n° :",
        "Enabled": [true]
      },
      {
        "TableName": "Manufacturer",
        "Field": "MFG Name",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MFGorder",
        "FieldDest": "MFG ID",
        "DefaultValue": "DPNC"
      },
      {
        "TableName": "MFGorder",
        "Field": "Offer link",
        "Type": "SmartTextBox",
        "Comment space in order to place the path button": "",
        "Description": "Offer link :        ",
        "Enabled": [true]
      },
      {
        "TableName": "MFGorder",
        "Field": "Remarks",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "TypeMFGOrder",
        "Field": "Type",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MFGorder",
        "FieldDest": "Type",
        "DefaultValue": "Assembly"
      }
    ]
  },

  "ExportDeliveryNote": {
    "WidthColumn": [
      25,
      60,
      10.43,
      12,
      12.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "$CurrentPCB"
      ],
      [
        "Description :",
        "$PCBDesc"
      ],
      [
        "Order N° :",
        "$MFGOrder"
      ],
      [
        "PCBA Quantity :",
        "$PCBQuantity"
      ],
      [
        "MFG Name/Type :",
        "$MFGName/$AssemblyType"
      ],
      [
        "",
        ""
      ],
      [
        "Delivery Note :",
        "$DNN°"
      ],
	  [
        "Remark :",
        "$Remark"
      ],
      [
        "Date :",
        "$Date"
      ],
      [
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "LeftHeaderPDF": "DELIVERY NOTE N°$DNN° FOR ORDER N°$MFGOrder",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND",
    "BOMTable": {
      "Tables": [
        {
          "TableName": "BL"
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "MFGorder.Boards Qty(multiply)BOMorder.Unitary Qty",
              "Index": 3,
              "Alias": "Required Qty"
            }
          ]
        },
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "Unitary Qty",
              "Index": 2
            },
            {
              "Field": "Delivered Qty",
              "Index": 4
            }
          ]
        },
        {
          "TableName": "BOM",
          "Columns": [
            {
              "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number",
              "Index": 0,
              "Alias": "PN"
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Alias": "Description"
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MFGorder",
          "Field1": "MFG Order",
          "TableName2": "BL",
          "Field2": "MFG Order"
        },
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "MFGorder+BOMorder",
          "Field1": "PCBA+PN",
          "TableName2": "BOM+$BOM",
          "Field2": "PCB+(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "BL",
          "Restriction": "DN N°=$CurrentDNN°"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=0"
        },
        {
          "Table": "BOMorder",
          "Restriction": "SuppliedMFR=0"
        },
        {
          "Table": "BOM",
          "Restriction": "NoExport=0"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!TP"
        },
        {
          "Table": "BOM",
          "Restriction": "Value=!VIS"
        }
      ],
      "GroupBys": [
        {
          "TableName": "$PartNumber",
          "Field": "(IF)BOM.Value=SC,BOM.SC_PN,BOM.Part Number"
        }
      ]
    }
  },

  "ExportDeliveryNoteAll": {
    "WidthColumn": [
      3.29,
      12.14,
      60,
      35,
      10.43,
      12,
      8.57,
      15,
      40,
      11.71,
      8.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Left Qty = to be fill by user in order to update stock when PN is taken out"
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        "Stock Qty = current stock before PN is taken out"
      ],
      [
        "List filter :",
        "",
        "Stock view with all PNs prepared and sent to MFR",
        "Returned = True : PNs have already been reintegrated into the stock after MFR return"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteStockOnly": {
    "WidthColumn": [
      2.43,
      12.14,
      60,
      35,
      10.43,
      12,
      8.57,
      40,
      11.71
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Left Qty = Left Qty in stock after PN is taken out : To be fill by user"
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        "Stock Qty = current stock before PN is taken out"
      ],
      [
        "List filter :",
        "",
        "Stock view only, no prep. PNs nor sent PNs to MFR",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteSentOnly": {
    "WidthColumn": [
      3.29,
      12.14,
      60,
      35,
      10.43,
      12,
      15,
      8.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        ""
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        ""
      ],
      [
        "List filter :",
        "",
        "Sent view for all DNs of the order $MFGOrder",
        "Returned = True : PNs have already been reintegrated into the stock after MFR return"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteInPrep": {
    "WidthColumn": [
      3.29,
      11.57,
      60,
      35,
      10.43,
      12,
      15
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        ""
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        ""
      ],
      [
        "List filter :",
        "",
        "Prepared PNs for the order N°$MFGOrder",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteSuppliedByMfr": {
    "WidthColumn": [
      3.29,
      12.14,
      60,
      35,
      10.43,
      12,
      15
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        ""
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        ""
      ],
      [
        "List filter :",
        "",
        "Supplied PNs by MFR view for the order $MFGOrder",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteRemaining": {
    "WidthColumn": [
      10.43,
      11.57,
      60,
      35,
      8.57,
      15,
      23.29
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Negative Remaining Qty = Potential parts to be returned from MFR after prod."
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        "In prep/Sent Qty = sum of all prepared & sent Qty for the order $MFGOrder"
      ],
      [
        "List filter :",
        "",
        "Remaining PNs to prepare to complete the order $MFGOrder",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteSynthesis": {
    "WidthColumn": [
      10.43,
      12.14,
      60,
      35,
      8.57,
      15,
      23.29
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty = current stock Qty (all locations sums) before PN is taken out"
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        "In prep/Sent Qty = sum of all prepared & sent Qty for the order $MFGOrder"
      ],
      [
        "List filter :",
        "",
        "Synthesis view of the order $MFGOrder",
        "Negative remaining stock Qty = Potential parts to be returned from MFR after prod."
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteToReturn": {
    "WidthColumn": [
      10.43,
      12,
      60,
      35,
      8.57,
      10,
      20.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty = current stock Qty (all locations sums)"
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        ""
      ],
      [
        "List filter :",
        "",
        "Potential PNs to return from MFR for this order (all DNs)",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportDeliveryNoteReturned": {
    "WidthColumn": [
      3.29,
      12.14,
      60,
      35,
      10.43,
      12,
      12.14
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        ""
      ],
      [
        "Order N° :",
        "",
        "$MFGOrder",
        ""
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        ""
      ],
      [
        "MFG Name/Type :",
        "",
        "$MFGName / $AssemblyType",
        ""
      ],
      [
        "List filter :",
        "",
        "PNs returned from MFR for this order (all DNs)",
        ""
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },

  "SqlListStockPNCheckBox": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "Stock",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 120
            },
            {
              "Field": "Stock",
              "Index": 1,
              "Width": 60
            },
            {
              "Field": "Cabinet/Shelf",
              "Index": 2,
              "Width": 120
            },
            {
              "Field": "Drawer",
              "Index": 3,
              "Width": 100
            },
            {
              "Field": "Box",
              "Index": 4,
              "Width": 100
            },			
			{
              "Field": "On Order",
              "Index": 6,
              "Width": 50
            },           
			{
              "Field": "Reserved",
              "Index": 7,
              "Width": 50
            },
			{
              "Field": "Remark",
              "Index": 8,
              "Width": 220
            },
			{
              "Field": "Planned use",
              "Index": 9,
              "Width": 50
            },			
            {
              "Field": "ID",
              "Index": 10,
              "Width": -1
            }
          ]
        },
        {
          "TableName": "Conditioning",
          "Columns": [
            {
              "Field": "Conditioning",
              "Index": 5,
              "Width": 100
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "Stock",
          "Field1": "Conditioning",
          "TableName2": "Conditioning",
          "Field2": "ID"
        }
      ],
      "Conditions": [
        {
          "Table": "Stock",
          "Restriction": "Part Number=$CurrentPN"
        }
      ]
    }
  },
  "SqlListPotReturnPNCheckBox": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "BOMorder",
          "Columns": [
            {
              "Field": "PN",
              "Index": 0,
              "Width": 120,
              "Alias": "Part Number"
            },
            {
              "Field": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty",
              "Index": 1,
              "Width": 100,
              "Alias": "Potential return Qty"
            }
          ]
        },
        {
          "TableName": "BL",
          "Columns": [
            {
              "Field": "MFG Order",
              "Index": 2,
              "Width": 100
            }
          ]
        },
        {
          "TableName": "MFGorder",
          "Columns": [
            {
              "Field": "PCBA",
              "Index": 3,
              "Width": 200
            },
            {
              "Field": "Boards Qty",
              "Index": 4,
              "Width": 300
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "BOMorder",
          "Field1": "DN N°",
          "TableName2": "BL",
          "Field2": "DN N°"
        },
        {
          "TableName1": "BL",
          "Field1": "MFG Order",
          "TableName2": "MFGorder",
          "Field2": "MFG Order"
        }
      ],
      "Conditions": [
        {
          "Table": "BOMorder",
          "Restriction": "PN=$CurrentPN"
        },
        {
          "Table": "BOMorder",
          "Restriction": "Returned=0"
        },
        {
          "Table": "BL",
          "Restriction": "Sent=1"
        },
        {
          "Table": "",
          "Restriction": "BOMorder.Delivered Qty(minus)BOMorder.Unitary Qty(multiply)MFGorder.Boards Qty=>0"
        }
      ]
    }
  },
  
  "ExportPCBAStockDetails": {
    "WidthColumn": [
      3.29,
      30,
      60,
      50,
      10.43,
      12,
      9.29,
      18.57,
      11.71,
	  9.29,
	  9.29,
      60
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        "Stock Qty for prepared PNs = Potential Qty in prep."
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty for Sent PNs = Potentially Qty returned by MFR"
      ],
      [
        "List filter :",
        "",
        "Stock view only, no prep. nor potential PNs from MFR shown",
        "Negative remaining stock Qty = Missing parts for manufacturing"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
	  [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportPCBAStockSum": {
    "WidthColumn": [
      3.29,
      30,
      60,
      50,
      9.29,
      31.29
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        "Stock Qty for prepared PNs = Potential Qty in prep."
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty for Sent PNs = Potentially Qty returned by MFR"
      ],
      [
        "List filter :",
        "",
        "Stock synthesis (sum) only, no prep. nor potential PNs from MFR",
        "Negative remaining stock Qty = Missing parts for manufacturing"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportPCBAStockInPrep": {
    "WidthColumn": [
      3.29,
      30,
      60,
      50,
      10.43,
      12,
      8.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        "Stock Qty for prepared PNs = Potential Qty in prep."
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty for Sent PNs = Potentially Qty returned by MFR"
      ],
      [
        "List filter :",
        "",
        "In preparation PNs",
        "Negative remaining stock Qty = Missing parts for manufacturing"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportPCBAStockPotRet": {
    "WidthColumn": [
      3.29,
      30,
      60,
      50,
      10.43,
      12,
      8.57
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        "Stock Qty for prepared PNs = Potential Qty in prep."
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty for Sent PNs = Potentially Qty returned by MFR"
      ],
      [
        "List filter :",
        "",
        "Potential PNs from MFR",
        "Negative remaining stock Qty = Missing parts for manufacturing"
      ],
      [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },
  "ExportPCBAStockAll": {
    "WidthColumn": [
      3.29,
      30,
      60,
      50,
      10.43,
      12,
      9.29,
      18.57,
      11.71,
	  9.29,
	  9.29,
      60
    ],
    "TitleText": [
      [
        "PCBA Name :",
        "",
        "$CurrentPCB",
        ""
      ],
      [
        "Description :",
        "",
        "$PCBDesc",
        "Stock Qty for prepared PNs = Potential Qty in prep."
      ],
      [
        "PCBA Quantity :",
        "",
        "$PCBQuantity",
        "Stock Qty for Sent PNs = Potentially Qty returned by MFR"
      ],
      [
        "List filter :",
        "",
        "Stock view with prep. and potential PNs from MFR shown",
        "Negative remaining stock Qty = Missing parts for manufacturing"
      ],
	  [
        "User filter :",
        "",
        "$UserFilter",
        ""
      ],
      [
        "",
        "",
        "",
        ""
      ]
    ],
    "StyleTitle": [
      {
        "ColumnIndex": 0,
        "Style": {
          "Bold": true,
          "UnderlineTextColor": 'Transparent'
        }
      },
      {
        "ColumnIndex": 3,
        "Style": {
          "Italic": true,
          "UnderlineTextColor": 'Transparent'
        }
      }
    ],
    "StyleHeader": {
      "Bold": true,
      "TextColor": 'White',
      "UnderlineTextColor": "180,0,235"
    },
    "StyleHeaderTable": {
      "Bold": false,
      "UnderlineTextColor": 'Transparent'
    },
    "LeftHeaderPDF": "STOCK VIEW on &D &T",
    "RightHeaderPDF": "PCBA:$CurrentPCB",
    "RightFooterPDF": "&P/&N",
    "LeftFooterPDF": "University of Geneva / DPNC - 24, quai Ernest Ansermet - CH1211 GENEVE - SWITZERLAND"
  },

  "InsertBOMReference": {
    "Filter": {
      "NbTextBox": 15,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 10,
      "HorizontalPaddingLeft": 10,
      "WidthColumn": [
        480
      ]
    },
    "TextBox": [
      {
        "TableName": "BOM",
        "Field": "BOM ID",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "Part Reference",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "PCB",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "Item Number",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "Part Number",
        "Type": "SmartTextBox",
        "Description": "PN :",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "Value",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true],
        "ReadOnly": true
      },
      {
        "TableName": "BOM",
        "Field": "Short Description",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Quantity",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "PCB Footprint",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "ALT_SYMBOLS",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "SC_PN",
        "Type": "SmartTextBox",
        "Description": "SC PN replace",
        "Enabled": [false]
      },
      {
        "TableName": "BOM",
        "Field": "NoExport",
        "Type": "SmartCheckBox",
        "Description": "No Export",
        "Enabled": [true]
      },
      {
        "TableName": "BOM",
        "Field": "Modified",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [true],
        "ReadOnly": true
      },
      {
        "TableName": "BOM",
        "Field": "Added",
        "Type": "SmartCheckBox",
        "Description": "",
        "Enabled": [false]
      }
    ]
  },

  "InsertMPN": {
    "Filter": {
      "NbTextBox": 13,
      "NbColumn": 1,
      "VerticalSpace": 0,
      "HorizontalSpace": 0,
      "HorizontalPaddingLeft": 0,
      "WidthColumn": [
        530
      ]
    },
    "TextBox": [
      {
        "TableName": "MfrPartNumber",
        "Field": "ID",
        "Type": "SmartTextBox",
        "Description": "",
        "DefaultValue": "Auto ID",
        "Enabled": [false]
      },
      {
        "TableName": "MfrName",
        "Field": "Manufacturer Name",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Manufacturer Name",
        "DefaultValue": "A DETERMINER"
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Mfr Item No",
        "Type": "SmartTextBox",
        "Description": "Mfr Item No :*",
        "Enabled": [true]
      },
      {
        "TableName": "PurchasingStatus",
        "Field": "Purchasing Status",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Purchasing Status",
        "DefaultValue": "Available for purchase",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "QualityStatusL1",
        "Field": "Quality Status Level 1",
        "Type": "SmartList",
        "Description": "Quality Status (1st level) :",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Quality Status (1st Level)",
        "DefaultValue": "Approved without restriction",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "QualityStatusL2",
        "Field": "Quality Status Level 2",
        "Type": "SmartList",
        "Description": "Quality Status (2nd level) :",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Quality Status (2nd Level)",
        "DefaultValue": ""
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Quality Status Note",
        "Type": "SmartTextBox",
        "Description": "",
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "Comment",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "PDF",
        "Type": "SmartTextBox",
        "Description": "PDF1 :",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "PDF2",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "MfrPartNumber",
        "Field": "PDF3",
        "Type": "SmartTextBox",
        "Description": "",
		"GhostCharAllowed": true,
        "Enabled": [true]
      },
      {
        "TableName": "MfrRoHSCompliant",
        "Field": "Mfr RoHS compliant",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Mfr RoHS Compliant",
        "DefaultValue": "Yes",
		"AutoGetColorEnabled": true
      },
      {
        "TableName": "MfrLeadFreeProcComp",
        "Field": "Mfr lead free process compatible",
        "Type": "SmartList",
        "Description": "",
        "Enabled": [true],
        "TableNameDest": "MfrPartNumber",
        "FieldDest": "Mfr Lead Free Process Compatible",
        "DefaultValue": "Yes",
		"AutoGetColorEnabled": true
      }
    ]
  },

  "SqlListMPNDetails": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "MfrPartNumber",
          "Columns": [
            {
              "Field": "ID",
              "Index": 0,
              "Width": 80
            }
          ]
        },
        {
          "TableName": "PartNumberAssembly"
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 1,
              "Width": 150
            },
            {
              "Field": "Short Description",
              "Index": 2,
              "Width": 300
            },
            {
              "Field": "Part Type",
              "Index": 3,
              "Width": 200
            },
            {
              "Field": "Case",
              "Index": 4,
              "Width": 200
            }
          ]
        }
      ],
      "Associations": [
        {
          "TableName1": "MfrPartNumber",
          "Field1": "ID",
          "TableName2": "PartNumberAssembly",
          "Field2": "Mfr Part Number ID"
        },
        {
          "TableName1": "PartNumberAssembly",
          "Field1": "Part Number",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }
      ],
      "Conditions": [
        {
          "Table": "MfrPartNumber",
          "Restriction": "ID=$CurrentMFGID"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Associated PNs: "
    }
  },
  
  "SqlListMatesDetails": {
    "SqlList": {
      "Tables": [
		{
          "TableName": "MatesWith",
		  "Columns": [
		    {
              "Field": "PartNumber2",
			  "Alias": "Part Number",
              "Index": 0,
              "Width": 140
            },
		    {
              "Field": "ID",
              "Index": 8,
              "Width": 30
            }
		  ]
        },
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 260
            },
            {
              "Field": "Part Type",
              "Index": 2,
              "Width": 140
            },
            {
              "Field": "Case",
              "Index": 3,
              "Width": 140
            },
			{
              "Field": "Value",
              "Index": 4,
              "Width": 100
            },
            {
              "Field": "Tolerance",
              "Index": 5,
              "Width": 100
            },
			{
              "Field": "Rating",
              "Index": 6,
              "Width": 100
            },
			{
              "Field": "PCB_Footprint",
              "Index": 7,
              "Width": 140
            }
          ]
        }
      ],
	  "Associations": [
        {
          "TableName1": "MatesWith",
          "Field1": "PartNumber2",
          "TableName2": "PartNumber",
          "Field2": "Part Number"
        }],  
      "Conditions": [
        {
          "Table": "MatesWith",
          "Restriction": "PartNumber1=$CurrentPN"
        }
	  ],
	  
	  "UnionList": {
        "Tables": [
	  	{
          "TableName": "MatesWith",
	  	  "Columns": [
	  	    {
                "Field": "PartNumber1",
	  		    "Alias": "Part Number",
                "Index": 0,
                "Width": 140
            },
	  	    {
                "Field": "ID",
                "Index": 8,
                "Width": 30
            }
	  	  ]
        },
	    {
	  	  "TableName": "PartNumber",
	  	  "Columns": [
	  	    {
	  	  	  "Field": "Short Description",
	  	  	  "Index": 1,
	  	  	  "Width": 260
	  	    },
	  	    {
	  	  	  "Field": "Part Type",
	  	  	  "Index": 2,
	  	  	  "Width": 140
	  	    },
	  	    {
	  	  	  "Field": "Case",
	  	  	  "Index": 3,
	  	  	  "Width": 140
	  	    },
	  	    {
	  	  	  "Field": "Value",
	  	  	  "Index": 4,
	  	  	  "Width": 100
	  	    },
	  	    {
	  	  	  "Field": "Tolerance",
	  	  	  "Index": 5,
	  	  	  "Width": 100
	  	    },
	  	    {
	  	  	  "Field": "Rating",
	  	  	  "Index": 6,
	  	  	  "Width": 100
	  	    },
	  	    {
	  	  	"Field": "PCB_Footprint",
	  	  	"Index": 7,
	  	  	"Width": 140
	  	    }
	  	  ]
	    } 
        ],
	    "Associations": [
          {
            "TableName1": "MatesWith",
            "Field1": "PartNumber1",
            "TableName2": "PartNumber",
            "Field2": "Part Number"
          }],  
        "Conditions": [
          {
            "Table": "MatesWith",
            "Restriction": "PartNumber2=$CurrentPN"
          }
	    ]
      }
	},  
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Mating PNs: "
    }
  },

  "SqlListSearchCaseInPN": {
    "SqlList": {
      "Tables": [
        {
          "TableName": "PartNumber",
          "Columns": [
            {
              "Field": "Part Number",
              "Index": 0,
              "Width": 140
            },
            {
              "Field": "Short Description",
              "Index": 1,
              "Width": 260
            },
            {
              "Field": "Part Type",
              "Index": 2,
              "Width": 190
            },
            {
              "Field": "Schematic part",
              "Index": 3,
              "Width": 260
            },
            {
              "Field": "Case",
              "Index": 4,
              "Width": 190
            }
          ]
        }
      ],
      "Conditions": [
        {
          "Table": "PartNumber",
          "Restriction": "Case=$CurrentCase"
        }
      ]
    },
    "SmartSqlList": {
      "HeaderHeight": 20,
      "SpaceBetweenLabel": 0,
      "TextToDisplay": "Associated PNs: "
    }
  }

}