Asset Module - Database Schema Documentation for builds below 15000/7800

Asset Module - Database Schema Documentation for builds below 15000/7800

Asset Module — Database Schema Documentation

Section 1: Asset Core Details

Field	Column	Source Table	JOIN Clause
Asset ID	`r.RESOURCEID`	`Resources r`	—
Asset Name	`r.RESOURCENAME`	`Resources r`	—
Asset Tag	`r.ASSETTAG`	`Resources r`	—
Serial Number	`r.SERIALNO`	`Resources r`	—
Barcode	`b.BARCODE`	`Barcodes b`	`LEFT JOIN Barcodes b ON r.BARCODEID = b.BARCODEID`
Description	`r.DESCRIPTION`	`Resources r`	—
IP Addresses	`r.IPADDRESSES`	`Resources r`	—
Primary IP	`r.PRIMARYIPADDRESS`	`Resources r`	—
MAC Addresses	`r.MACADDRESSES`	`Resources r`	—
Is Personal	`r.ISPERSONAL`	`Resources r`	—
Is Loanable	`r.ISLOANABLE`	`Resources r`	—
Location (Text)	`r.LOCATION`	`Resources r`	—
Scan Serial Number	`r.SCANSERIALNUMBER`	`Resources r`	—
Acquisition Date	`longtodate(r.ACQUISITIONDATE)`	`Resources r`	—
Warranty Expiry	`longtodate(r.WARRANTYEXPIRY)`	`Resources r`	—
Expiry Date	`longtodate(r.EXPIRYDATE)`	`Resources r`	—
Created Time	`longtodate(r.CREATEDTIME)`	`Resources r`	—
Modified Time	`longtodate(r.MODIFIEDTIME)`	`Resources r`	—

Section 2: Asset State

Field	Column	Source Table	JOIN Clause
State (Display)	`rs.DISPLAYSTATE`	`ResourceState rs`	`LEFT JOIN ResourceState rs ON r.RESOURCESTATEID = rs.RESOURCESTATEID`
State Description	`rs.STATEDESC`	`ResourceState rs`	(same)
State Detail	`rs.DESCRIPTION`	`ResourceState rs`	(same)
Is Disposed	`rs.ISDISPOSED`	`ResourceState rs`	(same)

Section 3: Product / Component Type

Field	Column	Source Table	JOIN Clause
Product Name	`cd.COMPONENTNAME`	`ComponentDefinition cd`	`LEFT JOIN ComponentDefinition cd ON r.COMPONENTID = cd.COMPONENTID`
Manufacturer	`cd.MANUFACTURERNAME`	`ComponentDefinition cd`	(same)
Part Number	`cd.PARTNO`	`ComponentDefinition cd`	(same)
Product Cost	`cd.COST`	`ComponentDefinition cd`	(same)
Asset Type	`ct.COMPONENTTYPENAME`	`ComponentType ct`	`LEFT JOIN ComponentType ct ON cd.COMPONENTTYPEID = ct.COMPONENTTYPEID`
Resource Type	`rt.TYPE`	`ResourceType rt`	`LEFT JOIN ResourceType rt ON ct.RESOURCETYPEID = rt.RESOURCETYPEID`
Resource Category	`rc.CATEGORY`	`ResourceCategory rc`	`LEFT JOIN ResourceCategory rc ON ct.RESOURCECATEGORYID = rc.RESOURCECATEGORYID`

Section 4: Asset Owner

