|
|
| Linia 1: |
Linia 1: |
| ==MAT_BILANSE==
| | {{Robocza}} |
| | |
| {| class="wikitable" | |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | OPIS
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | DOK_TYP
| |
| |
| |
| |-
| |
| | ID_KH
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |}
| |
| | |
| ==MAT_DOKS
| |
| Nagłówki dokumentów
| |
| {| class="wikitable" | |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NR_ZEW
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | DOK_TYP
| |
| |
| |
| |-
| |
| | ID_BILANSU
| |
| |
| |
| |-
| |
| | ID_KH
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |}
| |
| | |
| ==MAT_DOKSBIL==
| |
| | |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NR_ZEW
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | ID_KH
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |}
| |
| | |
| ==MAT_DOKS_OLD==
| |
| | |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NR_ZEW
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | BP
| |
| |
| |
| |-
| |
| | DZIAL
| |
| |
| |
| |-
| |
| | ID_GR
| |
| |
| |
| |-
| |
| | K_MA_P
| |
| |
| |
| |-
| |
| | K_MA_R
| |
| |
| |
| |-
| |
| | K_WN_P
| |
| |
| |
| |-
| |
| | K_WN_R
| |
| |
| |
| |}
| |
| | |
| ==MAT_GRMAT==
| |
| Grupy materiałów
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | OPIS
| |
| |
| |
| |-
| |
| | PARAGRAF
| |
| |
| |
| |-
| |
| | POZYCJA
| |
| |
| |
| |-
| |
| | ROZDZIAL
| |
| |
| |
| |-
| |
| | ZADANIE
| |
| |
| |
| |-
| |
| | ZRODLO_P
| |
| |
| |
| |-
| |
| | ZRODLO_R
| |
| |
| |
| |-
| |
| | JM
| |
| |
| |
| |-
| |
| | MAT_JM
| |
| |
| |
| |-
| |
| | OPIS
| |
| |
| |
| |-
| |
| | BANK
| |
| |
| |
| |-
| |
| | FAX
| |
| |
| |
| |-
| |
| | ID_KH
| |
| |
| |
| |-
| |
| | KOD
| |
| |
| |
| |-
| |
| | KONTO_BANK
| |
| |
| |
| |}
| |
| | |
| ==MAT_KH==
| |
| Słownik kontrahentów
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | MIEJSCOWOSC
| |
| |
| |
| |-
| |
| | NAZWA
| |
| |
| |
| |-
| |
| | NAZWA_KROTKA
| |
| |
| |
| |-
| |
| | NIP
| |
| |
| |
| |-
| |
| | NR_DOMU
| |
| |
| |
| |-
| |
| | NR_LOKALU
| |
| |
| |
| |-
| |
| | OPERATOR
| |
| |
| |
| |-
| |
| | POCZTA
| |
| |
| |
| |-
| |
| | TELEFON
| |
| |
| |
| |-
| |
| | ULICA
| |
| |
| |
| |}
| |
| | |
| ==MAT_KONFIG==
| |
| Konfiguracja programów
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | PARAMETR
| |
| |
| |
| |-
| |
| | WARTOSC
| |
| |
| |
| |-
| |
| | BP
| |
| |
| |
| |-
| |
| | DZIAL
| |
| |
| |
| |-
| |
| | EWID
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | KH_P
| |
| |
| |
| |-
| |
| | KH_R
| |
| |
| |
| |-
| |
| | K_MA_P
| |
| |
| |
| |-
| |
| | K_MA_R
| |
| |
| |
| |-
| |
| | K_WN_P
| |
| |
| |
| |-
| |
| | K_WN_R
| |
| |
| |
| |}
| |
| | |
| ==MAT_MAG==
| |
| Słownik magazynów
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NAZWA
| |
| |
| |
| |-
| |
| | PARAGRAF
| |
| |
| |
| |-
| |
| | POZYCJA
| |
| |
| |
| |-
| |
| | ROZDZ
| |
| |
| |
| |-
| |
| | SUM_P
| |
| |
| |
| |-
| |
| | SUM_R
| |
| |
| |
| |-
| |
| | ZADANIE
| |
| |
| |
| |-
| |
| | ZRODLO_P
| |
| |
| |
| |-
| |
| | ZRODLO_R
| |
| |
| |
| |-
| |
| | CENA
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | DATA_KSIEG
| |
| |
| |
| |-
| |
| | DATA_SYS
| |
| |
| |
| |-
| |
| | DOK_TYP
| |
| |
| |
| |-
| |
| | ID_BILANSU
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_MAT
| |
| |
| |
| |-
| |
| | ID_P
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |-
| |
| | ID_ZAD
| |
| |
| |
| |-
| |
| | ILOSC
| |
| |
| |
| |-
| |
| | ILOSC_R
| |
| |
| |
| |}
| |
| | |
| ==MAT_MATER==
| |
| Obroty
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NUMER
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | WARTOSC
| |
| |
| |
| |-
| |
| | CENA
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | DATA_KSIEG
| |
| |
| |
| |-
| |
| | DATA_SYS
| |
| |
| |
| |-
| |
| | DOK_TYP
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_MAT
| |
| |
| |
| |-
| |
| | ID_P
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |-
| |
| | ID_ZAD
| |
| |
| |
| |-
| |
| | ILOSC
| |
| |
| |
| |-
| |
| | ILOSC_R
| |
| |
| |
| |}
| |
| | |
| ==MAT_MATERARCH==
| |
| Dane archiwalne MAT_MATER
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NUMER
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | WARTOSC
| |
| |
| |
| |-
| |
| | CENA
| |
| |
| |
| |-
| |
| | DATA_DOK
| |
| |
| |
| |-
| |
| | DATA_KSIEG
| |
| |
| |
| |-
| |
| | DATA_SYS
| |
| |
| |
| |-
| |
| | DOK_TYP
| |
| |
| |
| |-
| |
| | ID_BILANSU
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_MAT
| |
| |
| |
| |-
| |
| | ID_P
| |
| |
| |
| |-
| |
| | ID_SESJI
| |
| |
| |
| |-
| |
| | ID_ZAD
| |
| |
| |
| |-
| |
| | ILOSC
| |
| |
| |
| |-
| |
| | ILOSC_R
| |
| |
| |
| |}
| |
| | |
| ==MAT_MATERBIL==
| |
| | |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NR_DOK
| |
| |
| |
| |-
| |
| | NUMER
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | WARTOSC
| |
| |
| |
| |-
| |
| | CW
| |
| |
| |
| |-
| |
| | ID_GR
| |
| |
| |
| |-
| |
| | ID_MAG
| |
| |
| |
| |-
| |
| | ID_MAT
| |
| |
| |
| |-
| |
| | JM
| |
| |
| |
| |}
| |
| | |
| ==MAT_SLOMAT==
| |
| Słownik materiałów
| |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NAZWA
| |
| |
| |
| |-
| |
| | NAZWAD
| |
| |
| |
| |-
| |
| | PKWIU
| |
| |
| |
| |-
| |
| | STATUS
| |
| |
| |
| |-
| |
| | ID_ZAD
| |
| |
| |
| |}
| |
| | |
| ==MAT_SLOZAD==
| |
| | |
| {| class="wikitable"
| |
| ! style="font-weight: bold;" | Nazwa pola
| |
| ! style="font-weight: bold;" | Opis
| |
| |-
| |
| | NAZWA
| |
| |
| |
| |-
| |
| | KOD_FUNSYS
| |
| |
| |
| |-
| |
| | KOD_GRUPY
| |
| |
| |
| |-
| |
| | KOD_SYSTEMU
| |
| |
| |
| |}
| |
| | |
| {{DBDTabelemiędzysystemowe}}
| |
|
| |
|
| [[Category:Dokumentacja bazy danych]] | | [[Category:Dokumentacja bazy danych]] |
| [[Category:Baza danych]] | | [[Category:Baza danych]] |