CREATE TABLE [dbo].[al_link_ca_arg_crncy]
(
[dlkey] [smallint] NOT NULL,
[currency_type_code] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__al_link_c__versi__2B2F2508] DEFAULT ((0)),
[culture_default] [int] NOT NULL CONSTRAINT [DF__al_link_c__cultu__32C6F086] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_ca_arg_crncy] ADD CONSTRAINT [PK_al_link_ca_arg_crncy] PRIMARY KEY CLUSTERED ([dlkey], [currency_type_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_ca_arg_crncy] ADD CONSTRAINT [al_link_ca_arg_crncy_fk01] FOREIGN KEY ([currency_type_code]) REFERENCES [dbo].[ca_currency_type] ([currency_type_code])
GO
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting]
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting_group]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting_group]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting_group]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [uapmreporting_group]
GO