ca_resource_gl_code

Contains information about the GL codes which can be assigned to an asset

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. Resource GL code id.
inactive integer not null Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive)
name nvarchar(100) not null GL Code name. Unique.
description nvarchar(255) with null GL Code description.
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process that last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.