Entity Account
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
Abbreviation Abbreviation Abbreviation String
AccountCode Code Code String
AccountEmployeeId Manager Manager Number
AccountEmployeeName String
AccountManagerID Manager Manager Number
AccountManagerName Name Name String
AccountManagerType Type Type String
AccountName Name Name String
AccountStatus String
AddExtraReceiptToOrder Add extra receipt to sales order Add extra receipt to sales order Boolean
AddressID String
AllowBackorder Back order Back order Boolean
AllowPartialDelivery Allow Partial Delivery Allow Partial Delivery Boolean
ApplyShippingCharges Boolean
ASPDatabase Database Database String
ASPDatabaseServer Server Server String
ASPWebsiteServer Website Website String
ASPWebsiteURL Website Website String
AttachUBL Attach UBL Attach UBL Boolean
Attention Notes Notes Boolean
AutoAllocate Boolean
AvalaraEntityUseCode Avalara entity use code Avalara entity use code String

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
BankAccountType String
Blocked Blocked Blocked Boolean
BOELimitAmount BOE limit BOE limit Number
BOEMaxAmount BOE Maximum BOE Maximum Number

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ChamberofCommerceNumber Chamber of Commerce Number Chamber of Commerce Number String
ChangeVatData Change Vat Data Change Vat Data Boolean
ChangeVatServices Change Vat Services Data Change Vat Services Data Boolean
CheckDate Check date Check date Date
CiscoDirectory String
CityOfLoadUnload City City String
ClassificationDescription Classification Classification String
ClassificationID Classification Classification String
CodeatSupplier Code at Supplier Code at Supplier String
CollectionInvoice Collection Collection String
CompanyCode Division Division String
CompanyCodeDebtorAccountID GUID
CompanyName String
CompanySize Size Size String
CompanyType Company type Company type Number
ContactAccountManager Manager Manager Number
ContactCompanyCode cnt_Administration cnt_Administration String
ContactCreatedDate cnt_DateCreated cnt_DateCreated Date
ContactCreator cnt_CreatedBy cnt_CreatedBy Number
ContactEmail E-mail E-mail String
ContactFaxNumber Fax Fax String
ContactFirstName First First String
ContactFullName Full name Full name String
ContactGender Gender Gender String
ContactID Contact Contact GUID
ContactInitials Initials Initials String
ContactLanguage Language Language String
ContactLanguageDescription Language description Language description String
ContactLastName Last Last String
ContactMiddleName Middle name Middle name String
ContactMobileNumber Mobile phone Mobile phone String
ContactModifiedDate cnt_DateModified cnt_DateModified Date
ContactModifier Modified by Modified by Number
ContactNumberFreeField1 Number Number Number
ContactNumberFreeField2 Number Number Number
ContactNumberFreeField3 Number Number Number
ContactNumberFreeField4 Number Number Number
ContactNumberFreeField5 Number Number Number
ContactPhoneNumber Phone Phone String
ContactTitle Title Title String
CountryOfAssembly String
CountryOfOrigin String
CreatedDate Date
Creator Number
CreatorName String
CreditabilityScenario Credit scenario Credit scenario String
CreditCardDescription Credit card desc Credit card desc String
CreditCardExpirationDate Date
CreditCardHolder Credit card Credit card String
CreditcardNumberReference Credit card number Credit card number String
CreditLine Credit line Credit line Number
CreditorCode Creditor code Creditor code String
CreditorNumber Creditor number Creditor number String
CreditorNumberReference Number Number String
CreditorType String
CurrencyCode Currency Currency String
CurrencyDescription String
CustomerID Customer Customer GUID
CustomerSince Since Since Date
CustomerStatus Status Status String
CustomerStatusDescription String
CustomerType Type Type String
CustomerTypeDescription String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
DateFreeField1 Date Date Date
DateFreeField2 Date Date Date
DateFreeField3 Date Date Date
DateFreeField4 Date Date Date
DateFreeField5 Date Date Date
DateLastReminder Date
DebtorAccountName String
DebtorCode Debtor code Debtor code String
DebtorCreditorAccount Centralization Account Centralization Account String
DebtorNumber Debtor number Debtor number String
DebtorNumberReference Debtor number Debtor number String
DefaultSelCode String
DefaultSelDescription String
DeleteBankAccount Number
DeliveryAddressline1 Address Address String
DeliveryAddressline2 Address Address String
DeliveryAddressline3 Address Address String
DeliveryCity City City String
DeliveryCountry Country Country String
DeliveryCounty County County String
DeliveryMethod Delivery method Delivery method String
DeliverymethodDescription String
DeliveryPostCode Postcode Postcode String
DeliveryState State State String
DeliveryTerms String
DestinationCountry String
Directory String
Discount Discount Discount Number
Document Document Document GUID
DocumentCreatedDate Date
DocumentCreator String
DocumentSubject Document Document String
DunBradstreetNumber D & B Number D & B Number String

