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.
|