, , . . , , , .
. , , , , , , .
, , , . , , , , . ( ).
, . , .. .
1.
1.1.
. . ( ), , , .
, (.. .), , , . , .
1.2. .
, .
:
, , 386 .
1.3.
.
/ , .. . , , , . .
, , . , , , .
. , , , , ( ) .
1.4.
:
.
, .
2.
2.1. .
.
, , , .
, . , . , .
( ) - , , .
( , ) . , 3.
2.2.
, , .
, , , .
, , (, , , .) , , .
2.3.
. , .
:
(, ).
.
2.4.
, : .
, .
. ( ) . , . , , , . ( ). , , , , , , , . , . , ( ). , , . , .. .
, . , .
, , .
. -, , -, .
, ( ) .
, , .
2.5.
, . . :
|
|
// // |
|
|
||
1. |
|
Number |
10 |
##### |
|
|
2. |
|
Date |
8 |
99.99.99 |
||
3. |
|
DocType |
3 |
999 |
||
4. |
|
Priznak |
3 |
999 |
|
|
5. |
Firm |
20 |
||||
6. |
Klient |
150 |
||||
7. |
|
SailType |
20 |
|||
8. |
Sklad |
20 |
||||
9. |
||||||
10. |
|
Osnov |
50 |
|||
11. |
|
Author |
3 |
999 |
||
12. |
. |
Tovar |
70 |
|||
13. |
|
Price |
, |
10, 2 |
9999999.99 |
|
14. |
|
Kol |
, |
10, 3 |
999999.999 |
|
15. |
Sum |
, |
12, 2 |
|||
16. |
NDS |
, |
12, 2 |
|||
17 |
Proveden |
1 |
|
3. .
3.1.
(, Microsoft Access). FoxPro. , , :
, ;
, ;
,
Windows ( )
, .
3.2.
. , , , ( ). :
, . , , .
Tovar.dbf
|
|||
Kod |
Numeric |
5 |
|
Name |
Character |
20 |
|
PriceIn |
Numeric |
6,2 |
|
PriceOut |
Numeric |
6,2 |
|
Unit |
Character |
5 |
|
Proizvod |
Numeric |
3 |
|
Proizv.dbf
|
|||
Kod |
Numeric |
3 |
|
Name |
Character |
10 |
|
Coment |
Character |
30 |
|
Sklad.dbf
|
|||
Kod |
Numeric |
3 |
|
Name |
Character |
25 |
|
Users.dbf
|
|||
Kod |
Numeric |
2 |
|
Name |
Character |
25 |
|
Passport |
Character |
15 |
|
Address |
Character |
50 |
|
Status |
Numeric |
1 |
|
Firms.dbf
|
|||
Kod |
Numeric |
2 |
|
Name |
Character |
25 |
|
Address |
Character |
50 |
|
Tel |
Character |
15 |
|
RS |
Numeric |
14 |
|
OKPO |
Numeric |
8 |
|
MFO |
Numeric |
6 |
|
Bank |
Character |
15 |
|
Klients.dbf ( )
|
|||
Kod |
Numeric |
2 |
|
Name |
Character |
25 |
|
Address |
Character |
50 |
|
Tel |
Character |
15 |
|
RS |
Numeric |
14 |
|
OKPO |
Numeric |
8 |
|
MFO |
Numeric |
6 |
|
Bank |
Character |
15 |
|
Doctype.dbf
|
|||
Kod |
Numeric |
3 |
|
Name |
Character |
10 |
|
Coment |
Character |
30 |
|
Sailtype.dbf
|
|||
Kod |
Numeric |
1 |
|
Name |
Character |
10 |
|
Coment |
Character |
30 |
|
PriznDoc.dbf
|
|||
Kod |
Numeric |
1 |
|
Name |
Character |
10 |
|
Coment |
Character |
30 |
|
( , )
DocumShp.dbf
|
|||
Number |
Character |
10 |
|
Date |
Date |
8 |
|
Type |
Numeric |
3 |
|
Firm |
Numeric |
3 |
. |
|
Numeric |
3 |
|
Klient |
Numeric |
3 |
. |
Osnov |
Character |
50 |
|
Positions |
Numeric |
3 |
|
SailType |
Numeric |
1 |
|
Priznak |
Numeric |
1 |
|
Author |
Numeric |
2 |
() |
Proveden |
Logical |
1 |
- ? |
DocumTbl.dbf
|
|||
Tovar |
Numeric |
5 |
|
Kol |
Numeric |
4 |
|
Price |
Numeric |
6,2 |
( ) |
Docum |
Character |
10 |
|
-. .
Rests.dbf
|
|||
Tovar |
Numeric |
5 |
|
Sklad |
Numeric |
3 |
|
Rest |
Numeric |
5 |
|
Motion.dbf
|
|||||
Tovar |
Numeric |
5 |
|||
Kolvo |
Numeric |
4 |
|||
Date |
Date |
8 |
|||
Docnum |
Character |
10 |
|
Duties.dbf
|
|||
Klient |
Numeric |
3 |
|
Duty |
Numeric |
12,2 |
( ) |
Mduty.dbf
|
|||
Klient |
Numeric |
3 |
|
Sum |
Numeric |
12,2 |
|
Date |
Date |
8 |
|
Docum |
Character |
10 |
|
.
. . , . , .
. Coment .
.
- -. , .. .
, . :
: ; ; . , , .
, . : 1-;
2-; 3-, .. , .
, : 1-; 2- ; 3- ; 4- .
. . . , , , . Number ( ), , , , .. .
. , , , .
, ( ) , .
, .
3.3.
, , . , .
, , . .
V.
, , , 3 , . , , .
|
|