Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_ZAP2 | Next Table |
Comment |
---|
Finanse, tabela z zaplatami faktur |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | TYP_ZAPLATY | CHAR(1 BYTE) | Y | Typ zaplaty, K <- Kasa, B <- Bank, Z <- Zaliczka | |
2 | ID_ZAPLATY | NUMBER(8) | Y | Id zaplaty z tabeli RKASY_P, BANKI_P lub ZALICZKI | |
3 | ID_FAK | NUMBER(8) | Y | Id dokumentu rozliczonego zaplata, ID_FAK z FAKTURY, ID_WBP z BANKI_P, ID_RKP z RKASY_P | |
4 | DATA_ZAP | DATE | Y | Data zaplaty | |
5 | WARTOSC | NUMBER(12,2) | Y | Wartosc | |
6 | WARTOSC_WAL | NUMBER(12,2) | Wartosc walutowa | ||
7 | WALUTA | VARCHAR2(3 BYTE) | Waluta | ||
8 | OPIS | VARCHAR2(40 BYTE) | Opis | ||
9 | WARTOSC_P | NUMBER(12,2) | Wartosc nierozliczona faktury jaka pozostala | ||
10 | TYP_DOK | CHAR(1 BYTE) | 'F' | Typ dokumentu | |
11 | DATA_DOK | DATE | Data dokumentu | ||
12 | DATA_SP_ZAP | DATE | Data zaplaty | ||
13 | DATA_SP_DOK | DATE | Data sprzedazy dokumentu | ||
14 | CZY_KTR | VARCHAR2(1 BYTE) | Czy KTR? | ||
15 | ID | NUMBER | Y | ||
16 | ZAP_CALOSCI | VARCHAR2(1 BYTE) | 'N' | Określa czy zapłata pokrywa należność w całości wraz z odsetkami na dzień zapłaty. | |
17 | UTW_DAT | DATE | Y | SYSTIMESTAMP | Data fizycznego utworzenia zapłaty. |
18 | UTW_USR | VARCHAR2(30 BYTE) | Y | USER | Nazwa użytkownika tworzącego zapłatę. |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IDX$$_19B110002 | NORMAL | TYP_DOK, ID_ZAPLATY, ID_FAK, TYP_ZAPLATY | <none> | ||||
NON-UNIQUE | IDX$$_19B130001 | NORMAL | TYP_DOK, ID_ZAPLATY, TYP_ZAPLATY, ID_FAK | <none> | ||||
NON-UNIQUE | IDX_FAKTURYZAP2_TYPDOK | NORMAL | ID_FAK, TYP_DOK, WARTOSC | <none> | ||||
NON-UNIQUE | IDX_PK_FAKTURY_ZAP2_ID | NORMAL | ID | <none> | ||||
NON-UNIQUE | IX3_FAKTURYZAP | NORMAL | DATA_ZAP | <none> | ||||
NON-UNIQUE | IX4_FAKTURYZAP | NORMAL | DATA_DOK | <none> | ||||
NON-UNIQUE | IX_FAKTURTURYZ_WALUTA | NORMAL | WALUTA | <none> | ||||
NON-UNIQUE | IX_FAKTURYZAP1 | NORMAL | ID_FAK | <none> | ||||
NON-UNIQUE | IX_FAKTURYZAP2 | NORMAL | ID_ZAPLATY | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_FAKTURY_ZAP2_WALUTA | WALUTA | F_54 | SL_WALUTY | WALUTA | NO ACTION | ENABLED | No | No |
Constraint Name | Type | Condition | Status | Columns |
---|---|---|---|---|
NN_FAKTURY_ZAP2_UTW_DAT | Check | "UTW_DAT" IS NOT NULL | ENABLED | UTW_DAT |
NN_FAKTURY_ZAP2_UTW_USR | Check | "UTW_USR" IS NOT NULL | ENABLED | UTW_USR |
NN_FAKTURYZAP_DATAZAP | Check | "DATA_ZAP" IS NOT NULL | ENABLED | DATA_ZAP |
NN_FAKTURYZAP_IDFAK | Check | "ID_FAK" IS NOT NULL | ENABLED | ID_FAK |
NN_FAKTURYZAP_IDZAPLATY | Check | "ID_ZAPLATY" IS NOT NULL | ENABLED | ID_ZAPLATY |
NN_FAKTURYZAP_TYPZAPLATY | Check | "TYP_ZAPLATY" IS NOT NULL | ENABLED | TYP_ZAPLATY |
NN_FAKTURYZAP_WARTOSC | Check | "WARTOSC" IS NOT NULL | ENABLED | WARTOSC |
PK_FAKTURY_ZAP2 | Primary Key | ENABLED | ID |
Partitions |
Redaction Policies |