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