MT540-543 File Upload Specs

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 11

STB USA a/c Customer Ref# Order ID Message Type Original Cust Ref Transaction Type ISIN Cusip

nsaction Type ISIN Cusip Sedol SECURITY DESCRPTION Country Currency


23G:NEWM/CANC REQU. W/CANC T:MT 35B: 35B: 35B: 35B:line 2 ISO Code

100097260 6228330 ID123 NEWM DVP B0FLLH1


APN/UKA European Retail-FP AU AUD
100097203 6228331 ID124 NEWM DVP 5710360
Warehouses De Pauw SCA BE EUR
100097229 6228332 ID125 NEWM DF B0FLLH1
APN/UKA European Retail-FP AU AUD
100097229 6228333 ID126 NEWM RVP 22002T108 Corporate Office US USD
100097229 6228334 ID127 NEWM RVP 929042109 Vornado Realty US USD
100097229 6228335 ID128 NEWM RVP 05564E502 BRE Properties 6.75 Series C US USD
100097229 6228336 ID129 NEWM RF 7595747 Silic FR EUR
100097229 6228337 ID130 NEWM RVP 4948623 Wereldhave NV NL EUR
100097229 6228338 ID131 NEWM DVP B1VP947 Alstria DE EUR
100097229 6228339 ID132 NEWM RVP 265274 Derwent London Plc GB GBP
100097229 6228340 ID133 NEWM RVP 0136701 British Land Co Plc GB GBP
100097229 6228341 ID134 NEWM RVP 3180943 Land Securities Group Plc GB GBP
100097229 6228342 ID135 CANC ID100 RVP B1YFN97 Segro Plc GB GBP

= mandatory
= conditional All Trades can be cancelled via File
Upload.
= pulled from tables set up on Web
= info only: not on Swift - only used for setting up new broker
Executing Broker (Who holds the account at delivering party?) Executing BIC Code Executing broker's custody a/c at clearing broker Clearing Broker (delivering party in local mkt) Clearing Broker BIC Code Trade Dt
95P:BUYR/ 98A/TRAD

Macquerie AU BSHLHKHH Macquerie Securities(Australia) MACQAU2E 20090311


Kempen & Co KASANL2A 223609153 Kas Bank KASANL2A 20090311
Macquerie AU BSHLHKHH Macquerie Securities(Australia) MACQAU2E 20090311
Citigrou SBNYUS33 CITIGROUP GLOBAL MARKETS INC SBSIUS33 20090311
Citigrou SBNYUS33 CITIGROUP GLOBAL MARKETS INC SBSIUS33 20090311
Citigrou SBNYUS33 CITIGROUP GLOBAL MARKETS INC SBSIUS33 20090311
Kempen KASANL2A 223609153 Kas Bank KASANL2A 20090311
Kempen KASANL2A 223630160 Kas Bank KASANL2A 20090311
Kempen & Co KASANL2A 223609153 Kas Bank KASANL2A 20090311
JPMorgan Cazenove CAZEGB2L JPMorgan Cazenove CAZEGB2L 20090311
Green Street Advisors PERLGB2L Green Street Advisors PERLGB2L 20090311
Morgan Stanley MSSEGB21 Morgan Stanley Securities MSSEGB21 20090311
Morgan Stanley MSSEGB21 Morgan Stanley Securities MSSEGB21 20090311
Settl. Dt. QTY/FMT PRICE Percent/Unit GROSS COMMISSION SEC FEE Stamp MISC. EXPENSE ACCRUED INTEREST Paydown Face NET Optional 1 PSET Optional2 Optional2
98A/SETT 36B:SETT 90A:DEAL 90A:DEAL 19A:DEAL 19A:COMM 19A:ACRU 19A:SETT 95P:PSET

20090316 10380 0.018 UNIT 186.84 0.28 0.03 186.53 SALE CAETAU21 9427
20090316 493 27.1746 UNIT 13,397.08 13.4 13,383.68 SALE CIKBBEBB 9417 EGSP 642
20090316 143179 UNIT DF CAETAU21 9422
20090316 2000 23.1618 UNIT 46,323.60 80 46,403.60 BUY DTCYUS33 9422
20090316 4000 35.0463 UNIT 140,185.20 160 140,345.20 BUY DTCYUS33 9422
20090316 1100 12.47 UNIT 13,717.00 0 13,717.00 BUY DTCYUS33 9422
20090316 1,300 UNIT RF SICVFRPP 9422 SICOVAM 642
20090316 4,800 48.5728 UNIT 233,149.44 233.15 233,382.59 BUY NECINL2A 9422 NECIGEF 642
20090313 18,000 3.4883 UNIT 62,789.40 62.79 62,726.61 SALE DAKVDEFF 9422 KV 7619
20090316 26,478 5.04 UNIT 133,449.12 200.17 668.25 1 134,318.54 BUY CRSTGB22 9422 CREST ID 142
20090316 44,000 3.1226 UNIT 137,394.40 206.09 686.97 1 138,288.46 BUY CRSTGB22 9422 CREST ID 601
20090316 105,000 3.4964 UNIT 367,122.00 550.68 1,838.36 1 369,512.04 BUY CRSTGB22 9422 CREST ID 50701
20090316 35,000 1.0539 UNIT 36,886.50 55.33 184.71 1 37,127.54 BUY CRSTGB22 9422 CREST ID 50701
Special instructions
Field Name Description Mandatory/Optional/Condition
The client’s nine digit SMTBUSA
STB USA a/c custody account number. Mandatory

