Contains previous day’s account activity. FCMs choose one of two types of reporting:
• T-type statements provide transaction data for the current day
• P-type statements provide up to 19 days of purchase and sales data
Name |
Position |
Length |
Decimal |
Description |
PRECID |
1 |
1 |
|
Record ID |
PFIRM |
2 |
1 |
|
Firm ID |
POFFIC |
3 |
3 |
|
Office number |
PACCT |
6 |
5 |
|
Account number |
PATYPE |
11 |
2 |
|
Account type in which future should be carried |
PCUSIP |
13 |
12 |
|
CUSIP number |
PCUSP2 |
25 |
12 |
|
CUSIP part 2 |
PCTYM |
37 |
6 |
|
Contract year and month, yyyymm |
PSBCUS |
43 |
2 |
|
Sub-CUSIP/prompt day/forward day |
PSTYPE |
45 |
1 |
|
Security type code |
PSUBTY |
46 |
1 |
|
Security sub-type |
PSTYP2 |
47 |
1 |
|
Repo/reverse repo/OTC put & call etc. |
PSTRIK |
48 |
17 |
8 |
Strike price, iiiiiiiddddddddd |
PEXPDT |
65 |
11 |
0 |
Expiration date |
PSUBAC |
76 |
10 |
|
Sub-account ID |
PDEAL |
86 |
7 |
|
Deal ID |
PTDATE |
93 |
11 |
0 |
Trade date, 0yyyymmdd |
PTPRIC |
104 |
17 |
8 |
Trade price, iiiiiiidddddddd |
PBS |
121 |
1 |
|
Buy/sell code |
PLOC |
122 |
1 |
|
Location code |
PBROKR |
123 |
2 |
|
Broker code |
PSPRED |
125 |
1 |
|
Spread code |
PTRACE |
126 |
10 |
|
Tracer number field, y-m-dd-nnnnn-s |
PICODE |
136 |
3 |
|
Instrument code |
PREFNO |
139 |
12 |
|
Source reference number |
PSWAC1 |
151 |
12 |
|
Swap side 1 CUSIP |
PSWAP1 |
163 |
1 |
|
Swap side 1 prod type |
PSWAS1 |
164 |
1 |
|
Swap side 1 security type |
PSWAC2 |
165 |
12 |
|
Swap side 2 CUSIP |
PSWAP2 |
177 |
1 |
|
Swap side 2 prod type |
PSWAS2 |
178 |
1 |
|
Swap side 2 security type |
PZONE |
179 |
1 |
|
Processing time zone |
PACNTY |
180 |
2 |
|
Account foreign country/province code |
PCLASS |
182 |
1 |
|
Account class code |
PSUBCL |
183 |
1 |
|
Sub-class code |
PRR |
184 |
5 |
|
Registered representative |
PRISKG |
189 |
3 |
|
Risk group ID |
PMEMBR |
192 |
1 |
|
Member code |
PSNAME |
193 |
20 |
|
Short name |
PSRCAC |
213 |
10 |
|
Source A/C number |
PREFOF |
223 |
3 |
|
Referred office |
PREFRR |
226 |
5 |
|
Referred RR code |
POFFFN |
231 |
1 |
|
Offset A/C firm number |
POFFOF |
232 |
3 |
|
Offset office number |
POFFAC |
235 |
5 |
|
Offset account number |
POFFAT |
240 |
2 |
|
Offset account type |
PMPGMN |
242 |
2 |
|
Managed account program |
PSTATA |
244 |
1 |
|
Status byte a |
PSTATB |
245 |
1 |
|
Status byte b |
PSTATC |
246 |
1 |
|
Status byte c |
PSTATD |
247 |
1 |
|
Status byte d |
PSTATE |
248 |
1 |
|
Status byte e |
PSTATF |
249 |
1 |
|
Status byte f |
PSTATG |
250 |
1 |
|
Status byte g |
PSTATH |
251 |
1 |
|
Status byte h |
PSTATJ |
252 |
1 |
|
Status byte j |
PSTATK |
253 |
1 |
|
Status byte k |
PSTAT1 |
254 |
1 |
|
Status byte 1 |
PSTAT2 |
255 |
1 |
|
Status byte 2 |
PSTAT3 |
256 |
1 |
|
Status byte 3 |
PSTAT4 |
257 |
1 |
|
Status byte 4 |
PSTAT5 |
258 |
1 |
|
Status byte 5 |
PSTAT6 |
259 |
1 |
|
Status byte 6 |
PSTAT7 |
260 |
1 |
|
Status byte 7 |
PSTAT8 |
261 |
1 |
|
Status byte 8 |
PSTAT9 |
262 |
1 |
|
Status byte 9 |
PQTEDT |
263 |
1 |
|
Quantity edit code |
PQTY |
264 |
17 |
4 |
Quantity e.g. 90000.0000 |
PPRTQ |
281 |
15 |
|
Quantity, printable e.g. 90,000 |
PBUSTQ |
296 |
17 |
4 |
Bust quantity |
PMAKEQ |
313 |
17 |
4 |
Make-up quantity |
PLEAVQ |
330 |
17 |
4 |
Leave quantity |
PSEGQ |
347 |
17 |
4 |
Portion of PQTY that is in segregated status |
PTFRQ |
364 |
17 |
4 |
Portion of PQTY that is in transfer status |
PDLVYQ |
381 |
17 |
4 |
Delivery quantity |
PDLVYA |
398 |
17 |
2 |
Delivery amount |
PSDSC# |
415 |
3 |
0 |
Number of security description lines |
PSDSC1 |
418 |
30 |
|
Security description line1 |
PSDSC2 |
448 |
30 |
|
Security description line 2 |
PSDSC3 |
478 |
30 |
|
Security description line 3 |
PTDSC# |
508 |
3 |
0 |
Number of transact description lines |
PTDSC1 |
511 |
30 |
|
Trade descriptor line 1 |
PTDSC2 |
541 |
30 |
|
Trade descriptor line 2 |
PTDSC3 |
571 |
30 |
|
Trade descriptor line 3 |
PMKVAL |
601 |
17 |
2 |
Market value or open trade equity |
PYSTMV |
618 |
17 |
2 |
Yesterday’s market value |
PMULTF |
635 |
17 |
7 |
Multiplication factor |
PSDATE |
652 |
11 |
0 |
Settlement last activity, yyyymmdd |
PEXRAT |
663 |
17 |
8 |
Currency exchange rate |
PRXDAT |
680 |
11 |
0 |
Record/Ex-div. date |
PIAD |
691 |
11 |
3 |
Indicated annual dividend |
PYIELD |
702 |
11 |
8 |
Yield |
PDCTCO |
713 |
17 |
8 |
Percent discount/concessions/repo rate |
PDELTA |
730 |
7 |
4 |
Delta factor |
PLTDAT |
737 |
11 |
0 |
Last trading date |
PCTLNO |
748 |
10 |
|
Clearing ID number or rec. number of contra side |
PPCNTY |
758 |
2 |
|
Product foreign country/province code |
PEXCHANGE |
760 |
2 |
|
Exchange code |
PFC |
762 |
2 |
|
Futures code |
PTYPE |
764 |
1 |
|
Contract type code |
PSYMBL |
765 |
6 |
|
Symbol |
PPTYPE |
771 |
1 |
|
Product type code |
PSUBEX |
772 |
1 |
|
Sub-exchange |
PTRDEX |
773 |
2 |
|
Exchange where traded |
PMATDT |
775 |
11 |
0 |
Bond maturity date |
PPRTPR |
786 |
11 |
|
Printable trade price |
PBASIS |
797 |
11 |
8 |
Basis price |
PCLOSE |
808 |
17 |
8 |
Closing market price or settlement price |
PPRCDT |
825 |
11 |
0 |
Date priced |
PPRTCP |
836 |
11 |
|
Printable closing price |
PUNDCP |
847 |
17 |
8 |
Underlying close price |
PPRTUC |
864 |
11 |
|
Printable underlying close |
PPRVCP |
875 |
17 |
8 |
Previous closing price |
PTRPRC |
892 |
17 |
8 |
Trade reported price |
PEXPR |
909 |
7 |
|
Input exercise price, iiiiiii |
PPRICE |
916 |
12 |
|
Input trade price |
PSPEDT |
928 |
1 |
|
Strike price edit code |
PTPEDT |
929 |
1 |
|
Trade price edit code |
PCURSY |
930 |
3 |
|
Product currency symbol |
PCURCD |
933 |
2 |
|
Product currency code |
PCALC |
935 |
1 |
|
Trade calculation control code |
PCMNT1 |
936 |
2 |
|
Comment code 1 |
PCMNT2 |
938 |
2 |
|
Comment code 2 |
PCMNT3 |
940 |
2 |
|
Comment code 3 |
PLEGND |
942 |
2 |
|
Legend code |
POMNCD |
944 |
1 |
|
Omnibus code |
PRTHT |
945 |
1 |
|
Round-turn/half-turn code |
PSCHDL |
946 |
2 |
|
Commission schedule |
POC |
948 |
1 |
|
Open/close code |
PCOD |
949 |
1 |
|
C-O-D code |
PUCUSP |
950 |
12 |
|
Underlying CUSIP number |
PCVTBL |
962 |
17 |
8 |
Convertible security ratio |
PEXBKR |
979 |
5 |
|
Executing broker or finder |
POPBKR |
984 |
5 |
|
Opposing broker |
POPFRM |
989 |
5 |
|
Opposite firm |
PGIVIO |
994 |
2 |
|
Give in/out code |
PGIVF# |
996 |
5 |
|
Give in/out firm number |
PIEXNG |
1001 |
2 |
|
Interexchange exchange |
PIEFRM |
1003 |
5 |
|
Interexchange firm |
PCARD |
1008 |
4 |
|
Card number |
PORDER |
1012 |
25 |
|
Order number |
PCHIT |
1037 |
15 |
|
Input chit number |
PFEECL |
1052 |
1 |
|
Clearing fee code |
PFEEEX |
1053 |
1 |
|
Exchange fee code |
PCTI |
1054 |
1 |
|
Customer type indicator |
PORDTY |
1055 |
3 |
|
Order type code |
PORDOR |
1058 |
2 |
|
Order originator |
PTIME |
1060 |
6 |
|
Trade execution time, hhmmss |
PTBKT |
1066 |
2 |
|
Time bracket code |
PSESSN |
1068 |
1 |
|
Trading session code |
PSTINS |
1069 |
2 |
|
Equity standing instructions |
PTTYPE |
1071 |
1 |
|
Futures trade type or securities trade code |
PBARG1 |
1072 |
2 |
|
Bargn 1 |
PBARG2 |
1074 |
2 |
|
Bargn 2 |
PBARG3 |
1076 |
2 |
|
Bargn 3 |
PBARG4 |
1078 |
2 |
|
Bargn 4 |
PBARG5 |
1080 |
2 |
|
Bargn 5 |
PMTABL |
1082 |
1 |
|
Margin table ID |
PMINIT |
1083 |
17 |
2 |
Initial margin on trade |
PMVARN |
1100 |
17 |
2 |
Variation margin due on trade |
PMUNTL |
1117 |
11 |
0 |
Margin until date, yymmdd |
PMGNCV |
1128 |
17 |
2 |
Collateral margin value |
PREL1F |
1145 |
1 |
|
Related firm number 1 |
PREL1O |
1146 |
3 |
|
Related office number 1 |
PREL1A |
1149 |
5 |
|
Related account number 1 |
PREL1T |
1154 |
1 |
|
Related type number 1 |
PREL2F |
1155 |
1 |
|
Related firm number 2 |
PREL2O |
1156 |
3 |
|
Related office number 2 |
PREL2A |
1159 |
5 |
|
Related account number 2 |
PREL2T |
1164 |
1 |
|
Related type number 2 |
PREL3F |
1165 |
1 |
|
Related firm number 3 |
PREL3O |
1166 |
3 |
|
Related office number 3 |
PREL3A |
1169 |
5 |
|
Related account number 3 |
PREL3T |
1174 |
1 |
|
Related type number 3 |
PCOMM |
1175 |
17 |
2 |
Commission amount |
PFEE1 |
1192 |
17 |
2 |
Fee amount 1 for clearing fee/bond interest/st tax |
PFEE2 |
1209 |
17 |
2 |
Fee amount 2 for exchange fee/postage |
PFEE3 |
1226 |
17 |
2 |
Fee amount 3 for NFA or sec fees or finder's percent |
PFEE4 |
1243 |
17 |
2 |
Fee amount 4 for exec charge or 2nd commission |
PFEE5 |
1260 |
17 |
2 |
Fee amount 5 |
PFEE6 |
1277 |
17 |
2 |
Fee amount 6 |
PFEE7 |
1294 |
17 |
2 |
Fee amount 7 |
PFEE8 |
1311 |
17 |
2 |
Fee amount 8 |
PFEE9 |
1328 |
17 |
2 |
Fee amount 9 |
PGICHG |
1345 |
17 |
2 |
Give in/out charge |
PBKCHG |
1362 |
17 |
2 |
Brokerage charge |
POTHER |
1379 |
17 |
2 |
Other charges |
PGROSS |
1396 |
17 |
2 |
Gross amount |
PNET |
1413 |
17 |
2 |
Net amount |
PMBKOF |
1430 |
17 |
2 |
Back office charge |
PMFLOR |
1447 |
17 |
2 |
Floor charges |
PMORDR |
1464 |
17 |
2 |
Order desk charges |
PMWIRE |
1481 |
17 |
2 |
Wire charges |
PMOTHR |
1498 |
17 |
2 |
Other allocation charges |
PATCOM |
1515 |
2 |
|
Account type to which commission is post |
PATFE1 |
1517 |
2 |
|
Account type to which fee 1 is posted |
PATFE2 |
1519 |
2 |
|
Account type to which fee 2 is posted |
PATFE3 |
1521 |
2 |
|
Account type to which fee 3 is posted |
PATFE4 |
1523 |
2 |
|
Account type to which fee 4 is posted |
PATFE5 |
1525 |
2 |
|
Account type to which fee 5 is posted |
PATFE6 |
1527 |
2 |
|
Account type to which fee 6 is posted |
PATFE7 |
1529 |
2 |
|
Account type to which fee 7 is posted |
PATFE8 |
1531 |
2 |
|
Account type to which fee 8 is posted |
PATFE9 |
1533 |
2 |
|
Account type to which fee 9 is posted |
PATGIV |
1535 |
2 |
|
Account type to which give in/out amount is posted |
PATBKG |
1537 |
2 |
|
Account type to which brokerage is posted |
PATOTH |
1539 |
2 |
|
Account type to which other charges are posted |
PATBKO |
1541 |
2 |
|
Account type to which back office allocation is posted |
PATFLR |
1543 |
2 |
|
Account type to which floor allocation is posted |
PATORD |
1545 |
2 |
|
Account type to which order allocation is posted |
PATWIR |
1547 |
2 |
|
Account type to which wire allocation is posted |
PATALO |
1549 |
2 |
|
Account type to which other allocation charges are posted |
PFDCOM |
1551 |
1 |
|
Field define code for commission |
PFDFE1 |
1552 |
1 |
|
Field define code for fee 1 |
PFDFE2 |
1553 |
1 |
|
Field define code for fee 2 |
PFDFE3 |
1554 |
1 |
|
Field define code for fee 3 |
PFDFE4 |
1555 |
1 |
|
Field define code for fee 4 |
PFDFE5 |
1556 |
1 |
|
Field define code for fee 5 |
PFDFE6 |
1557 |
1 |
|
Field define code for fee 6 |
PFDFE7 |
1558 |
1 |
|
Field define code for fee 7 |
PFDFE8 |
1559 |
1 |
|
Field define code for fee 8 |
PFDFE9 |
1560 |
1 |
|
Field define code for fee 9 |
PFDGIV |
1561 |
1 |
|
Field define code for give in/out amount |
PFDBKG |
1562 |
1 |
|
Field define code for brokerage |
PFDOTH |
1563 |
1 |
|
Field define code for other charges |
PFDBKO |
1564 |
1 |
|
Field define code for back office allocation |
PFDFLR |
1565 |
1 |
|
Field define code for floor allocation |
PFDORD |
1566 |
1 |
|
Field define code for order allocation |
PFDWIR |
1567 |
1 |
|
Field define code for wire allocation |
PFDALO |
1568 |
1 |
|
Field define code for other allocation charges |
PFUFE1 |
1569 |
1 |
|
Field usage code for fee 1 |
PFUFE2 |
1570 |
1 |
|
Field usage code for fee 2 |
PFUFE3 |
1571 |
1 |
|
Field usage code for fee 3 |
PFUFE4 |
1572 |
1 |
|
Field usage code for fee 4 |
PFUFE5 |
1573 |
1 |
|
Field usage code for fee 5 |
PFUFE6 |
1574 |
1 |
|
Field usage code for fee 6 |
PFUFE7 |
1575 |
1 |
|
Field usage code for fee 7 |
PFUFE8 |
1576 |
1 |
|
Field usage code for fee 8 |
PFUFE9 |
1577 |
1 |
|
Field usage code for fee 9 |
PFUGIV |
1578 |
1 |
|
Field usage code for give in/out amount |
PFUBKG |
1579 |
1 |
|
Field usage code for brokerage |
PFUOTH |
1580 |
1 |
|
Field usage code for other charges |
PFUBKO |
1581 |
1 |
|
Field usage code for back office allocation |
PFUFLR |
1582 |
1 |
|
Field usage code for floor allocation |
PFUORD |
1583 |
1 |
|
Field usage code for order allocation |
PFUWIR |
1584 |
1 |
|
Field usage code for wire allocation |
PFUALO |
1585 |
1 |
|
Field usage code for other allocation charges |
POVNQ |
1586 |
17 |
4 |
Overnight quantity field |
PDAYQ |
1603 |
17 |
4 |
Day quantity |
PSCRQ |
1620 |
17 |
4 |
Scratch quantity |
PSPDQ |
1637 |
17 |
4 |
Spread quantity |
POVNC |
1654 |
17 |
2 |
Overnight commission amount |
PDAYC |
1671 |
17 |
2 |
Day commission amount |
PSCRC |
1688 |
17 |
2 |
Scratch commission amount |
PSPDC |
1705 |
17 |
2 |
Spread commission |
PSORTK |
1722 |
50 |
|
Position file sort key |
PLEVEL |
1772 |
3 |
|
File revision level |
PBATCH |
1775 |
3 |
|
Batch number |
PRECNO |
1778 |
8 |
0 |
Relative record number |
PCLRID |
1786 |
11 |
|
Clearing house sequence ID |
PINPMO |
1797 |
1 |
|
Input month code |
PINPYR |
1798 |
2 |
|
Input year code |
PFBACC |
1800 |
5 |
|
Market maker account ID |
PORIG |
1805 |
1 |
|
Clearing house origin code or futures & options |
PCABCD |
1806 |
1 |
|
Cabinet code |
PSCHOV |
1807 |
2 |
|
Futures/options commission schedule override |
PPGMID |
1809 |
2 |
|
Program ID |
PSCRID |
1811 |
2 |
|
Input screen ID |
PUSER |
1813 |
10 |
|
User ID |
PWSID |
1823 |
10 |
|
Workstation ID |
PWSTIM |
1833 |
9 |
0 |
Workstation entry time |
PDEST |
1842 |
1 |
|
Destination code |
PDELET |
1843 |
1 |
|
Delete code for trade entry |
PXTRCT |
1844 |
9 |
0 |
Extraction control field |
PBQTY |
1853 |
17 |
4 |
Buy side quantity |
PSQTY |
1870 |
17 |
4 |
Sell side quantity |
PFDAM1 |
1887 |
1 |
|
Field define code for miscellaneous amount 1 |
PAMT1 |
1888 |
17 |
2 |
Miscellaneous amount 1 |
PFDAM2 |
1905 |
1 |
|
Field define code for miscellaneous amount 2 |
PAMT2 |
1906 |
17 |
2 |
Miscellaneous amount 2 |
PROUT1 |
1923 |
1 |
|
Routing code 1 |
PROUT2 |
1924 |
1 |
|
Routing code 2 |
PROUT3 |
1925 |
1 |
|
Routing code 3 |
PCURAC |
1926 |
3 |
|
Account base currency code symbol |
PCURAT |
1929 |
3 |
|
Account type currency code symbol |
PCCNTY |
1932 |
2 |
|
Country code of settlement currency |
EOREC |
1934 |
2 |
|
End of record |
Sample
TXXXXXXXXXUS.F430000006I 201509 F .00000000 0 20150703 104.00000000 2 6G03 BG450100 CJCFLA200 XXXXXXXXXXXXXXXXXXXX090 40560 F °— â m04.0000 4-.0000 .0000 .0000 .0000 .0000 .0000 .00 1 SEP 15 COFFEE 'C' 0 750.00 .00 375.0000000 20150703 1.00000000 0 .000 .00000000 .00000000 .0000 20150919 US0643 060 104.00 .00000000 103.50000000 20150703 103.50 .00000000 .00000000 .00000000 10400 CUSDUS HDP US.00000000 5961 3651 17666145CC4 0700 0.00 .00 0 .00 -8.00 .00 -5.40 -.08 .00 -8.00 .00 .00 .00 .00 .00 -8.00 .00 156000.00 156000.00 .00 .00 .00 .00 .00 USUSUSUSUSUSUSUSUSUS USUSUSUSUSUSUSMCENX4 BTYFDWKCCCMMMMMM CCMMMMM4.0000 .0000 .0000 .0000 -8.00 .00 .00 .00 F0904056001CGF43 06I00000US060703 10400 D?949481 9 6 0631CVNYBTFUT #0132928 B 0 .0000 4.0000 .00 .00 1A1USDUSDUS
TXXXXXXXXXUS.F430000006I 201509 F .00000000 0 20150703 104.00000000 2 6G03 BG460100 USCFLA200 XXXXXXXXXXXXXXXXXXXX090 40565 F Ø° â m06.0000 6-.0000 .0000 .0000 .0000 .0000 .0000 .00 1 SEP 15 COFFEE 'C' 0 1125.00 .00 375.0000000 20150703 1.00000000 0 .000 .00000000 .00000000 .0000 20150919 US0643 060 104.00 .00000000 103.50000000 20150703 103.50 .00000000 .00000000 .00000000 10400 CUSDUS HDP US.00000000 5961 3651 17666146CC4 0700 0.00 .00 0 .00 -12.00 .00 -8.10 -.12 .00 -12.00 .00 .00 .00 .00 .00 -12.00 .00 234000.00 234000.00 .00 .00 .00 .00 .00 USUSUSUSUSUSUSUSUSUS USUSUSUSUSUSUSMCENX4 BTYFDWKCCCMMMMMM CCMMMMM6.0000 .0000 .0000 .0000 -12.00 .00 .00 .00 F0904056501CGF43 06I00000US060703 10400 D?949483 9 6 0631CVNYBTFUT #0132928 B 0 .0000 6.0000 .00 .00 1A1USDUSDUS