Fixed Asset Management Data Dictionary

Fixed_Asset__c

Label: Fixed Asset

Contains records of long term tangible pieces of property that an organization owns and uses in the production of its income. Fixed assets are not expected to be consumed or converted into cash any sooner than one year from the Date in Service. A fixed asset can record a capital equipment acquisition or an asset that has been transferred. This information is used in Accounting processes.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Accounting_Company__c Accounting Company Spring 2023 The accounting company that relates to this asset. This ensures that transactions are associated with the correct accounting company when your org has more than one accounting company. This field can be populated automatically if you select an asset group where the Accounting Company field is already populated.

Looks up to: c2g__codaCompany__c

Lookup
Accumulated_Depreciation_GLA__c Accumulated Depreciation GLA Spring 2023 The accumulated depreciation general ledger account that relates to this asset. This field can be populated automatically if you select an asset group or asset sub-group where the Accumulated Depreciation GLA field is already populated. This general ledger account is used to reduce the value of the asset on the balance sheet and is credited throughout the depreciation schedule. When the asset is disposed of, the account is debited to write off the depreciation value.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Asset_Condition__c Asset Condition Pre-Fall 2018 Condition of this Asset.

Picklist:
New
None
Used
Asset_Cost__c Asset Cost Pre-Fall 2018 Purchase or Transfer cost of the Item. This is the starting value of the asset and is used to calculate the Quantity of Usefulness.

Currency(12,2)
Asset_Description__c Asset Description Pre-Fall 2018 A general description of the asset with an indication of its purpose.

LongTextArea(32768)
Asset_Group__c Asset Group Pre-Fall 2018 Select the group the asset is assigned to. This field is used to determine the accumulated depreciation account in the General Ledger

Looks up to: Asset_Group__c
Lookup
Asset_Relationship_Description__c Asset Relationship Description Pre-Fall 2018 Formula:
Fixed_Assets_Relationship__r.Relationship_Description__c
Text
Asset_Sub_Group__c Asset Sub-Group Pre-Fall 2018 A secondary grouping to further classify an asset

Looks up to: Asset_Sub_Group__c
Lookup
Asset_Tag_Number__c Asset Tag Number Pre-Fall 2018 Number or description of the asset tag fixed to the asset. You can use this field to tie the number on the asset tag to the asset record.

Text(50)
Business_Use_Percent__c Business Use Percent Pre-Fall 2018 The percentage of the asset that is assigned for business use.

Percent(3,0) 1
Date_Acquired__c Date Acquired Pre-Fall 2018 Date on which the asset was acquired

Date
Date_In_Service__c Date In Service Pre-Fall 2018 Date on which the asset came into service

Date
Department__c Deployed Department Pre-Fall 2018 Department in which the asset is deployed

Looks up to: Department__c
Lookup
Deployed_Facility__c Deployed Facility Pre-Fall 2018 Facility at which the asset is deployed

Picklist:
Facility Five
Facility Four
Facility One
Facility Three
Facility Two
Depreciation_GLA__c Depreciation GLA Spring 2023 The depreciation general ledger account that relates to this asset. This field can be populated automatically if you select an asset group or asset sub-group where the Deprecation GLA field is already populated. This is the general ledger account to which depreciation is charged for the profit and loss account and is debited during the depreciation schedule.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Dimension1__c Dimension 1 Spring 2023 The Accounting Dimension 1 that relates to this asset. This field is optional.

Looks up to: c2g__codaDimension1__c

Lookup
Dimension2__c Dimension 2 Spring 2023 The Accounting Dimension 2 that relates to this asset. This field is optional.

Looks up to: c2g__codaDimension2__c

Lookup
Dimension3__c Dimension 3 Spring 2023 The Accounting Dimension 3 that relates to this asset. This field is optional.

Looks up to: c2g__codaDimension3__c

Lookup
Dimension4__c Dimension 4 Spring 2023 The Accounting Dimension 4 that relates to this asset. This field is optional.

Looks up to: c2g__codaDimension4__c

Lookup
Disposal_Date__c Disposal Date Pre-Fall 2018 Date the asset was removed from contributing deprecation schedules

Date
Disposal_Organization_Address__c Disposal Organization Address Pre-Fall 2018 Address of disposal organization

TextArea
Disposal_Organization_Phone_Number__c Disposal Organization Phone Number Pre-Fall 2018 Contact number of the organization where the asset was disposed

Phone
Disposal_Organization__c Disposal Organization Pre-Fall 2018 Name of the organization where the asset was disposed

