Transcript
TP Suite User Guide
TPSuite User Guide Table of Contents 1 2
3
4
5 6
7
8
Introduction ................................................................................................................................... 4 Installation ..................................................................................................................................... 4 2.1 System requirement ........................................................................................................... 4 2.2 Install TPSuite software on your system............................................................................. 4 Configuration................................................................................................................................. 7 3.1 Price Option........................................................................................................................ 7 3.2 Communication .................................................................................................................. 7 3.2.1 Table Option ............................................................................................................ 7 3.2.2 TCP/IP ..................................................................................................................... 9 Discover TP (EX0907) on LAN.................................................................................................... 10 4.1 Start scan TP (EX0907).................................................................................................... 10 4.2 Stop scan process ............................................................................................................ 11 4.3 Record navigator button ................................................................................................... 11 4.4 Delete record.................................................................................................................... 11 4.5 Edit record ........................................................................................................................ 11 4.6 Refresh............................................................................................................................. 11 Upload and Download data with TP (EX0907) ............................................................................ 12 Data Introduction......................................................................................................................... 13 6.1 Data operation introduction - Single table......................................................................... 13 6.1.1 Table sheet ............................................................................................................ 14 6.1.2 Data grid ................................................................................................................ 14 6.1.3 Record count information....................................................................................... 14 6.1.4 Record navigator button ........................................................................................ 14 6.1.5 Edit record and Insert record ................................................................................. 14 6.1.6 Delete record ......................................................................................................... 15 6.1.7 Refresh .................................................................................................................. 15 6.1.8 Data export ............................................................................................................ 15 6.2 Data operation introduction - One to many. ...................................................................... 17 6.2.2 Detail table control form ......................................................................................... 18 6.3 Table introduction ............................................................................................................. 19 6.3.1 TRANS DETAIL ..................................................................................................... 19 6.3.2 TRANS HEAD ....................................................................................................... 21 PLU Export and Import................................................................................................................ 22 7.1 PLU export ....................................................................................................................... 22 7.2 PLU import ....................................................................................................................... 23 7.3 TXT data structure............................................................................................................ 23 Update Display fonts ................................................................................................................... 24 8.1 Single byte font type file content....................................................................................... 25 8.2 Double byte font type file content ..................................................................................... 26 2 / 32
TPSuite User Guide 9
Custom keypad (Full version)...................................................................................................... 27 9.1 User keypad layout........................................................................................................... 27 9.2 Create a new user keypad................................................................................................ 28 9.3 Open exist user keypad definition file ............................................................................... 28 10 Transaction data Server protocol ......................................................................................... 29 10.1 Transaction detail ............................................................................................................. 29 10.2 Transaction head.............................................................................................................. 31 11 Other function ...................................................................................................................... 32 11.1 Transaction data auto send (Full version) ........................................................................ 32 11.2 Set date time .................................................................................................................... 32
3 / 32
TPSuite User Guide 1 Introduction TPSuite is a software which can communicate with TP (EX0907).
Discover TP (EX0907) over LAN TPSuite can scan over LAN to collect network information of TP (EX0907).
TP (EX0907) data maintain TPSuite can download and upload data with TP (EX0907) by network.
Display fonts update TP (EX0907) display fonts can be update via TPSuite.
2 Installation 2.1 System requirement 2.1.1 CPU: Pentium 233 MHz above 2.1.2 RAM: 1 gigabyte(GB) above 2.1.3 Graphics: VGA 1024X768 above 2.1.4 OS: Windows XP(SP3)/Vista/7/8 32bit or 64bit
2.2 Install TPSuite software on your system STEP 1: Install BDE z Double click bde.exe
z
Welcome
Press Next.
4 / 32
z
TPSuite User Guide Read Me File
Press Next. z
Ready to install
Press Next. z
Borland Database Engine Directory
Recommend use install default directory. Then press Next to start install. 5 / 32
z
TPSuite User Guide Successfully install
Press Finish. STPE 2: Install TPSuite TPSuite full version: Unzip file TPSuite.zip to local drive. For example, we unzip to d:\. After unzip, we can see folder structure below: d:\TPSuite [Main folder] d:\TPSuite\BIN [Application folder] d:\TPSuite\DB [Data folder] TPSuite standard version: Unzip file TPSuiteStd.zip to local drive. For example, we unzip to d:\. After unzip, we can see folder structure below: d:\TPSuiteStd [Main folder] d:\TPSuiteStd\BIN [Application folder] d:\TPSuiteStd\DB [Data folder] CAUTION: Don’t move and rename for BIN and DB folders. Create a shortcut on desktop TPSuite full version: d:\TPSuite\BIN\TPSUITE.exe
[Application]
TPSuite standard version: d:\TPSuiteStd\BIN\TPSuiteStd.exe
[Application]
6 / 32
TPSuite User Guide 3 Configuration Use Option to set preference.
CAUTION: Must click Save Option button to save setting after each setting page which been modified.
3.1 Price Option
This setting must be the same with TP (EX0907) setting (SPEC 604). For example, if set to 2 digits static, price and percent field will rounding to 2 digits decimal after input.
3.2 Communication 3.2.1 Table Option
7 / 32
TPSuite User Guide Table select The checked fields within the table select will run in one download and upload batch job. Download option Clear table before download Data table (not include transaction data) will be cleared before downloading data from TP (EX0907). If it is unchecked, same key data will be replaced in TPSuite. Upload option Only updated record Upload data to TP (EX0907) which record has been updated. Download transaction data option Download transaction data If it is checked, downloading transaction data will run in one download batch job. Clear table before download Transaction data table will be cleared before downloading from TP (EX0907). If it is unchecked, same key data will be replaced in TPSuite. Transaction head last No. TPSuite will record the last transaction head table number in this field so for the next download job it will start from the recorded number + 1. If Input 0 here, it will download records starting from the first record in transaction head table. Recommend not to change this value. Transaction detail last No. TPSuite will record the last transaction detail table number in this field so for the next download job it will start from the recorded number + 1. If Input 0 here, it will download records starting from the first record in transaction detail table. Recommend not to change this value. Farsi with Iran System encoding Standard TP (EX0907) can use Iran System encoding Standard for Iran customer. This function can convert code page between Farsi and Iran System encoding Standard. This function used two documents for convert below: [TPSuite application folder]\BIN\UNITOIRAN.ini (For convert Farsi to Iran System encoding Standard) [TPSuite application folder]\BIN\IRANTOUNI.ini (For convert Iran System encoding Standard to Farsi) If there is “#” character in the word after converting from Farsi to Iran System encoding Standard, it means there is no match rule found in UNITOIRAN.ini. It will need to add rule manually. For example UNITOIRAN.ini content below:
8 / 32
TPSuite User Guide ….. [142] (Windows Farsi code page char code) ISOLATED=166 (Iran System encoding Standard char code when it is Isolated.) FINAL=166 (Iran System encoding Standard char code when it is in the FINAL.) MIDDLE= (Iran System encoding Standard char code when it is in the Middle. No char code means no define.)
INITIAL=
(Iran System encoding Standard char code when it is in the Initial. No char code means
no define.)
….. 3.2.2 TCP/IP
Default HOST IP Set an IP address for default host IP. Default host IP will show on status bar in the main form.
Default HOST PORT Set a communication port for default host port. Default host port will show on status bar in main form. In the case above, the port is 6800. Data Response Time (ms) During data communication, TPSuite sends data or commands to TP (EX0907). The data response time is in millisecond, and it the time to wait for TP (EX0907) to reply for the result. Value of 1000 means 1 second. Recommend 10 seconds. TCP Delay Time (ms) It is the delay time after each TCP/IP communication session. It also means the time to delay before sending next record when TPSuite uploads records to TP (EX0907). Value of 1000 is 1 second. Host Response Time (ms) Timeout for searching and checking the host before sending data. If the host is not found within the time limit, it means the host cannot be found on the LAN. 9 / 32
TPSuite User Guide Host scan range (Class D) These values are the start and the end of IP scanning range for TP (EX0907) on LAN. For example, if default host IP is 192.168.0.10, the range values are 20~50, TPSuite will scan IP from 192.168.0.20 to 192.168.0.50 during scanning for host operation. Enable Server and Server IP and Server Port (Full version) Server status show in state bar on main form. TPSuite can be a transaction data server to receive transaction data when checked. The settings of HOST IP [301524] and HOST PORT [301528] in TP (EX0907) must have the same setting in TPSuite Server. If the server computer has /;more than one network card (NIC), the server IP must be manually set to enable the server. Please refer to Chapter 10 for Transaction data Server protocol.
4 Connect with TP (EX0907) on LAN TPSuite can scan TP (EX0907) on the same network segment on LAN. TP (EX0907) found on the LAN will be listed on the SCALE sheet and the status field will be renew after scanning.
4.1 Start scan TP (EX0907)
Starts scanning for TP (EX0907) on LAN. Process shows on status bar in main form.
10 / 32
TPSuite User Guide 4.2 Stop scan process
Stop scanning process
4.3 Record navigator button
First record, previous record, next record, last record.
4.4 Delete record
Delete the selected record. The confirm dialog will show after click.
Click OK to delete record or Cancel to Ignore.
4.5 Edit record
Edit the selected record. The edit form will show after click. Click Save to save record and exit edit form. Click Ignore to don’t save and exit edit form.
4.6 Refresh
Refresh display data
11 / 32
TPSuite User Guide 5 Upload and Download data with TP (EX0907) Data in TPsuite can be downloadde and uploaded to TP (EX0907) in one batch. The selected data in U/P LOAD sheet follows the selections in OPTION sheet. But it can be modified. Table process status and batch log show in U/D LOAD sheet.
STEP1: Check target TP (EX0907) IP setting check whether target host IP and port are correct. Make sure that the target host IP is same network segment with computer. STEP2: Select table Basically, The selected data in U/P LOAD sheet follows the selections in OPTION sheet. But it can be modified before uploading and downloading. STEP3: Start upload /download Click Download button to download batch. Click Upload button to upload batch. STEP4: Check log If any error massage that text “**** Batch download failed. Please see log. ****” shows in last line of log text window. It means failed and table select panel show red color text “Processing….”.
12 / 32
TPSuite User Guide
If batch download successfully,that text “**** Batch download completed. ****” show in log text window last line. And table select panel show blue color text record process count + “Completed.”.
6 Data Introduction 6.1 Data operation introduction - Single table.
13 / 32
TPSuite User Guide 6.1.1 Table sheet
6.1.2 Data grid
6.1.3 Record count information
Used Record Count / Maximum Record Count 6.1.4 Record navigator button
First record, previous record, next record, last record. 6.1.5 Edit or insert record Edit button, edit selected record. Insert button, insert a new record. Click edit or insert button, edit form shows following.
Key field Red color label is key field. Some table’s key field can’t modify in insert mode. Data filed Fields of table. Set delete Click “Set record” button to delete status. “DELETED” will show on right top window. Re click set to enable status and “ENABLE” will show on right top window.
14 / 32
TPSuite User Guide
This action is not real to delete record. It’s only set record to delete status. Record still shows in data grid and grey background color.
Delete status record will not be uploaded to TP (EX0907) when uploading. Save Click “save” button to update record and exit edit form. Record text show blue color in data grid after record updated.
Ignore Ignore any modify and exit edit form. 6.1.6 Delete record
Click “-” button to delete the selected record. And the confirm dialog shows following.
Click “OK” button to delete record or “Cancel” button to Ignore. 6.1.7 Refresh
Refresh data 6.1.8 Data export
15 / 32
TPSuite User Guide Export grid data to CSV file. Please Click data export button and export dialog shows below.
STEP1: Select target folder. STEP2: Input export file name. STEP3: Click “save” button.
Click “OK” button to finish export. CSV content First line is field title. Each field data is separated by commas (,). All the field data is embraced by double quotes (“”). CSV can open by Notepad or Microsoft Excel and other application which support CSV file.
16 / 32
TPSuite User Guide 6.2 Data operation introduction - One to many. “One to many” means relation database. It’s a kind of master and detail database. After click insert or edit button on Table sheet, if one to many type, master form will show in edit or insert mode first below:
6.2.1 Master table
Key field Red color label is key field. Some table’s key field can’t modify in insert mode. Data filed
Fields of table.
17 / 32
TPSuite User Guide Edit
Click “Edit” button to edit records in master table. Save
Click “save” button to update records in master table . Record text show blue color in data grid after record updated. Cancel
Cancel any modify in master table Set delete
Click “Set record” button to delete status. “DELETED” will show on right top window. Re click set to enable status and “ENABLE” will show on right top window. Exit
Click “Exit” button to exit master table 6.2.2 Detail table
Operation is as same as “Data operation introduction - Single table” (refer to 6-1).
18 / 32
TPSuite User Guide 6.3 Table introduction Most of table field content please refer to S MODE in user guide of TP (EX0907) .Transaction table introduction show below in this section.
6.3.1
TRANS DETAIL
TRANS DETAIL table stores transaction detail records. It only can be downloaded in batch. Data can be exported but can’t be modified in TPSuite. Field Title Tran Seq No.
Description Transaction sequential number. TRANS DETAIL record primary key. It’s unique in TRANS DETAIL.
Ticket Seq No. Tran Rec No.
Transaction record number in TP (EX0907). Range is 1 to 24576 cycling.
Ticket Rec No.
Ticket record number in TP (EX0907). Range is 1 to 24576 cycling.
Tran No.
Transaction number. It reset to 1 per day depend on SPEC 153.
Ticket No.
Ticket number. It reset to 1 per day depend on SPEC 153.
Group No.
Group number.
Flg1
System used. Ignore.
Flg2
System used. Ignore.
Flg3
System used. Ignore.
Flg4
System used. Ignore.
PLU No.
PLU number.
PLU name
PLU name. Maximum 30 chars.
Year
Transaction year. Christian era. 4 digits.
Month
Transaction month.
Day
Transaction day
Time
Transaction time. Numeric. Data format HHMMSS. 24H. For example: AM 9:05:05 = 90505 PM 5:10:10 = 171010
Clerk No.
Clerk number.
Unit Price
Unit price.
Unit Price Dec
Unit price decimal.
PCS
Transaction pcs. Weight transaction is 1.
Weight
Transaction weight (gross). Pcs transaction is 0.
Weight Dec
Transaction weight decimal.
Net
Transaction weight (net).
WT Unit
Transaction weight unit. Maximum 4 chars. “kg“: Kilogram 19 / 32
TPSuite User Guide “lb”: Pound “g”: G “J”: Taiwan Jin Content depend on TP (EX0907) weight SPEC setting. CAL Unit
Price calculate unit. Maximum 4 chars. “kg“: Per kilogram “100g“: Per 100g “lb”: Per pound “J”: Per Taiwan Jin “L”: Per Taiwan Liang “PCS”: Per pcs Content depend on TP (EX0907) weight SPEC setting.
Total Price
Transaction total price(before discount):total price with / without tax
Total Price Dec
Transaction total price decimal.
Non Discount Total price Transaction total price before discount (by receipt). Decimal refer Total Price Dec. Discount Type
Transaction discount type. Numeric. 0: No discount 1: Unit price value discount 2: Unit price percent discount 3: Total price value discount 4: Total price percent discount 5: Fixed Priced. 6: Free gifts
Discount %
Transaction percent discount.
Discount % Dec
Transaction percent discount decimal.
Discount Price
Transaction value discount. Decimal refer Total Price Dec.
Discount Note
Transaction discount content. Maximum 12 chars. Format is “discount short name”+”discount value or percent”. Discount short name below: “”: No discount “UP “: Unit price value discount “UP%”: Unit price percent discount “TO ”: Total price value discount “TO%”: Total price percent discount “PR “: Fixed Priced. “GIF”: Free gifts
VAT No.
VAT number.
VAT Type
VAT type. Numeric. 0: Unit price include VAT. 1: Unit price exclude VAT. 20 / 32
TPSuite User Guide VAT Name
VAT name. Maximum 10 chars.
VAT %
VAT percent.
VAT % Dec
VAT percent decimal.
VAT
Transaction total VAT. Before summary discount. Decimal refer Total Price Dec.
HOST No.
Scale number. Please refer Preference [301500] of TP (EX0907) S MODE user guide.
Barcode No.
PLU barcode number. Please refer PLU [300208] of TP (EX0907) S MODE user guide.
Trace Code
PLU goods trace code. Please refer PLU [300222] of TP (EX0907) S MODE user guide.
VAT(Disc)
Transaction tax amount after discount. Decimal refer Total Price Dec.
Total Price(Disc)
Transaction total price after discount. Whether include tax or not depend on tax Type. Note: After summary discount, total price was apportioned to each transaction record.
Scale IP
The record which Scale downloaded.
6.3.2
TRANS HEAD Field Title
Description
Ticket Seq No
Ticket sequential number. TRANS HEAD record primary key. It’s unique in TRANS HEAD.
Tram Rec No.
Ticket record number in TP (EX0907). Range is 1 to 24576 cycling.
Ticket No.
Ticket number. It reset to 1 per day depend on SPEC 153.
Start Tran Rec No.
Transaction record number in TP (EX0907). There are many transaction records in a TRANS HEAD record. This is first transaction record number.
End Tran Rec No.
Transaction record number in TP (EX0907). There are many transaction records in a TRANS HEAD record. This is last transaction record number.
Sum PCS
Total transaction counts.
Sum Price before Disc(VAT)
Subtotal of transaction with tax (before discount). Decimal refer Sum Price Dec.
Sum Price before Disc
Subtotal of transaction without tax (before discount). Decimal refer Sum Price Dec.
Sum VAT after Disc
Subtotal of tax (after discount) Decimal refer Sum Price Dec.
Sum VAT before Disc
Subtotal of tax (before discount) 21 / 32
TPSuite User Guide Decimal refer Sum Price Dec. Sum Price after Disc(VAT)
Subtotal of transaction with tax (after discount). Decimal refer Sum Price Dec.
Sum Price Dec
Summary price decimal.
Cash
Cash.
Cash Dec
Cash decimal.
Change
Changed. Decimal refer Sum Price Dec.
Sum Disc Type
total discount type. Numeric. 0: Discount by value 1: Discount by percent.
Sum Disc Value
When Sum Disc Type value is 0, value decimal refer Sum Price Dec. When Sum Disc Type value is 1, value is percent and decimal is 0.
Scale IP
The record which Scale downloaded.
7 PLU Export and Import
Click PLU on menu and choose export or import.
7.1 PLU export
Step 1. Select export type “CSV” or “TXT”. Step 2. If select CSV type in step 1,“Separated by” “Enclosed within” and “Insert field name in first line” can be input. Step 3. Click “Export” button and named and save CSV file.
22 / 32
TPSuite User Guide 7.2 PLU import
Step 1. Select import type “CSV” or “TXT”. Step 2. If select CSV type in step 1, “Separated by” and “Enclosed within” can be input. Step 3. If import file first line is field name, please click “Don’t import first record” to skip first line. Step 4. Click “import” button to select import file and start import.
7.3 TXT data structure
Description PLU No. Group No. Calculate type Calculate weight unit Unit price Unit price decimal digits PLU name Barcode No. PLU item VAT No Pretare Discount No. Cost Cost decimal digits Expired type Expired Time Unit Price Change Trace Code
Byte Note 1~6 Numeric. 7~12 Numeric. 13 Numeric. 0: By Weight 1:By PCS 14 Numeric. 0~5. Depend on TP (EX0907) weight SPEC setting 15~20 Numeric. Include decimal symbol “.” 21 Numeric. 22~51 Text. 52~57 Numeric. 58~87 Numeric. 88~93 Numeric. 94~99 Numeric. 100~10 Numeric. 5 106~111 Numeric. Include decimal symbol “.” 112 Numeric. 113 Numeric. 0:Day 1:Month 2:Year 114~119 Numeric. 120 Numeric. 0:Disable 1:Enable 121~15 Numeric. 0
23 / 32
TPSuite User Guide 8 Update Display fonts Fonts can be updated to TP (EX0907) in FONTS sheet .
STEP1: HOST setting Input HOST IP and PORT. STEP2: Test host
Click
button to check whether host is enable or not on LAN. If enable, green light is on ,
otherwise red light is on.
STEP3: Select font type
STEP4: Select font file Font file must match font type which selected. STEP5: Start upload font file Click “Start Upload” button to upload font. The progress bar shows below.
24 / 32
TPSuite User Guide
Completed information shows when upload successful.
Click OK button to finish.
8.1 Single byte font type file content Support ASCII character set type. Total character: 256 Font size: 8x16 (WxH) File size: 4,096 bytes Font encode 16 bytes for each character.
For example character “A”, char code 65(DEC) 41(HEX)
25 / 32
TPSuite User Guide 8.2 Double byte font type file content Support Chinese Traditional and Simplified character set. Total character: Depend on character set. Blank spaces are filled by x0FF. Font size: 16x16 (WxH) File size: 544,768 bytes. Font encode 32 bytes for each character.
For example Chinese Tradition character “刳”, char code CBD2(HEX) Font byte start address = ( ( CB (203) - A1 (161) ) * 191 + D2 (210) - 40 (64) ) * 32 = 1FE8 (8168) * 32 = 3FD00 (261376) Note: HEX (DEC)
26 / 32
TPSuite User Guide 9 Custom keypad (Full version)
There are 3 kind of input data field. 1 is English keypad. 2 is input char code (decimal). 3 is user define keypad. This chapter describes how to define user keypad. Custom keypad value is depended on font (8x16) that has been installed in TP (EX0907).
9.1 User keypad layout High layer
Low layer
Ten keys
27 / 32
TPSuite User Guide 9.2 Create a new user keypad 9.2.1 Input char code (decimal) in key field. Code 0 is not defined. 9.2.2 Click “Save As” button to save as a new user keypad file (.klt).
9.3 Open exist user keypad file 9.3.1 Click
to open exist KLT file.
9.3.2 Open KLT file. Note: Don’t forget click
after key value changed.
9.4 Upload user keypad 9.4.1 Open or create a KLT file. 9.4.2 Click
to upload. Process will be shown in log text window on U/D LOAD
sheet. And “Custom key setting completed!” dialog will be shown after upload process successful.
28 / 32
TPSuite User Guide 10 Transaction data Server protocol Transaction data can be downloaded from TP (EX0907) via Transaction data Server automatically. These data on TRANS DETAIL and TRANS HEAD data table is as same as data downloaded in TPSuite manually. But different is automatic download does not need to click download button manually.
10.1 Transaction detail Record length: 257 bytes for each Transaction record. Non data space replace with 0x00. Description Identify Status Transaction record number Ticket number Group number Record flag 1 Record flag 2 Record flag 3 Record flag 4 PLU number Unused Transaction day Transaction month Transaction year Transaction time
Bytes 1 1 4 2 2 1 1 1 1 2 1 1 1 2 3
Clerk number. Unit Price Unit price decimal. Transaction pcs Transaction weight (gross) Transaction weight decimal. Transaction weight (net) Transaction weight unit
2 4 1 2 4
Price calculate unit
4
Transaction total price
4
Transaction total price decimal Transaction total price Transaction discount
1
Note Fixed “D”. 0x00: Deleted. 0x01: Enabled. 0xff: Blank record. System used. Transaction record number in TP (EX0907). Range is 1 to 24576 cycling. (TP (EX0907) KEY) It reset to 1 per day depend on SPEC 153. System used. Ignore. System used. Ignore. System used. Ignore. System used. Ignore.
.Christian era. 4 digits. Numeric. Data format HHMMSS. 24H. For example: AM 9:05:05 = 90505 PM 5:10:10 = 171010
Weight transaction is 1. Pcs transaction is 0.
1 4 4
4 1
Maximum 4 chars. “kg“: Kilogram “lb”: Pound “g”: G “J”: Taiwan Jin Content depend on TP (EX0907) weight SPEC setting. Maximum 4 chars. “kg“: Per kilogram “100g“: Per 100g “lb”: Per pound “J”: Per Taiwan Jin “L”: Per Taiwan Liang “PCS”: Per pcs Content depend on TP (EX0907) weight SPEC setting. After unit price type discount. Before summary discount. Whether include VAT or not depend on VAT Type.
Before summary discount (by receipt). Decimal refer Total Price decimal. Numeric. 29 / 32
TPSuite User Guide type
Transaction percent discount Transaction percent discount decimal Transaction value discount Transaction discount content
2
VAT number VAT type
1 1
VAT Name VAT percent VAT percent decimal Transaction total VAT Scale number PLU barcode number PLU goods trace code
10 2 1 4 4 1 30
PLU name Transaction total VAT Transaction total price
60 4 4
Transaction sequential number Transaction number Ticket record number
4
Ticket sequential number
0: No discount 1: Unit price value discount 2: Unit price percent discount 3: Total price value discount 4: Total price percent discount 5: Priced. 6: Free gifts %
1 4
Decimal refer Total Price decimal.
12
Maximum 12 chars. Format is “discount short name ”+”discount value or percent”. Discount short name below: “”: No discount “UP “: Unit price value discount “UP%”: Unit price percent discount “TO ”: Total price value discount “TO%”: Total price percent discount “PR “: Priced. “GIF”: Free gifts
4 4 4
Numeric. 0: Unit price include VAT. 1: Unit price exclude VAT. Maximum 10 chars. 1 bytes used in a character. % Before summary discount. Decimal refer Total Price decimal. Please refer Preference [301500] of TP (EX0907) S MODE user guide. Please refer PLU [300208] of TP (EX0907) S MODE user guide. Please refer PLU [300222] of TP (EX0907) S MODE user guide. 1 bytes used in a character. 2 bytes used in a character. After summary discount. Decimal refer Total Price Dec. After unit price type discount. After summary discount. Whether include VAT or not depend on VAT Type. Note: After summary discount, summary price was apportioned to each transaction record. Primary key of transaction detail in TPSuite (PC KEY). It’s unique in TABLE 50. It reset to 1 per day depend on SPEC 153. Ticket record number in TP (EX0907). Range is 1 to 24576 cycling. (TP (EX0907) KEY) Primary key of transaction head in TPSuite (PC KEY). It’s unique in TABLE 51.
30 / 32
TPSuite User Guide 10.2 Transaction head Record length: 129 bytes for each Transaction record. Non data space replace with 0x00. Description Identify Status Ticket record number
Byte s 1 1 4
Start transaction record 4 number End transaction record 4 number Summary pcs. 4 Summary price 4
Note Fixed “H”. 0x00: Deleted. 0x01: Enabled. 0xff: Blank record. System used. Ticket record number in TP (EX0907). Range is 1 to 24576 cycling. (TP (EX0907) KEY) Transaction record number in TP (EX0907). There are many transaction records in a transaction head record. This is first transaction record number. Transaction record number in TP (EX0907). There are many transaction records in a transaction head record. This is last transaction record number. Before summary discount. Include VAT. Decimal refer Summary price decimal. Before summary discount. Exclude VAT. Decimal refer Summary price decimal. After summary discount. Decimal refer Summary price decimal. Before summary discount. Decimal refer Summary price decimal. After summary discount. Include VAT. Decimal refer Summary price decimal.
Summary price
4
Summary VAT
4
Summary VAT
4
Summary price
4
Summary price decimal. Cash Cash decimal Changed Summary discount type
1 4 1 4 1
Summary discount value
4
Ticket sequential number Ticket number
4
Decimal refer Summary price decimal. Numeric. 0: Discount by value 1: Discount by percent. When Summary discount type value is 0, this value is decimal, refer Summary price decimal. When Summary discount type value is 1, this value is percent and decimal is 0. Primary key of transaction head in TPSuite (PC KEY). It’s unique in TABLE 51.
4
It reset to 1 per day depend on SPEC 153.
31 / 32
TPSuite User Guide 11 Other function
Each action will be shown in log text window of OTHER sheet.
11.1 Transaction data auto send (Full version)
Click “Get data” button to get ticket and transaction sequential number of the last sent data. It will show number in the field if it is available, otherwise it will leave the field empty. Click “Update data” button to update ticket and transaction sequential number of the last sent data. If they are set to zero, it means all transaction records can be resend.
11.2 Set date time
Click “Set date time” button to set date time of computer to TP (EX0907). Due to communicate process time, TP (EX0907) will delay around 1 second.
32 / 32
