arg_paydet

Contains information about payments assigned to an asset or legal document

Column Name Column Datatype Column Null Option Column Comment
object_uuid byte(16) not null First part of the primary key. Foreign key to one of the following fields: ca_owned_resource.own_resource_uuid, arg_legaldoc.legaldoc_uuid.
pdcdid smallint not null Cost detail id. Second part of the primary key.
pdid smallint not null Payment detail ID. Third part of the primary key.
object_type smallint with null Object type
pdduedt date with null Date due
pddueamt float with null Amount due
pdpaydt date with null Date paid
pdpayamt float with null Amount paid
pdintref nvarchar(35) with null Internal reference
pdpayref nvarchar(35) with null Payee Reference
cost_center integer with null Cost Center. Foreign key to the id field of the ca_resource_cost_center table.
pdcommnt nvarchar(255) with null Comments
gl_code integer with null GL Code. Foreign key to the id field of the ca_resource_gl_code 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


Copyright © 2006 CA. All rights reserved.