Field	Column	Source Table	JOIN Clause
Owner Name	`owneruser.FIRST_NAME`	`AaaUser owneruser`	`LEFT JOIN ResourceOwner ro ON r.RESOURCEID = ro.RESOURCEID` `LEFT JOIN SDUser ownersdu ON ro.USERID = ownersdu.USERID` `LEFT JOIN AaaUser owneruser ON ownersdu.USERID = owneruser.USER_ID`
Owner Employee ID	`ownersdu.EMPLOYEEID`	`SDUser ownersdu`	(via ResourceOwner)
Owner Job Title	`ownersdu.JOBTITLE`	`SDUser ownersdu`	(via ResourceOwner)
Owner Department	`ownerdept.DEPTNAME`	`DepartmentDefinition ownerdept`	`LEFT JOIN DepartmentDefinition ownerdept ON ro.DEPTID = ownerdept.DEPTID`
Owner VIP	`ownersdu.ISVIPUSER`	`SDUser ownersdu`	(via ResourceOwner)
Owner Email	`ownercontact.EMAILID`	`AaaContactInfo ownercontact`	`LEFT JOIN AaaUserContactInfo owneruci ON owneruser.USER_ID = owneruci.USER_ID` `LEFT JOIN AaaContactInfo ownercontact ON owneruci.CONTACTINFO_ID = ownercontact.CONTACTINFO_ID`

Section 5: Ownership History

Field	Column	Source Table	JOIN Clause
Assigned User	`histuser.FIRST_NAME`	`AaaUser histuser`	`LEFT JOIN ResourceOwnerHistory roh ON r.RESOURCEID = roh.RESOURCEID` `LEFT JOIN SDUser histsdu ON roh.USERID = histsdu.USERID` `LEFT JOIN AaaUser histuser ON histsdu.USERID = histuser.USER_ID`
Changed By	`taskuser.FIRST_NAME`	`AaaUser taskuser`	`LEFT JOIN SDUser tasksdu ON roh.TASKUSERID = tasksdu.USERID` `LEFT JOIN AaaUser taskuser ON tasksdu.USERID = taskuser.USER_ID`
Ownership Start	`longtodate(roh.STARTTIME)`	`ResourceOwnerHistory roh`	(same)
Ownership End	`longtodate(roh.ENDTIME)`	`ResourceOwnerHistory roh`	(same)
Department	`rohdept.DEPTNAME`	`DepartmentDefinition rohdept`	`LEFT JOIN DepartmentDefinition rohdept ON roh.DEPTID = rohdept.DEPTID`
Comments	`roh.COMMENTS`	`ResourceOwnerHistory roh`	(same)

Section 6: State History

Field	Column	Source Table	JOIN Clause
New State	`newstate.DISPLAYSTATE`	`ResourceState newstate`	`LEFT JOIN ResourceStateHistory rsh ON r.RESOURCEID = rsh.RESOURCEID` `LEFT JOIN ResourceState newstate ON rsh.RESOURCESTATEID = newstate.RESOURCESTATEID`
Previous State	`prevstate.DISPLAYSTATE`	`ResourceState prevstate`	`LEFT JOIN ResourceState prevstate ON rsh.PREVRESOURCESTATEID = prevstate.RESOURCESTATEID`
State Change Time	`longtodate(rsh.STARTTIME)`	`ResourceStateHistory rsh`	(same)
State End Time	`longtodate(rsh.ENDTIME)`	`ResourceStateHistory rsh`	(same)
Changed By	`stateuser.FIRST_NAME`	`AaaUser stateuser`	`LEFT JOIN SDUser statesdu ON rsh.USERID = statesdu.USERID` `LEFT JOIN AaaUser stateuser ON statesdu.USERID = stateuser.USER_ID`
Comments	`rsh.COMMENTS`	`ResourceStateHistory rsh`	(same)

Section 7: Site / Region / Physical Location

