{
"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"
}