Penny Lane POS Developer's Kit

Penny Lane POS Developer's Kit

Developer's Kit KIT 1

Developer's Kit Overview KIT 1

Compatibility Modes KIT 2

Normal Compatibility Mode KIT 2

42SF3/4 Compatibility Mode KIT 2

Polling Data KIT 4

Polling Overview KIT 4

Sample Penny Lane POS Configuration KIT 5

Summary of Compatibility Mode Reports KIT 6

Record Format Syntax KIT 7

Penny Lane POS Record Formats KIT 9

Header Records KIT 9

42SF3/4 Compatibility KIT 9

Normal Compatibility KIT 9

Daily Totals KIT 10

42SF3/4 Compatibility KIT 10

Normal Compatibility KIT 10

Daily Totals Format KIT 10

Cashier Readings

(Individual and Full) KIT 14

42SF3/4 Compatibility KIT 14

Normal Compatibility Mode - Available KIT 14

Cashier Readings Format KIT 14

Individual Clerk Readings KIT 15

42SF3/4 Compatibility KIT 15

Normal Compatibility Mode - Available KIT 15

Individual Clerk Readings Format KIT 15

Hourly Totals KIT 16

42SF3/4 Compatibility KIT 16

Normal Compatibility Mode - Available KIT 16

Hourly Totals Format KIT 16

Daily Department Totals KIT 17

42SF3/4 Compatibility KIT 17

Normal Compatibility Mode KIT 17

Daily Department Totals Format KIT 17

Cash in Drawer KIT 18

42SF3/4 Compatibility KIT 18

Normal Compatibility KIT 18

Cash in Drawer Format KIT 18

PLU Sales KIT 19

42SF3/4 Compatibility KIT 19

Normal Compatibility KIT 19

SKU Sales KIT 20

42SF3/4 Compatibility KIT 20

Normal Compatibility Mode KIT 20

Transaction Summaries KIT 21

42SF3/4 Compatibility Mode KIT 21

Normal Compatibility Mode KIT 21

Transaction Summaries Format KIT 21

Transaction Details KIT 23

42SF3/4 Compatibility Mode KIT 23

Normal Compatibility Mode KIT 23

Transaction Details Format

New Customer Information KIT 26

42SF3/4 Compatibility KIT 26

Normal Compatibility KIT 26

New Customer Information Format KIT 26

Physical Count KIT 27

42SF3/4 Compatibility KIT 27

Normal Compatibility KIT 27

Physical Count Format KIT 27

Inventory Re-Assign KIT 27

42SF3/4 Compatibility KIT 27

Normal Compatibility KIT 27

Inventory Re-Assign Format KIT 27

Inventory Transit In KIT 28

42SF3/4 Compatibility Mode KIT 28

Normal Compatibility Mode KIT 28

Inventory Transit In Format KIT 28

Inventory Transit Out KIT 28

42SF3/4 Compatibility Mode KIT 28

Normal Compatibility Mode KIT 28

Inventory Transit Out Format KIT 28

Daily Banking Information KIT 29

Daily Sales Information Format KIT 29

Daily Tender Information Format KIT 29

Store Order Request KIT 30

42SF3/4 Compatibility Mode KIT 30

Normal Compatibility Mode KIT 30

Store Order Request Format KIT 30

Key Data Entry KIT 30

42SF3/4 Compatibility KIT 30

Normal Compatibility Mode KIT 30

Key Data Entry Format KIT 30

Updating Data KIT 31

PLU Transfer File KIT 31

Format "A" KIT 31

Format "B" KIT 32

Normal Pricing PLU KIT 32

Normal Pricing PLU Format KIT 32

PLU Information KIT 33

(Assumed decimal places) KIT 33

Assumed Decimal Format KIT 33

Price Type Table KIT 34

PLU Information

(Mandatory decimal places) KIT 34

Mandatory Decimal Format KIT 34

PLU Quantity Updates KIT 35

Department Information KIT 35

Department Format KIT 35