Field	Column	Source Table	JOIN Clause
Site	`sdo.NAME`	`SDOrganization sdo`	`LEFT JOIN SiteDefinition sitedef ON r.SITEID = sitedef.SITEID` `LEFT JOIN SDOrganization sdo ON sitedef.SITEID = sdo.ORG_ID`
Region	`regiondef.REGIONNAME`	`RegionDefinition regiondef`	`LEFT JOIN RegionDefinition regiondef ON sitedef.REGIONID = regiondef.REGIONID`
Building	`bldg.BUILDINGNAME`	`BuildingDefinition bldg`	`LEFT JOIN ResourceLocation rloc ON r.RESOURCEID = rloc.RESOURCEID` `LEFT JOIN BuildingDefinition bldg ON rloc.BUILDINGID = bldg.BUILDINGID`
Floor	`flr.FLOORNAME`	`FloorDefinition flr`	`LEFT JOIN FloorDefinition flr ON rloc.FLOORID = flr.FLOORID`
Room	`rm.ROOMNAME`	`RoomDefinition rm`	`LEFT JOIN RoomDefinition rm ON rloc.ROOMID = rm.ROOMID`
Location (Text)	`rloc.LOCATION`	`ResourceLocation rloc`	(same)
Latitude	`rloc.LATITUDE`	`ResourceLocation rloc`	(same)
Longitude	`rloc.LONGITUDE`	`ResourceLocation rloc`	(same)

Section 8: CI / CMDB

Field	Column	Source Table	JOIN Clause
CI ID	`ci.CIID`	`CI ci`	`LEFT JOIN CI ci ON r.CIID = ci.CIID`
CI Name	`ci.CINAME`	`CI ci`	(same)
CI Description	`ci.DESCRIPTION`	`CI ci`	(same)
CI Type	`citype.TYPENAME`	`CIType citype`	`LEFT JOIN CIType citype ON ci.CITYPEID = citype.TYPEID`
CI Status	`cistatus.STATUSNAME`	`CIStatus cistatus`	`LEFT JOIN CIStatus cistatus ON ci.STATUSID = cistatus.STATUSID`
CI Created Date	`longtodate(ci.CREATEDDATE)`	`CI ci`	(same)
CI Last Modified	`longtodate(ci.LASTMODIFIED)`	`CI ci`	(same)
CI Version	`ci.VERSION`	`CI ci`	(same)

Section 9: Vendor

Field	Column	Source Table	JOIN Clause
Vendor Name	`vd.NAME`	`VendorDefinition vd`	`LEFT JOIN VendorDefinition vd ON r.VENDORID = vd.VENDORID`
Contact Person	`vd.CONTACTPERSON`	`VendorDefinition vd`	(same)
Email	`vd.EMAILID`	`VendorDefinition vd`	(same)
Phone	`vd.LANDLINE`	`VendorDefinition vd`	(same)
Fax	`vd.FAX`	`VendorDefinition vd`	(same)
Website	`vd.WEB_URL`	`VendorDefinition vd`	(same)
City	`vd.CITY`	`VendorDefinition vd`	(same)
State	`vd.STATE`	`VendorDefinition vd`	(same)
Country	`vd.COUNTRY`	`VendorDefinition vd`	(same)

Section 10: Purchase Order Chain

Field	Column	Source Table	JOIN Clause
PO Name	`po.PONAME`	`PurchaseOrder po`	`LEFT JOIN PurchaseLot pl ON r.PURCHASELOTID = pl.PURCHASELOTID` `LEFT JOIN PurchaseOrderItem poi ON pl.PURCHASEORDERITEMID = poi.PURCHASEORDERITEMID` `LEFT JOIN PurchaseOrder po ON poi.PURCHASEORDERID = po.PURCHASEORDERID`
PO Custom ID	`po.POCUSTOMID`	`PurchaseOrder po`	(same)
Date Ordered	`longtodate(po.DATEORDERED)`	`PurchaseOrder po`	(same)
Date Required	`longtodate(po.DATEREQUIRED)`	`PurchaseOrder po`	(same)
Shipping Price	`po.SHIPPINGPRICE`	`PurchaseOrder po`	(same)
Sales Tax	`po.SALESTAX`	`PurchaseOrder po`	(same)
Total Price	`po.TOTALPRICE`	`PurchaseOrder po`	(same)
PO Item Name	`poi.ITEMNAME`	`PurchaseOrderItem poi`	(same)
PO Item Price	`poi.PRICE`	`PurchaseOrderItem poi`	(same)
Quantity Ordered	`poi.QUANTITYORDERED`	`PurchaseOrderItem poi`	(same)
Lot Date Received	`longtodate(pl.DATERECEIVED)`	`PurchaseLot pl`	(same)
Lot Warranty Expiry	`longtodate(pl.WARRANTYEXPIRY)`	`PurchaseLot pl`	(same)
Lot Lease Expiry	`longtodate(pl.LEASEEXPIRY)`	`PurchaseLot pl`	(same)
PO Requester	`poreq.FIRST_NAME`	`AaaUser poreq`	`LEFT JOIN SDUser poreqsdu ON po.REQUESTERID = poreqsdu.USERID` `LEFT JOIN AaaUser poreq ON poreqsdu.USERID = poreq.USER_ID`
PO Vendor	`povd.NAME`	`VendorDefinition povd`	`LEFT JOIN VendorDefinition povd ON po.VENDORID = povd.VENDORID`

