Exporter - Product Price Lists

Field

Description

Min Sage Version

Data Type

Length

TYPE

Type: customer price list (P), supplier price list (U), customer special price (S)

10

String

1

PRICING_REF*

Pricing Reference

10

String

8

STOCK_CODE*

Stock Code

10

String

30

CALC_METHOD

Price Calculation Method

10

Int32

4

CALC_VALUE

Value or Percentage, depending on Method

10

Double

8

STORED_PRICE

Price for manually recalculated price lists

10

Double

8

ROUNDER_METHOD

Rounding Method

10

Int16

1

ROUNDER_DIRECTION

Rounding Direction

10

Int16

1

ROUNDER_MULTIPLE_OF

Rounding Multiple

10

Double

8

ROUNDER_ADJUSTMENT

Rounding Adjustment

10

Double

8

RECORD_CREATE_DATE

Date and time when the record was created.

2009

Date

8

RECORD_MODIFY_DATE

Date and time when the record was modified.

2009

Date

8

RECORD_DELETED

Flag denoting if the record has been deleted or not.

2009

Boolean

2

 

* Denotes the primary key field used to distinguish unique records.