AssetTable Table

The AssetTable contains the details related to the fixed assets.

ID: 1165

Configuration Key: Asset

Security Key: LedgerTables

Methods

Method

Description

AllowEditOfAssetNum

aosValidateDelete

(Inherited from xRecord.)

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

assetGroup

assetLedgerAccount

assetLedgerOffsetAccount

Book

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

caption

(Inherited from xRecord.)

checkMainAssetId

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

clear

(Inherited from xRecord.)

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

context

(Inherited from xRecord.)

createAssetBooksFromAssetGroup

createAssetDepBookBonusFromAssetGroup

createAssetDepBooksFromAssetGroup

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

defaultBookId

delete

(Inherited from xRecord.)

Dimension

disableCache

(Inherited from xRecord.)

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

hasOpenAssetBook

Calls the AssetBook::hasOpenBookForAsset method to check if any asset book with a status of Open is assigned to Fixed Asset.

helpField

(Inherited from xRecord.)

initAssetNumberSeq

initBarcodeNumberSeq

initFromAssetGroupId

initValue

Initializes the row with predefined values upon new record creation.

insert

isFormDataSource

(Inherited from xRecord.)

isTmp

(Inherited from xRecord.)

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

merge

(Inherited from xRecord.)

modifiedField

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

postingProfile

postLoad

(Inherited from xRecord.)

primaryValueModelForAssetProject

Calls the AssetBook::getPrimaryBookForAssetProject method.

primaryValueModelStatusForAssetProject

Returns the status of the value model (AssetBook) of a fixed asset record.

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

renamePrimaryKey

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setNameAlias

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

suppressWarnings

(Inherited from xRecord.)

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

TopMainAsset

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

update

usageCount

(Inherited from xRecord.)

ValidateDelete

Determines whether the current record is valid and ready to be deleted from the database.

validateField

(Inherited from xRecord.)

ValidateWrite

Determines whether the current record is valid and ready to be written to the database.

valueModelsCurrent

valueModelsOperations

valueModelsTax

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

write

(Inherited from xRecord.)

xml

(Inherited from xRecord.)

::checkExist

::childList

::depreciatingAncestor

::depreciatingDepBookAncestor

::exist

::find

::groupId

::isLowValuePoolAsset

Determines if the asset contains any value models or depreciation books which use the low value pool depreciation method.

::lookupAccountNum

::lookupAccountNumConsumption

::lookupAccountNumLVP

Opens the Asset lookup window which will restrict assets to those that contain a value model or depreciation book that uses a low value pool depreciation method.

::treeImage

::txtNotExist

Gets the message to use when a specific record in the AssetTable table does not exist.

Fields

Field

ID

Type

Configuration key

Description

AssetId

1

Extended Data Type: AssetId

Type: str

Asset

Unique key for identification of fixed asset. The key is used when creating new assets.

AssetGroup

2

Extended Data Type: AssetGroupId

Type: str

Asset

Identify the fixed asset group.

Name

5

Extended Data Type: AssetName

Type: str

Asset

Describe the fixed asset.

Location

6

Extended Data Type: AssetLocationId

Type: str

Asset

Location of the fixed asset.

Documents

12

Extended Data Type: Filename

Type: str

None

Location of documents regarding the fixed asset.

SerialNum

13

Extended Data Type: Num

Type: str

None

Serial number for this fixed asset.

InsurancePolicyNum

14

Extended Data Type: AssetInsurancePolicyNum

Type: str

Asset

Insurance policy number of the fixed asset.

InsuredValue

15

Extended Data Type: AssetInsuredValue

Type: real

Asset

Value that the fixed asset is insured for.

Make

16

Extended Data Type: Name

Type: str

None

Name of the manufacturer of the item.

Model

17

Extended Data Type: Name

Type: str

None

Model number of the item.

GuaranteeDate

18

Extended Data Type: AssetTransDate

Type: date

Asset

Date of the start of the guarantee for this fixed asset.

MainAssetId

19

Extended Data Type: AssetIdMain

Type: str

Asset

The main fixed asset that this fixed asset uses as its parent.

Responsible

22

Extended Data Type: AssetEmplId

Type: str

Asset

Employee who is responsible for the fixed asset.

AssetType

24

Enumeration: AssetType

Asset

Type of fixed asset.

Quantity

25

Extended Data Type: AssetQuantity

Type: real

Asset

The number of units

Barcode

31

Extended Data Type: AssetBarcode

Type: str

Asset

Bar code of the asset.

UnitOfMeasure

34

Extended Data Type: AssetUnitOfMeasure

Type: str

Asset

The common unit of measure for the item, for example, dozen, case, or each

InsuranceDate1

35

Extended Data Type: AssetInsuranceDate1

Type: date

Asset

Insurance date field used to keep check on insurance end dates, etc.

InsuranceDate2

36

Extended Data Type: AssetInsuranceDate2

Type: date

Asset

