Table Files

Division – The division file defines the divisions (balance sheet entities) that exist in the system.  At least one division record (division 1) is required by the system.

Department – Defines the departments (functional or geographic) departments available in the system.  At least one department record (department 1) is required for each division in the system.  The department records are also used to store the valid warehouse locations in the system so you will normally have one department record for each of your inventory locations. 

Operator – Stores the valid operators in the system.  The demo and startup databases contain Guest and System Administrator operator records.  Normally one operator record will be created for each user in StreamV.

Payment Terms – Contains the valid payment terms that are used by the application (all systems)

Shipvia (Shipping Methods) - Contains the shipping methods that are used by the application. 

Viaterms (Shipping Terms)

Gencode Table (system required and optional or custom tables)

Zipcode – The zipcode file is used to validate address information for sales tax calculation

Product Line – Product Lines are used to organize your product structure and to control how inventory activity is posted to the general ledger.  Product Lines are also used by the Special Pricing system.  You should define your product lines prior to importing inventory or transaction data since the data will point to the product lines in this table.

Product Group – Product Groups are also used to organize your product structure.  The product group in each item can also be used for pricing purposes.  You should define your product groups prior to importing inventory or transaction data since the data will point to the product lines in this table.

You shou

Sales Rep

Regional Manager

Sales Manager

Taxcode

Currency

Country

More:

Policy or Parameter Files