Property starting with A |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Active
|
|
|
Boolean
|
|
Active
|
|
|
|
|
Amount
|
|
|
Number
|
|
Amount
|
|
|
|
|
AmountCurrency
|
|
|
String
|
|
AmountCurrency
|
|
|
|
|
AmountForeignCurrency
|
|
|
Number
|
|
AmountForeignCurrency
|
|
|
|
|
AmountFreeField1
|
|
|
Number
|
|
AmountFreeField1
|
|
|
|
|
AmountFreeField2
|
|
|
Number
|
|
AmountFreeField2
|
|
|
|
|
AmountFreeField3
|
|
|
Number
|
|
AmountFreeField3
|
|
|
|
|
AmountFreeField4
|
|
|
Number
|
|
AmountFreeField4
|
|
|
|
|
AmountFreeField5
|
|
|
Number
|
|
AmountFreeField5
|
|
|
|
|
AssetType
|
|
|
Number
|
|
AssetType
|
|
|
|
|
Attachment
|
|
|
GUID
|
|
Attachment
|
|
|
|
|
Property starting with B |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
BookValue
|
|
|
Number
|
|
BookValue
|
|
|
|
|
BookValueForeignCurrency
|
|
|
Number
|
|
BookValueForeignCurrency
|
|
|
|
|
Property starting with C |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Classification
|
Classification
|
Classification
|
String
|
|
Classification
|
|
|
|
|
CompanyCode
|
|
|
String
|
|
CompanyCode
|
|
|
|
|
CompanyName
|
|
|
String
|
|
CompanyName
|
|
|
|
|
CostCenter
|
|
|
String
|
|
CostCenter
|
|
|
|
|
CostCenterDescription
|
|
|
String
|
|
CostCenterDescription
|
|
|
|
|
CostLastMaintenance
|
|
|
Number
|
|
CostLastMaintenance
|
|
|
|
|
CostLastMaintenanceForeignCurrency
|
|
|
Number
|
|
CostLastMaintenanceForeignCurrency
|
|
|
|
|
CostUnit
|
|
|
String
|
|
CostUnit
|
|
|
|
|
CostUnitDescription
|
|
|
String
|
|
CostUnitDescription
|
|
|
|
|
CreatedByFullName
|
|
|
String
|
|
CreatedByFullName
|
|
|
|
|
CreatedDate
|
|
|
Date
|
|
CreatedDate
|
|
|
|
|
Creator
|
|
|
Number
|
|
Creator
|
|
|
|
|
CurrentQuantityUnits
|
|
|
Number
|
|
CurrentQuantityUnits
|
|
|
|
|
CustomerAccount
|
|
|
GUID
|
|
CustomerAccount
|
|
|
|
|
CustomerAccountName
|
|
|
String
|
|
CustomerAccountName
|
|
|
|
|
CustomerCode
|
|
|
String
|
|
CustomerCode
|
|
|
|
|
Property starting with D |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
DateFreeField1
|
|
|
Date
|
|
DateFreeField1
|
|
|
|
|
DateFreeField2
|
|
|
Date
|
|
DateFreeField2
|
|
|
|
|
DateFreeField3
|
Investment
|
Investment
|
Date
|
|
DateFreeField3
|
|
|
|
|
DateFreeField4
|
|
|
Date
|
|
DateFreeField4
|
|
|
|
|
DateFreeField5
|
|
|
Date
|
|
DateFreeField5
|
|
|
|
|
DepreciationBaseDay
|
|
|
Number
|
|
DepreciationBaseDay
|
|
|
|
|
DepreciationBaseType
|
|
|
String
|
|
DepreciationBaseType
|
|
|
|
|
DepreciationCode
|
|
|
String
|
|
DepreciationCode
|
|
|
|
|
DepreciationEndDate
|
|
|
Date
|
|
DepreciationEndDate
|
|
|
|
|
DepreciationMethodA
|
|
|
String
|
|
DepreciationMethodA
|
|
|
|
|
DepreciationMethodADesc
|
|
|
String
|
|
DepreciationMethodADesc
|
|
|
|
|
DepreciationMethodB
|
|
|
String
|
|
DepreciationMethodB
|
|
|
|
|
DepreciationMethodBDesc
|
|
|
String
|
|
DepreciationMethodBDesc
|
|
|
|
|
DepreciationPeriods
|
|
|
String
|
|
DepreciationPeriods
|
|
|
|
|
DepreciationStartDate
|
Depreciation
|
Depreciation
|
Date
|
|
DepreciationStartDate
|
|
|
|
|
Description
|
|
|
String
|
|
Description
|
|
|
|
|
Description1
|
|
|
String
|
|
Description1
|
|
|
|
|
Description2
|
|
|
String
|
|
Description2
|
|
|
|
|
Description3
|
|
|
String
|
|
Description3
|
|
|
|
|
Description4
|
|
|
String
|
|
Description4
|
|
|
|
|
Property starting with E |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ExchangeRate
|
|
|
Number
|
|
ExchangeRate
|
|
|
|
|
Property starting with F |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
FiscalGroup
|
|
|
String
|
|
FiscalGroup
|
|
|
|
|
Property starting with G |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Group
|
Asset group
|
Asset group
|
String
|
|
Group
|
|
|
|
|
GroupDescription
|
|
|
String
|
|
GroupDescription
|
|
|
|
|
Property starting with H |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
HID
|
|
|
Number
|
|
HID
|
|
|
|
|
Property starting with I |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ID
|
|
|
GUID
|
|
ID
|
|
|
|
|
IsBinaryServiceEnabled
|
|
|
Boolean
|
|
IsBinaryServiceEnabled
|
|
|
|
|
Item
|
|
|
String
|
|
Item
|
|
|
|
|
ItemDescription
|
|
|
String
|
|
ItemDescription
|
|
|
|
|
Property starting with J |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
JournalDescription
|
JournalDescription
|
JournalDescription
|
String
|
|
JournalDescription
|
|
|
|
|
JournalID
|
JournalID
|
JournalID
|
Number
|
|
JournalID
|
|
|
|
|
Property starting with L |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
LastMaintenanceDate
|
|
|
Date
|
|
LastMaintenanceDate
|
|
|
|
|
LotNumber
|
|
|
String
|
|
LotNumber
|
|
|
|
|
Property starting with M |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
MessageID
|
|
|
GUID
|
|
MessageID
|
|
|
|
|
MiscellaneousAmount
|
|
|
Number
|
|
MiscellaneousAmount
|
|
|
|
|
MiscellaneousAmountForeignCurrency
|
|
|
Number
|
|
MiscellaneousAmountForeignCurrency
|
|
|
|
|
ModifiedByFullName
|
ModifiedByFullName
|
ModifiedByFullName
|
String
|
|
ModifiedByFullName
|
|
|
|
|
ModifiedDate
|
|
|
Date
|
|
ModifiedDate
|
|
|
|
|
Modifier
|
|
|
Number
|
|
Modifier
|
|
|
|
|
Property starting with N |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Notes
|
|
|
String
|
|
Notes
|
|
|
|
|
NotesGUID
|
|
|
GUID
|
|
NotesGUID
|
|
|
|
|
NumberFreeField1
|
|
|
Number
|
|
NumberFreeField1
|
|
|
|
|
NumberFreeField2
|
|
|
Number
|
|
NumberFreeField2
|
|
|
|
|
NumberFreeField3
|
|
|
Number
|
|
NumberFreeField3
|
|
|
|
|
NumberFreeField4
|
|
|
Number
|
|
NumberFreeField4
|
|
|
|
|
NumberFreeField5
|
|
|
Number
|
|
NumberFreeField5
|
|
|
|
|
Property starting with P |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ParentAssetDescription
|
|
|
String
|
|
ParentAssetDescription
|
|
|
|
|
ParentAssetID
|
|
|
GUID
|
|
ParentAssetID
|
|
|
|
|
PassengerCar
|
|
|
Boolean
|
|
PassengerCar
|
|
|
|
|
PictureFileName
|
|
|
String
|
|
PictureFileName
|
|
|
|
|
PriceList
|
|
|
String
|
|
PriceList
|
|
|
|
|
ProjectDescription
|
|
|
String
|
|
ProjectDescription
|
|
|
|
|
ProjectNumber
|
|
|
String
|
|
ProjectNumber
|
|
|
|
|
PropertyType
|
|
|
String
|
|
PropertyType
|
|
|
|
|
Property starting with Q |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Quantity
|
|
|
Number
|
|
Quantity
|
|
|
|
|
Property starting with R |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ReceiptNumber
|
|
|
String
|
|
ReceiptNumber
|
|
|
|
|
ResidualValue
|
|
|
Number
|
|
ResidualValue
|
|
|
|
|
Resource
|
|
|
Number
|
|
Resource
|
|
|
|
|
ResourceFullName
|
|
|
String
|
|
ResourceFullName
|
|
|
|
|
Property starting with S |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
SalesOrderResourceFullName
|
|
|
String
|
|
SalesOrderResourceFullName
|
|
|
|
|
SerialNumber
|
|
|
String
|
|
SerialNumber
|
|
|
|
|
ShadowPrice
|
|
|
Number
|
|
ShadowPrice
|
|
|
|
|
ShadowValid
|
|
|
Number
|
|
ShadowValid
|
|
|
|
|
SpecialCalculationBasis
|
SpecialCalcBasis
|
SpecialCalcBasis
|
String
|
|
SpecialCalculationBasis
|
|
|
|
|
SpecialNumberPeriods
|
SpecialNumPeriods
|
SpecialNumPeriods
|
String
|
|
SpecialNumberPeriods
|
|
|
|
|
SpecialNumberYears
|
SpecialNumYears
|
SpecialNumYears
|
String
|
|
SpecialNumberYears
|
|
|
|
|
SpecialStartDate
|
SpecialStartDate
|
SpecialStartDate
|
Date
|
|
SpecialStartDate
|
|
|
|
|
Status
|
Status
|
Status
|
String
|
|
Status
|
|
|
|
|
Status2
|
Status2
|
Status2
|
String
|
|
Status2
|
|
|
|
|
StatusBudget
|
|
|
Number
|
|
StatusBudget
|
|
|
|
|
StatusPrice
|
|
|
Number
|
|
StatusPrice
|
|
|
|
|
StatusValid
|
|
|
Number
|
|
StatusValid
|
|
|
|
|
SupplierAccount
|
|
|
GUID
|
|
SupplierAccount
|
|
|
|
|
SupplierAccountName
|
|
|
String
|
|
SupplierAccountName
|
|
|
|
|
SupplierCode
|
|
|
String
|
|
SupplierCode
|
|
|
|
|
SupplierNumber
|
|
|
String
|
|
SupplierNumber
|
|
|
|
|
Property starting with T |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Tangible
|
|
|
Number
|
|
Tangible
|
|
|
|
|
TextFreeField1
|
|
|
String
|
|
TextFreeField1
|
|
|
|
|
TextFreeField10
|
|
|
String
|
|
TextFreeField10
|
|
|
|
|
TextFreeField2
|
|
|
String
|
|
TextFreeField2
|
|
|
|
|
TextFreeField3
|
|
|
String
|
|
TextFreeField3
|
|
|
|
|
TextFreeField4
|
|
|
String
|
|
TextFreeField4
|
|
|
|
|
TextFreeField5
|
|
|
String
|
|
TextFreeField5
|
|
|
|
|
TextFreeField6
|
|
|
String
|
|
TextFreeField6
|
|
|
|
|
TextFreeField7
|
|
|
String
|
|
TextFreeField7
|
|
|
|
|
TextFreeField8
|
|
|
String
|
|
TextFreeField8
|
|
|
|
|
TextFreeField9
|
|
|
String
|
|
TextFreeField9
|
|
|
|
|
TransactionEntryNumber
|
|
|
String
|
|
TransactionEntryNumber
|
|
|
|
|
TransactionGUID
|
|
|
GUID
|
|
TransactionGUID
|
|
|
|
|
TransactionID
|
|
|
Number
|
|
TransactionID
|
|
|
|
|
Property starting with U |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
UseSpecial
|
UseSpecial
|
UseSpecial
|
Boolean
|
|
UseSpecial
|
|
|
|
|
Property starting with V |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
VATDescription
|
|
|
String
|
|
VATDescription
|
|
|
|
|
Property starting with W |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
WarehouseDescription
|
|
|
String
|
|
WarehouseDescription
|
|
|
|
|
Property starting with Y |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
YesNoFreeField1
|
|
|
Boolean
|
|
YesNoFreeField1
|
|
|
|
|
YesNoFreeField2
|
|
|
Boolean
|
|
YesNoFreeField2
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|