Sales Representative Maintenance Database Information

Data for Sales Representative Maintenance is stored in the sales-agent table.

Fields

Field

Field Name

Sales Representative ID

sales-agent-id

Main Tab Fields

Field

Field Name

Commission Group Name

comm-group-name

Sales Team ID

sales-team-id

Active

active

First Name

first-name

Last Name

last-name

SS #

ss-num

Other ID

other-id

Rep Type

agent-type

Manager

manager

Address 1

address-1

Address 2

address-2

City

city

State

state

Postal Code

zip

Country

country

County

county

Email

email-address

Phone #

phone

Fax #

fax

Cell Phone #

mobile

Remarks

remarks

Additional Information Tab Fields

Field

Field Name

Extract Agent Number

extract-agent-num

Extract Agent Name

extract-agent-name

QlikView User

qlikview-user-name

User Defined 1-10

user-defined-1 to user-defined-10