03333 445950
03333 calls are same cost
 |  |  |
Making I.T. Happen
Accounting and Information Technology Assistance and Support
Sage Custom Integration - Native Tables
Native Table -
STOCKDATA Name,Description,FieldType,Length,FieldState,DecimalPlaces ASSEMBLY_LEVEL,"Assembly level",5,2,0,0 AVERAGE_COST_PRICE,"Average cost price",8,8,0,101 BUDGET_QTY_SOLD_BF,"Brought forward budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_FUTURE,"Future budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH1,"Month 1 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH10,"Month 10 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH11,"Month 11 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH12,"Month 12 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH2,"Month 2 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH3,"Month 3 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH4,"Month 4 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH5,"Month 5 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH6,"Month 6 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH7,"Month 7 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH8,"Month 8 budget quantity sold",8,8,0,102 BUDGET_QTY_SOLD_MTH9,"Month 9 budget quantity sold",8,8,0,102 BUDGET_SALES_BF,"Brought forward budget sales",8,8,0,2 BUDGET_SALES_FUTURE,"Future budget sales",8,8,0,2 BUDGET_SALES_MTH1,"Month 1 budget sales",8,8,0,2 BUDGET_SALES_MTH10,"Month 10 budget sales",8,8,0,2 BUDGET_SALES_MTH11,"Month 11 budget sales",8,8,0,2 BUDGET_SALES_MTH12,"Month 12 budget sales",8,8,0,2 BUDGET_SALES_MTH2,"Month 2 budget sales",8,8,0,2 BUDGET_SALES_MTH3,"Month 3 budget sales",8,8,0,2 BUDGET_SALES_MTH4,"Month 4 budget sales",8,8,0,2 BUDGET_SALES_MTH5,"Month 5 budget sales",8,8,0,2 BUDGET_SALES_MTH6,"Month 6 budget sales",8,8,0,2 BUDGET_SALES_MTH7,"Month 7 budget sales",8,8,0,2 BUDGET_SALES_MTH8,"Month 8 budget sales",8,8,0,2 BUDGET_SALES_MTH9,"Month 9 budget sales",8,8,0,2 COMMODITY_CODE,"Commodity code description",12,30,0,0 COMPONENT_CODE_1,"Component 1 stock code",12,30,0,0 COMPONENT_CODE_10,"Component 10 stock code",12,30,0,0 COMPONENT_Code_11,"Component 11 stock code",12,30,0,0 COMPONENT_Code_12,"Component 12 stock code",12,30,0,0 COMPONENT_Code_13,"Component 13 stock code",12,30,0,0 COMPONENT_Code_14,"Component 14 stock code",12,30,0,0 COMPONENT_Code_15,"Component 15 stock code",12,30,0,0 COMPONENT_Code_16,"Component 16 stock code",12,30,0,0 COMPONENT_Code_17,"Component 17 stock code",12,30,0,0 COMPONENT_Code_18,"Component 18 stock code",12,30,0,0 COMPONENT_Code_19,"Component 19 stock code",12,30,0,0 COMPONENT_CODE_2,"Component 2 stock code",12,30,0,0 COMPONENT_CODE_20,"Component 20 stock code",12,30,0,0 COMPONENT_Code_21,"Component 21 stock code",12,30,0,0 COMPONENT_Code_22,"Component 22 stock code",12,30,0,0 COMPONENT_Code_23,"Component 23 stock code",12,30,0,0 COMPONENT_Code_24,"Component 24 stock code",12,30,0,0 COMPONENT_Code_25,"Component 25 stock code",12,30,0,0 COMPONENT_Code_26,"Component 26 stock code",12,30,0,0 COMPONENT_Code_27,"Component 27 stock code",12,30,0,0 COMPONENT_Code_28,"Component 28 stock code",12,30,0,0 COMPONENT_Code_29,"Component 29 stock code",12,30,0,0 COMPONENT_CODE_3,"Component 3 stock code",12,30,0,0 COMPONENT_CODE_30,"Component 30 stock code",12,30,0,0 COMPONENT_Code_31,"Component 31 stock code",12,30,0,0 COMPONENT_Code_32,"Component 32 stock code",12,30,0,0 COMPONENT_Code_33,"Component 33 stock code",12,30,0,0 COMPONENT_Code_34,"Component 34 stock code",12,30,0,0 COMPONENT_Code_35,"Component 35 stock code",12,30,0,0 COMPONENT_Code_36,"Component 36 stock code",12,30,0,0 COMPONENT_Code_37,"Component 37 stock code",12,30,0,0 COMPONENT_Code_38,"Component 38 stock code",12,30,0,0 COMPONENT_Code_39,"Component 39 stock code",12,30,0,0 COMPONENT_CODE_4,"Component 4 stock code",12,30,0,0 COMPONENT_CODE_40,"Component 40 stock code",12,30,0,0 COMPONENT_Code_41,"Component 41 stock code",12,30,0,0 COMPONENT_Code_42,"Component 42 stock code",12,30,0,0 COMPONENT_Code_43,"Component 43 stock code",12,30,0,0 COMPONENT_Code_44,"Component 44 stock code",12,30,0,0 COMPONENT_Code_45,"Component 45 stock code",12,30,0,0 COMPONENT_Code_46,"Component 46 stock code",12,30,0,0 COMPONENT_Code_47,"Component 47 stock code",12,30,0,0 COMPONENT_Code_48,"Component 48 stock code",12,30,0,0 COMPONENT_Code_49,"Component 49 stock code",12,30,0,0 COMPONENT_CODE_5,"Component 5 stock code",12,30,0,0 COMPONENT_Code_50,"Component 50 stock code",12,30,0,0 COMPONENT_CODE_6,"Component 6 stock code",12,30,0,0 COMPONENT_CODE_7,"Component 7 stock code",12,30,0,0 COMPONENT_CODE_8,"Component 8 stock code",12,30,0,0 COMPONENT_CODE_9,"Component 9 stock code",12,30,0,0 COMPONENT_QTY_1,"Component 1 quantity",8,8,0,102 COMPONENT_QTY_10,"Component 10 quantity",8,8,0,102 COMPONENT_QTY_11,"Component 11 quantity",8,8,0,102 COMPONENT_QTY_12,"Component 12 quantity",8,8,0,102 COMPONENT_QTY_13,"Component 13 quantity",8,8,0,102 COMPONENT_QTY_14,"Component 14 quantity",8,8,0,102 COMPONENT_QTY_15,"Component 15 quantity",8,8,0,102 COMPONENT_QTY_16,"Component 16 quantity",8,8,0,102 COMPONENT_QTY_17,"Component 17 quantity",8,8,0,102 COMPONENT_QTY_18,"Component 18 quantity",8,8,0,102 COMPONENT_QTY_19,"Component 19 quantity",8,8,0,102 COMPONENT_QTY_2,"Component 2 quantity",8,8,0,102 COMPONENT_QTY_20,"Component 20 quantity",8,8,0,102 COMPONENT_QTY_21,"Component 21 quantity",8,8,0,102 COMPONENT_QTY_22,"Component 22 quantity",8,8,0,102 COMPONENT_QTY_23,"Component 23 quantity",8,8,0,102 COMPONENT_QTY_24,"Component 24 quantity",8,8,0,102 COMPONENT_QTY_25,"Component 25 quantity",8,8,0,102 COMPONENT_QTY_26,"Component 26 quantity",8,8,0,102 COMPONENT_QTY_27,"Component 27 quantity",8,8,0,102 COMPONENT_QTY_28,"Component 28 quantity",8,8,0,102 COMPONENT_QTY_29,"Component 29 quantity",8,8,0,102 COMPONENT_QTY_3,"Component 3 quantity",8,8,0,102 COMPONENT_QTY_30,"Component 30 quantity",8,8,0,102 COMPONENT_QTY_31,"Component 31 quantity",8,8,0,102 COMPONENT_QTY_32,"Component 32 quantity",8,8,0,102 COMPONENT_QTY_33,"Component 33 quantity",8,8,0,102 COMPONENT_QTY_34,"Component 34 quantity",8,8,0,102 COMPONENT_QTY_35,"Component 35 quantity",8,8,0,102 COMPONENT_QTY_36,"Component 36 quantity",8,8,0,102 COMPONENT_QTY_37,"Component 37 quantity",8,8,0,102 COMPONENT_QTY_38,"Component 38 quantity",8,8,0,102 COMPONENT_QTY_39,"Component 39 quantity",8,8,0,102 COMPONENT_QTY_4,"Component 4 quantity",8,8,0,102 COMPONENT_QTY_40,"Component 40 quantity",8,8,0,102 COMPONENT_QTY_41,"Component 41 quantity",8,8,0,102 COMPONENT_QTY_42,"Component 42 quantity",8,8,0,102 COMPONENT_QTY_43,"Component 43 quantity",8,8,0,102 COMPONENT_QTY_44,"Component 44 quantity",8,8,0,102 COMPONENT_QTY_45,"Component 45 quantity",8,8,0,102 COMPONENT_QTY_46,"Component 46 quantity",8,8,0,102 COMPONENT_QTY_47,"Component 47 quantity",8,8,0,102 COMPONENT_QTY_48,"Component 48 quantity",8,8,0,102 COMPONENT_QTY_49,"Component 49 quantity",8,8,0,102 COMPONENT_QTY_5,"Component 5 quantity",8,8,0,102 COMPONENT_QTY_50,"Component 50 quantity",8,8,0,102 COMPONENT_QTY_6,"Component 6 quantity",8,8,0,102 COMPONENT_QTY_7,"Component 7 quantity",8,8,0,102 COMPONENT_QTY_8,"Component 8 quantity",8,8,0,102 COMPONENT_QTY_9,"Component 9 quantity",8,8,0,102 COST_BF,"Brought forward costs",8,8,0,2 COST_FUTURE,"Future costs",8,8,0,2 COST_MTH1,"Month 1 costs",8,8,0,2 COST_MTH10,"Month 10 costs",8,8,0,2 COST_MTH11,"Month 11 costs",8,8,0,2 COST_MTH12,"Month 12 costs",8,8,0,2 COST_MTH2,"Month 2 costs",8,8,0,2 COST_MTH3,"Month 3 costs",8,8,0,2 COST_MTH4,"Month 4 costs",8,8,0,2 COST_MTH5,"Month 5 costs",8,8,0,2 COST_MTH6,"Month 6 costs",8,8,0,2 COST_MTH7,"Month 7 costs",8,8,0,2 COST_MTH8,"Month 8 costs",8,8,0,2 COST_MTH9,"Month 9 costs",8,8,0,2 COUNTRY_CODE_OF_ORIGIN,"Country of Origin (IE Intrastat only)",12,2,0,0 CUSTOM_1,"Custom Field 1",12,60,0,0 CUSTOM_2,"Custom Field 2",12,60,0,0 CUSTOM_3,"Custom Field 3",12,60,0,0 DELETED_FLAG,"Is Deleted",5,2,0,0 DEPT_NUMBER,"Department number",5,2,0,0 DESCRIPTION,"Description",12,60,0,0 DISC_A_LEVEL_10_QTY,"Discount Table A, Break Level 10, Quantity",8,8,0,102 DISC_A_LEVEL_10_RATE,"Discount Table A, Break Level 10, Rate",8,8,0,2 DISC_A_LEVEL_1_QTY,"Discount Table A, Break Level 1, Quantity",8,8,0,102 DISC_A_LEVEL_1_RATE,"Discount Table A, Break Level 1, Rate",8,8,0,2 DISC_A_LEVEL_2_QTY,"Discount Table A, Break Level 2, Quantity",8,8,0,102 DISC_A_LEVEL_2_RATE,"Discount Table A, Break Level 2, Rate",8,8,0,2 DISC_A_LEVEL_3_QTY,"Discount Table A, Break Level 3, Quantity",8,8,0,102 DISC_A_LEVEL_3_RATE,"Discount Table A, Break Level 3, Rate",8,8,0,2 DISC_A_LEVEL_4_QTY,"Discount Table A, Break Level 4, Quantity",8,8,0,102 DISC_A_LEVEL_4_RATE,"Discount Table A, Break Level 4, Rate",8,8,0,2 DISC_A_LEVEL_5_QTY,"Discount Table A, Break Level 5, Quantity",8,8,0,102 DISC_A_LEVEL_5_RATE,"Discount Table A, Break Level 5, Rate",8,8,0,2 DISC_A_LEVEL_6_QTY,"Discount Table A, Break Level 6, Quantity",8,8,0,102 DISC_A_LEVEL_6_RATE,"Discount Table A, Break Level 6, Rate",8,8,0,2 DISC_A_LEVEL_7_QTY,"Discount Table A, Break Level 7, Quantity",8,8,0,102 DISC_A_LEVEL_7_RATE,"Discount Table A, Break Level 7, Rate",8,8,0,2 DISC_A_LEVEL_8_QTY,"Discount Table A, Break Level 8, Quantity",8,8,0,102 DISC_A_LEVEL_8_RATE,"Discount Table A, Break Level 8, Rate",8,8,0,2 DISC_A_LEVEL_9_QTY,"Discount Table A, Break Level 9, Quantity",8,8,0,102 DISC_A_LEVEL_9_RATE,"Discount Table A, Break Level 9, Rate",8,8,0,2 DISC_B_LEVEL_10_QTY,"Discount Table B, Break Level 10, Quantity",8,8,0,102 DISC_B_LEVEL_10_RATE,"Discount Table B, Break Level 10, Rate",8,8,0,2 DISC_B_LEVEL_1_QTY,"Discount Table B, Break Level 1, Quantity",8,8,0,102 DISC_B_LEVEL_1_RATE,"Discount Table B, Break Level 1, Rate",8,8,0,2 DISC_B_LEVEL_2_QTY,"Discount Table B, Break Level 2, Quantity",8,8,0,102 DISC_B_LEVEL_2_RATE,"Discount Table B, Break Level 2, Rate",8,8,0,2 DISC_B_LEVEL_3_QTY,"Discount Table B, Break Level 3, Quantity",8,8,0,102 DISC_B_LEVEL_3_RATE,"Discount Table B, Break Level 3, Rate",8,8,0,2 DISC_B_LEVEL_4_QTY,"Discount Table B, Break Level 4, Quantity",8,8,0,102 DISC_B_LEVEL_4_RATE,"Discount Table B, Break Level 4, Rate",8,8,0,2 DISC_B_LEVEL_5_QTY,"Discount Table B, Break Level 5, Quantity",8,8,0,102 DISC_B_LEVEL_5_RATE,"Discount Table B, Break Level 5, Rate",8,8,0,2 DISC_B_LEVEL_6_QTY,"Discount Table B, Break Level 6, Quantity",8,8,0,102 DISC_B_LEVEL_6_RATE,"Discount Table B, Break Level 6, Rate",8,8,0,2 DISC_B_LEVEL_7_QTY,"Discount Table B, Break Level 7, Quantity",8,8,0,102 DISC_B_LEVEL_7_RATE,"Discount Table B, Break Level 7, Rate",8,8,0,2 DISC_B_LEVEL_8_QTY,"Discount Table B, Break Level 8, Quantity",8,8,0,102 DISC_B_LEVEL_8_RATE,"Discount Table B, Break Level 8, Rate",8,8,0,2 DISC_B_LEVEL_9_QTY,"Discount Table B, Break Level 9, Quantity",8,8,0,102 DISC_B_LEVEL_9_RATE,"Discount Table B, Break Level 9, Rate",8,8,0,2 DISC_C_LEVEL_10_QTY,"Discount Table C, Break Level 10, Quantity",8,8,0,102 DISC_C_LEVEL_10_RATE,"Discount Table C, Break Level 10, Rate",8,8,0,2 DISC_C_LEVEL_1_QTY,"Discount Table C, Break Level 1, Quantity",8,8,0,102 DISC_C_LEVEL_1_RATE,"Discount Table C, Break Level 1, Rate",8,8,0,2 DISC_C_LEVEL_2_QTY,"Discount Table C, Break Level 2, Quantity",8,8,0,102 DISC_C_LEVEL_2_RATE,"Discount Table C, Break Level 2, Rate",8,8,0,2 DISC_C_LEVEL_3_QTY,"Discount Table C, Break Level 3, Quantity",8,8,0,102 DISC_C_LEVEL_3_RATE,"Discount Table C, Break Level 3, Rate",8,8,0,2 DISC_C_LEVEL_4_QTY,"Discount Table C, Break Level 4, Quantity",8,8,0,102 DISC_C_LEVEL_4_RATE,"Discount Table C, Break Level 4, Rate",8,8,0,2 DISC_C_LEVEL_5_QTY,"Discount Table C, Break Level 5, Quantity",8,8,0,102 DISC_C_LEVEL_5_RATE,"Discount Table C, Break Level 5, Rate",8,8,0,2 DISC_C_LEVEL_6_QTY,"Discount Table C, Break Level 6, Quantity",8,8,0,102 DISC_C_LEVEL_6_RATE,"Discount Table C, Break Level 6, Rate",8,8,0,2 DISC_C_LEVEL_7_QTY,"Discount Table C, Break Level 7, Quantity",8,8,0,102 DISC_C_LEVEL_7_RATE,"Discount Table C, Break Level 7, Rate",8,8,0,2 DISC_C_LEVEL_8_QTY,"Discount Table C, Break Level 8, Quantity",8,8,0,102 DISC_C_LEVEL_8_RATE,"Discount Table C, Break Level 8, Rate",8,8,0,2 DISC_C_LEVEL_9_QTY,"Discount Table C, Break Level 9, Quantity",8,8,0,102 DISC_C_LEVEL_9_RATE,"Discount Table C, Break Level 9, Rate",8,8,0,2 DISC_D_LEVEL_10_QTY,"Discount Table D, Break Level 10, Quantity",8,8,0,102 DISC_D_LEVEL_10_RATE,"Discount Table D, Break Level 10, Rate",8,8,0,2 DISC_D_LEVEL_1_QTY,"Discount Table D, Break Level 1, Quantity",8,8,0,102 DISC_D_LEVEL_1_RATE,"Discount Table D, Break Level 1, Rate",8,8,0,2 DISC_D_LEVEL_2_QTY,"Discount Table D, Break Level 2, Quantity",8,8,0,102 DISC_D_LEVEL_2_RATE,"Discount Table D, Break Level 2, Rate",8,8,0,2 DISC_D_LEVEL_3_QTY,"Discount Table D, Break Level 3, Quantity",8,8,0,102 DISC_D_LEVEL_3_RATE,"Discount Table D, Break Level 3, Rate",8,8,0,2 DISC_D_LEVEL_4_QTY,"Discount Table D, Break Level 4, Quantity",8,8,0,102 DISC_D_LEVEL_4_RATE,"Discount Table D, Break Level 4, Rate",8,8,0,2 DISC_D_LEVEL_5_QTY,"Discount Table D, Break Level 5, Quantity",8,8,0,102 DISC_D_LEVEL_5_RATE,"Discount Table D, Break Level 5, Rate",8,8,0,2 DISC_D_LEVEL_6_QTY,"Discount Table D, Break Level 6, Quantity",8,8,0,102 DISC_D_LEVEL_6_RATE,"Discount Table D, Break Level 6, Rate",8,8,0,2 DISC_D_LEVEL_7_QTY,"Discount Table D, Break Level 7, Quantity",8,8,0,102 DISC_D_LEVEL_7_RATE,"Discount Table D, Break Level 7, Rate",8,8,0,2 DISC_D_LEVEL_8_QTY,"Discount Table D, Break Level 8, Quantity",8,8,0,102 DISC_D_LEVEL_8_RATE,"Discount Table D, Break Level 8, Rate",8,8,0,2 DISC_D_LEVEL_9_QTY,"Discount Table D, Break Level 9, Quantity",8,8,0,102 DISC_D_LEVEL_9_RATE,"Discount Table D, Break Level 9, Rate",8,8,0,2 DISC_E_LEVEL_10_QTY,"Discount Table E, Break Level 10, Quantity",8,8,0,102 DISC_E_LEVEL_10_RATE,"Discount Table E, Break Level 10, Rate",8,8,0,2 DISC_E_LEVEL_1_QTY,"Discount Table E, Break Level 1, Quantity",8,8,0,102 DISC_E_LEVEL_1_RATE,"Discount Table E, Break Level 1, Rate",8,8,0,2 DISC_E_LEVEL_2_QTY,"Discount Table E, Break Level 2, Quantity",8,8,0,102 DISC_E_LEVEL_2_RATE,"Discount Table E, Break Level 2, Rate",8,8,0,2 DISC_E_LEVEL_3_QTY,"Discount Table E, Break Level 3, Quantity",8,8,0,102 DISC_E_LEVEL_3_RATE,"Discount Table E, Break Level 3, Rate",8,8,0,2 DISC_E_LEVEL_4_QTY,"Discount Table E, Break Level 4, Quantity",8,8,0,102 DISC_E_LEVEL_4_RATE,"Discount Table E, Break Level 4, Rate",8,8,0,2 DISC_E_LEVEL_5_QTY,"Discount Table E, Break Level 5, Quantity",8,8,0,102 DISC_E_LEVEL_5_RATE,"Discount Table E, Break Level 5, Rate",8,8,0,2 DISC_E_LEVEL_6_QTY,"Discount Table E, Break Level 6, Quantity",8,8,0,102 DISC_E_LEVEL_6_RATE,"Discount Table E, Break Level 6, Rate",8,8,0,2 DISC_E_LEVEL_7_QTY,"Discount Table E, Break Level 7, Quantity",8,8,0,102 DISC_E_LEVEL_7_RATE,"Discount Table E, Break Level 7, Rate",8,8,0,2 DISC_E_LEVEL_8_QTY,"Discount Table E, Break Level 8, Quantity",8,8,0,102 DISC_E_LEVEL_8_RATE,"Discount Table E, Break Level 8, Rate",8,8,0,2 DISC_E_LEVEL_9_QTY,"Discount Table E, Break Level 9, Quantity",8,8,0,102 DISC_E_LEVEL_9_RATE,"Discount Table E, Break Level 9, Rate",8,8,0,2 EXTERNAL_USAGE,"Number of External Usages",4,4,0,0 FIRST_TRAN,"",4,4,0,0 IGNORE_STK_LVL_FLAG,"Ignore stock level flag",-6,1,0,0 INACTIVE_FLAG,"Inactive Flag - Yes/No",-6,1,0,0 INTRASTAT_COMMODITY_CODE,"Intrastat Commodity code",12,8,0,0 INTRASTAT_IMPORT_DUTY_CODE,"Intrastat Import Duty code",12,2,0,0 ITEM_TYPE,"Item Type",-6,1,0,0 LAST_COST_DISCOUNT,"Last Cost Discounted",8,8,0,101 LAST_ORDER_QUANTITY,"Last Order Quantity",8,8,0,101 LAST_PURCHASE_DATE,"Last purchase date",9,2,0,0 LAST_PURCHASE_PRICE,"Last purchase price",8,8,0,101 LAST_SALE_DATE,"Last sale date",9,2,0,0 LAST_TRAN,"",4,4,0,0 LAST_UPDATED,"Date of last update",11,8,0,0 LINK_LEVEL,"Link level",5,2,0,0 LOCATION,"Location",12,16,0,0 NO_OF_TRAN,"",4,4,0,0 NOMINAL_CODE,"Sales Nominal code",12,8,0,0 PRIOR_YR_COST_BF,"Prior year brought forward costs",8,8,0,2 PRIOR_YR_COST_FUTURE,"Prior year future costs",8,8,0,2 PRIOR_YR_COST_MTH1,"Prior year month 1 costs",8,8,0,2 PRIOR_YR_COST_MTH10,"Prior year month 10 costs",8,8,0,2 PRIOR_YR_COST_MTH11,"Prior year month 11 costs",8,8,0,2 PRIOR_YR_COST_MTH12,"Prior year month 12 costs",8,8,0,2 PRIOR_YR_COST_MTH2,"Prior year month 2 costs",8,8,0,2 PRIOR_YR_COST_MTH3,"Prior year month 3 costs",8,8,0,2 PRIOR_YR_COST_MTH4,"Prior year month 4 costs",8,8,0,2 PRIOR_YR_COST_MTH5,"Prior year month 5 costs",8,8,0,2 PRIOR_YR_COST_MTH6,"Prior year month 6 costs",8,8,0,2 PRIOR_YR_COST_MTH7,"Prior year month 7 costs",8,8,0,2 PRIOR_YR_COST_MTH8,"Prior year month 8 costs",8,8,0,2 PRIOR_YR_COST_MTH9,"Prior year month 9 costs",8,8,0,2 PRIOR_YR_QTY_SOLD_BF,"Prior year brought forward quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_FUTURE,"Prior year future quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH1,"Prior year month 1 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH10,"Prior year month 10 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH11,"Prior year month 11 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH12,"Prior year month 12 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH2,"Prior year month 2 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH3,"Prior year month 3 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH4,"Prior year month 4 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH5,"Prior year month 5 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH6,"Prior year month 6 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH7,"Prior year month 7 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH8,"Prior year month 8 quantity sold",8,8,0,102 PRIOR_YR_QTY_SOLD_MTH9,"Prior year month 9 quantity sold",8,8,0,102 PRIOR_YR_SALES_BF,"Prior year brought forward sales",8,8,0,2 PRIOR_YR_SALES_FUTURE,"Prior year future sales",8,8,0,2 PRIOR_YR_SALES_MTH1,"Prior year month 1 sales",8,8,0,2 PRIOR_YR_SALES_MTH10,"Prior year month 10 sales",8,8,0,2 PRIOR_YR_SALES_MTH11,"Prior year month 11 sales",8,8,0,2 PRIOR_YR_SALES_MTH12,"Prior year month 12 sales",8,8,0,2 PRIOR_YR_SALES_MTH2,"Prior year month 2 sales",8,8,0,2 PRIOR_YR_SALES_MTH3,"Prior year month 3 sales",8,8,0,2 PRIOR_YR_SALES_MTH4,"Prior year month 4 sales",8,8,0,2 PRIOR_YR_SALES_MTH5,"Prior year month 5 sales",8,8,0,2 PRIOR_YR_SALES_MTH6,"Prior year month 6 sales",8,8,0,2 PRIOR_YR_SALES_MTH7,"Prior year month 7 sales",8,8,0,2 PRIOR_YR_SALES_MTH8,"Prior year month 8 sales",8,8,0,2 PRIOR_YR_SALES_MTH9,"Prior year month 9 sales",8,8,0,2 PRODUCT_BARCODE,"Barcode",12,60,0,0 PURCHASE_NOMINAL_CODE,"Purchase Nominal code",12,8,0,0 PURCHASE_REF,"Supplier's account reference",12,8,0,0 QTY_ALLOCATED,"Quantity allocated",8,8,0,102 QTY_IN_STOCK,"Quantity in stock",8,8,0,102 QTY_LAST_ORDER,"Last order quantity",8,8,0,102 QTY_LAST_STOCK_TAKE,"Last stock take quantity",8,8,0,102 QTY_ON_ORDER,"Quantity on order",8,8,0,102 QTY_REORDER,"Reorder quantity",8,8,0,102 QTY_REORDER_LEVEL,"Reorder level",8,8,0,102 QTY_SOLD_BF,"Brought forward quantity sold",8,8,0,102 QTY_SOLD_FUTURE,"Future quantity sold",8,8,0,102 QTY_SOLD_MTH1,"Month 1 quantity sold",8,8,0,102 QTY_SOLD_MTH10,"Month 10 quantity sold",8,8,0,102 QTY_SOLD_MTH11,"Month 11 quantity sold",8,8,0,102 QTY_SOLD_MTH12,"Month 12 quantity sold",8,8,0,102 QTY_SOLD_MTH2,"Month 2 quantity sold",8,8,0,102 QTY_SOLD_MTH3,"Month 3 quantity sold",8,8,0,102 QTY_SOLD_MTH4,"Month 4 quantity sold",8,8,0,102 QTY_SOLD_MTH5,"Month 5 quantity sold",8,8,0,102 QTY_SOLD_MTH6,"Month 6 quantity sold",8,8,0,102 QTY_SOLD_MTH7,"Month 7 quantity sold",8,8,0,102 QTY_SOLD_MTH8,"Month 8 quantity sold",8,8,0,102 QTY_SOLD_MTH9,"Month 9 quantity sold",8,8,0,102 RECORD_CREATE_DATE,"Date and time when the record was created",11,8,0,0 RECORD_DELETED,"Flag denoting if the record has been deleted or not.",5,2,0,0 RECORD_MODIFY_DATE,"Date and time when the record was modified",11,8,0,0 SALES_BF,"Brought forward sales",8,8,0,2 SALES_FUTURE,"Future sales",8,8,0,2 SALES_MTH1,"Month 1 sales",8,8,0,2 SALES_MTH10,"Month 10 sales",8,8,0,2 SALES_MTH11,"Month 11 sales",8,8,0,2 SALES_MTH12,"Month 12 sales",8,8,0,2 SALES_MTH2,"Month 2 sales",8,8,0,2 SALES_MTH3,"Month 3 sales",8,8,0,2 SALES_MTH4,"Month 4 sales",8,8,0,2 SALES_MTH5,"Month 5 sales",8,8,0,2 SALES_MTH6,"Month 6 sales",8,8,0,2 SALES_MTH7,"Month 7 sales",8,8,0,2 SALES_MTH8,"Month 8 sales",8,8,0,2 SALES_MTH9,"Month 9 sales",8,8,0,2 SALES_PRICE,"Sale price",8,8,0,101 STOCK_CAT,"Stock category number",5,2,0,0 STOCK_CODE,"Product code",12,30,1,0 STOCK_TAKE_DATE,"Stock take date",9,2,0,0 SUPP_UNIT_QTY,"Supplementary Unit Quantity",8,8,0,0 SUPPLIER_PART_NUMBER,"Supplier's part number",12,16,0,0 TAX_CODE,"Tax code (0 to 99)",5,2,0,0 UNIT_OF_SALE,"Unit of sale",12,8,0,0 UNIT_WEIGHT,"Unit weight",8,8,0,2 WEB_DESCRIPTION,"Web Description",12,255,0,0 WEB_IMAGE,"Web Image Filename",12,60,0,0 WEB_LONGDESCRIPTION,"Web Long Description",12,1023,0,0 WEB_PUBLISH,"Web Publish Flag",5,2,0,0 WEB_SPECIAL_OFFER,"Web Special Offer",5,2,0,0