Type MandatePlans
Type category Entity
Description The MandatePlans table contains data for MMD mandate plans.
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
link company Company MMD Company id, foreign key that links to the Company entity.
mandateId long Mandate Unique ID.
planAssets long Assets of the Pension Plan in USD.
planAssetsLoc long Assets of the pension Plan in local currency.
planCurrencyCode string(6) Currency of the pension plan.
planName string(260) Name of the Pension Plan.
planSeqNo long Sequence of MMD Plan.
planType string(100) Type of Pension Plan.
planValuationDate string(7) Validation Date of Pension Plan at time of Mandate.
updateDate dateTime Most recent update status of mandate.
13 rows of 13 total
API Open API Specification