Ñòðóêòóðà TCUMobileBase
Êàòåãîðèè òîâàðîâ (kat)
kat_number – íîìåð
êàòåãîðèè
kat_name –
íàèìåíîâàíèå êàòåãîðèè
top_kat – äàííîå
ïîëå ñîäåðæèò ññûëêó íà ðîäèòåëüñêóþ êàòåãîðèþ
Åäèíèöû èçìåðåíèÿ
(izmer)
izmer_number – íîìåð
åäèíèöû èçìåðåíèÿ
izmer_name – íàèìåíîâàíèå
åäèíèöû èçìåðåíèÿ
Ñïðàâî÷íèê êëèåíòîâ
(client)
client_number – íîìåð êëèåíòà
client_name – èìÿ
êëèåíòà
s_name – áóêâà,
íà êîòîðóþ íà÷èíàåòñÿ èìÿ êëèåíòà
address – àäðåñ
êëèåíòà
telefon – òåëåôîí
saldo – òåêóùåå
ñàëüäî
days – äåíü
íåäåëè â êîòîðûé îáñëóæèâàåòñÿ äàííûé êëèåíò
Ñòàòüè äâèæåíèÿ
(articl)
articl_number – íîìåð ñòàòüè
articl_name – íàèìåíîâàíèå
act_pass – ñòàòóñ
ñòàòüè (àêòèâíàÿ/ïàññèâíàÿ)
closed
– íå èñïîëüçóåòñÿ, âñåãäà FALSE
Òàáëèöà òîðãîâûõ òî÷åê
è êëèåíòîâ (point)
point_number – íîìåð
òî÷êè
name_point – íàèìåíîâàíèå
òî÷êè
post –
ïîñòàâùèê (êëèåíò), åñëè post = FALSE, òî ýòî âíóòðåííÿÿ òî÷êà, â ïðîòèâíîì
ñëó÷àå - êëèåíò
comm_agent – àãåíò,
åñëè comm_agent = TRUE, òî ýòî àãåíò
MyPoint – äàííîå
ïîëå ñîäåðæèò íîìåð òåêóùåé òîðãîâîé òî÷êè
MyAgent –
ñîäåðæèò íîìåð òåêóùåãî àãåíòà
Àðõèâ äîêóìåíòîâ
(nakl_arhiv)
nakl_number – íîìåð äîêóìåíòà
doc_number –
âíóòðåííèé íîìåð äîêóìåíòà
point2_number – ññûëêà
íà íîìåð êëèåíòà êóäà èäåò òîâàð (êëèåíò)
name_point – íàçâàíèå
òîðãîâîé òî÷êè ñ êîòîðîé áûëà âûïèñàíà íàêëàäíàÿ èëè íà êîòîðóþ ïðèíèìàëàñü
îïëàòà îò êëèåíòà
date_utv – äàòà
óòâåðæäåíèÿ äîêóìåíòà
sum_vzr – ñóììà
ïî âçàèìîðàñ÷åòó, êîòîðàÿ îòðàæàåòñÿ íà èçìåíåíèè çàäîëæåííîñòè êëèåíòà
sum_opl – ñóììà äîêóìåíòà,
êîòîðàÿ åùå íå îïëà÷åíà
osn – îñíîâàíèå,
íà êîòîðîì ïðîâåäåí äàííûé äîêóìåíò
nakl_type – òèï
äîêóìåíòà (0 – ðàñõîäíàÿ íàêëàäíàÿ, 7 – ïðèõîäíûé êàññîâûé îðäåð, 18 – çàêàç îò
êëèåíòà)
rash_prih – ïðèçíàê ðàñõîäíîãî(FALSE)/ïðèõîäíîãî(TRUE) äîêóìåíòà
utv –
óòâåðæäåí/íå óòâåðæäåí
arhiv – ïðèçíàê,
÷òî äàííûé äîêóìåíò ÿâëÿåòñÿ àðõèâíûì, ò.å. çàãðóæåííûì èç ó÷åòíîé ñèñòåìû, à
íå íàáðàíû â ÊÏÊ â òåêóùåì ñåàíñå ðàáîòû
client_name –
íàèìåíîâàíèå êëèåíòà
point1_number – íîìåð
òîðãîâîé òî÷êè îòêóäà èäåò òîâàð
cli_group_name –
íàèìåíîâàíèå ãðóïïû â êîòîðóþ âõîäèò äàííûé êëèåíò
articl_name – ñòàòüÿ
äâèæåíèÿ
agent_number – íîìåð
àãåíòà
bundle_nakl_number – íîìåð
ñâÿçàííîãî äîêóìåíòà
Òî÷êè äîñòàâêè
(delive_point)
delive_point_number – íîìåð òî÷êè äîñòàâêè
delive_address – àäðåñ
point_number – ññûëêà
íà êëèåíòà
days – äåíü
îáñëóæèâàíèÿ äàííîé òî÷êè äîñòàâêè
Ñïðàâî÷íèê òîâàðîâ
(tovar)
tovar_number – íîìåð
òîâàðà
t_name –
íàèìåíîâàíèå òîâàðà
kat_name –
íàèìåíîâàíèå êàòåãîðèè â êîòîðóþ âõîäèò òîâàð
izmer_name – åäèíèöû
èçìåðåíèÿ òîâàðà
kol – êîëè÷åñòâî
òîâàðà íà ñêëàäå
cena_rozn – ðîçíè÷íàÿ
öåíà
reestr_number – íîìåð
òîâàðà â ðååñòðå òîâàðîâ
point_number – òîðãîâàÿ
òî÷êà íà êîòîðîé ïðèñóòñòâóåò òîâàð
kol_in_pak – êîëè÷åñòâî
â óïàêîâêå
öåíû èç ïðàéñ-ëèñòà
cena_rozn_sprav – öåíà
ðîçíè÷íàÿ èç ñïðàâî÷íèêà òîâàðîâ
cena_rozn2 –öåíà ðîçíè÷íàÿ2
cena_rozn3 – öåíà ðîçíè÷íàÿ3
cena_rozn4 – öåíà ðîçíè÷íàÿ4
cena_rozn5 – öåíà ðîçíè÷íàÿ5
Ðàñøèðåííûé ñïðàâî÷íèê
òîâàðîâ (tovar_ext), ñîäåðæèò âñå òîâàðû èç ðååñòðà òîâàðîâ
tovar_number – íîìåð
òîâàðà
t_name – íàèìåíîâàíèå
òîâàðà
kat_name – êàòåãîðèÿ
â êîòîðóþ âõîäèò äàííûé òîâàð
izmer_name – åäèíèöû
èçìåðåíèÿ
kol – êîëè÷åñòâî
òîâàðà íà ñêëàäå
cena_rozn – ðîçíè÷íàÿ
öåíà
cena_rozn_sprav – öåíà
ðîçíè÷íàÿ èç ñïðàâî÷íèêà òîâàðîâ
kol_in_pak – êîëè÷åñòâî
â óïàêîâêå
cena_rozn2 – öåíà ðîçíè÷íàÿ2
cena_rozn3 – öåíà ðîçíè÷íàÿ3
cena_rozn4 – öåíà ðîçíè÷íàÿ4
cena_rozn5 – öåíà ðîçíè÷íàÿ5
Ïåðå÷åíü òîâàðîâ â
íàêëàäíîé/çàêàçå (list)
list_number – íîìåð
çàïèñè òîâàðà â íàêëàäíîé (â çàêàçå)
nakl_number – ññûëêà
íà äîêóìåíò (íàêëàäíóþ, çàêàç), êîòîðîìó ïðèíàäëåæèò çàïèñü òîâàðà
reestr_number – ññûëêà
íà çàïèñü â ðååñòðå òîâàðîâ ó÷åòíîé ñèñòåìû
tovar_number – íîìåð
òîâàðà â ñïðàâî÷íèêå òîâàðîâ
t_name –
íàèìåíîâàíèå òîâàðà
kol_in_pak –
êîëè÷åñòâî â óïàêîâêå
kol_pak –
êîëè÷åñòâî óïàêîâîê
kol_add –
äîïîëíèòåëüíî êîëè÷åñòâî òîâàðà
kol – ñóììàðíîå
êîëè÷åñòâî, ðàññ÷èòûâàåòñÿ ïî ôîðìóëå kol_in_pak*kol_pak+kol_add
cena_rozn – öåíà
ðîçíè÷íàÿ
sum_skid
– ñêèäêà