Comment for Table KG_SL_BILANS_POZ_HISTORIA
Comment
Tablica z zapisanymi do historii pozycjami zestawieniami dla roku księgowego

Columns of Table KG_SL_BILANS_POZ_HISTORIA
Column ID Column Name Datatype Not Null Data Default Comments
1 ID_POZ_HISTORIA NUMBER Y   Klucz główny z sekwencji Sq_Kg_Sl_Bilans_Poz_Id_Poz
2 ID_HISTORIA NUMBER Y   Id historii, której dotyczy pozycja z KG_SL_BILANS_HISTORIA
3 BO_STAN NUMBER     Zapisana wartość BO
4 OBROTY NUMBER     Zapisana wartość obrotów
5 PRZYCHOD NUMBER     Zapisana wartość przychodów
6 ROZCHOD NUMBER     Zapisana wartość rozchodów
7 SALDO NUMBER     Zapisane saldo końcowe
8 ID_POZ_BILANS NUMBER Y   Id przepisanej do historii pozycji bilansu z KG_SL_BILANS_POZ

Indexes on Table KG_SL_BILANS_POZ_HISTORIA
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
NON-UNIQUE INDX_KG_SL_BILA_IDHISTORIA NORMAL ID_HISTORIA <none>        
NON-UNIQUE INDX_KG_SL_BILA_IDPOZBILANS NORMAL ID_POZ_BILANS <none>        
UNIQUE PK_KG_SL_BILANS_POZ_HIST_ID NORMAL ID_POZ_HISTORIA <none>        

Foreign Key Constraints on Table KG_SL_BILANS_POZ_HISTORIA
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
FK_KG_SL_BILANS_POZ_HIST_HIST ID_HISTORIA F_54 KG_SL_BILANS_HISTORIA ID_HISTORIA NO ACTION ENABLED No No
FK_KG_SL_BIL_POZ_HIST_ID_P_BIL ID_POZ_BILANS F_54 KG_SL_BILANS_POZ ID_POZ NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table KG_SL_BILANS_POZ_HISTORIA
Constraint Name Type Condition Status Columns
NN_KG_SL_BILANS_POZ_HIST_HIST Check "ID_HISTORIA" IS NOT NULL ENABLED ID_HISTORIA
NN_KG_SL_BIL_POZ_HIST_ID_P_BIL Check "ID_POZ_BILANS" IS NOT NULL ENABLED ID_POZ_BILANS
PK_KG_SL_BILANS_POZ_HIST_ID Primary Key   ENABLED ID_POZ_HISTORIA

Table KG_SL_BILANS_POZ_HISTORIA does not have...
Partitions
Redaction Policies