Physical Data Model	Trade13_1

Òîðãîâëÿ

Author: 
Version: 
Date: 

Table List
Code | Label
T_COMPLECT | Êîìëåêòû
T_GRP_SETUP | Íàñòðîéêà ïîëåé äëÿ òîâàðîâ ïî ãðóïïàì òîâàðîâ
T_PRICE | Ïðàéñ-ëèñòû

T_COMPLECT
Column List
Code | Type | P | M | Label
KLS_ID | numeric(9) | Yes | Yes | ID òîâàðà, ÿâëÿþùåãîñÿ êîìïëåêòîì
KLS_NUM_ITEM | int | Yes | Yes | ïîðÿäêîâûé íîìåð â êîìëåêòå
KLS_ID_ITEM | numeric(9) | No | Yes | ID òîâàðà, âõîäÿùåãî â êîìïëåêò
KLS_UPAK | numeric(9) | No | No | ID óïàêîâêè
QUANTITY_UPAK1 | numeric(19,7) | No | No | Êîëè÷åñòâî óïàêîâîê êîìïëåêòàöèè
QUANTITY1 | numeric(19,7) | No | No | Êîëè÷åñòâî êîìïëåêòàöèè
PRICE1 | numeric(19,2) | No | No | Öåíà êîìïëåêòàöèè
SUMMA1 | numeric(19,2) | No | No | Ñóììà êîìïëåêòàöèè
QUANTITY_UPAK2 | numeric(19,7) | No | No | Êîëè÷åñòâî óïàêîâîê ðàçóêîìïëåêòàöèè
QUANTITY2 | numeric(19,7) | No | No | Êîëè÷åñòâî ðàçóêîìïëåêòàöèè
PRICE2 | numeric(19,2) | No | No | Öåíà ðàçóêîìïëåêòàöèè
SUMMA2 | numeric(19,2) | No | No | Ñóììà ðàçóêîìïëåêòàöèè

T_GRP_SETUP
Column List
Code | Type | P | M | Label
KLS_ID | numeric(9) | Yes | Yes | ID ãðóïïû òîâàðà
SPR_ORDER | int | Yes | Yes | Âíóòðåííèé íîìåð íåâèäèìîãî ïîëÿ

T_PRICE
Column List
Code | Type | P | M | Label
KLS_ID | numeric(9) | Yes | Yes | id òîâàðà (ññûëêà íà ñïðâàî÷íèê òîâàðîâ)
PRICE_DATE | datetime | Yes | Yes | Äàòà ïðàéñà
CURR_NUM | int | Yes | Yes | Íîìåð âàëþòû (ññûëêà íà ñïðàâî÷íèê âàëþò)
BRANCH | numeric(9) | Yes | Yes | id ïðåäïðèÿòèÿ
QUANTITY2 | numeric(19,7) | No | No | Êîëè÷åñòâî ìåëêîîïòîâîå
QUANTITY3 | numeric(19,7) | No | No | Êîëè÷åñòâî îïòîâîå
PRICE1 | numeric(19,7) | No | No | Öåíà ðîçíè÷íàÿ ðóáëåâàÿ
PRICE2 | numeric(19,7) | No | No | Öåíà ìåëêîîïòîâàÿ ðóáëåâàÿ
PRICE3 | numeric(19,7) | No | No | Öåíà îïòîâàÿ ðóáëåâàÿ
CURR_KURS | numeric(19,10) | No | No | êóðñ âàëþòû
PRICE_VAL1 | numeric(19,7) | No | No | Öåíà ðîçíè÷íàÿ âàëþòíàÿ
PRICE_VAL2 | numeric(19,7) | No | No | Öåíà ìåëêîîïòîâàÿ âàëþòíàÿ
PRICE_VAL3 | numeric(19,7) | No | No | Öåíà îïòîâàÿ âàëþòíàÿ
STATUS | numeric(1) | No | No | Ïðèçíàê : äåéñòâóåò/ íå äåéñòâóåò
USER_ID | char(32) | No | No | àâòîð
USER_ID_EDIT | char(32) | No | No | ðåäàêòîð
CREAT_DATE | datetime | No | No | äàòà ñîçäàíèÿ çàïèñè
INPUT_DATE | datetime | No | No | äàòà èçìåíåíèÿ çàïèñè

PowerDesigner		Page