|
xTuple Wholesale Distribution Product Guide |
|
|
xTuple Wholesale Distribution Product Guide |
| 1.1. Catalog Tables and Fields for Conversions and Updates | ||
|---|---|---|
 | 1. Trade Service Electrical and Plumbing |  |
The goal of this section is to describe which tables and fields are affected when trade service items are created on conversion or updated after they've been converted. The first two tables describe the schema impacted when creating or updating inventory and pricing units of measure (UOM). To learn more about UOMs in xTuple, please see the reference guide section on UOMs.
Table A.1. Inventory UOMs
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | catalog_ps_uom | Catalog is used and if not found the catalog configuration default is used. | Both inventory and price UOM are created if not found during the update. |
| catalog_ps_uom | The UOM is also used as the description. | Both inventory and price UOM are created if not found. | |
| uom (target) | uom_name | Catalog is used and if not found the catalog configuration default is used. | Creates the UOM in the UOM table if not found during update. |
| uom_descrip | "catalog_ps_uom" is used and if not found the catalog configuration default is used. | Creates the UOM in the UOM table if not found during update. |
Table A.2. Pricing UOMs
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | catalog_ps_lgcy_uom | "catalog_lgcy_uom" is used and if not found the "catalog_psuom" is used. | Pricing UOM is the context for both the wholesale price as well as the list price on the item. |
| catalog_ps_lgcy_uom | "catalog_lgcy_uom" is used and if not found the "catalog_psuom" is used. | Pricing UOM is the context for both the wholesale price as well as the list price on the item. | |
| uom (target) | uom_name | "catalog_lgcy_uom" is used and if not found the "catalog_psuom" is used. | Pricing UOM is the context for both the wholesale price as well as the list price on the item. |
| uom_descrip | "catalog_lgcy_uom" is used and if not found the "catalog_psuom" is used. | Pricing UOM is the context for both the wholesale price as well as the list price on the item. |
The next table describes the schema impacted when creating or updating class codes. To learn more about class codes in xTuple, please see the reference guide section on class codes.
Table A.3. Class Codes
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | catalog_comm_code | NA | catalog_comm_code |
| catalog_comm_code | NA | catalog_comm_code | |
| classcode (target) | classcode_code | NA | Name of the class code created. |
| classcode_descrip | NA | Description of the class code created. |
The next table describes the schema impacted when creating or updating product categories. To learn more about product categories in xTuple, please see the reference guide section on product categories.
Table A.4. Product Categories
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | prodcat_code | NA | catalog_product_category |
| prodcat_descrip | NA | catalog_product_category | |
| classcode (target) | prodcat_code | NA | Name of the product category created. |
| prodcat_descrip | NA | Description of the product category created. |
The next table describes the schema impacted when creating or updating freight classes. To learn more about freight classes in xTuple, please see the reference guide section on freight classes.
Table A.5. Freight Classes
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | freightclass_code | NA | catalog_pkg_freight_class |
| freightclass_descrip | NA | catalog_pkg_freight_class | |
| freightclass (target) | freightclass_code | NA | Name of the freight class created. |
| freightclass_descrip | NA | Description of the freight class created. |
The next table describes the schema impacted when creating or updating vendors. To learn more about vendors in xTuple, please see the reference guide section on vendors.
If you have limited TS data, only required fields will be populated when creating a new vendor. Be sure to have purchasing staff review and update records like this.
Table A.6. Vendors
| Table | Column | Default Value | Description |
|---|---|---|---|
| xwd.catalog (source) | vend_number | catalog_mfr_ucc_num | Vendor number on the vendor record. |
| vend_accntnum | Null (not set) | The account number for you account with the vendor. | |
| vend_active | TRUE (set active by default) | Vendor is active. | |
| vend_vendtype_id | catconfig_vendtype_id (catconfig refers to settings under in the client). | Type of vendor is set by the catalog configuration if the vendor does not exist. | |
| vend_name | catalog_mfr_fullname (from xwd.catalog table). | Full name for the vendor on the vendor record. | |
| vend_cntct1_id | Null (not set by default) | Not set by default. | |
| vend_cntct2_id | Null (not set by default) | Not set by default. | |
| vend_addr_id | Null (not set by default) | Not set by default. | |
| vend_po | TRUE (set active by default) | Set True by default. | |
| vend_restrictpurch | FALSE (not set by default) | Set False by default. | |
| vend_1099 | FALSE (not set by default) | Set False by default. | |
| vend_qualified | TRUE (set active by default) | Set True By default. | |
| vend_comments | Null (not set by default) | Not set by default. | |
| vend_pocomments | Null (not set by default) | Not set by default. | |
| vend_fobsource | Null (not set by default) | Not set by default. | |
| vend_fob | Null (not set by default) | Not set by default. | |
| vend_terms_id | catconfig_terms_id (catconfig refers to settings under in the client). | Terms are taken from the catalog configuration by default. | |
| vend_shipvia | Null (not set by default) | Not set by default. | |
| vend_curr_id | Null (not set by default) | Not set by default. | |
| vend_taxzone_id | Null (not set by default) | Not set by default. | |
| vend_match | Null (not set by default) | Not set by default. | |
| vend_ach_enabled | Null (not set by default) | Not set by default. | |
| vend_ach_routingnumber | Null (not set by default) | Not set by default. | |
| vend_ach_accntnumber | Null (not set by default) | Not set by default. | |
| vend_ach_use_vendinfo | Null (Not set by default) | Not set by default. | |
| vend_ach_accnttype | "K" | (set by default) | |
| vend_ach_indiv_name | Null (not set by default) | Not set by default. | |
| vend_accnt_id | "-1" (not set by default) | Not set by default. | |
| vend_expcat_id | "-1" (not set by default) | Not set by default. | |
| vend_tax_id | "-1" (not set by default) | Not set by default. | |
| vendinfo (target) | vend_number | catalog_mfr_ucc_num | Field used in searches when adding a vendor to a PO (alpha numeric). |
| vend_accntnum | Null (Not set by default) | Field used to store your account number from your vendor. | |
| vend_active | True | Sets the vendor active or inactive in the system. | |
| vend_vendtype_id | Catalog Config Table | Sets the vendor type from products/setup/external vendor catalog. | |
| vend_name | catalog_mfr_fullname | Name used for the vendor on the vendor record. | |
| vend_cntct1_id | Null (Not set by default) | Primary contact for the vendor (normally the remit-to). | |
| vend_cntct2_id | Null (Not set by default) | Secondary contact for the vendor. | |
| vend_addr_id | Null (Not set by default) | Vendor address ID (normally the remit-to address for the vendor). | |
| vend_po | True | Reference field only, sets if the vendor accepts POs for material. | |
| vend_restrictpurch | Null (Not set by default) | Restricts purchases form the vendor to assigned item sources. | |
| vend_1099 | False (Not set by default) | Set if vendor is sent a form 1099 federal tax form. | |
| vend_qualified | True | Sets vendor as a trusted vendor. | |
| vend_comments | Null (Not set by default) | Comments for vendor specific notes. | |
| vend_pocomments | Null (Not set by default) | Comments that go on each PO. | |
| vend_fobsource | Null (Not set by default) | Who pays the freight for shipments. | |
| vend_fob | Null (Not set by default) | Vendor free on board setting. | |
| vend_terms_id | Catalog Config Table | Default terms for vendor products/setup/external vendor catalog. | |
| vend_shipvia | Null (Not set by default) | Preferred carrier for vendor shipments. | |
| vend_curr_id | Null (Not set by default) | ID for the currency for the vendor. | |
| vend_taxzone_id | Null (Not set by default) | Default tax zone for vendor if applicable. | |
| vend_match | Null (Not set by default) | Force matching of PO and voucher amounts from the vendor. | |
| vend_ach_enabled | Null (Not set by default) | Enable ACH payments for the vendor. | |
| vend_ach_routingnumber | Null (Not set by default) | Routing number for vendor ACH payments. | |
| vend_ach_accntnumber | Null (Not set by default) | Account number for vendor ACH payments. | |
| vend_ach_use_vendinfo | Null (Not set by default) | Use vendor record for ACH payments. | |
| vend_ach_accnttype | K | Account type used for vendor ACH payments. | |
| vend_ach_indiv_number | Null (Not set by default) | Vendor ACH payment number. | |
| vend_accnt_id | Null (Not set by default) | Default miscellaneous distribution account for vendor. | |
| vend_expcat_id | Null (Not set by default) | Default expense category for vendor. | |
| vend_tax_id | Null (Not set by default) | Default tax ID for the vendor, if applicable. |
| |  | |
| 1. Trade Service Electrical and Plumbing |  | 1.2. Mapping for Trade Service Data |