Chip 2004 February/Chip_2004-02_cd1.bin/software/tax/data1.cab/Pohoda_DLLs/StwTaxDB.dll/1033/RCDATA/555

Text File | 2002-01-29 | 8KB | 466 lines

CREATE TABLE Verze (
    ID     COUNTER,
    Datum     DATETIME,
    Nazev     TEXT(24),
    TypeDB    TEXT(20),
    Verze     TEXT(4),
    Release    TEXT(20)
);
CREATE TABLE Print (
    ID     COUNTER,
    RepID    LONG,
    RepIDSR LONG,
    RefFirma    LONG,
    Nazev     TEXT(48),
    RpName     TEXT(48),
    Soubor    TEXT(24),
    Ucetni    TEXT(2),
    Pozn    MEMO
);
CREATE TABLE USR (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(2),
    SText     TEXT(32),
    Jmeno     TEXT(32),
    UsrSet     TEXT(2),
    Firmy     BIT,
    Obnova     BIT,
    RefFirma     LONG,
    Settings     LONGBINARY,
    Pozn     MEMO
);
CREATE TABLE Dotazy (
    ID     COUNTER,
    RelAg    LONG,
    UsrSel     BIT,
    User    TEXT(2),
    Filter     MEMO,
    Popis     TEXT(200)
);
CREATE TABLE DataStrg (
    ID    COUNTER,
    DataID    LONG,
    Settings    LONGBINARY
);
CREATE TABLE Recent (
    ID     COUNTER,
    AgID     LONG,
    Ucetni     TEXT(2),
    RefID     LONG
);
CREATE TABLE sUsrAgS (
    ID     COUNTER,
    Ucetni     TEXT(2),
    Typ     LONG,
    Dotaz     LONG,
    Settings     LONGBINARY
);
CREATE TABLE Tdef (
    ID     COUNTER,
    Ucetni     TEXT(2),
    Typ     LONG,
    RelT     LONG
);
CREATE TABLE sZeme (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(10),
    SText     TEXT(32),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE POP (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel     BIT,
    Rok     LONG,
    RelOsTyp     LONG,
    Firma     TEXT(48),
    ObchDod     TEXT(32),
    Jmeno     TEXT(32),
    Prijm     TEXT(32),
    Ulice     TEXT(32),
    DumCislo     TEXT(16),
    Obec     TEXT(35),
    PSC     TEXT(6),
    RefZeme    LONG,
    Okres    TEXT(35),
    ICO     TEXT(10),
    DIC     TEXT(14),
    Tel     TEXT(40),
    Fax     TEXT(24),
    GSM     TEXT(24),
    Email     TEXT(64),
    WWW     TEXT(32),
    VztahP     TEXT(32),
    Titul     TEXT(16),
    Titul2     TEXT(16),
    VSSSZ    TEXT(16),
    RefUcet    LONG,
    RodPrijmeni    TEXT(32),
    StPrisl    TEXT(16),
    OpCislo    TEXT(16),
    RodCislo    TEXT(16),
    FinUrad    TEXT(64),
    Zpoj    TEXT(64),
    TypUc    LONG,
    Dir        TEXT(50),
    HlCinnost    TEXT(78),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sPOPhis (
    ID         COUNTER,
    IDS        TEXT(32),
    RelTyp    LONG
);
CREATE TABLE POPhist (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel     BIT,
    RefAg     LONG,
    RefPOPdoc LONG,
    Datum     DATETIME,
    Termin    DATETIME,
    Akce     TEXT(32),
    Text1     TEXT(32),
    Text2     TEXT(16),
    Text3     TEXT(16),
    Text4     TEXT(16),
    Klic     TEXT(16),
    Ostatni    TEXT(16),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE POPos (
    ID     COUNTER,
    RefAg     LONG,
    Jmeno     TEXT(32),
    Funkce     TEXT(24),
    Tel     TEXT(32),
    Fax     TEXT(24),
    GSM     TEXT(24),
    Email     TEXT(64),
    WWW     TEXT(32),
    Pozn     TEXT(128)
);
CREATE TABLE POPdoc (
    ID         COUNTER,
    RelAgID    LONG,
    RelID    LONG,
    Path    TEXT(255)
);
CREATE TABLE POProd (
    ID     COUNTER,
    RefAg     LONG,
    DatOd    DATETIME,
    DatDo    DATETIME,
    Jmeno    TEXT(16),
    Prijmeni    TEXT(16),
    RodCislo     TEXT(16),
    RelVztah    LONG,
    Adresa        TEXT(100),
    DIC         TEXT(14),
    Podil        DOUBLE
);
CREATE TABLE DP (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel        BIT,
    RefAD     LONG,
    Rok        LONG,
    RelTpDp    LONG,
    RelDruh    LONG,
    Settings    LONGBINARY,
    KcDanZakl    CURRENCY,
    KcDanCelkem    CURRENCY,
    KcDoplatek    CURRENCY,
    KcDodDanPovin CURRENCY,
    KcSPoj    CURRENCY,
    KcZPoj    CURRENCY,
    DatUzavreni    DATETIME,
    Ucetni     TEXT(2),
    ZdrojDat    TEXT(255),
    Pozn     MEMO
);
CREATE TABLE sBanky (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(4),
    SText     TEXT(48),
    WWW     TEXT(32),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sKSym (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(4),
    SText     TEXT(64),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sUcet (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel     BIT,
    RelJeUcet     LONG,
    IDS     TEXT(10),
    SText     TEXT(24),
    SpecSym     TEXT(16),
    KodBanky     TEXT(5),
    Banka     TEXT(48),
    Swift     TEXT(20),
    AUcet     TEXT(6),
    KcStav     CURRENCY,
    RefCM    LONG,
    KCmPev     BIT,
    RefHB    LONG,
    RefUsr    LONG,
    RefPop    LONG,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sUPred (
    ID     COUNTER,
    Sel     BIT,
    RelUPredTyp    LONG,
    IDS     TEXT(4),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sFUrad (
    ID     COUNTER,
    Sel     BIT,
    UCislo    LONG,
    OCislo    TEXT(4),
    IDS     TEXT(40),
    Ulice     TEXT(32),
    Obec     TEXT(35),
    PSC     TEXT(6),
    Tel     TEXT(32),
    Fax     TEXT(24),
    Ucet     TEXT(24),
    Email     TEXT(64),
    KodBanky     TEXT(4),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sFUrados (
    ID     COUNTER,
    RefAg     LONG,
    Jmeno     TEXT(32),
    Funkce     TEXT(24),
    Tel     TEXT(32),
    Fax     TEXT(24),
    GSM     TEXT(24),
    Email     TEXT(64),
    WWW     TEXT(32),
    Pozn     TEXT(128)
);
CREATE TABLE sZPoj (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(10),
    SText     TEXT(64),
    Ulice     TEXT(32),
    Obec     TEXT(35),
    PSC     TEXT(6),
    Tel     TEXT(32),
    Fax     TEXT(24),
    Email     TEXT(64),
    Ucet     TEXT(24),
    KodBanky     TEXT(4),
    Kod        TEXT(4),
    RelFormZP    LONG,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE sSPoj (
    ID     COUNTER,
    Sel     BIT,
    IDS     TEXT(64),
    Ulice     TEXT(32),
    Obec     TEXT(35),
    PSC     TEXT(6),
    Tel     TEXT(32),
    Fax     TEXT(24),
    Email     TEXT(64),
    Ucet     TEXT(24),
    KodBanky     TEXT(4),
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE HB (
    ID            COUNTER,
    UsrOrder    LONG,
    Sel            BIT,
    IDS            TEXT(20),
    RelHb        LONG,
    Settings    LONGBINARY,
    RefPop        LONG,
    Ucetni        TEXT(2),
    Pozn        MEMO
);
CREATE TABLE BP (
    ID     COUNTER,
    Sel     BIT,
    Polozky     BIT,
    Datum     DATETIME,
    DatSplat     DATETIME,
    SText     TEXT(48),
    Udaj     TEXT(48),
    RefUcet     LONG,
    KcCelkem     CURRENCY,
    KonstSym     TEXT(4),
    RefPop    LONG,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE BPpol (
    ID     COUNTER,
    RefAg     LONG,
    RelAgH     LONG,
    RelIDH     LONG,
    Cislo     TEXT(10),
    Firma     TEXT(48),
    Ucet     TEXT(24),
    KodBanky     TEXT(4),
    KonstSym     TEXT(4),
    SpecSym     TEXT(16),
    VarSym     TEXT(16),
    Kc     CURRENCY,
    BpVrac        BIT,
    OrderFld     LONG
);
CREATE TABLE FA (
    ID     COUNTER,
    UsrOrder    LONG,
    RelTpFak     LONG,
    RelForUh     LONG,
    Sel     BIT,
    Polozky     BIT,
    VarSym     TEXT(20),
    SText     TEXT(240),
    Datum     DATETIME,
    DatSplat     DATETIME,
    KcCelkem     CURRENCY,
    KcLikv     CURRENCY,
    KcU     CURRENCY,
    KcP     CURRENCY,
    DatPrik     DATETIME,
    RefAD     LONG,
    Firma     TEXT(48),
    Utvar     TEXT(32),
    Jmeno     TEXT(32),
    Ulice     TEXT(32),
    PSC     TEXT(7),
    Obec     TEXT(35),
    Ucet     TEXT(24),
    KodBanky     TEXT(4),
    SpecSym     TEXT(16),
    KonstSym     TEXT(4),
    RefPop    LONG,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE FApol (
    ID     COUNTER,
    Sel     BIT,
    RefAg     LONG,
    RefSKz     LONG,
    RefPol     LONG,
    RelAgID    LONG,
    SText     TEXT(90),
    Pozn     TEXT(90),
    VCislo    TEXT(30),
    SKzVC     BIT,
    Mnozstvi    DOUBLE,
    MJ         TEXT(10),
    MJKoef    DOUBLE,
    KcJedn     CURRENCY,
    Sleva     DOUBLE,
    RelSzDPH     LONG,
    SDph     BIT,
    Kc         CURRENCY,
    KcDPH     CURRENCY,
    CmJedn     CURRENCY,
    Cm         CURRENCY,
    CmDPH     CURRENCY,
    RelPk     LONG,
    RelTpDPH     LONG,
    RefStr     LONG,
    RefCin     LONG,
    RefZak     LONG,
    OrderFld     LONG
);
CREATE TABLE sFormUh (
    ID         COUNTER,
    IDS        TEXT(20)
);
CREATE TABLE DSvoz (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel     BIT,
    SPZ     TEXT(9),
    Znacka     TEXT(32),
    Popis    TEXT(32),
    RelVozDruh     LONG,
    RelVozUpr     LONG,
    RelVozOsv     LONG,
    DatZar    DATETIME,
    DatVyr    DATETIME,
    Objem    DOUBLE,
    Hmotnost    DOUBLE,
    Napravy    DOUBLE,
    RelVozTyp     LONG,
    RelVozSaz     LONG,
    Zkratka    TEXT(32),
    Sedadla    DOUBLE,
    RokVyr    LONG,
    RefPop    LONG,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE DS (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel        BIT,
    RefPop     LONG,
    Rok        LONG,
    RelDruh    LONG,
    Settings    LONGBINARY,
    KcDanCelkem    CURRENCY,
    KcDoplatek    CURRENCY,
    DatUzavreni    DATETIME,
    Ucetni     TEXT(2),
    Pozn     MEMO
);
CREATE TABLE DPH (
    ID     COUNTER,
    UsrOrder    LONG,
    Sel        BIT,
    RefPop     LONG,
    Rok        LONG,
    RelDruh    LONG,
    RelObdob LONG,
    RelObdobD LONG,
    Settings    LONGBINARY,
    KcDanVstup    CURRENCY,
    KcDanVystup    CURRENCY,
    KcDanPovin    CURRENCY,
    KcNadOpoc    CURRENCY,
    DatUzavreni    DATETIME,
    Ucetni     TEXT(2),
    Pozn     MEMO
);

CREATE TABLE sKonfig (
    ID     COUNTER,
    Sel     BIT,
    PhCesta TEXT(255),
    Ucetni     TEXT(2),
    Settings     LONGBINARY
);