CREATE TABLE [dbo].[auth_product]
(
	    auth_product_key int primary key identity(1,1) not null ,
        auth_key int not null ,
        nappi_code nchar(9) not null ,
		proc_user_id int not null,
		proc_status_id int not null,
        product_type nchar(1) not null ,
        auth_product_start_dt datetime not null ,
        auth_product_end_dt datetime not null ,
        auth_product_dose decimal(10,1) not null ,
        product_freq_key int not null ,
        auth_repeats int not null ,
        nappi_unit_price money not null ,
        dispense_type_key int not null ,
        modified_dt datetime not null ,
        modified_by uniqueidentifier not null
		)
