Subject | Re: view porting problem |
---|---|
Author | Fikret Hasovic |
Post date | 2004-01-23T11:31:56Z |
Hi Arno.
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
);
Fikret Hasovic
TAMP R&D Team
> Could you give me only the necessary metadata to reproduce this?MD_UsrID have?
> What datatypes do the fields EC_UsrID, KV_UsrID, OE_UsrID and
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
);
>Best regards
> Regards,
> Arno Brinkman
> ABVisie
Fikret Hasovic
TAMP R&D Team