Collapse AllExpand All

1.2. Mapping for Trade Service Data

The information in this section describes the trade service data after it has been converted to actual inventory in xTuple. This section will cover three tables: item, item site, item source. To learn more about items in xTuple, please see the reference guide section on items.

Table A.7. Item Information

ColumnDefault ValueData SourceDescription
item_numbercatalog_mfr_shortname+catalog_mfr_cat_num (required)External catalogItems are built by default with the catalog short name as a prefix for all items.
item_activeYesN/ASet Active by default.
item_descrip1catalog_product_name (optional)External catalogDescriptions are populated when converted but not updated by default.
item_descrip2catalog_mfr_description (optional)External catalogDescriptions are populated when converted but not updated by default.
item_type"P" (required) (P= Purchased items)N/AItems converted are set to purchased items by default.
item_inv_uom_idcatalog_ps_uom (required)External catalogInventory UOM comes form the catalog by default.
item_classcode_idcatalog_comm_code (required)External catalogBy default the class code is the TS commodity code.
item_picklistYes (required)N/ASet Yes by default.
item_soldYes (required)Catalog configuration 
item_fractionalNO (required)N/A 
item_maxcost0Not set by default 
item_prodweightcatalog_indv_weight (optional)External catalogWeight of the item.
item_packweightcatalog_pkg_weight (optional)External catalogPackage weight for the item.
item_prodcat_idcatalog_product_category (required)External catalog 
item_price_uom_idcatalog_ps_lgcy_uom, if null then catalog_ps_uom (required)External catalog 
item_exclusiveNoN/A 
item_listpricecatalog_list (required)External catalog 
item_upccodecatalog_upc (required)External catalog 
item_configNoN/A 
item_commentsleft blankN/A 
item_extdescripcatalog_2K_descExternal catalog 
item_warrdays0N/A 
item_freightclass_idcatalog_pkg_freight_classExternal catalog 
item_tax_recoverableYesCatalog configuration 


The next table describes the schema impacted when creating or updating item sites. To learn more about item sites in xTuple, please see the reference guide section on item sites.

Table A.8. Item Site Information

