Entity Asset
Key property ID


Property starting with A
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Active Boolean
Amount Number
AmountCurrency String
AmountForeignCurrency Number
AmountFreeField1 Number
AmountFreeField2 Number
AmountFreeField3 Number
AmountFreeField4 Number
AmountFreeField5 Number
AssetType Number
Attachment GUID

Property starting with B
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
BookValue Number
BookValueForeignCurrency Number

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Classification Classification Classification String
CompanyCode String
CompanyName String
CostCenter String
CostCenterDescription String
CostLastMaintenance Number
CostLastMaintenanceForeignCurrency Number
CostUnit String
CostUnitDescription String
CreatedByFullName String
CreatedDate Date
Creator Number
CurrentQuantityUnits Number
CustomerAccount GUID
CustomerAccountName String
CustomerCode String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
DateFreeField1 Date
DateFreeField2 Date
DateFreeField3 Investment Investment Date
DateFreeField4 Date
DateFreeField5 Date
DepreciationBaseDay Number
DepreciationBaseType String
DepreciationCode String
DepreciationEndDate Date
DepreciationMethodA String
DepreciationMethodADesc String
DepreciationMethodB String
DepreciationMethodBDesc String
DepreciationPeriods String
DepreciationStartDate Depreciation Depreciation Date
Description String
Description1 String
Description2 String
Description3 String
Description4 String

Property starting with E
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ExchangeRate Number

Property starting with F
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
FiscalGroup String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Group Asset group Asset group String
GroupDescription String

Property starting with H
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
HID Number

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ID GUID
IsBinaryServiceEnabled Boolean
Item String
ItemDescription String

Property starting with J
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
JournalDescription JournalDescription JournalDescription String
JournalID JournalID JournalID Number

Property starting with L
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
LastMaintenanceDate Date
LotNumber String

Property starting with M
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
MessageID GUID
MiscellaneousAmount Number
MiscellaneousAmountForeignCurrency Number
ModifiedByFullName ModifiedByFullName ModifiedByFullName String
ModifiedDate Date
Modifier Number

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Notes String
NotesGUID GUID
NumberFreeField1 Number
NumberFreeField2 Number
NumberFreeField3 Number
NumberFreeField4 Number
NumberFreeField5 Number

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ParentAssetDescription String
ParentAssetID GUID
PassengerCar Boolean
PictureFileName String
PriceList String
ProjectDescription String
ProjectNumber String
PropertyType String

Property starting with Q
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Quantity Number

Property starting with R
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ReceiptNumber String
ResidualValue Number
Resource Number
ResourceFullName String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
SalesOrderResourceFullName String
SerialNumber String
ShadowPrice Number
ShadowValid Number
SpecialCalculationBasis SpecialCalcBasis SpecialCalcBasis String
SpecialNumberPeriods SpecialNumPeriods SpecialNumPeriods String
SpecialNumberYears SpecialNumYears SpecialNumYears String
SpecialStartDate SpecialStartDate SpecialStartDate Date
Status Status Status String
Status2 Status2 Status2 String
StatusBudget Number
StatusPrice Number
StatusValid Number
SupplierAccount GUID
SupplierAccountName String
SupplierCode String
SupplierNumber String

Property starting with T
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Tangible Number
TextFreeField1 String
TextFreeField10 String
TextFreeField2 String
TextFreeField3 String
TextFreeField4 String
TextFreeField5 String
TextFreeField6 String
TextFreeField7 String
TextFreeField8 String
TextFreeField9 String
TransactionEntryNumber String
TransactionGUID GUID
TransactionID Number

Property starting with U
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
UseSpecial UseSpecial UseSpecial Boolean

Property starting with V
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
VATDescription String

Property starting with W
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
WarehouseDescription String

Property starting with Y
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
YesNoFreeField1 Boolean
YesNoFreeField2 Boolean

Detail information of properties

