| 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
|
|
|
|
|
|
|
|
|
|
|
|
|