Text(100)
Disposal_Value__c Disposal Value Pre-Fall 2018 Amount the asset was sold, salvaged or transferred for

Currency(12,2)
ERP_APVoucher_Line_Correlation_Id__c Foundations AP Voucher Line Correlation Spring 2019 Records the AP voucher line correlation key used within the Foundations system.

Text(255)
Employee_Assigned__c Employee Assigned Pre-Fall 2018 Name of the employee who is accountable for the location of the asset and its use

Text(50)
Employee_E_Mail__c Employee E-Mail Pre-Fall 2018 Email address of the employee to which the asset is assigned

Email
Employee_Phone_Extension__c Employee Phone Extension Pre-Fall 2018 Extension Number of the employee to which the asset is assigned

Text(10)
Employee_Phone_Number__c Employee Phone Number Pre-Fall 2018 Telephone Number of the employee to which the asset is assigned

Phone
Fixed_Asset_GLA__c Fixed Asset GLA Spring 2023 The fixed asset general ledger account that relates to this asset. This field can be populated automatically if you select an asset group or asset sub-group where the Fixed Asset GLA field is already populated. This general ledger account is debited when the asset is acquired and credited when the asset is disposed of. This is normally a balance sheet account.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Fixed_Assets_Relationship__c Fixed Assets Relationship Pre-Fall 2018 Enter the relationship for the asset

Looks up to: Fixed_Assets_Relationship__c
Lookup
Inbound_Transfer__c Inbound Transfer Pre-Fall 2018 Indicates whether the asset was transferred from another organization

Checkbox false
Inherit_Values__c Inherit Values from Parent Pre-Fall 2018 Formula:
IF( ISBLANK ($Setup.Fixed_Asset_Management_Settings__c.Id ), true, $Setup.Fixed_Asset_Management_Settings__c.Inherit_Books_Values__c)
Checkbox
Insurance_Value__c Insurance Value Pre-Fall 2018 The replacement valuation of an insurance policy applicable to this asset

Currency(12,2)
Manufacturer_Serial_Number__c Manufacturer Serial Number Pre-Fall 2018 The serial number assigned by the manufacturer for this asset

Text(50)
Manufacturer__c Manufacturer Pre-Fall 2018 The name of the company that manufactured this asset

Text(50)
Method_of_Disposal__c Method of Disposal Pre-Fall 2018 Disposal method for the asset

Picklist:
Destroyed
Lost
Recycled
Salvaged
Sold
Stolen
Transfer
PNL_On_Asset_Disposal_GLA__c Asset Disposal Profit and Loss GLA Spring 2023 The profit and loss general ledger account that relates to the disposal of this asset. This field can be populated automatically if you select an asset group or asset sub-group where the Asset Disposal Profit and Loss GLA field is already populated. This general ledger account is debited when an asset is disposed of to write off its remaining value.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Payment_GLA__c Payment GLA Spring 2023 The payment general ledger account that relates to this asset. This field can be populated automatically if you select an asset group or asset sub-group where the Payment GLA field is already populated. This general ledger account is credited when the asset is acquired. This is normally a balance sheet account.

Looks up to: c2g__codaGeneralLedgerAccount__c

Lookup
Serial_Number_Id__c Serial Number Id Spring 2019 Serial Number Id of Manufacturer Serial Number resulted by CapEx Integration.

Text(20)
Status_ReadOnly__c Status Pre-Fall 2018 Formula:
TEXT(Status__c)
Text
Status__c Status Pre-Fall 2018 Picklist:
Active
Approved
Cancelled
Disposed
Fully Depreciated
New
Recalled
Rejected
Submitted
Supplier__c Supplier Pre-Fall 2018 The name of the company that this asset was purchased from

Text(200)
Transferring_Organization__c Transferring Organization Pre-Fall 2018 Name of organization transferring asset

Text(100)
V1V2UpgradeDone__c Version 1 to version 2 Upgrade Done Pre-Fall 2018 Indicates whether the upgrade from version 1 to version 2 has been completed

Checkbox true
VIN__c VIN Pre-Fall 2018 Vehicle Identification Numbers – Cars, Trucks Industrial and Farm Equipment may have a specific VIN

Text(50)
Warranty_Expiration_Date__c Warranty Expiration Date Pre-Fall 2018 Date on which the warranty expires for this asset

Date
Warranty_Provided__c Warranty Provided Pre-Fall 2018 Indicates whether the asset has a warranty granted by the Supplier and/or Manufacturer

Checkbox false


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.