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