|
Name |
|
|
Comment |
The purpose of the Reallocation Confirmation report is to provide the participants (Credit and Debit Parties) a confirmation wherever an allocation is submitted, authorised, cancelled or expired. The Reallocation subreport contains the main reallocation details. |
|
Name |
|
REALLOCATION_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATION_ID |
VARCHAR2(20) |
X |
The unique identifier for the reallocation |
|
DEBIT_PARTICIPANT_CODE |
VARCHAR2(20) |
|
The participant code for the participant on the debit side of the reallocation |
|
DEBIT_PARTICIPANT_NAME |
VARCHAR2(80) |
|
The name for the participant on the debit side of the reallocation |
|
DEBIT_PARTICIPANT_REFERENCE |
VARCHAR2(80) |
|
The reference for the reallocation for the participant on the debit side of the reallocation |
|
CREDIT_PARTICIPANT_CODE |
VARCHAR2(20) |
|
The participant code for the participant on the credit side of the reallocation |
|
CREDIT_PARTICIPANT_NAME |
VARCHAR2(80) |
|
The name for the participant on the credit side of the reallocation |
|
CREDIT_PARTICIPANT_REFERENCE |
VARCHAR2(80) |
|
The reference for the reallocation for the participant on the credit side of the reallocation |
|
START_DATE |
DATE |
|
The date on which the reallocation comes into effect |
|
END_DATE |
DATE |
|
The date on which the reallocation ends |
|
AGREEMENT_TYPE |
VARCHAR2(80) |
|
The type of the reallocation agreement |
|
PRODUCT_LOCATION |
VARCHAR2(80) |
|
The product location used to determine the reference price (only applicable to Fixed Quantity Amount reallocation agreement type) |
|
REALLOCATION_STATUS |
VARCHAR2(80) |
|
The status of the agreement which can be submitted, authorised, cancelled, or expired |
|
REASON |
VARCHAR2(255) |
|
The reason explaining why a reallocation has been cancelled or expired (only applies to Cancellation and Expiration of report) |
|
LAST_UPDATED |
DATE |
|
The date and time the reallocation was last updated i.e. saved into database |
|
LASTCHANGED |
DATE |
|
The date and time the report was generated |
|
|
|