Property starting with A |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
AccountNumberBank
|
Account Number Bank
|
Account Number Bank
|
String
|
|
AccountNumberBank
|
|
|
|
|
AccountNumberBankDescription
|
|
|
String
|
|
AccountNumberBankDescription
|
|
|
|
|
AccountNumberBankMask
|
|
|
String
|
|
AccountNumberBankMask
|
|
|
|
|
AccountSequenceNumber
|
Account Sequence Number
|
Account Sequence Number
|
String
|
|
AccountSequenceNumber
|
|
|
|
|
AccountWebsite
|
|
|
String
|
|
AccountWebsite
|
|
|
|
|
ActiveLineDisplayText
|
|
|
String
|
|
ActiveLineDisplayText
|
|
|
|
|
AmountLimit
|
|
|
Number
|
|
AmountLimit
|
|
|
|
|
Property starting with B |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
BankAccount
|
Number
|
Number
|
String
|
|
BankAccount
|
|
|
|
|
BankAccountIncludingMask
|
Account Number
|
Account Number
|
String
|
|
BankAccountIncludingMask
|
|
|
|
|
BankAccountReference
|
Instrument Number
|
Instrument Number
|
String
|
|
BankAccountReference
|
|
|
|
|
BankAccountSubType
|
Bank account subtype
|
Bank account subtype
|
String
|
|
BankAccountSubType
|
|
|
|
|
BankAccountType
|
Type
|
Type
|
String
|
|
BankAccountType
|
|
|
|
|
BankAddress1
|
Address 1
|
Address 1
|
String
|
|
BankAddress1
|
|
|
|
|
BankAddress2
|
Address 2
|
Address 2
|
String
|
|
BankAddress2
|
|
|
|
|
BankCity
|
City
|
City
|
String
|
|
BankCity
|
|
|
|
|
BankCode
|
|
|
String
|
|
BankCode
|
|
|
|
|
BankCountryCode
|
|
|
String
|
|
BankCountryCode
|
|
|
|
|
BankCreditorCode
|
|
|
String
|
|
BankCreditorCode
|
|
|
|
|
BankName
|
|
|
String
|
|
BankName
|
|
|
|
|
BankPostCode
|
Postcode
|
Postcode
|
String
|
|
BankPostCode
|
|
|
|
|
BankSubscribed
|
Bank subscribed
|
Bank subscribed
|
Boolean
|
|
BankSubscribed
|
|
|
|
|
BankTelephone
|
Telephone
|
Telephone
|
String
|
|
BankTelephone
|
|
|
|
|
BankType
|
|
|
String
|
|
BankType
|
|
|
|
|
BICCode
|
|
|
String
|
|
BICCode
|
|
|
|
|
Blocked
|
|
|
Number
|
|
Blocked
|
|
|
|
|
BranchCode
|
Branch code
|
Branch code
|
String
|
|
BranchCode
|
|
|
|
|
Property starting with C |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
CardReader
|
Card reader
|
Card reader
|
String
|
|
CardReader
|
|
|
|
|
CardReaderPort
|
Port
|
Port
|
String
|
|
CardReaderPort
|
|
|
|
|
Cashier
|
|
|
String
|
|
Cashier
|
|
|
|
|
ClearanceIdentification
|
Clearance identification
|
Clearance identification
|
String
|
|
ClearanceIdentification
|
|
|
|
|
ClientID
|
|
|
String
|
|
ClientID
|
|
|
|
|
CollectionsPermission
|
Collections
|
Collections
|
Boolean
|
|
CollectionsPermission
|
|
|
|
|
ColumnField0
|
Column
|
Column
|
String
|
|
ColumnField0
|
|
|
|
|
ColumnField1
|
Column
|
Column
|
String
|
|
ColumnField1
|
|
|
|
|
ColumnField10
|
Column
|
Column
|
String
|
|
ColumnField10
|
|
|
|
|
ColumnField2
|
Column
|
Column
|
String
|
|
ColumnField2
|
|
|
|
|
ColumnField3
|
Column
|
Column
|
String
|
|
ColumnField3
|
|
|
|
|
ColumnField4
|
Column
|
Column
|
String
|
|
ColumnField4
|
|
|
|
|
ColumnField5
|
Column
|
Column
|
String
|
|
ColumnField5
|
|
|
|
|
ColumnField6
|
Column
|
Column
|
String
|
|
ColumnField6
|
|
|
|
|
ColumnField7
|
Column
|
Column
|
String
|
|
ColumnField7
|
|
|
|
|
ColumnField8
|
Column
|
Column
|
String
|
|
ColumnField8
|
|
|
|
|
ColumnField9
|
Column
|
Column
|
String
|
|
ColumnField9
|
|
|
|
|
ColumnWidth0
|
Width
|
Width
|
Number
|
|
ColumnWidth0
|
|
|
|
|
ColumnWidth1
|
Width
|
Width
|
Number
|
|
ColumnWidth1
|
|
|
|
|
ColumnWidth10
|
Width
|
Width
|
Number
|
|
ColumnWidth10
|
|
|
|
|
ColumnWidth2
|
Width
|
Width
|
Number
|
|
ColumnWidth2
|
|
|
|
|
ColumnWidth3
|
Width
|
Width
|
Number
|
|
ColumnWidth3
|
|
|
|
|
ColumnWidth4
|
Width
|
Width
|
Number
|
|
ColumnWidth4
|
|
|
|
|
ColumnWidth5
|
Width
|
Width
|
Number
|
|
ColumnWidth5
|
|
|
|
|
ColumnWidth6
|
Width
|
Width
|
Number
|
|
ColumnWidth6
|
|
|
|
|
ColumnWidth7
|
Width
|
Width
|
Number
|
|
ColumnWidth7
|
|
|
|
|
ColumnWidth8
|
Width
|
Width
|
Number
|
|
ColumnWidth8
|
|
|
|
|
ColumnWidth9
|
Width
|
Width
|
Number
|
|
ColumnWidth9
|
|
|
|
|
CompanyCode
|
|
|
String
|
|
CompanyCode
|
|
|
|
|
CompanyCountry
|
|
|
String
|
|
CompanyCountry
|
|
|
|
|
CompanyName
|
|
|
String
|
|
CompanyName
|
|
|
|
|
CompanyNameChanged
|
Company name changed
|
Company name changed
|
Boolean
|
|
CompanyNameChanged
|
|
|
|
|
ContactEmail
|
|
|
String
|
|
ContactEmail
|
|
|
|
|
ContactFaxNumber
|
|
|
String
|
|
ContactFaxNumber
|
|
|
|
|
ContactID
|
|
|
GUID
|
|
ContactID
|
|
|
|
|
ContactInitials
|
|
|
String
|
|
ContactInitials
|
|
|
|
|
ContactLastName
|
|
|
String
|
|
ContactLastName
|
|
|
|
|
ContactName
|
Name
|
Name
|
String
|
|
ContactName
|
|
|
|
|
ContactPredCode
|
Title
|
Title
|
String
|
|
ContactPredCode
|
|
|
|
|
ContactTitle
|
|
|
String
|
|
ContactTitle
|
|
|
|
|
ContactWebsite
|
|
|
String
|
|
ContactWebsite
|
|
|
|
|
ContractNumber
|
Contractnumber
|
Contractnumber
|
String
|
|
ContractNumber
|
|
|
|
|
CostsPaymentRun
|
|
|
Number
|
|
CostsPaymentRun
|
|
|
|
|
CostsPayments
|
|
|
Number
|
|
CostsPayments
|
|
|
|
|
CostsReceipts
|
|
|
Number
|
|
CostsReceipts
|
|
|
|
|
CountMandatory
|
|
|
Boolean
|
|
CountMandatory
|
|
|
|
|
Country
|
|
|
String
|
|
Country
|
|
|
|
|
CountryDescription
|
|
|
String
|
|
CountryDescription
|
|
|
|
|
CreatedByFullName
|
|
|
String
|
|
CreatedByFullName
|
|
|
|
|
CreatedDate
|
|
|
Date
|
|
CreatedDate
|
|
|
|
|
Creator
|
|
|
Number
|
|
Creator
|
|
|
|
|
CreditCardLimit
|
|
|
Number
|
|
CreditCardLimit
|
|
|
|
|
CreditCardType
|
|
|
String
|
|
CreditCardType
|
|
|
|
|
CreditInterest
|
|
|
Number
|
|
CreditInterest
|
|
|
|
|
CreditLine
|
Limit Amount
|
Limit Amount
|
Number
|
|
CreditLine
|
|
|
|
|
CreditorID
|
Creditor identifier
|
Creditor identifier
|
String
|
|
CreditorID
|
|
|
|
|
CreditorIDChanged
|
Creditor identifier changed
|
Creditor identifier changed
|
Boolean
|
|
CreditorIDChanged
|
|
|
|
|
CurrencyCode
|
Currency
|
Currency
|
String
|
|
CurrencyCode
|
|
|
|
|
CurrencyDescription
|
|
|
String
|
|
CurrencyDescription
|
|
|
|
|
CurrentBalance
|
Balance
|
Balance
|
Number
|
|
CurrentBalance
|
|
|
|
|
Property starting with D |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
DebitInterest
|
|
|
Number
|
|
DebitInterest
|
|
|
|
|
DebtorMandatory
|
|
|
Boolean
|
|
DebtorMandatory
|
|
|
|
|
Description
|
Description
|
Description
|
String
|
|
Description
|
|
|
|
|
DocumentAttachmentFilename
|
|
|
String
|
|
DocumentAttachmentFilename
|
|
|
|
|
DocumentAttachmentID
|
|
|
GUID
|
|
DocumentAttachmentID
|
|
|
|
|
DocumentNumber
|
|
|
String
|
|
DocumentNumber
|
|
|
|
|
DocumentSubject
|
|
|
String
|
|
DocumentSubject
|
|
|
|
|
Property starting with E |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
EFTPort
|
Port
|
Port
|
String
|
|
EFTPort
|
|
|
|
|
EFTTerminal
|
EFT Terminal
|
EFT Terminal
|
String
|
|
EFTTerminal
|
|
|
|
|
Excluding
|
Excluding
|
Excluding
|
Boolean
|
|
Excluding
|
|
|
|
|
ExpiryDate
|
Expiry Date
|
Expiry Date
|
Date
|
|
ExpiryDate
|
|
|
|
|
Property starting with F |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
FixedCostsPerYear
|
|
|
Number
|
|
FixedCostsPerYear
|
|
|
|
|
FontSize
|
Font Size
|
Font Size
|
Number
|
|
FontSize
|
|
|
|
|
Property starting with H |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
HashMethod
|
Security Summary Method
|
Security Summary Method
|
String
|
|
HashMethod
|
|
|
|
|
Header1
|
Header 1
|
Header 1
|
String
|
|
Header1
|
|
|
|
|
Header2
|
Header2
|
Header2
|
String
|
|
Header2
|
|
|
|
|
Header3
|
Header3
|
Header3
|
String
|
|
Header3
|
|
|
|
|
Header4
|
Header4
|
Header4
|
String
|
|
Header4
|
|
|
|
|
HumanResourceFullName
|
|
|
String
|
|
HumanResourceFullName
|
|
|
|
|
HumanResourceID
|
Employee
|
Employee
|
Number
|
|
HumanResourceID
|
|
|
|
|
Property starting with I |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
IBAN
|
|
|
String
|
|
IBAN
|
|
|
|
|
ID
|
|
|
Number
|
|
ID
|
|
|
|
|
IdentificationNumberBank
|
Identification
|
Identification
|
String
|
|
IdentificationNumberBank
|
|
|
|
|
IdentificationNumberBankOffice
|
Identification
|
Identification
|
String
|
|
IdentificationNumberBankOffice
|
|
|
|
|
InactiveLineDisplayText
|
|
|
String
|
|
InactiveLineDisplayText
|
|
|
|
|
InvoiceLayout
|
Layout
|
Layout
|
String
|
|
InvoiceLayout
|
|
|
|
|
Property starting with J |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Journal
|
|
|
String
|
|
Journal
|
|
|
|
|
Property starting with L |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
LastLetterOfCredit
|
|
|
String
|
|
LastLetterOfCredit
|
|
|
|
|
LastStatementDate
|
|
|
Date
|
|
LastStatementDate
|
|
|
|
|
LastStatementNumber
|
|
|
String
|
|
LastStatementNumber
|
|
|
|
|
LastValidYear
|
|
|
String
|
|
LastValidYear
|
|
|
|
|
LedgerAccount
|
G/L
|
G/L
|
String
|
|
LedgerAccount
|
|
|
|
|
LedgerAccountDescription
|
|
|
String
|
|
LedgerAccountDescription
|
|
|
|
|
LedgerAccountID
|
|
|
Number
|
|
LedgerAccountID
|
|
|
|
|
Property starting with M |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
MaximumAmount
|
|
|
Number
|
|
MaximumAmount
|
|
|
|
|
MaximumLines
|
|
|
Number
|
|
MaximumLines
|
|
|
|
|
MenuBar
|
Menu
|
Menu
|
String
|
|
MenuBar
|
|
|
|
|
MerchantKey
|
|
|
String
|
|
MerchantKey
|
|
|
|
|
MerchantNumber
|
|
|
String
|
|
MerchantNumber
|
|
|
|
|
ModifiedByFullName
|
|
|
String
|
|
ModifiedByFullName
|
|
|
|
|
ModifiedDate
|
|
|
Date
|
|
ModifiedDate
|
|
|
|
|
Modifier
|
|
|
Number
|
|
Modifier
|
|
|
|
|
Property starting with N |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
NameAddressDateBank
|
|
|
GUID
|
|
NameAddressDateBank
|
|
|
|
|
NameAddressDateBankName
|
Name
|
Name
|
String
|
|
NameAddressDateBankName
|
|
|
|
|
Notes
|
Notes
|
Notes
|
String
|
|
Notes
|
|
|
|
|
Property starting with O |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
OfficeName
|
Office
|
Office
|
String
|
|
OfficeName
|
|
|
|
|
OfficeNumber
|
Officenumber
|
Officenumber
|
String
|
|
OfficeNumber
|
|
|
|
|
OldCreditorID
|
Creditor identifier
|
Creditor identifier
|
String
|
|
OldCreditorID
|
|
|
|
|
Property starting with P |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
PaymentsPermission
|
Payments
|
Payments
|
Boolean
|
|
PaymentsPermission
|
|
|
|
|
PCChargeDirectory
|
|
|
String
|
|
PCChargeDirectory
|
|
|
|
|
PreAuthorizationLimit
|
|
|
Number
|
|
PreAuthorizationLimit
|
|
|
|
|
Preset
|
Preset
|
Preset
|
String
|
|
Preset
|
|
|
|
|
PrintLayout
|
Print
|
Print
|
Boolean
|
|
PrintLayout
|
|
|
|
|
ProcessorCode
|
|
|
String
|
|
ProcessorCode
|
|
|
|
|
Purpose
|
|
|
String
|
|
Purpose
|
|
|
|
|
Property starting with S |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
SCTBatchBook
|
Batch Booking SEPA Credit Transfer
|
Batch Booking SEPA Credit Transfer
|
Boolean
|
|
SCTBatchBook
|
|
|
|
|
SCTCurrency
|
|
|
String
|
|
SCTCurrency
|
|
|
|
|
SDDBatchBook
|
Batch Booking SEPA Direct Debit
|
Batch Booking SEPA Direct Debit
|
Boolean
|
|
SDDBatchBook
|
|
|
|
|
SentSEPADirectDebit
|
Sent SEPA direct debit
|
Sent SEPA direct debit
|
Boolean
|
|
SentSEPADirectDebit
|
|
|
|
|
StartDate
|
Start Date
|
Start Date
|
Date
|
|
StartDate
|
|
|
|
|
Suffix
|
Suffix
|
Suffix
|
String
|
|
Suffix
|
|
|
|
|
SupplierNumber
|
|
|
String
|
|
SupplierNumber
|
|
|
|
|
SWIFTCode
|
SWIFT Address
|
SWIFT Address
|
String
|
|
SWIFTCode
|
|
|
|
|
Property starting with T |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
TimeOut
|
|
|
Number
|
|
TimeOut
|
|
|
|
|
Trailer1
|
Trailer1
|
Trailer1
|
String
|
|
Trailer1
|
|
|
|
|
Trailer2
|
Trailer2
|
Trailer2
|
String
|
|
Trailer2
|
|
|
|
|
Trailer3
|
Trailer3
|
Trailer3
|
String
|
|
Trailer3
|
|
|
|
|
Trailer4
|
Trailer4
|
Trailer4
|
String
|
|
Trailer4
|
|
|
|
|
TransactionGroupType
|
|
|
String
|
|
TransactionGroupType
|
|
|
|
|
TransactionsPermission
|
Transactions
|
Transactions
|
Boolean
|
|
TransactionsPermission
|
|
|
|
|
Property starting with U |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Unallocated
|
|
|
String
|
|
Unallocated
|
|
|
|
|
UnallocatedDescription
|
|
|
String
|
|
UnallocatedDescription
|
|
|
|
|
UnallocatedID
|
|
|
Number
|
|
UnallocatedID
|
|
|
|
|
UseBankingGateway
|
Use banking gateway
|
Use banking gateway
|
Boolean
|
|
UseBankingGateway
|
|
|
|
|
UseSEPA
|
|
|
Number
|
|
UseSEPA
|
|
|
|
|
UseSEPADirectDebit
|
|
|
Number
|
|
UseSEPADirectDebit
|
|
|
|
|
Property starting with W |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Warehouse
|
Warehouse
|
Warehouse
|
String
|
|
Warehouse
|
|
|
|
|
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 |
AccountNumberBank
|
AccountNumberBank
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountNumberBankDescription
|
AccountNumberBankDesc
|
String
|
|
32
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountNumberBankMask
|
AccountNumberBankMask
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountSequenceNumber
|
AccountSeqNr
|
String
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountWebsite
|
AccountWebsite
|
String
|
|
128
|
0
|
-
|
|
|
|
|
|
|
|
|
|
|
|
ActiveLineDisplayText
|
ActiveLDPCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AmountLimit
|
LimitAmount
|
Number
|
|
16
|
4
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
BankAccountReference
|
BankAccountRef
|
String
|
|
34
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankAccountSubType
|
BankAccountSubType
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,8872,None | P,43012,Split payment account |
|
BankAccountType
|
BankAccountType
|
String
|
|
1
|
0
|
R
|
|
|
|
|
|
|
|
|
|
|
R,8371,Bank | K,3704,Cash | P,26947,Cash register | C,29633,Credit card | U,1067,Unknown |
|
BankAddress1
|
BankAddress1
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankAddress2
|
BankAddress2
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankCity
|
BankCity
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankCode
|
BankCmpCode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankCountryCode
|
BankCountryCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankCreditorCode
|
BankCrdCode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankName
|
BankName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankPostCode
|
BankPostCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankSubscribed
|
BankSubscribed
|
Boolean
|
|
1
|
0
|
|
0
|
1
|
|
|
|
|
|
|
|
|
|
BankTelephone
|
BankTelephone
|
String
|
|
15
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankType
|
BankType
|
String
|
|
1
|
0
|
B
|
|
|
|
|
|
|
|
|
|
|
|
BICCode
|
BICCode
|
String
|
|
11
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Blocked
|
Blocked
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
BranchCode
|
BranchCode
|
String
|
|
8
|
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 |
CardReader
|
cardreader
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
|
CardReaderPort
|
crdr_port
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Cashier
|
Cashier
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
|
ClearanceIdentification
|
ClearanceIdentification
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ClientID
|
ClientID
|
String
|
|
32
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CollectionsPermission
|
CollectionsPermission
|
Boolean
|
|
1
|
0
|
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ColumnField0
|
colfield0
|
String
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField1
|
colfield1
|
String
|
|
2
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField10
|
colfield10
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField2
|
colfield2
|
String
|
|
2
|
0
|
2
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField3
|
colfield3
|
String
|
|
2
|
0
|
3
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField4
|
colfield4
|
String
|
|
2
|
0
|
4
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField5
|
colfield5
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField6
|
colfield6
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField7
|
colfield7
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField8
|
colfield8
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnField9
|
colfield9
|
String
|
|
2
|
0
|
-1
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth0
|
colwidth0
|
Number
|
|
4
|
0
|
2490
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth1
|
colwidth1
|
Number
|
|
4
|
0
|
4470
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth10
|
colwidth10
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth2
|
colwidth2
|
Number
|
|
4
|
0
|
1605
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth3
|
colwidth3
|
Number
|
|
4
|
0
|
1170
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth4
|
colwidth4
|
Number
|
|
4
|
0
|
1560
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth5
|
colwidth5
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth6
|
colwidth6
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth7
|
colwidth7
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth8
|
colwidth8
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ColumnWidth9
|
colwidth9
|
Number
|
|
4
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
Division
|
String
|
|
3
|
0
|
COMPANY
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCountry
|
DivisionCountry
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyName
|
DivisionDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyNameChanged
|
CompanyNameChanged
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ContactEmail
|
ContactEmail
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactFaxNumber
|
ContactFaxNumber
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactID
|
ContactID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactInitials
|
ContactInitials
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactLastName
|
ContactLastName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactName
|
ContactName
|
String
|
|
70
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactPredCode
|
ContactPredCode
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactTitle
|
ContactTitle
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactWebsite
|
ContactWebsite
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractNumber
|
Contractnumber
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostsPaymentRun
|
CostsPaymentRun
|
Number
|
|
16
|
4
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
CostsPayments
|
CostsPayments
|
Number
|
|
16
|
4
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
CostsReceipts
|
CostsReceipts
|
Number
|
|
16
|
4
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
CountMandatory
|
CountMandatory
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Country
|
Country
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryDescription
|
CountryDescription
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedByFullName
|
CreatedByFullName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
CreatedDate
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
CreatedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreditCardLimit
|
CreditCardLimit
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditCardType
|
CreditCardType
|
String
|
|
60
|
0
|
V
|
|
|
|
|
|
|
|
|
|
|
A,0,American Express | D,0,Diners Club | O,0,Discover | E,0,EuroCard - MasterCard | M,0,MasterCard | V,0,VISA |
|
CreditInterest
|
CreditInterest
|
Number
|
|
8
|
5
|
0.00
|
0.00
|
100.00
|
|
|
|
|
|
|
|
|
|
CreditLine
|
CreditLine
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
CreditorID
|
CreditorID
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorIDChanged
|
CreditorIDChanged
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
CurrencyCode
|
CurrencyCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CurrencyDescription
|
CurrencyDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CurrentBalance
|
CurrentBalance
|
Number
|
|
16
|
4
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
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 |
DebitInterest
|
DebitInterest
|
Number
|
|
8
|
5
|
0.00
|
0.00
|
100.00
|
|
|
|
|
|
|
|
|
|
DebtorMandatory
|
DebtorMandatory
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Description
|
Description
|
String
|
|
32
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DocumentAttachmentFilename
|
DocumentAttachmentFilename
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DocumentAttachmentID
|
DocumentAttachmentID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DocumentNumber
|
DocumentNumber
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DocumentSubject
|
DocumentSubject
|
String
|
|
255
|
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 |
EFTPort
|
eftport
|
String
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
EFTTerminal
|
eftterminal
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
|
Excluding
|
Excluding
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ExpiryDate
|
ExpiryDate
|
Date
|
|
10
|
0
|
|
1753-01-01
|
9999-12-31
|
|
|
|
|
|
|
|
|
|
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 |
FixedCostsPerYear
|
FixedCostsPerYear
|
Number
|
|
16
|
4
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
FontSize
|
fontsize
|
Number
|
|
2
|
0
|
12
|
|
|
|
|
|
|
|
|
|
|
|
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 |
HashMethod
|
HashMethod
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
|
Header1
|
Header1
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Header2
|
Header2
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Header3
|
Header3
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Header4
|
Header4
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
HumanResourceFullName
|
HumanResourceFullName
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
HumanResourceID
|
HumanResourceID
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
IBAN
|
IBAN
|
String
|
|
34
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ID
|
ID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IdentificationNumberBank
|
IdentificationNumberBank
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IdentificationNumberBankOffice
|
IdentificationNumberBankOffice
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
InactiveLineDisplayText
|
InActiveLDPCode
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
InvoiceLayout
|
InvoiceLayout
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
Journal
|
Journal
|
String
|
|
3
|
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 |
LastLetterOfCredit
|
LastLetterOfCredit
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LastStatementDate
|
LastStatementDate
|
Date
|
|
10
|
0
|
|
1753-01-01
|
9999-12-31
|
|
|
|
|
|
|
|
|
|
LastStatementNumber
|
LastStatementNumber
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LastValidYear
|
LastValidYear
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerAccount
|
LedgerAccount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerAccountDescription
|
LedgerAccountDescription
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LedgerAccountID
|
LedgerAccountID
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
MaximumAmount
|
MaximumAmount
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
MaximumLines
|
MaximumLines
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MenuBar
|
menubar
|
String
|
|
1
|
0
|
R
|
|
|
|
|
|
|
|
|
|
|
|
MerchantKey
|
MerchantKey
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MerchantNumber
|
MerchantNumber
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedByFullName
|
ModifiedByFullName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
ModifiedDate
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
ModifiedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
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 |
NameAddressDateBank
|
NameAddressDateBank
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
NameAddressDateBankName
|
NameAddressDateBankName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Notes
|
Notes
|
String
|
|
8191
|
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 |
OfficeName
|
OfficeName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OfficeNumber
|
Officenumber
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OldCreditorID
|
OldCreditorID
|
String
|
|
40
|
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 |
PaymentsPermission
|
PaymentsPermission
|
Boolean
|
|
1
|
0
|
|
0
|
1
|
|
|
|
|
|
|
|
|
|
PCChargeDirectory
|
PCChargeDirectory
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PreAuthorizationLimit
|
PreAuthorizationLimit
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
Preset
|
preset
|
String
|
|
8
|
0
|
DEFAULT
|
|
|
|
|
|
|
|
|
|
|
|
PrintLayout
|
printlayout
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ProcessorCode
|
ProcessorCode
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Purpose
|
Purpose
|
String
|
|
1
|
0
|
B
|
|
|
|
|
|
|
|
|
|
|
B,5586,Both | C,6156,Collection | D,1340,Discount | I,223,Inflow | O,301,Outflow |
|
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 |
SCTBatchBook
|
SCTBatchBook
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
SCTCurrency
|
SCTCurrency
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SDDBatchBook
|
SDDBatchBook
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
SentSEPADirectDebit
|
SentSEPADirectDebit
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
StartDate
|
StartDate
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Suffix
|
Suffix
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SupplierNumber
|
SupplierNumber
|
String
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SWIFTCode
|
SWIFTCode
|
String
|
|
11
|
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 |
TimeOut
|
TimeOut
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Trailer1
|
Trailer1
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Trailer2
|
Trailer2
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Trailer3
|
Trailer3
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Trailer4
|
Trailer4
|
String
|
|
94
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TransactionGroupType
|
TransactionGroupType
|
String
|
|
1
|
0
|
G
|
|
|
|
|
|
|
|
|
|
|
G,35642,Grouped | M,30661,Mixed | S,34608,Single |
|
TransactionsPermission
|
TransactionsPermission
|
Boolean
|
|
1
|
0
|
|
0
|
1
|
|
|
|
|
|
|
|
|
|
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 |
Unallocated
|
Unallocated
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
UnallocatedDescription
|
UnallocatedDesc
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
UnallocatedID
|
UnallocatedID
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
UseBankingGateway
|
UseBankingGateway
|
Boolean
|
|
1
|
0
|
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseSEPA
|
UseSEPA
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
UseSEPADirectDebit
|
UseSEPADirectDebit
|
Number
|
|
1
|
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 |
Warehouse
|
warehouse
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|