Wrong DATE/INTEGER columns in postgresql

Description

The following query:

displays 6 columns that are wrongly defined as DATE in postgresql:

ad_broadcastmessage.updated
ad_modelvalidator.updated
c_bpartner.dunninggrace
c_invoice.dunninggrace
c_ordersource.created
c_ordersource.updated

iDempiere manages date / datetime / time as timestamp

There are also 4 integer columns (must be numeric):
u_rolemenu.createdby
u_rolemenu.updatedby
u_web_properties.createdby
u_web_properties.updatedby

Environment

None

Activity

Show:
Carlos Ruiz
July 1, 2020, 7:24 PM

This is breaking the process "Copy Client"

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Fix versions

Priority

Major
Configure