Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
New-DbaDbMaskingConfig output
{
"Name": "AdventureWorks2014",
"Tables": [
{
"Name": "AWBuildVersion",
"Schema": "dbo",
"Columns": [
{
"Name": "Database Version",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 25,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "VersionDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "DatabaseLog",
"Schema": "dbo",
"Columns": [
{
"Name": "PostTime",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "DatabaseUser",
"ColumnType": "sysname",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Event",
"ColumnType": "sysname",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Schema",
"ColumnType": "sysname",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Object",
"ColumnType": "sysname",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "TSQL",
"ColumnType": "nvarcharmax",
"CharacterString": null,
"MinValue": null,
"MaxValue": -1,
"MaskingType": "Random",
"SubType": "String"
}
]
},
{
"Name": "ErrorLog",
"Schema": "dbo",
"Columns": [
{
"Name": "ErrorTime",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "UserName",
"ColumnType": "sysname",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ErrorNumber",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ErrorSeverity",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ErrorState",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ErrorProcedure",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 126,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ErrorLine",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ErrorMessage",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 4000,
"MaskingType": "Random",
"SubType": "String"
}
]
},
{
"Name": "Department",
"Schema": "HumanResources",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "GroupName",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Employee",
"Schema": "HumanResources",
"Columns": [
{
"Name": "NationalIDNumber",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 15,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LoginID",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 256,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "JobTitle",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "BirthDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "MaritalStatus",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Gender",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "HireDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "SalariedFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "VacationHours",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "SickLeaveHours",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "CurrentFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "EmployeeDepartmentHistory",
"Schema": "HumanResources",
"Columns": [
{
"Name": "StartDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EndDate",
"ColumnType": "date",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "EmployeePayHistory",
"Schema": "HumanResources",
"Columns": [
{
"Name": "RateChangeDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "Rate",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "PayFrequency",
"ColumnType": "tinyint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 255,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "JobCandidate",
"Schema": "HumanResources",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Shift",
"Schema": "HumanResources",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "StartTime",
"ColumnType": "time",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "EndTime",
"ColumnType": "time",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Address",
"Schema": "Person",
"Columns": [
{
"Name": "AddressLine1",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 60,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "AddressLine2",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 60,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "City",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 30,
"MaskingType": "Address",
"SubType": "City"
},
{
"Name": "PostalCode",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 15,
"MaskingType": "Address",
"SubType": "Zipcode"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "AddressType",
"Schema": "Person",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "BusinessEntity",
"Schema": "Person",
"Columns": [
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "BusinessEntityAddress",
"Schema": "Person",
"Columns": [
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "BusinessEntityContact",
"Schema": "Person",
"Columns": [
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ContactType",
"Schema": "Person",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "CountryRegion",
"Schema": "Person",
"Columns": [
{
"Name": "CountryRegionCode",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 3,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "EmailAddress",
"Schema": "Person",
"Columns": [
{
"Name": "EmailAddress",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Password",
"Schema": "Person",
"Columns": [
{
"Name": "PasswordHash",
"ColumnType": "varchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 128,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "PasswordSalt",
"ColumnType": "varchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 10,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Person",
"Schema": "Person",
"Columns": [
{
"Name": "PersonType",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "NameStyle",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "Title",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "FirstName",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Name",
"SubType": "Firstname"
},
{
"Name": "MiddleName",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LastName",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Name",
"SubType": "Lastname"
},
{
"Name": "Suffix",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 10,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "EmailPromotion",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "PersonPhone",
"Schema": "Person",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "PhoneNumberType",
"Schema": "Person",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "StateProvince",
"Schema": "Person",
"Columns": [
{
"Name": "StateProvinceCode",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 3,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "IsOnlyStateProvinceFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "BillOfMaterials",
"Schema": "Production",
"Columns": [
{
"Name": "StartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "BOMLevel",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "PerAssemblyQty",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Culture",
"Schema": "Production",
"Columns": [
{
"Name": "CultureID",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 6,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Document",
"Schema": "Production",
"Columns": [
{
"Name": "Title",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "FolderFlag",
"ColumnType": "bit",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "FileName",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 400,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "FileExtension",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Revision",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ChangeNumber",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "Status",
"ColumnType": "tinyint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 255,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "DocumentSummary",
"ColumnType": "nvarcharmax",
"CharacterString": null,
"MinValue": null,
"MaxValue": -1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Document",
"ColumnType": "varbinarymax",
"CharacterString": null,
"MinValue": null,
"MaxValue": -1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Illustration",
"Schema": "Production",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Location",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "CostRate",
"ColumnType": "smallmoney",
"CharacterString": null,
"MinValue": null,
"MaxValue": 4,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Availability",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "Product",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ProductNumber",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 25,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "MakeFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "FinishedGoodsFlag",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "Color",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 15,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "SafetyStockLevel",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ReorderPoint",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "StandardCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ListPrice",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Size",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Weight",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "DaysToManufacture",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ProductLine",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Class",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Style",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "SellStartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "SellEndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "DiscontinuedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductCategory",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductCostHistory",
"Schema": "Production",
"Columns": [
{
"Name": "StartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "StandardCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductDescription",
"Schema": "Production",
"Columns": [
{
"Name": "Description",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 400,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductDocument",
"Schema": "Production",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductInventory",
"Schema": "Production",
"Columns": [
{
"Name": "Shelf",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 10,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Bin",
"ColumnType": "tinyint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 255,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "Quantity",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductListPriceHistory",
"Schema": "Production",
"Columns": [
{
"Name": "StartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ListPrice",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductModel",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductModelIllustration",
"Schema": "Production",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductModelProductDescriptionCulture",
"Schema": "Production",
"Columns": [
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductPhoto",
"Schema": "Production",
"Columns": [
{
"Name": "ThumbNailPhoto",
"ColumnType": "varbinarymax",
"CharacterString": null,
"MinValue": null,
"MaxValue": -1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ThumbnailPhotoFileName",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LargePhoto",
"ColumnType": "varbinarymax",
"CharacterString": null,
"MinValue": null,
"MaxValue": -1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LargePhotoFileName",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductProductPhoto",
"Schema": "Production",
"Columns": [
{
"Name": "Primary",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "Bool"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductReview",
"Schema": "Production",
"Columns": [
{
"Name": "ReviewerName",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ReviewDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EmailAddress",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Rating",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "Comments",
"ColumnType": "nvarchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 3850,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductSubcategory",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "rowguid",
"ColumnType": "uniqueidentifier",
"CharacterString": null,
"MinValue": null,
"MaxValue": 16,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ScrapReason",
"Schema": "Production",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "TransactionHistory",
"Schema": "Production",
"Columns": [
{
"Name": "ReferenceOrderID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ReferenceOrderLineID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "TransactionDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "TransactionType",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Quantity",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ActualCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "TransactionHistoryArchive",
"Schema": "Production",
"Columns": [
{
"Name": "TransactionID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ProductID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ReferenceOrderID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ReferenceOrderLineID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "TransactionDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "TransactionType",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": null,
"MaxValue": 1,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Quantity",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ActualCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "UnitMeasure",
"Schema": "Production",
"Columns": [
{
"Name": "UnitMeasureCode",
"ColumnType": "nchar",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 3,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,
"MinValue": null,
"MaxValue": 50,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "WorkOrder",
"Schema": "Production",
"Columns": [
{
"Name": "OrderQty",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ScrappedQty",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "StartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "EndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "DueDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "WorkOrderRouting",
"Schema": "Production",
"Columns": [
{
"Name": "ProductID",
"ColumnType": "int",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "OperationSequence",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": 2,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ScheduledStartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ScheduledEndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ActualStartDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ActualEndDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ActualResourceHrs",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "PlannedCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ActualCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ProductVendor",
"Schema": "Purchasing",
"Columns": [
{
"Name": "AverageLeadTime",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "StandardPrice",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LastReceiptCost",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "LastReceiptDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "MinOrderQty",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "MaxOrderQty",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "OnOrderQty",
"ColumnType": "int",
"CharacterString": null,
"MinValue": null,
"MaxValue": 2147483647,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "PurchaseOrderDetail",
"Schema": "Purchasing",
"Columns": [
{
"Name": "DueDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "OrderQty",
"ColumnType": "smallint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 32767,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "UnitPrice",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ReceivedQty",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "RejectedQty",
"ColumnType": "decimal",
"CharacterString": null,
"MinValue": null,
"MaxValue": 5,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "PurchaseOrderHeader",
"Schema": "Purchasing",
"Columns": [
{
"Name": "RevisionNumber",
"ColumnType": "tinyint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 255,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "Status",
"ColumnType": "tinyint",
"CharacterString": null,
"MinValue": null,
"MaxValue": 255,
"MaskingType": "Random",
"SubType": "Number"
},
{
"Name": "OrderDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "ShipDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
},
{
"Name": "SubTotal",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "TaxAmt",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "Freight",
"ColumnType": "money",
"CharacterString": null,
"MinValue": null,
"MaxValue": 8,
"MaskingType": "Random",
"SubType": "String"
},
{
"Name": "ModifiedDate",
"ColumnType": "datetime",
"CharacterString": null,
"MinValue": null,
"MaxValue": null,
"MaskingType": "Random",
"SubType": "Date"
}
]
},
{
"Name": "ShipMethod",
"Schema": "Purchasing",
"Columns": [
{
"Name": "Name",
"ColumnType": "userdefineddatatype",
"CharacterString": null,