Insurance date field used to keep check on insurance end dates, etc.

AssetReplaceCost

41

Extended Data Type: AssetReplaceCost

Type: real

Asset

Cost to replace this fixed asset.

SortingId

43

Extended Data Type: AssetSortingId

Type: str

Asset

Alternative sort field for the fixed asset.

TaxCountyNO

44

Extended Data Type: AssetTaxCountyNO

Type: str

CRSENorway

Municipality that the fixed asset will be reported to for tax purposes.

SubventionNO

45

Extended Data Type: AssetSubventionNO

Type: real

CRSENorway

Taxable contribution to the fixed asset.

SubventionTaxFreeNO

46

Extended Data Type: AssetSubventionTaxFreeNO

Type: real

CRSENorway

Tax-free contribution to the fixed asset.

AssessmentNO

47

Extended Data Type: AssetAssessmentNO

Type: real

CRSENorway

Tax assessment value of the fixed asset.

AssessmentTaxNO

48

Extended Data Type: AssetAssessmentTaxNO

Type: real

CRSENorway

Value for tax purposes of the fixed asset.

AcquisitionValueNO

49

Extended Data Type: AssetAcquisitionValueNO

Type: real

CRSENorway

Acquisition value of the fixed asset for tax purposes.

ValueAt19840101NO

50

Extended Data Type: AssetValueAt19840101NO

Type: real

CRSENorway

Value of the fixed asset as on January 1, 1984.

ReturnOnInvestmentsNO

51

Extended Data Type: AssetReturnOnInvestmentsNO

Type: real

CRSENorway

Origin of calculation of the return on capital.

SortingId2

52

Extended Data Type: AssetSortingId2

Type: str

Asset

Alternative sort field for the fixed asset.

SortingId3

53

Extended Data Type: AssetSortingId3

Type: str

Asset

Alternative sort field for the fixed asset.

NameAlias

54

Extended Data Type: AssetNameAlias

Type: str

Asset

Find fast name applying to the fixed asset.

TechInfo1

55

Extended Data Type: AssetTechInfo

Type: str

Asset

Field for technical information.

TechInfo2

56

Extended Data Type: AssetTechInfo

Type: str

Asset

Field for technical information.

TechInfo3

57

Extended Data Type: AssetTechInfo

Type: str

Asset

Field for technical information.

LastMaintenance

58

Extended Data Type: AssetLastMaintenance

Type: date

Asset

Date of last maintenance.

NextMaintenance

59

Extended Data Type: AssetNextMaintenance

Type: date

Asset

Date of next maintenance.

MaintenanceInfo1

60

Extended Data Type: AssetMaintenanceInfo

Type: str

Asset

Field with update information.

MaintenanceInfo2

61

Extended Data Type: AssetMaintenanceInfo

Type: str

Asset

Field with update information.

MaintenanceInfo3

62

Extended Data Type: AssetMaintenanceInfoMemo

Type: str

Asset

Field with update information.

PhysicalInventory

63

Extended Data Type: AssetPhysicalInventory

Type: date

Asset

Date of last physical inventory of this fixed asset.

Reference

64

Extended Data Type: AssetReference

Type: str

Asset

Comment to physical inventory.

Notes

65

Extended Data Type: AssetNotes

Type: str

Asset

Comment to physical inventory.

UnitCost

66

Extended Data Type: AssetUnitCost

Type: real

Asset

The cost per unit

PurchLineRecId

68

Extended Data Type: PurchLineRefRecId

Type: int64

LogisticsBasic

Reference field in a different table.

MajorType

100

Extended Data Type: AssetMajorTypeId

Type: str

None

Identify a top-level asset classification for reporting purposes only, for example, street, land, or sewer.

ParcelId

101

Extended Data Type: AssetParcelId

Type: str

None

If the asset is land, enter the identifier for the parcel, which is a plot of land. For example, enter 01-6211421.

PropertyType

102

Extended Data Type: AssetPropertyTypeId

Type: AssetPropertyType

None

Identify the type of property that the asset is.

GISReferenceNumber

103

Extended Data Type: AssetGISReferenceNumber

Type: str

None

Enter the Geographic Information System reference number, which indicates the exact location within the GIS layer for the asset.

LocationMemo

104

Extended Data Type: AssetLongDescription

Type: str

None

Notes about the location of the asset.

RoomNumber

105

Extended Data Type: AssetRoomNumber

Type: str

None

Enter the room number where the asset is located.

ContactName

106

Extended Data Type: AssetContactName

Type: str

Asset

Enter the name of an individual who might know more information about the asset.

ModelYear

107

Extended Data Type: AssetModelYear

Type: str

None

Enter the year that the item was built.

DisposalRestriction

108

Extended Data Type: AssetLongDescription

Type: str

None

Enter any restrictions for properly disposing of the asset.

Lease

109

Extended Data Type: AssetLongDescription

Type: str

None

If the asset is leased, enter notes about the lease.

TitleHolder

110

