MGR_DEDUCTION Table

The table MGR_DEDUCTION represents the Deduction object for London support representing activation/transfer.

MGR_DEDUCTION Table

Database Column

Details

ID

Type: Decimal.

The primary key of the table MGR_DEDUCTION Table

LASTUPDATED

Type: TimeStamp. Unique.

DESTINATIONSYSTEM

Type: text. Unique.

TYPE

Type: text (max length 1). Unique.

REGULAR

Type: Boolean. Unique.

CONCURRENT

Type: Bigint. Unique.

CONCURRENTOVER

Type: Bigint. Unique.

HYBRID

Type: Bigint. Unique.

HYBRIDOVER

Type: Bigint. Unique.

ACTIVATABLE

Type: Bigint. Unique.

ACTIVATABLEOVER

Type: Bigint. Unique.

EXPIRATIONDATE

Type: TimeStamp. Unique.

SOURCE_ID

Type: Decimal.

References Table: MGR_FULFILLMENT Table

Foreign Key to Fulfillment representing the source

DESTINATION_ID

Type: Decimal.

References Table: MGR_FULFILLMENT Table

Foreign Key to Fulfillment representing the destination