Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table KPIR | Next Table |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID | NUMBER | Y | ||
2 | LP | NUMBER | Liczba porzadkowa | ||
3 | DZIEN | DATE | Data dowodu przeslanego do KPIR, lub data najstarszego dowodu jezeli paczka | ||
4 | NR_KONTR | NUMBER | |||
5 | WARTOSC | NUMBER | |||
6 | ID_POZYCJI_KPIR | NUMBER | Id pozycji w KPIR do ktorego ma trafic wartosc | ||
7 | TYP_SRC | VARCHAR2(3 BYTE) | Typ dokumentu zrodlowego: FN <- faktury naleznosci, FZ <- faktury zobowiazania, A <- amortyzacja, LP <- Lista plac, R <- Reczny | ||
8 | ID_SRC | NUMBER | Id dowodu z odpowiedniego modulu, NULL jezeli paczka | ||
9 | NR_DOWODU | VARCHAR2(256 BYTE) | |||
10 | OPIS_ZDARZENIA | VARCHAR2(256 BYTE) | |||
11 | UWAGI | VARCHAR2(256 BYTE) | |||
12 | OPER_REJ | VARCHAR2(60 BYTE) | Uzytkownik ktory przeslal do KPIR | ||
13 | DATA_REJ | DATE | Data przeslania do KPIR | ||
14 | OPER_ZAM | VARCHAR2(60 BYTE) | |||
15 | DATA_ZAM | DATE |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX$$_110280001 | NORMAL | TYP_SRC | <none> | ||||
NON-UNIQUE | IX_KPIR_IDPOZYCJIKPIR | NORMAL | ID_POZYCJI_KPIR | <none> | ||||
NON-UNIQUE | IX_KPIR_NRKONTR | NORMAL | NR_KONTR | <none> | ||||
UNIQUE | PK_KPIR_ID | NORMAL | ID | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_KPIR_ID_POZ_KPIR | ID_POZYCJI_KPIR | F_54 | SL_KPIR_POZYCJE | ID | NO ACTION | ENABLED | No | No |
FK_KPIR_NR_KONTR | NR_KONTR | F_54 | KDO_WEW | NR_KONTR | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_KPIR_DZIEN | Check | "DZIEN" IS NOT NULL | ENABLED | DZIEN |
NN_KPIR_ID_POZ_KPIR | Check | "ID_POZYCJI_KPIR" IS NOT NULL | ENABLED | ID_POZYCJI_KPIR |
NN_KPIR_LP | Check | "LP" IS NOT NULL | ENABLED | LP |
NN_KPIR_TYP_SRC | Check | "TYP_SRC" IS NOT NULL | ENABLED | TYP_SRC |
NN_KPIR_WARTOSC | Check | "WARTOSC" IS NOT NULL | ENABLED | WARTOSC |
PK_KPIR_ID | Primary Key | ENABLED | ID |
Comments |
Partitions |
Redaction Policies |