Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Other Party Code
|
other_party_code
|
char(12)
|
Yes
|
Other Party Name
|
other_party_name
|
varchar(40)
|
Yes
|
Other Party Short Name
|
short_name
|
varchar(20)
|
Yes
|
Responsible Salesman
|
salesman
|
char(4)
|
No
|
Is Backoffice Pending
|
is_bop
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Is Active
|
is_active
|
tinyint
|
No
|
Location
|
location
|
char(6)
|
No
|
Other Party Type
|
other_party_type
|
char(6)
|
No
|
Other Party Subtype
|
other_party_subtype
|
char(6)
|
No
|
Accounting Method
|
accounting_method
|
char(6)
|
No
|
Home Currency
|
home_currency
|
char(3)
|
No
|
Confirms
|
confirms
|
tinyint
|
No
|
Add Date
|
add_date
|
datetime
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
CUSIP
|
cusip
|
char(6)
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
Credit Limit
|
credit_limit
|
float
|
No
|
Parent
|
parent
|
char(8)
|
No
|
Repo Credit Limit
|
repo_credit_limit
|
float
|
No
|
Max Settle Days
|
op_max_settle_days
|
int
|
No
|
External Account ID
|
external_account_id
|
varchar(20)
|
No
|
Last Ticket Date
|
last_ticket_date
|
datetime
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_opmast
|
Yes
|
Yes
|
No
|
Yes
|
No
|
ASC
|
index_opmast_salesman
|
No
|
Yes
|
No
|
No
|
No
|
ASC
|
index_opmast_parent
|
No
|
Yes
|
No
|
No
|
No
|
ASC
|
index_opmast_short_name_parent
|
No
|
No
|
No
|
Yes
|
No
|
ASC ASC |
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
acctmeth
|
accounting_method
|
currency_code
|
currency
|
home_currency
|
parent_code
|
opparent
|
parent
|
code
|
opsubtyp
|
other_party_subtype
|
code
|
optype
|
other_party_type
|
trans_id
|
transact
|
salesman
|
Referenced by
|
Primary Key
|
Foreign Key
|
|---|---|---|
aprvdop
|
other_party_code
|
other_party_code
|
issuer
|
other_party_code
|
default_broker_code
|
opaprisr
|
other_party_code
|
other_party_code
|
opapprv
|
other_party_code
|
other_party_code
|
opcnfrms
|
other_party_code
|
other_party_code
|
opdtl
|
other_party_code
|
other_party_code
|
tckmast
|
other_party_code
|
other_party_code
|