CREATE TABLE [dbo].[mnr_ZATCA_EGS_Details](
	ID                 [UNIQUEIDENTIFIER] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ZATCA_EGS_DETAILS_ID] DEFAULT (newid()),
	Number             [INT]               NULL,
	BillID               [UNIQUEIDENTIFIER]  NULL,
	CommercialRegistrationNum [nvarchar](512) NULL,
	PRIVATE_KEY        [VARCHAR]    (max)  NULL,
	EncodePUBLIC_KEY         [VARCHAR]    (max)  NULL,
	EncodeCSR                [VARCHAR]    (max)  NULL,
	REQUEST_ID         [VARCHAR]    (max)  NULL, --csid
	SCRET              [VARCHAR]    (max)  NULL,
	BINARY_TOKEN       [VARCHAR]    (max)  NULL ,
	CERT               [VARCHAR]    (max)  NULL ,
	REGISTER_DATE  DATE,
	LAST_ICV           [float] DEFAULT 0     NOT NULL,
	LAST_PIH [VARCHAR]              (max) DEFAULT 'NWZlY2ViNjZmZmM4NmYzOGQ5NTI3ODZjNmQ2OTZjNzljMmRiYzIzOWRkNGU5MWI0NjcyOWQ3M2EyN2ZiNTdlOQ==' NOT NULL ,
	BINARY_TOKEN_PRODUCTION  [VARCHAR]    (max)  NULL,
	SCRET_PRODUCTION  [VARCHAR]    (max)  NULL,
	CERT_PRODUCTION  [VARCHAR]     (max)  NULL, 
	QRCode  [VARCHAR](max)  NULL, 
	PRIMARY KEY NONCLUSTERED
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]