| psprice_vend_num | catalog_mfr_ucc_num | vend_num (vendinfo table) | The vend_num field is used to create a vendor record if one does not exist. This would be the vend_num field in the vendinfo table if no vendor record exists during convert of the item. |
| psprice_mfr_shortname | catalog_mfr_shortname | prefix used in the item_number field to create the item_number | item_numbers in the system are created in the system with a prefix for the vendor to insure no duplicate item numbers are used. If you prefer not to use the prefix, simply leave this field blank and just the catalog_i2_cat_num field would be used as the item_number when converted. |
| psprice_mfr_fullname | catalog_mfr_fullname | vend_name (vendinfo table) | This field is used for the vendor name if the vendor record is created on convert. |
| psprice_min_order_type | catalog_min_order_type | itemsrc_min_order_qty | If set to Q then itemsrc_min_order_qty=1 else itemsrc_min_order_qty=psprice_min_order_qty |
| psprice_min_order_qty | catalog_min_order_qty | itemsrc_min_order_qty | If psprice_min_order_type set to Q then itemsrc_min_order_qty=1 else itemsrc_min_order_qty=psprice_min_order_qty |
| psprice_i2_cat_num | catalog_i2_cat_num | item_number | If psprice_mfr_shortname is null, then just the catalog_i2_cat_num will be used as the item number. If the catalog_mfr_shortname is not null, then the item_number value will be catalog_mfr_shortname-catalog_i2_cat_num |
| psprice_mfr_cat_num | catalog_mfr_cat_num | itemsrc_vend_item_number | Used as the item_number on the PO to send to the vendor (no prefix). |
| psprice_product_name | catalog_product_name | item_descrip1 | First line of description on the item. |
| psprice_mfr_descrip | catalog_mfr_descrip | item_descrip2 / itemsrc_vend_item_descrip | Second line of description on the item and the vendor item description on the PO. |
| psprice_comm_code | catalog_comm_code | item_classcode_id | If the comm_code does not exist, the convert and the update will create it and use that id as the comm_code_id. |
| psprice_comm_pix | catalog_comm_pix | N/A | Not used with custom price sheets. |
| psprice_lgcy_uom | catalog_lgcy_uom | item_price_uom_id | If it does not exist in the uom table, the convert and the update will create it and set the item_price_uom_id to that uom_id. (If the value is C or M the update will also create a item conversion to 100 or 1000 if ps_uom=E.) |
| psprice_ps_uom | catalog_ps_uom | item_inv_uom_id / itemsrc_vend_uom | Only created for the convert (item_inv_uom), once set this field is not updated to maintain quantity on hand integrity. itemsrc_vend_uom is updated. |
| psprice_list | catalog_list | item_listcost / itemsrc_price/itemcost_stdcost | catalog_list is only used as cost if the catalog_custom_price1 filed is null and the catalog_col3 field is also null. (NOTE: Incident #25810 will update after that incident is closed.) |
| psprice_col3 | catalog_col3 | item_listcost / itemsrc_price_itemcost_stdcost | catalog_col3 is only used as cost if the catalog_custom_price1 field is null. |
| psprice_cost | catalog_cost | item_listcost / itemsrc_price_itemcost_stdcost | catalog_cost is only used as cost if the catalog_custom_price1 field is null as well as the catalog_col3 is also null. |
| psprice_custom_price1 | catalog_custom_price1 | item_listcost / itemsrc_price_itemcost_stdcost | catalog_custom_price1 is the primary field for costing in the catalog. |
| psprice_pkg_weight | catalog_pkg_weight | item_packweight | This if for the weight of the packaging on the item. |
| psprice_pkg_qty | catalog_pkg_qty | N/A | N/A |
| psprice_pkg_uom | catalog_pkg_uom | N/A | N/A |
| psprice_2k_desc | catalog_2k_desc | item_extdescrip | Extended description for the item. |
| psprice_indv_weight | catalog_indv_weight | item_prodweight | Item weight |
| psprice_pkg_freight_class | catalog_pkg_freight_class | item_freightclass_id / missing | Freight class is created if it does not exist. If no value is provided then the default is "Missing". |
| psprice_upc | catalog_upc | item_upccode / itemsrc_upccode | If your vendor does not provide a UPC, then use the item number as the UPC. UPC and item numbers are used to update items, your UPC should not be null. |
| psprice_prod_cat | catalog_prod_cat | item_prodcat_id | If the product category does not exist on convert or update it will be created. |
| psprice_src_name | catalog_src_name | N/A | N/A |
| psprice_dcsnt_schd_code | catalog_dscnt_schd_code | N/A | N/A |
| psprice_pdf_url | catalog_pdf_url | item document | This field is added as a document to the item. |
| psprice_web_url | catalog_web_url | item document | This field is added as a document to the item. |