Foreign Exchange Rate KIT 36

Foreign Exchange Rate Format KIT 36

Tax Information Entry KIT 36

Tax Entry Format KIT 36

Tax Table Entry KIT 36

Tax Table Entry Format KIT 36

MixMatch Split Pricing Entry KIT 37

Assumed decimal places KIT 37

Assumed Decimal Format KIT 37

MixMatch Stepwise Pricing Entry

Assumed decimal places KIT 37

Assumed Decimal Format KIT 37

MixMatch Split Pricing Entry

Mandatory Decimal Places KIT 38

Mandatory Decimal Format KIT 38

MixMatch Stepwise Pricing Entry

Mandatory Decimal Places KIT 38

Mandatory Decimal Format KIT 38

Tare Entry KIT 39

Tare Entry Format KIT 39

User Entry KIT 39

User Entry Format KIT 39

Customer Information KIT 40

Customer Entry Format KIT 41

Price Tag Printing KIT 42

Special Codes KIT 43

Modifiers KIT 44

Additional Square Bracket Codes KIT 45

Comment Lines KIT 46

Developer's Kit Overview

Penny Lane POS is a complete point-of-sale solution designed specifically for general merchandise retailers. Penny Lane POS utilizes the flexibility and power of a PC and adds the functionality, performance, and control of a cash register. The Penny Lane POS system is designed for retail environments requiring anything from a single, stand-alone system to a multi-store, multi-terminal solution.

The Developer's Kit provides information on how to integrate Penny Lane POS with other software applications. Penny Lane POS's supporting documentation should be reviewed and thoroughly understood before using this Kit.

Compatibility Modes

Penny Lane POS has been developed with a view to data compatibility with datasym's 42SF3/4 product and the communications product called YakPak. The compatibility mode that is selected determines the format of the data that is generated by Penny Lane POS.

Normal Compatibility Mode

Normal Compatibility should be selected by all users who do not require data compatibility with datasym's 42SF3/4 product and YakPak. Normal mode offers additional data than 42SF3/4 compatibility mode.

42SF3/4 Compatibility Mode

The data generated by Penny Lane POS in this mode is essentially the same as the data produced by YakPak with a 42SF3/4 enhancement board. Users who have previously developed interfaces with 42SF3/4 applications should select this compatibility mode. Existing interface programs should not require modification in order to function with data generated by Penny Lane POS in this mode. There are some minor differences which are outlined in general below and in detail under each Report Title.

General Compatibility:

Penny Lane POS supports delimited records. Unlike YakPak, fixed length fields are not supported. Fields are not zero padded and there are no trailing spaces.

Reports not supported:

Report 6 Full Clerk Totals

Report 20 Sharp PLU Totals

Report 22 Sharp PLU Stock quantities

Report 60 Previous Balances

Report 90 Positive/Negative Check File

Report 92 Management Functions

Report 99 Service Programming

Report 1 Fields Not Supported:

011,002 Deduction Total Sales Amt and Qty

025,007 01 - 10 1st through 10th Cash in Drawer Entry

Reports 2 and 5:

Cashier number may be three digits in Penny Lane POS

Polling Data

Polling Overview

Polling with Penny Lane POS moves data from remote sites to a central location. Penny Lane POS requires that a Polling Mode and a Compatibility Mode be defined for each polling session.

The Polling Mode defines whether the data is read from the terminal, or read and reset. If the mode is Read Only, all data is retained at the terminal and is "mirrored" in the polled file. If the mode is Read and Reset, all sales transaction detail and summary data from the remote location is read, then cleared, and the totals are set to 0.

File names are formated as follows:

010SSSX.DAT

where SSS represents a four digit store number

An "X" (READ ONLY) has been executed

010SSS.DAT

where SSS represents a four digit store number

A "Z" (READ AND RESET) has been executed

The options for compatibility are Normal or 42SF3/4. The 42SF3/4 compatibility mode retains the data structures generated by a 42SF3/4 enhancement board.

