Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Transactor ID
|
trans_id
|
char(4)
|
Yes
|
Last Name
|
last_name
|
varchar(20)
|
Yes
|
First Name
|
first_name
|
varchar(20)
|
No
|
Telephone Number
|
phone_number
|
varchar(20)
|
No
|
Intercom
|
intercom
|
varchar(8)
|
No
|
Desk Code
|
desk
|
char(4)
|
No
|
Is Analyst
|
is_analyst
|
tinyint
|
No
|
Team
|
team
|
char(6)
|
No
|
Is Team Manager
|
is_team_manager
|
tinyint
|
No
|
Is Back Office Pending
|
is_bop
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Transactor Type
|
trans_type
|
char(6)
|
No
|
Is Active
|
is_active
|
tinyint
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Database Login Name
|
login_name
|
varchar(30)
|
No
|
Security Profile
|
security_profile
|
char(6)
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_transact
|
Yes
|
No
|
No
|
Yes
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
saleteam
|
team
|
code
|
trsidtyp
|
trans_type
|
Referenced by
|
Primary Key
|
Foreign Key
|
|---|---|---|
account
|
trans_id
|
account_manager
|
opapprv
|
trans_id
|
credit
|
opapprv
|
trans_id
|
data_entry
|
opapprv
|
trans_id
|
principal
|
opapprv
|
trans_id
|
salersman
|
opmast
|
trans_id
|
salesman
|
tradedsk
|
trans_id
|
analyst
|
trandesk
|
trans_id
|
trans_id
|
vacttran
|
trans_id
|
trans_id
|