ORDERS Plus Technical Database Specifications

Accounting Software, ERP, Inventory software, Business Software

Product Questions? Select Here to Contact Our Live Help Desk

Phone: 800.764.4272

Fax: 800.340.9239

Technical Database Specifications

The information published on this page details certain key database field, format and record count specifications.

Typically, this information will benefit IT Consultants and Systems personnel to determine if the database structures in ORDERS Plus will meet the necessary application requirements.

Some system limitations are based upon whether or not the application requirements also include our integrated financials. Please refer to the respective footnotes for details.

If the specifications conflict with your application requirements, please discuss this with your sales representative, since there may be a resolution. However in general, database field specifications are not user definable nor modified for a specific user.

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 Invoice¹	Unlimited*
Line Items Per Purchase Order²	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/Vendor³	100
Invoices Per Customer³	12000 during 60 Month Period in A/R Unlimited Storage in Invoice Module
Sales Accounts³	250
Sales Tax Jurisdictions³	10,000
Sales Accounts Per Invoice³	15
Months to Keep GL/AP/AR/PR History³	60
Number of Cash Accounts³	9
Number of G/L Accounts³	99999999
G/L Account Balance³	$999,999,9999.99
G/L Account Description³	40 Alpha/Numeric Characters
Digits in G/L Account Number³	8
Digits in G/L Department Code³	3
Number of Departments³	999
Number of Open Fiscal Years³	9
Number or Subsidiary Companies³	99
G/L Distribution Accounts Per Transaction³	20
Number of A/P Checks Per Month³	Unlimited*
Digits on A/P Check³	6
A/P Invoices Per Check³	Unlimited*

¹ Unlimited Non-Stock Items & Limited to 99 Stock Items when using integrated financials

² Limited to 99 Open Purchase Receipts per Purchase Order when using integrated financials

³ Only Relevant if using Integrated Financials

* Based Solely on Enterprise Processing Ability & Amount of Hard Disk Space Available