BECENTURA SIA

“Businesa Vadības Komunikators”

DBExport

| | | 1. Entry No. (Primary key)| integer| 3. Posting date | Date | 5. Quantity| Decimal| 7. Amount | Decimal| 9 Cost Amount| Decimal | | | | VI. Cashiers 2. Name| varchar| 50 4. Cashier POS key| varchar| 8 6. Deleted from POS| tinyint| | | | 1.| Device code (Primary key)| varchar| 20 3.| Device Type (Option – POS,Weights)| option| | | | 1.| | varchar| 20| | | | 1. | | varchar| 20

No.	Table/field name	Type	Length
I.	Item
1.	Item No. (Primary key)	varchar	20
2.	Item Name full	varchar	150
3.	Item Name POS	varchar	30
4.	Sales Unit of Measure (foreign key – Unit of Measure Table)	varchar	10
5.	Unit volume	decimal
6.	Unit volume description (Option- liter,Kg,Gr)	Option
7.	Net Weight	Decimal
8.	Alcohol %	Decimal
9.	Vendor No. (foreign key – Vendor Table)	varchar	20
1.	Block	tinyint
1.	Deleted from POS	tinyint
1.	Unit Price	Decimal
1.	Unit Cost	Decimal
II. Item Barcode
1. Barcode (Primary key)	varchar	20
2. Item No. (foreign key – Item Table)	varchar	20
3. Expiration date	Date
4. Deleted from POS	tinyint
III. Unit of Measure
1. Unit of Measure kode (Primary key)	varchar	10
2. Description.	varchar	30
3. Decimal Places	integer
IV. Vendor
1. Vendor No. (Primary key)	varchar	20
2. Name	varchar	60
3. VAT Registration No.	varchar	20
4. Vendor Address	varchar	60
5. Vendor City	varchar	30
6. Vendor Post Code	varchar	20
7. Vendor Country	varchar	100
8. Vendor Phone No.	varchar	80
9. Vendor E-mail	varchar	80
9. Vendor Fax	varchar	80
9. Is Bloked	bool
10. Vendor Bank Name	varchar	60
11. Vendor Bank SWIFT code	varchar	20
12. Vendor Bank Account No.	varchar	30
V. Item Ledger Entry
2. Item No. (foreign key – Item Table)	varchar	20
4. Entry Type (Option – Sale,Return)	Option
6. Unit Price	Decimal
8 Unit Cost	Decimal
10 Profit Amount	Decimal
1. Cashier code (Primary key)	varchar	10
3. Cashier POS ID	varchar	3
5. Expiration date date
VII. Devices
2.	Network Path	varchar	100
VIII. Z-Header
IX. Z-Line
X.	Retail place setup
1.	Company name	varchar	50
2.	Company address	varchar	100
3.	Company City	Varchar	50
4.	Company Post Code	varchar	10
5.	Company VAT Registration No	varchar	20
6.	Company bank Name	varchar	100
7.	Company SWIFT code	varchar	20
8.	Company Bank Account No.	varchar	30
9.Retail place address	varchar	100
10.	Retail place City	Varchar	50
11.	Retail place Post Code	varchar	10
12.	Retail place category code	varchar	10

POS Interface tables

Prot.dbf faila struktūra
Field Name Field Type Quantity Description
Issued character 12 komandas ģenerācijas datums un laiks DDMMYYYYHHMM
cmd character 2 komandas kods ( piemēram 01 )
P1 character 14 izejošās informācijas fails
P2 character 30 fals-rezultāts
P3 character 14
Lvl character 1
Done_date character 8 komandas izpildes datums *
Done_time character 5 komandas izpildes laiks*
Del character 1
* lauki tiek aizpildīti ja komanda tiek izpildīta bez kļūdām, pretejā gadījumā – tur tiek ierakstīts “-"

Cmd field description – Komandu saraksts
Command Name Code Comment
Ielādēt PLU tabulu 1
Ielādēt mērvienību tabulu 3
Ielādēt kasieru tabulu 4
Nolasīt Z-atskaite 84 P1-Z numurs, P2-faila ceļš

plu.dbf ( Pārdošanas atskaites ) faila struktūra
Field Name Field Type Quantity Description
code character 14 F_CODE; svītru kods
art character 14 F_ART; Navision item code
descr character 35 F_DESCR; preces nosaukums
price character 15 F_NUMBER; cena
price1 character 15 F_NUMBER;
unit character 2 F_INT; mērvienība ( reference )
dec character 1 F_CHAR; decimālo ciparu skaits
tax character 1 F_CHAR; nodokļa kods
tblock character 2 F_INT;
disc character 2 F_INT;
disc_a character 2 F_INT;
dept character 2 F_INT; preču grupa
qty character 15 F_NUMBER; pārdoto preču skaits
amt character 15 F_NUMBER; pārdota summa
status character 1 F_CHAR;
status1 character 1 F_CHAR;
status2 character 1 F_CHAR;
bottle character 8 F_DOUBLE;
active character 1 F_CHAR; “0”/"1” BOOLEAN
del character 1 F_CHAR; “0”/"1” BOOLEAN
load character 1 F_CHAR; “1”
crc character 8 F_DOUBLE;
RC character 1 F_CHAR;
*

unit.dbf ( Mērvienības ) faila struktūra
Field Name Field Type Quantity Description
unit character 2 F_INT; kods
descr character 35 F_DESCR; Nosaukums
dec character 1 F_CHAR; decimālo ciparu skaits
status1 character 1 F_CHAR;
active character 1 F_CHAR;
del character 1 F_CHAR;
load character 1 F_CHAR;
crc character 8 F_DOUBLE;
RC character 1
*


clerk.dbf ( Kasieru tabula ) faila struktūra
Field Name Field Type Quantity Description
cl character 3 kods
id character 8 F_DOUBLE; Atslega
descr character 35 F_DESCR; Apraksts
active character 1 F_CHAR;
del character 1 F_CHAR;
load character 1 F_CHAR;
crc character 8 F_DOUBLE;
RC character 1
*

Таблица Location