Views [dbo].[al_aud_legaldoc_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:37:15 PM Thursday, February 10, 2011
Last Modified10:37:15 PM Thursday, February 10, 2011
Columns
Name
legaldoc_uuid
lelgid
external_company_uuid
internal_company_uuid
ledocidn
negotiator_contact_uuid
ledesc
leeffdt
letermdt
ledocloc
leeleloc
leinact
lestatdt
lestatus
requestor_contact_uuid
vendor_contact_uuid
lecnused
gl_code
cost_center
creation_user
creation_date
last_update_user
last_update_date
version_number
organization_uuid
owner_uuid
manager_uuid
cost_approver_uuid
tenant
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product
SQL Script
CREATE VIEW dbo.al_aud_legaldoc_view AS select audittable.* from dbo.aud_arg_legaldoc audittable WITH(READPAST) left outer join dbo.al_aud_legaldoc_potr audpointer on (audittable.legaldoc_uuid = audpointer.legaldoc_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO
Uses