Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table DEK_TMP_USUWANIE_FAKTUR_16639 | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_FAK | NUMBER(8) | |||
2 | BARKOD | VARCHAR2(18 BYTE) | |||
3 | NZ | CHAR(1 BYTE) | Y | ||
4 | TYP_FAK | CHAR(1 BYTE) | |||
5 | NUMER | VARCHAR2(20 BYTE) | |||
6 | REJESTR | VARCHAR2(5 BYTE) | Y | ||
7 | NR_KONTR | NUMBER(6) | Y | ||
8 | DATA_FAK | DATE | |||
9 | DA_WPL | DATE | |||
10 | TERMIN | DATE | Y | ||
11 | DA_ZAP | DATE | |||
12 | WARTOSC | NUMBER(12,2) | Y | ||
13 | WARTOSC_WAL | NUMBER(12,2) | |||
14 | WALUTA | VARCHAR2(3 BYTE) | |||
15 | RODZ_PL | NUMBER(2) | |||
16 | ID_FAK2 | NUMBER(7) | |||
17 | DA_VAT | DATE | |||
18 | DA_KOSZT | DATE | |||
19 | OPERATOR | VARCHAR2(30 BYTE) | |||
20 | KIERUNEK | VARCHAR2(20 BYTE) | |||
21 | DEKRET | VARCHAR2(2 BYTE) | |||
22 | ID_DOWODU | NUMBER(8) | |||
23 | OBSZAR | VARCHAR2(8 BYTE) | |||
24 | AKTYWNOSC | VARCHAR2(8 BYTE) | |||
25 | TYP_SRC | CHAR(1 BYTE) | |||
26 | DATA_ROZLICZENIA | DATE | |||
27 | STATUS_ROZL | CHAR(1 BYTE) | |||
28 | WARTOSC_PK | NUMBER(12,2) | |||
29 | WARTOSC_WAL_PK | NUMBER(12,2) | |||
30 | WARTOSC_ZAP | NUMBER(12,2) | |||
31 | WARTOSC_WAL_ZAP | NUMBER(12,2) | |||
32 | ID_FAK2_WEW | NUMBER | |||
33 | WALUTA_KURS | NUMBER | |||
34 | NUMER_INT | NUMBER | |||
35 | ID_REJESTRY | VARCHAR2(7 BYTE) | |||
36 | ID_AKTYWNOSCI | VARCHAR2(5 BYTE) | |||
37 | TYP_KONTR | VARCHAR2(5 BYTE) | |||
38 | RODZ_KDO | VARCHAR2(5 BYTE) | |||
39 | ID_DZIELNICY | NUMBER | |||
40 | TYP_FAK_PRZED_RATA | CHAR(1 BYTE) | |||
41 | ZABEZP_HIPO | VARCHAR2(1 BYTE) | |||
42 | DATA_ZABEZP_HIPO | DATE | |||
43 | KTO_ZABEZP_HIPO | VARCHAR2(60 CHAR) | |||
44 | WYDRUK_PLIK | BLOB | |||
45 | CZY_USUNIETO | VARCHAR2(1 BYTE) | 'N' |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
SYS_C0056525 | Check | "NZ" IS NOT NULL | ENABLED | NZ |
SYS_C0056526 | Check | "REJESTR" IS NOT NULL | ENABLED | REJESTR |
SYS_C0056527 | Check | "NR_KONTR" IS NOT NULL | ENABLED | NR_KONTR |
SYS_C0056528 | Check | "TERMIN" IS NOT NULL | ENABLED | TERMIN |
SYS_C0056529 | Check | "WARTOSC" IS NOT NULL | ENABLED | WARTOSC |
Comments |
Partitions |
Indexes |
Foreign Key Constraints |
Redaction Policies |