SET_APC_COMPENSATION
APC Compensation payment amounts in the Settlements timeframe.
Package
SETTLEMENT_DATA
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Settlement run date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Settlement run number |
| APEVENTID |
numeric(6, 0) |
int |
AP Event Id |
| CLAIMID |
numeric(6, 0) |
int |
AP Event Claim Id |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Participant identifier |
| PERIODID |
numeric(3, 0) |
smallint |
Trading interval identifier |
| COMPENSATION_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Compensation amount for the event claim in this interval |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SET_APC_COMPENSATION_PK |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_APC_COMPENSATION |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SET_APC_COMPENSATION |
clustered, unique, primary key |
SETTLEMENTDATE, VERSIONNO, APEVENTID, CLAIMID, PARTICIPANTID, PERIODID |