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