Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Table | Table MGINWE_ASN | Next Table |
Comment |
---|
tabela dla arkusza spisu z natury inwentaryzacji |
Column ID | Column Name | Datatype | Not Null | Data Default | Comments |
---|---|---|---|---|---|
1 | ID_INWE | NUMBER(8) | id inwentaryzacji (FK) | ||
2 | NR_ASN | NUMBER(8) | numer arkusza | ||
3 | NR_POZ | NUMBER(8) | numer pozycji | ||
4 | GNIAZDO | VARCHAR2(10 BYTE) | gniazdo | ||
5 | GR_TOW | NUMBER(3) | grupa towarowa | ||
6 | NR_KATAL | NUMBER(9) | numer katalogowy | ||
7 | JM_PODST | NUMBER(3) | jednostka miary | ||
8 | CENA_ZN | NUMBER | cena z natury | ||
9 | STAN | NUMBER(10,3) | stan na magazynie | ||
10 | IL_SPIS | NUMBER(10,3) | -1 | ilosc spisana | |
11 | WART_KSIE | NUMBER(14,2) | wartosc ksiegowa | ||
12 | WART_SPIS | NUMBER(14,2) | wartosc spisana | ||
13 | UWAGI | VARCHAR2(60 BYTE) | uwagi do pozycji | ||
14 | STATUS | CHAR(1 BYTE) | 'B' | status pozycji | |
15 | NR_KATAL2 | NUMBER(9) | powiazany numer katalogowy | ||
16 | POWOD | NUMBER | Powod ronicy inwentaryzacyjnej (z tabeli MGINWE_PARAM). |
Uniqueness | Index Name | Type | Columns | Partitions | Partition Type | Partition Columns | Subpartition Type | Subpartition Columns |
---|---|---|---|---|---|---|---|---|
NON-UNIQUE | IX1_MGINWEASN | NORMAL | ID_INWE, NR_ASN, NR_POZ | <none> | ||||
NON-UNIQUE | IX_MGINWEGINWE_POWOD | NORMAL | POWOD | <none> |
Constraint Name | Columns | Ref Table Owner | Referenced Table Name | Referenced Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
FK_MGINWEASN_MGINWE | ID_INWE | F_54 | MGINWE | ID_INWE | NO ACTION | ENABLED | No | No |
FK_MGINWE_ASN_MGINWE_PARAM | POWOD | F_54 | MGINWE_PARAM | POWOD | NO ACTION | ENABLED | No | No |
Partitions |
Primary Key, Unique, or Check Constraints |
Redaction Policies |