|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Address_ID
|
Record ID
|
|
9999999999
|
|
|
|
AddressCity
|
City
|
|
X(20)
|
|
|
|
AddressCityCode
|
City Code
|
|
x(20)
|
|
|
|
AddressCounty
|
County
|
|
x(40)
|
|
|
|
AddressEMail
|
E-Mail
|
|
x(40)
|
|
|
|
AddressExternalValidationCode
|
External Validation Code
|
|
x(1)
|
|
|
|
AddressFax
|
Fax
|
|
x(40)
|
|
|
|
AddressFormat
|
Format
|
|
->,>>>,>>9
|
|
|
|
AddressIsSendToPostal
|
Send Documents
|
|
yes/no
|
|
|
|
AddressIsTaxable
|
Taxable Address
|
|
yes/no
|
|
|
|
AddressIsTaxInCity
|
Tax in City
|
|
yes/no
|
|
|
|
AddressIsTaxIncluded
|
Tax Is Included
|
|
yes/no
|
|
|
|
AddressIsTemporary
|
Temporary
|
Temp
|
yes/no
|
|
|
|
AddressLogicKeyString
|
Logic Key String
|
|
x(40)
|
|
|
|
AddressName
|
Name
|
|
x(36)
|
|
|
|
AddressPostalAddress1
|
Postal Address
|
|
x(40)
|
|
|
|
AddressPostalAddress2
|
Postal Address
|
|
x(40)
|
|
|
|
AddressPostalCity
|
City
|
|
x(20)
|
|
|
|
AddressPostalZip
|
Zip/City
|
Zip Code
|
x(40)
|
|
|
|
AddressSearchName
|
Search Name
|
|
x(28)
|
|
|
|
AddressState
|
State
|
|
x(20)
|
|
|
|
AddressStreet1
|
Address
|
|
x(36)
|
|
|
|
AddressStreet2
|
Address
|
|
x(36)
|
|
|
|
AddressStreet3
|
Address
|
|
x(36)
|
|
|
|
AddressTaxDeclaration
|
Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
AddressTaxIDFederal
|
Federal Tax
|
|
x(18)
|
|
|
|
AddressTaxIDMisc1
|
Miscellaneous Tax 1
|
|
x(18)
|
|
|
|
AddressTaxIDMisc2
|
Miscellaneous Tax 2
|
|
x(18)
|
|
|
|
AddressTaxIDMisc3
|
Miscellaneous Tax 3
|
|
x(18)
|
|
|
|
AddressTaxIDState
|
State Tax
|
|
x(18)
|
|
|
|
AddressTelephone
|
Telephone
|
|
x(40)
|
|
|
|
AddressType_ID
|
Address Type
|
Type
|
9999999999
|
|
|
|
AddressWebSite
|
Internet
|
|
x(60)
|
|
|
|
AddressZip
|
Zip/City
|
Zip Code
|
x(10)
|
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
9999999999
|
|
|
|
Country_ID
|
Country Format
|
|
9999999999
|
|
|
|
County_ID
|
Description
|
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Lng_ID
|
Language Code
|
Lang
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
State_ID
|
Description
|
|
9999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
TxzTaxZone
|
Tax Zone
|
|
x(16)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AddressType
|
no
|
AddressType_ID
|
yes
|
no
|
|
|
BusinesRelation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
City
|
no
|
AddressCity
|
yes
|
no
|
|
|
Country
|
no
|
Country_ID
|
yes
|
no
|
|
|
CountryIdx
|
no
|
County_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LngIdx
|
no
|
Lng_ID
|
yes
|
no
|
|
|
NameIdx
|
no
|
AddressName
|
yes
|
no
|
|
|
PostalCode
|
no
|
AddressZip
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Address_ID
|
yes
|
no
|
|
|
SNameIdx
|
no
|
AddressSearchName
|
yes
|
no
|
|
|
StateIdx
|
no
|
State_ID
|
yes
|
no
|
|
|
TaxClass
|
no
|
TxclTaxCls
|
yes
|
no
|
|
|
TaxIDs
|
no
|
AddressTaxIDFederal
|
yes
|
no
|
|
|
|
|
AddressTaxIDState
|
yes
|
no
|
|
|
TaxZone
|
no
|
TxzTaxZone
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
AddressType_ID
|
yes
|
no
|
|
|
|
|
AddressLogicKeyString
|
yes
|
no
|
|
|
UniqueKeyAddress
|
yes
|
AddressStreet1
|
yes
|
no
|
|
|
|
|
AddressStreet2
|
yes
|
no
|
|
|
|
|
AddressStreet3
|
yes
|
no
|
|
|
|
|
AddressZip
|
yes
|
no
|
|
|
|
|
AddressCity
|
yes
|
no
|
|
|
|
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
AddressType_ID
|
yes
|
no
|