Контракты
Скачать схему в формате JSON
schema.json
Схема данных
| _id | |
|---|
| id | |
|---|
| parent_id | |
|---|
| referens | |
|---|
| status | |
|---|
| form_date | |
|---|
| journal_number | |
|---|
| journal_date | |
|---|
| snd_tofk_code | |
|---|
| snd_tofk_name | |
|---|
| ppp_code | |
|---|
| customer_code | |
|---|
| customer_name | |
|---|
| customer_inn | |
|---|
| customer_kpp | |
|---|
| public_formation | |
|---|
| budget_name | |
|---|
| budget_code | |
|---|
| off_budget_type | |
|---|
| reg_tofk_code | |
|---|
| reg_tofk_name | |
|---|
| contract_number | |
|---|
| contract_date | |
|---|
| contract_end_date | |
|---|
| placement_type | |
|---|
| reason_date | |
|---|
| reason_document | |
|---|
| result_date | |
|---|
| currency_code | |
|---|
| note_number | |
|---|
| contract_price | |
|---|
| change_number | |
|---|
| change_date | |
|---|
| change_reason | |
|---|
| chief_name | |
|---|
| chief_date | |
|---|
| executor_post | |
|---|
| executor_name | |
|---|
| executor_date | |
|---|
| execution_type | |
|---|
| execution_date | |
|---|
| execution_reason | |
|---|
| cancel_date | |
|---|
| cancel_reason | |
|---|
| actual_payment | |
|---|
| notice_date | |
|---|
| izm_type | |
|---|
| dol_ruk_fk | |
|---|
| name_ruk_fk | |
|---|
| load_name | |
|---|
| changes | | type | dict |
|---|
| schema | | change_number | |
|---|
| id | |
|---|
| form_date | |
|---|
| change_reason | |
|---|
|
|---|
|
|---|
| goods | | type | dict |
|---|
| schema | | item_number | |
|---|
| goods_name | |
|---|
| okp_code | |
|---|
| okei_measure | |
|---|
| price | |
|---|
| count | |
|---|
| total_amount | |
|---|
|
|---|
|
|---|
| cinfo | | type | dict |
|---|
| schema | | line_type | |
|---|
| fkr_code | |
|---|
| csr_code | |
|---|
| kvr_code | |
|---|
| ekr_code | |
|---|
| by_year | |
|---|
|
|---|
|
|---|
| suppliers | | type | dict |
|---|
| schema | | item_number | |
|---|
| name | |
|---|
| country | |
|---|
| oksm_code | |
|---|
| address | |
|---|
| inn | |
|---|
| kpp | |
|---|
| status | |
|---|
| phone | |
|---|
|
|---|
|
|---|