Cacher is the code snippet organizer for pro developers

{
  "DBName": "*Public/DG Net Local",
  "Library": "Examples",
  "File": "CMastNewL1",
  "Format": "RCMMastL1",
  "Description": "Cust Master by CustNo",
  "Type": "Simple logical",
  "RecordLength": "151",
  "KeyLength": "5",
  "BaseFile": "Examples/CMastNew",
  "DuplicateKeys": "none",
  "SqlServerUniqueIndex": "UNIQUE",
  "Fields": [
    {
      "Name": "CMCustNo",
      "Type": "Packed",
      "SystemType": "System.Decimal",
      "SqlServerType": "SqlDBType.decimal",
      "SqlServerTypeWithLength": "decimal(9, 0)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": true,
      "SqlServerPrimaryKey": "PRIMARY KEY",
      "FullType": "Type(*Packed) Len(9,0)",
      "LengthDecimals": "9,0",
      "Length": "    9",
      "Decimals": "  0",
      "KeyPosition": 0,
      "Description": "Cutomer Number",
      "Alias": "CMCustNo"
    },
    {
      "Name": "CMName",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(40)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(40)",
      "LengthDecimals": "40",
      "Length": "   40",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Customer Name",
      "Alias": "CMName"
    },
    {
      "Name": "CMAddr1",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(35)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(35)",
      "LengthDecimals": "35",
      "Length": "   35",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Address Line 1",
      "Alias": "CMAddr1"
    },
    {
      "Name": "CMCity",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(30)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(30)",
      "LengthDecimals": "30",
      "Length": "   30",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "City",
      "Alias": "CMCity"
    },
    {
      "Name": "CMState",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(2)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(2)",
      "LengthDecimals": "2",
      "Length": "    2",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "State",
      "Alias": "CMState"
    },
    {
      "Name": "CMCntry",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(2)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(2)",
      "LengthDecimals": "2",
      "Length": "    2",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Country Code",
      "Alias": "CMCntry"
    },
    {
      "Name": "CMPostCode",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(10)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(10)",
      "LengthDecimals": "10",
      "Length": "   10",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Postal Code (zip)",
      "Alias": "CMPostCode"
    },
    {
      "Name": "CMActive",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(1)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(1)",
      "LengthDecimals": "1",
      "Length": "    1",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Active = 1, else 0",
      "Alias": "CMActive"
    },
    {
      "Name": "CMFax",
      "Type": "Packed",
      "SystemType": "System.Decimal",
      "SqlServerType": "SqlDBType.bigint",
      "SqlServerTypeWithLength": "bigint(10, 0)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Packed) Len(10,0)",
      "LengthDecimals": "10,0",
      "Length": "   10",
      "Decimals": "  0",
      "KeyPosition": -1,
      "Description": "Fax Number",
      "Alias": "CMFax"
    },
    {
      "Name": "CMPhone",
      "Type": "Char",
      "SystemType": "System.String",
      "SqlServerType": "SqlDBType.nchar",
      "SqlServerTypeWithLength": "nchar(20)",
      "SqlServerNull": "NOT NULL",
      "AllowNull": false,
      "IsKey": false,
      "SqlServerPrimaryKey": "",
      "FullType": "Type(*Char) Len(20)",
      "LengthDecimals": "20",
      "Length": "   20",
      "Decimals": "   ",
      "KeyPosition": -1,
      "Description": "Main Phone",
      "Alias": "CMPhone"
    }
  ],
  "Alias": null,
  "AllFieldsWithPrefix": "_CMCustNo, _CMName, _CMAddr1, _CMCity, _CMState, _CMCntry, _CMPostCode, _CMActive, _CMFax, _CMPhone",
  "KeyFieldsWithPrefix": "_CMCustNo",
  "AllFieldsAliasWithPrefix": "_CMCustNo, _CMName, _CMAddr1, _CMCity, _CMState, _CMCntry, _CMPostCode, _CMActive, _CMFax, _CMPhone",
  "KeyFieldsWithAliasPrefix": "_CMCustNo"
}