Property starting with A
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Active Active Boolean 1 0 1 0 1
Amount Amount Number 16 4 0.00
AmountCurrency AmountCurrency String 3 0
AmountForeignCurrency AmountFC Number 16 4 0
AmountFreeField1 AmountField1 Number 16 4 0.00
AmountFreeField2 AmountField2 Number 16 4 0.00
AmountFreeField3 AmountField3 Number 16 4 0.00
AmountFreeField4 AmountField4 Number 16 4 0.00
AmountFreeField5 AmountField5 Number 16 4 0.00
AssetType AssetType Number 10 0 0
Attachment Attachment GUID 16 0

Property starting with B
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
BookValue BookValue Number 16 4
BookValueForeignCurrency BookValueFC Number 16 4

Property starting with C
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Classification Classification String 1 0 F
CompanyCode Division String 3 0 COMPANY
CompanyName DivisionDescription String 60 0
CostCenter CostCenter String 8 0
CostCenterDescription CostCenterDescription String 50 0
CostLastMaintenance CostLastMaintenance Number 16 4
CostLastMaintenanceForeignCurrency CostLastMaintenanceFC Number 16 4
CostUnit CostUnit String 8 0
CostUnitDescription CostUnitDescription String 30 0
CreatedByFullName CreatedByFullName String 60 0
CreatedDate CreatedDate Date 8 0 NOW
Creator CreatedBy Number 10 0 HUMRESID
CurrentQuantityUnits CurrQtyUnits Number 4 0
CustomerAccount CustomerAccount GUID 16 0
CustomerAccountName CustomerAccountName String 50 0
CustomerCode CustomerCode String 20 0

Property starting with D
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
DateFreeField1 DateField1 Date 8 0
DateFreeField2 DateField2 Date 8 0
DateFreeField3 DateField3 Date 8 0
DateFreeField4 DateField4 Date 8 0
DateFreeField5 DateField5 Date 8 0
DepreciationBaseDay DepreciationBaseDay Number 2 0
DepreciationBaseType DepreciationBaseType String 1 0
O,21257,Open
C,4376,Calculated
A,17689,Approved
R,17691,Rejected
P,11949,Processed
H,1069,Historical
V,662,Void
T,0,To be void
S,21316,Static
DepreciationCode DeprCode String 1 0 A
A,0,Linear
R,0,Linear
DL,873,Degressive to linear
B,0,Degressive
HB,0,Manually Degressive
DF,0,Variable write off
F,0,Fixed Amount
Y,0,Sum of the year digits
N,0,Normal annuity method
M,0,Manually
P,0,Usage/Performance based
DepreciationEndDate DeprEndDate Date 8 0
DepreciationMethodA DepreciationMethodA String 20 0
DepreciationMethodADesc DepreciationMethodADesc String 50 0
DepreciationMethodB DepreciationMethodB String 20 0
DepreciationMethodBDesc DepreciationMethodBDesc String 50 0
DepreciationPeriods DeprPeriods String 4 0 12
DepreciationStartDate DeprStartDate Date 8 0
Description Description String 50 0
Description1 Description1 String 30 0
Description2 Description2 String 30 0
Description3 Description3 String 30 0
Description4 Description4 String 30 0

Property starting with E
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ExchangeRate ExchangeRate Number 16 4

Property starting with F
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
FiscalGroup FiscalGroup String 20 0

Property starting with G
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Group Group String 20 0 Select Top 1 assetgroup FROM fagrp
GroupDescription GroupDescription String 50 0

Property starting with H
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
HID HID Number 10 0

Property starting with I
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ID ID GUID 16 0
IsBinaryServiceEnabled IsBinaryServiceEnabled Boolean 1 0 0 0 1
Item Item String 30 0
ItemDescription ItemDescription String 60 0

Property starting with J
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
JournalDescription JournalDescription String 128 0
JournalID JournalID Number 10 0

Property starting with L
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
LastMaintenanceDate LastMaintenanceDate Date 0 0
LotNumber LotNumber String 30 0

