Precision and Scale not handled yet

[programmergrammar]

On one of my databases, I get the error "Precision and Scale not handled yet". I don't see how this is possible since the line that generates this error seems to be looking for the data type "numberic" https://github.com/sethreno/schemazen/blob/master/Library/Models/UserDefinedType.cs#L89. It seems like numberic is just a misspelling of numeric. I'm using SchemaZen v2. Any ideas on how to fix the issue would be appreciated.

[programmergrammar]

I see now that my problem was with the 'decimal' type for a user defined type.

[sethreno]

@programmergrammar Hi there, will you post a create script the object so it's easy to reproduce?

[programmergrammar]

--FeeVolume_UDT

USE [PDS]
GO

/****** Object:  UserDefinedDataType [dbo].[FeeVolume_UDT]    Script Date: 6/5/2023 12:08:28 PM ******/
CREATE TYPE [dbo].[FeeVolume_UDT] FROM [decimal](12, 6) NULL
GO


USE [PDS]
GO


--Table using the FeeVolume_UDT type
/****** Object:  Table [dbo].[SPBPmts]    Script Date: 6/5/2023 12:09:55 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SPBPmts](
	[PmtNbr] [dbo].[PmtNbr_UDT] NOT NULL,
	[PmtAFIN] [dbo].[AFIN_UDT] NOT NULL,
	[PmtCounty] [dbo].[County_UDT] NOT NULL,
	[PmtIssueDate] [datetime] NULL,
	[PmtModDate] [datetime] NULL,
	[PmtExpirationDate] [datetime] NULL,
	[PmtVoidDate] [datetime] NULL,
	[PmtMedia] [dbo].[MediaCode_UDT] NOT NULL,
	[PmtType] [dbo].[Code4_UDT] NOT NULL,
	[PmtStaff] [dbo].[Init_UDT] NOT NULL,
	[PmtStatus] [char](2) NOT NULL,
	[PmtStatusDate] [datetime] NULL,
	[InitPmtFeeInvNbr] [dbo].[InvoiceNum_UDT] NOT NULL,
	[FeeCode] [dbo].[Code4_UDT] NOT NULL,
	[FeeVolume] FeeVolume_UDT(decimal(12,6), null),
	[InvComment] [varchar](75) NOT NULL,
	[InvCommentPrtYN] [dbo].[YN_UDT] NOT NULL,
	[InvSinglePmtYN] [dbo].[YN_UDT] NOT NULL,
	[InvSinglePmtLblYN] [dbo].[YN_UDT] NOT NULL,
	[PmtContactName] [dbo].[Name_UDT] NOT NULL,
	[PmtContactPhone] [dbo].[PhoneNbr_UDT] NOT NULL,
	[PmtFaxNbr] [dbo].[PhoneNbr_UDT] NOT NULL,
	[PmtEmail] [varchar](75) NOT NULL,
	[PmtMailAddr1] [dbo].[Addr_UDT] NOT NULL,
	[PmtMailAddr2] [dbo].[Addr_UDT] NOT NULL,
	[PmtMailAddr3] [dbo].[Addr_UDT] NOT NULL,
	[PmtMailCity] [dbo].[City_UDT] NOT NULL,
	[PmtMailState] [dbo].[State_UDT] NOT NULL,
	[PmtMailZip] [dbo].[Zip_UDT] NOT NULL,
	[PmtMailCountry] [dbo].[Country_UDT] NOT NULL,
	[OperatorID] [dbo].[Code4_UDT] NOT NULL,
	[PmtPrimarySICCode] [dbo].[SICCode_UDT] NOT NULL,
	[PmtSecondarySICCode] [dbo].[SICCode_UDT] NOT NULL,
	[PmtTertiarySICCode] [dbo].[SICCode_UDT] NOT NULL,
	[PmtPrimaryNAICSCode] [dbo].[NAICSCode_UDT] NOT NULL,
	[PmtSecondaryNAICSCode] [dbo].[NAICSCode_UDT] NOT NULL,
	[PmtTertiaryNAICSCode] [dbo].[NAICSCode_UDT] NOT NULL,
	[PriorPmtNbr] [dbo].[PmtNbr_UDT] NOT NULL,
	[PmtOtherIdentifier] [dbo].[OtherIdentifier_UDT] NOT NULL,
	[PmtComment] [varchar](300) NOT NULL,
	[PmtHistory] [varchar](1200) NOT NULL,
	[StreamSegment] [char](2) NOT NULL,
	[NearestStream] [dbo].[StreamName_UDT] NOT NULL,
	[BrineSystem] [varchar](30) NOT NULL,
	[BrineField] [varchar](20) NOT NULL,
	[BrineVolumeBSWPD] [int] NULL,
	[BrinePressurePSIG] [int] NULL,
	[BrineStorageBBL] [int] NULL,
	[BrineSystemWellsQty] [int] NULL,
	[BrineInjectionWells] [int] NULL,
	[BrineCutoffSwYN] [dbo].[YN_UDT] NULL,
	[FacSizeComment] [varchar](300) NOT NULL,
	[SPBNbrPoultryBroilers] [int] NULL,
	[SPBNbrPoultryLayers] [int] NULL,
	[SPBNbrPoultryHatchery] [int] NULL,
	[SPBNbrTurkeys] [int] NULL,
	[SPBNbrKennels] [int] NULL,
	[SPBNbrSwineOver55lbs] [int] NULL,
	[SPBNbrSwineUnder55lbs] [int] NULL,
	[SPBNbrMatureDairyCows] [int] NULL,
	[SPBNbrDairyHeifers] [int] NULL,
	[SPBNbrVealCalves] [int] NULL,
	[SPBNbrCattle] [int] NULL,
	[SPBNbrHorses] [int] NULL,
	[SPBNbrSheepOrLambs] [int] NULL,
	[SPBNbrDucks] [int] NULL,
	[SPBNbrOther] [int] NULL,
	[SPBNbrOtherSpecifyName] [varchar](75) NOT NULL,
	[PmtGISOriginalCoordinateSystem] [varchar](10) NOT NULL,
	[PmtGISOriginalDatumCode] [dbo].[GISDatumCode_UDT] NOT NULL,
	[PmtGISCurrentDatumCode] [dbo].[GISDatumCode_UDT] NOT NULL,
	[PmtLatDegrees] [dbo].[LLDegrees_UDT] NULL,
	[PmtLatMinutes] [dbo].[LLMinutes_UDT] NULL,
	[PmtLatSeconds] [decimal](4, 2) NULL,
	[PmtLongDegrees] [dbo].[LLDegrees_UDT] NULL,
	[PmtLongMinutes] [dbo].[LLMinutes_UDT] NULL,
	[PmtLongSeconds] [decimal](4, 2) NULL,
	[PmtLatDecimal] [decimal](9, 6) NULL,
	[PmtLongDecimal] [decimal](9, 6) NULL,
	[PmtUTMNorthing] [decimal](9, 2) NULL,
	[PmtUTMEasting] [decimal](8, 2) NULL,
	[PmtUTMZone] [dbo].[UTMZone_UDT] NOT NULL,
	[PmtSectionTownshipRange] [varchar](150) NOT NULL,
	[PmtGISDateMeasured] [datetime] NULL,
	[PmtGISSourceName] [varchar](50) NOT NULL,
	[PmtGISCollectorStaffCode] [varchar](6) NOT NULL,
	[PmtGISCertifiedMeasurementYN] [dbo].[YN_UDT] NOT NULL,
	[PmtGPSReceiverTypeName] [varchar](50) NOT NULL,
	[PmtGPSReceiverChannels] [int] NULL,
	[PmtGISBaseStationName] [varchar](50) NOT NULL,
	[PmtGISBaseStationDistance] [int] NULL,
	[PmtGISMinPointPositions] [int] NULL,
	[PmtGISPDOPMask] [decimal](4, 1) NULL,
	[PmtGISSNRMask] [int] NULL,
	[PmtGISHorizAccuracy] [varchar](50) NOT NULL,
	[PmtGISComment] [varchar](150) NOT NULL,
	[PmtGISHUC] [dbo].[GISHUC] NOT NULL,
	[PmtGISPlanningSegment] [dbo].[GISPlanningSegment] NOT NULL,
	[PmtGISArkSenDist] [dbo].[GISArkSenDist] NOT NULL,
	[PmtGISArkRepDist] [dbo].[GISArkRepDist] NOT NULL,
	[RecCreatedBy] [dbo].[UserID_UDT] NOT NULL,
	[RecCreatedDate] [datetime] NULL,
	[RecModifiedBy] [dbo].[UserID_UDT] NOT NULL,
	[RecModifiedDate] [datetime] NULL,
 CONSTRAINT [PK_SPBPmts] PRIMARY KEY CLUSTERED 
(
	[PmtNbr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__Operato__251FAF49]  DEFAULT (' ') FOR [OperatorID]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__SPBNbrO__2613D382]  DEFAULT (' ') FOR [SPBNbrOtherSpecifyName]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISO__5582242B]  DEFAULT (' ') FOR [PmtGISOriginalCoordinateSystem]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISO__56764864]  DEFAULT (' ') FOR [PmtGISOriginalDatumCode]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISC__576A6C9D]  DEFAULT (' ') FOR [PmtGISCurrentDatumCode]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtSect__585E90D6]  DEFAULT (' ') FOR [PmtSectionTownshipRange]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISS__5952B50F]  DEFAULT (' ') FOR [PmtGISSourceName]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISC__5A46D948]  DEFAULT (' ') FOR [PmtGISCollectorStaffCode]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISC__5B3AFD81]  DEFAULT ('N') FOR [PmtGISCertifiedMeasurementYN]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGPSR__5C2F21BA]  DEFAULT (' ') FOR [PmtGPSReceiverTypeName]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISB__5D2345F3]  DEFAULT (' ') FOR [PmtGISBaseStationName]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISH__5E176A2C]  DEFAULT (' ') FOR [PmtGISHorizAccuracy]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISC__5F0B8E65]  DEFAULT (' ') FOR [PmtGISComment]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISH__5FFFB29E]  DEFAULT (' ') FOR [PmtGISHUC]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISP__60F3D6D7]  DEFAULT (' ') FOR [PmtGISPlanningSegment]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISA__61E7FB10]  DEFAULT (' ') FOR [PmtGISArkSenDist]
GO

ALTER TABLE [dbo].[SPBPmts] ADD  CONSTRAINT [DF__SPBPmts__PmtGISA__62DC1F49]  DEFAULT (' ') FOR [PmtGISArkRepDist]
GO

ALTER TABLE [dbo].[SPBPmts]  WITH NOCHECK ADD  CONSTRAINT [FK_SPBPmts_AFIN] FOREIGN KEY([PmtAFIN])
REFERENCES [dbo].[Facilities] ([AFIN])
GO

ALTER TABLE [dbo].[SPBPmts] CHECK CONSTRAINT [FK_SPBPmts_AFIN]
GO