arg_costdet

Contains information about costs assigned to an asset or legal document. UAPM facilitates tracking of cost information for assets and legal documents. It also allows using cost records in conjunction with payments and notifications to create payment schedules. These schedules can help you make timely payments and reduce the risk of overpayment. A record is added to this table when cost details are added to either asset or legal document. The information can be viewed by selecting the respective cost node under Cost for Object Type node of an object's main view.

Column Name Column Datatype Column Null Option Column Comment
object_uuid byte(16) not null Object uuid. Primary key.. First part of the primary key. Foreign key to one of the following fields: ca_owned_resource.own_resource_uuid, arg_legaldoc.legaldoc_uuid
cdid smallint not null Cost detail ID. Second part of the primary key.
object_type smallint with null Object type
cdbegdt date with null Begin date. Indicates when the cost begins or when the first cost was incurred.
cdivid smallint with null Version
cduntamt float with null Unit amount. Specifies the cost per unit value.
company_uuid byte(16) with null Primary key. Unique identifier.
cdbillcd integer with null Billing code
cdcommnt nvarchar(255) with null Cost comment
cdamtper integer with null Amortization period. Indicates the number of months over which you will amortize this cost in accounting books.
cdreunt smallint with null Recurring Period Units
cdreper integer with null Recurring period. Indicates how often the cost recures.
cdretmdt date with null Termination date. Indicates when you expect a recurring cost to terminate.
cdreact smallint with null Actual term. date. Indicates whether the selected date is estimated or actual.
cdrecap smallint with null Escalation cap. Indicates whether you negotiated a cap on escalation charges.
cdreespc float with null Escalation percent. Provides the estimated percentage cost increase per recurring period.
cost_center integer with null Primary key. Cost center id.
cdcurrty smallint with null Currency type
cdtype smallint with null Cost Type
gl_code integer with null GL code. Foreign key to the id field of the ca_resource_gl_code table.
cdpaytype smallint with null Payment Type
cdpaytot float with null Payment total for this cost.
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


Copyright © 2006 CA. All rights reserved.