Untitled

Dispute Action

Created_Datetime

OI_Action

Created_Datetime_X (Sysdate DB)

Created_Datetime (System Date)

Millis_Archived (System Date)

Status_change_Datetime (System Date)

A_Invoice

Submit Action

Created_Datetime

Save Action

Created_Datetime

Approve Action

Created_Datetime

Amend Action

Created_Datetime

Delete Action

Created_Datetime

A_invoice.Archived_date = TRUN(OI_Action.Created_Datetime) (dispute or approve action)

Submit_datetime = OI_action.Created_datetime (Submit action)

Dispute_datetime = OI_action.Created_datetime (Dispute action) - can be null

Last_submit_datetime = OI_action.Created_datetime (Last submit action)

Code_datetime = Invoice.created_datetime (Code action) - can be null A_Invoice table

Approve_datetime = OI_action.created_datetime (Approve action) - can be null

Amend_datetime = OI_action.created_datetime (Amend action) - can be null

Delete_datetime = OI_action.Created_datetime (Delete action) - can be null

First_FNCL_Approve_Datetime = OI_Action.Created_datetime (First Approve action) - can be null

Final_FNCL_Approve_Datetime = OI_Action.Created_datetime (Final Approve action) - can be null

EP_STATUS (This will be out of this fix for the moment) - can be null

EP_DUE_DATETIME (This will be out of this fix for the moment) - can be null

Code Action

Created_Datetime