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 |
AccountID
|
AccountID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AddPartHour
|
AddPartHour
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AddPartHourQuantity
|
AddPartHourQuantity
|
Number
|
|
10
|
2
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
AddPartHourType
|
AddPartHourType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
AgreementDocument
|
AgreementDocument
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AgreementSet
|
AgreementSet
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
ContractHeader
|
ContractHeader
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractRateID
|
ContractRateID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostCenter
|
CostCenter
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostCenterCode
|
CostCenterCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostUnitCode
|
CostUnitCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Created
|
Created
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
Creator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorFullName
|
CreatorFullName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Currency
|
Currency
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CurrencyID
|
CurrencyID
|
GUID
|
|
16
|
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 |
DefaultContractRateID
|
DefaultContractRateID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DefaultFrequency
|
DefaultFrequency
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
DefaultRate
|
DefaultRate
|
Number
|
|
12
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
DefaultRatePerPeriod
|
DefaultRatePerPeriod
|
Number
|
|
12
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
Description
|
Description
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Division
|
Division
|
GUID
|
|
16
|
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 |
EGPriceList
|
EGPriceList
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Enddate
|
Enddate
|
Date
|
|
8
|
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 |
GeneratedUntilDate
|
GeneratedUntilDate
|
Date
|
|
0
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
Invoice
|
Invoice
|
Boolean
|
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
InvoiceDate
|
InvoiceDate
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
InvoicedUntilDate
|
InvoicedUntilDate
|
Date
|
|
10
|
0
|
|
1753-01-01
|
9999-12-31
|
|
|
|
|
|
|
|
|
|
InvoiceFrequency
|
InvoiceFrequency
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
InvoiceRate
|
InvoiceRate
|
Number
|
|
12
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
IsChangedAgreementDocument
|
IsChangedAgreementDocument
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedAgreementSet
|
IsChangedAgreementSet
|
Number
|
|
3
|
0
|
|
0
|
255
|
|
|
|
|
|
|
|
|
|
IsChangedAgreementType
|
IsChangedAgreementType
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedInvoiceFrequency
|
IsChangedInvoiceFrequency
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedInvoiceRate
|
IsChangedInvoiceRate
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedPMType
|
IsChangedPMType
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedRateDiscount
|
IsChangedRateDiscount
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsChangedResponseTimeID
|
IsChangedResponseTimeID
|
Number
|
|
3
|
0
|
|
0
|
255
|
|
|
|
|
|
|
|
|
|
IsChangedStartDate
|
IsChangedStartDate
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsFromAgreementSet
|
IsFromAgreementSet
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
IsPercentage
|
IsPercentage
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Item
|
Item
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemQuantity
|
ItemQuantity
|
Number
|
|
10
|
2
|
|
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 |
LineDiscount
|
LineDiscount
|
Number
|
|
10
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
LineNumber
|
LineNumber
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LongDescription
|
LongDescription
|
String
|
|
0
|
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 |
MaintenanceType
|
MaintenanceType
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Modified
|
Modified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
Modifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierFullName
|
ModifierFullName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with O |
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 |
OldGeneratedUntilDate
|
OldGeneratedUntilDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OldInvoicedUntilDate
|
OldInvoicedUntilDate
|
Date
|
|
8
|
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 |
ParentAgreement
|
ParentAgreement
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PartsHoursAssortment
|
PartsHoursAssortment
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PartsHoursGroup
|
PartsHoursGroup
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PartsHoursIncluding
|
PartsHoursIncluding
|
Boolean
|
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PartsHoursPercentage
|
PartsHoursPercentage
|
Number
|
|
6
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PartsHoursPricelist
|
PartsHoursPricelist
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PartsHoursPriority
|
PartsHoursPriority
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PartsHoursSelection
|
PartsHoursSelection
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMContract
|
PMContract
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMDuration
|
PMDuration
|
Number
|
|
6
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PMStartNextRequest
|
PMStartNextRequest
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMStartTime
|
PMStartTime
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PMTime
|
PMTime
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMTimeInterval
|
PMTimeInterval
|
Number
|
|
6
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PMTimeUnits
|
PMTimeUnits
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMType
|
PMType
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PMUsage
|
PMUsage
|
Boolean
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
PMUsageInterval
|
PMUsageInterval
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PrepaidAmount
|
PrepaidAmount
|
Number
|
|
12
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PrepaidAmountRemaining
|
PrepaidAmountRemaining
|
Number
|
|
12
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PrepaidQuantity
|
PrepaidQuantity
|
Number
|
|
10
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PrepaidQuantityRemaining
|
PrepaidQuantityRemaining
|
Number
|
|
10
|
2
|
|
0
|
|
|
|
|
|
|
|
|
|
|
PrepaidSet
|
PrepaidSet
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Prepaidtype
|
Prepaidtype
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ProlongationType
|
ProlongationType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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 |
RateDiscount
|
RateDiscount
|
Number
|
|
3
|
2
|
|
0
|
100
|
|
|
|
|
|
|
|
|
|
Responsetime
|
Responsetime
|
Number
|
|
4
|
0
|
|
0
|
|
|
|
|
|
|
|
|
|
|
ResponsetimeID
|
ResponsetimeID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Responsetimeunit
|
Responsetimeunit
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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 |
ShortDescription
|
ShortDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Startdate
|
Startdate
|
Date
|
|
8
|
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 |
Type
|
Type
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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 |
VatCode
|
VatCode
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|