Table: REALLOCATIONDETAILS

REALLOCATIONDETAILS

Name

REALLOCATIONDETAILS

Comment

REALLOCATIONDETAILS sets out specific reallocation agreements.


Description

Not in Use - discontinued 10/06/2004

Source

As changes occur.


Primary Key Columns

Name

EFFECTIVEDATE

REALLOCATIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

REALLOCATIONID

VARCHAR2(20)

X

Identification of the reallocation agreement

EFFECTIVEDATE

DATE

X

Calendar settlement date the agreement starts from

VERSIONNO

NUMBER(3,0)

X

Version number on the effective date, highest is the reallocation used on that date

AUTHORISEDDATE

DATE

 

Date the entry was authorised

AUTHORISEDBY

VARCHAR2(10)

 

User who authorised the record

LASTCHANGED

DATE

 

Last date and time record changed