ExternalAccountProvider
An ExternalAccountProvider represents the authority that issued that account (for example, the registry or bank).
In addition to being the authority for Holdings, an ExternalAccountProvider is also the authority for the Instrument that the Holding represents.
For example, BHP shares are controlled by the Computershare registry and so an ExternalAccount issued by Computershare would be required to represent a holding of BHP shares in MarketGrid.
- Section: Position Keeping
Metadata
- Base Table Class: Static
- Default Size: 100
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this ExternalAccountProvider. |
| Status | Set of Status | 4 | |
| ShortName | String | 24 | The short text identifier of this ExternalAccountProvider. |
| Name | String | 48 | The long text identifier of this ExternalAccountProvider. |
| TaggedHoldingURL | String | 100 | |
| TriggerPTT | Integer (unsigned) | 1 | |
| TriggerDT | Integer (unsigned) | 1 | |
| TriggerDTRange | Integer (unsigned) | 1 | |
| TriggerVRNCount | Integer (unsigned) | 1 | |
| ActionStartDate | Integer (unsigned) | 8 | The timestamp of this record. |
| ActionEndDate | Integer (unsigned) | 8 | The timestamp of this record. |
| UseActionDates | Integer (unsigned) | 1 | |
| ScheduleSecondsPTT | Integer (unsigned) | 4 | |
| ScheduleSecondsDT | Integer (unsigned) | 4 | |
| ScheduleSecondsVRNCount | Integer (unsigned) | 4 | |
| StartTimePTT | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| StartTimeDT | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| StartTimeVRNCount | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| NextTimePTT | Integer (unsigned) | 8 | The timestamp of this record. |
| NextTimeDT | Integer (unsigned) | 8 | The timestamp of this record. |
| NextTimeVRNCount | Integer (unsigned) | 8 | The timestamp of this record. |
| UseSchedulePTT | Integer (unsigned) | 1 | |
| UseScheduleDT | Integer (unsigned) | 1 | |
| UseScheduleVRNCount | Integer (unsigned) | 1 | |
| VRNLowWarnLimit | Integer (unsigned) | 4 | If the number of unassigned VRNs drop below this, send a warning message to NOTE. Leave unset to disable warnings. |
| DenyVoidTransaction | Integer (unsigned) | 1 | Setting this attribute to true removes the 'Void' transaction option when dealing with an Unconfirmed HoldingTransaction for an Instrument that belongs to this ExternalAccountProvider. |
| 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. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this ExternalAccountProvider. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this ExternalAccountProvider. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this ExternalAccountProvider. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this ExternalAccountProvider. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this ExternalAccountProvider was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this ExternalAccountProvider. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this ExternalAccountProvider was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the ExternalAccountProvider table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; ExternalAccount-->|ExternalAccountProvider|ExternalAccountProvider click ExternalAccount "/marketgrid/developer/model/tables/ExternalAccount" Instrument-->|ExternalAccountProvider|ExternalAccountProvider click Instrument "/marketgrid/developer/model/tables/Instrument" InstrumentMarket-->|ExternalAccountProvider|ExternalAccountProvider InstrumentMarket-->|ExternalSettlementAccountProvider|ExternalAccountProvider click InstrumentMarket "/marketgrid/developer/model/tables/InstrumentMarket" Market-->|DefaultExternalSettlementAccountProvider|ExternalAccountProvider click Market "/marketgrid/developer/model/tables/Market" Order-->|ExternalAccountProvider|ExternalAccountProvider Order-->|ExternalSettlementAccountProvider|ExternalAccountProvider click Order "/marketgrid/developer/model/tables/Order" TradeFee-->|ExternalAccountProvider|ExternalAccountProvider click TradeFee "/marketgrid/developer/model/tables/TradeFee"