ColumnDefault ValueData SourceDescription
itemsite_warehous_idExternal catalog configurationCatalog configurationSet in the configuration for the provider.
itemsite_qtyonhand0Not set by default 
itemsite_useparamsExternal catalog configurationCatalog configurationTurns reorder levels on.
itemsite_useparamsmanualExternal catalog configurationCatalog configurationTurns on manual parameters for reorder levels.
itemsite_reorderlevelExternal catalog configurationCatalog configurationSets the reorder level for every item converted.
itemsite_ordertoqtyExternal catalog configurationCatalog configurationSet the order to QTY on an item site.
itemsite_minordqtyExternal catalog configurationCatalog configurationSet the minimum order QTY for an item site.
itemsite_maxordqtyExternal catalog configurationCatalog configurationSet the maximum order QTY for an item site.
itemsite_multordqtyExternal catalog configurationCatalog configurationSet the order multiple for an item site.
itemsite_safetystockExternal catalog configurationCatalog configurationSet the safety stock level for an item site.
itemsite_cyclecountfreqExternal catalog configurationCatalog configurationSet the cycle count frequency for an item site.
itemsite_leadtimeExternal catalog configurationCatalog configurationSet the default lead time for the item site.
itemsite_eventfenceExternal catalog configurationCatalog configurationSets the time frame under which cycle counts should be complete.
itemsite_plancode_idExternal catalog configurationCatalog configurationSet the planner code (reorder group) for an item site.
itemsite_costcat_idExternal catalog configurationCatalog configurationSet the GL cost category for the item site.
itemsite_poSupplyTrueN/ASet to PO supplied by default.
itemsite_woSupplyFalseN/ASet False by default.
itemsite_createprExternal catalog configurationCatalog configurationSets if the items create PO request.
itemsite_createwoFalseN/ASet False by default.
itemsite_createsoprExternal catalog configurationCatalog configurationSets if the items are SO is linked to PO request.
itemsite_createsopoExternal catalog configurationCatalog configurationSets if the items are SO is linked to PO.
itemsite_soldExternal catalog configurationCatalog configurationSet if the item is sold.
itemsite_soldrankingExternal catalog configurationCatalog configurationSet the sold ranking for an item site.
itemsite_stockedExternal catalog configurationCatalog configurationUsed in conjunction with Create PO and PR; Ii a sales order the PO or PR is created by default, setting the item as stocked makes them available in an SO but not checked by default.
itemsite_planning_typeExternal catalog configurationCatalog configurationSet the planning type on an item site.
itemsite_supply_itemsite_idNullNot set by default 
itemsite_controlmethodExternal catalog configurationCatalog configurationSet the default control method (normally Regular).
itemsite_perishableFalseN/ASet False by default.
itemsite_activeTrueN/ASet True by default.
itemsite_loccntrlExternal catalog configurationCatalog configurationSets multi-location control on.
itemsite_location_idExternal catalog configurationCatalog configurationSets default location for multi-location control.
itemsite_locationExternal catalog configurationCatalog configurationSet default location for item site.
itemsite_location_distExternal catalog configurationCatalog configurationSet default distribution location for item site.
itemsite_recvlocation_distExternal catalog configurationCatalog configurationSet default receiving location for item site.
itemsite_issuelocation_distExternal catalog configurationCatalog configurationSet default issue location for item site.
itemsite_location_commentsN/AN/ANot set by default.
itemsite_notesN/AN/ANot set by default.
itemsite_abcclassExternal catalog configurationCatalog configurationSet the ABC ranking.
itemsite_autoabcclassExternal catalog configurationCatalog configurationSet the ABC ranking to auto update.
itemsite_freezeN/AN/ANot set by default.
itemsite_datelastusedN/AN/ANot set by default.
itemsite_ordergroupExternal catalog configurationCatalog configurationSet the order group for an item site.
itemsite_ordergroup_firstExternal catalog configurationCatalog configurationSet the order group first (which order group is first).
itemsite_mps_timefence0N/ANot set by default.
itemsite_disallowblankwipN/AN/A 
itemsite_costmethodExternal catalog configurationCatalog configurationSet the default costing method for item site.
itemsite_valueN/AN/ANot set by default.
itemsite_cosdefault0N/ANot set by default.
itemsite_warrpurcFalseN/ASet False by default.
itemsite_autoregFalseN/ASet False by default.
itemsite_lsseq_idNullN/ANot set by default.


The next table describes the schema impacted when creating or updating item sources. To learn more about item sources in xTuple, please see the reference guide section on item sources.

Table A.9. Item Source Information

ColumnDefault ValueData SourceDescription
itemsrc_activeTrueN/AItem source is set active by default.
itemsrc_defaultTrueN/AItem source is set to default on convert.
itemsrc_vend_idcatalog_mfr_ucc_numExternal catalog 
itemsrc_vend_item_numbercatalog_mfr_cat_numExternal catalog 
itemsrc_vend_item_descrip,catalog_mfr_descriptionExternal catalog 
itemsrc_vend_uomcatalog_ps_uomExternal catalogUses catalog_ps_uom and external catalog configuration is catalog_ps_uom is null.
itemsrc_invvendoruomratio1N/A 
itemsrc_minordqtycatalog_ps_lgcy_uomExternal catalogCase select will set to 1, 100 or 1000 depending on the pricing UOM.
itemsrc_multordqty1N/ASet to 1 by default.
itemsrc_upccodecatalpg_upcExternal catalog 
itemsrc_leadtime1N/ASet to 1 by default.
itemsrc_ranking1N/ASet to 1 by default.
itemsrc_commentsNullN/ANot set by default.
itemsrc_manuf_namecatalog_mfr_fullnameExternal catalog 
itemsrc_manuf_item_numbercatalog_mfr_cat_numExternal catalog 
itemsrc_manuf_item_descripcatalog_mfr_descriptionExternal catalog