Table: GSH_REALLOC_REALLOCATION

GSH_REALLOC_REALLOCATION

Name

GSH_REALLOC_REALLOCATION

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.


Primary Key Columns

Name

REALLOCATION_ID


Content

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)
(Note: for details on what the REASON field value should be refer to SUC7704-Cancel Reallocation in the Reallocations System Requirements Document)

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