Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table ZALICZKI_DOKNR | Next Table |
Comment |
---|
Finanse, tabela z dokumentami podpietymi pod zaliczki |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_DOKUMENTU | NUMBER(8) | Y | Id dokumentu, klucz glowny nadawany z sekwencji SQ_ZALICZKIDNR | |
2 | ID_ZA | NUMBER(8) | Id zaliczki z tabeli ZALICZKI | ||
3 | NR_KONTR | NUMBER(6) | Nr kontrahenta z KDO | ||
4 | TRESC | VARCHAR2(60 BYTE) | Tresc | ||
5 | WARTOSC | NUMBER(12,2) | Wartosc | ||
6 | WARTOSC_WAL | NUMBER(12,2) | Wartosc walutowa | ||
7 | WALUTA | VARCHAR2(3 BYTE) | Waluta | ||
8 | DATA_DOK | DATE | Data dokumentu | ||
9 | CHAR_KS | VARCHAR2(5 BYTE) | Charakter ksiegowy z CHAR_KS | ||
10 | OPERATOR | VARCHAR2(30 BYTE) | Operator | ||
11 | KONTO | VARCHAR2(32 BYTE) | Nr konta | ||
12 | KONTO_LICZBA | VARCHAR2(32 BYTE) | REPLACE("KONTO",'-','') | Kolumna funkcyjna na podstawie KONTO, bez znaku "-" |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX1_ZALICZKIDOKNR | NORMAL | ID_ZA, ID_DOKUMENTU | <none> | ||||
NON-UNIQUE | IX_ZALICZZKIDO_CHARKS | NORMAL | CHAR_KS | <none> | ||||
NON-UNIQUE | IX_ZALICZZKIDO_NRKONTR | NORMAL | NR_KONTR | <none> | ||||
NON-UNIQUE | IX_ZALICZZKIDO_WALUTA | NORMAL | WALUTA | <none> | ||||
UNIQUE | PK_ZALICZKIDOKNR | NORMAL | ID_DOKUMENTU | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_ZALICZKIDOKNR_CHARKS | CHAR_KS | F_54 | CHAR_KS | CHAR_KS | NO ACTION | ENABLED | No | No |
FK_ZALICZKIDOKNR_KDO | NR_KONTR | F_54 | KDO_WEW | NR_KONTR | NO ACTION | ENABLED | No | No |
FK_ZALICZKIDOKNR_WALUTA | WALUTA | F_54 | SL_WALUTY | WALUTA | NO ACTION | ENABLED | No | No |
FK_ZALICZKIDOKNR_ZALICZKI | ID_ZA | F_54 | ZALICZKI | ID_ZA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_ZALICZKIDOKNR_ID_ZA | Check | "ID_ZA" IS NOT NULL | ENABLED | ID_ZA |
PK_ZALICZKIDOKNR | Primary Key | ENABLED | ID_DOKUMENTU |
Partitions |
Redaction Policies |