|
System Wide Technical
Database Specifications |
|
Customer Records |
Unlimited |
|
Prospect Records |
Unlimited |
|
Customer, Prospect, Vendor ID, Payroll ID |
12 Alpha/Numeric Characters |
|
Customer/Prospect User Definable Fields |
10 Alpha/Numeric Fields & 3 Date Fields
(13 Total) |
|
Customer/Prospect Secondary Locations |
Unlimited |
|
Primary Vendors |
Unlimited |
|
Secondary Vendors |
Unlimited |
|
Company Name |
40 Alpha/Numeric Characters |
|
Address Lines |
40 Alpha/Numeric Characters |
|
City |
24 Alpha/Numeric Characters |
|
Zip Code |
10 Alpha/Numeric Characters |
|
State |
2 Alpha/Numeric Characters |
|
Months to Keep Detailed Transactional
History |
Unlimited |
|
Customer/Vendor Account Balance |
$99,999,999.99 |
|
Number of Commission Tables |
Unlimited |
|
Payment Terms |
99 |
|
Sales Reps |
999 |
|
Line Items Per Quotation |
Unlimited |
|
Line Items Per Sales Order |
Unlimited |
|
Line
Items Per Invoice1 |
Unlimited |
|
Line
Items Per Purchase Order2 |
Unlimited |
|
Transaction Amount |
$9,999,999.99 |
|
Transaction Number |
6 Alpha/Numeric Characters |
|
Inventory Records |
Unlimited |
|
Inventory Item# |
20 Alpha/Numeric Characters |
|
Inventory Item Brief Description |
40 Alpha/Numeric Characters |
|
Inventory Item Detailed Description |
400 Alpha/Numeric Characters w/Carriage
Returns |
|
Maximum Item Cost/Price |
$9,999,999.99 |
|
Maximum Decimals for Cost & Selling Price |
5 |
|
Maximum # of Selling Prices |
6, Unlimited w/Special Contract Pricing
Module |
|
Inventory User Definable Fields |
4 Alpha/Numeric Fields & 5 User Definable
Tables |
|
Inventory Secondary Vendors |
Unlimited |
|
Inventory Category Tables |
Unlimited |
|
Inventory Serial Numbers |
Unlimited |
|
Inventory Lot Numbers |
Unlimited |
|
Inventory Bill of Materials |
Unlimited |
|
Inventory Production Orders |
Unlimited |
|
Recurring Invoices Per Customer/Vendor3 |
100 |
|
Invoices Per Customer3 |
12000 during 60 Month Period in A/R
Unlimited Storage in Invoice Module |
|
Sales
Accounts3 |
250 |
|
Sales Tax Jurisdictions3 |
10,000 |
|
Sales Accounts Per Invoice3 |
15 |
|
Months to Keep GL/AP/AR/PR History3 |
60 |
|
Number of Cash Accounts3 |
9 |
|
Number of G/L Accounts3 |
99999999 |
|
G/L Account Balance3 |
$999,999,9999.99 |
|
G/L Account Description3 |
40 Alpha/Numeric Characters |
|
Digits in G/L Account Number3 |
8 |
|
Digits in G/L Department Code3 |
3 |
|
Number of Departments3 |
999 |
|
Number of Open Fiscal Years3 |
9 |
|
Number or Subsidiary Companies3 |
99 |
|
G/L Distribution Accounts Per Transaction3 |
20 |
|
Number of A/P Checks Per Month3 |
Unlimited |
|
Digits on A/P Check3 |
6 |
|
A/P Invoices Per Check3 |
Unlimited |