Show TOC

Background documentationMaximum Retail Price File Format

 

File: [MRPTXN.ASC]

SQL TABLE: PLUMRP

Field Number and Name

Field Type or Mask

Possible Values

1 Update Type

Decimal 2.0

1 - Add

2 - Modify

3 - Delete

99 - Delete all MRP records from the table

2 PLU Number

String 18

3 MRP Price

Decimal 6.2

4 Apply Date

String 8

YYYYDDMM

5 Apply Time

String 6

HHMMSS