Entity PayrollTransactionLine
Key property ID


Property starting with A
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
AmountCost Costs Costs Number
AmountToBePaid To be paid To be paid Number
AttachmentGUID GUID

Property starting with B
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
BankAccount Bank account Bank account String
BaseValue Number

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ChangeDescription String
ComponentCode String
ComponentGUID GUID
ComponentSubType Sub type Sub type String
ComponentType Type Type String
CostCenter CostCenter CostCenter String
CostUnit Cost unit Cost unit String
CountryNumberField1 Number
CountryNumberField2 Number
CountryNumberField3 Number
CountryTextField1 String
CreditorGLAccount String
CreditorGLCostCenter Cost center Cost center String
CreditorGLCostUnit Cost unit Cost unit String
CreditorNumber Creditor Creditor String
Currency Currency Currency String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
DeclarationDate Date
DeclarationMade Number
DeclarationNumber String
DeclarationPeriod Number
DeclarationSequence Number

Property starting with E
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
EntryAmount Amount Amount Number
EntryOrigin String
EntryPercentage Percentage Percentage Number

Property starting with F
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
FormulaField Formula Formula String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
GLAccount General ledger account General ledger account String

Property starting with H
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
HourlyWage Hourly wage Hourly wage Number

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ID Number

Property starting with L
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Local String

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
NoteGUID Notes Notes GUID
NumberField1 Number
NumberField2 Number
NumberField3 Number
NumberField4 Number
NumberField5 Number
NumberField6 Number
NumberOfDays Number of days Number of days Number
NumberOfDaysAbsent Number of days absent Number of days absent Number
NumberOfDaysComponent Number of days component Number of days component Number

Property starting with O
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
OurReference Our reference Our reference String

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
PaidBy Paid by Paid by String
PaymentPeriod Payment period Payment period String
Project Project Project String

Property starting with Q
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Quantity Number

Property starting with R
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ReferenceNumber1 String
ReferenceNumber2 String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
StateCode String
Status Status Status String

Property starting with T
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
TextField1 String
TextField2 String
TextField3 String
TextField4 String
TextField5 String
TextField6 String
TextField7 String
TextField8 String
TextField9 String
TransactionKey GUID

Property starting with U
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Unit Unit Unit String

Property starting with V
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
VoidDate Date

Property starting with Y
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
YesNoField1 Boolean
YesNoField10 Boolean
YesNoField11 Boolean
YesNoField12 Boolean
YesNoField13 Boolean
YesNoField14 Boolean
YesNoField15 Boolean
YesNoField16 Boolean
YesNoField17 Boolean
YesNoField18 Boolean
YesNoField2 Boolean
YesNoField3 Boolean
YesNoField4 Boolean
YesNoField5 Boolean
YesNoField6 Boolean
YesNoField7 Boolean
YesNoField8 Boolean
YesNoField9 Boolean
YourReference Your reference Your reference String

Detail information of properties

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
AmountCost amount_costs Number 11 2
AmountToBePaid amount_to_be_paid Number 11 2
AttachmentGUID DocAttachmentID GUID 16 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
BaseValue base_value Number 11 2

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
ChangeDescription deviating_descr50 String 50 0
ComponentCode comp_code String 8 0
ComponentGUID ComponentGuid GUID 16 0
ComponentSubType comp_sub_type String 4 0
ComponentType comp_type String 1 0 F
Exact.Repository.ERSelectionValue
CostCenter ledger_costcenter String 8 0
CostUnit ledger_costunit String 8 0
CountryNumberField1 calc_country_float1 Number 11 2
CountryNumberField2 calc_country_float2 Number 11 2
CountryNumberField3 calc_country_float3 Number 11 2
CountryTextField1 country_string1 String 75 0
CreditorGLAccount creditor_account String 9 0
CreditorGLCostCenter creditor_costcenter String 8 0
CreditorGLCostUnit creditor_costunit String 8 0
CreditorNumber creditor String 6 0
Currency currency String 3 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
DeclarationDate declaration_date Date 0 0
DeclarationMade declaration_made Number 1 0
DeclarationNumber declaration_number String 30 0
DeclarationPeriod declaration_period Number 4 0
DeclarationSequence declaration_sequence Number 4 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
EntryAmount entry_amount Number 11 2
EntryOrigin entryorigin String 1 0
Exact.Repository.ERSelectionValue
EntryPercentage entry_percentage Number 8 4

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
FormulaField formulafield String 2000 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
GLAccount ledger_account String 9 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 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

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
Local LocalCode String 4 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
NoteGUID notes GUID 16 0
NumberField1 country_float1 Number 11 2
NumberField2 country_float2 Number 11 2
NumberField3 country_float3 Number 11 2
NumberField4 country_float4 Number 11 2
NumberField5 country_float5 Number 11 2
NumberField6 country_float6 Number 11 2
NumberOfDays number_days_period Number 11 2
NumberOfDaysAbsent number_days_absent Number 11 2
NumberOfDaysComponent number_days_component Number 11 2

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
OurReference ourreference 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 paid_by String 1 0 E
Exact.Repository.ERSelectionValue
PaymentPeriod payment_period String 1 0 P
Exact.Repository.ERSelectionValue
Project project String 20 0

Property starting with Q
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
Quantity number Number 11 2

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
ReferenceNumber1 ReferenceNr1 String 20 0
ReferenceNumber2 ReferenceNr2 String 20 0

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
StateCode StateCode String 3 0
Status status String 1 0
Exact.Repository.ERSelectionValue

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
TextField1 country_char1 String 1 0
TextField2 country_char2 String 1 0
TextField3 country_char3 String 1 0
TextField4 country_char4 String 1 0
TextField5 country_char5 String 1 0
TextField6 country_char6 String 1 0
TextField7 country_char7 String 1 0
TextField8 country_char8 String 1 0
TextField9 country_char9 String 1 0
TransactionKey TransactionKey GUID 16 0

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
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
VoidDate VoidDate Date 0 0

Property starting with Y
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
YesNoField1 country_ny1 Boolean 0 0 1
YesNoField10 country_ny10 Boolean 0 0 1
YesNoField11 country_ny11 Boolean 0 0 1
YesNoField12 country_ny12 Boolean 0 0 1
YesNoField13 country_ny13 Boolean 0 0 1
YesNoField14 country_ny14 Boolean 0 0 1
YesNoField15 country_ny15 Boolean 0 0 1
YesNoField16 country_ny16 Boolean 0 0 1
YesNoField17 country_ny17 Boolean 0 0 1
YesNoField18 country_ny18 Boolean 0 0 1
YesNoField2 country_ny2 Boolean 0 0 1
YesNoField3 country_ny3 Boolean 0 0 1
YesNoField4 country_ny4 Boolean 0 0 1
YesNoField5 country_ny5 Boolean 0 0 1
YesNoField6 country_ny6 Boolean 0 0 1
YesNoField7 country_ny7 Boolean 0 0 1
YesNoField8 country_ny8 Boolean 0 0 1
YesNoField9 country_ny9 Boolean 0 0 1
YourReference yourreference String 20 0