VirtualReferenceNumber

This table holds Virtual Reference Numbers (VRN) for JPMorgan linked accounts. VRN information is a list of all acquired VRN and what accounts they're associated with. If a VRN association is removed (eg. account is assigned a new one), the old one is put in 'Suspended' status.

Section: CartaX

Metadata

Base Table Class: Static
Default Size: Account = 500

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this VirtualReferenceNumber. Not editable Read-only
Status	Set of Status	4
VirtualReferenceNumber	String	20	JPMorgen issued VRN. Required
Account	Foreign key to Account	8	Account this VRN is linked to.
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 VirtualReferenceNumber.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this VirtualReferenceNumber.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this VirtualReferenceNumber.
CreateUser	Foreign key to User	8	The Id of the User that created this VirtualReferenceNumber. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this VirtualReferenceNumber was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this VirtualReferenceNumber. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this VirtualReferenceNumber was last updated. Not editable Read-only

Foreign Keys

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

graph LR;
	Account-->|VRN|VirtualReferenceNumber
	click Account "/marketgrid/developer/model/tables/Account"