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] (8 ) 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 , 1 ) NOT NULL , [PA Bank] [nvarchar] (8 ) 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] (8 ) 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] (8 ) 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] (8 ) 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 , 1 ) NOT NULL , [AP PAY Type] [nvarchar] (20 ) NULL , [AP PAY Check No] [nvarchar] (20 ) NULL , [AP PAY Vendor No] [nvarchar] (8 ) 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 , 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 , 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] (8 ) 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] (5 ) 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] (5 ) 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] (5 ) 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 , 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] (5 ) NULL , [AP POD Project ID] [nvarchar] (8 ) 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] (1 ) 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] (8 ) 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] (5 ) 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] (5 ) 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] (5 ) 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] (8 ) 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] (5 ) 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] (8 ) 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 , 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] (8 ) 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] (5 ) 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] (8 ) 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] (5 ) 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] (8 ) NULL , [AR ORDER Check Date] [datetime] NULL , [AR ORDER Quote Document #] [int] NULL , [AR ORDER Notes] [nvarchar] (500 ) NULL , [AR ORDER Department] [nvarchar] (5 ) 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 , 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] (1 ) 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] (5 ) NULL , [AR ORDERD Project] [nvarchar] (8 ) 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 , 1 ) NOT NULL , [AR PAY Type] [nvarchar] (20 ) NULL , [AR PAY Check No] [nvarchar] (50 ) NULL , [AR PAY Customer No] [nvarchar] (8 ) 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 , 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 , 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] (8 ) 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] (5 ) 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] (8 ) 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] (5 ) 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] (5 ) 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 , 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] (1 ) 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] (5 ) NULL , [AR SALED Project] [nvarchar] (8 ) 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] (8 ) 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] (5 ) 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] (8 ) 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] (5 ) 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] (5 ) 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] (8 ) 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] (5 ) 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] (5 ) 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 , 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 , 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 , 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] (8 ) 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] (8 ) 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] (6 ) 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 , 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] (5 ) NULL , [GL TRANSD Debit Amount] [float] NULL , [GL TRANSD Credit Amount] [float] NULL , [GL TRANSD Project] [nvarchar] (8 ) NULL , [GL TRANSD ID] [int] IDENTITY (1 , 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] (5 ) NULL , [GW TRANSD Debit Amount] [float] NULL , [GW TRANSD Credit Amount] [float] NULL , [GW TRANSD Project] [nvarchar] (8 ) NULL , [GW TRANSD ID] [int] IDENTITY (1 , 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 , 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 , 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] (5 ) NULL , [INV ADJD Project] [nvarchar] (8 ) 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 , 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] (8 ) 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 , 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 , 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 , 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] (8 ) 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 , 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 , 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 , 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] (8 ) 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] (8 ) NOT NULL , [PROJ Name] [nvarchar] (30 ) NULL , [PROJ Description] [nvarchar] (255 ) NULL , [PROJ Customer ID] [nvarchar] (8 ) 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] (8 ) 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] (8 ) 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] (5 ) NULL , [GL TRANSD Debit Amount] [float] NULL , [GL TRANSD Credit Amount] [float] NULL , [GL TRANSD Project] [nvarchar] (8 ) NULL , [GL TRANSD ID] [int] IDENTITY (1 , 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] (8 ) 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 , 1 ) NOT NULL , [EMP ID] [nvarchar] (8 ) 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] (8 ) 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] (8 ) 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] (8 ) 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] (8 ) NULL , [Type] [varchar] (7 ) 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] (4 ) 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] (8 ) 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] (5 ) 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] (8 ) 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] (8 ) 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] (8 ) NULL , [SYS TAXGRPD Tax ID] [nvarchar] (8 ) 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 |