Subject Re: view porting problem
Author Fikret Hasovic
Hi Arno.

> Could you give me only the necessary metadata to reproduce this?
> What datatypes do the fields EC_UsrID, KV_UsrID, OE_UsrID and
MD_UsrID have?

CREATE TABLE "m_MDEntries" (
"MdentryID" INTEGER NOT NULL,
"DeclID" INTEGER,
DLN VARCHAR(17),
TIN VARCHAR(13),
"FromDate" TIMESTAMP,
"ToDate" TIMESTAMP,
"TodID" INTEGER,
"CantonID" INTEGER,
"LOfficeID" INTEGER,
"MD_UsrID" INTEGER,
"MD_UsrTS" TIMESTAMP DEFAULT 'NOW',
"OE_UsrID" INTEGER,
"OE_UsrTS" TIMESTAMP,
"OE_Timer" INTEGER,
"KV_UsrID" INTEGER,
"KV_UsrTS" TIMESTAMP,
"KV_Timer" INTEGER,
"EC_UsrID" INTEGER,
"EC_UsrTS" TIMESTAMP,
"EC_Timer" INTEGER,
"DecPosted" INTEGER
);


>
> Regards,
> Arno Brinkman
> ABVisie
Best regards
Fikret Hasovic
TAMP R&D Team