Extended Data Type: AssetTitleHolder

Type: str

None

Identify the agency that holds the title for the asset.

InsuranceVendor

111

Extended Data Type: VendAccount

Type: str

None

Identify the insurance company that insures the asset.

InsuranceAgent

112

Extended Data Type: AssetInsuranceAgent

Type: str

None

Identify the insurance agent for the asset.

PolicyExpiration

113

Extended Data Type: AssetPolicyExpiration

Type: date

None

Enter the expiration date on the insurance policy for the asset.

PolicyAmount

114

Extended Data Type: AssetPolicyAmount

Type: real

None

Enter the amount that the asset is insured for.

LastFactorUpdateDate

115

Extended Data Type: AssetLastFactorUpdateDate

Type: date

None

Displays the date the replacement cost or insured value was last updated using the fixed asset periodic process.

InsuredAtMarketValue

116

Extended Data Type: NoYesId

Type: NoYes

None

Is the asset insured at its fair market value?

Condition

117

Extended Data Type: AssetConditionId

Type: str

None

Identify the current condition of the asset, for example, poor, good, or excellent.

modifiedDateTime

61440

System Data Type: modifiedDateTime

Type: utcdatetime

None

dEL_ModifiedTime

61441

System Data Type: dEL_ModifiedTime

Type: int

None

modifiedBy

61442

System Data Type: modifiedBy

Type: str

None

createdDateTime

61444

System Data Type: createdDateTime

Type: utcdatetime

None

dEL_CreatedTime

61445

System Data Type: dEL_CreatedTime

Type: int

None

createdBy

61446

System Data Type: createdBy

Type: str

None

dataAreaId

61448

System Data Type: dataAreaId

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Groups

Field Group

Fields

AutoLookup

AssetId

Name

AssetGroup

AutoReport

AssetId

AssetGroup

Name

NameAlias

Location

MajorType

Description

Name

NameAlias

Disposal

DisposalRestriction

Documents

Documents

Identification

AssetGroup

AssetId

Insurance

InsuranceVendor

InsuranceAgent

Inventory

PhysicalInventory

ContactName

Lease

Lease

TitleHolder

MainAsset

MainAssetId

Mapping

GISReferenceNumber

ParcelId

Model

Make

Model

ModelYear

SerialNum

GuaranteeDate

TechInfo1

TechInfo2

TechInfo3

Municipality

TaxCountyNO

Other

ReturnOnInvestmentsNO

AcquisitionValueNO

ValueAt19840101NO

Physical

Location

LocationMemo

RoomNumber

Responsible

Barcode

Policy

InsurancePolicyNum

PolicyExpiration

PolicyAmount

InsuredValue

AssetReplaceCost

LastFactorUpdateDate

InsuranceDate1

InsuranceDate2

InsuredAtMarketValue

PurchaseOrders

PurchLineRecId

Quantity

Quantity

UnitOfMeasure

UnitCost

Reference

Reference

Notes

Sorting

SortingId

SortingId2

SortingId3

Subventions

SubventionNO

SubventionTaxFreeNO

Type

AssetType

MajorType

PropertyType

Update

LastMaintenance

NextMaintenance

MaintenanceInfo1

MaintenanceInfo2

MaintenanceInfo3

Condition

ValueModelGroup

AssetId

Name

primaryValueModelStatusForAssetProject

primaryValueModelForAssetProject

Values

AssessmentNO

AssessmentTaxNO

Warehouse

Relations

Relation

Table

Lines

AssetCondition

AssetCondition Table

AssetTable.Condition == AssetCondition.Condition

AssetGroup

AssetGroup Table

AssetTable.AssetGroup == AssetGroup.GroupId

AssetLocation

AssetLocation Table

AssetTable.Location == AssetLocation.Location

AssetMajorType

AssetMajorType Table

AssetTable.MajorType == AssetMajorType.MajorType

AssetSorting

AssetSorting Table

AssetTable.SortingId == AssetSorting.SortingId

0 == AssetSorting.SortCode

AssetTable

AssetTable Table

AssetTable.AssetId == AssetTable.AssetId

DataArea

DataArea Table

AssetTable.dataAreaId == DataArea.id

EmplTable

EmplTable Table

AssetTable.ContactName == EmplTable.EmplId

PurchLine

PurchLine Table

AssetTable.PurchLineRecId == PurchLine.RecId

Unit

Unit Table

AssetTable.UnitOfMeasure == Unit.UnitId

VendTable

VendTable Table

AssetTable.InsuranceVendor == VendTable.AccountNum

Indexes

Index

AllowDuplicates

Enabled

Fields

AssetNumIdx

No

Yes

AssetId

GroupAssetIdx

No

Yes

AssetGroup

AssetId

MainAssetIdx

Yes

Yes

MainAssetId

AssetId

NameAliasIdx

Yes

Yes

NameAlias

RecId

No

Yes

RecId

See Also

Table Methods

Tables Overview