Section 11: Cost

Field	Column	Source Table	JOIN Clause
Purchase Cost	`rcost.PURCHASECOST`	`ResourceToCost rcost`	`LEFT JOIN ResourceToCost rcost ON r.RESOURCEID = rcost.RESOURCEID`
Operational Cost	`rcost.OPERATIONALCOST`	`ResourceToCost rcost`	(same)
Current Cost	`rcost.CURRENTCOST`	`ResourceToCost rcost`	(same)
Total Cost	`rcost.TOTALCOST`	`ResourceToCost rcost`	(same)

Section 12: System / Hardware Info

Field	Column	Source Table	JOIN Clause
Workstation Name	`si.WORKSTATIONNAME`	`SystemInfo si`	`LEFT JOIN SystemInfo si ON r.RESOURCEID = si.WORKSTATIONID`
System Manufacturer	`si.MANUFACTURER`	`SystemInfo si`	(same)
System Model	`si.MODEL`	`SystemInfo si`	(same)
Service Tag	`si.SERVICETAG`	`SystemInfo si`	(same)
BIOS Name	`si.BIOSNAME`	`SystemInfo si`	(same)
BIOS Version	`si.BIOSVERSION`	`SystemInfo si`	(same)
Logged User	`si.LOGGEDUSER`	`SystemInfo si`	(same)
Processor Summary	`si.PROCESSOR`	`SystemInfo si`	(same)
Processor Count	`si.PROCESSORCOUNT`	`SystemInfo si`	(same)
Core Count	`si.PROCESSORCORECOUNT`	`SystemInfo si`	(same)
Disk Space	`si.DISKSPACE`	`SystemInfo si`	(same)
RAM Slots	`si.RAMSLOTSCOUNT`	`SystemInfo si`	(same)
Agent Installed	`si.ISAGENTINSTALLED`	`SystemInfo si`	(same)
Agent Version	`si.AGENTVERSION`	`SystemInfo si`	(same)
Last Boot Time	`si.LASTBOOTTIME`	`SystemInfo si`	(same)
Is Server	`si.ISSERVER`	`SystemInfo si`	(same)

Processor Details

Field	Column	Source Table	JOIN Clause
CPU Name	`pi.CPUNAME`	`ProcessorInfo pi`	`LEFT JOIN ProcessorInfo pi ON si.WORKSTATIONID = pi.WORKSTATIONID`
CPU Speed	`pi.SPEED`	`ProcessorInfo pi`	(same)
CPU Vendor	`pi.VENDOR`	`ProcessorInfo pi`	(same)
CPU Model	`pi.CPUMODEL`	`ProcessorInfo pi`	(same)
CPU Serial	`pi.CPUSERIALNUMBER`	`ProcessorInfo pi`	(same)
Number of Cores	`pi.NUMBEROFCORES`	`ProcessorInfo pi`	(same)

