DiaryEvent
Field Name Type Nullable? Comment

EventNumber (PK)

Numeric (9,0)

    

Event Type (FK)

CHAR(4)

    

GroupCode (FK)

CHAR(6)

    

CorporateCode (FK)

CHAR(6)

    

Invoice Tax Date

DateTime

    

Event Status

CHAR(1)

    
IH InvoiceNumber (FK) Numeric    

Date Created (FK)

Numeric(7,0)

    

Time Created (FK)

Numeric(6,)

    

Created by DISE User ID (FK)

 DateTime    

Created by Program (FK)

 DateTime    

Date Changed (FK)

 DateTime    

Time Changed (FK)

 DateTime    

Changed by DISE User Id (FK)

CHAR(10)

    

Changed by Program (FK)

CHAR(10)

    

Account No (FK)

Numeric(8)

    

Event Code (FK)

CHAR(4)

    

Company Number (FK)

CHAR(3)

    
RC Reason Code (FK) CHAR (4)    

Spare Alpha (FK)

CHAR(10)

    

Spare Numeric (FK)

Numeric(11,2)

    

Spare Status (FK)

CHAR(1)

    

Current DISE User Id (FK)

CHAR(10)

    

Resolved By DISE User Id (FK)

CHAR(10)

    

Agreement Number (FK)

Numeric(8,0)

    

Inv Consolidation Agreeme (FK)

Numeric(8,0)

    

Prospect ID Number (FK)

Numeric(8,0)

    

Contact Name

CHAR(30)

    

Contact Telephone Number

CHAR(15)

    

Resolved Date

DateTime

    

Resolution Req by Date

 DateTime    

Resolution Req by Time

 DateTime    

Bill Immediately?

CHAR(1)

    

Contact Extension

Numeric(6,0)

    

Total S/L Adjustments

Numeric(11,2)

    

Processed Date

DateTime

    

DE S/L Adjustment?

CHAR(1)

    

Override Action Date

DateTime

    

Delivery Address Number (FK)

Numeric(8,0)

    

Subscription Number (FK)

Numeric(8,0)