ACCPAC Item Data Fields

 

This is a work in progress. I'm not 100% on wether these are accurate, but the essential fields are easily identifiable. Where it gets into quantity price breaks and stuff like that is where it gets sketchy. There are actually fields that are stored in CSV themselves.

accpac_products Table

Field Type Null Default Comments
item_no varchar(10) No

desc

varchar(50) No Description

cat_code

varchar(20) Yes NULL Category Code

report_group

varchar(4) Yes NULL

account_set

tinyint(1) Yes 1 1 = Inventory, 2 = Non-Stock Item

alt_item

varchar(10) Yes NULL Alternate Item Number

stock_item

tinyint(1) Yes 1 1 = Yes

stock_unit

varchar(10) Yes NULL EA = Each etc.

alt_unit1

varchar(10) Yes NULL Alternate Stocking Unit 1

alt_unit2

varchar(10) Yes NULL Alternate Stocking Unit 2

alt_unit3

varchar(10) Yes NULL Alternate Stocking Unit 3

alt_unit4

varchar(10) Yes NULL Alternate Stocking Unit 4

conversion_factor1

float Yes NULL Alternate Stocking Unit Conversion Factor 1

conversion_factor2

float Yes NULL Alternate Stocking Unit Conversion Factor 2

conversion_factor3

float Yes NULL Alternate Stocking Unit Conversion Factor 3

conversion_factor4

float Yes NULL Alternate Stocking Unit Conversion Factor 4

pricing_unit

varchar(10) Yes NULL EA etc.

costing_unit

varchar(10) Yes NULL EA etc.

base_price

float Yes NULL Base Price

std_cost

float Yes NULL Standard Cost

most_recent_cost

float Yes NULL Most Recent Cost

ex_cost

float Yes NULL Ex Tax Cost

in_cost

float Yes NULL Tax Inclusive Cost

markup_factor

float Yes NULL Markup Factor

serial_nos

tinyint(4) Yes NULL How Many Serial Numbers

picking_seq

varchar(10) Yes NULL Picking Sequence

weight

float Yes NULL Weight (Kg)

price_base

tinyint(1) Yes NULL 1 = Discount Based, 2 = Markup Based

change_type

tinyint(1) Yes NULL 1 = Percentage, 2 = Amount

determined_by

tinyint(1) Yes NULL additional_info1

markup_break_a

float Yes NULL

markup_break_b

float Yes NULL

markup_break_c

float Yes NULL

markup_break_d

float Yes NULL

markup_break_e

float Yes NULL

markup_amount_a

float Yes NULL

markup_amount_b

float Yes NULL

markup_amount_c

float Yes NULL

markup_amount_d

float Yes NULL

markup_amount_e

float Yes NULL

tax_status

tinyint(1) No Verify This!

sale_start

varchar(10) Yes NULL not sure of format yet

sale_end

varchar(10) Yes NULL not sure of format yet

sale_price

float Yes NULL Sale Price

pri_vendor_number

varchar(10) Yes NULL Vendors Code?

pri_vendor_contact

varchar(50) Yes NULL Contact Person

pri_vendor_item_no

varchar(10) Yes NULL Vendor Part Number

sec_vendor_number

varchar(10) Yes NULL

sec_vendor_contact

varchar(50) Yes NULL

sec_vendor_item_no

varchar(10) Yes NULL

additional_info1

varchar(100) Yes NULL

additional_info2

varchar(100) Yes NULL

additional_info3

varchar(100) Yes NULL

additional_info4

varchar(100) Yes NULL