Memory Details

Field	Column	Source Table	JOIN Clause
Total Memory	`mi.TOTALMEMORY`	`MemoryInfo mi`	`LEFT JOIN MemoryInfo mi ON si.WORKSTATIONID = mi.WORKSTATIONID`
Free Memory	`mi.FREEMEMORY`	`MemoryInfo mi`	(same)
Virtual Memory	`mi.VIRTUALMEMORY`	`MemoryInfo mi`	(same)

Memory Module Details

Field	Column	Source Table	JOIN Clause
Module Name	`mm.NAME`	`MemoryModuleInfo mm`	`LEFT JOIN MemoryModuleInfo mm ON si.WORKSTATIONID = mm.WORKSTATIONID`
Capacity	`mm.CAPACITY`	`MemoryModuleInfo mm`	(same)
Memory Type	`mm.MEMORYTYPE`	`MemoryModuleInfo mm`	(same)
Frequency	`mm.FREQUENCY`	`MemoryModuleInfo mm`	(same)
Socket Label	`mm.SOCKETLABEL`	`MemoryModuleInfo mm`	(same)

Hard Disk Details

Field	Column	Source Table	JOIN Clause
Model Number	`hd.MODELNUMBER`	`HardDiskInfo hd`	`LEFT JOIN HardDiskInfo hd ON si.WORKSTATIONID = hd.WORKSTATIONID`
Serial Number	`hd.SERIALNUMBER`	`HardDiskInfo hd`	(same)
Capacity	`hd.CAPACITY`	`HardDiskInfo hd`	(same)
Free Space	`hd.FREESPACE`	`HardDiskInfo hd`	(same)
Drive Type	`hd.DRIVETYPE`	`HardDiskInfo hd`	(same)
Manufacturer	`hd.MANUFACTURER`	`HardDiskInfo hd`	(same)

Drive Details

Field	Column	Source Table	JOIN Clause
Drive Name	`dr.DRIVENAME`	`DriveInfo dr`	`LEFT JOIN DriveInfo dr ON si.WORKSTATIONID = dr.WORKSTATIONID`
Drive Type	`dr.DRIVETYPE`	`DriveInfo dr`	(same)
Capacity	`dr.CAPACITY`	`DriveInfo dr`	(same)
Free Space	`dr.FREESPACE`	`DriveInfo dr`	(same)
File System	`dr.FILESYSTEM`	`DriveInfo dr`	(same)

Monitor Details

Field	Column	Source Table	JOIN Clause
Monitor Type	`mon.MONITORTYPE`	`MonitorInfo mon`	`LEFT JOIN MonitorInfo mon ON si.WORKSTATIONID = mon.WORKSTATIONID`
Max Resolution	`mon.MAXRESOLUTION`	`MonitorInfo mon`	(same)
Manufacturer	`mon.MANUFACTURER`	`MonitorInfo mon`	(same)
Serial Number	`mon.SERIALNUMBER`	`MonitorInfo mon`	(same)

OS Details

Field	Column	Source Table	JOIN Clause
OS Name	`osi.OSNAME`	`OSInfo osi`	`LEFT JOIN OSInfo osi ON si.WORKSTATIONID = osi.WORKSTATIONID`
Version	`osi.VERSION`	`OSInfo osi`	(same)
Build Number	`osi.BUILDNUMBER`	`OSInfo osi`	(same)
Service Pack	`osi.SERVICEPACK`	`OSInfo osi`	(same)
Product ID	`osi.PRODUCTID`	`OSInfo osi`	(same)
System Type	`osi.SYSTEMTYPE`	`OSInfo osi`	(same)
License Type	`osi.LICENSETYPE`	`OSInfo osi`	(same)
License Status	`osi.LICENSESTATUS`	`OSInfo osi`	(same)

Network Details

