General System Table Setup

Group 1

This group of data tables is created at the system level. The tables are shared by all financial enterprises.

SPTM Terms Code Maintenance:

Enter the financial payment terms codes for Accounts Payable and Accounts Receivable. These codes are used to set the payment and discount terms for a customer.

SPSF Ship Via Code Maintenance:

Enter the ship via codes. Ship via codes indicate the method of shipment.

SPSB  FOB Code Maintenance:

Enter the FOB codes. FOB codes reflect the Free on Board location.

SPAM Boilerplate Text Maintenance:

Enter the boilerplate text for comments.

SPLM  Labor Code Maintenance:

Enter and maintain labor codes fir all financial enterprises. Labor codes are required in program LREM, Labor Time Entry. Labor codes are supplied with the system. You can create additional codes, but deletion of standard codes is not recommended as they are used throughout the system.

SPKM  Comment Type Code Maintenance:

Maintain the comment type codes that will be included in the List of Values. Only comment type codes that can be entered in program VEMM, Vendor Master Maintenance, program CMMM, Customer Master Maintenance, and program ICMM, Inventory Master Maintenance, can be included in the List of Values for other programs.

SPCG Catalog ID Maintenance

Enter and maintain catalog ID's and descriptions used in catalog pricing.

SPFT Maintain Phone Types:

Enter and maintain telephone types. Telephone types are used when entering customer, vendor, and prospect contacts.

SPGM Global Comments Maintenance:

Enter and maintain global comments to print on sales order and purchase order reports.

SPRC Currency Code Maintenance:

Enter and maintain alternate currency codes. A full list of the ISO standard currency codes are provided with the system.

SPHM WCO Harmonized Code Maintenance:

Enter and maintain WCO harmonized codes, used when entering items in program ICMM, Inventory Master Maintenance.

Group 2

This group of tables is created by at the financial enterprise level. The user creating these tables must currently have access to the appropriate financial enterprise. Run program SPDM, System User Default Maintenance, to set the local financial enterprise for the following tables in Group 2 and Group 3.

SPSC Territory Code Maintenance:

Enter sales territories for sales representatives and sales order entry.

SPBM Bank Code Maintenance:

Add the bank codes and account numbers for your financial enterprise

SPSM State/Province Code Maintenance:

Enter state/province codes for your financial enterprise. The system supplies all U.S. state codes and all Canadian province codes.

SPNM Country Code Maintenance:

Enter country codes for your financial enterprise. The program comes with codes USA and CAN.

RERM  Reject/Scrap Reason Code Maintenance:

Enter the rejection and scrap reason codes.

SPPT Payment Type Maintenance:

Enter and maintain the payment type codes used in sales order entry. Miscellaneous codes can be assigned to payment types, after they have been entered into the system with program SPMC, Miscellaneous Code Maintenance.

SPZM Zip Code Maintenance:

Add, delete, and maintain zip code records for country codes.

CZMM Customer / Zip Code Master Maintenance:

Enter the customer / zip code cross references for the Sales Order Entry by Zip Code feature.

SPPH PPH Charges Maintenance:

Set up freight charges by sales order gross high. When a sales order's gross amount exceeds an amount entered in this program, the miscellaneous code assigned to the amount in this program will be entered on the sales order.

SPUF Contact Field User Title Maintenance:

Enter and maintain the label and case restrictions for the user fields for customer, vendor, and prospect contacts.

SPUC Contact User Codes Maintenance:

Enter and maintain the codes that can be assigned to the contact fields. Codes entered in program SPWM, System Contacts Maintenance, that do not exist here will be added automatically.

SPWM System Contacts Maintenance:

Enter and maintain the contact information for customers, prospects, and vendors.

SPOP System Printer Output Defaults

Maintain the printer defaults for printing sales order pick lists with program OESB, Sales Order Batch Shipping. Printer defaults are defined by plant. You can only enter one record for each Print Rule/Rule Value combination.

Group 3

This group of tables uses general ledger accounts in program GLTM, Account Maintenance. General ledger accounts can be added later in these tables or set up before these tables. See the General Ledger (GL) module to set up general ledger accounts .

The distribution codes are Account or Default. The default for new entries is Account, which indicates that you can enter in the Account field the general ledger account number to which amounts will be charged.

If Account is selected and the account is blank, freight, tax, or miscellaneous charges will be distributed to the Freight Account, Tax Account, or Miscellaneous Account entered in program APEM, AP Enterprise Maintenance. If no accounts have been entered in program APEM, AP Enterprise Maintenance, they will be distributed to the accounts assigned to the FRT, TAX, and MISC post types in program GPTM, Posting Template Maintenance, for the Accounts Payable Posting Interface.

Default indicates that during voucher update, the freight, tax, or miscellaneous amount will be charged to the same account number as the item.

SPFM Freight Code Maintenance:

Enter the freight shipment method codes for purchasing and sales order entry. Freight codes are set up by financial enterprise and are used to identify the general ledger posting option for the freight expense.

SPTX Tax Code Maintenance:

Enter the tax codes for purchasing and sales order entry. Tax codes are set up by financial enterprise.

SPSX Tax Rate Maintenance:

Program SPSX, Tax Rate Maintenance, is used to enter tax rates by zip codes. Tax rates can be set up for a single zip code or a range of zip codes.

SPMC Miscellaneous Code Maintenance:

Enter the miscellaneous codes for purchasing and sales order entry. Miscellaneous codes are setup by financial enterprise and allow general ledger distribution by code.