Data is generated for each terminal and is preceded by a header record which identifies the terminal and the date that the data was generated. The polling function creates a 010SSSX.DAT or a 010SSS.DAT file for each store.

Sample Penny Lane POS Configuration

The following diagram illustrates a sample Penny Lane POS configuration that has two stores. Store 1 has 3 terminals; Store 2 has 1 terminal.

Summary of Compatibility Mode Reports

Penny Lane POS Reports / 42SF3/4 Mode Compatibility / Normal Mode Compatibility /
Daily Sales / Yes (1 Report) / Yes
Cashier Totals / Yes (2 Report) / Yes
Clerk Totals / Yes (3 Report) / Yes
Hourly Totals / Yes (4 Report) / Yes
Daily Department Totals / Yes (10 Report) / Yes
Cash in Drawer / Yes (30 Report) / Yes
PLU Sales / Yes (80 Report) / Yes
SKU Sales / Yes (85 Report) / Yes
Transaction Summaries / No / Yes
Transaction Details / No / Yes
New Customer Information / No / Yes
Physical Count / No / Yes
Inventory Re-Assign / No / Yes
Inventory Transit In / No / Yes
Inventory Transit out / No / Yes
Store Order Request / No / Yes
Key Data1 / Yes / Yes
42SF3/4 Reports / The following reports are not available from Penny Lane POS, but are available with a 42SF3/4
Full Cashier Totals / 5 Report
Full Clerk Totals / 6 Report
Sharp PLU Totals / 20 Report
Sharp PLU Stock Quantities / 22 Report
Previous Balances / 60 Report
Positive/Negative Check File / 90 Report
Management Functions / 92 Report
Service Programming / 99 Report
Periodics (All) / Reports 6, 10

1 Key Data records are available from both the 42SF3/4 and Penny Lane POS but the record formats are different.

Record Format Syntax

• Files may contain one or more records

• Records may contain one or more lines.

• Lines contain one or more fields. Each line is terminated by a CR/LF combination. Information in the first line of a record determines the number of lines that are in the record.

• Fields contain one specific piece of information. Each field is separated by either a comma ( , ) or a double vertical bar ( ║ ). The values for these characters are identified in the table below.

• Field delimiters are constant within each line. If the first delimiter in a record is a comma, doublebars will be ignored as a delimiter. If the first delimiter in a record is a doublebar, the comma will be ignored as a delimiter.

• Records generated in 42SF3/4 compatibility mode do not use the ║ character as a delimiter.

• Dollar amounts are expressed in cents (ie., $1.99 is output as 199)

• Amount fields may not use leading zeros

• A zero length in a numeric field indicates the number zero.

CHARACTER VALUES
CHARACTER / DECIMAL / HEX
CR (carriage return) / 13 / 0D
LF (line feed) / 10 / 0A
COMMA / 44 / 2C
DOUBLE VERTICAL BAR / 186 / BA

Penny Lane POS Record Formats

Header Records

A Header Record precedes the data generated by each terminal in the ".DAT" file.

42SF3/4 Compatibility

This Header Record will be included when the 42SF3/4 Compatibility Mode has been selected.

Field # Description Type Valid Entries

1 Record Type Numeric 00

2 Terminal No. Numeric 1-32

3 Month/Day Numeric 1-12 / 1-31

Sample Record: 00,2,1107 (Header Record for terminal 2 created on November 7)

Normal Compatibility

This Header Record will be included when the Normal Compatibility Mode has been selected.

Field # Description Type Valid Entries

1 Record Type Numeric 00

2 Terminal No. Numeric 1-32

3 Yr/Mth/Day Numeric YYYYMMDD

4 Record Source A/N T

5 Update Type A/N

6 Version # A/N

Sample Record: 00,2,19911107,T,u,101 (Header Record for terminal 02 created on November 7)

Daily Totals

42SF3/4 Compatibility

Daily Totals, known as the 1 Report with a 42SF3/4 board, is available in 42SF3/4 compatibility mode. The report is the same as that produced with a 42SF3/4 with the following minor exceptions:

• The following fields, available on the 42SF3/4 are not supported by Penny Lane POS:

7,01,011,002, x1, x2 1Deduction Total Sales Amt 2Qty

7,01,025,007,01, x1 11st Cash in Drawer Entry (Most Recent)

7,01,025,007,02, x1 12nd Cash in Drawer Entry

7,01,025,007,03, x1 13rd Cash in Drawer Entry

7,01,025,007,04, x1 14th Cash in Drawer Entry

7,01,025,007,05, x1 15th Cash in Drawer Entry

7,01,025,007,06, x1 16th Cash in Drawer Entry

7,01,025,007,07, x1 17th Cash in Drawer Entry

7,01,025,007,08, x1 18th Cash in Drawer Entry

7,01,025,007,09, x1 19th Cash in Drawer Entry

7,01,025,007,10, x1 110th Cash in Drawer Entry

• Record types 051 and 052 for Layaways and Special Orders are not available in 42SF3/4 mode.

Normal Compatibility

Daily Totals is available in Normal Compatibility Mode.

Daily Totals Format

Field # Description Type Valid Entries

1 Record ID Numeric 7 or 6

2 Report No. Numeric 01

3 Data Type Numeric See Below

4 Sub Type Numeric See Below

5,6,7 See Below Numeric See Below

Record Descriptions by Sub Type

x represents a field of variable length, having a value or quantity for the description provided

7,01,025,008, x1 1Z1 Reset Counter

7,01,025,009, x1 1Z2 Reset Counter

7,01,025,010, x1 1Grand Total of Plus Registrations

7,01,025,011, x1 1Grand Total Minus Registrations

7,01,025,012, x1 1Net Grand Total

7,01,025,006, x1, x2, x3 1Foreign Sales Qty, 2Sale Amt, 3Exchange Amt

7,01,025,005, x1, x2 1Foreign Currency Cash in Drawer Qty, 2Amt

7,01,025,004, x1, x2 1Foreign Currency R/A Qty, 2Amt

7,01,025,003, x1, x2 1Employee Sales Qty, 2Amt

7,01,025,002, x1, x2 1Float Out Qty, 2Amt

7,01,025,001, x1, x2 1Float In Qty, 2Amt

7,01,001, x1, x2, x3 1Department No., 2Department Sales Amt, 3Qty

7,01,002,006, x1, 1Real + Department Total

7,01,002,007, x1 1Real - Department Total

7,01,004,002, x1 1Net 1 Sales Total

7,01,002,008, x1 1Hash + Department Total

7,01,002,009, x1 1Hash - Department Total

7,01,005,004, x1 1Net Taxable 1 Total

7,01,005,002, x1 1Tax 1 Total + Sales

7,01,005,003, x1 1Tax 1 Total - Sales

7,01,005,001, x1 1Net Tax 1 Total

7,01,006,004, x1 1Net Tax 2 Total

7,01,006,002, x1 1Tax 2 Total + Sales

7,01,006,003, x1 1Tax 2 Total - Sales

7,01,006,001, x1 1Net Tax 2 Total

7,01,007,001, x1 1Net Manual Tax Total

7,01,004,001, x1 1Sales Total Including Tax

7,01,002,003, x1 1Charge and Check Change

7,01,002,004, x1 1Food Stamp Change

7,01,002,010, x1 1Charge and Check Change R/A

7,01,002,002, x1 1Food Stamp in Drawer

7,01,004,003, x1 1Sales Total Including Hash Departments

7,01,002,001, x1 1Cash in Drawer

7,01,003,006, x1 1Non Add Printing Counter

7,01,003,003, x1 1No Sale Counter

7,01,003,002, x1 1Validation Print Counter

7,01,003,005, x1 1Slip Print Counter

7,01,003,001, x1 1Customer Count

7,01,009,001, x1,x2 1CP1 Total Sales Amt, 2Qty

7,01,010,001, x1,x2 1%1 Total Sales Amt, 2Qty