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