Field	Column	Source Table	JOIN Clause
NIC Name	`ni.NICNAME`	`NetworkInfo ni`	`LEFT JOIN NetworkInfo ni ON r.RESOURCEID = ni.WORKSTATIONID`
NIC Description	`ni.NICDESCRIPTION`	`NetworkInfo ni`	(same)
IP Address	`ni.IPADDRESS`	`NetworkInfo ni`	(same)
MAC Address	`ni.MACADDRESS`	`NetworkInfo ni`	(same)
Subnet Mask	`ni.IPNETMASK`	`NetworkInfo ni`	(same)
Gateway	`ni.GATEWAY`	`NetworkInfo ni`	(same)
DHCP	`ni.ISDHCP`	`NetworkInfo ni`	(same)
DHCP Server	`ni.DHCPSERVER`	`NetworkInfo ni`	(same)

Section 13: Software Installed

Field	Column	Source Table	JOIN Clause
Software Name	`swl.SOFTWARENAME`	`SoftwareList swl`	`LEFT JOIN SoftwareInfo swi ON si.WORKSTATIONID = swi.WORKSTATIONID` `LEFT JOIN SoftwareList swl ON swi.SOFTWAREID = swl.SOFTWAREID`
Product Name	`swl.PRODUCTNAME`	`SoftwareList swl`	(same)
Product Version	`swl.PRODUCTVERSION`	`SoftwareList swl`	(same)
File Version	`swl.FILEVERSION`	`SoftwareList swl`	(same)
Company Name	`swl.COMPANYNAME`	`SoftwareList swl`	(same)
Manufacturer	`swm.NAME`	`SoftwareManufacturer swm`	`LEFT JOIN SoftwareManufacturer swm ON swl.SWMANUFACTURERID = swm.SWMANUFACTURERID`
Install Path	`swi.LOCATION`	`SoftwareInfo swi`	(same)
File Size	`swi.FILESIZE`	`SoftwareInfo swi`	(same)

Section 14: Maintenance Contract

Field	Column	Source Table	JOIN Clause
Contract Name	`mc.CONTRACTNAME`	`MaintenanceContract mc`	`LEFT JOIN ContractDetails cdet ON r.RESOURCEID = cdet.RESOURCEID` `LEFT JOIN MaintenanceContract mc ON cdet.CONTRACTID = mc.CONTRACTID`
Custom Contract ID	`mc.CUSTOMCONTRACTID`	`MaintenanceContract mc`	(same)
From Date	`longtodate(mc.FROMDATE)`	`MaintenanceContract mc`	(same)
To Date	`longtodate(mc.TODATE)`	`MaintenanceContract mc`	(same)
Total Price	`mc.TOTALPRICE`	`MaintenanceContract mc`	(same)
Support	`mc.SUPPORT`	`MaintenanceContract mc`	(same)
Contract Vendor	`mcvd.NAME`	`VendorDefinition mcvd`	`LEFT JOIN VendorDefinition mcvd ON mc.MAINTENANCEVENDOR = mcvd.VENDORID`

Section 15: Loan

Field	Column	Source Table	JOIN Clause
Loan ID	`lo.LOANID`	`Loan lo`	`LEFT JOIN LoanResources lr ON r.RESOURCEID = lr.RESOURCEID` `LEFT JOIN Loan lo ON lr.LOANID = lo.LOANID`
Loan Custom ID	`lo.LOANCUSTOMID`	`Loan lo`	(same)
Loaned To	`loanuser.FIRST_NAME`	`AaaUser loanuser`	`LEFT JOIN SDUser loansdu ON lo.USERID = loansdu.USERID` `LEFT JOIN AaaUser loanuser ON loansdu.USERID = loanuser.USER_ID`
Loan Start	`longtodate(lo.STARTTIME)`	`Loan lo`	(same)
Loan End	`longtodate(lo.ENDTIME)`	`Loan lo`	(same)
Extended To	`longtodate(lo.EXTENDEDTO)`	`Loan lo`	(same)
Returned On	`longtodate(lo.RETURNEDON)`	`Loan lo`	(same)
Loan Status	`lo.STATUS`	`Loan lo`	(same)
Is Returned	`lr.ISRETURNED`	`LoanResources lr`	(same)

