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 |
Account
|
Account
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountName
|
AccountName
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Activities
|
Activities
|
String
|
|
1000
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Amount
|
Amount
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Attachment
|
Attachment
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AutoLink
|
AutoLink
|
Boolean
|
|
0
|
0
|
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 |
BankAccount
|
BankAccount
|
String
|
|
34
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankAccountIncludingMask
|
BankAccountIncludingMask
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Blocked
|
Blocked
|
Boolean
|
|
0
|
0
|
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 |
CalculateCumulative
|
CumulatiefRekenen
|
String
|
|
1
|
0
|
Y
|
|
|
|
|
|
|
|
|
|
|
Y,0,Per jaar | P,0,Per periode |
|
CalculateEmployerCosts
|
CalculateEmployerCosts
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
CAOHours
|
CAOHours
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CAONumber
|
CAONumber
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | 1,0,SFB: CAO Bouw | 2,0,SFS: CAO Stukadoors | 3,0,SFB: CAO Natuursteen | 6,0,SFS: CAO Schilders | 9,0,SFB: CAO Timmerfabrieken |
|
CheckMaximum
|
CheckMaximum
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ChildComponentIDs
|
ChildComponentIDs
|
String
|
|
1000
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Code
|
Code
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
CompanyCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryCode
|
CountryCode
|
String
|
|
3
|
0
|
NL
|
|
|
|
|
|
|
|
|
|
|
|
CountryDescription
|
CountryDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
Created
|
Date
|
|
12
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
Creator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatorName
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorAccount
|
CreditorAccount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorCostCenter
|
CreditorCostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorCostCenterDescription
|
CreditorCostCenterDescription
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorCostUnit
|
CreditorCostUnit
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorCostUnitDescription
|
CreditorCostUnitDescription
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CurrencyCode
|
CurrencyCode
|
String
|
|
3
|
0
|
EUR
|
|
|
|
|
|
|
|
|
|
|
|
CurrencyDescription
|
CurrencyDescription
|
String
|
|
30
|
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 |
DaysPerWeek
|
DaysPerWeek
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DBFactorNotUTA
|
DBFactorNotUTA
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
DBFactorUTA
|
DBFactorUTA
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Description0
|
Description0
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description1
|
Description1
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description2
|
Description2
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description3
|
Description3
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description4
|
Description4
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DeviatingPercentage
|
DeviatingPercentage
|
Boolean
|
|
0
|
0
|
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 |
EditResourceLevel
|
EditResourceLevel
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
EndDate
|
EndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
Formula
|
Formula
|
String
|
|
2000
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Franchise
|
Franchise
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
FranchiseMaxwage
|
FranchiseMaxwage
|
String
|
|
1
|
0
|
D
|
|
|
|
|
|
|
|
|
|
|
U,0,Dag/uurfranchise | D,0,Dag | J,0,Jaar | K,0,Jaar (franchise herleiden) | L,0,Jaar (franchise en max. herleiden) | M,0,Jaar (franchise minimumloon) |
|
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 |
HourlyWage
|
HourlyWage
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IncludeInHourlyWage
|
IncludeInHourlyWage
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
IncludePayment
|
IncludeAfdracht
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
IsLimittedAmount
|
IsGrensbedrag
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
IsLimittedAmountMaxWage
|
IsGrensbedragMaxloon
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
IsVisible
|
IsVisible
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
N,6845,Advanced | A,5161,Always | V,5162,Never |
|
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 |
JobLevelCycle
|
JobLevelCycle
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,3502,N/A | P,31538,Periodically | A,29673,Half-yearly | Y,29672,Yearly | B,0,Tweejaarlijks |
|
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 |
LastPayPeriod
|
LastPayPeriod
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerAccount
|
LedgerAccount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerCostCenter
|
LedgerCostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerCostCenterDescription
|
LedgerCostCenterDescription
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerCostUnit
|
LedgerCostUnit
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerCostUnitDescription
|
LedgerCostUnitDescription
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerType
|
LedgerType
|
String
|
|
1
|
0
|
C
|
|
|
|
|
|
|
|
|
|
|
C,0,Creditor account | T,7777,Suspense account |
|
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 |
MaxAgeActive
|
MaxAgeActive
|
String
|
|
1
|
0
|
P
|
|
|
|
|
|
|
|
|
|
|
P,0,In de laatste periode | Y,0,Aan het begin van het jaar |
|
MaxHoursPerDay
|
MaxUrenPerDag
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
MaximumAge
|
MaximumAge
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MaxWage
|
MaxWage
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
MinAgeActive
|
MinAgeActive
|
String
|
|
1
|
0
|
P
|
|
|
|
|
|
|
|
|
|
|
P,0,In de periode | Y,0,Aan het begin van het jaar |
|
MinimumAge
|
MinimumAge
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MinimumWage
|
MinimumWage
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
Modified
|
Date
|
|
12
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
Modifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifierName
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
GUID
|
|
16
|
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 |
Origin
|
Origin
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,3502,N/A | C,10421,Contract | A,56,Actual | X,580,Commission invoice | T,8895,Time | I,9889,Item |
|
OriginalCode
|
OriginalCode
|
String
|
|
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 |
PaidBy
|
PaidBy
|
String
|
|
1
|
0
|
E
|
|
|
|
|
|
|
|
|
|
|
E,9551,Employee | R,5796,Employer |
|
ParentCode
|
ParentCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ParentCodeDescription
|
ParentCodeDescription
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentPeriod
|
PaymentPeriod
|
String
|
|
1
|
0
|
P
|
|
|
|
|
|
|
|
|
|
|
P,31538,Periodically | M,24003,Monthly | W,24228,Weekly | D,24227,Daily | H,29667,Hourly | Q,24005,Quarterly | A,29673,Half-yearly | Y,29672,Yearly | V,30356,4-weekly | O,6963,Once only |
|
PaymentTerm
|
PaymentTerm
|
String
|
|
1
|
0
|
D
|
|
|
|
|
|
|
|
|
|
|
D,8521,Default | M,24003,Monthly | Q,24005,Quarterly | Y,29672,Yearly |
|
PayPeriod
|
PayPeriod
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PayPeriodEndContract
|
PayPeriodEndContract
|
String
|
|
1
|
0
|
L
|
|
|
|
|
|
|
|
|
|
|
L,0,Uitbetalen laatste periode in dienst | M,0,Uitbetalen eerste periode uit dienst | N,0,Niet betalen | O,0,Niet betalen (wel in uitbetalingsperiode) | P,0,Niet betalen (wel indien gelijk aan einddatum uitbetalingsperiode) |
|
PayPeriodEndContractHours
|
PayPeriodEndContract_Hours
|
String
|
|
1
|
0
|
L
|
|
|
|
|
|
|
|
|
|
|
L,0,Huidige periode | M,0,Huidige anders vorige periode | V,0,Vorige periode |
|
PayPeriodEndContractNA
|
PayPeriodEndContract_NA
|
String
|
|
1
|
0
|
L
|
|
|
|
|
|
|
|
|
|
|
L,0,Standaard | M,0,Laatste periode in dienst | N,0,Eerste periode uit dienst |
|
Payroll
|
Payroll
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
PayrollLineType
|
Loonboekingstype
|
String
|
|
1
|
0
|
R
|
|
|
|
|
|
|
|
|
|
|
R,0,Regulier | S,0,Bijzonder | B,0,Regulier en Bijzonder |
|
Percentage
|
Percentage
|
Number
|
|
8
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
RegulationType
|
SoortRegeling
|
String
|
|
75
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ABP_OPNP,0,OP/NP | ABP_IPBW_HOOG,0,IPbw hoog | ABP_IPBW_LAAG,0,IPbw laag | ABP_FPU_BASIS,0,VUT/FPU basis | ABP_FPU_HOOG,0,FPU verhoogd | ABP_FPU_TOTAAL,0,FPU totaal | ABP_FPU_EXTRA,0,FPU extra | ABP_FP_OPBOUW,0,FP opbouwdeel | ABP_OP_IND_65,0,OP/NP individueel 65+ | ABP_OP_IND_WOU_25,0,OP/NP individueel WOU 25% | ABP_OP_IND_WOU_50,0,OP/NP individueel WOU 50% | ABP_VSG,0,VSG | ABP_FUR_STD,0,FUR standaard | ABP_FUR_AANV,0,FUR aanvullend | ABP_IPAP_GEDEELTE,0,IPAP gedeeltelijke dekking | ABP_IPAP_VOLLEDIG,0,IPAP volledige dekking | ABP_IPAP_BEIDE,0,IPAP beide dekkingen | ABP_PARTNERPLUS,0,PartnerPlus Pensioen |
|
RelateEntryamount
|
RelateEntryamount
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,0,Niet van toepassing | D,0,Deeltijdfactor | U,0,Gewerkte uren x uurloon | K,0,Kalenderdagen |
|
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 |
SequenceNumber
|
SequenceNumber
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Shipped
|
Shipped
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
StartDate
|
StartDate
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Status
|
Status
|
String
|
|
1
|
0
|
C
|
|
|
|
|
|
|
|
|
|
|
C,6483,Complete | I,385,Incomplete |
|
SubType
|
SubType
|
String
|
|
4
|
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 |
TaxdeclarationClass
|
Aangifterubriek
|
String
|
|
1
|
0
|
T
|
|
|
|
|
|
|
|
|
|
|
|
TransactionKey
|
TransactionKey
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Type
|
Type
|
String
|
|
1
|
0
|
F
|
|
|
|
|
|
|
|
|
|
|
B,8372,Bankaccount | D,29669,Deduction | F,30057,Financial component | I,0,In between calculation | M,0,More than one component | R,6058,Reservation | T,31629,Tax | E,2127,Prepayment |
|
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 |
Unit
|
Unit
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
A,4182,Amount | P,18828,Percentage |
|
UseAsPrepayment
|
UseAsPrepayment
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
UseDailyTable
|
UseDailyTable
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
UseInBTER
|
UseInBTER
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
UseRounding
|
UseRounding
|
Boolean
|
|
0
|
0
|
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 |
WageScaleType
|
WageScaleType
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|