|
Ordinal
|
Data
Description
|
Data
Type
|
Data
Length
|
Required
|
Check
Constraints
|
Comments
|
|
1
|
Contact Number
|
string
|
30
|
Y
|
|
Must
be unique
|
|
2
|
Kommerce
Server ID
|
integer
|
4
|
|
|
This
is the KommerceServer reference number for this contact It is only needed
when the contact was originally created in KS as a cross reference to the
contact number assigned by the ERP system when imported.
|
|
3
|
Display Name
|
string
|
100
|
Y
|
|
This
is the name that displays on the web and listing pages
|
|
4
|
Position
|
string
|
100
|
|
|
|
|
5
|
Phone
|
string
|
25
|
|
|
No
need to resend related customer phone number (only if direct line to
contact).
|
|
6
|
Email Address
|
string
|
100
|
|
|
|
|
7
|
First Name
|
string
|
30
|
|
|
|
|
8
|
Last Name
|
string
|
30
|
|
|
|
|
9
|
Middle Name
|
string
|
30
|
|
|
|
|
10
|
Name Prefix
|
string
|
10
|
|
|
|
|
11
|
Name Suffix
|
string
|
10
|
|
|
|
|
12
|
Company Number
|
string
|
30
|
Y
|
|
This
is actually the xref_id which is looked up in the foreign key table to find
the actual pk value (integer) in SQL DB. The lookup is a combination of type
and company number.
|
|
13
|
Business Type
|
string
|
1
|
Y
|
'C'=Customer
'E'=End User
|
Used
to lookup the type of company the contact is associated. See comment above.
|
|
14
|
Contact Class
|
string
|
30
|
|
|
A
lookup is performed using this value against the
classification.class_xref_id. See KS_CLASSIFICATIONS export
|
|
15
|
Department
|
string
|
30
|
|
|
A
lookup is performed using this value against the business_unit.unit_xref_id
column. This field is used by the webTeam application
|
|
16
|
Fax Number
|
string
|
25
|
|
|
|
|
17
|
Mobile Number
|
string
|
25
|
|
|
|
|
18
|
Address Number
|
string
|
30
|
|
|
A
lookup is performed using the value against the
entity_address.address_xref_id column. The value should correspond to the
addresses sent in the KS_SHIP_ADDRS export. If this is blank the assumption
is the contact is associated with the primary address for the company sent in
KS_CUSTOMERS or KS_ENDUSERS export.
|
|
19
|
Active Flag
|
string
|
1
|
Y
|
"Y"=
Active
"N"=Inactive
|
If
set to "N" this contact will still show for historical transactions
but will not be selectable for any new transactions. The Auto Set Web Access
Code would likely be set to "REMOVE" in this case as well.
|
|
20
|
Auto Set Web Access
Code
|
string
|
10
|
|
"ACTIVATE"
"DEACTIVATE"_
"REMOVE"
|
If
set to "ACTIVATE" a web account will be created and a password
generated only if a Web Account does not exist. If a Web Account already
exists, this code will ensure that the account is active only. If Set to
"DEACTIVATE" and a Web Account exists, the password will be
preserved but the web access will be denied. If set to "REMOVE" the
Web Account will be removed entirely if it exists. If a Web Account does not exist, no change
occurs for "DEACTIVATE" or "REMOVE". Note: This feature
can conflict with interactive changes that may be allowed on-line. If web
access is to be maintained on-line exclusively then this field should be left
blank.
|