Field
|
Description
|
Min Sage Version
|
Data Type
|
Length
|
STOCK_CODE*
|
Stock code
|
10
|
String
|
30
|
DESCRIPTION
|
Description
|
10
|
String
|
60
|
UNIT_OF_SALE
|
Unit of sale
|
10
|
String
|
8
|
NOMINAL_CODE
|
Nominal code
|
10
|
String
|
8
|
PURCHASE_REF
|
Supplier's account reference
|
10
|
String
|
8
|
SUPPLIER_PART_NUMBER
|
Supplier's part number
|
10
|
String
|
16
|
LOCATION
|
Bin location
|
10
|
String
|
16
|
COMMODITY_CODE
|
Commodity code
|
10
|
String
|
30
|
SALES_PRICE
|
Sale price
|
10
|
Double
|
8
|
WEB_DESCRIPTION
|
Web Description
|
10
|
String
|
60
|
WEB_DETAILS
|
Web Details
|
10
|
String
|
1023
|
WEB_CATEGORY_1
|
Web Category 1
|
10
|
String
|
60
|
WEB_CATEGORY_2
|
Web Category 2
|
10
|
String
|
60
|
WEB_CATEGORY_3
|
Web Category 3
|
10
|
String
|
60
|
WEB_IMAGE_FILE
|
Web Image Filename
|
10
|
String
|
60
|
WEB_PUBLISH
|
Is published on the web
|
10
|
Boolean
|
2
|
WEB_SPECIAL
|
Is on special offer on the web
|
10
|
Boolean
|
2
|
INTRASTAT_COMM_CODE
|
Commodity Code (for Intrastat)
|
11
|
String
|
8
|
IGNORE_STK_LVL_FLAG
|
Ignore stock level flag
|
10
|
Boolean
|
1
|
DEPT_NUMBER
|
Department number
|
10
|
Int32
|
2
|
TAX_CODE
|
Tax code (T0 to T99)
|
10
|
String
|
3
|
ASSEMBLY_LEVEL
|
Assembly level
|
10
|
Int32
|
2
|
LINK_LEVEL
|
Link level
|
10
|
Int32
|
2
|
STOCK_CAT
|
Stock category number
|
10
|
Int32
|
2
|
STOCK_TAKE_DATE
|
Stock take date
|
10
|
Date
|
2
|
LAST_PURCHASE_PRICE
|
Last purchase price
|
10
|
Double
|
8
|
LAST_DISC_PURCHASE_PRICE
|
Last discounted purchase price
|
10
|
Double
|
8
|
AVERAGE_COST_PRICE
|
Average cost price
|
10
|
Double
|
8
|
QTY_IN_STOCK
|
Quantity in stock
|
10
|
Double
|
8
|
QTY_ON_ORDER
|
Quantity on order
|
10
|
Double
|
8
|
QTY_ALLOCATED
|
Quantity allocated
|
10
|
Double
|
8
|
QTY_LAST_ORDER
|
Last order quantity
|
10
|
Double
|
8
|
QTY_REORDER
|
Reorder quantity
|
10
|
Double
|
8
|
QTY_REORDER_LEVEL
|
Reorder level
|
10
|
Double
|
8
|
QTY_LAST_STOCK_TAKE
|
Last stock take quantity
|
10
|
Double
|
8
|
LAST_SALE_DATE
|
Last sale date
|
10
|
Date
|
2
|
LAST_PURCHASE_DATE
|
Last purchase date
|
10
|
Date
|
2
|
UNIT_WEIGHT
|
Unit weight
|
10
|
Double
|
8
|
COMPONENT_CODE_1
|
Component 1 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_2
|
Component 2 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_3
|
Component 3 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_4
|
Component 4 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_5
|
Component 5 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_6
|
Component 6 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_7
|
Component 7 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_8
|
Component 8 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_9
|
Component 9 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_10
|
Component 10 stock code
|
10
|
String
|
30
|
COMPONENT_CODE_11
|
Component 11 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_12
|
Component 12 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_13
|
Component 13 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_2008
|
Component 2008 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_2009
|
Component 2009 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_16
|
Component 16 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_17
|
Component 17 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_18
|
Component 18 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_19
|
Component 19 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_20
|
Component 20 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_21
|
Component 21 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_22
|
Component 22 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_23
|
Component 23 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_24
|
Component 24 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_25
|
Component 25 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_26
|
Component 26 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_27
|
Component 27 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_28
|
Component 28 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_29
|
Component 29 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_30
|
Component 30 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_31
|
Component 31 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_32
|
Component 32 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_33
|
Component 33 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_34
|
Component 34 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_35
|
Component 35 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_36
|
Component 36 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_37
|
Component 37 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_38
|
Component 38 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_39
|
Component 39 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_40
|
Component 40 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_41
|
Component 41 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_42
|
Component 42 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_43
|
Component 43 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_44
|
Component 44 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_45
|
Component 45 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_46
|
Component 46 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_47
|
Component 47 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_48
|
Component 48 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_49
|
Component 49 stock code
|
12
|
String
|
30
|
COMPONENT_CODE_50
|
Component 50 stock code
|
12
|
String
|
30
|
COMPONENT_QTY_1
|
Component 1 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_2
|
Component 2 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_3
|
Component 3 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_4
|
Component 4 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_5
|
Component 5 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_6
|
Component 6 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_7
|
Component 7 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_8
|
Component 8 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_9
|
Component 9 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_10
|
Component 10 quantity
|
10
|
Double
|
8
|
COMPONENT_QTY_11
|
Component 11 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_12
|
Component 12 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_13
|
Component 13 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_2008
|
Component 2008 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_2009
|
Component 2009 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_16
|
Component 16 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_17
|
Component 17 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_18
|
Component 18 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_19
|
Component 19 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_20
|
Component 20 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_21
|
Component 21 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_22
|
Component 22 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_23
|
Component 23 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_24
|
Component 24 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_25
|
Component 25 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_26
|
Component 26 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_27
|
Component 27 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_28
|
Component 28 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_29
|
Component 29 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_30
|
Component 30 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_31
|
Component 31 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_32
|
Component 32 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_33
|
Component 33 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_34
|
Component 34 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_35
|
Component 35 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_36
|
Component 36 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_37
|
Component 37 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_38
|
Component 38 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_39
|
Component 39 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_40
|
Component 40 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_41
|
Component 41 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_42
|
Component 42 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_43
|
Component 43 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_44
|
Component 44 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_45
|
Component 45 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_46
|
Component 46 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_47
|
Component 47 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_48
|
Component 48 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_49
|
Component 49 quantity
|
12
|
Double
|
8
|
COMPONENT_QTY_50
|
Component 50 quantity
|
12
|
Double
|
8
|
QTY_SOLD_BF
|
Brought forward quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH1
|
Month 1 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH2
|
Month 2 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH3
|
Month 3 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH4
|
Month 4 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH5
|
Month 5 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH6
|
Month 6 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH7
|
Month 7 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH8
|
Month 8 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH9
|
Month 9 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH10
|
Month 10 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH11
|
Month 11 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_MTH12
|
Month 12 quantity sold
|
10
|
Double
|
8
|
QTY_SOLD_FUTURE
|
Future quantity sold
|
10
|
Double
|
8
|
SALES_BF
|
Brought forward sales
|
10
|
Double
|
8
|
SALES_MTH1
|
Month 1 sales
|
10
|
Double
|
8
|
SALES_MTH2
|
Month 2 sales
|
10
|
Double
|
8
|
SALES_MTH3
|
Month 3 sales
|
10
|
Double
|
8
|
SALES_MTH4
|
Month 4 sales
|
10
|
Double
|
8
|
SALES_MTH5
|
Month 5 sales
|
10
|
Double
|
8
|
SALES_MTH6
|
Month 6 sales
|
10
|
Double
|
8
|
SALES_MTH7
|
Month 7 sales
|
10
|
Double
|
8
|
SALES_MTH8
|
Month 8 sales
|
10
|
Double
|
8
|
SALES_MTH9
|
Month 9 sales
|
10
|
Double
|
8
|
SALES_MTH10
|
Month 10 sales
|
10
|
Double
|
8
|
SALES_MTH11
|
Month 11 sales
|
10
|
Double
|
8
|
SALES_MTH12
|
Month 12 sales
|
10
|
Double
|
8
|
SALES_FUTURE
|
Future sales
|
10
|
Double
|
8
|
COST_BF
|
Brought forward costs
|
10
|
Double
|
8
|
COST_MTH1
|
Month 1 costs
|
10
|
Double
|
8
|
COST_MTH2
|
Month 2 costs
|
10
|
Double
|
8
|
COST_MTH3
|
Month 3 costs
|
10
|
Double
|
8
|
COST_MTH4
|
Month 4 costs
|
10
|
Double
|
8
|
COST_MTH5
|
Month 5 costs
|
10
|
Double
|
8
|
COST_MTH6
|
Month 6 costs
|
10
|
Double
|
8
|
COST_MTH7
|
Month 7 costs
|
10
|
Double
|
8
|
COST_MTH8
|
Month 8 costs
|
10
|
Double
|
8
|
COST_MTH9
|
Month 9 costs
|
10
|
Double
|
8
|
COST_MTH10
|
Month 10 costs
|
10
|
Double
|
8
|
COST_MTH11
|
Month 11 costs
|
10
|
Double
|
8
|
COST_MTH12
|
Month 12 costs
|
10
|
Double
|
8
|
COST_FUTURE
|
Future costs
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_BF
|
Brought forward budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH1
|
Month 1 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH2
|
Month 2 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH3
|
Month 3 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH4
|
Month 4 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH5
|
Month 5 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH6
|
Month 6 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH7
|
Month 7 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH8
|
Month 8 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH9
|
Month 9 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH10
|
Month 10 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH11
|
Month 11 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_MTH12
|
Month 12 budget quantity sold
|
10
|
Double
|
8
|
BUDGET_QTY_SOLD_FUTURE
|
Future budget quantity sold
|
10
|
Double
|
8
|
BUDGET_SALES_BF
|
Brought forward budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH1
|
Month 1 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH2
|
Month 2 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH3
|
Month 3 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH4
|
Month 4 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH5
|
Month 5 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH6
|
Month 6 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH7
|
Month 7 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH8
|
Month 8 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH9
|
Month 9 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH10
|
Month 10 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH11
|
Month 11 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_MTH12
|
Month 12 budget sales
|
10
|
Double
|
8
|
BUDGET_SALES_FUTURE
|
Future budget sales
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_BF
|
Prior year brought forward quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH1
|
Prior year month 1 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH2
|
Prior year month 2 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH3
|
Prior year month 3 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH4
|
Prior year month 4 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH5
|
Prior year month 5 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH6
|
Prior year month 6 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH7
|
Prior year month 7 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH8
|
Prior year month 8 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH9
|
Prior year month 9 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH10
|
Prior year month 10 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH11
|
Prior year month 11 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_MTH12
|
Prior year month 12 quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_QTY_SOLD_FUTURE
|
Prior year future quantity sold
|
10
|
Double
|
8
|
PRIOR_YR_SALES_BF
|
Prior year brought forward sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH1
|
Prior year month 1 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH2
|
Prior year month 2 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH3
|
Prior year month 3 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH4
|
Prior year month 4 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH5
|
Prior year month 5 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH6
|
Prior year month 6 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH7
|
Prior year month 7 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH8
|
Prior year month 8 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH9
|
Prior year month 9 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH10
|
Prior year month 10 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH11
|
Prior year month 11 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_MTH12
|
Prior year month 12 sales
|
10
|
Double
|
8
|
PRIOR_YR_SALES_FUTURE
|
Prior year future sales
|
10
|
Double
|
8
|
PRIOR_YR_COST_BF
|
Prior year brought forward costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH1
|
Prior year month 1 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH2
|
Prior year month 2 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH3
|
Prior year month 3 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH4
|
Prior year month 4 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH5
|
Prior year month 5 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH6
|
Prior year month 6 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH7
|
Prior year month 7 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH8
|
Prior year month 8 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH9
|
Prior year month 9 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH10
|
Prior year month 10 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH11
|
Prior year month 11 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_MTH12
|
Prior year month 12 costs
|
10
|
Double
|
8
|
PRIOR_YR_COST_FUTURE
|
Prior year future costs
|
10
|
Double
|
8
|
DISC_A_LEVEL_1_QTY
|
Discount Table A, Break Level 1, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_2_QTY
|
Discount Table A, Break Level 2, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_3_QTY
|
Discount Table A, Break Level 3, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_4_QTY
|
Discount Table A, Break Level 4, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_5_QTY
|
Discount Table A, Break Level 5, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_6_QTY
|
Discount Table A, Break Level 6, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_7_QTY
|
Discount Table A, Break Level 7, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_8_QTY
|
Discount Table A, Break Level 8, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_9_QTY
|
Discount Table A, Break Level 9, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_10_QTY
|
Discount Table A, Break Level 10, Quantity
|
10
|
Double
|
8
|
DISC_A_LEVEL_1_RATE
|
Discount Table A, Break Level 1, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_2_RATE
|
Discount Table A, Break Level 2, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_3_RATE
|
Discount Table A, Break Level 3, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_4_RATE
|
Discount Table A, Break Level 4, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_5_RATE
|
Discount Table A, Break Level 5, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_6_RATE
|
Discount Table A, Break Level 6, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_7_RATE
|
Discount Table A, Break Level 7, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_8_RATE
|
Discount Table A, Break Level 8, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_9_RATE
|
Discount Table A, Break Level 9, Rate
|
10
|
Double
|
8
|
DISC_A_LEVEL_10_RATE
|
Discount Table A, Break Level 10, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_1_QTY
|
Discount Table B, Break Level 1, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_2_QTY
|
Discount Table B, Break Level 2, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_3_QTY
|
Discount Table B, Break Level 3, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_4_QTY
|
Discount Table B, Break Level 4, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_5_QTY
|
Discount Table B, Break Level 5, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_6_QTY
|
Discount Table B, Break Level 6, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_7_QTY
|
Discount Table B, Break Level 7, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_8_QTY
|
Discount Table B, Break Level 8, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_9_QTY
|
Discount Table B, Break Level 9, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_10_QTY
|
Discount Table B, Break Level 10, Quantity
|
10
|
Double
|
8
|
DISC_B_LEVEL_1_RATE
|
Discount Table B, Break Level 1, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_2_RATE
|
Discount Table B, Break Level 2, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_3_RATE
|
Discount Table B, Break Level 3, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_4_RATE
|
Discount Table B, Break Level 4, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_5_RATE
|
Discount Table B, Break Level 5, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_6_RATE
|
Discount Table B, Break Level 6, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_7_RATE
|
Discount Table B, Break Level 7, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_8_RATE
|
Discount Table B, Break Level 8, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_9_RATE
|
Discount Table B, Break Level 9, Rate
|
10
|
Double
|
8
|
DISC_B_LEVEL_10_RATE
|
Discount Table B, Break Level 10, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_1_QTY
|
Discount Table C, Break Level 1, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_2_QTY
|
Discount Table C, Break Level 2, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_3_QTY
|
Discount Table C, Break Level 3, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_4_QTY
|
Discount Table C, Break Level 4, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_5_QTY
|
Discount Table C, Break Level 5, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_6_QTY
|
Discount Table C, Break Level 6, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_7_QTY
|
Discount Table C, Break Level 7, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_8_QTY
|
Discount Table C, Break Level 8, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_9_QTY
|
Discount Table C, Break Level 9, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_10_QTY
|
Discount Table C, Break Level 10, Quantity
|
10
|
Double
|
8
|
DISC_C_LEVEL_1_RATE
|
Discount Table C, Break Level 1, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_2_RATE
|
Discount Table C, Break Level 2, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_3_RATE
|
Discount Table C, Break Level 3, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_4_RATE
|
Discount Table C, Break Level 4, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_5_RATE
|
Discount Table C, Break Level 5, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_6_RATE
|
Discount Table C, Break Level 6, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_7_RATE
|
Discount Table C, Break Level 7, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_8_RATE
|
Discount Table C, Break Level 8, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_9_RATE
|
Discount Table C, Break Level 9, Rate
|
10
|
Double
|
8
|
DISC_C_LEVEL_10_RATE
|
Discount Table C, Break Level 10, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_1_QTY
|
Discount Table D, Break Level 1, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_2_QTY
|
Discount Table D, Break Level 2, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_3_QTY
|
Discount Table D, Break Level 3, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_4_QTY
|
Discount Table D, Break Level 4, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_5_QTY
|
Discount Table D, Break Level 5, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_6_QTY
|
Discount Table D, Break Level 6, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_7_QTY
|
Discount Table D, Break Level 7, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_8_QTY
|
Discount Table D, Break Level 8, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_9_QTY
|
Discount Table D, Break Level 9, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_10_QTY
|
Discount Table D, Break Level 10, Quantity
|
10
|
Double
|
8
|
DISC_D_LEVEL_1_RATE
|
Discount Table D, Break Level 1, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_2_RATE
|
Discount Table D, Break Level 2, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_3_RATE
|
Discount Table D, Break Level 3, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_4_RATE
|
Discount Table D, Break Level 4, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_5_RATE
|
Discount Table D, Break Level 5, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_6_RATE
|
Discount Table D, Break Level 6, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_7_RATE
|
Discount Table D, Break Level 7, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_8_RATE
|
Discount Table D, Break Level 8, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_9_RATE
|
Discount Table D, Break Level 9, Rate
|
10
|
Double
|
8
|
DISC_D_LEVEL_10_RATE
|
Discount Table D, Break Level 10, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_1_QTY
|
Discount Table E, Break Level 1, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_2_QTY
|
Discount Table E, Break Level 2, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_3_QTY
|
Discount Table E, Break Level 3, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_4_QTY
|
Discount Table E, Break Level 4, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_5_QTY
|
Discount Table E, Break Level 5, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_6_QTY
|
Discount Table E, Break Level 6, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_7_QTY
|
Discount Table E, Break Level 7, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_8_QTY
|
Discount Table E, Break Level 8, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_9_QTY
|
Discount Table E, Break Level 9, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_10_QTY
|
Discount Table E, Break Level 10, Quantity
|
10
|
Double
|
8
|
DISC_E_LEVEL_1_RATE
|
Discount Table E, Break Level 1, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_2_RATE
|
Discount Table E, Break Level 2, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_3_RATE
|
Discount Table E, Break Level 3, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_4_RATE
|
Discount Table E, Break Level 4, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_5_RATE
|
Discount Table E, Break Level 5, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_6_RATE
|
Discount Table E, Break Level 6, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_7_RATE
|
Discount Table E, Break Level 7, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_8_RATE
|
Discount Table E, Break Level 8, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_9_RATE
|
Discount Table E, Break Level 9, Rate
|
10
|
Double
|
8
|
DISC_E_LEVEL_10_RATE
|
Discount Table E, Break Level 10, Rate
|
10
|
Double
|
8
|
PURCHASE_NOMINAL_CODE
|
Purchase nominal code
|
2009
|
String
|
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
|