Section 16: Scan / Audit History

Field	Column	Source Table	JOIN Clause
Audit Time	`longtodate(ah.AUDITTIME)`	`AuditHistory ah`	`LEFT JOIN AuditHistory ah ON r.RESOURCEID = ah.WORKSTATIONID`
Audit Status	`ah.AUDITSTATUS`	`AuditHistory ah`	(same)
Comments	`ah.COMMENTS`	`AuditHistory ah`	(same)
HW Change Table	`hwah.TABLENAME`	`HWAuditHistory hwah`	`LEFT JOIN HWAuditHistory hwah ON ah.AUDITID = hwah.AUDITID`
HW Change Column	`hwah.COLUMNNAME`	`HWAuditHistory hwah`	(same)
HW New Value	`hwah.COLUMNVALUE`	`HWAuditHistory hwah`	(same)
HW Old Value	`hwah.COLUMNOLDVALUE`	`HWAuditHistory hwah`	(same)
Operation	`ao.OPERATIONSTRING`	`AuditOperation ao`	`LEFT JOIN AuditOperation ao ON hwah.OPERATION = ao.OPERATION`

Section 17: CI History

Field	Column	Source Table	JOIN Clause
Edit Mode	`cih.EDITMODE`	`CIHistory cih`	`LEFT JOIN CIHistory cih ON ci.CIID = cih.CIID`
Operation Time	`longtodate(cih.OPERATIONTIME)`	`CIHistory cih`	(same)
Changed By	`cihuser.FIRST_NAME`	`AaaUser cihuser`	`LEFT JOIN SDUser cihsdu ON cih.USERID = cihsdu.USERID` `LEFT JOIN AaaUser cihuser ON cihsdu.USERID = cihuser.USER_ID`
Attribute Changed	`cihd.ATTRIBUTE`	`CIHistoryDetails cihd`	`LEFT JOIN CIHistoryDetails cihd ON cih.HISTORYID = cihd.HISTORYID`
Old Value	`cihd.OLDVALUE`	`CIHistoryDetails cihd`	(same)
New Value	`cihd.NEWVALUE`	`CIHistoryDetails cihd`	(same)

Section 18: Depreciation

Field	Column	Source Table	JOIN Clause
Depreciation Type	`dtype.DEPRECIATIONTYPE`	`DepreciationType dtype`	`LEFT JOIN ResourceDepreciation rdep ON r.RESOURCEID = rdep.RESOURCEID` `LEFT JOIN DepreciationDetails dd ON rdep.DEPRECIATIONID = dd.DEPRECIATIONID` `LEFT JOIN DepreciationType dtype ON dd.DEPRECIATIONTYPEID = dtype.DEPRECIATIONTYPEID`
Salvage Value	`dd.SALVAGEVALUE`	`DepreciationDetails dd`	(same)
Useful Life	`dd.USEFULLIFE`	`DepreciationDetails dd`	(same)
Depreciation %	`dd.DEPRECIATIONPERCENT`	`DepreciationDetails dd`	(same)

Section 19: Asset Additional Fields (UDF)

Field	Column	Source Table	JOIN Clause
UDF Char 1–24	`rf.UDF_CHAR1` … `rf.UDF_CHAR24`	`Resource_Fields rf`	`LEFT JOIN Resource_Fields rf ON r.RESOURCEID = rf.RESOURCEID`
UDF Long 1–10	`rf.UDF_LONG1` … `rf.UDF_LONG10`	`Resource_Fields rf`	(same)
UDF Date 1–10	`longtodate(rf.UDF_DATE1)` …	`Resource_Fields rf`	(same)