Property starting with E
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
EmailAddress E-mail E-mail String
ESFContactID GUID
ExemptNumber Tax Exempt No Tax Exempt No String
Extension Extension Extension String
ExtraDescriptionName String
ExtraDuty Boolean
ExtraItemDescription Extra Item Description Extra Item Description String

Property starting with F
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
FaxNumber Fax Fax String
FedCategory 1099 Category 1099 Category String
FedIDNumber Fed. Id. No. Fed. Id. No. String
FedIDType Fed. Id. Type Fed. Id. Type String
FiscalCode String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
GroupDueDates String
GuidFreeField1 GUID
GuidFreeField2 GUID
GuidFreeField3 GUID
GuidFreeField4 GUID
GuidFreeField5 GUID

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ID GUID
IncoTermAcknowledgeOrder Acknowledge order Acknowledge order Boolean
IncoTermCode Incoterm Incoterm String
IncoTermConfirmPrices Confirm prices Confirm prices Boolean
IncoTermProperty Incoterm code Incoterm code String
IntegerFreeField1 Number
IntegerFreeField2 Number
IntegerFreeField3 Number
IntegerFreeField4 Number
IntegerFreeField5 Number
IntermediaryassociateID String
IntrastatSystem String
IntRegion String
InvoiceAddress Address Address String
InvoiceAddress2 Address Address String
InvoiceAddress3 Address Address String
InvoiceAddressPostCode Postcode Postcode String
InvoiceCity City City String
InvoiceCopies Number
InvoiceCountry Country Country String
InvoiceCounty County County String
InvoiceDebtor Invoice Invoice String
InvoiceMethod Invoicing method Invoicing method String
InvoiceState State State String
IsBinaryServiceEnabled Boolean
IsCommissionable Commissionable Commissionable Boolean
IsTaxExempted Boolean

Property starting with J
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
JobDescription Job description Job description String
JobTitle JobTitle JobTitle String
JobTitleDescription String
JournalCode Journal Journal String

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

Property starting with M
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Mailbox Mailbox Mailbox String
MailingAddress1 Address Address String
MailingAddress2 Address Address String
MailingAddress3 Address Address String
MailingCity City City String
MailingCountry Country Country String
MailingCountryDescription String
MailingCounty County County String
MailingPostcode Postcode Postcode String
MailingState State State String
MailingStateDescription String
ManagersCCDescription String
ManagersCostCenter String
MessageIDCompanyLogo GUID
MessageIDRemarks GUID
ModifiedDate Date
Modifier Number
ModifierName String

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
NumberFreeField1 Number Number Number
NumberFreeField2 Number Number Number
NumberFreeField3 Number Number Number
NumberFreeField4 Number Number Number
NumberFreeField5 Number Number Number

Property starting with O
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
OffsetAccountName String
OffsetLedgerAccount OffSet GL OffSet GL String
OrderConfirmation Confirm SO Confirm SO String

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Parent Parent Parent GUID
ParentCode String
ParentName String
PayeeName Payee Name Payee Name String
PaymentCondition Payment condition Payment condition String
PaymentConditionDescription String
PaymentDay1 Payment day 1 Payment day 1 Number
PaymentDay2 Payment day 2 Payment day 2 Number
PaymentDay3 Payment day 3 Payment day 3 Number
PaymentDay4 Payment day 4 Payment day 4 Number
PaymentDay5 Payment day 5 Payment day 5 Number
PhoneExtension Extension Extension String
PhoneNumber Phone Phone String
PhoneQueue Phone queue Phone queue String
PictureFilename File name File name String
PostalAddressLine1 Address Address String
PostalAddressLine2 Address Address String
PostalAddressLine3 Address Address String
PostalCity City City String
PostalCountry Country Country String
PostalCounty County County String
PostalPostCode PostCode PostCode String
PostalState State State String
PriceList Price list Price list String
PriceListDescription String
PurchaseOrderConfirmation Boolean

