Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Other Party Code
|
other_party_code
|
char(12)
|
Yes
|
Address Line 1
|
address_line_1
|
varchar(40)
|
No
|
Address Line 2
|
address_line_2
|
varchar(40)
|
No
|
Address Line 3
|
address_line_3
|
varchar(40)
|
No
|
Voice Telephone Number
|
voice_phone
|
varchar(20)
|
No
|
Fax Telephone Number
|
fax_phone
|
varchar(20)
|
No
|
Contact Person 1
|
contact_1
|
varchar(30)
|
No
|
Contact Person 2
|
contact_2
|
varchar(30)
|
No
|
Comments
|
comments
|
varchar(120)
|
No
|
Tax ID
|
tax_id
|
varchar(11)
|
No
|
Residence State
|
residence_state
|
varchar(2)
|
No
|
DTC
|
dtc
|
varchar(5)
|
No
|
Institution ID
|
instid
|
varchar(5)
|
No
|
NSCC
|
nscc
|
varchar(5)
|
No
|
Agent ID
|
agent_id
|
varchar(5)
|
No
|
Agent Internal ID
|
agent_internal
|
varchar(20)
|
No
|
TAS Number
|
tas_number
|
varchar(15)
|
No
|
Cash Account Number
|
cash_account_number
|
varchar(16)
|
No
|
Wire Instructions
|
wire_instructions
|
varchar(40)
|
No
|
Interested Party 1 ID
|
int_party_1
|
varchar(5)
|
No
|
Interested Party 1 Internal ID
|
int_party_1_internal
|
varchar(12)
|
No
|
Interested Party 2 ID
|
int_party_2
|
varchar(5)
|
No
|
Interested Party 2 Internal ID
|
int_party_2_internal
|
varchar(12)
|
No
|
City
|
city
|
varchar(20)
|
No
|
State
|
state
|
varchar(2)
|
No
|
Zip Code
|
zip_code
|
varchar(10)
|
No
|
SIC Code
|
sic_code
|
varchar(5)
|
No
|
GSCC ID
|
gscc_id
|
varchar(4)
|
No
|
MBSCC ID
|
mbscc_id
|
varchar(4)
|
No
|
MBSCC Eligibility
|
mbscc_eligibility
|
tinyint
|
No
|
Reliable
|
reliable
|
tinyint
|
No
|
W9 Received
|
w9_received
|
tinyint
|
No
|
Foreign Customer
|
foreign_customer
|
tinyint
|
No
|
Foreign Institution
|
foreign_institution
|
tinyint
|
No
|
Safekeeping
|
safekeeping
|
tinyint
|
No
|
Permanently Exempt
|
permanently_exempt
|
tinyint
|
No
|
Is Directed By Advisor
|
is_directed_by_advisor
|
tinyint
|
No
|
Is Legal Age
|
is_legal_age
|
tinyint
|
No
|
Is Broker Dealer
|
is_broker_dealer
|
tinyint
|
No
|
Is Primary Dealer
|
is_primary_dealer
|
tinyint
|
No
|
Country
|
country
|
char(6)
|
No
|
Fedieral Income Tax
|
fed_income_tax
|
float
|
No
|
Capital Gains Tax
|
cap_gains_tax
|
float
|
No
|
State Income Tax
|
state_income_tax
|
float
|
No
|
Instruction 1
|
instruction_1
|
varchar(40)
|
No
|
Instruction 2
|
instruction_2
|
varchar(40)
|
No
|
Instruction 3
|
instruction_3
|
varchar(40)
|
No
|
Instruction 4
|
instruction_4
|
varchar(40)
|
No
|
Is Affiliate
|
is_affiliate
|
tinyint
|
No
|
Email
|
email
|
varchar(40)
|
No
|
Minor Badge Number
|
minor_badge_number
|
varchar(4)
|
No
|
Agent Internal 2
|
agent_internal_2
|
varchar(20)
|
No
|
Instruction 5
|
instruction_5
|
varchar(40)
|
No
|
Is Free Delivery
|
is_free_delivery
|
tinyint
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_opdtl
|
Yes
|
Yes
|
No
|
Yes
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
country
|
country
|
other_party_code
|
opmast
|
other_party_code
|