Adjustment Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Adjustment Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Cash Payments Lock
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Cash Payments Lock] (
	[Locking] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Locking Locking [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Pay Many Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Pay Many Detail] (
	[Vendor] [nvarchar] (50 ) NULL ,
	[Reference] [nvarchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Original Amount] [money] NULL ,
	[Discount] [money] NULL ,
	[Write Off] [money] NULL ,
	[Applied Amount] [money] NULL ,
	[Balance] [money] NULL ,
	[Amount Paid] [money] NULL ,
	[Discount Date] [datetime] NULL ,
	[AP Pay Type] [nvarchar] (20 ) NULL ,
	[AP PO Vendor Invoice No] [nvarchar] (50 ) NULL ,
	[AP PO Due Date] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Vendor Vendor [nvarchar](50) NULL  
Reference Reference [nvarchar](50) NULL  
Date Date [datetime] NULL  
Original Amount Original Amount [money] NULL  
Discount Discount [money] NULL  
Write Off Write Off [money] NULL  
Applied Amount Applied Amount [money] NULL  
Balance Balance [money] NULL  
Amount Paid Amount Paid [money] NULL  
Discount Date Discount Date [datetime] NULL  
AP Pay Type AP Pay Type [nvarchar](20) NULL  
AP PO Vendor Invoice No AP PO Vendor Invoice No [nvarchar](50) NULL  
AP PO Due Date AP PO Due Date [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Pay Many Header
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Pay Many Header] (
	[PH Vendor ID] [nvarchar] () NOT NULL ,
	[PH Vendor Name] [nvarchar] (50 ) NULL ,
	[PH Payment Total] [money] NULL ,
	[PH UnApplied Amount] [money] NULL ,
	[PH Check Number] [nvarchar] (50 ) NULL ,
	[PH Credit Amount] [money] NULL ,
	[PH Total Owed] [money] NULL ,
	[PH Selected] [bit] NOT NULL ,
	[PH Due Date] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PH Vendor ID PH Vendor ID [nvarchar](8) NOT NULL  
PH Vendor Name PH Vendor Name [nvarchar](50) NULL  
PH Payment Total PH Payment Total [money] NULL  
PH UnApplied Amount PH UnApplied Amount [money] NULL  
PH Check Number PH Check Number [nvarchar](50) NULL  
PH Credit Amount PH Credit Amount [money] NULL  
PH Total Owed PH Total Owed [money] NULL  
PH Selected PH Selected [bit] NOT NULL  
PH Due Date PH Due Date [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Pay Many Print Parameters
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Pay Many Print Parameters] (
	[PA Starting Check No] [int] NULL ,
	[PA Check Date] [datetime] NULL ,
	[PA Number of Checks Needed] [smallint] NULL ,
	[PA Include Credits] [bit] NOT NULL ,
	[PA Include Apply To] [bit] NOT NULL ,
	[PA ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[PA Bank] [nvarchar] () NULL ,
	[PA Source] [smallint] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PA Starting Check No PA Starting Check No [int] NULL  
PA Check Date PA Check Date [datetime] NULL  
PA Number of Checks Needed PA Number of Checks Needed [smallint] NULL  
PA Include Credits PA Include Credits [bit] NOT NULL  
PA Include Apply To PA Include Apply To [bit] NOT NULL  
PA ID PA ID [int] NOT NULL  
PA Bank PA Bank [nvarchar](8) NULL  
PA Source PA Source [smallint] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Pay Many Printed Documents
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Pay Many Printed Documents] (
	[PP Vendor ID] [nvarchar] () NOT NULL ,
	[PP Open ID] [int] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PP Vendor ID PP Vendor ID [nvarchar](8) NOT NULL  
PP Open ID PP Open ID [int] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Pay Many Workfile
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Pay Many Workfile] (
	[PM Vendor ID] [nvarchar] () NOT NULL ,
	[PM Vendor Name] [nvarchar] (50 ) NULL ,
	[PM Open ID] [int] NOT NULL ,
	[PM Balance] [money] NULL ,
	[PM Owed] [money] NULL ,
	[PM Amount to be Applied] [money] NULL ,
	[PM Amount to be Discounted] [money] NULL ,
	[PM Amount to be Written Off] [money] NULL ,
	[PM Project] [nvarchar] () NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PM Vendor ID PM Vendor ID [nvarchar](8) NOT NULL  
PM Vendor Name PM Vendor Name [nvarchar](50) NULL  
PM Open ID PM Open ID [int] NOT NULL  
PM Balance PM Balance [money] NULL  
PM Owed PM Owed [money] NULL  
PM Amount to be Applied PM Amount to be Applied [money] NULL  
PM Amount to be Discounted PM Amount to be Discounted [money] NULL  
PM Amount to be Written Off PM Amount to be Written Off [money] NULL  
PM Project PM Project [nvarchar](8) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Payment Header
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Payment Header] (
	[AP PAY ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AP PAY Type] [nvarchar] (20 ) NULL ,
	[AP PAY Check No] [nvarchar] (20 ) NULL ,
	[AP PAY Vendor No] [nvarchar] () NULL ,
	[AP PAY Transaction Date] [datetime] NULL ,
	[AP PAY Amount] [money] NULL ,
	[AP PAY UnApplied Amount] [money] NULL ,
	[AP PAY Bank Account] [nvarchar] (50 ) NULL ,
	[AP PAY Status] [nvarchar] (10 ) NULL ,
	[AP PAY Void] [bit] NOT NULL ,
	[AP PAY Notes] [nvarchar] (2000 ) NULL ,
	[AP PAY Credit Amount] [money] NULL ,
	[AP PAY Class] [float] NULL ,
	[AP PAY Cleared] [bit] NOT NULL ,
	[AP PAY Customer No] [nvarchar] (50 ) NULL ,
	[AP PAY Posted YN] [bit] NOT NULL ,
	[AP PAY Recurring YN] [bit] NOT NULL ,
	[AP PAY Reconciled] [bit] NOT NULL ,
	[AP PAY Credit YN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AP PAY ID AP PAY ID [int] NOT NULL  
AP PAY Type AP PAY Type [nvarchar](20) NULL  
AP PAY Check No AP PAY Check No [nvarchar](20) NULL  
AP PAY Vendor No AP PAY Vendor No [nvarchar](8) NULL  
AP PAY Transaction Date AP PAY Transaction Date [datetime] NULL  
AP PAY Amount AP PAY Amount [money] NULL  
AP PAY UnApplied Amount AP PAY UnApplied Amount [money] NULL  
AP PAY Bank Account AP PAY Bank Account [nvarchar](50) NULL  
AP PAY Status AP PAY Status [nvarchar](10) NULL  
AP PAY Void AP PAY Void [bit] NOT NULL  
AP PAY Notes AP PAY Notes [nvarchar](2000) NULL  
AP PAY Credit Amount AP PAY Credit Amount [money] NULL  
AP PAY Class AP PAY Class [float] NULL  
AP PAY Cleared AP PAY Cleared [bit] NOT NULL  
AP PAY Customer No AP PAY Customer No [nvarchar](50) NULL  
AP PAY Posted YN AP PAY Posted YN [bit] NOT NULL  
AP PAY Recurring YN AP PAY Recurring YN [bit] NOT NULL  
AP PAY Reconciled AP PAY Reconciled [bit] NOT NULL  
AP PAY Credit YN AP PAY Credit YN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Payment Invoice Cross Reference
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Payment Invoice Cross Reference] (
	[AP CROSS ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AP CROSS Payment ID] [int] NULL ,
	[AP CROSS Payed ID] [int] NULL ,
	[AP CROSS Discount Taken] [money] NULL ,
	[AP CROSS Write Off Amount] [money] NULL ,
	[AP CROSS Applied Amount] [money] NULL ,
	[AP CROSS Cleared] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AP CROSS ID AP CROSS ID [int] NOT NULL  
AP CROSS Payment ID AP CROSS Payment ID [int] NULL  
AP CROSS Payed ID AP CROSS Payed ID [int] NULL  
AP CROSS Discount Taken AP CROSS Discount Taken [money] NULL  
AP CROSS Write Off Amount AP CROSS Write Off Amount [money] NULL  
AP CROSS Applied Amount AP CROSS Applied Amount [money] NULL  
AP CROSS Cleared AP CROSS Cleared [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Purchase
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Purchase] (
	[AP PO Document No] [int] IDENTITY (, 1 ) NOT NULL ,
	[AP PO Ext Document No] [nvarchar] (50 ) NULL ,
	[AP PO Document Type] [nvarchar] (20 ) NULL ,
	[AP PO Saved YN] [bit] NOT NULL ,
	[AP PO Posted YN] [bit] NOT NULL ,
	[AP PO Open YN] [bit] NOT NULL ,
	[AP PO Check Print YN] [smallint] NULL ,
	[AP PO Date] [datetime] NULL ,
	[AP PO Due Date] [datetime] NULL ,
	[AP PO Vendor Invoice No] [nvarchar] (50 ) NULL ,
	[AP PO Taxes YN] [bit] NOT NULL ,
	[AP PO Vendor ID] [nvarchar] () NULL ,
	[AP PO Vendor Info] [nvarchar] (1000 ) NULL ,
	[AP PO Vendor Name] [nvarchar] (50 ) NULL ,
	[AP PO Address 1] [nvarchar] (30 ) NULL ,
	[AP PO Address 2] [nvarchar] (30 ) NULL ,
	[AP PO City] [nvarchar] (20 ) NULL ,
	[AP PO State] [nvarchar] () NULL ,
	[AP PO Postal] [nvarchar] (20 ) NULL ,
	[AP PO Country] [nvarchar] (50 ) NULL ,
	[AP PO Remit To] [nvarchar] (1000 ) NULL ,
	[AP PO Remit Name] [nvarchar] (50 ) NULL ,
	[AP PO Remit Address 1] [nvarchar] (30 ) NULL ,
	[AP PO Remit Address 2] [nvarchar] (30 ) NULL ,
	[AP PO Remit City] [nvarchar] (20 ) NULL ,
	[AP PO Remit State] [nvarchar] () NULL ,
	[AP PO Remit Postal] [nvarchar] (20 ) NULL ,
	[AP PO Remit Country] [nvarchar] (50 ) NULL ,
	[AP PO Date Requested] [datetime] NULL ,
	[AP PO Ship Method] [nvarchar] (20 ) NULL ,
	[AP PO Ordered by] [nvarchar] (20 ) NULL ,
	[AP PO Payment Terms] [nvarchar] (20 ) NULL ,
	[AP PO Payment Method] [nvarchar] (20 ) NULL ,
	[AP PO Discount Percent] [float] NULL ,
	[AP PO Discount Amt] [money] NULL ,
	[AP PO Subtotal] [money] NULL ,
	[AP PO Misc Percent] [float] NULL ,
	[AP PO Misc Charges] [money] NULL ,
	[AP PO Tax Percent] [float] NULL ,
	[AP PO Shipping] [money] NULL ,
	[AP PO Total Amount] [money] NULL ,
	[AP PO Amount Paid] [money] NULL ,
	[AP PO Balance Due] [money] NULL ,
	[AP PO Description] [nvarchar] (50 ) NULL ,
	[AP PO Message] [nvarchar] (50 ) NULL ,
	[AP PO Existing PO] [bit] NOT NULL ,
	[AP PO Existing PO Number] [nvarchar] (20 ) NULL ,
	[AP PO Undistributed Amt] [money] NULL ,
	[AP PO Check Number] [nvarchar] (50 ) NULL ,
	[AP PO Check Acct ID] [nvarchar] (50 ) NULL ,
	[AP PO Check Date] [datetime] NULL ,
	[AP PO Notes] [nvarchar] (1000 ) NULL ,
	[AP PO Department] [nvarchar] () NULL ,
	[AP PO Recurring YN] [bit] NOT NULL ,
	[AP PO Cleared YN] [bit] NOT NULL ,
	[AP PO Computer Check] [bit] NOT NULL ,
	[AP PO Default GL] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AP PO Document No AP PO Document No [int] NOT NULL  
AP PO Ext Document No AP PO Ext Document No [nvarchar](50) NULL  
AP PO Document Type AP PO Document Type [nvarchar](20) NULL  
AP PO Saved YN AP PO Saved YN [bit] NOT NULL  
AP PO Posted YN AP PO Posted YN [bit] NOT NULL  
AP PO Open YN AP PO Open YN [bit] NOT NULL  
AP PO Check Print YN AP PO Check Print YN [smallint] NULL  
AP PO Date AP PO Date [datetime] NULL  
AP PO Due Date AP PO Due Date [datetime] NULL  
AP PO Vendor Invoice No AP PO Vendor Invoice No [nvarchar](50) NULL  
AP PO Taxes YN AP PO Taxes YN [bit] NOT NULL  
AP PO Vendor ID AP PO Vendor ID [nvarchar](8) NULL  
AP PO Vendor Info AP PO Vendor Info [nvarchar](1000) NULL  
AP PO Vendor Name AP PO Vendor Name [nvarchar](50) NULL  
AP PO Address 1 AP PO Address 1 [nvarchar](30) NULL  
AP PO Address 2 AP PO Address 2 [nvarchar](30) NULL  
AP PO City AP PO City [nvarchar](20) NULL  
AP PO State AP PO State [nvarchar](5) NULL  
AP PO Postal AP PO Postal [nvarchar](20) NULL  
AP PO Country AP PO Country [nvarchar](50) NULL  
AP PO Remit To AP PO Remit To [nvarchar](1000) NULL  
AP PO Remit Name AP PO Remit Name [nvarchar](50) NULL  
AP PO Remit Address 1 AP PO Remit Address 1 [nvarchar](30) NULL  
AP PO Remit Address 2 AP PO Remit Address 2 [nvarchar](30) NULL  
AP PO Remit City AP PO Remit City [nvarchar](20) NULL  
AP PO Remit State AP PO Remit State [nvarchar](5) NULL  
AP PO Remit Postal AP PO Remit Postal [nvarchar](20) NULL  
AP PO Remit Country AP PO Remit Country [nvarchar](50) NULL  
AP PO Date Requested AP PO Date Requested [datetime] NULL  
AP PO Ship Method AP PO Ship Method [nvarchar](20) NULL  
AP PO Ordered by AP PO Ordered by [nvarchar](20) NULL  
AP PO Payment Terms AP PO Payment Terms [nvarchar](20) NULL  
AP PO Payment Method AP PO Payment Method [nvarchar](20) NULL  
AP PO Discount Percent AP PO Discount Percent [float] NULL  
AP PO Discount Amt AP PO Discount Amt [money] NULL  
AP PO Subtotal AP PO Subtotal [money] NULL  
AP PO Misc Percent AP PO Misc Percent [float] NULL  
AP PO Misc Charges AP PO Misc Charges [money] NULL  
AP PO Tax Percent AP PO Tax Percent [float] NULL  
AP PO Shipping AP PO Shipping [money] NULL  
AP PO Total Amount AP PO Total Amount [money] NULL  
AP PO Amount Paid AP PO Amount Paid [money] NULL  
AP PO Balance Due AP PO Balance Due [money] NULL  
AP PO Description AP PO Description [nvarchar](50) NULL  
AP PO Message AP PO Message [nvarchar](50) NULL  
AP PO Existing PO AP PO Existing PO [bit] NOT NULL  
AP PO Existing PO Number AP PO Existing PO Number [nvarchar](20) NULL  
AP PO Undistributed Amt AP PO Undistributed Amt [money] NULL  
AP PO Check Number AP PO Check Number [nvarchar](50) NULL  
AP PO Check Acct ID AP PO Check Acct ID [nvarchar](50) NULL  
AP PO Check Date AP PO Check Date [datetime] NULL  
AP PO Notes AP PO Notes [nvarchar](1000) NULL  
AP PO Department AP PO Department [nvarchar](5) NULL  
AP PO Recurring YN AP PO Recurring YN [bit] NOT NULL  
AP PO Cleared YN AP PO Cleared YN [bit] NOT NULL  
AP PO Computer Check AP PO Computer Check [bit] NOT NULL  
AP PO Default GL AP PO Default GL [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Purchase Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Purchase Detail] (
	[AP POD ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AP POD Document No] [int] NULL ,
	[AP POD Qty] [float] NULL ,
	[AP POD Item ID] [nvarchar] (20 ) NULL ,
	[AP POD Description] [nvarchar] (255 ) NULL ,
	[AP POD Units] [nvarchar] (20 ) NULL ,
	[AP POD Tax] [bit] NOT NULL ,
	[AP POD Vendor Item ID] [nvarchar] (20 ) NULL ,
	[AP POD Unit Cost] [float] NULL ,
	[AP POD Item Total] [float] NULL ,
	[AP POD Posting Account] [nvarchar] (50 ) NULL ,
	[AP POD Department] [nvarchar] () NULL ,
	[AP POD Project ID] [nvarchar] () NULL ,
	[AP POD Date Received] [datetime] NULL ,
	[AP POD Total Qty Received] [float] NULL ,
	[AP POD 1099 YN] [bit] NOT NULL ,
	[AP POD Recd From PO No] [int] NULL ,
	[AP POD Account Type] [nvarchar] (50 ) NULL ,
	[AP POD Row Type] [nvarchar] () NULL ,
	[AP POD Open YN] [smallint] NULL ,
	[AP POD Default GL] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AP POD ID AP POD ID [int] NOT NULL  
AP POD Document No AP POD Document No [int] NULL  
AP POD Qty AP POD Qty [float] NULL  
AP POD Item ID AP POD Item ID [nvarchar](20) NULL  
AP POD Description AP POD Description [nvarchar](255) NULL  
AP POD Units AP POD Units [nvarchar](20) NULL  
AP POD Tax AP POD Tax [bit] NOT NULL  
AP POD Vendor Item ID AP POD Vendor Item ID [nvarchar](20) NULL  
AP POD Unit Cost AP POD Unit Cost [float] NULL  
AP POD Item Total AP POD Item Total [float] NULL  
AP POD Posting Account AP POD Posting Account [nvarchar](50) NULL  
AP POD Department AP POD Department [nvarchar](5) NULL  
AP POD Project ID AP POD Project ID [nvarchar](8) NULL  
AP POD Date Received AP POD Date Received [datetime] NULL  
AP POD Total Qty Received AP POD Total Qty Received [float] NULL  
AP POD 1099 YN AP POD 1099 YN [bit] NOT NULL  
AP POD Recd From PO No AP POD Recd From PO No [int] NULL  
AP POD Account Type AP POD Account Type [nvarchar](50) NULL  
AP POD Row Type AP POD Row Type [nvarchar](1) NULL  
AP POD Open YN AP POD Open YN [smallint] NULL  
AP POD Default GL AP POD Default GL [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AP Vendor
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AP Vendor] (
	[AR CUST Saved] [smallint] NULL ,
	[AP VEN ID] [nvarchar] () NOT NULL ,
	[AP VEN Name] [nvarchar] (50 ) NULL ,
	[AP VEN Inactive YN] [smallint] NULL ,
	[AP VEN Address 1] [nvarchar] (30 ) NULL ,
	[AP VEN Address 2] [nvarchar] (30 ) NULL ,
	[AP VEN City] [nvarchar] (20 ) NULL ,
	[AP VEN State] [nvarchar] () NULL ,
	[AP VEN Postal] [nvarchar] (20 ) NULL ,
	[AP VEN Country] [nvarchar] (20 ) NULL ,
	[AP VEN Phone] [nvarchar] (20 ) NULL ,
	[AP VEN Phone Ext] [nvarchar] (10 ) NULL ,
	[AP VEN Fax] [nvarchar] (20 ) NULL ,
	[AP VEN Contact] [nvarchar] (20 ) NULL ,
	[AP VEN Notes] [nvarchar] (1000 ) NULL ,
	[AP VEN Remit Name] [nvarchar] (50 ) NULL ,
	[AP VEN Remit Address 1] [nvarchar] (30 ) NULL ,
	[AP VEN Remit Address 2] [nvarchar] (30 ) NULL ,
	[AP VEN Remit City] [nvarchar] (20 ) NULL ,
	[AP VEN Remit State] [nvarchar] () NULL ,
	[AP VEN Remit Postal] [nvarchar] (20 ) NULL ,
	[AP VEN Remit Country] [nvarchar] (20 ) NULL ,
	[AP VEN Remit Phone] [nvarchar] (20 ) NULL ,
	[AP VEN Remit Phone Ext] [nvarchar] (10 ) NULL ,
	[AP VEN Remit Fax] [nvarchar] (20 ) NULL ,
	[AP VEN Remit Contact] [nvarchar] (20 ) NULL ,
	[AP VEN Default Terms] [nvarchar] (20 ) NULL ,
	[AP VEN Type] [nvarchar] (20 ) NULL ,
	[AP VEN 1099] [bit] NOT NULL ,
	[AP VEN Tax ID] [nvarchar] (20 ) NULL ,
	[AP VEN Default GL] [nvarchar] (50 ) NULL ,
	[AP VEN Default Department] [nvarchar] (50 ) NULL ,
	[AP VEN Financial Period 1] [float] NULL ,
	[AP VEN Financial Period 2] [float] NULL ,
	[AP VEN Financial Period 3] [float] NULL ,
	[AP VEN Financial Period 4] [float] NULL ,
	[AP VEN Financial Total] [float] NULL ,
	[AP VEN Purchase YTD] [float] NULL ,
	[AP VEN Purchase Last Year] [float] NULL ,
	[AP VEN Purchase Lifetime] [float] NULL ,
	[AP VEN Payments YTD] [float] NULL ,
	[AP VEN Payments Last Year] [float] NULL ,
	[AP VEN Payments Lifetime] [float] NULL ,
	[AP VEN 1099 Payments YTD] [float] NULL ,
	[AP VEN 1099 Payments Last Year] [float] NULL ,
	[AP VEN 1099 Payments Lifetime] [float] NULL ,
	[AP VEN Purchase Number YTD] [smallint] NULL ,
	[AP VEN Purchase Number Last Year] [smallint] NULL ,
	[AP VEN Purchase Number Lifetime] [smallint] NULL ,
	[AP VEN Payment Number YTD] [smallint] NULL ,
	[AP VEN Payment Number Last Year] [smallint] NULL ,
	[AP VEN Payment Number Lifetime] [smallint] NULL ,
	[AP VEN Payment Hold] [bit] NOT NULL ,
	[AP VEN Department] [nvarchar] () NULL ,
	[AP VEN Custom 1] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 2] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 3] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 4] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 5] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 6] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 7] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 8] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 9] [nvarchar] (50 ) NULL ,
	[AP VEN Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR CUST Saved AR CUST Saved [smallint] NULL  
AP VEN ID AP VEN ID [nvarchar](8) NOT NULL  
AP VEN Name AP VEN Name [nvarchar](50) NULL  
AP VEN Inactive YN AP VEN Inactive YN [smallint] NULL  
AP VEN Address 1 AP VEN Address 1 [nvarchar](30) NULL  
AP VEN Address 2 AP VEN Address 2 [nvarchar](30) NULL  
AP VEN City AP VEN City [nvarchar](20) NULL  
AP VEN State AP VEN State [nvarchar](5) NULL  
AP VEN Postal AP VEN Postal [nvarchar](20) NULL  
AP VEN Country AP VEN Country [nvarchar](20) NULL  
AP VEN Phone AP VEN Phone [nvarchar](20) NULL  
AP VEN Phone Ext AP VEN Phone Ext [nvarchar](10) NULL  
AP VEN Fax AP VEN Fax [nvarchar](20) NULL  
AP VEN Contact AP VEN Contact [nvarchar](20) NULL  
AP VEN Notes AP VEN Notes [nvarchar](1000) NULL  
AP VEN Remit Name AP VEN Remit Name [nvarchar](50) NULL  
AP VEN Remit Address 1 AP VEN Remit Address 1 [nvarchar](30) NULL  
AP VEN Remit Address 2 AP VEN Remit Address 2 [nvarchar](30) NULL  
AP VEN Remit City AP VEN Remit City [nvarchar](20) NULL  
AP VEN Remit State AP VEN Remit State [nvarchar](5) NULL  
AP VEN Remit Postal AP VEN Remit Postal [nvarchar](20) NULL  
AP VEN Remit Country AP VEN Remit Country [nvarchar](20) NULL  
AP VEN Remit Phone AP VEN Remit Phone [nvarchar](20) NULL  
AP VEN Remit Phone Ext AP VEN Remit Phone Ext [nvarchar](10) NULL  
AP VEN Remit Fax AP VEN Remit Fax [nvarchar](20) NULL  
AP VEN Remit Contact AP VEN Remit Contact [nvarchar](20) NULL  
AP VEN Default Terms AP VEN Default Terms [nvarchar](20) NULL  
AP VEN Type AP VEN Type [nvarchar](20) NULL  
AP VEN 1099 AP VEN 1099 [bit] NOT NULL  
AP VEN Tax ID AP VEN Tax ID [nvarchar](20) NULL  
AP VEN Default GL AP VEN Default GL [nvarchar](50) NULL  
AP VEN Default Department AP VEN Default Department [nvarchar](50) NULL  
AP VEN Financial Period 1 AP VEN Financial Period 1 [float] NULL  
AP VEN Financial Period 2 AP VEN Financial Period 2 [float] NULL  
AP VEN Financial Period 3 AP VEN Financial Period 3 [float] NULL  
AP VEN Financial Period 4 AP VEN Financial Period 4 [float] NULL  
AP VEN Financial Total AP VEN Financial Total [float] NULL  
AP VEN Purchase YTD AP VEN Purchase YTD [float] NULL  
AP VEN Purchase Last Year AP VEN Purchase Last Year [float] NULL  
AP VEN Purchase Lifetime AP VEN Purchase Lifetime [float] NULL  
AP VEN Payments YTD AP VEN Payments YTD [float] NULL  
AP VEN Payments Last Year AP VEN Payments Last Year [float] NULL  
AP VEN Payments Lifetime AP VEN Payments Lifetime [float] NULL  
AP VEN 1099 Payments YTD AP VEN 1099 Payments YTD [float] NULL  
AP VEN 1099 Payments Last Year AP VEN 1099 Payments Last Year [float] NULL  
AP VEN 1099 Payments Lifetime AP VEN 1099 Payments Lifetime [float] NULL  
AP VEN Purchase Number YTD AP VEN Purchase Number YTD [smallint] NULL  
AP VEN Purchase Number Last Year AP VEN Purchase Number Last Year [smallint] NULL  
AP VEN Purchase Number Lifetime AP VEN Purchase Number Lifetime [smallint] NULL  
AP VEN Payment Number YTD AP VEN Payment Number YTD [smallint] NULL  
AP VEN Payment Number Last Year AP VEN Payment Number Last Year [smallint] NULL  
AP VEN Payment Number Lifetime AP VEN Payment Number Lifetime [smallint] NULL  
AP VEN Payment Hold AP VEN Payment Hold [bit] NOT NULL  
AP VEN Department AP VEN Department [nvarchar](5) NULL  
AP VEN Custom 1 AP VEN Custom 1 [nvarchar](50) NULL  
AP VEN Custom 2 AP VEN Custom 2 [nvarchar](50) NULL  
AP VEN Custom 3 AP VEN Custom 3 [nvarchar](50) NULL  
AP VEN Custom 4 AP VEN Custom 4 [nvarchar](50) NULL  
AP VEN Custom 5 AP VEN Custom 5 [nvarchar](50) NULL  
AP VEN Custom 6 AP VEN Custom 6 [nvarchar](50) NULL  
AP VEN Custom 7 AP VEN Custom 7 [nvarchar](50) NULL  
AP VEN Custom 8 AP VEN Custom 8 [nvarchar](50) NULL  
AP VEN Custom 9 AP VEN Custom 9 [nvarchar](50) NULL  
AP VEN Custom 10 AP VEN Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Customer
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Customer] (
	[AR CUST Customer ID] [nvarchar] () NOT NULL ,
	[AR CUST Name] [nvarchar] (50 ) NULL ,
	[AR CUST Address 1] [nvarchar] (30 ) NULL ,
	[AR CUST Address 2] [nvarchar] (30 ) NULL ,
	[AR CUST City] [nvarchar] (20 ) NULL ,
	[AR CUST State] [nvarchar] () NULL ,
	[AR CUST Postal] [nvarchar] (20 ) NULL ,
	[AR CUST Country] [nvarchar] (20 ) NULL ,
	[AR CUST Phone] [nvarchar] (20 ) NULL ,
	[AR CUST Phone Ext] [nvarchar] (10 ) NULL ,
	[AR CUST Fax] [nvarchar] (20 ) NULL ,
	[AR CUST Contact] [nvarchar] (30 ) NULL ,
	[AR CUST Type] [nvarchar] (20 ) NULL ,
	[AR CUST Discount %] [float] NULL ,
	[AR CUST Tax ID No] [nvarchar] (20 ) NULL ,
	[AR CUST Tax Group] [nvarchar] (20 ) NULL ,
	[AR CUST Payment Terms] [nvarchar] (20 ) NULL ,
	[AR CUST Credit Limit] [float] NULL ,
	[AR CUST Notes] [nvarchar] (2000 ) NULL ,
	[AR CUST Financial Period 1] [float] NULL ,
	[AR CUST Financial Period 2] [float] NULL ,
	[AR CUST Financial Period 3] [float] NULL ,
	[AR CUST Financial Period 4] [float] NULL ,
	[AR CUST Financial Total] [float] NULL ,
	[AR CUST Sales YTD] [float] NULL ,
	[AR CUST Sales Last Year] [float] NULL ,
	[AR CUST Sales Lifetime] [float] NULL ,
	[AR CUST Payments YTD] [float] NULL ,
	[AR CUST Payments Last Year] [float] NULL ,
	[AR CUST Payments Lifetime] [float] NULL ,
	[AR CUST Write Offs YTD] [float] NULL ,
	[AR CUST Write Offs Last Year] [float] NULL ,
	[AR CUST Write Offs Lifetime] [float] NULL ,
	[AR CUST Invoices YTD] [smallint] NULL ,
	[AR CUST Invoices Last Year] [smallint] NULL ,
	[AR CUST Invoices Lifetime] [smallint] NULL ,
	[AR CUST Highest Balance] [float] NULL ,
	[AR CUST Average Days To Pay] [float] NULL ,
	[AR CUST Statements YN] [bit] NOT NULL ,
	[AR CUST Finance Charge YN] [bit] NOT NULL ,
	[AR CUST SalesPerson] [nvarchar] () NULL ,
	[AR CUST Sales Account] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR CUST Customer ID AR CUST Customer ID [nvarchar](8) NOT NULL  
AR CUST Name AR CUST Name [nvarchar](50) NULL  
AR CUST Address 1 AR CUST Address 1 [nvarchar](30) NULL  
AR CUST Address 2 AR CUST Address 2 [nvarchar](30) NULL  
AR CUST City AR CUST City [nvarchar](20) NULL  
AR CUST State AR CUST State [nvarchar](5) NULL  
AR CUST Postal AR CUST Postal [nvarchar](20) NULL  
AR CUST Country AR CUST Country [nvarchar](20) NULL  
AR CUST Phone AR CUST Phone [nvarchar](20) NULL  
AR CUST Phone Ext AR CUST Phone Ext [nvarchar](10) NULL  
AR CUST Fax AR CUST Fax [nvarchar](20) NULL  
AR CUST Contact AR CUST Contact [nvarchar](30) NULL  
AR CUST Type AR CUST Type [nvarchar](20) NULL  
AR CUST Discount % AR CUST Discount % [float] NULL  
AR CUST Tax ID No AR CUST Tax ID No [nvarchar](20) NULL  
AR CUST Tax Group AR CUST Tax Group [nvarchar](20) NULL  
AR CUST Payment Terms AR CUST Payment Terms [nvarchar](20) NULL  
AR CUST Credit Limit AR CUST Credit Limit [float] NULL  
AR CUST Notes AR CUST Notes [nvarchar](2000) NULL  
AR CUST Financial Period 1 AR CUST Financial Period 1 [float] NULL  
AR CUST Financial Period 2 AR CUST Financial Period 2 [float] NULL  
AR CUST Financial Period 3 AR CUST Financial Period 3 [float] NULL  
AR CUST Financial Period 4 AR CUST Financial Period 4 [float] NULL  
AR CUST Financial Total AR CUST Financial Total [float] NULL  
AR CUST Sales YTD AR CUST Sales YTD [float] NULL  
AR CUST Sales Last Year AR CUST Sales Last Year [float] NULL  
AR CUST Sales Lifetime AR CUST Sales Lifetime [float] NULL  
AR CUST Payments YTD AR CUST Payments YTD [float] NULL  
AR CUST Payments Last Year AR CUST Payments Last Year [float] NULL  
AR CUST Payments Lifetime AR CUST Payments Lifetime [float] NULL  
AR CUST Write Offs YTD AR CUST Write Offs YTD [float] NULL  
AR CUST Write Offs Last Year AR CUST Write Offs Last Year [float] NULL  
AR CUST Write Offs Lifetime AR CUST Write Offs Lifetime [float] NULL  
AR CUST Invoices YTD AR CUST Invoices YTD [smallint] NULL  
AR CUST Invoices Last Year AR CUST Invoices Last Year [smallint] NULL  
AR CUST Invoices Lifetime AR CUST Invoices Lifetime [smallint] NULL  
AR CUST Highest Balance AR CUST Highest Balance [float] NULL  
AR CUST Average Days To Pay AR CUST Average Days To Pay [float] NULL  
AR CUST Statements YN AR CUST Statements YN [bit] NOT NULL  
AR CUST Finance Charge YN AR CUST Finance Charge YN [bit] NOT NULL  
AR CUST SalesPerson AR CUST SalesPerson [nvarchar](8) NULL  
AR CUST Sales Account AR CUST Sales Account [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Order
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Order] (
	[AR ORDER Document #] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR ORDER Ext Document #] [nvarchar] (20 ) NULL ,
	[AR ORDER Document Type] [nvarchar] (20 ) NULL ,
	[AR ORDER Saved YN] [bit] NOT NULL ,
	[AR ORDER Posted YN] [bit] NOT NULL ,
	[AR ORDER Service YN] [smallint] NULL ,
	[AR ORDER Date] [datetime] NULL ,
	[AR ORDER Due Date] [datetime] NULL ,
	[AR ORDER PO ID] [nvarchar] (50 ) NULL ,
	[AR ORDER Tax Exempt ID] [nvarchar] (20 ) NULL ,
	[AR ORDER Tax Group] [nvarchar] (20 ) NULL ,
	[AR ORDER Customer ID] [nvarchar] () NULL ,
	[AR ORDER Bill To] [nvarchar] (1000 ) NULL ,
	[AR ORDER Billing Customer] [nvarchar] (50 ) NULL ,
	[AR ORDER Billing Address 1] [nvarchar] (30 ) NULL ,
	[AR ORDER Billing Address 2] [nvarchar] (30 ) NULL ,
	[AR ORDER Billing City] [nvarchar] (20 ) NULL ,
	[AR ORDER Billing State] [nvarchar] () NULL ,
	[AR ORDER Billing Postal] [nvarchar] (20 ) NULL ,
	[AR ORDER Billing Country] [nvarchar] (50 ) NULL ,
	[AR ORDER Ship Date] [datetime] NULL ,
	[AR ORDER Shipping ID] [nvarchar] () NULL ,
	[AR ORDER Ship To] [nvarchar] (1000 ) NULL ,
	[AR ORDER Shipping Customer] [nvarchar] (50 ) NULL ,
	[AR ORDER Shipping Address 1] [nvarchar] (30 ) NULL ,
	[AR ORDER Shipping Address 2] [nvarchar] (30 ) NULL ,
	[AR ORDER Shipping City] [nvarchar] (20 ) NULL ,
	[AR ORDER Shipping State] [nvarchar] () NULL ,
	[AR ORDER Shipping Postal] [nvarchar] (20 ) NULL ,
	[AR ORDER Shipping Country] [nvarchar] (50 ) NULL ,
	[AR ORDER Shipping Method] [nvarchar] (30 ) NULL ,
	[AR ORDER Salesperson] [nvarchar] (20 ) NULL ,
	[AR ORDER Payment Terms] [nvarchar] (20 ) NULL ,
	[AR ORDER Payment Method] [nvarchar] (20 ) NULL ,
	[AR ORDER Subtotal] [money] NULL ,
	[AR ORDER Discount Percent] [float] NULL ,
	[AR ORDER Discount Amount] [money] NULL ,
	[AR ORDER Tax Percent] [float] NULL ,
	[AR ORDER Sales Tax] [money] NULL ,
	[AR ORDER Freight] [money] NULL ,
	[AR ORDER Total] [money] NULL ,
	[AR ORDER Amount Paid] [money] NULL ,
	[AR ORDER Balance Due] [money] NULL ,
	[AR ORDER Undistributed Amt] [money] NULL ,
	[AR ORDER Commission] [money] NULL ,
	[AR ORDER Commissionable Sales] [money] NULL ,
	[AR ORDER Commissionable Cost] [money] NULL ,
	[AR ORDER Description] [nvarchar] (150 ) NULL ,
	[AR ORDER Message] [nvarchar] (50 ) NULL ,
	[AR ORDER Apply to Number] [nvarchar] (20 ) NULL ,
	[AR ORDER Check Number] [nvarchar] (50 ) NULL ,
	[AR ORDER Check Acct ID] [nvarchar] () NULL ,
	[AR ORDER Check Date] [datetime] NULL ,
	[AR ORDER Quote Document #] [int] NULL ,
	[AR ORDER Notes] [nvarchar] (500 ) NULL ,
	[AR ORDER Department] [nvarchar] () NULL ,
	[AR ORDER Taxable Subtotal] [money] NULL ,
	[AR ORDER Tax Freight] [bit] NOT NULL ,
	[AR ORDER Recurring YN] [bit] NOT NULL ,
	[AR ORDER Cleared] [bit] NOT NULL ,
	[AR ORDER Recur Type] [nvarchar] (50 ) NULL ,
	[AR ORDER Next Recur] [datetime] NULL ,
	[AR ORDER Invoiced] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR ORDER Document # AR ORDER Document # [int] NOT NULL  
AR ORDER Ext Document # AR ORDER Ext Document # [nvarchar](20) NULL  
AR ORDER Document Type AR ORDER Document Type [nvarchar](20) NULL  
AR ORDER Saved YN AR ORDER Saved YN [bit] NOT NULL  
AR ORDER Posted YN AR ORDER Posted YN [bit] NOT NULL  
AR ORDER Service YN AR ORDER Service YN [smallint] NULL  
AR ORDER Date AR ORDER Date [datetime] NULL  
AR ORDER Due Date AR ORDER Due Date [datetime] NULL  
AR ORDER PO ID AR ORDER PO ID [nvarchar](50) NULL  
AR ORDER Tax Exempt ID AR ORDER Tax Exempt ID [nvarchar](20) NULL  
AR ORDER Tax Group AR ORDER Tax Group [nvarchar](20) NULL  
AR ORDER Customer ID AR ORDER Customer ID [nvarchar](8) NULL  
AR ORDER Bill To AR ORDER Bill To [nvarchar](1000) NULL  
AR ORDER Billing Customer AR ORDER Billing Customer [nvarchar](50) NULL  
AR ORDER Billing Address 1 AR ORDER Billing Address 1 [nvarchar](30) NULL  
AR ORDER Billing Address 2 AR ORDER Billing Address 2 [nvarchar](30) NULL  
AR ORDER Billing City AR ORDER Billing City [nvarchar](20) NULL  
AR ORDER Billing State AR ORDER Billing State [nvarchar](5) NULL  
AR ORDER Billing Postal AR ORDER Billing Postal [nvarchar](20) NULL  
AR ORDER Billing Country AR ORDER Billing Country [nvarchar](50) NULL  
AR ORDER Ship Date AR ORDER Ship Date [datetime] NULL  
AR ORDER Shipping ID AR ORDER Shipping ID [nvarchar](8) NULL  
AR ORDER Ship To AR ORDER Ship To [nvarchar](1000) NULL  
AR ORDER Shipping Customer AR ORDER Shipping Customer [nvarchar](50) NULL  
AR ORDER Shipping Address 1 AR ORDER Shipping Address 1 [nvarchar](30) NULL  
AR ORDER Shipping Address 2 AR ORDER Shipping Address 2 [nvarchar](30) NULL  
AR ORDER Shipping City AR ORDER Shipping City [nvarchar](20) NULL  
AR ORDER Shipping State AR ORDER Shipping State [nvarchar](5) NULL  
AR ORDER Shipping Postal AR ORDER Shipping Postal [nvarchar](20) NULL  
AR ORDER Shipping Country AR ORDER Shipping Country [nvarchar](50) NULL  
AR ORDER Shipping Method AR ORDER Shipping Method [nvarchar](30) NULL  
AR ORDER Salesperson AR ORDER Salesperson [nvarchar](20) NULL  
AR ORDER Payment Terms AR ORDER Payment Terms [nvarchar](20) NULL  
AR ORDER Payment Method AR ORDER Payment Method [nvarchar](20) NULL  
AR ORDER Subtotal AR ORDER Subtotal [money] NULL  
AR ORDER Discount Percent AR ORDER Discount Percent [float] NULL  
AR ORDER Discount Amount AR ORDER Discount Amount [money] NULL  
AR ORDER Tax Percent AR ORDER Tax Percent [float] NULL  
AR ORDER Sales Tax AR ORDER Sales Tax [money] NULL  
AR ORDER Freight AR ORDER Freight [money] NULL  
AR ORDER Total AR ORDER Total [money] NULL  
AR ORDER Amount Paid AR ORDER Amount Paid [money] NULL  
AR ORDER Balance Due AR ORDER Balance Due [money] NULL  
AR ORDER Undistributed Amt AR ORDER Undistributed Amt [money] NULL  
AR ORDER Commission AR ORDER Commission [money] NULL  
AR ORDER Commissionable Sales AR ORDER Commissionable Sales [money] NULL  
AR ORDER Commissionable Cost AR ORDER Commissionable Cost [money] NULL  
AR ORDER Description AR ORDER Description [nvarchar](150) NULL  
AR ORDER Message AR ORDER Message [nvarchar](50) NULL  
AR ORDER Apply to Number AR ORDER Apply to Number [nvarchar](20) NULL  
AR ORDER Check Number AR ORDER Check Number [nvarchar](50) NULL  
AR ORDER Check Acct ID AR ORDER Check Acct ID [nvarchar](8) NULL  
AR ORDER Check Date AR ORDER Check Date [datetime] NULL  
AR ORDER Quote Document # AR ORDER Quote Document # [int] NULL  
AR ORDER Notes AR ORDER Notes [nvarchar](500) NULL  
AR ORDER Department AR ORDER Department [nvarchar](5) NULL  
AR ORDER Taxable Subtotal AR ORDER Taxable Subtotal [money] NULL  
AR ORDER Tax Freight AR ORDER Tax Freight [bit] NOT NULL  
AR ORDER Recurring YN AR ORDER Recurring YN [bit] NOT NULL  
AR ORDER Cleared AR ORDER Cleared [bit] NOT NULL  
AR ORDER Recur Type AR ORDER Recur Type [nvarchar](50) NULL  
AR ORDER Next Recur AR ORDER Next Recur [datetime] NULL  
AR ORDER Invoiced AR ORDER Invoiced [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Order Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Order Detail] (
	[AR ORDERD ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR ORDERD Document #] [int] NULL ,
	[AR ORDERD Qty] [float] NULL ,
	[AR ORDERD Qty To Invoice] [float] NULL ,
	[AR ORDERD Qty Backordered] [float] NULL ,
	[AR ORDERD BackOrdered] [bit] NOT NULL ,
	[AR ORDERD Date] [datetime] NULL ,
	[AR ORDERD Item Id] [nvarchar] (20 ) NULL ,
	[AR ORDERD Units] [nvarchar] (20 ) NULL ,
	[AR ORDERD Discount %] [float] NULL ,
	[AR ORDERD Tax] [bit] NOT NULL ,
	[AR ORDERD Tax Rate] [float] NULL ,
	[AR ORDERD Description] [nvarchar] (150 ) NULL ,
	[AR ORDERD Row Type] [nvarchar] () NULL ,
	[AR ORDERD Item Cost] [float] NULL ,
	[AR ORDERD Unit Price] [float] NULL ,
	[AR ORDERD Item Total] [float] NULL ,
	[AR ORDERD Posting Account] [nvarchar] (50 ) NULL ,
	[AR ORDERD Department] [nvarchar] () NULL ,
	[AR ORDERD Project] [nvarchar] () NULL ,
	[AR ORDERD Account Type] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR ORDERD ID AR ORDERD ID [int] NOT NULL  
AR ORDERD Document # AR ORDERD Document # [int] NULL  
AR ORDERD Qty AR ORDERD Qty [float] NULL  
AR ORDERD Qty To Invoice AR ORDERD Qty To Invoice [float] NULL  
AR ORDERD Qty Backordered AR ORDERD Qty Backordered [float] NULL  
AR ORDERD BackOrdered AR ORDERD BackOrdered [bit] NOT NULL  
AR ORDERD Date AR ORDERD Date [datetime] NULL  
AR ORDERD Item Id AR ORDERD Item Id [nvarchar](20) NULL  
AR ORDERD Units AR ORDERD Units [nvarchar](20) NULL  
AR ORDERD Discount % AR ORDERD Discount % [float] NULL  
AR ORDERD Tax AR ORDERD Tax [bit] NOT NULL  
AR ORDERD Tax Rate AR ORDERD Tax Rate [float] NULL  
AR ORDERD Description AR ORDERD Description [nvarchar](150) NULL  
AR ORDERD Row Type AR ORDERD Row Type [nvarchar](1) NULL  
AR ORDERD Item Cost AR ORDERD Item Cost [float] NULL  
AR ORDERD Unit Price AR ORDERD Unit Price [float] NULL  
AR ORDERD Item Total AR ORDERD Item Total [float] NULL  
AR ORDERD Posting Account AR ORDERD Posting Account [nvarchar](50) NULL  
AR ORDERD Department AR ORDERD Department [nvarchar](5) NULL  
AR ORDERD Project AR ORDERD Project [nvarchar](8) NULL  
AR ORDERD Account Type AR ORDERD Account Type [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Order Tracking
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Order Tracking] (
	[Order ID] [int] NULL ,
	[Invoice ID] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Order ID Order ID [int] NULL  
Invoice ID Invoice ID [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Payment Header
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Payment Header] (
	[AR PAY ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR PAY Type] [nvarchar] (20 ) NULL ,
	[AR PAY Check No] [nvarchar] (50 ) NULL ,
	[AR PAY Customer No] [nvarchar] () NULL ,
	[AR PAY Transaction Date] [datetime] NULL ,
	[AR PAY Amount] [money] NULL ,
	[AR PAY UnApplied Amount] [money] NULL ,
	[AR PAY Bank Account] [nvarchar] (50 ) NULL ,
	[AR PAY Status] [nvarchar] (10 ) NULL ,
	[AR PAY NSF] [bit] NOT NULL ,
	[AR PAY Notes] [nvarchar] (2000 ) NULL ,
	[AR PAY Credit Amount] [money] NULL ,
	[AR PAY Class] [nvarchar] (20 ) NULL ,
	[AR PAY Cleared] [bit] NOT NULL ,
	[AR PAY Posted YN] [bit] NOT NULL ,
	[AR PAY Reconciled] [bit] NOT NULL ,
	[AR PAY Deposited YN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR PAY ID AR PAY ID [int] NOT NULL  
AR PAY Type AR PAY Type [nvarchar](20) NULL  
AR PAY Check No AR PAY Check No [nvarchar](50) NULL  
AR PAY Customer No AR PAY Customer No [nvarchar](8) NULL  
AR PAY Transaction Date AR PAY Transaction Date [datetime] NULL  
AR PAY Amount AR PAY Amount [money] NULL  
AR PAY UnApplied Amount AR PAY UnApplied Amount [money] NULL  
AR PAY Bank Account AR PAY Bank Account [nvarchar](50) NULL  
AR PAY Status AR PAY Status [nvarchar](10) NULL  
AR PAY NSF AR PAY NSF [bit] NOT NULL  
AR PAY Notes AR PAY Notes [nvarchar](2000) NULL  
AR PAY Credit Amount AR PAY Credit Amount [money] NULL  
AR PAY Class AR PAY Class [nvarchar](20) NULL  
AR PAY Cleared AR PAY Cleared [bit] NOT NULL  
AR PAY Posted YN AR PAY Posted YN [bit] NOT NULL  
AR PAY Reconciled AR PAY Reconciled [bit] NOT NULL  
AR PAY Deposited YN AR PAY Deposited YN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Payment Invoice Cross Reference
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Payment Invoice Cross Reference] (
	[AR CROSS ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR CROSS Payment ID] [int] NULL ,
	[AR CROSS Payed ID] [int] NULL ,
	[AR CROSS Discount Taken] [money] NULL ,
	[AR CROSS Write Off Amount] [money] NULL ,
	[AR CROSS Applied Amount] [money] NULL ,
	[AR CROSS Cleared] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR CROSS ID AR CROSS ID [int] NOT NULL  
AR CROSS Payment ID AR CROSS Payment ID [int] NULL  
AR CROSS Payed ID AR CROSS Payed ID [int] NULL  
AR CROSS Discount Taken AR CROSS Discount Taken [money] NULL  
AR CROSS Write Off Amount AR CROSS Write Off Amount [money] NULL  
AR CROSS Applied Amount AR CROSS Applied Amount [money] NULL  
AR CROSS Cleared AR CROSS Cleared [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Sales
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Sales] (
	[AR SALE Document #] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR SALE Ext Document #] [nvarchar] (20 ) NULL ,
	[AR SALE Document Type] [nvarchar] (20 ) NULL ,
	[AR SALE Saved YN] [bit] NOT NULL ,
	[AR SALE Posted YN] [bit] NOT NULL ,
	[AR SALE Service YN] [smallint] NULL ,
	[AR SALE Date] [datetime] NULL ,
	[AR SALE Due Date] [datetime] NULL ,
	[AR SALE PO ID] [nvarchar] (50 ) NULL ,
	[AR SALE Tax Exempt ID] [nvarchar] (20 ) NULL ,
	[AR SALE Tax Group] [nvarchar] (20 ) NULL ,
	[AR SALE Customer ID] [nvarchar] () NULL ,
	[AR SALE Bill To] [nvarchar] (50 ) NULL ,
	[AR SALE Billing Customer] [nvarchar] (50 ) NULL ,
	[AR SALE Billing Address 1] [nvarchar] (30 ) NULL ,
	[AR SALE Billing Address 2] [nvarchar] (30 ) NULL ,
	[AR SALE Billing City] [nvarchar] (20 ) NULL ,
	[AR SALE Billing State] [nvarchar] () NULL ,
	[AR SALE Billing Postal] [nvarchar] (20 ) NULL ,
	[AR SALE Billing Country] [nvarchar] (50 ) NULL ,
	[AR SALE Ship Date] [datetime] NULL ,
	[AR SALE Shipping ID] [nvarchar] () NULL ,
	[AR SALE Ship To] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Customer] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Address 1] [nvarchar] (30 ) NULL ,
	[AR SALE Shipping Address 2] [nvarchar] (30 ) NULL ,
	[AR SALE Shipping City] [nvarchar] (20 ) NULL ,
	[AR SALE Shipping State] [nvarchar] () NULL ,
	[AR SALE Shipping Postal] [nvarchar] (20 ) NULL ,
	[AR SALE Shipping Country] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Method] [nvarchar] (30 ) NULL ,
	[AR SALE Salesperson] [nvarchar] (20 ) NULL ,
	[AR SALE Payment Terms] [nvarchar] (20 ) NULL ,
	[AR SALE Payment Method] [nvarchar] (20 ) NULL ,
	[AR SALE Subtotal] [money] NULL ,
	[AR SALE Discount Percent] [float] NULL ,
	[AR SALE Discount Amount] [money] NULL ,
	[AR SALE Tax Percent] [float] NULL ,
	[AR SALE Sales Tax] [money] NULL ,
	[AR SALE Freight] [money] NULL ,
	[AR SALE Total] [money] NULL ,
	[AR SALE Amount Paid] [money] NULL ,
	[AR SALE Balance Due] [money] NULL ,
	[AR SALE Undistributed Amt] [money] NULL ,
	[AR SALE Commission] [money] NULL ,
	[AR SALE Commissionable Sales] [money] NULL ,
	[AR SALE Commissionable Cost] [money] NULL ,
	[AR SALE Description] [nvarchar] (50 ) NULL ,
	[AR SALE Message] [nvarchar] (50 ) NULL ,
	[AR SALE Apply to Number] [nvarchar] (20 ) NULL ,
	[AR SALE Check Number] [nvarchar] (50 ) NULL ,
	[AR SALE Check Acct ID] [nvarchar] (50 ) NULL ,
	[AR SALE Check Date] [datetime] NULL ,
	[AR SALE Quote Document #] [int] NULL ,
	[AR SALE Notes] [nvarchar] (1000 ) NULL ,
	[AR SALE Department] [nvarchar] () NULL ,
	[AR SALE Taxable Subtotal] [money] NULL ,
	[AR SALE Tax Freight] [bit] NOT NULL ,
	[AR SALE Recurring YN] [bit] NOT NULL ,
	[AR SALE Cleared] [bit] NOT NULL ,
	[AR SALE Recur Type] [nvarchar] (50 ) NULL ,
	[AR SALE Next Recur] [datetime] NULL ,
	[AR SALE Commission Paid] [bit] NOT NULL ,
	[AR SALE Select To Pay] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR SALE Document # AR SALE Document # [int] NOT NULL  
AR SALE Ext Document # AR SALE Ext Document # [nvarchar](20) NULL  
AR SALE Document Type AR SALE Document Type [nvarchar](20) NULL  
AR SALE Saved YN AR SALE Saved YN [bit] NOT NULL  
AR SALE Posted YN AR SALE Posted YN [bit] NOT NULL  
AR SALE Service YN AR SALE Service YN [smallint] NULL  
AR SALE Date AR SALE Date [datetime] NULL  
AR SALE Due Date AR SALE Due Date [datetime] NULL  
AR SALE PO ID AR SALE PO ID [nvarchar](50) NULL  
AR SALE Tax Exempt ID AR SALE Tax Exempt ID [nvarchar](20) NULL  
AR SALE Tax Group AR SALE Tax Group [nvarchar](20) NULL  
AR SALE Customer ID AR SALE Customer ID [nvarchar](8) NULL  
AR SALE Bill To AR SALE Bill To [nvarchar](50) NULL  
AR SALE Billing Customer AR SALE Billing Customer [nvarchar](50) NULL  
AR SALE Billing Address 1 AR SALE Billing Address 1 [nvarchar](30) NULL  
AR SALE Billing Address 2 AR SALE Billing Address 2 [nvarchar](30) NULL  
AR SALE Billing City AR SALE Billing City [nvarchar](20) NULL  
AR SALE Billing State AR SALE Billing State [nvarchar](5) NULL  
AR SALE Billing Postal AR SALE Billing Postal [nvarchar](20) NULL  
AR SALE Billing Country AR SALE Billing Country [nvarchar](50) NULL  
AR SALE Ship Date AR SALE Ship Date [datetime] NULL  
AR SALE Shipping ID AR SALE Shipping ID [nvarchar](8) NULL  
AR SALE Ship To AR SALE Ship To [nvarchar](50) NULL  
AR SALE Shipping Customer AR SALE Shipping Customer [nvarchar](50) NULL  
AR SALE Shipping Address 1 AR SALE Shipping Address 1 [nvarchar](30) NULL  
AR SALE Shipping Address 2 AR SALE Shipping Address 2 [nvarchar](30) NULL  
AR SALE Shipping City AR SALE Shipping City [nvarchar](20) NULL  
AR SALE Shipping State AR SALE Shipping State [nvarchar](5) NULL  
AR SALE Shipping Postal AR SALE Shipping Postal [nvarchar](20) NULL  
AR SALE Shipping Country AR SALE Shipping Country [nvarchar](50) NULL  
AR SALE Shipping Method AR SALE Shipping Method [nvarchar](30) NULL  
AR SALE Salesperson AR SALE Salesperson [nvarchar](20) NULL  
AR SALE Payment Terms AR SALE Payment Terms [nvarchar](20) NULL  
AR SALE Payment Method AR SALE Payment Method [nvarchar](20) NULL  
AR SALE Subtotal AR SALE Subtotal [money] NULL  
AR SALE Discount Percent AR SALE Discount Percent [float] NULL  
AR SALE Discount Amount AR SALE Discount Amount [money] NULL  
AR SALE Tax Percent AR SALE Tax Percent [float] NULL  
AR SALE Sales Tax AR SALE Sales Tax [money] NULL  
AR SALE Freight AR SALE Freight [money] NULL  
AR SALE Total AR SALE Total [money] NULL  
AR SALE Amount Paid AR SALE Amount Paid [money] NULL  
AR SALE Balance Due AR SALE Balance Due [money] NULL  
AR SALE Undistributed Amt AR SALE Undistributed Amt [money] NULL  
AR SALE Commission AR SALE Commission [money] NULL  
AR SALE Commissionable Sales AR SALE Commissionable Sales [money] NULL  
AR SALE Commissionable Cost AR SALE Commissionable Cost [money] NULL  
AR SALE Description AR SALE Description [nvarchar](50) NULL  
AR SALE Message AR SALE Message [nvarchar](50) NULL  
AR SALE Apply to Number AR SALE Apply to Number [nvarchar](20) NULL  
AR SALE Check Number AR SALE Check Number [nvarchar](50) NULL  
AR SALE Check Acct ID AR SALE Check Acct ID [nvarchar](50) NULL  
AR SALE Check Date AR SALE Check Date [datetime] NULL  
AR SALE Quote Document # AR SALE Quote Document # [int] NULL  
AR SALE Notes AR SALE Notes [nvarchar](1000) NULL  
AR SALE Department AR SALE Department [nvarchar](5) NULL  
AR SALE Taxable Subtotal AR SALE Taxable Subtotal [money] NULL  
AR SALE Tax Freight AR SALE Tax Freight [bit] NOT NULL  
AR SALE Recurring YN AR SALE Recurring YN [bit] NOT NULL  
AR SALE Cleared AR SALE Cleared [bit] NOT NULL  
AR SALE Recur Type AR SALE Recur Type [nvarchar](50) NULL  
AR SALE Next Recur AR SALE Next Recur [datetime] NULL  
AR SALE Commission Paid AR SALE Commission Paid [bit] NOT NULL  
AR SALE Select To Pay AR SALE Select To Pay [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Sales Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Sales Detail] (
	[AR SALED ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[AR SALED Document #] [int] NULL ,
	[AR SALED Qty] [float] NULL ,
	[AR SALED Date] [datetime] NULL ,
	[AR SALED Item Id] [nvarchar] (20 ) NULL ,
	[AR SALED Units] [nvarchar] (20 ) NULL ,
	[AR SALED Discount %] [float] NULL ,
	[AR SALED Tax] [bit] NOT NULL ,
	[AR SALED Tax Rate] [float] NULL ,
	[AR SALED Description] [nvarchar] (255 ) NULL ,
	[AR SALED Row Type] [nvarchar] () NULL ,
	[AR SALED Item Cost] [float] NULL ,
	[AR SALED Unit Price] [float] NULL ,
	[AR SALED Item Total] [float] NULL ,
	[AR SALED Posting Account] [nvarchar] (50 ) NULL ,
	[AR SALED Department] [nvarchar] () NULL ,
	[AR SALED Project] [nvarchar] () NULL ,
	[AR SALED Account Type] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR SALED ID AR SALED ID [int] NOT NULL  
AR SALED Document # AR SALED Document # [int] NULL  
AR SALED Qty AR SALED Qty [float] NULL  
AR SALED Date AR SALED Date [datetime] NULL  
AR SALED Item Id AR SALED Item Id [nvarchar](20) NULL  
AR SALED Units AR SALED Units [nvarchar](20) NULL  
AR SALED Discount % AR SALED Discount % [float] NULL  
AR SALED Tax AR SALED Tax [bit] NOT NULL  
AR SALED Tax Rate AR SALED Tax Rate [float] NULL  
AR SALED Description AR SALED Description [nvarchar](255) NULL  
AR SALED Row Type AR SALED Row Type [nvarchar](1) NULL  
AR SALED Item Cost AR SALED Item Cost [float] NULL  
AR SALED Unit Price AR SALED Unit Price [float] NULL  
AR SALED Item Total AR SALED Item Total [float] NULL  
AR SALED Posting Account AR SALED Posting Account [nvarchar](50) NULL  
AR SALED Department AR SALED Department [nvarchar](5) NULL  
AR SALED Project AR SALED Project [nvarchar](8) NULL  
AR SALED Account Type AR SALED Account Type [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Sales Tax Report1
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Sales Tax Report1] (
	[AR SALE Document #] [int] NOT NULL ,
	[AR SALE Ext Document #] [nvarchar] (20 ) NULL ,
	[AR SALE Document Type] [nvarchar] (20 ) NULL ,
	[AR SALE Saved YN] [bit] NOT NULL ,
	[AR SALE Posted YN] [bit] NOT NULL ,
	[AR SALE Service YN] [smallint] NULL ,
	[AR SALE Date] [datetime] NULL ,
	[AR SALE Due Date] [datetime] NULL ,
	[AR SALE PO ID] [nvarchar] (50 ) NULL ,
	[AR SALE Tax Exempt ID] [nvarchar] (20 ) NULL ,
	[AR SALE Tax Group] [nvarchar] (20 ) NULL ,
	[AR SALE Customer ID] [nvarchar] () NULL ,
	[AR SALE Bill To] [nvarchar] (50 ) NULL ,
	[AR SALE Billing Customer] [nvarchar] (50 ) NULL ,
	[AR SALE Billing Address 1] [nvarchar] (30 ) NULL ,
	[AR SALE Billing Address 2] [nvarchar] (30 ) NULL ,
	[AR SALE Billing City] [nvarchar] (20 ) NULL ,
	[AR SALE Billing State] [nvarchar] () NULL ,
	[AR SALE Billing Postal] [nvarchar] (20 ) NULL ,
	[AR SALE Billing Country] [nvarchar] (50 ) NULL ,
	[AR SALE Ship Date] [datetime] NULL ,
	[AR SALE Shipping ID] [nvarchar] () NULL ,
	[AR SALE Ship To] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Customer] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Address 1] [nvarchar] (30 ) NULL ,
	[AR SALE Shipping Address 2] [nvarchar] (30 ) NULL ,
	[AR SALE Shipping City] [nvarchar] (20 ) NULL ,
	[AR SALE Shipping State] [nvarchar] () NULL ,
	[AR SALE Shipping Postal] [nvarchar] (20 ) NULL ,
	[AR SALE Shipping Country] [nvarchar] (50 ) NULL ,
	[AR SALE Shipping Method] [nvarchar] (30 ) NULL ,
	[AR SALE Salesperson] [nvarchar] (20 ) NULL ,
	[AR SALE Payment Terms] [nvarchar] (20 ) NULL ,
	[AR SALE Payment Method] [nvarchar] (20 ) NULL ,
	[AR SALE Subtotal] [money] NULL ,
	[AR SALE Discount Percent] [float] NULL ,
	[AR SALE Discount Amount] [money] NULL ,
	[AR SALE Tax Percent] [float] NULL ,
	[AR SALE Sales Tax] [money] NULL ,
	[AR SALE Freight] [money] NULL ,
	[AR SALE Total] [money] NULL ,
	[AR SALE Amount Paid] [money] NULL ,
	[AR SALE Balance Due] [money] NULL ,
	[AR SALE Undistributed Amt] [money] NULL ,
	[AR SALE Commission] [money] NULL ,
	[AR SALE Commissionable Sales] [money] NULL ,
	[AR SALE Commissionable Cost] [money] NULL ,
	[AR SALE Description] [nvarchar] (50 ) NULL ,
	[AR SALE Message] [nvarchar] (50 ) NULL ,
	[AR SALE Apply to Number] [nvarchar] (20 ) NULL ,
	[AR SALE Check Number] [nvarchar] (50 ) NULL ,
	[AR SALE Check Acct ID] [nvarchar] (50 ) NULL ,
	[AR SALE Check Date] [datetime] NULL ,
	[AR SALE Quote Document #] [int] NULL ,
	[AR SALE Notes] [nvarchar] (1000 ) NULL ,
	[AR SALE Department] [nvarchar] () NULL ,
	[AR SALE Taxable Subtotal] [money] NULL ,
	[AR SALE Tax Freight] [bit] NOT NULL ,
	[AR SALE Recurring YN] [bit] NOT NULL ,
	[AR SALE Cleared] [bit] NOT NULL ,
	[Taxable] [money] NULL ,
	[Tax] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR SALE Document # AR SALE Document # [int] NOT NULL  
AR SALE Ext Document # AR SALE Ext Document # [nvarchar](20) NULL  
AR SALE Document Type AR SALE Document Type [nvarchar](20) NULL  
AR SALE Saved YN AR SALE Saved YN [bit] NOT NULL  
AR SALE Posted YN AR SALE Posted YN [bit] NOT NULL  
AR SALE Service YN AR SALE Service YN [smallint] NULL  
AR SALE Date AR SALE Date [datetime] NULL  
AR SALE Due Date AR SALE Due Date [datetime] NULL  
AR SALE PO ID AR SALE PO ID [nvarchar](50) NULL  
AR SALE Tax Exempt ID AR SALE Tax Exempt ID [nvarchar](20) NULL  
AR SALE Tax Group AR SALE Tax Group [nvarchar](20) NULL  
AR SALE Customer ID AR SALE Customer ID [nvarchar](8) NULL  
AR SALE Bill To AR SALE Bill To [nvarchar](50) NULL  
AR SALE Billing Customer AR SALE Billing Customer [nvarchar](50) NULL  
AR SALE Billing Address 1 AR SALE Billing Address 1 [nvarchar](30) NULL  
AR SALE Billing Address 2 AR SALE Billing Address 2 [nvarchar](30) NULL  
AR SALE Billing City AR SALE Billing City [nvarchar](20) NULL  
AR SALE Billing State AR SALE Billing State [nvarchar](5) NULL  
AR SALE Billing Postal AR SALE Billing Postal [nvarchar](20) NULL  
AR SALE Billing Country AR SALE Billing Country [nvarchar](50) NULL  
AR SALE Ship Date AR SALE Ship Date [datetime] NULL  
AR SALE Shipping ID AR SALE Shipping ID [nvarchar](8) NULL  
AR SALE Ship To AR SALE Ship To [nvarchar](50) NULL  
AR SALE Shipping Customer AR SALE Shipping Customer [nvarchar](50) NULL  
AR SALE Shipping Address 1 AR SALE Shipping Address 1 [nvarchar](30) NULL  
AR SALE Shipping Address 2 AR SALE Shipping Address 2 [nvarchar](30) NULL  
AR SALE Shipping City AR SALE Shipping City [nvarchar](20) NULL  
AR SALE Shipping State AR SALE Shipping State [nvarchar](5) NULL  
AR SALE Shipping Postal AR SALE Shipping Postal [nvarchar](20) NULL  
AR SALE Shipping Country AR SALE Shipping Country [nvarchar](50) NULL  
AR SALE Shipping Method AR SALE Shipping Method [nvarchar](30) NULL  
AR SALE Salesperson AR SALE Salesperson [nvarchar](20) NULL  
AR SALE Payment Terms AR SALE Payment Terms [nvarchar](20) NULL  
AR SALE Payment Method AR SALE Payment Method [nvarchar](20) NULL  
AR SALE Subtotal AR SALE Subtotal [money] NULL  
AR SALE Discount Percent AR SALE Discount Percent [float] NULL  
AR SALE Discount Amount AR SALE Discount Amount [money] NULL  
AR SALE Tax Percent AR SALE Tax Percent [float] NULL  
AR SALE Sales Tax AR SALE Sales Tax [money] NULL  
AR SALE Freight AR SALE Freight [money] NULL  
AR SALE Total AR SALE Total [money] NULL  
AR SALE Amount Paid AR SALE Amount Paid [money] NULL  
AR SALE Balance Due AR SALE Balance Due [money] NULL  
AR SALE Undistributed Amt AR SALE Undistributed Amt [money] NULL  
AR SALE Commission AR SALE Commission [money] NULL  
AR SALE Commissionable Sales AR SALE Commissionable Sales [money] NULL  
AR SALE Commissionable Cost AR SALE Commissionable Cost [money] NULL  
AR SALE Description AR SALE Description [nvarchar](50) NULL  
AR SALE Message AR SALE Message [nvarchar](50) NULL  
AR SALE Apply to Number AR SALE Apply to Number [nvarchar](20) NULL  
AR SALE Check Number AR SALE Check Number [nvarchar](50) NULL  
AR SALE Check Acct ID AR SALE Check Acct ID [nvarchar](50) NULL  
AR SALE Check Date AR SALE Check Date [datetime] NULL  
AR SALE Quote Document # AR SALE Quote Document # [int] NULL  
AR SALE Notes AR SALE Notes [nvarchar](1000) NULL  
AR SALE Department AR SALE Department [nvarchar](5) NULL  
AR SALE Taxable Subtotal AR SALE Taxable Subtotal [money] NULL  
AR SALE Tax Freight AR SALE Tax Freight [bit] NOT NULL  
AR SALE Recurring YN AR SALE Recurring YN [bit] NOT NULL  
AR SALE Cleared AR SALE Cleared [bit] NOT NULL  
Taxable Taxable [money] NULL  
Tax Tax [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


AR Ship To
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[AR Ship To] (
	[AR SHIP ID] [nvarchar] (10 ) NULL ,
	[AR SHIP Customer ID] [nvarchar] () NULL ,
	[AR SHIP Default] [bit] NOT NULL ,
	[AR SHIP Name] [nvarchar] (50 ) NULL ,
	[AR SHIP Address 1] [nvarchar] (30 ) NULL ,
	[AR SHIP Address 2] [nvarchar] (30 ) NULL ,
	[AR SHIP City] [nvarchar] (20 ) NULL ,
	[AR SHIP State] [nvarchar] () NULL ,
	[AR SHIP Postal] [nvarchar] (20 ) NULL ,
	[AR SHIP Phone] [nvarchar] (20 ) NULL ,
	[AR SHIP Fax] [nvarchar] (20 ) NULL ,
	[AR SHIP Country] [nvarchar] (20 ) NULL ,
	[AR SHIP Phone Ext] [nvarchar] (10 ) NULL ,
	[AR SHIP Contact] [nvarchar] (30 ) NULL ,
	[AR SHIP Notes] [nvarchar] (2000 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AR SHIP ID AR SHIP ID [nvarchar](10) NULL  
AR SHIP Customer ID AR SHIP Customer ID [nvarchar](8) NULL  
AR SHIP Default AR SHIP Default [bit] NOT NULL  
AR SHIP Name AR SHIP Name [nvarchar](50) NULL  
AR SHIP Address 1 AR SHIP Address 1 [nvarchar](30) NULL  
AR SHIP Address 2 AR SHIP Address 2 [nvarchar](30) NULL  
AR SHIP City AR SHIP City [nvarchar](20) NULL  
AR SHIP State AR SHIP State [nvarchar](5) NULL  
AR SHIP Postal AR SHIP Postal [nvarchar](20) NULL  
AR SHIP Phone AR SHIP Phone [nvarchar](20) NULL  
AR SHIP Fax AR SHIP Fax [nvarchar](20) NULL  
AR SHIP Country AR SHIP Country [nvarchar](20) NULL  
AR SHIP Phone Ext AR SHIP Phone Ext [nvarchar](10) NULL  
AR SHIP Contact AR SHIP Contact [nvarchar](30) NULL  
AR SHIP Notes AR SHIP Notes [nvarchar](2000) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Accounts
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Accounts] (
	[BANK ACCT ID] [nvarchar] (50 ) NOT NULL ,
	[BANK ACCT Number] [nvarchar] (20 ) NULL ,
	[BANK ACCT Name] [nvarchar] (50 ) NULL ,
	[BANK ACCT Address 1] [nvarchar] (30 ) NULL ,
	[BANK ACCT Address 2] [nvarchar] (30 ) NULL ,
	[BANK ACCT City] [nvarchar] (20 ) NULL ,
	[BANK ACCT State] [nvarchar] () NULL ,
	[BANK ACCT Postal] [nvarchar] (20 ) NULL ,
	[BANK ACCT Country] [nvarchar] (20 ) NULL ,
	[BANK ACCT Phone] [nvarchar] (20 ) NULL ,
	[BANK ACCT Fax] [nvarchar] (20 ) NULL ,
	[BANK ACCT Officer] [nvarchar] (20 ) NULL ,
	[BANK ACCT Next Check No] [int] NULL ,
	[BANK ACCT Next Deposit No] [int] NULL ,
	[BANK ACCT Notes] [nvarchar] (2000 ) NULL ,
	[BANK ACCT Default] [bit] NOT NULL ,
	[BANK ACCT Saved] [smallint] NULL ,
	[BANK ACCT GL Cash Acct] [int] NULL ,
	[BANK ACCT Balance] [float] NULL ,
	[BANK ACCT Unposted Deposits] [float] NULL ,
	[BANK ACCT Custom 1] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 2] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 3] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 4] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 5] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 6] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 7] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 8] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 9] [nvarchar] (50 ) NULL ,
	[BANK ACCT Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK ACCT ID BANK ACCT ID [nvarchar](50) NOT NULL  
BANK ACCT Number BANK ACCT Number [nvarchar](20) NULL  
BANK ACCT Name BANK ACCT Name [nvarchar](50) NULL  
BANK ACCT Address 1 BANK ACCT Address 1 [nvarchar](30) NULL  
BANK ACCT Address 2 BANK ACCT Address 2 [nvarchar](30) NULL  
BANK ACCT City BANK ACCT City [nvarchar](20) NULL  
BANK ACCT State BANK ACCT State [nvarchar](5) NULL  
BANK ACCT Postal BANK ACCT Postal [nvarchar](20) NULL  
BANK ACCT Country BANK ACCT Country [nvarchar](20) NULL  
BANK ACCT Phone BANK ACCT Phone [nvarchar](20) NULL  
BANK ACCT Fax BANK ACCT Fax [nvarchar](20) NULL  
BANK ACCT Officer BANK ACCT Officer [nvarchar](20) NULL  
BANK ACCT Next Check No BANK ACCT Next Check No [int] NULL  
BANK ACCT Next Deposit No BANK ACCT Next Deposit No [int] NULL  
BANK ACCT Notes BANK ACCT Notes [nvarchar](2000) NULL  
BANK ACCT Default BANK ACCT Default [bit] NOT NULL  
BANK ACCT Saved BANK ACCT Saved [smallint] NULL  
BANK ACCT GL Cash Acct BANK ACCT GL Cash Acct [int] NULL  
BANK ACCT Balance BANK ACCT Balance [float] NULL  
BANK ACCT Unposted Deposits BANK ACCT Unposted Deposits [float] NULL  
BANK ACCT Custom 1 BANK ACCT Custom 1 [nvarchar](50) NULL  
BANK ACCT Custom 2 BANK ACCT Custom 2 [nvarchar](50) NULL  
BANK ACCT Custom 3 BANK ACCT Custom 3 [nvarchar](50) NULL  
BANK ACCT Custom 4 BANK ACCT Custom 4 [nvarchar](50) NULL  
BANK ACCT Custom 5 BANK ACCT Custom 5 [nvarchar](50) NULL  
BANK ACCT Custom 6 BANK ACCT Custom 6 [nvarchar](50) NULL  
BANK ACCT Custom 7 BANK ACCT Custom 7 [nvarchar](50) NULL  
BANK ACCT Custom 8 BANK ACCT Custom 8 [nvarchar](50) NULL  
BANK ACCT Custom 9 BANK ACCT Custom 9 [nvarchar](50) NULL  
BANK ACCT Custom 10 BANK ACCT Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Reconciliation
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Reconciliation] (
	[BANK REC Bank Acct] [nvarchar] (50 ) NOT NULL ,
	[BANK REC Start Date] [datetime] NULL ,
	[BANK REC Cutoff Date] [datetime] NULL ,
	[BANK REC Ending Balance] [money] NULL ,
	[BANK REC Service Charge] [money] NULL ,
	[BANK REC Service Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Interest] [money] NULL ,
	[BANK REC Interest Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Other] [nvarchar] (50 ) NULL ,
	[BANK REC Other Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Notes] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK REC Bank Acct BANK REC Bank Acct [nvarchar](50) NOT NULL  
BANK REC Start Date BANK REC Start Date [datetime] NULL  
BANK REC Cutoff Date BANK REC Cutoff Date [datetime] NULL  
BANK REC Ending Balance BANK REC Ending Balance [money] NULL  
BANK REC Service Charge BANK REC Service Charge [money] NULL  
BANK REC Service Acct BANK REC Service Acct [nvarchar](50) NULL  
BANK REC Interest BANK REC Interest [money] NULL  
BANK REC Interest Acct BANK REC Interest Acct [nvarchar](50) NULL  
BANK REC Other BANK REC Other [nvarchar](50) NULL  
BANK REC Other Acct BANK REC Other Acct [nvarchar](50) NULL  
BANK REC Notes BANK REC Notes [ntext] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Reconciliation Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Reconciliation Detail] (
	[BANK RECD Doc #] [nvarchar] (50 ) NULL ,
	[BANK RECD Cleared] [bit] NOT NULL ,
	[BANK RECD Date] [datetime] NULL ,
	[BANK RECD Description] [nvarchar] (50 ) NULL ,
	[BANK RECD Type] [nvarchar] (50 ) NULL ,
	[BANK RECD Amount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK RECD Doc # BANK RECD Doc # [nvarchar](50) NULL  
BANK RECD Cleared BANK RECD Cleared [bit] NOT NULL  
BANK RECD Date BANK RECD Date [datetime] NULL  
BANK RECD Description BANK RECD Description [nvarchar](50) NULL  
BANK RECD Type BANK RECD Type [nvarchar](50) NULL  
BANK RECD Amount BANK RECD Amount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Reconciliation Detail Credits
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Reconciliation Detail Credits] (
	[BANK RECD Doc #] [nvarchar] (50 ) NULL ,
	[BANK RECD Cleared] [bit] NOT NULL ,
	[BANK RECD Date] [datetime] NULL ,
	[BANK RECD Description] [nvarchar] (50 ) NULL ,
	[BANK RECD Type] [nvarchar] (50 ) NULL ,
	[BANK RECD Amount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK RECD Doc # BANK RECD Doc # [nvarchar](50) NULL  
BANK RECD Cleared BANK RECD Cleared [bit] NOT NULL  
BANK RECD Date BANK RECD Date [datetime] NULL  
BANK RECD Description BANK RECD Description [nvarchar](50) NULL  
BANK RECD Type BANK RECD Type [nvarchar](50) NULL  
BANK RECD Amount BANK RECD Amount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Reconciliation Detail Debits
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Reconciliation Detail Debits] (
	[BANK RECD Doc #] [nvarchar] (50 ) NULL ,
	[BANK RECD Cleared] [bit] NOT NULL ,
	[BANK RECD Date] [datetime] NULL ,
	[BANK RECD Description] [nvarchar] (50 ) NULL ,
	[BANK RECD Type] [nvarchar] (50 ) NULL ,
	[BANK RECD Amount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK RECD Doc # BANK RECD Doc # [nvarchar](50) NULL  
BANK RECD Cleared BANK RECD Cleared [bit] NOT NULL  
BANK RECD Date BANK RECD Date [datetime] NULL  
BANK RECD Description BANK RECD Description [nvarchar](50) NULL  
BANK RECD Type BANK RECD Type [nvarchar](50) NULL  
BANK RECD Amount BANK RECD Amount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Reconciliation Summary
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Reconciliation Summary] (
	[BANK REC ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[BANK REC Bank Acct] [nvarchar] (50 ) NOT NULL ,
	[BANK REC Cutoff Date] [datetime] NOT NULL ,
	[BANK REC Ending Balance] [money] NULL ,
	[BANK REC Service Charge] [money] NULL ,
	[BANK REC Service Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Interest] [money] NULL ,
	[BANK REC Interest Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Other] [nvarchar] (50 ) NULL ,
	[BANK REC Other Acct] [nvarchar] (50 ) NULL ,
	[BANK REC Notes] [ntext] NULL ,
	[BANK REC Credit Total] [money] NULL ,
	[BANK REC Debit Total] [money] NULL ,
	[BANK REC Credit OS] [money] NULL ,
	[BANK REC Debit OS] [money] NULL ,
	[BANK REC Starting Balance] [money] NULL ,
	[BANK REC Book Balance] [money] NULL ,
	[BANK Rec Diff] [money] NULL ,
	[BANK REC Ending Book Balance] [money] NULL ,
	[BANK REC Starting Bank Balance] [money] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK REC ID BANK REC ID [int] NOT NULL  
BANK REC Bank Acct BANK REC Bank Acct [nvarchar](50) NOT NULL  
BANK REC Cutoff Date BANK REC Cutoff Date [datetime] NOT NULL  
BANK REC Ending Balance BANK REC Ending Balance [money] NULL  
BANK REC Service Charge BANK REC Service Charge [money] NULL  
BANK REC Service Acct BANK REC Service Acct [nvarchar](50) NULL  
BANK REC Interest BANK REC Interest [money] NULL  
BANK REC Interest Acct BANK REC Interest Acct [nvarchar](50) NULL  
BANK REC Other BANK REC Other [nvarchar](50) NULL  
BANK REC Other Acct BANK REC Other Acct [nvarchar](50) NULL  
BANK REC Notes BANK REC Notes [ntext] NULL  
BANK REC Credit Total BANK REC Credit Total [money] NULL  
BANK REC Debit Total BANK REC Debit Total [money] NULL  
BANK REC Credit OS BANK REC Credit OS [money] NULL  
BANK REC Debit OS BANK REC Debit OS [money] NULL  
BANK REC Starting Balance BANK REC Starting Balance [money] NULL  
BANK REC Book Balance BANK REC Book Balance [money] NULL  
BANK Rec Diff BANK Rec Diff [money] NULL  
BANK REC Ending Book Balance BANK REC Ending Book Balance [money] NULL  
BANK REC Starting Bank Balance BANK REC Starting Bank Balance [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Transaction
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Transaction] (
	[BANK TRANS ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[BANK TRANS Ext Document No] [nvarchar] (50 ) NULL ,
	[BANK TRANS Bank Acct 1] [nvarchar] (50 ) NULL ,
	[BANK TRANS Bank Acct 2] [nvarchar] (50 ) NULL ,
	[BANK TRANS Type] [nvarchar] (20 ) NULL ,
	[BANK TRANS Date] [datetime] NULL ,
	[BANK TRANS Amount] [money] NULL ,
	[BANK TRANS Reference] [nvarchar] (20 ) NULL ,
	[BANK TRANS Notes] [ntext] NULL ,
	[BANK TRANS Posted YN] [bit] NOT NULL ,
	[BANK TRANS Beg Balance] [bit] NOT NULL ,
	[BANK TRANS Cleared YN] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BANK TRANS ID BANK TRANS ID [int] NOT NULL  
BANK TRANS Ext Document No BANK TRANS Ext Document No [nvarchar](50) NULL  
BANK TRANS Bank Acct 1 BANK TRANS Bank Acct 1 [nvarchar](50) NULL  
BANK TRANS Bank Acct 2 BANK TRANS Bank Acct 2 [nvarchar](50) NULL  
BANK TRANS Type BANK TRANS Type [nvarchar](20) NULL  
BANK TRANS Date BANK TRANS Date [datetime] NULL  
BANK TRANS Amount BANK TRANS Amount [money] NULL  
BANK TRANS Reference BANK TRANS Reference [nvarchar](20) NULL  
BANK TRANS Notes BANK TRANS Notes [ntext] NULL  
BANK TRANS Posted YN BANK TRANS Posted YN [bit] NOT NULL  
BANK TRANS Beg Balance BANK TRANS Beg Balance [bit] NOT NULL  
BANK TRANS Cleared YN BANK TRANS Cleared YN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


BANK Transaction Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[BANK Transaction Detail] (
	[ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[BANK TRANSD Name] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ID ID [int] NOT NULL  
BANK TRANSD Name BANK TRANSD Name [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Cash Payments Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Cash Payments Work] (
	[Reference] [nvarchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Original Amount] [money] NULL ,
	[Discount] [money] NULL ,
	[Write Off] [money] NULL ,
	[Applied Amount] [money] NULL ,
	[Balance] [money] NULL ,
	[Amount Paid] [money] NULL ,
	[Discount Date] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [nvarchar](50) NULL  
Date Date [datetime] NULL  
Original Amount Original Amount [money] NULL  
Discount Discount [money] NULL  
Write Off Write Off [money] NULL  
Applied Amount Applied Amount [money] NULL  
Balance Balance [money] NULL  
Amount Paid Amount Paid [money] NULL  
Discount Date Discount Date [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Cash Receipts Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Cash Receipts Work] (
	[Reference] [nvarchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Original Amount] [money] NULL ,
	[Discount] [money] NULL ,
	[Write Off] [money] NULL ,
	[Applied Amount] [money] NULL ,
	[Balance] [money] NULL ,
	[Amount Paid] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [nvarchar](50) NULL  
Date Date [datetime] NULL  
Original Amount Original Amount [money] NULL  
Discount Discount [money] NULL  
Write Off Write Off [money] NULL  
Applied Amount Applied Amount [money] NULL  
Balance Balance [money] NULL  
Amount Paid Amount Paid [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


COA
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[COA] (
	[GL COA Account No] [nvarchar] (50 ) NOT NULL ,
	[GL COA Account Name] [nvarchar] (30 ) NULL ,
	[GL COA Asset Type] [nvarchar] (30 ) NULL ,
	[GL COA Balance Type] [nvarchar] (10 ) NULL ,
	[GL COA Notes] [ntext] NULL ,
	[GL COA Report Level] [bit] NOT NULL ,
	[GL COA Reporting Level] [smallint] NULL ,
	[GL COA Account Balance] [float] NULL ,
	[GL COA CY Beginning Amt] [float] NULL ,
	[GL COA CY Period 1 Amt] [float] NULL ,
	[GL COA CY Period 2 Amt] [float] NULL ,
	[GL COA CY Period 3 Amt] [float] NULL ,
	[GL COA CY Period 4 Amt] [float] NULL ,
	[GL COA CY Period 5 Amt] [float] NULL ,
	[GL COA CY Period 6 Amt] [float] NULL ,
	[GL COA CY Period 7 Amt] [float] NULL ,
	[GL COA CY Period 8 Amt] [float] NULL ,
	[GL COA CY Period 9 Amt] [float] NULL ,
	[GL COA CY Period 10 Amt] [float] NULL ,
	[GL COA CY Period 11 Amt] [float] NULL ,
	[GL COA CY Period 12 Amt] [float] NULL ,
	[GL COA CY Period 13 Amt] [float] NULL ,
	[GL COA CY Period 14 Amt] [float] NULL ,
	[GL COA BUD Beginning Amt] [float] NULL ,
	[GL COA BUD Period 1 Amt] [float] NULL ,
	[GL COA BUD Period 2 Amt] [float] NULL ,
	[GL COA BUD Period 3 Amt] [float] NULL ,
	[GL COA BUD Period 4 Amt] [float] NULL ,
	[GL COA BUD Period 5 Amt] [float] NULL ,
	[GL COA BUD Period 6 Amt] [float] NULL ,
	[GL COA BUD Period 7 Amt] [float] NULL ,
	[GL COA BUD Period 8 Amt] [float] NULL ,
	[GL COA BUD Period 9 Amt] [float] NULL ,
	[GL COA BUD Period 10 Amt] [float] NULL ,
	[GL COA BUD Period 11 Amt] [float] NULL ,
	[GL COA BUD Period 12 Amt] [float] NULL ,
	[GL COA BUD Period 13 Amt] [float] NULL ,
	[GL COA PY Beginning Amt] [float] NULL ,
	[GL COA PY Period 1 Amt] [float] NULL ,
	[GL COA PY Period 2 Amt] [float] NULL ,
	[GL COA PY Period 3 Amt] [float] NULL ,
	[GL COA PY Period 4 Amt] [float] NULL ,
	[GL COA PY Period 5 Amt] [float] NULL ,
	[GL COA PY Period 6 Amt] [float] NULL ,
	[GL COA PY Period 7 Amt] [float] NULL ,
	[GL COA PY Period 8 Amt] [float] NULL ,
	[GL COA PY Period 9 Amt] [float] NULL ,
	[GL COA PY Period 10 Amt] [float] NULL ,
	[GL COA PY Period 11 Amt] [float] NULL ,
	[GL COA PY Period 12 Amt] [float] NULL ,
	[GL COA PY Period 13 Amt] [float] NULL ,
	[GL COA Inactive YN] [smallint] NULL ,
	[GL COA Beginning Balance] [float] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL COA Account No GL COA Account No [nvarchar](50) NOT NULL  
GL COA Account Name GL COA Account Name [nvarchar](30) NULL  
GL COA Asset Type GL COA Asset Type [nvarchar](30) NULL  
GL COA Balance Type GL COA Balance Type [nvarchar](10) NULL  
GL COA Notes GL COA Notes [ntext] NULL  
GL COA Report Level GL COA Report Level [bit] NOT NULL  
GL COA Reporting Level GL COA Reporting Level [smallint] NULL  
GL COA Account Balance GL COA Account Balance [float] NULL  
GL COA CY Beginning Amt GL COA CY Beginning Amt [float] NULL  
GL COA CY Period 1 Amt GL COA CY Period 1 Amt [float] NULL  
GL COA CY Period 2 Amt GL COA CY Period 2 Amt [float] NULL  
GL COA CY Period 3 Amt GL COA CY Period 3 Amt [float] NULL  
GL COA CY Period 4 Amt GL COA CY Period 4 Amt [float] NULL  
GL COA CY Period 5 Amt GL COA CY Period 5 Amt [float] NULL  
GL COA CY Period 6 Amt GL COA CY Period 6 Amt [float] NULL  
GL COA CY Period 7 Amt GL COA CY Period 7 Amt [float] NULL  
GL COA CY Period 8 Amt GL COA CY Period 8 Amt [float] NULL  
GL COA CY Period 9 Amt GL COA CY Period 9 Amt [float] NULL  
GL COA CY Period 10 Amt GL COA CY Period 10 Amt [float] NULL  
GL COA CY Period 11 Amt GL COA CY Period 11 Amt [float] NULL  
GL COA CY Period 12 Amt GL COA CY Period 12 Amt [float] NULL  
GL COA CY Period 13 Amt GL COA CY Period 13 Amt [float] NULL  
GL COA CY Period 14 Amt GL COA CY Period 14 Amt [float] NULL  
GL COA BUD Beginning Amt GL COA BUD Beginning Amt [float] NULL  
GL COA BUD Period 1 Amt GL COA BUD Period 1 Amt [float] NULL  
GL COA BUD Period 2 Amt GL COA BUD Period 2 Amt [float] NULL  
GL COA BUD Period 3 Amt GL COA BUD Period 3 Amt [float] NULL  
GL COA BUD Period 4 Amt GL COA BUD Period 4 Amt [float] NULL  
GL COA BUD Period 5 Amt GL COA BUD Period 5 Amt [float] NULL  
GL COA BUD Period 6 Amt GL COA BUD Period 6 Amt [float] NULL  
GL COA BUD Period 7 Amt GL COA BUD Period 7 Amt [float] NULL  
GL COA BUD Period 8 Amt GL COA BUD Period 8 Amt [float] NULL  
GL COA BUD Period 9 Amt GL COA BUD Period 9 Amt [float] NULL  
GL COA BUD Period 10 Amt GL COA BUD Period 10 Amt [float] NULL  
GL COA BUD Period 11 Amt GL COA BUD Period 11 Amt [float] NULL  
GL COA BUD Period 12 Amt GL COA BUD Period 12 Amt [float] NULL  
GL COA BUD Period 13 Amt GL COA BUD Period 13 Amt [float] NULL  
GL COA PY Beginning Amt GL COA PY Beginning Amt [float] NULL  
GL COA PY Period 1 Amt GL COA PY Period 1 Amt [float] NULL  
GL COA PY Period 2 Amt GL COA PY Period 2 Amt [float] NULL  
GL COA PY Period 3 Amt GL COA PY Period 3 Amt [float] NULL  
GL COA PY Period 4 Amt GL COA PY Period 4 Amt [float] NULL  
GL COA PY Period 5 Amt GL COA PY Period 5 Amt [float] NULL  
GL COA PY Period 6 Amt GL COA PY Period 6 Amt [float] NULL  
GL COA PY Period 7 Amt GL COA PY Period 7 Amt [float] NULL  
GL COA PY Period 8 Amt GL COA PY Period 8 Amt [float] NULL  
GL COA PY Period 9 Amt GL COA PY Period 9 Amt [float] NULL  
GL COA PY Period 10 Amt GL COA PY Period 10 Amt [float] NULL  
GL COA PY Period 11 Amt GL COA PY Period 11 Amt [float] NULL  
GL COA PY Period 12 Amt GL COA PY Period 12 Amt [float] NULL  
GL COA PY Period 13 Amt GL COA PY Period 13 Amt [float] NULL  
GL COA Inactive YN GL COA Inactive YN [smallint] NULL  
GL COA Beginning Balance GL COA Beginning Balance [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


EMP Employees
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[EMP Employees] (
	[EMP ID] [nvarchar] () NOT NULL ,
	[EMP Name] [nvarchar] (50 ) NULL ,
	[EMP Inactive YN] [smallint] NULL ,
	[EMP Address 1] [nvarchar] (30 ) NULL ,
	[EMP Address 2] [nvarchar] (30 ) NULL ,
	[EMP City] [nvarchar] (20 ) NULL ,
	[EMP State] [nvarchar] (20 ) NULL ,
	[EMP Postal] [nvarchar] (20 ) NULL ,
	[EMP Country] [nvarchar] (20 ) NULL ,
	[EMP Phone] [nvarchar] (20 ) NULL ,
	[EMP Home Fax] [nvarchar] (20 ) NULL ,
	[EMP SS Number] [nvarchar] (15 ) NULL ,
	[EMP Hire Date] [datetime] NULL ,
	[EMP Birthday] [datetime] NULL ,
	[EMP Percentage] [float] NULL ,
	[EMP Method] [smallint] NULL ,
	[EMP Salesperson YN] [bit] NOT NULL ,
	[EMP Type] [nvarchar] (20 ) NULL ,
	[EMP Notes] [nvarchar] (2000 ) NULL ,
	[EMP MTD Gross] [float] NULL ,
	[EMP MTD FICA] [float] NULL ,
	[EMP MTD Federal] [float] NULL ,
	[EMP MTD State] [float] NULL ,
	[EMP MTD Local] [float] NULL ,
	[EMP MTD Other] [float] NULL ,
	[EMP QTD Gross] [float] NULL ,
	[EMP QTD FICA] [float] NULL ,
	[EMP QTD Federal] [float] NULL ,
	[EMP QTD State] [float] NULL ,
	[EMP QTD Local] [float] NULL ,
	[EMP QTD Other] [float] NULL ,
	[EMP YTD Gross] [float] NULL ,
	[EMP YTD FICA] [float] NULL ,
	[EMP YTD Federal] [float] NULL ,
	[EMP YTD State] [float] NULL ,
	[EMP YTD Local] [float] NULL ,
	[EMP YTD Other] [float] NULL ,
	[EMP Emergency Contact] [nvarchar] (30 ) NULL ,
	[EMP Emergency Number] [nvarchar] (20 ) NULL ,
	[EMP Employee Saved] [bit] NOT NULL ,
	[EMP Custom 1] [nvarchar] (50 ) NULL ,
	[EMP Custom 2] [nvarchar] (50 ) NULL ,
	[EMP Custom 3] [nvarchar] (50 ) NULL ,
	[EMP Custom 4] [nvarchar] (50 ) NULL ,
	[EMP Custom 5] [nvarchar] (50 ) NULL ,
	[EMP Custom 6] [nvarchar] (50 ) NULL ,
	[EMP Custom 7] [nvarchar] (50 ) NULL ,
	[EMP Custom 8] [nvarchar] (50 ) NULL ,
	[EMP Custom 9] [nvarchar] (50 ) NULL ,
	[EMP Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EMP ID EMP ID [nvarchar](8) NOT NULL  
EMP Name EMP Name [nvarchar](50) NULL  
EMP Inactive YN EMP Inactive YN [smallint] NULL  
EMP Address 1 EMP Address 1 [nvarchar](30) NULL  
EMP Address 2 EMP Address 2 [nvarchar](30) NULL  
EMP City EMP City [nvarchar](20) NULL  
EMP State EMP State [nvarchar](20) NULL  
EMP Postal EMP Postal [nvarchar](20) NULL  
EMP Country EMP Country [nvarchar](20) NULL  
EMP Phone EMP Phone [nvarchar](20) NULL  
EMP Home Fax EMP Home Fax [nvarchar](20) NULL  
EMP SS Number EMP SS Number [nvarchar](15) NULL  
EMP Hire Date EMP Hire Date [datetime] NULL  
EMP Birthday EMP Birthday [datetime] NULL  
EMP Percentage EMP Percentage [float] NULL  
EMP Method EMP Method [smallint] NULL  
EMP Salesperson YN EMP Salesperson YN [bit] NOT NULL  
EMP Type EMP Type [nvarchar](20) NULL  
EMP Notes EMP Notes [nvarchar](2000) NULL  
EMP MTD Gross EMP MTD Gross [float] NULL  
EMP MTD FICA EMP MTD FICA [float] NULL  
EMP MTD Federal EMP MTD Federal [float] NULL  
EMP MTD State EMP MTD State [float] NULL  
EMP MTD Local EMP MTD Local [float] NULL  
EMP MTD Other EMP MTD Other [float] NULL  
EMP QTD Gross EMP QTD Gross [float] NULL  
EMP QTD FICA EMP QTD FICA [float] NULL  
EMP QTD Federal EMP QTD Federal [float] NULL  
EMP QTD State EMP QTD State [float] NULL  
EMP QTD Local EMP QTD Local [float] NULL  
EMP QTD Other EMP QTD Other [float] NULL  
EMP YTD Gross EMP YTD Gross [float] NULL  
EMP YTD FICA EMP YTD FICA [float] NULL  
EMP YTD Federal EMP YTD Federal [float] NULL  
EMP YTD State EMP YTD State [float] NULL  
EMP YTD Local EMP YTD Local [float] NULL  
EMP YTD Other EMP YTD Other [float] NULL  
EMP Emergency Contact EMP Emergency Contact [nvarchar](30) NULL  
EMP Emergency Number EMP Emergency Number [nvarchar](20) NULL  
EMP Employee Saved EMP Employee Saved [bit] NOT NULL  
EMP Custom 1 EMP Custom 1 [nvarchar](50) NULL  
EMP Custom 2 EMP Custom 2 [nvarchar](50) NULL  
EMP Custom 3 EMP Custom 3 [nvarchar](50) NULL  
EMP Custom 4 EMP Custom 4 [nvarchar](50) NULL  
EMP Custom 5 EMP Custom 5 [nvarchar](50) NULL  
EMP Custom 6 EMP Custom 6 [nvarchar](50) NULL  
EMP Custom 7 EMP Custom 7 [nvarchar](50) NULL  
EMP Custom 8 EMP Custom 8 [nvarchar](50) NULL  
EMP Custom 9 EMP Custom 9 [nvarchar](50) NULL  
EMP Custom 10 EMP Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


EMP Employees Upgrade
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[EMP Employees Upgrade] (
	[EMP ID] [nvarchar] () NOT NULL ,
	[EMP Name] [nvarchar] (50 ) NULL ,
	[EMP Inactive YN] [smallint] NULL ,
	[EMP Address 1] [nvarchar] (30 ) NULL ,
	[EMP Address 2] [nvarchar] (30 ) NULL ,
	[EMP City] [nvarchar] (20 ) NULL ,
	[EMP State] [nvarchar] (20 ) NULL ,
	[EMP Postal] [nvarchar] (20 ) NULL ,
	[EMP Country] [nvarchar] (20 ) NULL ,
	[EMP Phone] [nvarchar] (20 ) NULL ,
	[EMP Home Fax] [nvarchar] (20 ) NULL ,
	[EMP SS Number] [nvarchar] (15 ) NULL ,
	[EMP Hire Date] [datetime] NULL ,
	[EMP Birthday] [datetime] NULL ,
	[EMP Percentage] [float] NULL ,
	[EMP Method] [smallint] NULL ,
	[EMP Salesperson YN] [bit] NOT NULL ,
	[EMP Type] [nvarchar] (20 ) NULL ,
	[EMP Notes] [ntext] NULL ,
	[EMP MTD Gross] [float] NULL ,
	[EMP MTD FICA] [float] NULL ,
	[EMP MTD Federal] [float] NULL ,
	[EMP MTD State] [float] NULL ,
	[EMP MTD Local] [float] NULL ,
	[EMP MTD Other] [float] NULL ,
	[EMP QTD Gross] [float] NULL ,
	[EMP QTD FICA] [float] NULL ,
	[EMP QTD Federal] [float] NULL ,
	[EMP QTD State] [float] NULL ,
	[EMP QTD Local] [float] NULL ,
	[EMP QTD Other] [float] NULL ,
	[EMP YTD Gross] [float] NULL ,
	[EMP YTD FICA] [float] NULL ,
	[EMP YTD Federal] [float] NULL ,
	[EMP YTD State] [float] NULL ,
	[EMP YTD Local] [float] NULL ,
	[EMP YTD Other] [float] NULL ,
	[EMP Emergency Contact] [nvarchar] (30 ) NULL ,
	[EMP Emergency Number] [nvarchar] (20 ) NULL ,
	[EMP Employee Saved] [bit] NOT NULL ,
	[EMP Custom 1] [nvarchar] (50 ) NULL ,
	[EMP Custom 2] [nvarchar] (50 ) NULL ,
	[EMP Custom 3] [nvarchar] (50 ) NULL ,
	[EMP Custom 4] [nvarchar] (50 ) NULL ,
	[EMP Custom 5] [nvarchar] (50 ) NULL ,
	[EMP Custom 6] [nvarchar] (50 ) NULL ,
	[EMP Custom 7] [nvarchar] (50 ) NULL ,
	[EMP Custom 8] [nvarchar] (50 ) NULL ,
	[EMP Custom 9] [nvarchar] (50 ) NULL ,
	[EMP Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EMP ID EMP ID [nvarchar](8) NOT NULL  
EMP Name EMP Name [nvarchar](50) NULL  
EMP Inactive YN EMP Inactive YN [smallint] NULL  
EMP Address 1 EMP Address 1 [nvarchar](30) NULL  
EMP Address 2 EMP Address 2 [nvarchar](30) NULL  
EMP City EMP City [nvarchar](20) NULL  
EMP State EMP State [nvarchar](20) NULL  
EMP Postal EMP Postal [nvarchar](20) NULL  
EMP Country EMP Country [nvarchar](20) NULL  
EMP Phone EMP Phone [nvarchar](20) NULL  
EMP Home Fax EMP Home Fax [nvarchar](20) NULL  
EMP SS Number EMP SS Number [nvarchar](15) NULL  
EMP Hire Date EMP Hire Date [datetime] NULL  
EMP Birthday EMP Birthday [datetime] NULL  
EMP Percentage EMP Percentage [float] NULL  
EMP Method EMP Method [smallint] NULL  
EMP Salesperson YN EMP Salesperson YN [bit] NOT NULL  
EMP Type EMP Type [nvarchar](20) NULL  
EMP Notes EMP Notes [ntext] NULL  
EMP MTD Gross EMP MTD Gross [float] NULL  
EMP MTD FICA EMP MTD FICA [float] NULL  
EMP MTD Federal EMP MTD Federal [float] NULL  
EMP MTD State EMP MTD State [float] NULL  
EMP MTD Local EMP MTD Local [float] NULL  
EMP MTD Other EMP MTD Other [float] NULL  
EMP QTD Gross EMP QTD Gross [float] NULL  
EMP QTD FICA EMP QTD FICA [float] NULL  
EMP QTD Federal EMP QTD Federal [float] NULL  
EMP QTD State EMP QTD State [float] NULL  
EMP QTD Local EMP QTD Local [float] NULL  
EMP QTD Other EMP QTD Other [float] NULL  
EMP YTD Gross EMP YTD Gross [float] NULL  
EMP YTD FICA EMP YTD FICA [float] NULL  
EMP YTD Federal EMP YTD Federal [float] NULL  
EMP YTD State EMP YTD State [float] NULL  
EMP YTD Local EMP YTD Local [float] NULL  
EMP YTD Other EMP YTD Other [float] NULL  
EMP Emergency Contact EMP Emergency Contact [nvarchar](30) NULL  
EMP Emergency Number EMP Emergency Number [nvarchar](20) NULL  
EMP Employee Saved EMP Employee Saved [bit] NOT NULL  
EMP Custom 1 EMP Custom 1 [nvarchar](50) NULL  
EMP Custom 2 EMP Custom 2 [nvarchar](50) NULL  
EMP Custom 3 EMP Custom 3 [nvarchar](50) NULL  
EMP Custom 4 EMP Custom 4 [nvarchar](50) NULL  
EMP Custom 5 EMP Custom 5 [nvarchar](50) NULL  
EMP Custom 6 EMP Custom 6 [nvarchar](50) NULL  
EMP Custom 7 EMP Custom 7 [nvarchar](50) NULL  
EMP Custom 8 EMP Custom 8 [nvarchar](50) NULL  
EMP Custom 9 EMP Custom 9 [nvarchar](50) NULL  
EMP Custom 10 EMP Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Error Log
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Error Log] (
	[Form Name] [nvarchar] (50 ) NULL ,
	[Module Name] [nvarchar] (50 ) NULL ,
	[When] [datetime] NULL ,
	[Error Code] [int] NULL ,
	[Error String] [nvarchar] (255 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Form Name Form Name [nvarchar](50) NULL  
Module Name Module Name [nvarchar](50) NULL  
When When [datetime] NULL  
Error Code Error Code [int] NULL  
Error String Error String [nvarchar](255) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Finance Charge Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Finance Charge Work] (
	[Customer] [nvarchar] (50 ) NULL ,
	[Finance Charge] [money] NULL ,
	[Period 1] [money] NULL ,
	[Period 2] [money] NULL ,
	[Period 3] [money] NULL ,
	[Period 4] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer Customer [nvarchar](50) NULL  
Finance Charge Finance Charge [money] NULL  
Period 1 Period 1 [money] NULL  
Period 2 Period 2 [money] NULL  
Period 3 Period 3 [money] NULL  
Period 4 Period 4 [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Account Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Account Types] (
	[Account Name] [nvarchar] (20 ) NULL ,
	[Account ID] [int] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Account Name Account Name [nvarchar](20) NULL  
Account ID Account ID [int] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Chart Of Accounts
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Chart Of Accounts] (
	[GL COA Account No] [nvarchar] (50 ) NOT NULL ,
	[GL COA Account Name] [nvarchar] (30 ) NULL ,
	[GL COA Asset Type] [nvarchar] (30 ) NULL ,
	[GL COA Balance Type] [nvarchar] (10 ) NULL ,
	[GL COA Notes] [nvarchar] (1000 ) NULL ,
	[GL COA Report Level] [bit] NOT NULL ,
	[GL COA Reporting Level] [smallint] NULL ,
	[GL COA Account Balance] [float] NULL ,
	[GL COA CY Beginning Amt] [float] NULL ,
	[GL COA CY Period 1 Amt] [float] NULL ,
	[GL COA CY Period 2 Amt] [float] NULL ,
	[GL COA CY Period 3 Amt] [float] NULL ,
	[GL COA CY Period 4 Amt] [float] NULL ,
	[GL COA CY Period 5 Amt] [float] NULL ,
	[GL COA CY Period 6 Amt] [float] NULL ,
	[GL COA CY Period 7 Amt] [float] NULL ,
	[GL COA CY Period 8 Amt] [float] NULL ,
	[GL COA CY Period 9 Amt] [float] NULL ,
	[GL COA CY Period 10 Amt] [float] NULL ,
	[GL COA CY Period 11 Amt] [float] NULL ,
	[GL COA CY Period 12 Amt] [float] NULL ,
	[GL COA CY Period 13 Amt] [float] NULL ,
	[GL COA CY Period 14 Amt] [float] NULL ,
	[GL COA BUD Beginning Amt] [float] NULL ,
	[GL COA BUD Period 1 Amt] [float] NULL ,
	[GL COA BUD Period 2 Amt] [float] NULL ,
	[GL COA BUD Period 3 Amt] [float] NULL ,
	[GL COA BUD Period 4 Amt] [float] NULL ,
	[GL COA BUD Period 5 Amt] [float] NULL ,
	[GL COA BUD Period 6 Amt] [float] NULL ,
	[GL COA BUD Period 7 Amt] [float] NULL ,
	[GL COA BUD Period 8 Amt] [float] NULL ,
	[GL COA BUD Period 9 Amt] [float] NULL ,
	[GL COA BUD Period 10 Amt] [float] NULL ,
	[GL COA BUD Period 11 Amt] [float] NULL ,
	[GL COA BUD Period 12 Amt] [float] NULL ,
	[GL COA BUD Period 13 Amt] [float] NULL ,
	[GL COA PY Beginning Amt] [float] NULL ,
	[GL COA PY Period 1 Amt] [float] NULL ,
	[GL COA PY Period 2 Amt] [float] NULL ,
	[GL COA PY Period 3 Amt] [float] NULL ,
	[GL COA PY Period 4 Amt] [float] NULL ,
	[GL COA PY Period 5 Amt] [float] NULL ,
	[GL COA PY Period 6 Amt] [float] NULL ,
	[GL COA PY Period 7 Amt] [float] NULL ,
	[GL COA PY Period 8 Amt] [float] NULL ,
	[GL COA PY Period 9 Amt] [float] NULL ,
	[GL COA PY Period 10 Amt] [float] NULL ,
	[GL COA PY Period 11 Amt] [float] NULL ,
	[GL COA PY Period 12 Amt] [float] NULL ,
	[GL COA PY Period 13 Amt] [float] NULL ,
	[GL COA Inactive YN] [smallint] NULL ,
	[GL COA Beginning Balance] [float] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL COA Account No GL COA Account No [nvarchar](50) NOT NULL  
GL COA Account Name GL COA Account Name [nvarchar](30) NULL  
GL COA Asset Type GL COA Asset Type [nvarchar](30) NULL  
GL COA Balance Type GL COA Balance Type [nvarchar](10) NULL  
GL COA Notes GL COA Notes [nvarchar](1000) NULL  
GL COA Report Level GL COA Report Level [bit] NOT NULL  
GL COA Reporting Level GL COA Reporting Level [smallint] NULL  
GL COA Account Balance GL COA Account Balance [float] NULL  
GL COA CY Beginning Amt GL COA CY Beginning Amt [float] NULL  
GL COA CY Period 1 Amt GL COA CY Period 1 Amt [float] NULL  
GL COA CY Period 2 Amt GL COA CY Period 2 Amt [float] NULL  
GL COA CY Period 3 Amt GL COA CY Period 3 Amt [float] NULL  
GL COA CY Period 4 Amt GL COA CY Period 4 Amt [float] NULL  
GL COA CY Period 5 Amt GL COA CY Period 5 Amt [float] NULL  
GL COA CY Period 6 Amt GL COA CY Period 6 Amt [float] NULL  
GL COA CY Period 7 Amt GL COA CY Period 7 Amt [float] NULL  
GL COA CY Period 8 Amt GL COA CY Period 8 Amt [float] NULL  
GL COA CY Period 9 Amt GL COA CY Period 9 Amt [float] NULL  
GL COA CY Period 10 Amt GL COA CY Period 10 Amt [float] NULL  
GL COA CY Period 11 Amt GL COA CY Period 11 Amt [float] NULL  
GL COA CY Period 12 Amt GL COA CY Period 12 Amt [float] NULL  
GL COA CY Period 13 Amt GL COA CY Period 13 Amt [float] NULL  
GL COA CY Period 14 Amt GL COA CY Period 14 Amt [float] NULL  
GL COA BUD Beginning Amt GL COA BUD Beginning Amt [float] NULL  
GL COA BUD Period 1 Amt GL COA BUD Period 1 Amt [float] NULL  
GL COA BUD Period 2 Amt GL COA BUD Period 2 Amt [float] NULL  
GL COA BUD Period 3 Amt GL COA BUD Period 3 Amt [float] NULL  
GL COA BUD Period 4 Amt GL COA BUD Period 4 Amt [float] NULL  
GL COA BUD Period 5 Amt GL COA BUD Period 5 Amt [float] NULL  
GL COA BUD Period 6 Amt GL COA BUD Period 6 Amt [float] NULL  
GL COA BUD Period 7 Amt GL COA BUD Period 7 Amt [float] NULL  
GL COA BUD Period 8 Amt GL COA BUD Period 8 Amt [float] NULL  
GL COA BUD Period 9 Amt GL COA BUD Period 9 Amt [float] NULL  
GL COA BUD Period 10 Amt GL COA BUD Period 10 Amt [float] NULL  
GL COA BUD Period 11 Amt GL COA BUD Period 11 Amt [float] NULL  
GL COA BUD Period 12 Amt GL COA BUD Period 12 Amt [float] NULL  
GL COA BUD Period 13 Amt GL COA BUD Period 13 Amt [float] NULL  
GL COA PY Beginning Amt GL COA PY Beginning Amt [float] NULL  
GL COA PY Period 1 Amt GL COA PY Period 1 Amt [float] NULL  
GL COA PY Period 2 Amt GL COA PY Period 2 Amt [float] NULL  
GL COA PY Period 3 Amt GL COA PY Period 3 Amt [float] NULL  
GL COA PY Period 4 Amt GL COA PY Period 4 Amt [float] NULL  
GL COA PY Period 5 Amt GL COA PY Period 5 Amt [float] NULL  
GL COA PY Period 6 Amt GL COA PY Period 6 Amt [float] NULL  
GL COA PY Period 7 Amt GL COA PY Period 7 Amt [float] NULL  
GL COA PY Period 8 Amt GL COA PY Period 8 Amt [float] NULL  
GL COA PY Period 9 Amt GL COA PY Period 9 Amt [float] NULL  
GL COA PY Period 10 Amt GL COA PY Period 10 Amt [float] NULL  
GL COA PY Period 11 Amt GL COA PY Period 11 Amt [float] NULL  
GL COA PY Period 12 Amt GL COA PY Period 12 Amt [float] NULL  
GL COA PY Period 13 Amt GL COA PY Period 13 Amt [float] NULL  
GL COA Inactive YN GL COA Inactive YN [smallint] NULL  
GL COA Beginning Balance GL COA Beginning Balance [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Industry Chart Of Accounts
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Industry Chart Of Accounts] (
	[GL COA Industry] [nvarchar] (50 ) NULL ,
	[GL COA Account No] [nvarchar] (50 ) NULL ,
	[GL COA Account Name] [nvarchar] (30 ) NULL ,
	[GL COA Asset Type] [nvarchar] (30 ) NULL ,
	[GL COA Balance Type] [nvarchar] (10 ) NULL ,
	[GL COA Notes] [ntext] NULL ,
	[GL COA Report Level] [bit] NOT NULL ,
	[GL COA Reporting Level] [smallint] NULL ,
	[GL COA Inactive YN] [smallint] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL COA Industry GL COA Industry [nvarchar](50) NULL  
GL COA Account No GL COA Account No [nvarchar](50) NULL  
GL COA Account Name GL COA Account Name [nvarchar](30) NULL  
GL COA Asset Type GL COA Asset Type [nvarchar](30) NULL  
GL COA Balance Type GL COA Balance Type [nvarchar](10) NULL  
GL COA Notes GL COA Notes [ntext] NULL  
GL COA Report Level GL COA Report Level [bit] NOT NULL  
GL COA Reporting Level GL COA Reporting Level [smallint] NULL  
GL COA Inactive YN GL COA Inactive YN [smallint] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Reporting Type
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Reporting Type] (
	[GL RPT Account Type] [smallint] NOT NULL ,
	[GL RPT Reporting Description] [nvarchar] (30 ) NOT NULL ,
	[GL RPT Balance Type] [nvarchar] () NULL ,
	[GL RPT Sort] [float] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL RPT Account Type GL RPT Account Type [smallint] NOT NULL  
GL RPT Reporting Description GL RPT Reporting Description [nvarchar](30) NOT NULL  
GL RPT Balance Type GL RPT Balance Type [nvarchar](6) NULL  
GL RPT Sort GL RPT Sort [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Transaction
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Transaction] (
	[GL TRANS Number] [int] IDENTITY (, 1 ) NOT NULL ,
	[GL TRANS Document #] [nvarchar] (50 ) NULL ,
	[GL TRANS Type] [nvarchar] (20 ) NULL ,
	[GL TRANS Date] [datetime] NULL ,
	[GL TRANS Description] [nvarchar] (50 ) NULL ,
	[GL TRANS Reference] [nvarchar] (50 ) NULL ,
	[GL TRANS Amount] [float] NULL ,
	[GL TRANS Undistributed] [float] NULL ,
	[GL TRANS Balance] [float] NULL ,
	[GL TRANS Posted YN] [bit] NOT NULL ,
	[GL TRANS Source] [nvarchar] (50 ) NULL ,
	[GL TRANS System Generated] [bit] NOT NULL ,
	[GL TRANS Unposted] [bit] NOT NULL ,
	[GL TRANS Recurring YN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL TRANS Number GL TRANS Number [int] NOT NULL  
GL TRANS Document # GL TRANS Document # [nvarchar](50) NULL  
GL TRANS Type GL TRANS Type [nvarchar](20) NULL  
GL TRANS Date GL TRANS Date [datetime] NULL  
GL TRANS Description GL TRANS Description [nvarchar](50) NULL  
GL TRANS Reference GL TRANS Reference [nvarchar](50) NULL  
GL TRANS Amount GL TRANS Amount [float] NULL  
GL TRANS Undistributed GL TRANS Undistributed [float] NULL  
GL TRANS Balance GL TRANS Balance [float] NULL  
GL TRANS Posted YN GL TRANS Posted YN [bit] NOT NULL  
GL TRANS Source GL TRANS Source [nvarchar](50) NULL  
GL TRANS System Generated GL TRANS System Generated [bit] NOT NULL  
GL TRANS Unposted GL TRANS Unposted [bit] NOT NULL  
GL TRANS Recurring YN GL TRANS Recurring YN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Transaction Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Transaction Detail] (
	[GL TRANSD Number] [int] NULL ,
	[GL TRANSD Account] [nvarchar] (50 ) NULL ,
	[GL TRANSD Department] [nvarchar] () NULL ,
	[GL TRANSD Debit Amount] [float] NULL ,
	[GL TRANSD Credit Amount] [float] NULL ,
	[GL TRANSD Project] [nvarchar] () NULL ,
	[GL TRANSD ID] [int] IDENTITY (, 1 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL TRANSD Number GL TRANSD Number [int] NULL  
GL TRANSD Account GL TRANSD Account [nvarchar](50) NULL  
GL TRANSD Department GL TRANSD Department [nvarchar](5) NULL  
GL TRANSD Debit Amount GL TRANSD Debit Amount [float] NULL  
GL TRANSD Credit Amount GL TRANSD Credit Amount [float] NULL  
GL TRANSD Project GL TRANSD Project [nvarchar](8) NULL  
GL TRANSD ID GL TRANSD ID [int] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


GL Work Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GL Work Detail] (
	[GW TRANSD Number] [int] NULL ,
	[GW TRANSD Account] [nvarchar] (50 ) NULL ,
	[GW TRANSD Department] [nvarchar] () NULL ,
	[GW TRANSD Debit Amount] [float] NULL ,
	[GW TRANSD Credit Amount] [float] NULL ,
	[GW TRANSD Project] [nvarchar] () NULL ,
	[GW TRANSD ID] [int] IDENTITY (, 1 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GW TRANSD Number GW TRANSD Number [int] NULL  
GW TRANSD Account GW TRANSD Account [nvarchar](50) NULL  
GW TRANSD Department GW TRANSD Department [nvarchar](5) NULL  
GW TRANSD Debit Amount GW TRANSD Debit Amount [float] NULL  
GW TRANSD Credit Amount GW TRANSD Credit Amount [float] NULL  
GW TRANSD Project GW TRANSD Project [nvarchar](8) NULL  
GW TRANSD ID GW TRANSD ID [int] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Help Text
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Help Text] (
	[Form Name] [nvarchar] (50 ) NOT NULL ,
	[Help Text] [text] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Form Name Form Name [nvarchar](50) NOT NULL  
Help Text Help Text [text] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Adjustment
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Adjustment] (
	[INV ADJ Document No] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV ADJ Ext Document No] [nvarchar] (20 ) NULL ,
	[INV ADJ Type] [nvarchar] (10 ) NULL ,
	[INV ADJ Date] [datetime] NULL ,
	[INV ADJ Reason] [nvarchar] (50 ) NULL ,
	[INV ADJ Posted YN] [bit] NOT NULL ,
	[INV ADJ Notes] [nvarchar] (2000 ) NULL ,
	[INV ADJ Post To GL YN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV ADJ Document No INV ADJ Document No [int] NOT NULL  
INV ADJ Ext Document No INV ADJ Ext Document No [nvarchar](20) NULL  
INV ADJ Type INV ADJ Type [nvarchar](10) NULL  
INV ADJ Date INV ADJ Date [datetime] NULL  
INV ADJ Reason INV ADJ Reason [nvarchar](50) NULL  
INV ADJ Posted YN INV ADJ Posted YN [bit] NOT NULL  
INV ADJ Notes INV ADJ Notes [nvarchar](2000) NULL  
INV ADJ Post To GL YN INV ADJ Post To GL YN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Adjustment Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Adjustment Detail] (
	[INV ADJD ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV ADJD Document No] [int] NULL ,
	[INV ADJD Item ID] [nvarchar] (20 ) NULL ,
	[INV ADJD Description] [nvarchar] (255 ) NULL ,
	[INV ADJD Original Qty] [float] NULL ,
	[INV ADJD Adjusted Qty] [float] NULL ,
	[INV ADJD Cost] [float] NULL ,
	[INV ADJD Posting Account] [nvarchar] (50 ) NULL ,
	[INV ADJD Department] [nvarchar] () NULL ,
	[INV ADJD Project] [nvarchar] () NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV ADJD ID INV ADJD ID [int] NOT NULL  
INV ADJD Document No INV ADJD Document No [int] NULL  
INV ADJD Item ID INV ADJD Item ID [nvarchar](20) NULL  
INV ADJD Description INV ADJD Description [nvarchar](255) NULL  
INV ADJD Original Qty INV ADJD Original Qty [float] NULL  
INV ADJD Adjusted Qty INV ADJD Adjusted Qty [float] NULL  
INV ADJD Cost INV ADJD Cost [float] NULL  
INV ADJD Posting Account INV ADJD Posting Account [nvarchar](50) NULL  
INV ADJD Department INV ADJD Department [nvarchar](5) NULL  
INV ADJD Project INV ADJD Project [nvarchar](8) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV History
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV History] (
	[INV HIST Sequence] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV HIST Document No] [nvarchar] (20 ) NULL ,
	[INV HIST Type] [nvarchar] (20 ) NULL ,
	[INV HIST Date] [datetime] NULL ,
	[INV HIST Item ID] [nvarchar] (20 ) NULL ,
	[INV HIST Quantity] [float] NULL ,
	[INV HIST Cost] [float] NULL ,
	[INV HIST Memo] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV HIST Sequence INV HIST Sequence [int] NOT NULL  
INV HIST Document No INV HIST Document No [nvarchar](20) NULL  
INV HIST Type INV HIST Type [nvarchar](20) NULL  
INV HIST Date INV HIST Date [datetime] NULL  
INV HIST Item ID INV HIST Item ID [nvarchar](20) NULL  
INV HIST Quantity INV HIST Quantity [float] NULL  
INV HIST Cost INV HIST Cost [float] NULL  
INV HIST Memo INV HIST Memo [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Items
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Items] (
	[INV ITEM Id] [nvarchar] (20 ) NOT NULL ,
	[INV ITEM Inactive YN] [smallint] NULL ,
	[INV ITEM Type] [nvarchar] (20 ) NULL ,
	[INV ITEM Description] [nvarchar] (255 ) NULL ,
	[INV ITEM Category] [nvarchar] (20 ) NULL ,
	[INV ITEM Sales Account] [nvarchar] (50 ) NULL ,
	[INV ITEM Inventory Account] [nvarchar] (50 ) NULL ,
	[INV ITEM Cost of Sales Account] [nvarchar] (50 ) NULL ,
	[INV ITEM Unit] [nvarchar] (20 ) NULL ,
	[INV ITEM Price] [money] NULL ,
	[INV ITEM Taxable YN] [bit] NOT NULL ,
	[INV ITEM Commissionable YN] [bit] NOT NULL ,
	[INV ITEM Pricing Method] [smallint] NULL ,
	[INV ITEM Costing Method] [smallint] NULL ,
	[INV ITEM Vendor ID] [nvarchar] () NULL ,
	[INV ITEM Vendors Number] [nvarchar] (50 ) NULL ,
	[INV ITEM Reorder Level] [float] NULL ,
	[INV ITEM Reorder Qty] [float] NULL ,
	[INV ITEM Qty On Hand] [float] NULL ,
	[INV ITEM Qty On Order] [float] NULL ,
	[INV ITEM Average Cost] [float] NULL ,
	[INV ITEM Last Cost] [float] NULL ,
	[INV ITEM Standard Cost] [float] NULL ,
	[INV ITEM New Price] [float] NULL ,
	[INV ITEM Commission Type] [smallint] NULL ,
	[INV ITEM Commission Percent] [float] NULL ,
	[INV ITEM Saved] [bit] NOT NULL ,
	[INV ITEM Notes] [nvarchar] (2000 ) NULL ,
	[INV ITEM Custom 1] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 2] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 3] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 4] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 5] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 6] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 7] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 8] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 9] [nvarchar] (50 ) NULL ,
	[INV ITEM Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV ITEM Id INV ITEM Id [nvarchar](20) NOT NULL  
INV ITEM Inactive YN INV ITEM Inactive YN [smallint] NULL  
INV ITEM Type INV ITEM Type [nvarchar](20) NULL  
INV ITEM Description INV ITEM Description [nvarchar](255) NULL  
INV ITEM Category INV ITEM Category [nvarchar](20) NULL  
INV ITEM Sales Account INV ITEM Sales Account [nvarchar](50) NULL  
INV ITEM Inventory Account INV ITEM Inventory Account [nvarchar](50) NULL  
INV ITEM Cost of Sales Account INV ITEM Cost of Sales Account [nvarchar](50) NULL  
INV ITEM Unit INV ITEM Unit [nvarchar](20) NULL  
INV ITEM Price INV ITEM Price [money] NULL  
INV ITEM Taxable YN INV ITEM Taxable YN [bit] NOT NULL  
INV ITEM Commissionable YN INV ITEM Commissionable YN [bit] NOT NULL  
INV ITEM Pricing Method INV ITEM Pricing Method [smallint] NULL  
INV ITEM Costing Method INV ITEM Costing Method [smallint] NULL  
INV ITEM Vendor ID INV ITEM Vendor ID [nvarchar](8) NULL  
INV ITEM Vendors Number INV ITEM Vendors Number [nvarchar](50) NULL  
INV ITEM Reorder Level INV ITEM Reorder Level [float] NULL  
INV ITEM Reorder Qty INV ITEM Reorder Qty [float] NULL  
INV ITEM Qty On Hand INV ITEM Qty On Hand [float] NULL  
INV ITEM Qty On Order INV ITEM Qty On Order [float] NULL  
INV ITEM Average Cost INV ITEM Average Cost [float] NULL  
INV ITEM Last Cost INV ITEM Last Cost [float] NULL  
INV ITEM Standard Cost INV ITEM Standard Cost [float] NULL  
INV ITEM New Price INV ITEM New Price [float] NULL  
INV ITEM Commission Type INV ITEM Commission Type [smallint] NULL  
INV ITEM Commission Percent INV ITEM Commission Percent [float] NULL  
INV ITEM Saved INV ITEM Saved [bit] NOT NULL  
INV ITEM Notes INV ITEM Notes [nvarchar](2000) NULL  
INV ITEM Custom 1 INV ITEM Custom 1 [nvarchar](50) NULL  
INV ITEM Custom 2 INV ITEM Custom 2 [nvarchar](50) NULL  
INV ITEM Custom 3 INV ITEM Custom 3 [nvarchar](50) NULL  
INV ITEM Custom 4 INV ITEM Custom 4 [nvarchar](50) NULL  
INV ITEM Custom 5 INV ITEM Custom 5 [nvarchar](50) NULL  
INV ITEM Custom 6 INV ITEM Custom 6 [nvarchar](50) NULL  
INV ITEM Custom 7 INV ITEM Custom 7 [nvarchar](50) NULL  
INV ITEM Custom 8 INV ITEM Custom 8 [nvarchar](50) NULL  
INV ITEM Custom 9 INV ITEM Custom 9 [nvarchar](50) NULL  
INV ITEM Custom 10 INV ITEM Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Items Break
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Items Break] (
	[INV BREAK Counter] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV BREAK ID] [nvarchar] (20 ) NULL ,
	[INV BREAK Description] [nvarchar] (50 ) NULL ,
	[INV BREAK Qty] [float] NULL ,
	[INV BREAK Unit] [nvarchar] (20 ) NULL ,
	[INV BREAK Amount] [float] NULL ,
	[INV BREAK Price] [float] NULL ,
	[INV BREAK Default] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV BREAK Counter INV BREAK Counter [int] NOT NULL  
INV BREAK ID INV BREAK ID [nvarchar](20) NULL  
INV BREAK Description INV BREAK Description [nvarchar](50) NULL  
INV BREAK Qty INV BREAK Qty [float] NULL  
INV BREAK Unit INV BREAK Unit [nvarchar](20) NULL  
INV BREAK Amount INV BREAK Amount [float] NULL  
INV BREAK Price INV BREAK Price [float] NULL  
INV BREAK Default INV BREAK Default [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Kit Items
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Kit Items] (
	[INV KIT Item ID] [nvarchar] (20 ) NULL ,
	[INV KIT Sub Item ID] [nvarchar] (20 ) NULL ,
	[INV KIT Qty] [float] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV KIT Item ID INV KIT Item ID [nvarchar](20) NULL  
INV KIT Sub Item ID INV KIT Sub Item ID [nvarchar](20) NULL  
INV KIT Qty INV KIT Qty [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Kit Items 2
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Kit Items 2] (
	[INV KIT Item ID] [nvarchar] (20 ) NULL ,
	[INV KIT Sub Item ID] [nvarchar] (20 ) NULL ,
	[INV KIT Qty] [float] NULL ,
	[INV KIT SubAssem ID] [nvarchar] (20 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV KIT Item ID INV KIT Item ID [nvarchar](20) NULL  
INV KIT Sub Item ID INV KIT Sub Item ID [nvarchar](20) NULL  
INV KIT Qty INV KIT Qty [float] NULL  
INV KIT SubAssem ID INV KIT SubAssem ID [nvarchar](20) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Kit Items 3
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Kit Items 3] (
	[INV KIT Assy ID] [nvarchar] (20 ) NULL ,
	[INV KIT Sub Item Lvl 2] [nvarchar] (20 ) NULL ,
	[INV KIT Qty 2] [float] NULL ,
	[INV KIT Sub Item Lvl 3] [nvarchar] (20 ) NULL ,
	[INV KIT Qty 3] [float] NULL ,
	[INV KIT Sub Item Lvl 4] [nvarchar] (50 ) NULL ,
	[INV KIT Qty 4] [float] NULL ,
	[INV KIT Sub Item Lvl 5] [nvarchar] (50 ) NULL ,
	[INV KIT Qty 5] [float] NULL ,
	[INV KIT SubAssem ID] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV KIT Assy ID INV KIT Assy ID [nvarchar](20) NULL  
INV KIT Sub Item Lvl 2 INV KIT Sub Item Lvl 2 [nvarchar](20) NULL  
INV KIT Qty 2 INV KIT Qty 2 [float] NULL  
INV KIT Sub Item Lvl 3 INV KIT Sub Item Lvl 3 [nvarchar](20) NULL  
INV KIT Qty 3 INV KIT Qty 3 [float] NULL  
INV KIT Sub Item Lvl 4 INV KIT Sub Item Lvl 4 [nvarchar](50) NULL  
INV KIT Qty 4 INV KIT Qty 4 [float] NULL  
INV KIT Sub Item Lvl 5 INV KIT Sub Item Lvl 5 [nvarchar](50) NULL  
INV KIT Qty 5 INV KIT Qty 5 [float] NULL  
INV KIT SubAssem ID INV KIT SubAssem ID [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Production
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Production] (
	[INV PRO Document No] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV PRO Ext Document No] [nvarchar] (20 ) NULL ,
	[INV PRO Type] [nvarchar] (10 ) NULL ,
	[INV PRO Date] [datetime] NULL ,
	[INV PRO Memo] [nvarchar] (50 ) NULL ,
	[INV PRO Posted YN] [bit] NOT NULL ,
	[INV PRO Notes] [nvarchar] (2000 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV PRO Document No INV PRO Document No [int] NOT NULL  
INV PRO Ext Document No INV PRO Ext Document No [nvarchar](20) NULL  
INV PRO Type INV PRO Type [nvarchar](10) NULL  
INV PRO Date INV PRO Date [datetime] NULL  
INV PRO Memo INV PRO Memo [nvarchar](50) NULL  
INV PRO Posted YN INV PRO Posted YN [bit] NOT NULL  
INV PRO Notes INV PRO Notes [nvarchar](2000) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


INV Production Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[INV Production Detail] (
	[INV PROD ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[INV PROD Document No] [int] NULL ,
	[INV PROD Item ID] [nvarchar] (20 ) NULL ,
	[INV PROD Description] [nvarchar] (255 ) NULL ,
	[INV PROD Quantity] [float] NULL ,
	[INV PROD Cost] [float] NULL ,
	[INV PROD Ext Cost] [float] NULL ,
	[INV PROD Project] [nvarchar] () NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
INV PROD ID INV PROD ID [int] NOT NULL  
INV PROD Document No INV PROD Document No [int] NULL  
INV PROD Item ID INV PROD Item ID [nvarchar](20) NULL  
INV PROD Description INV PROD Description [nvarchar](255) NULL  
INV PROD Quantity INV PROD Quantity [float] NULL  
INV PROD Cost INV PROD Cost [float] NULL  
INV PROD Ext Cost INV PROD Ext Cost [float] NULL  
INV PROD Project INV PROD Project [nvarchar](8) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Invoice Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Invoice Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Last Company
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Last Company] (
	[Last Company] [nvarchar] (255 ) NULL ,
	[date] [nvarchar] (50 ) NULL ,
	[Last User] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Last Company Last Company [nvarchar](255) NULL  
date date [nvarchar](50) NULL  
Last User Last User [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Credit Cards
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Credit Cards] (
	[LIST CC Name] [nvarchar] (50 ) NOT NULL ,
	[LIST CC Card No] [nvarchar] (50 ) NULL ,
	[LIST CC Cardholder] [nvarchar] (50 ) NULL ,
	[LIST CC Exp Date] [datetime] NULL ,
	[LIST Account Number] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST CC Name LIST CC Name [nvarchar](50) NOT NULL  
LIST CC Card No LIST CC Card No [nvarchar](50) NULL  
LIST CC Cardholder LIST CC Cardholder [nvarchar](50) NULL  
LIST CC Exp Date LIST CC Exp Date [datetime] NULL  
LIST Account Number LIST Account Number [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Customer Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Customer Types] (
	[Customer Type] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer Type Customer Type [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Department
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Department] (
	[Department] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Department Department [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Employee Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Employee Types] (
	[LIST EMPLOYEE Types] [nvarchar] (20 ) NOT NULL ,
	[LIST EMPLOYEE Description] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST EMPLOYEE Types LIST EMPLOYEE Types [nvarchar](20) NOT NULL  
LIST EMPLOYEE Description LIST EMPLOYEE Description [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Item Categories
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Item Categories] (
	[Category] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Category Category [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Item Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Item Types] (
	[Type] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Type Type [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Location
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Location] (
	[id] [int] IDENTITY (, 1 ) NOT NULL ,
	[Location] [nvarchar] (30 ) NULL ,
	[Address1] [nvarchar] (50 ) NULL ,
	[Address2] [nvarchar] (50 ) NULL ,
	[City] [nvarchar] (50 ) NULL ,
	[Zip] [nvarchar] (15 ) NULL ,
	[State] [nvarchar] (10 ) NULL ,
	[Country] [nvarchar] (20 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
id id [int] NOT NULL  
Location Location [nvarchar](30) NULL  
Address1 Address1 [nvarchar](50) NULL  
Address2 Address2 [nvarchar](50) NULL  
City City [nvarchar](50) NULL  
Zip Zip [nvarchar](15) NULL  
State State [nvarchar](10) NULL  
Country Country [nvarchar](20) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Payment Methods
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Payment Methods] (
	[LIST PAY Method] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST PAY Method LIST PAY Method [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Payment Terms
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Payment Terms] (
	[LIST PAY Description] [nvarchar] (20 ) NULL ,
	[LIST PAY Net Days] [float] NULL ,
	[LIST PAY Discount] [float] NULL ,
	[LIST PAY Discount Days] [float] NULL ,
	[LIST PAY Expire Day] [float] NULL ,
	[LIST PAY ID] [int] IDENTITY (, 1 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST PAY Description LIST PAY Description [nvarchar](20) NULL  
LIST PAY Net Days LIST PAY Net Days [float] NULL  
LIST PAY Discount LIST PAY Discount [float] NULL  
LIST PAY Discount Days LIST PAY Discount Days [float] NULL  
LIST PAY Expire Day LIST PAY Expire Day [float] NULL  
LIST PAY ID LIST PAY ID [int] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Project Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Project Types] (
	[LIST PROJECT Types] [nvarchar] (20 ) NOT NULL ,
	[LIST PROJECT Description] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST PROJECT Types LIST PROJECT Types [nvarchar](20) NOT NULL  
LIST PROJECT Description LIST PROJECT Description [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Shipping Methods
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Shipping Methods] (
	[LIST SHIP Method] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST SHIP Method LIST SHIP Method [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


LIST Vendor Types
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[LIST Vendor Types] (
	[LIST VENDOR Types] [nvarchar] (20 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
LIST VENDOR Types LIST VENDOR Types [nvarchar](20) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Month End
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Month End] (
	[Locked] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Locked Locked [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Order Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Order Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Payment Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Payment Numbers] (
	[Check No] [nvarchar] (50 ) NOT NULL ,
	[Bank] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Check No Check No [nvarchar](50) NOT NULL  
Bank Bank [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


PREF System Preferences
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[PREF System Preferences] (
	[PREF Resize Forms] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PREF Resize Forms PREF Resize Forms [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Print Aged Payables Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Print Aged Payables Work] (
	[Vendor ID] [nvarchar] (50 ) NULL ,
	[Order] [float] NULL ,
	[Transaction Date] [datetime] NULL ,
	[Transaction Type] [nvarchar] (50 ) NULL ,
	[Transaction ID] [nvarchar] (50 ) NULL ,
	[Transaction Description] [nvarchar] (50 ) NULL ,
	[Applied To] [nvarchar] (50 ) NULL ,
	[Period 1] [money] NULL ,
	[Period 2] [money] NULL ,
	[Period 3] [money] NULL ,
	[Period 4] [money] NULL ,
	[Balance] [money] NULL ,
	[Total] [money] NULL ,
	[Period] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Vendor ID Vendor ID [nvarchar](50) NULL  
Order Order [float] NULL  
Transaction Date Transaction Date [datetime] NULL  
Transaction Type Transaction Type [nvarchar](50) NULL  
Transaction ID Transaction ID [nvarchar](50) NULL  
Transaction Description Transaction Description [nvarchar](50) NULL  
Applied To Applied To [nvarchar](50) NULL  
Period 1 Period 1 [money] NULL  
Period 2 Period 2 [money] NULL  
Period 3 Period 3 [money] NULL  
Period 4 Period 4 [money] NULL  
Balance Balance [money] NULL  
Total Total [money] NULL  
Period Period [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Print Aged Receivables Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Print Aged Receivables Work] (
	[Customer ID] [nvarchar] (50 ) NULL ,
	[Order] [int] NULL ,
	[Transaction Date] [datetime] NULL ,
	[Transaction Type] [nvarchar] (50 ) NULL ,
	[Transaction ID] [nvarchar] (50 ) NULL ,
	[Transaction Description] [nvarchar] (50 ) NULL ,
	[Applied To] [nvarchar] (50 ) NULL ,
	[Period 1] [money] NULL ,
	[Period 2] [money] NULL ,
	[Period 3] [money] NULL ,
	[Period 4] [money] NULL ,
	[Balance] [money] NULL ,
	[Total] [money] NULL ,
	[Period] [smallint] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer ID Customer ID [nvarchar](50) NULL  
Order Order [int] NULL  
Transaction Date Transaction Date [datetime] NULL  
Transaction Type Transaction Type [nvarchar](50) NULL  
Transaction ID Transaction ID [nvarchar](50) NULL  
Transaction Description Transaction Description [nvarchar](50) NULL  
Applied To Applied To [nvarchar](50) NULL  
Period 1 Period 1 [money] NULL  
Period 2 Period 2 [money] NULL  
Period 3 Period 3 [money] NULL  
Period 4 Period 4 [money] NULL  
Balance Balance [money] NULL  
Total Total [money] NULL  
Period Period [smallint] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Print Check Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Print Check Work] (
	[Vendor ID] [nvarchar] (50 ) NULL ,
	[Check Number] [nvarchar] (50 ) NULL ,
	[Total Amount] [money] NULL ,
	[Transaction Date] [datetime] NULL ,
	[Order] [float] NULL ,
	[Visible] [bit] NOT NULL ,
	[Reference #] [nvarchar] (50 ) NULL ,
	[Invoice #] [nvarchar] (50 ) NULL ,
	[Invoice Date] [nvarchar] (50 ) NULL ,
	[Invoice Amt] [money] NULL ,
	[Amount Paid] [money] NULL ,
	[Discount] [money] NULL ,
	[Net Amt] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Vendor ID Vendor ID [nvarchar](50) NULL  
Check Number Check Number [nvarchar](50) NULL  
Total Amount Total Amount [money] NULL  
Transaction Date Transaction Date [datetime] NULL  
Order Order [float] NULL  
Visible Visible [bit] NOT NULL  
Reference # Reference # [nvarchar](50) NULL  
Invoice # Invoice # [nvarchar](50) NULL  
Invoice Date Invoice Date [nvarchar](50) NULL  
Invoice Amt Invoice Amt [money] NULL  
Amount Paid Amount Paid [money] NULL  
Discount Discount [money] NULL  
Net Amt Net Amt [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Print Statement Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Print Statement Work] (
	[Customer ID] [nvarchar] (50 ) NULL ,
	[Order] [float] NULL ,
	[Transaction Date] [datetime] NULL ,
	[Transaction Type] [nvarchar] (50 ) NULL ,
	[Transaction ID] [nvarchar] (50 ) NULL ,
	[Transaction Description] [nvarchar] (50 ) NULL ,
	[Applied To] [nvarchar] (50 ) NULL ,
	[Amount] [money] NULL ,
	[Balance] [money] NULL ,
	[Current] [money] NULL ,
	[1-30 Days] [money] NULL ,
	[31-60 Days] [money] NULL ,
	[61-90 Days] [money] NULL ,
	[Over 90 Days] [money] NULL ,
	[Total] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer ID Customer ID [nvarchar](50) NULL  
Order Order [float] NULL  
Transaction Date Transaction Date [datetime] NULL  
Transaction Type Transaction Type [nvarchar](50) NULL  
Transaction ID Transaction ID [nvarchar](50) NULL  
Transaction Description Transaction Description [nvarchar](50) NULL  
Applied To Applied To [nvarchar](50) NULL  
Amount Amount [money] NULL  
Balance Balance [money] NULL  
Current Current [money] NULL  
1-30 Days 1-30 Days [money] NULL  
31-60 Days 31-60 Days [money] NULL  
61-90 Days 61-90 Days [money] NULL  
Over 90 Days Over 90 Days [money] NULL  
Total Total [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Print Statement Work 2
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Print Statement Work 2] (
	[Customer ID] [nvarchar] (50 ) NULL ,
	[Customer Name] [nvarchar] (50 ) NULL ,
	[Selected] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer ID Customer ID [nvarchar](50) NULL  
Customer Name Customer Name [nvarchar](50) NULL  
Selected Selected [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Production Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Production Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


PROJ History
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[PROJ History] (
	[PROJ HIST Sequence] [int] IDENTITY (, 1 ) NOT NULL ,
	[PROJ HIST Document No] [nvarchar] (20 ) NULL ,
	[PROJ HIST Type] [nvarchar] (20 ) NULL ,
	[PROJ HIST Date] [datetime] NULL ,
	[PROJ HIST Project ID] [nvarchar] () NULL ,
	[PROJ HIST Revenue] [float] NULL ,
	[PROJ HIST Cost] [float] NULL ,
	[PROJ HIST Memo] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PROJ HIST Sequence PROJ HIST Sequence [int] NOT NULL  
PROJ HIST Document No PROJ HIST Document No [nvarchar](20) NULL  
PROJ HIST Type PROJ HIST Type [nvarchar](20) NULL  
PROJ HIST Date PROJ HIST Date [datetime] NULL  
PROJ HIST Project ID PROJ HIST Project ID [nvarchar](8) NULL  
PROJ HIST Revenue PROJ HIST Revenue [float] NULL  
PROJ HIST Cost PROJ HIST Cost [float] NULL  
PROJ HIST Memo PROJ HIST Memo [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


PROJ Projects
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[PROJ Projects] (
	[PROJ ID] [nvarchar] () NOT NULL ,
	[PROJ Name] [nvarchar] (30 ) NULL ,
	[PROJ Description] [nvarchar] (255 ) NULL ,
	[PROJ Customer ID] [nvarchar] () NULL ,
	[PROJ Type] [nvarchar] (50 ) NULL ,
	[PROJ Start Date] [datetime] NULL ,
	[PROJ Completion Date] [datetime] NULL ,
	[PROJ Estimated Revenue] [float] NULL ,
	[PROJ Estimated Cost] [float] NULL ,
	[PROJ Actual Revenue] [float] NULL ,
	[PROJ Actual Cost] [float] NULL ,
	[PROJ Project Manager] [nvarchar] (30 ) NULL ,
	[PROJ Notes] [nvarchar] (2000 ) NULL ,
	[PROJ Saved] [smallint] NULL ,
	[PROJ Custom 1] [nvarchar] (50 ) NULL ,
	[PROJ Custom 2] [nvarchar] (50 ) NULL ,
	[PROJ Custom 3] [nvarchar] (50 ) NULL ,
	[PROJ Custom 4] [nvarchar] (50 ) NULL ,
	[PROJ Custom 5] [nvarchar] (50 ) NULL ,
	[PROJ Custom 6] [nvarchar] (50 ) NULL ,
	[PROJ Custom 7] [nvarchar] (50 ) NULL ,
	[PROJ Custom 8] [nvarchar] (50 ) NULL ,
	[PROJ Custom 9] [nvarchar] (50 ) NULL ,
	[PROJ Custom 10] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PROJ ID PROJ ID [nvarchar](8) NOT NULL  
PROJ Name PROJ Name [nvarchar](30) NULL  
PROJ Description PROJ Description [nvarchar](255) NULL  
PROJ Customer ID PROJ Customer ID [nvarchar](8) NULL  
PROJ Type PROJ Type [nvarchar](50) NULL  
PROJ Start Date PROJ Start Date [datetime] NULL  
PROJ Completion Date PROJ Completion Date [datetime] NULL  
PROJ Estimated Revenue PROJ Estimated Revenue [float] NULL  
PROJ Estimated Cost PROJ Estimated Cost [float] NULL  
PROJ Actual Revenue PROJ Actual Revenue [float] NULL  
PROJ Actual Cost PROJ Actual Cost [float] NULL  
PROJ Project Manager PROJ Project Manager [nvarchar](30) NULL  
PROJ Notes PROJ Notes [nvarchar](2000) NULL  
PROJ Saved PROJ Saved [smallint] NULL  
PROJ Custom 1 PROJ Custom 1 [nvarchar](50) NULL  
PROJ Custom 2 PROJ Custom 2 [nvarchar](50) NULL  
PROJ Custom 3 PROJ Custom 3 [nvarchar](50) NULL  
PROJ Custom 4 PROJ Custom 4 [nvarchar](50) NULL  
PROJ Custom 5 PROJ Custom 5 [nvarchar](50) NULL  
PROJ Custom 6 PROJ Custom 6 [nvarchar](50) NULL  
PROJ Custom 7 PROJ Custom 7 [nvarchar](50) NULL  
PROJ Custom 8 PROJ Custom 8 [nvarchar](50) NULL  
PROJ Custom 9 PROJ Custom 9 [nvarchar](50) NULL  
PROJ Custom 10 PROJ Custom 10 [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Purchase Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Purchase Numbers] (
	[Document ID] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document ID Document ID [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Empl Payroll Items
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Empl Payroll Items] (
	[PyrlItemID] [nvarchar] (10 ) NULL ,
	[EMP ID] [nvarchar] () NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[Basis] [nvarchar] (50 ) NULL ,
	[Type] [nvarchar] (50 ) NULL ,
	[YTDMax] [money] NULL ,
	[Minimum] [money] NULL ,
	[WageHigh] [money] NULL ,
	[WageLow] [money] NULL ,
	[ItemAmount] [money] NULL ,
	[ItemPercent] [real] NULL ,
	[PercentAmount] [money] NULL ,
	[TotalAmount] [money] NULL ,
	[ApplyItem] [bit] NOT NULL ,
	[Account] [nvarchar] (50 ) NULL ,
	[Account2] [nvarchar] (50 ) NULL ,
	[Account3] [nvarchar] (50 ) NULL ,
	[EmployerItemAmount] [money] NULL ,
	[EmployerItemPercent] [real] NULL ,
	[EmployerPercentAmount] [money] NULL ,
	[EmployerTotalAmount] [money] NULL ,
	[EmployerYN] [bit] NOT NULL ,
	[W2Box1] [nvarchar] (15 ) NULL ,
	[W2Box2] [nvarchar] (15 ) NULL ,
	[W2Box3] [nvarchar] (15 ) NULL ,
	[W2Box4] [nvarchar] (15 ) NULL ,
	[W2Box5] [nvarchar] (15 ) NULL ,
	[W2Box6] [nvarchar] (15 ) NULL ,
	[W2Box7] [nvarchar] (15 ) NULL ,
	[W2Box8] [nvarchar] (15 ) NULL ,
	[W2Box9] [nvarchar] (15 ) NULL ,
	[W2Box10] [nvarchar] (15 ) NULL ,
	[W2Box11] [nvarchar] (15 ) NULL ,
	[W2Box12] [nvarchar] (15 ) NULL ,
	[W2Box13] [nvarchar] (15 ) NULL ,
	[W2Box13b] [nvarchar] (15 ) NULL ,
	[W2Box14] [nvarchar] (15 ) NULL ,
	[W2Box15] [nvarchar] (15 ) NULL ,
	[W2Box17] [nvarchar] (15 ) NULL ,
	[W2Box18] [nvarchar] (15 ) NULL ,
	[W2Box20] [nvarchar] (15 ) NULL ,
	[W2Box21] [nvarchar] (15 ) NULL ,
	[Frm941Line2] [nvarchar] (15 ) NULL ,
	[Frm941Line3] [nvarchar] (15 ) NULL ,
	[Frm941Line4] [nvarchar] (15 ) NULL ,
	[Frm941Line6a] [nvarchar] (15 ) NULL ,
	[Frm941Line6b] [nvarchar] (15 ) NULL ,
	[Frm941Line7] [nvarchar] (15 ) NULL ,
	[Frm941Line9] [nvarchar] (15 ) NULL ,
	[Frm941Line12] [nvarchar] (15 ) NULL ,
	[Default] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PyrlItemID PyrlItemID [nvarchar](10) NULL  
EMP ID EMP ID [nvarchar](8) NULL  
Description Description [nvarchar](50) NULL  
Basis Basis [nvarchar](50) NULL  
Type Type [nvarchar](50) NULL  
YTDMax YTDMax [money] NULL  
Minimum Minimum [money] NULL  
WageHigh WageHigh [money] NULL  
WageLow WageLow [money] NULL  
ItemAmount ItemAmount [money] NULL  
ItemPercent ItemPercent [real] NULL  
PercentAmount PercentAmount [money] NULL  
TotalAmount TotalAmount [money] NULL  
ApplyItem ApplyItem [bit] NOT NULL  
Account Account [nvarchar](50) NULL  
Account2 Account2 [nvarchar](50) NULL  
Account3 Account3 [nvarchar](50) NULL  
EmployerItemAmount EmployerItemAmount [money] NULL  
EmployerItemPercent EmployerItemPercent [real] NULL  
EmployerPercentAmount EmployerPercentAmount [money] NULL  
EmployerTotalAmount EmployerTotalAmount [money] NULL  
EmployerYN EmployerYN [bit] NOT NULL  
W2Box1 W2Box1 [nvarchar](15) NULL  
W2Box2 W2Box2 [nvarchar](15) NULL  
W2Box3 W2Box3 [nvarchar](15) NULL  
W2Box4 W2Box4 [nvarchar](15) NULL  
W2Box5 W2Box5 [nvarchar](15) NULL  
W2Box6 W2Box6 [nvarchar](15) NULL  
W2Box7 W2Box7 [nvarchar](15) NULL  
W2Box8 W2Box8 [nvarchar](15) NULL  
W2Box9 W2Box9 [nvarchar](15) NULL  
W2Box10 W2Box10 [nvarchar](15) NULL  
W2Box11 W2Box11 [nvarchar](15) NULL  
W2Box12 W2Box12 [nvarchar](15) NULL  
W2Box13 W2Box13 [nvarchar](15) NULL  
W2Box13b W2Box13b [nvarchar](15) NULL  
W2Box14 W2Box14 [nvarchar](15) NULL  
W2Box15 W2Box15 [nvarchar](15) NULL  
W2Box17 W2Box17 [nvarchar](15) NULL  
W2Box18 W2Box18 [nvarchar](15) NULL  
W2Box20 W2Box20 [nvarchar](15) NULL  
W2Box21 W2Box21 [nvarchar](15) NULL  
Frm941Line2 Frm941Line2 [nvarchar](15) NULL  
Frm941Line3 Frm941Line3 [nvarchar](15) NULL  
Frm941Line4 Frm941Line4 [nvarchar](15) NULL  
Frm941Line6a Frm941Line6a [nvarchar](15) NULL  
Frm941Line6b Frm941Line6b [nvarchar](15) NULL  
Frm941Line7 Frm941Line7 [nvarchar](15) NULL  
Frm941Line9 Frm941Line9 [nvarchar](15) NULL  
Frm941Line12 Frm941Line12 [nvarchar](15) NULL  
Default Default [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Employee Data
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Employee Data] (
	[PAY] [bit] NOT NULL ,
	[EMP ID] [nvarchar] () NOT NULL ,
	[SS#] [nvarchar] (15 ) NULL ,
	[DEPARTMENT] [nvarchar] (50 ) NULL ,
	[LOCATION] [nvarchar] (50 ) NULL ,
	[PAYTYPE] [nvarchar] (50 ) NULL ,
	[PAYFREQUENCY] [nvarchar] (50 ) NULL ,
	[SALARY] [money] NULL ,
	[HOURLYRATE] [money] NULL ,
	[COMMRATE] [int] NULL ,
	[COMMPERCENT] [int] NULL ,
	[OTRATE] [money] NULL ,
	[FICAYN] [bit] NOT NULL ,
	[FITYN] [bit] NOT NULL ,
	[FEDALLOW] [int] NULL ,
	[STATEALLOW] [int] NULL ,
	[LOCALALLOW] [int] NULL ,
	[FEDWITHHOLDAMT] [money] NULL ,
	[STATEWITHHOLDAMT] [money] NULL ,
	[LOCALWITHHOLDAMT] [money] NULL ,
	[FEDFILINGSTATUS] [nvarchar] (50 ) NULL ,
	[STATEFILINGSTATUS] [nvarchar] (50 ) NULL ,
	[LOCALFILINGSTATUS] [nvarchar] (50 ) NULL ,
	[MALEFEMALE] [nvarchar] (50 ) NULL ,
	[LASTGROSS] [money] NULL ,
	[LASTAGI] [money] NULL ,
	[LASTFICA] [money] NULL ,
	[LASTFIT] [money] NULL ,
	[LASTSTATETAX] [money] NULL ,
	[LASTLOCAL] [money] NULL ,
	[LASTCOMMISSION] [money] NULL ,
	[YTDFIT] [money] NULL ,
	[YTDSTATETAX] [money] NULL ,
	[YTDLOCAL] [money] NULL ,
	[YTDGROSS] [money] NULL ,
	[YTDFICA] [money] NULL ,
	[LASTHOURS] [real] NULL ,
	[LASTDATE] [datetime] NULL ,
	[AMOUNT] [money] NULL ,
	[NETCHECK] [money] NULL ,
	[ADDITIONS] [money] NULL ,
	[DEDUCTIONS] [money] NULL ,
	[PRETAXDED] [money] NULL ,
	[YTDOTHOURS] [real] NULL ,
	[YTDREGHOURS] [real] NULL ,
	[BlankCheckHourlyRate] [money] NULL ,
	[BlankCheckOTRate] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PAY PAY [bit] NOT NULL  
EMP ID EMP ID [nvarchar](8) NOT NULL  
SS# SS# [nvarchar](15) NULL  
DEPARTMENT DEPARTMENT [nvarchar](50) NULL  
LOCATION LOCATION [nvarchar](50) NULL  
PAYTYPE PAYTYPE [nvarchar](50) NULL  
PAYFREQUENCY PAYFREQUENCY [nvarchar](50) NULL  
SALARY SALARY [money] NULL  
HOURLYRATE HOURLYRATE [money] NULL  
COMMRATE COMMRATE [int] NULL  
COMMPERCENT COMMPERCENT [int] NULL  
OTRATE OTRATE [money] NULL  
FICAYN FICAYN [bit] NOT NULL  
FITYN FITYN [bit] NOT NULL  
FEDALLOW FEDALLOW [int] NULL  
STATEALLOW STATEALLOW [int] NULL  
LOCALALLOW LOCALALLOW [int] NULL  
FEDWITHHOLDAMT FEDWITHHOLDAMT [money] NULL  
STATEWITHHOLDAMT STATEWITHHOLDAMT [money] NULL  
LOCALWITHHOLDAMT LOCALWITHHOLDAMT [money] NULL  
FEDFILINGSTATUS FEDFILINGSTATUS [nvarchar](50) NULL  
STATEFILINGSTATUS STATEFILINGSTATUS [nvarchar](50) NULL  
LOCALFILINGSTATUS LOCALFILINGSTATUS [nvarchar](50) NULL  
MALEFEMALE MALEFEMALE [nvarchar](50) NULL  
LASTGROSS LASTGROSS [money] NULL  
LASTAGI LASTAGI [money] NULL  
LASTFICA LASTFICA [money] NULL  
LASTFIT LASTFIT [money] NULL  
LASTSTATETAX LASTSTATETAX [money] NULL  
LASTLOCAL LASTLOCAL [money] NULL  
LASTCOMMISSION LASTCOMMISSION [money] NULL  
YTDFIT YTDFIT [money] NULL  
YTDSTATETAX YTDSTATETAX [money] NULL  
YTDLOCAL YTDLOCAL [money] NULL  
YTDGROSS YTDGROSS [money] NULL  
YTDFICA YTDFICA [money] NULL  
LASTHOURS LASTHOURS [real] NULL  
LASTDATE LASTDATE [datetime] NULL  
AMOUNT AMOUNT [money] NULL  
NETCHECK NETCHECK [money] NULL  
ADDITIONS ADDITIONS [money] NULL  
DEDUCTIONS DEDUCTIONS [money] NULL  
PRETAXDED PRETAXDED [money] NULL  
YTDOTHOURS YTDOTHOURS [real] NULL  
YTDREGHOURS YTDREGHOURS [real] NULL  
BlankCheckHourlyRate BlankCheckHourlyRate [money] NULL  
BlankCheckOTRate BlankCheckOTRate [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - GL Trans Detail Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - GL Trans Detail Work] (
	[GL TRANSD Number] [int] NULL ,
	[GL TRANSD Account] [nvarchar] (50 ) NULL ,
	[GL TRANSD Department] [nvarchar] () NULL ,
	[GL TRANSD Debit Amount] [float] NULL ,
	[GL TRANSD Credit Amount] [float] NULL ,
	[GL TRANSD Project] [nvarchar] () NULL ,
	[GL TRANSD ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[CheckNumber] [int] NULL ,
	[BankAcctNumber] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GL TRANSD Number GL TRANSD Number [int] NULL  
GL TRANSD Account GL TRANSD Account [nvarchar](50) NULL  
GL TRANSD Department GL TRANSD Department [nvarchar](5) NULL  
GL TRANSD Debit Amount GL TRANSD Debit Amount [float] NULL  
GL TRANSD Credit Amount GL TRANSD Credit Amount [float] NULL  
GL TRANSD Project GL TRANSD Project [nvarchar](8) NULL  
GL TRANSD ID GL TRANSD ID [int] NOT NULL  
CheckNumber CheckNumber [int] NULL  
BankAcctNumber BankAcctNumber [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - ItemsBegBalWork
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - ItemsBegBalWork] (
	[EmployeeID] [nvarchar] (50 ) NULL ,
	[EmployeeName] [nvarchar] (50 ) NULL ,
	[ItemID] [nvarchar] (10 ) NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[TotalAmount] [money] NULL ,
	[CheckDate] [datetime] NULL ,
	[CheckNumber] [int] NULL ,
	[Basis] [nvarchar] (50 ) NULL ,
	[Type] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EmployeeID EmployeeID [nvarchar](50) NULL  
EmployeeName EmployeeName [nvarchar](50) NULL  
ItemID ItemID [nvarchar](10) NULL  
Description Description [nvarchar](50) NULL  
TotalAmount TotalAmount [money] NULL  
CheckDate CheckDate [datetime] NULL  
CheckNumber CheckNumber [int] NULL  
Basis Basis [nvarchar](50) NULL  
Type Type [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Payroll Items
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Payroll Items] (
	[PyrlItemID] [nvarchar] (10 ) NOT NULL ,
	[EMP ID] [nvarchar] () NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[Basis] [nvarchar] (50 ) NULL ,
	[Type] [nvarchar] (50 ) NULL ,
	[YTDMax] [money] NULL ,
	[Minimum] [money] NULL ,
	[WageHigh] [money] NULL ,
	[WageLow] [money] NULL ,
	[ItemAmount] [money] NULL ,
	[ItemPercent] [real] NULL ,
	[PercentAmount] [money] NULL ,
	[TotalAmount] [money] NULL ,
	[ApplyItem] [bit] NOT NULL ,
	[Account] [nvarchar] (50 ) NULL ,
	[Account2] [nvarchar] (50 ) NULL ,
	[Account3] [nvarchar] (50 ) NULL ,
	[EmployerItemAmount] [money] NULL ,
	[EmployerItemPercent] [real] NULL ,
	[EmployerPercentAmount] [money] NULL ,
	[EmployerTotalAmount] [money] NULL ,
	[EmployerYN] [bit] NOT NULL ,
	[W2Box1] [nvarchar] (15 ) NULL ,
	[W2Box2] [nvarchar] (15 ) NULL ,
	[W2Box3] [nvarchar] (15 ) NULL ,
	[W2Box4] [nvarchar] (15 ) NULL ,
	[W2Box5] [nvarchar] (15 ) NULL ,
	[W2Box6] [nvarchar] (15 ) NULL ,
	[W2Box7] [nvarchar] (15 ) NULL ,
	[W2Box8] [nvarchar] (15 ) NULL ,
	[W2Box9] [nvarchar] (15 ) NULL ,
	[W2Box10] [nvarchar] (15 ) NULL ,
	[W2Box11] [nvarchar] (15 ) NULL ,
	[W2Box12] [nvarchar] (15 ) NULL ,
	[W2Box13] [nvarchar] (15 ) NULL ,
	[W2Box13b] [nvarchar] (15 ) NULL ,
	[W2Box14] [nvarchar] (15 ) NULL ,
	[W2Box15] [nvarchar] (15 ) NULL ,
	[W2Box17] [nvarchar] (15 ) NULL ,
	[W2Box18] [nvarchar] (15 ) NULL ,
	[W2Box20] [nvarchar] (15 ) NULL ,
	[W2Box21] [nvarchar] (15 ) NULL ,
	[Frm941Line2] [nvarchar] (15 ) NULL ,
	[Frm941Line3] [nvarchar] (15 ) NULL ,
	[Frm941Line4] [nvarchar] (15 ) NULL ,
	[Frm941Line6a] [nvarchar] (15 ) NULL ,
	[Frm941Line6b] [nvarchar] (15 ) NULL ,
	[Frm941Line7] [nvarchar] (15 ) NULL ,
	[Frm941Line9] [nvarchar] (15 ) NULL ,
	[Frm941Line12] [nvarchar] (15 ) NULL ,
	[Default] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PyrlItemID PyrlItemID [nvarchar](10) NOT NULL  
EMP ID EMP ID [nvarchar](8) NULL  
Description Description [nvarchar](50) NULL  
Basis Basis [nvarchar](50) NULL  
Type Type [nvarchar](50) NULL  
YTDMax YTDMax [money] NULL  
Minimum Minimum [money] NULL  
WageHigh WageHigh [money] NULL  
WageLow WageLow [money] NULL  
ItemAmount ItemAmount [money] NULL  
ItemPercent ItemPercent [real] NULL  
PercentAmount PercentAmount [money] NULL  
TotalAmount TotalAmount [money] NULL  
ApplyItem ApplyItem [bit] NOT NULL  
Account Account [nvarchar](50) NULL  
Account2 Account2 [nvarchar](50) NULL  
Account3 Account3 [nvarchar](50) NULL  
EmployerItemAmount EmployerItemAmount [money] NULL  
EmployerItemPercent EmployerItemPercent [real] NULL  
EmployerPercentAmount EmployerPercentAmount [money] NULL  
EmployerTotalAmount EmployerTotalAmount [money] NULL  
EmployerYN EmployerYN [bit] NOT NULL  
W2Box1 W2Box1 [nvarchar](15) NULL  
W2Box2 W2Box2 [nvarchar](15) NULL  
W2Box3 W2Box3 [nvarchar](15) NULL  
W2Box4 W2Box4 [nvarchar](15) NULL  
W2Box5 W2Box5 [nvarchar](15) NULL  
W2Box6 W2Box6 [nvarchar](15) NULL  
W2Box7 W2Box7 [nvarchar](15) NULL  
W2Box8 W2Box8 [nvarchar](15) NULL  
W2Box9 W2Box9 [nvarchar](15) NULL  
W2Box10 W2Box10 [nvarchar](15) NULL  
W2Box11 W2Box11 [nvarchar](15) NULL  
W2Box12 W2Box12 [nvarchar](15) NULL  
W2Box13 W2Box13 [nvarchar](15) NULL  
W2Box13b W2Box13b [nvarchar](15) NULL  
W2Box14 W2Box14 [nvarchar](15) NULL  
W2Box15 W2Box15 [nvarchar](15) NULL  
W2Box17 W2Box17 [nvarchar](15) NULL  
W2Box18 W2Box18 [nvarchar](15) NULL  
W2Box20 W2Box20 [nvarchar](15) NULL  
W2Box21 W2Box21 [nvarchar](15) NULL  
Frm941Line2 Frm941Line2 [nvarchar](15) NULL  
Frm941Line3 Frm941Line3 [nvarchar](15) NULL  
Frm941Line4 Frm941Line4 [nvarchar](15) NULL  
Frm941Line6a Frm941Line6a [nvarchar](15) NULL  
Frm941Line6b Frm941Line6b [nvarchar](15) NULL  
Frm941Line7 Frm941Line7 [nvarchar](15) NULL  
Frm941Line9 Frm941Line9 [nvarchar](15) NULL  
Frm941Line12 Frm941Line12 [nvarchar](15) NULL  
Default Default [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Qtr Report Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Qtr Report Work] (
	[CHECKDATE] [datetime] NULL ,
	[SumOfGROSS] [money] NULL ,
	[SumOfAGI] [money] NULL ,
	[SumOfFIT] [money] NULL ,
	[SumOfFICA] [money] NULL ,
	[SumOfFICAer] [money] NULL ,
	[SumOfPreTax] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CHECKDATE CHECKDATE [datetime] NULL  
SumOfGROSS SumOfGROSS [money] NULL  
SumOfAGI SumOfAGI [money] NULL  
SumOfFIT SumOfFIT [money] NULL  
SumOfFICA SumOfFICA [money] NULL  
SumOfFICAer SumOfFICAer [money] NULL  
SumOfPreTax SumOfPreTax [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Register
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Register] (
	[ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[EMP ID] [nvarchar] () NULL ,
	[NAME] [nvarchar] (50 ) NULL ,
	[STARTDATE] [datetime] NULL ,
	[DATE] [datetime] NULL ,
	[CHECKDATE] [datetime] NULL ,
	[GROSS] [money] NULL ,
	[PRETAXDED] [money] NULL ,
	[YTDGROSS] [money] NULL ,
	[AGI] [money] NULL ,
	[FICA] [money] NULL ,
	[FICAER] [money] NULL ,
	[FIT] [money] NULL ,
	[STATETAX] [money] NULL ,
	[LOCAL] [money] NULL ,
	[ADDITIONS] [money] NULL ,
	[COMMISSION] [money] NULL ,
	[DEDUCTIONS] [money] NULL ,
	[NETPAY] [money] NULL ,
	[VOIDED] [bit] NOT NULL ,
	[RECONCILED] [bit] NOT NULL ,
	[CHECKTYPE] [nvarchar] (50 ) NULL ,
	[CHECKNUMBER] [int] NULL ,
	[PRINTED] [bit] NOT NULL ,
	[REGHOURS] [real] NULL ,
	[OTHOURS] [real] NULL ,
	[OTRATE] [money] NULL ,
	[HOURLYRATE] [money] NULL ,
	[AMOUNT] [money] NULL ,
	[FUTA] [money] NULL ,
	[SUI] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ID ID [int] NOT NULL  
EMP ID EMP ID [nvarchar](8) NULL  
NAME NAME [nvarchar](50) NULL  
STARTDATE STARTDATE [datetime] NULL  
DATE DATE [datetime] NULL  
CHECKDATE CHECKDATE [datetime] NULL  
GROSS GROSS [money] NULL  
PRETAXDED PRETAXDED [money] NULL  
YTDGROSS YTDGROSS [money] NULL  
AGI AGI [money] NULL  
FICA FICA [money] NULL  
FICAER FICAER [money] NULL  
FIT FIT [money] NULL  
STATETAX STATETAX [money] NULL  
LOCAL LOCAL [money] NULL  
ADDITIONS ADDITIONS [money] NULL  
COMMISSION COMMISSION [money] NULL  
DEDUCTIONS DEDUCTIONS [money] NULL  
NETPAY NETPAY [money] NULL  
VOIDED VOIDED [bit] NOT NULL  
RECONCILED RECONCILED [bit] NOT NULL  
CHECKTYPE CHECKTYPE [nvarchar](50) NULL  
CHECKNUMBER CHECKNUMBER [int] NULL  
PRINTED PRINTED [bit] NOT NULL  
REGHOURS REGHOURS [real] NULL  
OTHOURS OTHOURS [real] NULL  
OTRATE OTRATE [money] NULL  
HOURLYRATE HOURLYRATE [money] NULL  
AMOUNT AMOUNT [money] NULL  
FUTA FUTA [money] NULL  
SUI SUI [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Register Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Register Detail] (
	[PyrlItemID] [nvarchar] (10 ) NULL ,
	[EMP ID] [nvarchar] () NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[Basis] [nvarchar] (50 ) NULL ,
	[Type] [nvarchar] (50 ) NULL ,
	[YTDMax] [money] NULL ,
	[Minimum] [nvarchar] (50 ) NULL ,
	[WageHigh] [money] NULL ,
	[WageLow] [money] NULL ,
	[ItemAmount] [money] NULL ,
	[ItemPercent] [real] NULL ,
	[PercentAmount] [money] NULL ,
	[TotalAmount] [money] NULL ,
	[ApplyItem] [bit] NOT NULL ,
	[Account] [nvarchar] (50 ) NULL ,
	[Account2] [nvarchar] (50 ) NULL ,
	[Account3] [nvarchar] (50 ) NULL ,
	[EmployerItemAmount] [money] NULL ,
	[EmployerItemPercent] [real] NULL ,
	[EmployerPercentAmount] [money] NULL ,
	[EmployerTotalAmount] [money] NULL ,
	[EmployerYN] [bit] NOT NULL ,
	[ID] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PyrlItemID PyrlItemID [nvarchar](10) NULL  
EMP ID EMP ID [nvarchar](8) NULL  
Description Description [nvarchar](50) NULL  
Basis Basis [nvarchar](50) NULL  
Type Type [nvarchar](50) NULL  
YTDMax YTDMax [money] NULL  
Minimum Minimum [nvarchar](50) NULL  
WageHigh WageHigh [money] NULL  
WageLow WageLow [money] NULL  
ItemAmount ItemAmount [money] NULL  
ItemPercent ItemPercent [real] NULL  
PercentAmount PercentAmount [money] NULL  
TotalAmount TotalAmount [money] NULL  
ApplyItem ApplyItem [bit] NOT NULL  
Account Account [nvarchar](50) NULL  
Account2 Account2 [nvarchar](50) NULL  
Account3 Account3 [nvarchar](50) NULL  
EmployerItemAmount EmployerItemAmount [money] NULL  
EmployerItemPercent EmployerItemPercent [real] NULL  
EmployerPercentAmount EmployerPercentAmount [money] NULL  
EmployerTotalAmount EmployerTotalAmount [money] NULL  
EmployerYN EmployerYN [bit] NOT NULL  
ID ID [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Register Detail Commissions
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Register Detail Commissions] (
	[DocNo] [int] NULL ,
	[ExtDocNo] [nvarchar] (20 ) NULL ,
	[DocType] [nvarchar] (20 ) NULL ,
	[Commission] [money] NULL ,
	[ID] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
DocNo DocNo [int] NULL  
ExtDocNo ExtDocNo [nvarchar](20) NULL  
DocType DocType [nvarchar](20) NULL  
Commission Commission [money] NULL  
ID ID [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Select Pyrl Items Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Select Pyrl Items Work] (
	[PyrlItemID] [nvarchar] (10 ) NULL ,
	[EMP ID] [nvarchar] () NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[Basis] [nvarchar] (50 ) NULL ,
	[Type] [nvarchar] (50 ) NULL ,
	[YTDMax] [money] NULL ,
	[Minimum] [money] NULL ,
	[WageHigh] [money] NULL ,
	[WageLow] [money] NULL ,
	[ItemAmount] [money] NULL ,
	[ItemPercent] [real] NULL ,
	[PercentAmount] [money] NULL ,
	[TotalAmount] [money] NULL ,
	[ApplyItem] [bit] NOT NULL ,
	[Account] [nvarchar] (50 ) NULL ,
	[Account2] [nvarchar] (50 ) NULL ,
	[Account3] [nvarchar] (50 ) NULL ,
	[EmployerItemAmount] [money] NULL ,
	[EmployerItemPercent] [real] NULL ,
	[EmployerPercentAmount] [money] NULL ,
	[EmployerTotalAmount] [money] NULL ,
	[EmployerYN] [bit] NOT NULL ,
	[W2Box1] [nvarchar] (15 ) NULL ,
	[W2Box2] [nvarchar] (15 ) NULL ,
	[W2Box3] [nvarchar] (15 ) NULL ,
	[W2Box4] [nvarchar] (15 ) NULL ,
	[W2Box5] [nvarchar] (15 ) NULL ,
	[W2Box6] [nvarchar] (15 ) NULL ,
	[W2Box7] [nvarchar] (15 ) NULL ,
	[W2Box8] [nvarchar] (15 ) NULL ,
	[W2Box9] [nvarchar] (15 ) NULL ,
	[W2Box10] [nvarchar] (15 ) NULL ,
	[W2Box11] [nvarchar] (15 ) NULL ,
	[W2Box12] [nvarchar] (15 ) NULL ,
	[W2Box13] [nvarchar] (15 ) NULL ,
	[W2Box13b] [nvarchar] (15 ) NULL ,
	[W2Box14] [nvarchar] (15 ) NULL ,
	[W2Box15] [nvarchar] (15 ) NULL ,
	[W2Box17] [nvarchar] (15 ) NULL ,
	[W2Box18] [nvarchar] (15 ) NULL ,
	[W2Box20] [nvarchar] (15 ) NULL ,
	[W2Box21] [nvarchar] (15 ) NULL ,
	[Frm941Line2] [nvarchar] (15 ) NULL ,
	[Frm941Line3] [nvarchar] (15 ) NULL ,
	[Frm941Line4] [nvarchar] (15 ) NULL ,
	[Frm941Line6a] [nvarchar] (15 ) NULL ,
	[Frm941Line6b] [nvarchar] (15 ) NULL ,
	[Frm941Line7] [nvarchar] (15 ) NULL ,
	[Frm941Line9] [nvarchar] (15 ) NULL ,
	[Frm941Line12] [nvarchar] (15 ) NULL ,
	[Default] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PyrlItemID PyrlItemID [nvarchar](10) NULL  
EMP ID EMP ID [nvarchar](8) NULL  
Description Description [nvarchar](50) NULL  
Basis Basis [nvarchar](50) NULL  
Type Type [nvarchar](50) NULL  
YTDMax YTDMax [money] NULL  
Minimum Minimum [money] NULL  
WageHigh WageHigh [money] NULL  
WageLow WageLow [money] NULL  
ItemAmount ItemAmount [money] NULL  
ItemPercent ItemPercent [real] NULL  
PercentAmount PercentAmount [money] NULL  
TotalAmount TotalAmount [money] NULL  
ApplyItem ApplyItem [bit] NOT NULL  
Account Account [nvarchar](50) NULL  
Account2 Account2 [nvarchar](50) NULL  
Account3 Account3 [nvarchar](50) NULL  
EmployerItemAmount EmployerItemAmount [money] NULL  
EmployerItemPercent EmployerItemPercent [real] NULL  
EmployerPercentAmount EmployerPercentAmount [money] NULL  
EmployerTotalAmount EmployerTotalAmount [money] NULL  
EmployerYN EmployerYN [bit] NOT NULL  
W2Box1 W2Box1 [nvarchar](15) NULL  
W2Box2 W2Box2 [nvarchar](15) NULL  
W2Box3 W2Box3 [nvarchar](15) NULL  
W2Box4 W2Box4 [nvarchar](15) NULL  
W2Box5 W2Box5 [nvarchar](15) NULL  
W2Box6 W2Box6 [nvarchar](15) NULL  
W2Box7 W2Box7 [nvarchar](15) NULL  
W2Box8 W2Box8 [nvarchar](15) NULL  
W2Box9 W2Box9 [nvarchar](15) NULL  
W2Box10 W2Box10 [nvarchar](15) NULL  
W2Box11 W2Box11 [nvarchar](15) NULL  
W2Box12 W2Box12 [nvarchar](15) NULL  
W2Box13 W2Box13 [nvarchar](15) NULL  
W2Box13b W2Box13b [nvarchar](15) NULL  
W2Box14 W2Box14 [nvarchar](15) NULL  
W2Box15 W2Box15 [nvarchar](15) NULL  
W2Box17 W2Box17 [nvarchar](15) NULL  
W2Box18 W2Box18 [nvarchar](15) NULL  
W2Box20 W2Box20 [nvarchar](15) NULL  
W2Box21 W2Box21 [nvarchar](15) NULL  
Frm941Line2 Frm941Line2 [nvarchar](15) NULL  
Frm941Line3 Frm941Line3 [nvarchar](15) NULL  
Frm941Line4 Frm941Line4 [nvarchar](15) NULL  
Frm941Line6a Frm941Line6a [nvarchar](15) NULL  
Frm941Line6b Frm941Line6b [nvarchar](15) NULL  
Frm941Line7 Frm941Line7 [nvarchar](15) NULL  
Frm941Line9 Frm941Line9 [nvarchar](15) NULL  
Frm941Line12 Frm941Line12 [nvarchar](15) NULL  
Default Default [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Setup
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Setup] (
	[PYRL CASH ACCT] [nvarchar] (50 ) NULL ,
	[FIT PAY ACCT] [nvarchar] (50 ) NULL ,
	[SIT PAY ACCT] [nvarchar] (50 ) NULL ,
	[FICA PAY ACCT] [nvarchar] (50 ) NULL ,
	[FICA EXP ACCT] [nvarchar] (50 ) NULL ,
	[SUI PAY ACCT] [nvarchar] (50 ) NULL ,
	[SUI EXP ACCT] [nvarchar] (50 ) NULL ,
	[FUTA PAY ACCT] [nvarchar] (50 ) NULL ,
	[FUTA EXP ACCT] [nvarchar] (50 ) NULL ,
	[LOCAL PAY ACCT] [nvarchar] (50 ) NULL ,
	[SALES EXP ACCT] [nvarchar] (50 ) NULL ,
	[OFFICE EXP ACCT] [nvarchar] (50 ) NULL ,
	[WHSE EXP ACCT] [nvarchar] (50 ) NULL ,
	[PROD EXP ACCT] [nvarchar] (50 ) NULL ,
	[OVERTIME EXP ACCT] [nvarchar] (50 ) NULL ,
	[WAGES PAY ACCT] [nvarchar] (50 ) NULL ,
	[PYRL TAX EXP] [nvarchar] (50 ) NULL ,
	[BONUS1 PAY ACCT] [nvarchar] (50 ) NULL ,
	[FICASS] [real] NULL ,
	[FICAMED] [real] NULL ,
	[FICA EMPL PERCENT] [real] NULL ,
	[SUIRATE] [real] NULL ,
	[FUTARATE] [real] NULL ,
	[CREATE PYRL YN] [bit] NOT NULL ,
	[OTAfter] [int] NULL ,
	[PAYALLCOMMISSIONS] [bit] NOT NULL ,
	[SSWAGEBASE] [real] NULL ,
	[MEDIWAGEBASE] [real] NULL ,
	[FUTAWAGEBASE] [money] NULL ,
	[SUIWAGEBASE] [money] NULL ,
	[FederalIDNo] [nvarchar] (50 ) NULL ,
	[StateIDNo] [nvarchar] (50 ) NULL ,
	[State] [nvarchar] (50 ) NULL ,
	[LocalityName] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PYRL CASH ACCT PYRL CASH ACCT [nvarchar](50) NULL  
FIT PAY ACCT FIT PAY ACCT [nvarchar](50) NULL  
SIT PAY ACCT SIT PAY ACCT [nvarchar](50) NULL  
FICA PAY ACCT FICA PAY ACCT [nvarchar](50) NULL  
FICA EXP ACCT FICA EXP ACCT [nvarchar](50) NULL  
SUI PAY ACCT SUI PAY ACCT [nvarchar](50) NULL  
SUI EXP ACCT SUI EXP ACCT [nvarchar](50) NULL  
FUTA PAY ACCT FUTA PAY ACCT [nvarchar](50) NULL  
FUTA EXP ACCT FUTA EXP ACCT [nvarchar](50) NULL  
LOCAL PAY ACCT LOCAL PAY ACCT [nvarchar](50) NULL  
SALES EXP ACCT SALES EXP ACCT [nvarchar](50) NULL  
OFFICE EXP ACCT OFFICE EXP ACCT [nvarchar](50) NULL  
WHSE EXP ACCT WHSE EXP ACCT [nvarchar](50) NULL  
PROD EXP ACCT PROD EXP ACCT [nvarchar](50) NULL  
OVERTIME EXP ACCT OVERTIME EXP ACCT [nvarchar](50) NULL  
WAGES PAY ACCT WAGES PAY ACCT [nvarchar](50) NULL  
PYRL TAX EXP PYRL TAX EXP [nvarchar](50) NULL  
BONUS1 PAY ACCT BONUS1 PAY ACCT [nvarchar](50) NULL  
FICASS FICASS [real] NULL  
FICAMED FICAMED [real] NULL  
FICA EMPL PERCENT FICA EMPL PERCENT [real] NULL  
SUIRATE SUIRATE [real] NULL  
FUTARATE FUTARATE [real] NULL  
CREATE PYRL YN CREATE PYRL YN [bit] NOT NULL  
OTAfter OTAfter [int] NULL  
PAYALLCOMMISSIONS PAYALLCOMMISSIONS [bit] NOT NULL  
SSWAGEBASE SSWAGEBASE [real] NULL  
MEDIWAGEBASE MEDIWAGEBASE [real] NULL  
FUTAWAGEBASE FUTAWAGEBASE [money] NULL  
SUIWAGEBASE SUIWAGEBASE [money] NULL  
FederalIDNo FederalIDNo [nvarchar](50) NULL  
StateIDNo StateIDNo [nvarchar](50) NULL  
State State [nvarchar](50) NULL  
LocalityName LocalityName [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - W2 Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - W2 Work] (
	[EMP ID] [nvarchar] () NULL ,
	[1] [money] NULL ,
	[2] [money] NULL ,
	[3] [money] NULL ,
	[4] [money] NULL ,
	[5] [money] NULL ,
	[6] [money] NULL ,
	[7] [money] NULL ,
	[8] [money] NULL ,
	[9] [money] NULL ,
	[10] [money] NULL ,
	[11] [money] NULL ,
	[12] [money] NULL ,
	[13] [money] NULL ,
	[13b] [nvarchar] (50 ) NULL ,
	[14] [money] NULL ,
	[15] [nvarchar] (50 ) NULL ,
	[15CK1] [bit] NOT NULL ,
	[15CK2] [bit] NOT NULL ,
	[15CK3] [bit] NOT NULL ,
	[15CK4] [bit] NOT NULL ,
	[15CK5] [bit] NOT NULL ,
	[15CK6] [bit] NOT NULL ,
	[15CK7] [bit] NOT NULL ,
	[17] [money] NULL ,
	[18] [money] NULL ,
	[20] [money] NULL ,
	[21] [money] NULL ,
	[EMP Name] [nvarchar] (50 ) NULL ,
	[SS#] [nvarchar] (50 ) NULL ,
	[EMP Address 1] [nvarchar] (50 ) NULL ,
	[EMP Address 2] [nvarchar] (50 ) NULL ,
	[EMP City] [nvarchar] (50 ) NULL ,
	[EMP State] [nvarchar] (50 ) NULL ,
	[EMP Postal] [nvarchar] (50 ) NULL ,
	[Emp Country] [nvarchar] (50 ) NULL ,
	[Control Number] [nvarchar] (50 ) NULL ,
	[Void] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EMP ID EMP ID [nvarchar](8) NULL  
1 1 [money] NULL  
2 2 [money] NULL  
3 3 [money] NULL  
4 4 [money] NULL  
5 5 [money] NULL  
6 6 [money] NULL  
7 7 [money] NULL  
8 8 [money] NULL  
9 9 [money] NULL  
10 10 [money] NULL  
11 11 [money] NULL  
12 12 [money] NULL  
13 13 [money] NULL  
13b 13b [nvarchar](50) NULL  
14 14 [money] NULL  
15 15 [nvarchar](50) NULL  
15CK1 15CK1 [bit] NOT NULL  
15CK2 15CK2 [bit] NOT NULL  
15CK3 15CK3 [bit] NOT NULL  
15CK4 15CK4 [bit] NOT NULL  
15CK5 15CK5 [bit] NOT NULL  
15CK6 15CK6 [bit] NOT NULL  
15CK7 15CK7 [bit] NOT NULL  
17 17 [money] NULL  
18 18 [money] NULL  
20 20 [money] NULL  
21 21 [money] NULL  
EMP Name EMP Name [nvarchar](50) NULL  
SS# SS# [nvarchar](50) NULL  
EMP Address 1 EMP Address 1 [nvarchar](50) NULL  
EMP Address 2 EMP Address 2 [nvarchar](50) NULL  
EMP City EMP City [nvarchar](50) NULL  
EMP State EMP State [nvarchar](50) NULL  
EMP Postal EMP Postal [nvarchar](50) NULL  
Emp Country Emp Country [nvarchar](50) NULL  
Control Number Control Number [nvarchar](50) NULL  
Void Void [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - W3 Work
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - W3 Work] (
	[1] [money] NULL ,
	[2] [money] NULL ,
	[3] [money] NULL ,
	[4] [money] NULL ,
	[5] [money] NULL ,
	[6] [money] NULL ,
	[7] [money] NULL ,
	[8] [money] NULL ,
	[9] [money] NULL ,
	[10] [money] NULL ,
	[11] [money] NULL ,
	[12] [money] NULL ,
	[15] [money] NULL ,
	[Control Number] [nvarchar] (50 ) NULL ,
	[941] [bit] NOT NULL ,
	[Military] [bit] NOT NULL ,
	[943] [bit] NOT NULL ,
	[CT-1] [bit] NOT NULL ,
	[Hshld] [bit] NOT NULL ,
	[MedicareGovtEmp] [bit] NOT NULL ,
	[EIN] [nvarchar] (50 ) NULL ,
	[Other EIN] [nvarchar] (50 ) NULL ,
	[TotalNoStatements] [int] NULL ,
	[EstablishmentNo] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
1 1 [money] NULL  
2 2 [money] NULL  
3 3 [money] NULL  
4 4 [money] NULL  
5 5 [money] NULL  
6 6 [money] NULL  
7 7 [money] NULL  
8 8 [money] NULL  
9 9 [money] NULL  
10 10 [money] NULL  
11 11 [money] NULL  
12 12 [money] NULL  
15 15 [money] NULL  
Control Number Control Number [nvarchar](50) NULL  
941 941 [bit] NOT NULL  
Military Military [bit] NOT NULL  
943 943 [bit] NOT NULL  
CT-1 CT-1 [bit] NOT NULL  
Hshld Hshld [bit] NOT NULL  
MedicareGovtEmp MedicareGovtEmp [bit] NOT NULL  
EIN EIN [nvarchar](50) NULL  
Other EIN Other EIN [nvarchar](50) NULL  
TotalNoStatements TotalNoStatements [int] NULL  
EstablishmentNo EstablishmentNo [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Pyrl - Withholding
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Pyrl - Withholding] (
	[Period] [nvarchar] (50 ) NULL ,
	[Over] [money] NULL ,
	[NotOver] [money] NULL ,
	[Bracket] [real] NULL ,
	[Cumulative] [money] NULL ,
	[Status] [nvarchar] (50 ) NULL ,
	[OneAllowance] [money] NULL ,
	[Year] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Period Period [nvarchar](50) NULL  
Over Over [money] NULL  
NotOver NotOver [money] NULL  
Bracket Bracket [real] NULL  
Cumulative Cumulative [money] NULL  
Status Status [nvarchar](50) NULL  
OneAllowance OneAllowance [money] NULL  
Year Year [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


qryBankTransactions
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[qryBankTransactions] (
	[Doc #] [nvarchar] (20 ) NULL ,
	[Date] [datetime] NULL ,
	[Description] [nvarchar] () NULL ,
	[Type] [varchar] () NOT NULL ,
	[Amount] [money] NULL ,
	[BANK ID] [nvarchar] (50 ) NULL ,
	[Cleared] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Doc # Doc # [nvarchar](20) NULL  
Date Date [datetime] NULL  
Description Description [nvarchar](8) NULL  
Type Type [varchar](7) NOT NULL  
Amount Amount [money] NULL  
BANK ID BANK ID [nvarchar](50) NULL  
Cleared Cleared [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Receipt Numbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Receipt Numbers] (
	[Check No] [nvarchar] (50 ) NOT NULL ,
	[Bank] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Check No Check No [nvarchar](50) NOT NULL  
Bank Bank [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


RECUR_TYPE
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[RECUR_TYPE] (
	[RECURR TYPE] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
RECURR TYPE RECURR TYPE [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Results
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Results] (
	[Form Name] [nvarchar] (50 ) NULL ,
	[Help Text] [ntext] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Form Name Form Name [nvarchar](50) NULL  
Help Text Help Text [ntext] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


rptManualCheck
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[rptManualCheck] (
	[CHECKNUMBER] [int] NULL ,
	[NAME] [nvarchar] (50 ) NULL ,
	[NETPAY] [money] NULL ,
	[GROSS] [money] NULL ,
	[PRETAXDED] [money] NULL ,
	[FICA] [money] NULL ,
	[CHECKDATE] [datetime] NULL ,
	[FIT] [money] NULL ,
	[STATETAX] [money] NULL ,
	[LOCAL] [money] NULL ,
	[ADDITIONS] [money] NULL ,
	[DEDUCTIONS] [money] NULL ,
	[AGI] [money] NULL ,
	[STARTDATE] [datetime] NULL ,
	[DATE] [datetime] NULL ,
	[YTDGROSS] [money] NULL ,
	[YTDFIT] [money] NULL ,
	[YTDFICA] [money] NULL ,
	[YTDLOCAL] [money] NULL ,
	[YTDSTATETAX] [money] NULL ,
	[SS#] [nvarchar] (15 ) NULL ,
	[BankName] [varchar] (14 ) NOT NULL ,
	[BankAddress] [varchar] () NOT NULL ,
	[CompName] [varchar] (13 ) NOT NULL ,
	[CompAddress] [varchar] (54 ) NOT NULL ,
	[EMPAddress] [varchar] (41 ) NOT NULL ,
	[TextPay] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CHECKNUMBER CHECKNUMBER [int] NULL  
NAME NAME [nvarchar](50) NULL  
NETPAY NETPAY [money] NULL  
GROSS GROSS [money] NULL  
PRETAXDED PRETAXDED [money] NULL  
FICA FICA [money] NULL  
CHECKDATE CHECKDATE [datetime] NULL  
FIT FIT [money] NULL  
STATETAX STATETAX [money] NULL  
LOCAL LOCAL [money] NULL  
ADDITIONS ADDITIONS [money] NULL  
DEDUCTIONS DEDUCTIONS [money] NULL  
AGI AGI [money] NULL  
STARTDATE STARTDATE [datetime] NULL  
DATE DATE [datetime] NULL  
YTDGROSS YTDGROSS [money] NULL  
YTDFIT YTDFIT [money] NULL  
YTDFICA YTDFICA [money] NULL  
YTDLOCAL YTDLOCAL [money] NULL  
YTDSTATETAX YTDSTATETAX [money] NULL  
SS# SS# [nvarchar](15) NULL  
BankName BankName [varchar](14) NOT NULL  
BankAddress BankAddress [varchar](4) NOT NULL  
CompName CompName [varchar](13) NOT NULL  
CompAddress CompAddress [varchar](54) NOT NULL  
EMPAddress EMPAddress [varchar](41) NOT NULL  
TextPay TextPay [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Company
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Company] (
	[SYS COM ID] [nvarchar] () NOT NULL ,
	[SYS COM Company Name] [nvarchar] (50 ) NULL ,
	[SYS COM Address 1] [nvarchar] (30 ) NULL ,
	[SYS COM Address 2] [nvarchar] (30 ) NULL ,
	[SYS COM City] [nvarchar] (20 ) NULL ,
	[SYS COM State] [nvarchar] () NULL ,
	[SYS COM Postal] [nvarchar] (20 ) NULL ,
	[SYS COM Country] [nvarchar] (20 ) NULL ,
	[SYS COM Phone] [nvarchar] (20 ) NULL ,
	[SYS COM Fax] [nvarchar] (20 ) NULL ,
	[SYS COM Notes] [nvarchar] (1000 ) NULL ,
	[SYS COM GL Number] [int] NULL ,
	[SYS COM Fiscal Start Date] [datetime] NULL ,
	[SYS COM Fiscal End Date] [datetime] NULL ,
	[SYS COM Fiscal Year] [float] NULL ,
	[SYS COM Fiscal Dist Type] [nvarchar] (50 ) NULL ,
	[SYS COM P1 Date] [datetime] NULL ,
	[SYS COM P2 Date] [datetime] NULL ,
	[SYS COM P3 Date] [datetime] NULL ,
	[SYS COM P4 Date] [datetime] NULL ,
	[SYS COM P5 Date] [datetime] NULL ,
	[SYS COM P6 Date] [datetime] NULL ,
	[SYS COM P7 Date] [datetime] NULL ,
	[SYS COM P8 Date] [datetime] NULL ,
	[SYS COM P9 Date] [datetime] NULL ,
	[SYS COM P10 Date] [datetime] NULL ,
	[SYS COM P11 Date] [datetime] NULL ,
	[SYS COM P12 Date] [datetime] NULL ,
	[SYS COM P13 Date] [datetime] NULL ,
	[SYS COM P1 Closed] [smallint] NULL ,
	[SYS COM P2 Closed] [smallint] NULL ,
	[SYS COM P3 Closed] [smallint] NULL ,
	[SYS COM P4 Closed] [smallint] NULL ,
	[SYS COM P5 Closed] [smallint] NULL ,
	[SYS COM P6 Closed] [smallint] NULL ,
	[SYS COM P7 Closed] [smallint] NULL ,
	[SYS COM P8 Closed] [smallint] NULL ,
	[SYS COM P9 Closed] [smallint] NULL ,
	[SYS COM P10 Closed] [smallint] NULL ,
	[SYS COM P11 Closed] [smallint] NULL ,
	[SYS COM P12 Closed] [smallint] NULL ,
	[SYS COM P13 Closed] [smallint] NULL ,
	[SYS COM Department YN] [smallint] NULL ,
	[SYS COM Use Passwords YN] [smallint] NULL ,
	[SYS COM Items per Transaction] [smallint] NULL ,
	[SYS COM Font Name] [nvarchar] (50 ) NULL ,
	[SYS COM Finance Charges YN] [bit] NOT NULL ,
	[SYS COM Annual Charge] [float] NULL ,
	[SYS COM Monthly Charge] [float] NULL ,
	[SYS COM Minimum Balance] [float] NULL ,
	[SYS COM Minimum Finance Charge] [float] NULL ,
	[SYS COM Interest YN] [bit] NOT NULL ,
	[SYS COM Finance Charge Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Use Departments YN] [bit] NOT NULL ,
	[SYS COM Show Tips YN] [bit] NOT NULL ,
	[SYS COM Purchase Period 1] [smallint] NULL ,
	[SYS COM Purchase Period 2] [smallint] NULL ,
	[SYS COM Purchase Period 3] [smallint] NULL ,
	[SYS COM Purchase Age Invoices By] [smallint] NULL ,
	[SYS COM Purchase Number] [int] NULL ,
	[SYS COM Voucher Number] [int] NULL ,
	[SYS COM Purchase AP Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Discount Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Inventory Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Misc Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Freight Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase PrePaid Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Payment Terms] [nvarchar] (20 ) NULL ,
	[SYS COM Purchase Payment Methods] [nvarchar] (20 ) NULL ,
	[SYS COM Purchase Shipping Method] [nvarchar] (20 ) NULL ,
	[SYS COM Purchase Write Off Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Purchase Cash Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Pay Many Selection] [bit] NOT NULL ,
	[SYS COM Sales Period 1] [smallint] NULL ,
	[SYS COM Sales Period 2] [smallint] NULL ,
	[SYS COM Sales Period 3] [smallint] NULL ,
	[SYS COM Sales Age Invoices By] [smallint] NULL ,
	[SYS COM Sales Acct Default] [smallint] NULL ,
	[SYS COM Sales Number] [int] NULL ,
	[SYS COM Sales Sales Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Inventory Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales COGS Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Discount Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales AR Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Misc Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Freight Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Return Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Write Off Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Sales Cash Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Inventory Cost Method Last YN] [bit] NOT NULL ,
	[SYS COM Inventory Adjustment Number] [int] NULL ,
	[SYS COM Inventory Production Number] [int] NULL ,
	[SYS COM Inventory Cost Digits] [smallint] NULL ,
	[SYS COM Inventory Qty Digits] [smallint] NULL ,
	[SYS COM Sales Payment Terms] [nvarchar] (20 ) NULL ,
	[SYS COM Sales Shipping Method] [nvarchar] (20 ) NULL ,
	[SYS COM Sales Sales Tax] [nvarchar] (20 ) NULL ,
	[SYS COM Bank Other Charges Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Bank Interest Earned Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Bank Service Charges Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Bank Misc Withdrawl Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Bank Misc Deposit Acct] [nvarchar] (50 ) NULL ,
	[SYS COM Ledger Color] [int] NULL ,
	[SYS COM Post to GL] [bit] NOT NULL ,
	[SYS COM GL Post By Date] [smallint] NULL ,
	[SYS COM Invoice Form] [smallint] NULL ,
	[SYS COM PO Form] [smallint] NULL ,
	[SYS COM Retained Earnings Acct] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
SYS COM ID SYS COM ID [nvarchar](8) NOT NULL  
SYS COM Company Name SYS COM Company Name [nvarchar](50) NULL  
SYS COM Address 1 SYS COM Address 1 [nvarchar](30) NULL  
SYS COM Address 2 SYS COM Address 2 [nvarchar](30) NULL  
SYS COM City SYS COM City [nvarchar](20) NULL  
SYS COM State SYS COM State [nvarchar](5) NULL  
SYS COM Postal SYS COM Postal [nvarchar](20) NULL  
SYS COM Country SYS COM Country [nvarchar](20) NULL  
SYS COM Phone SYS COM Phone [nvarchar](20) NULL  
SYS COM Fax SYS COM Fax [nvarchar](20) NULL  
SYS COM Notes SYS COM Notes [nvarchar](1000) NULL  
SYS COM GL Number SYS COM GL Number [int] NULL  
SYS COM Fiscal Start Date SYS COM Fiscal Start Date [datetime] NULL  
SYS COM Fiscal End Date SYS COM Fiscal End Date [datetime] NULL  
SYS COM Fiscal Year SYS COM Fiscal Year [float] NULL  
SYS COM Fiscal Dist Type SYS COM Fiscal Dist Type [nvarchar](50) NULL  
SYS COM P1 Date SYS COM P1 Date [datetime] NULL  
SYS COM P2 Date SYS COM P2 Date [datetime] NULL  
SYS COM P3 Date SYS COM P3 Date [datetime] NULL  
SYS COM P4 Date SYS COM P4 Date [datetime] NULL  
SYS COM P5 Date SYS COM P5 Date [datetime] NULL  
SYS COM P6 Date SYS COM P6 Date [datetime] NULL  
SYS COM P7 Date SYS COM P7 Date [datetime] NULL  
SYS COM P8 Date SYS COM P8 Date [datetime] NULL  
SYS COM P9 Date SYS COM P9 Date [datetime] NULL  
SYS COM P10 Date SYS COM P10 Date [datetime] NULL  
SYS COM P11 Date SYS COM P11 Date [datetime] NULL  
SYS COM P12 Date SYS COM P12 Date [datetime] NULL  
SYS COM P13 Date SYS COM P13 Date [datetime] NULL  
SYS COM P1 Closed SYS COM P1 Closed [smallint] NULL  
SYS COM P2 Closed SYS COM P2 Closed [smallint] NULL  
SYS COM P3 Closed SYS COM P3 Closed [smallint] NULL  
SYS COM P4 Closed SYS COM P4 Closed [smallint] NULL  
SYS COM P5 Closed SYS COM P5 Closed [smallint] NULL  
SYS COM P6 Closed SYS COM P6 Closed [smallint] NULL  
SYS COM P7 Closed SYS COM P7 Closed [smallint] NULL  
SYS COM P8 Closed SYS COM P8 Closed [smallint] NULL  
SYS COM P9 Closed SYS COM P9 Closed [smallint] NULL  
SYS COM P10 Closed SYS COM P10 Closed [smallint] NULL  
SYS COM P11 Closed SYS COM P11 Closed [smallint] NULL  
SYS COM P12 Closed SYS COM P12 Closed [smallint] NULL  
SYS COM P13 Closed SYS COM P13 Closed [smallint] NULL  
SYS COM Department YN SYS COM Department YN [smallint] NULL  
SYS COM Use Passwords YN SYS COM Use Passwords YN [smallint] NULL  
SYS COM Items per Transaction SYS COM Items per Transaction [smallint] NULL  
SYS COM Font Name SYS COM Font Name [nvarchar](50) NULL  
SYS COM Finance Charges YN SYS COM Finance Charges YN [bit] NOT NULL  
SYS COM Annual Charge SYS COM Annual Charge [float] NULL  
SYS COM Monthly Charge SYS COM Monthly Charge [float] NULL  
SYS COM Minimum Balance SYS COM Minimum Balance [float] NULL  
SYS COM Minimum Finance Charge SYS COM Minimum Finance Charge [float] NULL  
SYS COM Interest YN SYS COM Interest YN [bit] NOT NULL  
SYS COM Finance Charge Acct SYS COM Finance Charge Acct [nvarchar](50) NULL  
SYS COM Use Departments YN SYS COM Use Departments YN [bit] NOT NULL  
SYS COM Show Tips YN SYS COM Show Tips YN [bit] NOT NULL  
SYS COM Purchase Period 1 SYS COM Purchase Period 1 [smallint] NULL  
SYS COM Purchase Period 2 SYS COM Purchase Period 2 [smallint] NULL  
SYS COM Purchase Period 3 SYS COM Purchase Period 3 [smallint] NULL  
SYS COM Purchase Age Invoices By SYS COM Purchase Age Invoices By [smallint] NULL  
SYS COM Purchase Number SYS COM Purchase Number [int] NULL  
SYS COM Voucher Number SYS COM Voucher Number [int] NULL  
SYS COM Purchase AP Acct SYS COM Purchase AP Acct [nvarchar](50) NULL  
SYS COM Purchase Discount Acct SYS COM Purchase Discount Acct [nvarchar](50) NULL  
SYS COM Purchase Inventory Acct SYS COM Purchase Inventory Acct [nvarchar](50) NULL  
SYS COM Purchase Misc Acct SYS COM Purchase Misc Acct [nvarchar](50) NULL  
SYS COM Purchase Freight Acct SYS COM Purchase Freight Acct [nvarchar](50) NULL  
SYS COM Purchase PrePaid Acct SYS COM Purchase PrePaid Acct [nvarchar](50) NULL  
SYS COM Purchase Payment Terms SYS COM Purchase Payment Terms [nvarchar](20) NULL  
SYS COM Purchase Payment Methods SYS COM Purchase Payment Methods [nvarchar](20) NULL  
SYS COM Purchase Shipping Method SYS COM Purchase Shipping Method [nvarchar](20) NULL  
SYS COM Purchase Write Off Acct SYS COM Purchase Write Off Acct [nvarchar](50) NULL  
SYS COM Purchase Cash Acct SYS COM Purchase Cash Acct [nvarchar](50) NULL  
SYS COM Pay Many Selection SYS COM Pay Many Selection [bit] NOT NULL  
SYS COM Sales Period 1 SYS COM Sales Period 1 [smallint] NULL  
SYS COM Sales Period 2 SYS COM Sales Period 2 [smallint] NULL  
SYS COM Sales Period 3 SYS COM Sales Period 3 [smallint] NULL  
SYS COM Sales Age Invoices By SYS COM Sales Age Invoices By [smallint] NULL  
SYS COM Sales Acct Default SYS COM Sales Acct Default [smallint] NULL  
SYS COM Sales Number SYS COM Sales Number [int] NULL  
SYS COM Sales Sales Acct SYS COM Sales Sales Acct [nvarchar](50) NULL  
SYS COM Sales Inventory Acct SYS COM Sales Inventory Acct [nvarchar](50) NULL  
SYS COM Sales COGS Acct SYS COM Sales COGS Acct [nvarchar](50) NULL  
SYS COM Sales Discount Acct SYS COM Sales Discount Acct [nvarchar](50) NULL  
SYS COM Sales AR Acct SYS COM Sales AR Acct [nvarchar](50) NULL  
SYS COM Sales Misc Acct SYS COM Sales Misc Acct [nvarchar](50) NULL  
SYS COM Sales Freight Acct SYS COM Sales Freight Acct [nvarchar](50) NULL  
SYS COM Sales Return Acct SYS COM Sales Return Acct [nvarchar](50) NULL  
SYS COM Sales Write Off Acct SYS COM Sales Write Off Acct [nvarchar](50) NULL  
SYS COM Sales Cash Acct SYS COM Sales Cash Acct [nvarchar](50) NULL  
SYS COM Inventory Cost Method Last YN SYS COM Inventory Cost Method Last YN [bit] NOT NULL  
SYS COM Inventory Adjustment Number SYS COM Inventory Adjustment Number [int] NULL  
SYS COM Inventory Production Number SYS COM Inventory Production Number [int] NULL  
SYS COM Inventory Cost Digits SYS COM Inventory Cost Digits [smallint] NULL  
SYS COM Inventory Qty Digits SYS COM Inventory Qty Digits [smallint] NULL  
SYS COM Sales Payment Terms SYS COM Sales Payment Terms [nvarchar](20) NULL  
SYS COM Sales Shipping Method SYS COM Sales Shipping Method [nvarchar](20) NULL  
SYS COM Sales Sales Tax SYS COM Sales Sales Tax [nvarchar](20) NULL  
SYS COM Bank Other Charges Acct SYS COM Bank Other Charges Acct [nvarchar](50) NULL  
SYS COM Bank Interest Earned Acct SYS COM Bank Interest Earned Acct [nvarchar](50) NULL  
SYS COM Bank Service Charges Acct SYS COM Bank Service Charges Acct [nvarchar](50) NULL  
SYS COM Bank Misc Withdrawl Acct SYS COM Bank Misc Withdrawl Acct [nvarchar](50) NULL  
SYS COM Bank Misc Deposit Acct SYS COM Bank Misc Deposit Acct [nvarchar](50) NULL  
SYS COM Ledger Color SYS COM Ledger Color [int] NULL  
SYS COM Post to GL SYS COM Post to GL [bit] NOT NULL  
SYS COM GL Post By Date SYS COM GL Post By Date [smallint] NULL  
SYS COM Invoice Form SYS COM Invoice Form [smallint] NULL  
SYS COM PO Form SYS COM PO Form [smallint] NULL  
SYS COM Retained Earnings Acct SYS COM Retained Earnings Acct [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Purchase Batch
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Purchase Batch] (
	[Post YN] [bit] NOT NULL ,
	[Document ID] [nvarchar] (50 ) NULL ,
	[Vendor ID] [nvarchar] (50 ) NULL ,
	[Document Type] [nvarchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL ,
	[Status] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Post YN Post YN [bit] NOT NULL  
Document ID Document ID [nvarchar](50) NULL  
Vendor ID Vendor ID [nvarchar](50) NULL  
Document Type Document Type [nvarchar](50) NULL  
Date Date [datetime] NULL  
Amount Amount [money] NULL  
Status Status [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Recurred
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Recurred] (
	[Document Type] [nvarchar] (50 ) NULL ,
	[Document Number] [nvarchar] (50 ) NULL ,
	[Reference] [nvarchar] (50 ) NULL ,
	[Amount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Document Type Document Type [nvarchar](50) NULL  
Document Number Document Number [nvarchar](50) NULL  
Reference Reference [nvarchar](50) NULL  
Amount Amount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Report Filters
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Report Filters] (
	[Filter Name] [nvarchar] (50 ) NOT NULL ,
	[Report Name] [nvarchar] (50 ) NOT NULL ,
	[Where Clause] [nvarchar] (255 ) NULL ,
	[Company Name] [nvarchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Filter Name Filter Name [nvarchar](50) NOT NULL  
Report Name Report Name [nvarchar](50) NOT NULL  
Where Clause Where Clause [nvarchar](255) NULL  
Company Name Company Name [nvarchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Reports
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Reports] (
	[SYS Report Category] [nvarchar] (50 ) NULL ,
	[SYS Report Name] [nvarchar] (50 ) NULL ,
	[SYS Report Title] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
SYS Report Category SYS Report Category [nvarchar](50) NULL  
SYS Report Name SYS Report Name [nvarchar](50) NULL  
SYS Report Title SYS Report Title [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Sales Batch
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Sales Batch] (
	[Post YN] [bit] NOT NULL ,
	[Document ID] [nvarchar] (50 ) NULL ,
	[Customer ID] [nvarchar] (50 ) NULL ,
	[Document Type] [nvarchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL ,
	[Status] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Post YN Post YN [bit] NOT NULL  
Document ID Document ID [nvarchar](50) NULL  
Customer ID Customer ID [nvarchar](50) NULL  
Document Type Document Type [nvarchar](50) NULL  
Date Date [datetime] NULL  
Amount Amount [money] NULL  
Status Status [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Setup
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Setup] (
	[Company] [bit] NOT NULL ,
	[Chart Of Accounts] [bit] NOT NULL ,
	[Tax Authorities] [bit] NOT NULL ,
	[Tax Groups] [bit] NOT NULL ,
	[Accounting Preferences] [bit] NOT NULL ,
	[Purchasing Preferences] [bit] NOT NULL ,
	[Sales Preferences] [bit] NOT NULL ,
	[Item Categories] [bit] NOT NULL ,
	[Shipping Methods] [bit] NOT NULL ,
	[Payment Terms] [bit] NOT NULL ,
	[Credit Cards Used] [bit] NOT NULL ,
	[Employees] [bit] NOT NULL ,
	[Customers] [bit] NOT NULL ,
	[Vendors] [bit] NOT NULL ,
	[Items] [bit] NOT NULL ,
	[Projects] [bit] NOT NULL ,
	[Payroll] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Company Company [bit] NOT NULL  
Chart Of Accounts Chart Of Accounts [bit] NOT NULL  
Tax Authorities Tax Authorities [bit] NOT NULL  
Tax Groups Tax Groups [bit] NOT NULL  
Accounting Preferences Accounting Preferences [bit] NOT NULL  
Purchasing Preferences Purchasing Preferences [bit] NOT NULL  
Sales Preferences Sales Preferences [bit] NOT NULL  
Item Categories Item Categories [bit] NOT NULL  
Shipping Methods Shipping Methods [bit] NOT NULL  
Payment Terms Payment Terms [bit] NOT NULL  
Credit Cards Used Credit Cards Used [bit] NOT NULL  
Employees Employees [bit] NOT NULL  
Customers Customers [bit] NOT NULL  
Vendors Vendors [bit] NOT NULL  
Items Items [bit] NOT NULL  
Projects Projects [bit] NOT NULL  
Payroll Payroll [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Tax
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Tax] (
	[SYS TAX ID] [nvarchar] () NOT NULL ,
	[SYS TAX Description] [nvarchar] (20 ) NULL ,
	[SYS TAX Percent] [float] NULL ,
	[SYS TAX Account] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
SYS TAX ID SYS TAX ID [nvarchar](8) NOT NULL  
SYS TAX Description SYS TAX Description [nvarchar](20) NULL  
SYS TAX Percent SYS TAX Percent [float] NULL  
SYS TAX Account SYS TAX Account [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Tax Group
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Tax Group] (
	[SYS TAXGRP ID] [nvarchar] () NOT NULL ,
	[SYS TAXGRP Name] [nvarchar] (20 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
SYS TAXGRP ID SYS TAXGRP ID [nvarchar](8) NOT NULL  
SYS TAXGRP Name SYS TAXGRP Name [nvarchar](20) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


SYS Tax Group Detail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[SYS Tax Group Detail] (
	[SYS TAXGRPD Group ID] [nvarchar] () NULL ,
	[SYS TAXGRPD Tax ID] [nvarchar] () NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
SYS TAXGRPD Group ID SYS TAXGRPD Group ID [nvarchar](8) NULL  
SYS TAXGRPD Tax ID SYS TAXGRPD Tax ID [nvarchar](8) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


tblUpgrade
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[tblUpgrade] (
	[Table] [nvarchar] (50 ) NULL ,
	[Field] [nvarchar] (50 ) NULL ,
	[DataType] [nvarchar] (50 ) NULL ,
	[RelationName] [nvarchar] (50 ) NULL ,
	[TableOne] [nvarchar] (50 ) NULL ,
	[TableOneField] [nvarchar] (50 ) NULL ,
	[TableManyForeign] [nvarchar] (50 ) NULL ,
	[TableManyField] [nvarchar] (50 ) NULL ,
	[OneToOne] [bit] NOT NULL ,
	[DeleteCascade] [bit] NOT NULL ,
	[UpdateCascade] [bit] NOT NULL ,
	[Done] [bit] NOT NULL ,
	[LastUpgrade] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Table Table [nvarchar](50) NULL  
Field Field [nvarchar](50) NULL  
DataType DataType [nvarchar](50) NULL  
RelationName RelationName [nvarchar](50) NULL  
TableOne TableOne [nvarchar](50) NULL  
TableOneField TableOneField [nvarchar](50) NULL  
TableManyForeign TableManyForeign [nvarchar](50) NULL  
TableManyField TableManyField [nvarchar](50) NULL  
OneToOne OneToOne [bit] NOT NULL  
DeleteCascade DeleteCascade [bit] NOT NULL  
UpdateCascade UpdateCascade [bit] NOT NULL  
Done Done [bit] NOT NULL  
LastUpgrade LastUpgrade [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Work - Balance Sheet
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Work - Balance Sheet] (
	[Visible] [bit] NOT NULL ,
	[CY Balance] [money] NULL ,
	[PY Balance] [money] NULL ,
	[BUD Balance] [money] NULL ,
	[CY Ratio] [float] NULL ,
	[PY Ratio] [float] NULL ,
	[BUD Ratio] [float] NULL ,
	[Total CY Assets] [money] NULL ,
	[Total PY Assets] [money] NULL ,
	[Total BUD Assets] [money] NULL ,
	[Total CY Liabilities] [money] NULL ,
	[Total PY Liabilities] [money] NULL ,
	[Total BUD Liabilities] [money] NULL ,
	[Total CY Equity] [money] NULL ,
	[Total PY Equity] [money] NULL ,
	[Total BUD Equity] [money] NULL ,
	[GL COA Account No] [nvarchar] (50 ) NOT NULL ,
	[GL COA Account Name] [nvarchar] (30 ) NULL ,
	[GL COA Asset Type] [nvarchar] (30 ) NULL ,
	[GL COA Balance Type] [nvarchar] (10 ) NULL ,
	[GL COA Reporting Level] [smallint] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Visible Visible [bit] NOT NULL  
CY Balance CY Balance [money] NULL  
PY Balance PY Balance [money] NULL  
BUD Balance BUD Balance [money] NULL  
CY Ratio CY Ratio [float] NULL  
PY Ratio PY Ratio [float] NULL  
BUD Ratio BUD Ratio [float] NULL  
Total CY Assets Total CY Assets [money] NULL  
Total PY Assets Total PY Assets [money] NULL  
Total BUD Assets Total BUD Assets [money] NULL  
Total CY Liabilities Total CY Liabilities [money] NULL  
Total PY Liabilities Total PY Liabilities [money] NULL  
Total BUD Liabilities Total BUD Liabilities [money] NULL  
Total CY Equity Total CY Equity [money] NULL  
Total PY Equity Total PY Equity [money] NULL  
Total BUD Equity Total BUD Equity [money] NULL  
GL COA Account No GL COA Account No [nvarchar](50) NOT NULL  
GL COA Account Name GL COA Account Name [nvarchar](30) NULL  
GL COA Asset Type GL COA Asset Type [nvarchar](30) NULL  
GL COA Balance Type GL COA Balance Type [nvarchar](10) NULL  
GL COA Reporting Level GL COA Reporting Level [smallint] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Work - Income Statement
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Work - Income Statement] (
	[Visible] [bit] NOT NULL ,
	[CY Period Balance] [money] NULL ,
	[PY Period Balance] [money] NULL ,
	[BUD Period Balance] [money] NULL ,
	[CY Period Ratio] [float] NULL ,
	[PY Period Ratio] [float] NULL ,
	[BUD Period Ratio] [float] NULL ,
	[Total CY Period Income] [money] NULL ,
	[Total PY Period Income] [money] NULL ,
	[Total BUD Period Income] [money] NULL ,
	[Total CY Period COGS] [money] NULL ,
	[Total PY Period COGS] [money] NULL ,
	[Total BUD Period COGS] [money] NULL ,
	[Total CY Period Expenses] [money] NULL ,
	[Total PY Period Expenses] [money] NULL ,
	[Total BUD Period Expenses] [money] NULL ,
	[Net Income CY Period] [money] NULL ,
	[Net Income PY Period] [money] NULL ,
	[Net Income BUD Period] [money] NULL ,
	[CY YTD Balance] [money] NULL ,
	[PY YTD Balance] [money] NULL ,
	[BUD YTD Balance] [money] NULL ,
	[CY YTD Ratio] [float] NULL ,
	[PY YTD Ratio] [float] NULL ,
	[BUD YTD Ratio] [float] NULL ,
	[Total CY YTD Income] [money] NULL ,
	[Total PY YTD Income] [money] NULL ,
	[Total BUD YTD Income] [money] NULL ,
	[Total CY YTD COGS] [money] NULL ,
	[Total PY YTD COGS] [money] NULL ,
	[Total BUD YTD COGS] [money] NULL ,
	[Total CY YTD Expenses] [money] NULL ,
	[Total PY YTD Expenses] [money] NULL ,
	[Total BUD YTD Expenses] [money] NULL ,
	[Net Income CY YTD] [money] NULL ,
	[Net Income PY YTD] [money] NULL ,
	[Net Income BUD YTD] [money] NULL ,
	[GL COA Account No] [nvarchar] (50 ) NOT NULL ,
	[GL COA Account Name] [nvarchar] (30 ) NULL ,
	[GL COA Asset Type] [nvarchar] (30 ) NULL ,
	[GL COA Balance Type] [nvarchar] (10 ) NULL ,
	[GL COA Reporting Level] [smallint] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Visible Visible [bit] NOT NULL  
CY Period Balance CY Period Balance [money] NULL  
PY Period Balance PY Period Balance [money] NULL  
BUD Period Balance BUD Period Balance [money] NULL  
CY Period Ratio CY Period Ratio [float] NULL  
PY Period Ratio PY Period Ratio [float] NULL  
BUD Period Ratio BUD Period Ratio [float] NULL  
Total CY Period Income Total CY Period Income [money] NULL  
Total PY Period Income Total PY Period Income [money] NULL  
Total BUD Period Income Total BUD Period Income [money] NULL  
Total CY Period COGS Total CY Period COGS [money] NULL  
Total PY Period COGS Total PY Period COGS [money] NULL  
Total BUD Period COGS Total BUD Period COGS [money] NULL  
Total CY Period Expenses Total CY Period Expenses [money] NULL  
Total PY Period Expenses Total PY Period Expenses [money] NULL  
Total BUD Period Expenses Total BUD Period Expenses [money] NULL  
Net Income CY Period Net Income CY Period [money] NULL  
Net Income PY Period Net Income PY Period [money] NULL  
Net Income BUD Period Net Income BUD Period [money] NULL  
CY YTD Balance CY YTD Balance [money] NULL  
PY YTD Balance PY YTD Balance [money] NULL  
BUD YTD Balance BUD YTD Balance [money] NULL  
CY YTD Ratio CY YTD Ratio [float] NULL  
PY YTD Ratio PY YTD Ratio [float] NULL  
BUD YTD Ratio BUD YTD Ratio [float] NULL  
Total CY YTD Income Total CY YTD Income [money] NULL  
Total PY YTD Income Total PY YTD Income [money] NULL  
Total BUD YTD Income Total BUD YTD Income [money] NULL  
Total CY YTD COGS Total CY YTD COGS [money] NULL  
Total PY YTD COGS Total PY YTD COGS [money] NULL  
Total BUD YTD COGS Total BUD YTD COGS [money] NULL  
Total CY YTD Expenses Total CY YTD Expenses [money] NULL  
Total PY YTD Expenses Total PY YTD Expenses [money] NULL  
Total BUD YTD Expenses Total BUD YTD Expenses [money] NULL  
Net Income CY YTD Net Income CY YTD [money] NULL  
Net Income PY YTD Net Income PY YTD [money] NULL  
Net Income BUD YTD Net Income BUD YTD [money] NULL  
GL COA Account No GL COA Account No [nvarchar](50) NOT NULL  
GL COA Account Name GL COA Account Name [nvarchar](30) NULL  
GL COA Asset Type GL COA Asset Type [nvarchar](30) NULL  
GL COA Balance Type GL COA Balance Type [nvarchar](10) NULL  
GL COA Reporting Level GL COA Reporting Level [smallint] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE