Home > Technical > Table Definitions > NEXTSEQNUM

NEXTSEQNUM

The receipt numbers used by POS are a sequential number for all transactions. Some countries use different sequence numbers for different types of transactions. You can use NEXTSEQNUM records to show which transaction types require a different sequence number. A different sequence number is maintained for each record. The system will find the record where the transaction type is in the MEMTYPES field. This will give the STRCODE. The system will then use the sequence number for that code. You only need NEXTSEQNUM records for the exceptions. If a transaction type is not defined in a NEXTSEQNUM, it will continue use the existing sequence number the system has always used. The 'Unused Sequences Audit Report' is a report which shows transaction numbers that were assigned but not actually used, for example user starts a new PO then cancels it before saving.

Example - Without NEXTSEQNUM

SALE 1

SALE 2

RETURN 3

PRINTBILL 4

NOSALE 5

SALE 6

Example - With NEXTSEQNUM

NONSALE = PRINTBILL, NOSALE

SALE 1

SALE 2

RETURN 3

PRINTBILL 1      <---- this is based on the sequence number for NONSALE

NOSALE 2

SALE 4              <----back to the standard sequence number


Column

Type

Description

STRTYPE

VARCHAR(10)

Indicates where the records will be used. At this stage only 'POS' is supported.

STRCODE

VARCHAR(10)

A code assigned by the user to identify the record. A sequence number will be kept for each STRCODE.

MEMTYPES

TEXT

The types that are to use this record. This is a memo field. Each transaction type will be on a new line.

 

Primary Key: STRTYPE + STRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)