Property starting with R
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Rating Rating Rating String
RatingDescription String
Reminder Reminder Reminder Boolean
ResellerCode String
ResellerID Reseller Reseller GUID
ResellerName String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
SectorCode Sector Sector String
SectorDescription String
SecurityLevel Security level Security level Number
SignDate Date
SizeDescription String
Source Source Source String
SourceDescription String
StatementDate Date
StatementFrequency Statement Freq. Statement Freq. String
StatementNumber Number
StatementPrint Print debtor statements Print debtor statements Boolean
StatFactor String
SubSector Subsector Subsector String
SubSectorDescription String
SupplierID Supplier Supplier GUID
SyncID GUID

Property starting with T
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Terms String
TerritoryCode Territory code Territory code String
TextFreeField1 Text Text String
TextFreeField10 Text Text String
TextFreeField11 Text Text String
TextFreeField12 Text Text String
TextFreeField13 Text Text String
TextFreeField14 Text Text String
TextFreeField15 Text Text String
TextFreeField16 Text Text String
TextFreeField17 Text Text String
TextFreeField18 Text Text String
TextFreeField19 Text Text String
TextFreeField2 Text Text String
TextFreeField20 Text Text String
TextFreeField21 Text Text String
TextFreeField22 Text Text String
TextFreeField23 Text Text String
TextFreeField24 Text Text String
TextFreeField25 Text Text String
TextFreeField26 Text Text String
TextFreeField27 Text Text String
TextFreeField28 Text Text String
TextFreeField29 Text Text String
TextFreeField3 Text Text String
TextFreeField30 Text Text String
TextFreeField4 Text Text String
TextFreeField5 Text Text String
TextFreeField6 Text Text String
TextFreeField7 Text Text String
TextFreeField8 Text Text String
TextFreeField9 Text Text String
TitleDescription Title description Title description String
TransactionA String
TransactionB String
Transport String
Transshipment String
TriangularCountry String
TypeSince Type Type Date

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

Property starting with V
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
VatCode Vat code Vat code String
VATLiability Vat liability Vat liability String
VATNumber VAT Number VAT Number String
VatServices Vat services Vat services String

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

