| 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
*
DBExport