Customer Ref# The client’s unique reference for the trad Mandatory
Order ID - -
Message Type NEWM -
Original Cust Ref - -
Transaction Type Options are Receive Free (MT540), DelivMandatory
ISIN Security ID. Format validation is perform Mandatory
Cusip Security ID. Format validation is perform Mandatory
Sedol Security ID. Format validation is perform Mandatory

SECURITY DESCRPTION Description of Security Mandatory


Country Country Code Mandatory

Currency Currency Code Mandatory

Executing Broker (Who holds the


account at delivering party?) Broker Name Optional

Executing BIC Code Executing Broker BIC Mandatory


Executing broker's custody a/c at
clearing broker Custoday account at clearing broker Optional
Clearing Broker (delivering party in
local mkt) Broker Name Optional

Clearing Broker BIC Code Clearing Broker BIC Mandatory

Trade Dt Trade date of the transaction Mandatory

Settl. Dt. Settlement date of the transaction Mandatory


QTY/FMT # of shares/ face amount of bonds Mandatory

Unit Price. Only for Buy/Sell. Ignore for


PRICE Free deliver and Free receive Conditional

Percent/Unit UNIT = Value; FAMT = Percent Conditional

GROSS Validate vs. Trans Type Conditional


COMMISSION COMMISSION Conditional
SEC FEE SEC FEE Conditional
Stamp Stamp Conditional
MISC. EXPENSE MISC. EXPENSE Conditional
ACCRUED INTEREST ACCRUED INTEREST Conditional
Paydown Face Paydown Face Conditional
NET Validate per Entry rules + trans type Conditional
Optional 1 - Optional
PSET BIC Code Mandatory
Optional2 - Optional
Optional3 - Optional
Special instructions Any special instruction Optional
Validation/Field length
9 characters. Must conform to
SMTBUSA account convention
A/N Maximum 16 characters -
unique for Client
-

-
?
ISIN :12 digit alpha numeric
CUSIP : 9 digit alpha numeric
SEDOL:7 digit alpha numeric
Check for ISIN first; Then SEDOL;
then CUSIP, as available.
Alpha Numeric should exists i.e.
Validation fails if only special
characters in this field.
2 digit Country code
3 digit Currency code.
Validate with SMTBUSA
currencies
Alpha Numeric and Special
Characters, maximum 40
characters.
max 25 digits; >0
Validate with client and PSET in
the Broker set up

max 25 digits; >0

max 25 digits; >0


Validate with client and PSET in
the Broker set up
Validate - date format min - 90
days pervious to current date; max
today +1
- Settlement date >= Trade date
- Settlement date > Create
date/Current Biz date.
-Settlement date can be any future
date.
max 15 digits; >0

Validate vs. Trans Type.


max 8 decimals; ignore for RF/DF
Required for DVP/RVP one of
UNIT or FAMT
Required for DVP/RVP; numeric
>0; valid error check for Price *
Quantity
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
Ignore for RF/DF; numeric
max 140 characters
Validate PSET
max 140 characters
max 140 characters
max 140 characters
File Name Upload Date/Time Total # Records Total # Records Successful
trades.xls May-15-2020 @ 5:00 PM 3 3
Error Description Row Status STB USA a/c Customer Ref Order ID Message Typ Transaction T ISIN
Success 100097229 6228333 ID126 NEWM RVP
Success 100097229 6228334 ID127 NEWM RVP
Success 100097229 6228335 ID128 NEWM RVP

Transaction Type' missing


'Security ID' missing
'Trade Dt' missing Error 100097260 6228330 ID123 NEWM
Success 100097203 6228331 ID124 NEWM DVP
STB USA a/c' invalid format Error AB1000972296228332 ID125 NEWM DF
cords Successful Total # Records Error
0
Cusip Sedol SECURITY D Country Currency Executing BI Clearing Brok Trade Dt Settl. Dt. QTY/FMT
22002T108 Corporate Off US USD SBNYUS33 SBSIUS33 20090311 20090316 2000
929042109 Vornado Real US USD SBNYUS33 SBSIUS33 20090311 20090316 4000
05564E502 BRE PropertieUS USD SBNYUS33 SBSIUS33 20090311 20090316 1100

APN/UKA EuroAU AUD BSHLHKHH MACQAU2E 20090311 20090316 10380


5710360 Warehouses BE EUR KASANL2A KASANL2A 20090311 20090316 493
B0FLLH1 APN/UKA EuroAU AUD BSHLHKHH MACQAU2E 20090311 20090316 143179
PRICE Percent/Unit GROSS NET PSET
23.1618 UNIT 46,323.60 46,403.60 DTCYUS33
35.0463 UNIT 140,185.20 140,345.20 DTCYUS33
12.47 UNIT 13,717.00 13,717.00 DTCYUS33

0.018 UNIT 186.84 186.53 CAETAU21


27.1746 UNIT 13,397.08 13,383.68 CIKBBEBB
UNIT CAETAU21

You might also like