FixedAsset
Table containing details on fixed assets.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | False |
Unique numeric identifier for the fixed asset record. |
| Assetid | String | False |
Unique ID assigned to the asset. |
| State | String | False |
Current state or lifecycle phase of the asset. |
| Status | String | False |
Status of the asset, such as active or retired. |
| Name | String | False |
Descriptive name of the asset. |
| Serialnumber | String | False |
Asset's serial number, if applicable. |
| Assettag | String | False |
Asset tag or barcode assigned for tracking. |
| Assetcost | Decimal | False |
Original cost of acquiring the asset. |
| Salvagevalue | Decimal | False |
Estimated residual value at the end of the asset's useful life. |
| Inservicedate | Date | False |
Date the asset was placed in service. |
| Classificationkey | Long | False |
Identifier for the asset’s classification. |
| Classification_classificationid | String | False |
Unique ID of the asset classification. |
| Classification_name | String | False |
Name of the asset classification. |
| Depracctkey | Long | False |
Identifier for the accumulated depreciation GL account. |
| Depracct_acct_no | String | False |
Account number for the depreciation GL account. |
| Depracct_name | String | False |
Name of the depreciation GL account. |
| Deprexpacctkey | Long | False |
Identifier for the depreciation expense GL account. |
| Deprexpacct_acct_no | String | False |
Account number for the depreciation expense GL account. |
| Deprexpacct_name | String | False |
Name of the depreciation expense GL account. |
| Assetacctkey | Long | False |
Identifier for the asset GL account. |
| Assetacct_acct_no | String | False |
Account number for the asset GL account. |
| Assetacct_name | String | False |
Name of the asset GL account. |
| Disposalacctkey | Long | False |
Identifier for the disposal GL account. |
| Disposalacct_acct_no | String | False |
Account number for the disposal GL account. |
| Disposalacct_name | String | False |
Name of the disposal GL account. |
| Gainlossacctkey | Long | False |
Identifier for the gain/loss GL account. |
| Gainlossacct_acct_no | String | False |
Account number for the gain/loss GL account. |
| Gainlossacct_name | String | False |
Name of the gain/loss GL account. |
| Whencreated | Datetime | False |
Timestamp when the asset record was created. |
| Whenmodified | Datetime | False |
Timestamp when the asset record was last updated. |
| Createdby | Long | False |
ID of the user who created the asset record. |
| Modifiedby | Long | False |
ID of the user who last modified the asset record. |
| Createdbyuser_recordno | Long | False |
User record number for the creator. |
| Createdbyuser_loginid | String | False |
Login ID of the user who created the asset. |
| Modifiedbyuser_recordno | Long | False |
User record number for the last modifier. |
| Modifiedbyuser_loginid | String | False |
Login ID of the user who modified the asset. |
| Melocationkey | Long | False |
Identifier for the multi-entity location. |
| Melocation_location_no | String | False |
Location number for the multi-entity structure. |
| Melocation_name | String | False |
Name of the multi-entity location. |
| Quantity | Long | False |
Quantity of the asset units. |
| Depreciate | Bool | False |
Indicates whether the asset is depreciated. |
| Acquisitiondate | Date | False |
Date the asset was acquired. |
| Description | String | False |
Detailed description of the asset. |
| Notes | String | False |
Internal notes about the asset. |
| Disposaldate | Date | False |
Date the asset was disposed. |
| Disposaltype | String | False |
Type of disposal for the asset. |
| Saleprice | Decimal | False |
Sale price of the disposed asset. |
| Disposalcomments | String | False |
Comments or notes about the asset’s disposal. |
| Type | String | False |
Specifies whether the asset is tangible or intangible. |
| Depreciablecost | Decimal | False |
Cost of the asset that is subject to depreciation. |
| Ndgainlossamount | Decimal | False |
Amount of gain or loss from the asset disposal. |
| Nddisposedglbatchkey | Long | False |
GL batch key for the asset’s disposal transaction. |
| Nddisposedglbatch_txnnumber | Long | False |
Transaction number in the disposal GL batch. |
| Ndjournalkey | Long | False |
Identifier for the related journal entry. |
| Ndjournal_symbol | String | False |
Journal symbol used for the transaction |
| Ndjournal_name | String | False |
Name of the journal entry. |
| Allocationkey | Long | False |
Identifier for the asset allocation. |
| Allocation_allocationid | String | False |
ID of the allocation record. |
| Sourceclientid | String | False |
ID of the client that originated the record. |
| Sourceheadertype | String | False |
Type of source header for the record. |
| Sourceheaderkey | Long | False |
Record number of the source header. |
| Sourceheaderid | String | False |
Identifier of the source header. |
| Sourcelinekey | Long | False |
Record number of the source line item. |
| Sourcelineno | Long | False |
Line number of the source transaction. |
| Attachmentkey | Long | False |
Identifier for the attached document. |
| Attachment_documentid | String | False |
Document ID of the attachment. |
| Attachment_name | String | False |
Name or title of the attached document. |
| Parentkey | Long | False |
Record number of the parent asset. |
| Parent_assetid | String | False |
Asset ID of the parent asset. |
| Parent_name | String | False |
Name of the parent asset. |
| Locationkey | Long | False |
Identifier for the asset's location |
| Deptkey | Long | False |
Identifier for the department associated with the asset. |
| Megaentitykey | Long | True |
Key for the entity where the asset was created. |
| Megaentityid | String | True |
Entity ID where the asset was created. |
| Megaentityname | String | True |
Entity name where the asset was created. |
| Projectdimkey | Long | False |
Identifier for the associated project dimension. |
| Projectid | String | False |
ID of the associated project. |
| Projectname | String | False |
Name of the associated project. |
| Customerdimkey | Long | False |
Identifier for the associated customer dimension. |
| Customerid | String | False |
ID of the associated customer. |
| Customername | String | False |
Name of the associated customer. |
| Vendordimkey | Long | False |
Identifier for the associated vendor dimension. |
| Vendorid | String | False |
ID of the associated vendor. |
| Vendorname | String | False |
Name of the associated vendor. |
| Employeedimkey | Long | False |
Identifier for the associated employee dimension. |
| Employeeid | String | False |
ID of the associated employee. |
| Employeename | String | False |
Name of the associated employee. |
| Itemdimkey | Long | False |
Identifier for the associated item dimension. |
| Itemid | String | False |
ID of the associated item. |
| Itemname | String | False |
Name of the associated item. |
| Classdimkey | Long | False |
Identifier for the associated class dimension. |
| Classid | String | False |
ID of the associated class. |
| Classname | String | False |
Name of the associated class. |
| Warehousedimkey | Long | False |
Identifier for the associated warehouse dimension. |
| Warehouseid | String | False |
ID of the associated warehouse. |
| Warehousename | String | False |
Name of the associated warehouse. |
| Contractdimkey | Long | False |
Identifier for the associated contract dimension. |
| Contractid | String | False |
ID of the associated contract. |
| Contractname | String | False |
Name of the associated contract. |
| Record_url | String | True |
A portable, user-independent, deep-link URL for viewing this record. |
| Gldimtest | String | False |
Internal field used for GL dimension testing. |
| Gldimtestegi1 | String | False |
Internal field used for GL dimension testing. |