Name |
Position |
Length |
Decimal |
Description |
MRECID |
1 |
1 |
|
Record ID |
MFIRM |
2 |
1 |
|
Firm ID |
MOFFIC |
3 |
3 |
|
Office number |
MACCT |
6 |
5 |
|
Account number |
MATYPE |
11 |
2 |
|
Account type |
MRR |
13 |
5 |
|
Salesperson |
MCLASS |
18 |
1 |
|
Account class code |
MSUBCL |
19 |
1 |
|
Sub-class code |
MCURAT |
20 |
3 |
|
Account type currency code symbol |
MCURCD |
23 |
2 |
|
Product currency code |
MCURAC |
25 |
3 |
|
Account base currency code symbol |
MCURFM |
28 |
3 |
|
Firm base currency symbol |
MCPCOD |
31 |
1 |
|
Currency processing code |
MNCALL |
32 |
4 |
0 |
Number of call records in an account |
MCAGE |
36 |
4 |
0 |
Age of oldest call in an account |
MFILL1 |
40 |
1 |
|
Available filler byte |
MAVDYS |
41 |
4 |
0 |
Days used in calculation of average equity |
MDSCCD |
45 |
1 |
|
Discretionary code |
MOMNCD |
46 |
1 |
|
Omnibus code |
MACNTY |
47 |
2 |
|
Account country/province code |
MMPGMN |
49 |
2 |
|
Managed account program ID |
MSNAME |
51 |
20 |
|
Short name |
MNA1 |
71 |
32 |
|
Customer name and address line 1 |
MDLACT |
103 |
11 |
0 |
Date of last activity e.g. 20141216 |
MDLACW |
114 |
9 |
|
Date of last activity work e.g. 020141216 |
MREL1F |
123 |
1 |
|
Related firm number 1 |
MREL1O |
124 |
3 |
|
Related office number 1 |
MREL1A |
127 |
5 |
|
Related acct number 1 |
MREL1T |
132 |
1 |
|
Related type number 1 |
MREL2F |
133 |
1 |
|
Related firm number 2 |
MREL2O |
134 |
3 |
|
Related office number 2 |
MREL2A |
137 |
5 |
|
Related acct number 2 |
MREL2T |
142 |
1 |
|
Related type number 2 |
MREL3F |
143 |
1 |
|
Related firm number 3 |
MREL3O |
144 |
3 |
|
Related office number 3 |
MREL3A |
147 |
5 |
|
Related acct number 3 |
MREL3T |
152 |
1 |
|
Related type number 3 |
MGRPFM |
153 |
1 |
|
Group firm number |
MGRPOF |
154 |
3 |
|
Group office number |
MGRPRR |
157 |
5 |
|
Group salesperson |
MGRPAC |
162 |
5 |
|
Group account number |
MBAL |
167 |
17 |
2 |
Account balance |
MLMV |
184 |
17 |
2 |
Long market value for securities |
MSMV |
201 |
17 |
2 |
Short market value of securities |
MLOV |
218 |
17 |
2 |
Long option market value |
MSOV |
235 |
17 |
2 |
Short option market value |
MTC |
252 |
17 |
2 |
Total outstanding margin calls |
MWF |
269 |
17 |
2 |
Funds able to be withdrawn |
MFIR |
286 |
17 |
2 |
Futures initial margin requirement |
MFMR |
303 |
17 |
2 |
Futures maintenance margin requirement |
MFEXIR |
320 |
17 |
2 |
Futures exchange minimum initial requirement |
MME |
337 |
17 |
2 |
Margin excess/deficit |
MOTE |
354 |
17 |
2 |
Futures open trade equity |
MSMA |
371 |
17 |
2 |
Special miscellaneous account amount |
MLOOTE |
388 |
17 |
2 |
Long options open trade equity |
MSOOTE |
405 |
17 |
2 |
Short options open trade equity |
MAVGEQ |
422 |
17 |
2 |
Average equity |
MMTDCM |
439 |
17 |
2 |
Month-to-date commission |
MUNLMV |
456 |
17 |
2 |
Unsettled security long market value |
MTDBAL |
473 |
17 |
2 |
Trade date market balance of securities |
MUNSMV |
490 |
17 |
2 |
Unsettled short market value |
MMMHC |
507 |
17 |
2 |
Market maker haircut amount |
MUNDPC |
524 |
17 |
2 |
JPN unrealized cash deposits |
MMTDPL |
541 |
17 |
2 |
Month-to-date P&L |
MSEGLV |
558 |
17 |
2 |
Seg required long market value |
MSEGSV |
575 |
17 |
2 |
Seg required short market value |
MEIR |
592 |
17 |
2 |
Equities initial margin requirement |
MEMR |
609 |
17 |
2 |
Equities maintenance margin requirement |
MCVTFB |
626 |
17 |
8 |
Conversion rate to firm base currency |
MDVBAL |
643 |
17 |
2 |
Monthly dividend balance |
MJPUPL |
660 |
17 |
2 |
Japanese unsettled unrealized P&L |
MFOOTE |
677 |
17 |
2 |
Futures style option open trade equity |
MLOANV |
694 |
17 |
2 |
Loan value |
MBYPWR |
711 |
17 |
2 |
Buying power |
MPNDIV |
728 |
17 |
2 |
Pending dividend amount |
MPNINT |
745 |
17 |
2 |
Pending interest amount |
MLQVAL |
762 |
17 |
2 |
Liquidating value |
MMRGVL |
779 |
17 |
2 |
Margin collateral value |
MOTECR |
796 |
17 |
2 |
Futures open trade equity credit |
MOTEDR |
813 |
17 |
2 |
Futures open trade equity debit |
MPREM |
830 |
17 |
2 |
Option premium value |
MOOTEC |
847 |
17 |
2 |
Futures style option open trade equity credit |
MAVSOD |
864 |
17 |
2 |
Average security on deposit |
MLOPRM |
881 |
17 |
2 |
Long options premium |
MUNUPL |
898 |
17 |
2 |
Unsettled unrealized P&L |
MAVGME |
915 |
17 |
2 |
Average margin excess |
MJPIR |
932 |
17 |
2 |
Japanese I/R |
MJPIRC |
949 |
17 |
2 |
Japanese I/R cash |
MJPMR |
966 |
17 |
2 |
Japanese M/R |
MJPRT2 |
983 |
17 |
2 |
Japanese initial to release + P&L + premium |
MTAR |
1000 |
17 |
2 |
Total account requirements |
MEPOTE |
1017 |
17 |
2 |
Equity products open trade equity |
MLVUST |
1034 |
17 |
2 |
Long market value US treasury |
MTE |
1051 |
17 |
2 |
Total equity |
MAVGBL |
1068 |
17 |
2 |
Average balance |
MAVGOV |
1085 |
17 |
2 |
Average option value |
MCVTAB |
1102 |
17 |
8 |
Conversion rate to account base currency |
MCMACR |
1119 |
17 |
2 |
Commissions accrued receivable |
MCMACU |
1136 |
17 |
2 |
Commissions accrued unsecured |
MSPNOV |
1153 |
17 |
2 |
Span option value |
MEEXM |
1170 |
17 |
2 |
Equities exchange minimum margin requirement |
MEIRT |
1187 |
17 |
2 |
Equities initial requirements on trades |
MEOIR |
1204 |
17 |
2 |
Equities option initial requirements |
MEOMR |
1221 |
17 |
2 |
Equities option maintenance requirements |
MFEXMR |
1238 |
17 |
2 |
Futures exchange minimum maintenance requirement |
MGEUDC |
1255 |
17 |
2 |
Group excess used/deficit covered |
MNCOTE |
1272 |
17 |
2 |
Non-cash open trade equity |
MCCDNT |
1289 |
17 |
2 |
Cash/collateral daily net value |
MEQPCT |
1306 |
17 |
2 |
Equity percent |
MREGCV |
1323 |
17 |
2 |
Regulatory collateral value |
MCVTAF |
1340 |
17 |
8 |
Conversion rate to account base currency, SMFD format |
MTDVAL |
1357 |
17 |
2 |
Trade date market value of securities |
MTCC |
1374 |
17 |
2 |
Total current calls |
MMRGLM |
1391 |
17 |
2 |
Margin limit in firm base currency |
MPNOTH |
1408 |
17 |
2 |
Pending other amounts |
MIRCIC |
1425 |
17 |
2 |
Initial requirements covered ineligible collateral |
MIRCEC |
1442 |
17 |
2 |
Initial requirements covered by eligible collateral |
MDEFOT |
1459 |
17 |
2 |
Deficit offset BT treasuries |
MSECAM |
1476 |
17 |
2 |
Secured amount |
MCLMGN |
1493 |
17 |
2 |
Credit lines used to cover margin requirements |
MCLOTE |
1510 |
17 |
2 |
Credit lines used to cover debit OTE |
MSPNAE |
1527 |
17 |
2 |
Span adjusted equity |
MMVUCI |
1544 |
17 |
2 |
Market value used to cover initial requirements |
MACRET |
1561 |
17 |
2 |
Accreted interest |
MPOOTE |
1578 |
17 |
2 |
Tiffe paid-out open trade equity |
MUNDEP |
1595 |
17 |
2 |
JPN unrealized deposits |
MPRTC |
1612 |
17 |
2 |
Previous total calls |
MPRSMA |
1629 |
17 |
2 |
Previous SMA |
MLVTM4 |
1646 |
17 |
2 |
Liquidating value t-minus 4 days |
MLVTM3 |
1663 |
17 |
2 |
Liquidating value t-minus 3 days |
MLVTM2 |
1680 |
17 |
2 |
Liquidating value t-minus 2 days |
MPREOI |
1697 |
17 |
2 |
Previous equity option initial requirement |
MPREIR |
1714 |
17 |
2 |
Previous equity initial requirement |
MPRFXM |
1731 |
17 |
2 |
Previous futures exchange maintenance requirement |
MPRFXI |
1748 |
17 |
2 |
Previous futures exchange initial requirement |
MPRFIR |
1765 |
17 |
2 |
Previous futures initial requirement |
MPROTE |
1782 |
17 |
2 |
Previous open trade equity |
MPRTE |
1799 |
17 |
2 |
Previous total equity |
MPRLQV |
1816 |
17 |
2 |
Previous liquidating value |
MPRRCV |
1833 |
17 |
2 |
Previous reg collateral value |
MPRBAL |
1850 |
17 |
2 |
Previous account balance |
MBNRY1 |
1867 |
1 |
|
Binary bits for flag |
MBNRY2 |
1868 |
1 |
|
Binary bits for flag |
MBNRY3 |
1869 |
1 |
|
Binary bits for flag |
MBNRY4 |
1870 |
1 |
|
Binary bits for flag |
MBNRY5 |
1871 |
1 |
|
Binary bits for flag |
MMISC1 |
1872 |
1 |
|
Miscellaneous one-byte code |
MMISC2 |
1873 |
1 |
|
Miscellaneous code 2 |
MMISC3 |
1874 |
1 |
|
Miscellaneous code 3 |
MMISC4 |
1875 |
1 |
|
Miscellaneous code 4 |
MMISC5 |
1876 |
1 |
|
Miscellaneous code 5 |
MMISC6 |
1877 |
1 |
|
Miscellaneous code 6 |
MMISC7 |
1878 |
1 |
|
Miscellaneous code 7 |
MMISC8 |
1879 |
1 |
|
Miscellaneous code 8 |
MMISC9 |
1880 |
1 |
|
Miscellaneous code 9 |
MMISC0 |
1881 |
1 |
|
Miscellaneous code 0 |
MCND01 |
1882 |
1 |
|
Conditional flag byte 1 |
MCND02 |
1883 |
1 |
|
Conditional flag byte 2 |
MCND03 |
1884 |
1 |
|
Conditional flag byte 3 |
MCND04 |
1885 |
1 |
|
Conditional flag byte 4 |
MCND05 |
1886 |
1 |
|
Conditional flag byte 5 |
MCND06 |
1887 |
1 |
|
Conditional flag byte 6 |
MCND07 |
1888 |
1 |
|
Conditional flag byte 7 |
MCND08 |
1889 |
1 |
|
Conditional flag byte 8 |
MCND09 |
1890 |
1 |
|
Conditional flag byte 9 |
MCND10 |
1891 |
1 |
|
Conditional flag byte 10 |
MUSFL1 |
1892 |
1 |
|
Reg/sec/unreg code |
MUSFL2 |
1893 |
1 |
|
Seg/sec report line |
MUSFL3 |
1894 |
1 |
|
Net liquidity class |
MUSFL4 |
1895 |
1 |
|
Net equity class |
MUSFL5 |
1896 |
1 |
|
Cross margin indicator |
MUSFL6 |
1897 |
1 |
|
Group net equity code |
MUSFL7 |
1898 |
1 |
|
Unused |
MUSFL8 |
1899 |
1 |
|
Unused |
MUSFL9 |
1900 |
1 |
|
Unused |
MUSFLA |
1901 |
1 |
|
Unused |
MUKFL1 |
1902 |
1 |
|
UK flag 1 |
MUKFL2 |
1903 |
2 |
|
UK flag 2 |
MUKFL3 |
1905 |
1 |
|
UK flag 3 |
MUKFL4 |
1906 |
1 |
|
UK flag 4 |
MFRFL1 |
1907 |
1 |
|
FR flag 1 |
MFRFL2 |
1908 |
1 |
|
FR flag 2 |
MFRFL3 |
1909 |
1 |
|
FR flag 3 |
MJPFL1 |
1910 |
1 |
|
JP flag 1 |
MJPFL2 |
1911 |
1 |
|
JP flag 2 |
MJPFL3 |
1912 |
1 |
|
JP flag 3 |
MHKFL1 |
1913 |
1 |
|
HK flag 1 |
MGEFL1 |
1914 |
1 |
|
GE flag 1 |
MITFL1 |
1915 |
1 |
|
FR flag 3 |
EOREC |
1916 |
2 |
|
End of record |
Sample
MXXXXXXXXXXXXXXXXCFGBPBPUSDUSD 0 0 3 US XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX20150703 020150613FRRG7502RM .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 7510.86 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1.84264990 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 7510.86 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 1.84264990 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -11266.30 .00 .00 1.84264990 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 11266.30 11266.30 11266.30 .00 .00 .00 .00 .00 .00 11266.30 11266.30 .00 11266.30 F 52 2
MXXXXXXXXXXXXXXXXCFJPYJYUSDUSD 0 0 3 US XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX20150703 020150613FRRG7502RM .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -176736.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00871877 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -176736.00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00871877 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 265104.00 .00 .00 114.69499990 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 .00 -265104.00 -265104.00 -265104.00 .00 .00 .00 .00 .00 .00 -265104.00 -265104.00 .00 -265104.00 F 52 2