Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table FAKTURY_ZAP_TMP | Next Table |
Comment |
---|
Finanse, tabela z tymczasowymi zaplatami faktur |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | TYP_ZAPLATY | CHAR(1 BYTE) | Typ zaplaty, K <- Kasa, B <- Bank, Z <- Zaliczka | ||
2 | ID_ZAPLATY | NUMBER(8) | Id zaplaty z tabeli RKASY_P, BANKI_P lub ZALICZKI | ||
3 | ID_FAK | NUMBER(8) | Id faktury z FAKTURY | ||
4 | DATA_ZAP | DATE | Data zaplaty | ||
5 | WARTOSC | NUMBER(12,2) | 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 |
Partitions |
Indexes |
Foreign Key Constraints |
Primary Key, Unique, or Check Constraints |
Redaction Policies |