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 |
|
|
|