Main source of information for a legal document and its attributes. Legal Documents are linked with the assets to describe a legal relationship or agreement between two or more parties. A record is appended to this table when a new legal document object is created.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| legaldoc_uuid | byte(16) | not null | Legal document ID. Primary key. |
| lelgid | integer | with null | Template Name |
| external_company_uuid | byte(16) | with null | Primary key. Unique identifier. |
| internal_company_uuid | byte(16) | with null | Internal company. Unique identifier. |
| ledocidn | nvarchar(50) | with null | Document identifier |
| negotiator_contact_uuid | byte(16) | with null | Negotiator. Foreign key to the ca_contact table. |
| ledesc | nvarchar(100) | with null | Description |
| leeffdt | date | with null | Effective date |
| letermdt | date | with null | Termination date |
| ledocloc | integer | with null | Document location |
| leeleloc | nvarchar(50) | with null | Electronic location |
| leinact | smallint | with null | Inactive |
| lestatdt | date | with null | Current status date |
| lestatus | smallint | with null | Legal status |
| requestor_contact_uuid | byte(16) | with null | Requestor. Foreign key to the ca_contact table. |
| vendor_contact_uuid | byte(16) | with null | Vendor Negotiator. Foreign key to the ca_contact table. |
| lecnused | smallint | with null | Contract Used |
| gl_code | integer | with null | GL Code. Foreign key to the id field of the ca_resource_gl_code table. |
| cost_center | integer | with null | Cost center. Foreign key to the id field of the ca_resource_cost_center table. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Creation date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table