Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior View | View V_MAG_WZ_PZ_FAKTURY | Next View |
Column Name | Datatype | Nullable | Comments |
---|---|---|---|
ZAK_ID_FAK | NUMBER | No | |
ZAK_BARKOD | VARCHAR2 | Yes | |
ZAK_NZ | CHAR | No | |
ZAK_TYP_FAK | VARCHAR2 | Yes | |
ZAK_NUMER | VARCHAR2 | Yes | |
ZAK_REJESTR | VARCHAR2 | No | |
ZAK_NR_KONTR | NUMBER | No | |
ZAK_DATA_FAK | DATE | Yes | |
ZAK_DA_WPL | DATE | Yes | |
ZAK_TERMIN | DATE | No | |
ZAK_DA_ZAP | DATE | Yes | |
ZAK_WARTOSC | NUMBER | No | |
ZAK_WARTOSC_WAL | NUMBER | Yes | |
ZAK_WALUTA | VARCHAR2 | Yes | |
ZAK_RODZ_PL | NUMBER | Yes | |
ZAK_ID_FAK2 | NUMBER | Yes | |
ZAK_DA_VAT | DATE | Yes | |
ZAK_DA_KOSZT | DATE | Yes | |
ZAK_OPERATOR | VARCHAR2 | Yes | |
ZAK_KIERUNEK | VARCHAR2 | Yes | |
ZAK_DEKRET | VARCHAR2 | Yes | |
ZAK_ID_DOWODU | NUMBER | Yes | |
ZAK_OBSZAR | VARCHAR2 | Yes | |
ZAK_AKTYWNOSC | VARCHAR2 | Yes | |
ZAK_TYP_SRC | VARCHAR2 | Yes | |
ZAK_DATA_ROZLICZENIA | DATE | Yes | |
ZAK_STATUS_ROZL | CHAR | Yes | |
ZAK_WARTOSC_PK | NUMBER | Yes | |
ZAK_WARTOSC_WAL_PK | NUMBER | Yes | |
ZAK_WARTOSC_ZAP | NUMBER | Yes | |
ZAK_WARTOSC_WAL_ZAP | NUMBER | Yes | |
ZAK_ID_FAK2_WEW | NUMBER | Yes | |
ZAK_WALUTA_KURS | NUMBER | Yes | |
PZ_ID_DOWODU | NUMBER | No | |
PZ_MAGAZYN | NUMBER | Yes | |
PZ_DOWOD | VARCHAR2 | Yes | |
PZ_NUMER | NUMBER | Yes | |
PZ_NR_DOW | VARCHAR2 | Yes | |
PZ_NR_KONTR | NUMBER | Yes | |
PZ_DATA_DO | DATE | Yes | |
PZ_DATA_AKCEPT | DATE | Yes | |
PZ_DEPOZYT | CHAR | Yes | |
PZ_ID_FAK | NUMBER | Yes | |
PZ_DATA_FAK | DATE | Yes | |
PZ_TYP_FAK | VARCHAR2 | Yes | |
PZ_OPERATOR | VARCHAR2 | Yes | |
PZ_MAG_DOCELOWY | NUMBER | Yes | |
PZ_OBSZAR | VARCHAR2 | Yes | |
PZ_AKTYWNOSC | VARCHAR2 | Yes | |
PZ_DEKRET | VARCHAR2 | Yes | |
PZ_ID_DOWODU_FK | NUMBER | Yes | |
PZ_TYP_SRC | CHAR | Yes | |
PZ_UWAGI | VARCHAR2 | Yes | |
PZ_ID_FAK_P | NUMBER | Yes | |
PZ_DATA_FAK_P | DATE | Yes | |
PZ_TYP_FAK_P | VARCHAR2 | Yes | |
PZ_OSOBA_POB | NUMBER | Yes | |
PZ_OSOBA_AKCEPT | VARCHAR2 | Yes | |
PZ_ID_DOWODU_KOR | NUMBER | Yes | |
PZ_POZ_ID_DOWODU | NUMBER | No | |
PZ_POZ_ID_POZ | NUMBER | No | |
PZ_POZ_NR_KATAL | NUMBER | Yes | |
PZ_POZ_CENA | NUMBER | Yes | |
PZ_POZ_ILOSC | NUMBER | Yes | |
PZ_POZ_WARTOSC | NUMBER | Yes | |
PZ_POZ_VAT | NUMBER | Yes | |
PZ_POZ_JM_PODST | NUMBER | Yes | |
PZ_POZ_MARZA | NUMBER | Yes | |
PZ_POZ_PR_VAT | NUMBER | Yes | |
PZ_POZ_GNIAZDO | VARCHAR2 | Yes | |
PZ_POZ_NAZWA | VARCHAR2 | Yes | |
PZ_POZ_STATUS | VARCHAR2 | Yes | |
PZ_POZ_CENA_BR | NUMBER | Yes | |
PZ_POZ_JAKA_CENA | CHAR | Yes | |
PZ_POZ_KONTO | VARCHAR2 | Yes | |
PZ_POZ_ID_POZ_KOR | NUMBER | Yes | |
PZ_POZ_WARTOSC_WALUTA | NUMBER | Yes | |
PZ_POZ_CENA_WALUTA | NUMBER | Yes | |
PZ_POZ_VAT_WALUTA | NUMBER | Yes | |
PZ_POZ_CENA_BR_WALUTA | NUMBER | Yes | |
SP_ID_FAK | NUMBER | No | |
SP_BARKOD | VARCHAR2 | Yes | |
SP_NZ | CHAR | No | |
SP_TYP_FAK | VARCHAR2 | Yes | |
SP_NUMER | VARCHAR2 | Yes | |
SP_REJESTR | VARCHAR2 | No | |
SP_NR_KONTR | NUMBER | No | |
SP_DATA_FAK | DATE | Yes | |
SP_DA_WPL | DATE | Yes | |
SP_TERMIN | DATE | No | |
SP_DA_ZAP | DATE | Yes | |
SP_WARTOSC | NUMBER | No | |
SP_WARTOSC_WAL | NUMBER | Yes | |
SP_WALUTA | VARCHAR2 | Yes | |
SP_RODZ_PL | NUMBER | Yes | |
SP_ID_FAK2 | NUMBER | Yes | |
SP_DA_VAT | DATE | Yes | |
SP_DA_KOSZT | DATE | Yes | |
SP_OPERATOR | VARCHAR2 | Yes | |
SP_KIERUNEK | VARCHAR2 | Yes | |
SP_DEKRET | VARCHAR2 | Yes | |
SP_ID_DOWODU | NUMBER | Yes | |
SP_OBSZAR | VARCHAR2 | Yes | |
SP_AKTYWNOSC | VARCHAR2 | Yes | |
SP_TYP_SRC | VARCHAR2 | Yes | |
SP_DATA_ROZLICZENIA | DATE | Yes | |
SP_STATUS_ROZL | CHAR | Yes | |
SP_WARTOSC_PK | NUMBER | Yes | |
SP_WARTOSC_WAL_PK | NUMBER | Yes | |
SP_WARTOSC_ZAP | NUMBER | Yes | |
SP_WARTOSC_WAL_ZAP | NUMBER | Yes | |
SP_ID_FAK2_WEW | NUMBER | Yes | |
SP_WALUTA_KURS | NUMBER | Yes | |
WZ_ID_DOWODU | NUMBER | No | |
WZ_MAGAZYN | NUMBER | Yes | |
WZ_DOWOD | VARCHAR2 | Yes | |
WZ_NUMER | NUMBER | Yes | |
WZ_NR_DOW | VARCHAR2 | Yes | |
WZ_NR_KONTR | NUMBER | Yes | |
WZ_DATA_DO | DATE | Yes | |
WZ_DATA_AKCEPT | DATE | Yes | |
WZ_DEPOZYT | CHAR | Yes | |
WZ_ID_FAK | NUMBER | Yes | |
WZ_DATA_FAK | DATE | Yes | |
WZ_TYP_FAK | VARCHAR2 | Yes | |
WZ_OPERATOR | VARCHAR2 | Yes | |
WZ_MAG_DOCELOWY | NUMBER | Yes | |
WZ_OBSZAR | VARCHAR2 | Yes | |
WZ_AKTYWNOSC | VARCHAR2 | Yes | |
WZ_DEKRET | VARCHAR2 | Yes | |
WZ_ID_DOWODU_FK | NUMBER | Yes | |
WZ_TYP_SRC | CHAR | Yes | |
WZ_UWAGI | VARCHAR2 | Yes | |
WZ_ID_FAK_P | NUMBER | Yes | |
WZ_DATA_FAK_P | DATE | Yes | |
WZ_TYP_FAK_P | VARCHAR2 | Yes | |
WZ_OSOBA_POB | NUMBER | Yes | |
WZ_OSOBA_AKCEPT | VARCHAR2 | Yes | |
WZ_ID_DOWODU_KOR | NUMBER | Yes | |
WZ_POZ_ID_DOWODU | NUMBER | No | |
WZ_POZ_ID_POZ | NUMBER | No | |
WZ_POZ_NR_KATAL | NUMBER | Yes | |
WZ_POZ_CENA | NUMBER | Yes | |
WZ_POZ_ILOSC | NUMBER | Yes | |
WZ_POZ_WARTOSC | NUMBER | Yes | |
WZ_POZ_VAT | NUMBER | Yes | |
WZ_POZ_JM_PODST | NUMBER | Yes | |
WZ_POZ_MARZA | NUMBER | Yes | |
WZ_POZ_PR_VAT | NUMBER | Yes | |
WZ_POZ_GNIAZDO | VARCHAR2 | Yes | |
WZ_POZ_NAZWA | VARCHAR2 | Yes | |
WZ_POZ_STATUS | VARCHAR2 | Yes | |
WZ_POZ_CENA_BR | NUMBER | Yes | |
WZ_POZ_JAKA_CENA | CHAR | Yes | |
WZ_POZ_KONTO | VARCHAR2 | Yes | |
WZ_POZ_ID_POZ_KOR | NUMBER | Yes | |
WZ_POZ_WARTOSC_WALUTA | NUMBER | Yes | |
WZ_POZ_CENA_WALUTA | NUMBER | Yes | |
WZ_POZ_VAT_WALUTA | NUMBER | Yes | |
WZ_POZ_CENA_BR_WALUTA | NUMBER | Yes |
Comments |