Name
|
Code
|
Type
|
M
|
|---|---|---|---|
Account Code
|
acct_code
|
char(12)
|
Yes
|
Account Name
|
acct_name
|
varchar(30)
|
Yes
|
Fund Code
|
fund
|
char(4)
|
No
|
Is Back Office Pending
|
is_bop
|
tinyint
|
No
|
Is Edit Active
|
is_edit_active
|
tinyint
|
No
|
Legal Vehicle
|
legal_vehicle
|
char(6)
|
No
|
Account Type
|
account_type
|
char(6)
|
No
|
Is Active
|
is_active
|
tinyint
|
No
|
Accounting Method
|
accounting_method
|
char(6)
|
No
|
Custodian
|
custodian
|
char(6)
|
No
|
Position Limit
|
position_limit
|
float
|
No
|
Last Update ID
|
last_update_id
|
char(4)
|
No
|
Last Update
|
last_update
|
datetime
|
No
|
Ranking
|
ranking
|
float
|
No
|
Account Group
|
account_group
|
char(6)
|
No
|
Lock ID
|
lock_id
|
char(4)
|
No
|
External Account ID
|
external_acct_id
|
varchar(20)
|
No
|
Cash Proxy
|
cash_proxy
|
char(20)
|
No
|
Account Manager
|
account_manager
|
char(4)
|
No
|
is_allowed_short_positions
|
is_allowed_short_positions
|
tinyint
|
No
|
Report Distribution
|
report_distribution
|
char(6)
|
No
|
Report Index
|
report_index
|
char(6)
|
No
|
Can Use Affiliate
|
can_use_affiliate
|
varchar(1)
|
No
|
Index Code
|
P
|
F
|
A
|
U
|
C
|
Sort
|
|---|---|---|---|---|---|---|
pk_account
|
Yes
|
No
|
No
|
Yes
|
No
|
ASC
|
Primary Key
|
Reference to
|
Foreign Key
|
|---|---|---|
code
|
acctgrp
|
account_group
|
code
|
acctmeth
|
accounting_method
|
code
|
custodn
|
custodian
|
fund_code
|
fund
|
fund
|
code
|
accttype
|
account_type
|
code
|
legalveh
|
legal_vehicle
|
product_id
|
product
|
cash_proxy
|
trans_id
|
transact
|
account_manager
|
Referenced by
|
Primary Key
|
Foreign Key
|
|---|---|---|
apisract
|
acct_code
|
acct_code
|
apprdact
|
acct_code
|
acct_code
|
cashtckt
|
acct_code
|
acct_code
|
currposn
|
acct_code
|
acct_code
|
tckdtl
|
acct_code
|
acct_code
|
vacttran
|
acct_code
|
acct_code
|