Property starting with M
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
MessageID MessageID GUID 16 0
MiscellaneousAmount MiscellaneousAmount Number 16 4
MiscellaneousAmountForeignCurrency MiscellaneousAmountFC Number 16 4
ModifiedByFullName ModifiedByFullName String 60 0
ModifiedDate ModifiedDate Date 8 0 NOW
Modifier ModifiedBy Number 10 0 HUMRESID

Property starting with N
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Notes Notes String 8191 0
NotesGUID NotesGUID GUID 16 0
NumberFreeField1 ValueField1 Number 10 0 0
NumberFreeField2 ValueField2 Number 10 0 0
NumberFreeField3 ValueField3 Number 10 0 0
NumberFreeField4 ValueField4 Number 10 0 0
NumberFreeField5 ValueField5 Number 10 0 0

Property starting with P
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ParentAssetDescription ParentAssetDescription String 50 0
ParentAssetID ParentAssetID GUID 16 0
PassengerCar PassengerCar Boolean 1 0 0 0 1
PictureFileName PictureFileName String 128 0
PriceList PriceList String 15 0
ProjectDescription ProjectDescription String 60 0
ProjectNumber ProjectNr String 20 0
PropertyType PropertyType String 1 0 P
D,31569,Produced
E,31583,Leasehold
H,14283,Hire purchase
L,31579,Leased
M,22243,Maintenance
O,8887,Other
P,18207,Purchased
R,31568,Rented

Property starting with Q
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Quantity Quantity Number 10 0 1

Property starting with R
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
ReceiptNumber ReceiptNumber String 8 0
ResidualValue ResidualValue Number 16 4 0.00
Resource Resource Number 10 0
ResourceFullName ResourceFullName String 60 0

Property starting with S
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
SalesOrderResourceFullName SOResourceFullName String 60 0
SerialNumber SerialNumber String 20 0
ShadowPrice ShadowPrice Number 16 4
ShadowValid ShadowValid Number 4 0
SpecialCalculationBasis SpecialCalcBasis String 1 0
SpecialNumberPeriods SpecialNumPeriods String 4 0
SpecialNumberYears SpecialNumYears String 4 0
SpecialStartDate SpecialStartDate Date 8 0
Status Status String 1 0 A
A,2212,Active
B,1267,Blocked
C,5639,Depreciated
D,29544,Inactive
G,29,Not validated
S,6437,Sold
T,18832,Transfer
W,35098,Written Off
Status2 Status2 String 20 0
StatusBudget StatusBudget Number 4 0
StatusPrice StatusPrice Number 4 0
StatusValid StatusValid Number 4 0
SupplierAccount SupplierAccount GUID 16 0
SupplierAccountName SupplierAccountName String 60 0
SupplierCode SupplierCode String 6 0
SupplierNumber SupplierNumber String 6 0

Property starting with T
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
Tangible Tangible Number 1 0 1
TextFreeField1 TextField1 String 20 0
TextFreeField10 TextField10 String 20 0
TextFreeField2 TextField2 String 20 0
TextFreeField3 TextField3 String 20 0
TextFreeField4 TextField4 String 20 0
TextFreeField5 TextField5 String 20 0
TextFreeField6 TextField6 String 20 0
TextFreeField7 TextField7 String 20 0
TextFreeField8 TextField8 String 20 0
TextFreeField9 TextField9 String 20 0
TransactionEntryNumber TransactionEntryNo String 8 0
TransactionGUID TransactionGUID GUID 16 0
TransactionID TransactionID Number 10 0

Property starting with U
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
UseSpecial UseSpecial Boolean 1 0 0 0 1

Property starting with V
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
VATDescription VATDescription String 60 0

Property starting with W
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
WarehouseDescription WarehouseDescription String 10 0

Property starting with Y
Name Source name Type Mandatory Length Scale Default value Lower range Upper range Allowed characters Auto increment Numeric string Right aligned Unsigned Upper case Zero equals null Zero fill Selection values
YesNoFreeField1 OptionField1 Boolean 1 0 0 1
YesNoFreeField2 OptionField2 Boolean 1 0 0 1