ORDERS Plus.NET Technical Database Specifications

Accounting Software, ERP, Inventory software, Business Software

Product Questions? Select Here to Contact Our Live Help Desk

800.764.4272

Technical Specifications

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

This information will benefit Consultants and Systems personnel to determine if the database field structures will meet the necessary business requirements.

If the specifications conflict with your application requirements, please confirm this with a representative since there may be a resolution. In general, field specs are not user definable.

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

Copyright 2021 InterConnectWare L.L.C. All Rights Reserved. All materials contained on this site are protected by United States copyright law and may not be reproduced, distributed, transmitted, displayed, published or broadcast without the prior written permission of InterConnectWare L.L.C. or in the case of third party materials and their respective trademarks, the owner of that content. You may not alter or remove any trademark, copyright or other notice from copies of this content.