Property starting with Y
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
YesNoFreeField1 Yes/No Yes/No Boolean
YesNoFreeField2 Yes/No Yes/No Boolean
YesNoFreeField3 Yes/No Yes/No Boolean
YesNoFreeField4 Yes/No Yes/No Boolean
YesNoFreeField5 Yes/No Yes/No Boolean

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
Abbreviation cnt_titleabbreviation String 8 0
AccountCode CustomerCode String 20 0
AccountEmployeeId AccountEmployeeId Number 10 0 0
AccountEmployeeName AccountEmployeeName String 70 0
AccountManagerID AccountManager Number 10 0
AccountManagerName AccountManagerName String 64 0
AccountManagerType AccountManagerType String 1 0
A,35,Applicant
C,24081,Contractor
E,9551,Employee
K,240,Customer
R,995,Partner
S,29493,Student
T,29542,Temporary
V,8148,Vacancy
AccountName Name String 50 0
AccountStatus Status String 1 0 S
B,1267,Blocked
C,30798,Corporate
E,8573,Exit
H,31092,High attention
P,24822,Prospect
R,5961,Reference
S,24011,Standard
AddExtraReceiptToOrder AddExtraReceiptToOrder Boolean 1 0 0 0 1
AddressID AddressID String 8191 0
AllowBackorder AllowBackOrders Boolean 0 0 0
AllowPartialDelivery AllowPartialShipment Boolean 0 0 1
ApplyShippingCharges ApplyShippingCharges Boolean 1 0 0 0 1
ASPDatabase ASPDatabase String 30 0
ASPDatabaseServer ASPServer String 30 0
ASPWebsiteServer ASPWebServer String 30 0
ASPWebsiteURL ASPWebSite String 128 0
AttachUBL AttachUBL Boolean 0 0 0
Attention Attention Boolean 1 0 0 0 1
AutoAllocate AutoAllocate Boolean 1 0 0 0 1
AvalaraEntityUseCode AvalaraEntityUseCode String 1 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
BankAccountType BankAccountType String 3 0
AT,0,Austrian bank accounts
BE,0,Belgian bankaccounts
CZ,0,Czech account number
DE,0,German bankaccounts
DEF,0,Default bank account type
ES,0,Spanish bankaccounts
FR,0,French bankaccounts
GB,0,British bankaccounts
GNL,0,Blocked Dutch bank account
GPB,0,Blocked Postbank account
HU,0,Hungarian bank accounts
IBA,0,IBAN International Bank Account Number
IT,0,Italian bank accounts
LU,0,Luxemburg bankaccounts
NL,0,Dutch bankaccounts
PB,0,Postbankaccounts
RU,0,Russian bank accounts
Blocked Blocked Boolean 1 0 0 0 1
BOELimitAmount BOELimitAmount Number 16 4
BOEMaxAmount BOEMaxAmount Number 16 4

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
ChamberofCommerceNumber ChamberOfCommerce String 20 0
ChangeVatData ChangeVatCode Boolean 1 0 1 0 1
ChangeVatServices ChangeVatServices Boolean 1 0 1 0 1
CheckDate CheckDate Date 8 0
CiscoDirectory cntp_directory String 30 0
CityOfLoadUnload CityOfLoadUnload String 10 0
ClassificationDescription ClassificationDescription String 50 0
ClassificationID ClassificationID String 3 0
CodeatSupplier CustomerCodeEx String 10 0
CollectionInvoice Collect String 1 0 N
F,10107,On Invoice Debtor
N,1015,No
O,10112,On Order Debtor
CompanyCode Administration String 3 0
CompanyCodeDebtorAccountID DivisionDebtorAccountID GUID 16 0
CompanyName AdministrationDescription String 60 0
CompanySize CompanySize String 10 0
CompanyType CompanyType Number 4 0 3
ContactAccountManager cnt_AccountManager Number 10 0 AccountManager
ContactCompanyCode cnt_Administration String 3 0 Administration
ContactCreatedDate cnt_DateCreated Date 0 0 NOW
ContactCreator cnt_CreatedBy Number 10 0 HUMRESID
ContactEmail cnt_Email String 128 0 EMail
ContactFaxNumber cnt_Fax String 25 0
ContactFirstName cnt_FirstName String 30 0
ContactFullName ContactFullName String 100 0
ContactGender Gender String 1 0 O
M,5155,Male
O,1067,Unknown
V,5156,Female
ContactID ContactID GUID 16 0
ContactInitials cnt_Initials String 10 0
ContactLanguage cnt_Language String 3 0
ContactLanguageDescription cnt_LanguageDescription String 30 0
ContactLastName cnt_LastName String 50 0 --
ContactMiddleName cnt_MiddleName String 30 0
ContactMobileNumber cnt_Mobile String 25 0
ContactModifiedDate cnt_DateModified Date 0 0 NOW
ContactModifier cnt_ModifiedBy Number 10 0 HUMRESID
ContactNumberFreeField1 ContactNumberField1 Number 16 2
ContactNumberFreeField2 ContactNumberField2 Number 16 2
ContactNumberFreeField3 ContactNumberField3 Number 16 2
ContactNumberFreeField4 ContactNumberField4 Number 16 2
ContactNumberFreeField5 ContactNumberField5 Number 16 2
ContactPhoneNumber cnt_Phone String 25 0
ContactTitle cnt_Title String 4 0
CountryOfAssembly CountryOfAssembly String 3 0
CountryOfOrigin CountryOfOrigin String 3 0
CreatedDate DateCreated Date 0 0 NOW
Creator CreatedBy Number 10 0 HUMRESID
CreatorName CreatedByName String 64 0
CreditabilityScenario CreditabilityScenario String 1 0 N
A,31845,Payment agreement
C,30768,Complaints
N,6486,Normal
T,31846,Transferred
CreditCardDescription CreditCardDescription String 15 0
CreditCardExpirationDate ExpiryDate Date 8 0
CreditCardHolder CreditCardHolder String 40 0
CreditcardNumberReference Creditcard String 34 0
CreditLine CreditLine Number 12 2 0
CreditorCode crdcode String 20 0
CreditorNumber crdnr String 6 0
CreditorNumberReference CreditorNumber String 6 0
CreditorType CreditorType String 1 0
B,12208,Tax authority,Industry Assurance Board
C,8504,Creditor
E,17121,Employee
O,7738,Subcontractor
CurrencyCode Currency String 3 0
CurrencyDescription CurrencyDescription String 60 0
CustomerID DivisionDebtorID GUID 16 0
CustomerSince CustomerSince Date 0 0 NOW
CustomerStatus CustomerStatus String 1 0 N
A,2212,Active
B,1267,Blocked
E,29544,Exit
N,29,Not Validated
P,41,Pilot
R,20344,Reference
S,38,Passive
CustomerStatusDescription CustomerStatusDescription String 30 0
CustomerType CustomerType String 1 0 N
A,24820,Associate
B,8371,Bank
C,14006,Customer
D,64,Division
E,9551,Employee
L,25454,Lead
N,29,Not Validated
P,24822,Prospect
R,24870,Reseller
S,5098,Supplier
T,15235,Suspect
CustomerTypeDescription CustomerTypeDescription 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
DateFreeField1 DateField1 Date 8 0
DateFreeField2 DateField2 Date 8 0
DateFreeField3 DateField3 Date 8 0
DateFreeField4 DateField4 Date 8 0
DateFreeField5 DateField5 Date 8 0
DateLastReminder DateLastReminder Date 8 0
DebtorAccountName CentralizationAccountName String 60 0
DebtorCode debcode String 20 0
DebtorCreditorAccount CentralizationAccount String 9 0
DebtorNumber debnr String 6 0
DebtorNumberReference DebtorNumber String 6 0
DefaultSelCode DefaultSelCode String 2 0
DefaultSelDescription DefaultSelDescription String 30 0
DeleteBankAccount DeleteBankAccount Number 1 0 0
DeliveryAddressline1 DelAddress String 100 0
DeliveryAddressline2 DelAddress2 String 100 0
DeliveryAddressline3 DelAddress3 String 100 0
DeliveryCity DelCity String 100 0
DeliveryCountry DelCountry String 3 0
DeliveryCounty DelCounty String 100 0
DeliveryMethod DeliveryMethod String 5 0
DeliverymethodDescription DeliveryMethodDescription String 40 0
DeliveryPostCode DelPostCode String 20 0
DeliveryState DelState String 3 0
DeliveryTerms DeliveryTerms String 10 0
DestinationCountry DestinationCountry String 3 0
Directory Directory String 30 0
Discount Discount Number 6 2 0
Document Document GUID 16 0
DocumentCreatedDate DocumentCreatedDate Date 8 0
DocumentCreator DocumentCreatedByFullName String 40 0
DocumentSubject DocumentSubject String 255 0
DunBradstreetNumber DunsNumber String 9 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
EmailAddress Email String 128 0
ESFContactID ESFContactID GUID 16 0
ExemptNumber ExemptNumber String 20 0
Extension cnt_PhoneExtension String 10 0
ExtraDescriptionName ItemCodeName String 20 0
ExtraDuty ExtraDuty Boolean 1 0 0 0 1
ExtraItemDescription ItemCode String 2 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
FaxNumber Fax String 25 0
FedCategory FedCategory String 4 0
FedIDNumber FedIDNumber String 13 0
FedIDType FedIDType String 1 0
B,8872,None
F,40036,Federal ID no.
S,7655,Social security no.
FiscalCode FiscalCode String 30 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
GroupDueDates GroupPayments String 1 0 N
A,17828,Always collect
I,5160,Use default settings
N,17951,Never collect
GuidFreeField1 GUIDField1 GUID 16 0
GuidFreeField2 GUIDField2 GUID 16 0
GuidFreeField3 GUIDField3 GUID 16 0
GuidFreeField4 GUIDField4 GUID 16 0
GuidFreeField5 GUIDField5 GUID 16 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
ID ID GUID 16 0
IncoTermAcknowledgeOrder IncoTermAcknowledgeOrder Boolean 0 0 0
IncoTermCode IncoTermCode String 3 0
IncoTermConfirmPrices IncoTermConfirmPrices Boolean 0 0 0
IncoTermProperty IncoTermProperty String 60 0
IntegerFreeField1 NumIntField1 Number 4 0 0
IntegerFreeField2 NumIntField2 Number 4 0 0
IntegerFreeField3 NumIntField3 Number 4 0 0
IntegerFreeField4 NumIntField4 Number 4 0 0
IntegerFreeField5 NumIntField5 Number 4 0 0
IntermediaryassociateID IntermediaryassociateID String 10 0
IntrastatSystem IntrastatSystem String 10 0
IntRegion IntRegion String 10 0
InvoiceAddress InvAddress String 100 0
InvoiceAddress2 InvAddress2 String 100 0
InvoiceAddress3 InvAddress3 String 100 0
InvoiceAddressPostCode InvPostCode String 20 0
InvoiceCity InvCity String 100 0
InvoiceCopies InvoiceCopies Number 4 0
InvoiceCountry InvCountry String 3 0
InvoiceCounty InvCounty String 100 0
InvoiceDebtor InvoiceDebtor String 6 0
InvoiceMethod InvoiceMethod String 1 0
E,36057,Electronically
M,5804,E-mail
P,8650,Printer
T,0,TNT
InvoiceState InvState String 3 0
IsBinaryServiceEnabled IsBinaryServiceEnabled Boolean 1 0 0 0 1
IsCommissionable IsCommissionable Boolean 1 0 0 0 1
IsTaxExempted IsTaxExempted Boolean 0 0 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
JobDescription cnt_JobDescription String 50 0 --
JobTitle cnt_JobTitle String 12 0
JobTitleDescription cnt_JobTitleDescription String 50 0
JournalCode JournalCode 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
LogoFilename LogoFilename String 128 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
Mailbox Mailbox String 128 0
MailingAddress1 MailAddress String 100 0
MailingAddress2 MailAddress2 String 100 0
MailingAddress3 MailAddress3 String 100 0
MailingCity MailCity String 100 0
MailingCountry MailCountry String 3 0
MailingCountryDescription MailCountryDescription String 30 0
MailingCounty MailCounty String 100 0
MailingPostcode MailPostcode String 20 0
MailingState MailState String 3 0
MailingStateDescription StateDescription String 100 0
ManagersCCDescription ManagerCostCenterDesc String 50 0
ManagersCostCenter ManagerCostCenter String 8 0
MessageIDCompanyLogo MessageID_logo GUID 16 0
MessageIDRemarks MessageID_note GUID 16 0
ModifiedDate DateModified Date 0 0 NOW
Modifier ModifiedBy Number 10 0 HUMRESID
ModifierName ModifiedByName String 64 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
NumberFreeField1 NumberField1 Number 16 2
NumberFreeField2 NumberField2 Number 16 2
NumberFreeField3 NumberField3 Number 16 2
NumberFreeField4 NumberField4 Number 16 2
NumberFreeField5 NumberField5 Number 16 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
OffsetAccountName OffSetAccountName String 60 0
OffsetLedgerAccount OffSetAccount String 9 0
OrderConfirmation PurchaseReceipt String 1 0 N
A,1014,Yes
B,3726,Back order
N,1015,No

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
Parent Parent GUID 16 0
ParentCode ParentCode String 20 0
ParentName ParentName String 64 0
PayeeName PayeeName String 40 0
PaymentCondition PaymentCondition String 2 0
PaymentConditionDescription PaymentConditionDescription String 30 0
PaymentDay1 PaymentDay1 Number 2 0
PaymentDay2 PaymentDay2 Number 2 0
PaymentDay3 PaymentDay3 Number 2 0
PaymentDay4 PaymentDay4 Number 2 0
PaymentDay5 PaymentDay5 Number 2 0
PhoneExtension PhoneExtension String 10 0
PhoneNumber Phone String 25 0
PhoneQueue PhoneQueue String 15 0
PictureFilename cnt_picturefilename String 128 0
PostalAddressLine1 PosAddress String 100 0
PostalAddressLine2 PosAddress2 String 100 0
PostalAddressLine3 PosAddress3 String 100 0
PostalCity PosCity String 100 0
PostalCountry PosCountry String 3 0
PostalCounty PosCounty String 100 0
PostalPostCode PosPostCode String 20 0
PostalState PosState String 3 0
PriceList PriceList String 15 0
PriceListDescription PriceListDescription String 30 0
PurchaseOrderConfirmation PurchaseOrderConfirmation Boolean 1 0 0 0 1

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
Rating Rating String 1 0
RatingDescription RatingDescription String 100 0
Reminder Reminder Boolean 1 0 1 0 1
ResellerCode ResellerCode String 20 0
ResellerID ResellerID GUID 16 0
ResellerName ResellerName String 64 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
SectorCode IndustrySector String 10 0
SectorDescription IndustrySectorDescription String 100 0
SecurityLevel SecurityLevel Number 3 0 10
SignDate SignDate Date 0 0
SizeDescription CompanySizeDescription String 40 0
Source CustomerOrigin String 3 0 P
SourceDescription CustomerOriginDescription String 40 0
StatementDate StatementDate Date 8 0
StatementFrequency StatementFrequency String 1 0
D,0,Discretionary
M,0,Monthly
N,0,No statement
Q,0,Quarterly
S,0,Semi-Monthly
W,0,Weekly
StatementNumber StatementNumber Number 5 0
StatementPrint StatementPrint Boolean 0 0 1
StatFactor StatFactor String 3 0
SubSector SubSector String 10 0
SubSectorDescription SubSectorDescription String 40 0
SupplierID DivisionCreditorID GUID 16 0
SyncID SyncID GUID 16 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
Terms Terms String 5 0 0
TerritoryCode TerritoryCode String 5 0
TextFreeField1 TextField1 String 80 0
TextFreeField10 TextField10 String 75 0
TextFreeField11 TextField11 String 80 0
TextFreeField12 TextField12 String 80 0
TextFreeField13 TextField13 String 80 0
TextFreeField14 TextField14 String 80 0
TextFreeField15 TextField15 String 80 0
TextFreeField16 TextField16 String 80 0
TextFreeField17 TextField17 String 80 0
TextFreeField18 TextField18 String 80 0
TextFreeField19 TextField19 String 80 0
TextFreeField2 TextField2 String 80 0
TextFreeField20 TextField20 String 80 0
TextFreeField21 TextField21 String 80 0
TextFreeField22 TextField22 String 80 0
TextFreeField23 TextField23 String 75 0
TextFreeField24 TextField24 String 80 0
TextFreeField25 TextField25 String 80 0
TextFreeField26 TextField26 String 80 0
TextFreeField27 TextField27 String 80 0
TextFreeField28 TextField28 String 80 0
TextFreeField29 TextField29 String 80 0
TextFreeField3 TextField3 String 80 0
TextFreeField30 TextField30 String 80 0
TextFreeField4 TextField4 String 80 0
TextFreeField5 TextField5 String 80 0
TextFreeField6 TextField6 String 75 0
TextFreeField7 TextField7 String 75 0
TextFreeField8 TextField8 String 75 0
TextFreeField9 TextField9 String 75 0
TitleDescription cnt_TitleDescription String 30 0
TransactionA TransactionA String 10 0
TransactionB TransactionB String 10 0
Transport Transport String 10 0
Transshipment Transshipment String 10 0
TriangularCountry TriangularCountry String 3 0
TypeSince TypeSince Date 0 0 NOW

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
UseAvalaraTaxation UseAvalaraTaxation Boolean 0 0 0

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
VatCode VatCode String 15 0
VATLiability VATLiability String 1 0 L
E,31873,Exempted
L,1964,Liable to pay VAT
N,31872,Not liable to pay VAT
VATNumber VatNumber String 20 0
VatServices VatServices String 15 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
WebAddress WebAddress String 128 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
YesNoFreeField1 YesNoField1 Boolean 0 0 0
YesNoFreeField2 YesNoField2 Boolean 0 0 0
YesNoFreeField3 YesNoField3 Boolean 0 0 0
YesNoFreeField4 YesNoField4 Boolean 0 0 0
YesNoFreeField5 YesNoField5 Boolean 0 0 0