SRAllocationNoticeStatus

V8 Message Definiton

METADATA

Attribute	Value
Topic	3695-order-allocation
MLink Token	ClientTrading
Product	SRTrade
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
allocNumber	BIGINT	PRI	0	matches AllocationNoticepkeyallocNumber
status	enum - AllocationStatus		'None'	Queued file pathway in file queue awaiting eject rule N records or M seconds xxxErr after a required bustamend the destination cannot accept manual intervention ExternDlvry delivery is external to SR allocStyleNone the record is complete and SR will never send it terminal bustsamends republish as ExternDlvry never xxxErr
rejectReason	TINYTEXT		''
secKey_at	enum - AssetType		'None'	security key stock future or option
secKey_ts	enum - TickerSrc		'None'	security key stock future or option
secKey_tk	VARCHAR(12)		''	security key stock future or option
secKey_yr	SMALLINT UNSIGNED		0	security key stock future or option
secKey_mn	TINYINT UNSIGNED		0	security key stock future or option
secKey_dy	TINYINT UNSIGNED		0	security key stock future or option
secKey_xx	DOUBLE		0	security key stock future or option
secKey_cp	enum - CallPut		'Call'	security key stock future or option
secType	enum - SpdrKeyType		'None'	security type
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
allocNumber	1

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgSRAllocationNoticeStatus`
WHERE 
    /* Replace with a BIGINT */ 
    `allocNumber` = 1234567890;

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SRAllocationNoticeStatus' ORDER BY ordinal_position ASC;