[dbo].[aud_al

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	781
Created	10:36:48 PM Thursday, February 10, 2011
Last Modified	10:37:17 PM Thursday, February 10, 2011

Name	Data Type	Max Length (Bytes)	Identity
pdduedt	datetime	8
pddueamt	float	8
pdpaydt	datetime	8
pdpayamt	float	8
pdintref	nvarchar(35)	70
pdpayref	nvarchar(35)	70
cost_center	int	4
pdcommnt	nvarchar(255)	510
gl_code	int	4
creation_user	nvarchar(64)	128
creation_date	int	4
last_update_user	nvarchar(64)	128
last_update_date	int	4
version_number	int	4
payment_id	bigint	8
cost_id	bigint	8
tenant	binary(16)	16
audit_trail_id	bigint	8	1 - 1
audit_trail_user	nvarchar(64)	128
audit_trail_type	varchar(6)	6
audit_trail_date	int	4
audit_trail_product	varchar(64)	64

	Name	Columns	Unique
	aud_al_paydet_PK	audit_trail_id

SQL Script

CREATE TABLE [dbo].[aud_al_paydet]
(
[pdduedt] [datetime] NULL,
[pddueamt] [float] NULL,
[pdpaydt] [datetime] NULL,
[pdpayamt] [float] NULL,
[pdintref] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pdpayref] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cost_center] [int] NULL,
[pdcommnt] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[gl_code] [int] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL,
[payment_id] [bigint] NOT NULL,
[cost_id] [bigint] NOT NULL,
[tenant] [binary] (16) NULL,
[audit_trail_id] [bigint] NOT NULL IDENTITY(1, 1),
[audit_trail_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[audit_trail_type] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[audit_trail_date] [int] NULL,
[audit_trail_product] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[aud_al_paydet] ADD CONSTRAINT [aud_al_paydet_PK] PRIMARY KEY CLUSTERED ([audit_trail_id]) ON [PRIMARY]
GO