HoldingTransaction

Section: Position Keeping

Metadata

Base Table Class: Entity
Default Size: 1000

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this HoldingTransaction. Not editable Read-only
Status	Set of Status	4
ExternalTimestamp	Integer (unsigned)	8
RecordId	Integer (signed)	8
Holding	Foreign key to Holding	8	A Holding describes the position held by an Account_ for a given Instrument_. Such a position is a combination of the balance at the start of the day and the aggregate actual buys and sells completed since the opening balance. In addition, the balances of planned transactions (effectively the unmatched Order_ records) are also recorded here for the purposes of monitoring and risk management.
PairedHoldingTransaction	Foreign key to HoldingTransaction	8
Instrument	Foreign key to Instrument	8	An Instrument is the entity that represents something to be traded in MarketGrid. In order for an Instrument to trade it must be listed on a Market_ to produce an InstrumentMarket_. Each Instrument may be traded simultaneously on one or more Markets, each such instance being an InstrumentMarket_. Required
Tag	String	50	For tagged Instruments, this is the identifier of the individual holding.
ExternalId	String	30	A place for writing the identifier of this HoldingTransaction at the external venue where it is managed.
ExternalTransactionId	String	20	A place for writing the identifier of the external transaction that is connected with this HoldingTransaction record at the external venue to which it is related.
ExternalAccount	Foreign key to ExternalAccount	8	This is a reference to the ExternalAccount table. It is keyed by the ExternalAccount column in this table to the Id column in the ExternalAccount table.
Quantity	Integer (signed)	8	Decimals: null
PrevQuantity	Integer (signed)	8	Decimals: null
Type	One of HoldingTransactionType	1
HoldingTransactionStatus	One of HoldingTransactionStatus	1
ExternalStatus	String	1024
Reason	One of HoldingTransactionReason	1	A reason code to indicate why this HoldingTransaction was created.
SuspenseAccountReason	One of Result	2	For banking transactions on the Suspense Account, this is a Result code that indicates why the transaction is in the Suspense Account
VerifyExternal	Integer (unsigned)	1
NoParent	Integer (unsigned)	1
ProjectId	String	50	The identifier of the specific project at the external register associated with this HoldingTransaction record.
Vintage	Integer (unsigned)	4	A year in YYYY format.
ProjectType	Foreign key to ProjectType	8	This is a reference to the ProjectType table. It is keyed by the ProjectType column in this table to the Id column in the ProjectType table.
Region	Foreign key to Region	8	This is a reference to the Region table. It is keyed by the Region column in this table to the Id column in the Region table.
Country	Foreign key to Country	8	This is a reference to the Country table. It is keyed by the Country column in this table to the Id column in the Country table.
Trade	Foreign key to Trade	8	If this transaction is related to settlement of a trade, this is the particular trade to which it applies.
TradeSettlementType	One of TradeSettlementType	1	The type of trade settlement transaction.
TradeCostsAction	One of TradeCostsAction	1	The action for a trade costs transaction.
HoldingTransactionMetaData	String	2000	A free-format field with pass-through information for the Holding Transaction.
TradeReport	Foreign key to Order	8	Used for XCHG where we may create a holding transaction from a TwoSideReport.
LinkedHoldingTransaction	Foreign key to HoldingTransaction	8	For a transaction resulting from a bank ACH return, this links back to the transaction generated by the original ACH request.
HoldingBalance	Integer (signed)	8	Balance of the Holding at the time of the transaction. Decimals: null
HoldingAvailableBalance	Integer (signed)	8	AvailableBalance of the Holding at the time of the transaction. Decimals: null
HoldingAvailableToTransfer	Integer (signed)	8	Useable balance of the Holding at the time of the transaction. Decimals: null
HoldingTransactionSource	One of Source	1
CreateMemo	String	100
VerifyMemo	String	100
ConfirmAfterDays	Integer (unsigned)	2	If not zero, is the number of days after being posted by JPM that the transaction may become confirmed. If set, takes precedence over ConfirmAfter and will set ConfirmAfter once the transaction is posted by JPM.
ConfirmAfter	Integer (unsigned)	8	If not null, is the date/time after which an incoming ACH deposit may become confirmed.
IsForNetting	Integer (unsigned)	1
IsPayrollProceeds	Integer (unsigned)	1
UpdateNumber	Integer (unsigned)	8	A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. Not editable
OwnerUser	Foreign key to User	8	The Id of the User that owns this HoldingTransaction.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this HoldingTransaction.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this HoldingTransaction.
CreateUser	Foreign key to User	8	The Id of the User that created this HoldingTransaction. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this HoldingTransaction was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this HoldingTransaction. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this HoldingTransaction was last updated. Not editable Read-only

Foreign Keys

The following diagram shows the tables that have a foreign key link to the HoldingTransaction table. All Table nodes can be clicked to take you to that table's definition page.

graph LR;
	BankTransaction-->|HoldingTransaction|HoldingTransaction
	click BankTransaction "/marketgrid/developer/model/tables/BankTransaction"