| 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 |
|
ChildComponentIDs
|
ChildComponentIDs
|
String
|
|
1000
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code
|
Code
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
CompanyCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryCode
|
CountryCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 | | M,24003,Monthly | | Q,24005,Quarterly | | A,29673,Half-yearly | | Y,29672,Yearly | | B,0,Biannual |
|
| 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 |
|
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 |
|
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 | | B,30355,Bi-weekly | | S,0,Semi-monthly |
|
|
PaymentTerm
|
PaymentTerm
|
String
|
|
1
|
0
|
D
|
|
|
|
|
|
|
|
|
|
|
| D,8521,Default | | M,24003,Monthly | | Q,24005,Quarterly | | Y,29672,Yearly |
|
|
Payroll
|
Payroll
|
Boolean
|
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
|
Percentage
|
Percentage
|
Number
|
|
8
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
|
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 |
|
| 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
|
|
|
|
|
|
|
|
|
|
|
|
|