bCheckDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[bCheckDetails] (
	[CheckID] [int] NOT NULL ,
	[InvDate] [datetime] NULL ,
	[InvRef] [nvarchar] (20 ) NOT NULL ,
	[InvOrigAmount] [money] NULL ,
	[Amount] [money] NULL ,
	[BillID] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CheckID CheckID [int] NOT NULL  
InvDate InvDate [datetime] NULL  
InvRef InvRef [nvarchar](20) NOT NULL  
InvOrigAmount InvOrigAmount [money] NULL  
Amount Amount [money] NULL  
BillID BillID [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_bCheckDetails PRIMARY [CheckID], [InvRef]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

Commissions
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Commissions] (
	[ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[EmpName] [varchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL ,
	[PaidYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ID ID [int] NOT NULL  
EmpName EmpName [varchar](50) NULL  
Date Date [datetime] NULL  
Amount Amount [money] NULL  
PaidYN PaidYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_Commissions PRIMARY [ID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

Company
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Company] (
	[CompanyName] [varchar] (50 ) NULL ,
	[LegalName] [varchar] (50 ) NULL ,
	[Address1] [varchar] (50 ) NULL ,
	[Address2] [varchar] (50 ) NULL ,
	[City] [varchar] (50 ) NULL ,
	[State] [varchar] (50 ) NULL ,
	[Zip] [varchar] (10 ) NULL ,
	[Country] [varchar] (50 ) NULL ,
	[Phone] [varchar] (25 ) NULL ,
	[Fax] [varchar] (25 ) NULL ,
	[email] [varchar] (50 ) NULL ,
	[website] [varchar] (50 ) NULL ,
	[FirstFiscalMonth] [varchar] (50 ) NULL ,
	[PictureURL] [char] (10 ) NULL ,
	[ConfirmDeletion] [bit] NOT NULL ,
	[UseAN] [bit] NOT NULL ,
	[DefaultCT] [int] NULL ,
	[DefaultIT] [int] NULL ,
	[DefaultSM] [varchar] (50 ) NULL ,
	[AgingReportUse] [bit] NOT NULL ,
	[TaxFreight] [bit] NOT NULL ,
	[DefaultSalesTax] [varchar] (50 ) NULL ,
	[ChargeHandling] [bit] NOT NULL ,
	[HandlingAsPercent] [bit] NOT NULL ,
	[HandlingAmount] [float] NULL ,
	[CurrencySymbol] [varchar] (10 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CompanyName CompanyName [varchar](50) NULL  
LegalName LegalName [varchar](50) NULL  
Address1 Address1 [varchar](50) NULL  
Address2 Address2 [varchar](50) NULL  
City City [varchar](50) NULL  
State State [varchar](50) NULL  
Zip Zip [varchar](10) NULL  
Country Country [varchar](50) NULL  
Phone Phone [varchar](25) NULL  
Fax Fax [varchar](25) NULL  
email email [varchar](50) NULL  
website website [varchar](50) NULL  
FirstFiscalMonth FirstFiscalMonth [varchar](50) NULL  
PictureURL PictureURL [char](10) NULL  
ConfirmDeletion ConfirmDeletion [bit] NOT NULL  
UseAN UseAN [bit] NOT NULL  
DefaultCT DefaultCT [int] NULL  
DefaultIT DefaultIT [int] NULL  
DefaultSM DefaultSM [varchar](50) NULL  
AgingReportUse AgingReportUse [bit] NOT NULL  
TaxFreight TaxFreight [bit] NOT NULL  
DefaultSalesTax DefaultSalesTax [varchar](50) NULL  
ChargeHandling ChargeHandling [bit] NOT NULL  
HandlingAsPercent HandlingAsPercent [bit] NOT NULL  
HandlingAmount HandlingAmount [float] NULL  
CurrencySymbol CurrencySymbol [varchar](10) NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

csCustomerPaymentDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csCustomerPaymentDetails] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[FID] [varchar] (50 ) NOT NULL ,
	[ToPay] [money] NULL ,
	[textboxAmount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
FID FID [varchar](50) NOT NULL  
ToPay ToPay [money] NULL  
textboxAmount textboxAmount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_csCustomerPaymentDetails PRIMARY [Reference], [FID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

csOrderTracking
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csOrderTracking] (
	[OrderNo] [varchar] (50 ) NULL ,
	[InvoiceNo] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
OrderNo OrderNo [varchar](50) NULL  
InvoiceNo InvoiceNo [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
   

DocNumbers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[DocNumbers] (
	[CheckNo] [int] NOT NULL ,
	[Vouchers] [int] NOT NULL ,
	[Orders] [int] NOT NULL ,
	[BillPmt] [int] NOT NULL ,
	[Invoices] [int] NOT NULL ,
	[CustCredits] [int] NOT NULL ,
	[CustPmt] [int] NOT NULL ,
	[Adjustment] [int] NOT NULL ,
	[TimeTracking] [int] NOT NULL ,
	[Transfers] [int] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CheckNo CheckNo [int] NOT NULL  
Vouchers Vouchers [int] NOT NULL  
Orders Orders [int] NOT NULL  
BillPmt BillPmt [int] NOT NULL  
Invoices Invoices [int] NOT NULL  
CustCredits CustCredits [int] NOT NULL  
CustPmt CustPmt [int] NOT NULL  
Adjustment Adjustment [int] NOT NULL  
TimeTracking TimeTracking [int] NOT NULL  
Transfers Transfers [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
   

GeneralJournalDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GeneralJournalDetail] (
	[EntryNo] [varchar] (50 ) NOT NULL ,
	[No] [int] NOT NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Debit] [money] NULL ,
	[Credit] [money] NULL ,
	[Memo] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EntryNo EntryNo [varchar](50) NOT NULL  
No No [int] NOT NULL  
Account Account [varchar](50) NULL  
Debit Debit [money] NULL  
Credit Credit [money] NULL  
Memo Memo [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_GeneralJournalDetail PRIMARY [EntryNo], [No]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

GeneralJournalEntry
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GeneralJournalEntry] (
	[EntryNo] [nvarchar] (20 ) NOT NULL ,
	[Date] [datetime] NULL ,
	[TrType] [int] NULL ,
	[TrID] [varchar] (50 ) NULL ,
	[SystemGenerated] [bit] NOT NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EntryNo EntryNo [nvarchar](20) NOT NULL  
Date Date [datetime] NULL  
TrType TrType [int] NULL  
TrID TrID [varchar](50) NULL  
SystemGenerated SystemGenerated [bit] NOT NULL  
PostedYN PostedYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_GeneralJournalEntry PRIMARY [EntryNo]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

GLWorkDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GLWorkDetail] (
	[GLID] [varchar] (50 ) NOT NULL ,
	[No] [char] (10 ) NOT NULL ,
	[Credit] [money] NULL ,
	[Debit] [money] NULL ,
	[Memo] [varchar] (50 ) NULL ,
	[Account] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GLID GLID [varchar](50) NOT NULL  
No No [char](10) NOT NULL  
Credit Credit [money] NULL  
Debit Debit [money] NULL  
Memo Memo [varchar](50) NULL  
Account Account [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_GLWorkDetail PRIMARY [GLID], [No]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsAccountTypes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsAccountTypes] (
	[Description] [varchar] (50 ) NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Description Description [varchar](50) NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
aaaaalsAccountType_PK PRIMARY [Description]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsClasses
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsClasses] (
	[ClassName] [varchar] (50 ) NOT NULL ,
	[Subclass] [bit] NOT NULL ,
	[ClassName1] [varchar] (50 ) NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ClassName ClassName [varchar](50) NOT NULL  
Subclass Subclass [bit] NOT NULL  
ClassName1 ClassName1 [varchar](50) NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsClasses PRIMARY [ClassName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsCustomerMessages
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsCustomerMessages] (
	[CustomerMessage] [varchar] (50 ) NOT NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CustomerMessage CustomerMessage [varchar](50) NOT NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsCustomerMessages PRIMARY [CustomerMessage]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsCustomersShipTo
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsCustomersShipTo] (
	[CustomerName] [varchar] (50 ) NULL ,
	[ShippingAddress] [varchar] (50 ) NULL ,
	[City] [varchar] (50 ) NULL ,
	[State] [varchar] (10 ) NULL ,
	[Zip] [varchar] (10 ) NULL ,
	[Country] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CustomerName CustomerName [varchar](50) NULL  
ShippingAddress ShippingAddress [varchar](50) NULL  
City City [varchar](50) NULL  
State State [varchar](10) NULL  
Zip Zip [varchar](10) NULL  
Country Country [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
   

lsCustomerTypes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsCustomerTypes] (
	[CustomerType] [varchar] (50 ) NOT NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CustomerType CustomerType [varchar](50) NOT NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsCustomerTypes PRIMARY [CustomerType]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsItemCategories
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsItemCategories] (
	[CategoryID] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (50 ) NULL ,
	[PictureURL] [varchar] (50 ) NULL ,
	[familyID] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CategoryID CategoryID [varchar](50) NOT NULL  
Description Description [varchar](50) NULL  
PictureURL PictureURL [varchar](50) NULL  
familyID familyID [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsItemCategories PRIMARY [CategoryID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsItemFamilies
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsItemFamilies] (
	[FamilyID] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (50 ) NULL ,
	[PictureURL] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
FamilyID FamilyID [varchar](50) NOT NULL  
Description Description [varchar](50) NULL  
PictureURL PictureURL [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsItemFamilies PRIMARY [FamilyID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsMemorized
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsMemorized] (
	[Name] [varchar] (50 ) NOT NULL ,
	[TrType] [varchar] (20 ) NULL ,
	[TransID] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Name Name [varchar](50) NOT NULL  
TrType TrType [varchar](20) NULL  
TransID TransID [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsMemorized PRIMARY [Name]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsPaymentMethods
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsPaymentMethods] (
	[PaymentMethod] [nvarchar] (20 ) NOT NULL ,
	[ExternalAccess] [bit] NOT NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PaymentMethod PaymentMethod [nvarchar](20) NOT NULL  
ExternalAccess ExternalAccess [bit] NOT NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsPaymentMethods PRIMARY [PaymentMethod]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsShippingMethods
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsShippingMethods] (
	[ShippingMethod] [varchar] (50 ) NOT NULL ,
	[AccountNo] [varchar] (50 ) NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ShippingMethod ShippingMethod [varchar](50) NOT NULL  
AccountNo AccountNo [varchar](50) NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsShippingMethods PRIMARY [ShippingMethod]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsTaxGroupDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsTaxGroupDetail] (
	[GrpID] [varchar] (10 ) NULL ,
	[TaxID] [varchar] (10 ) NULL ,
	[Description] [varchar] (50 ) NULL ,
	[Account] [varchar] (50 ) NULL ,
	[TaxPercent] [float] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
GrpID GrpID [varchar](10) NULL  
TaxID TaxID [varchar](10) NULL  
Description Description [varchar](50) NULL  
Account Account [varchar](50) NULL  
TaxPercent TaxPercent [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsTaxGroups
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsTaxGroups] (
	[TaxGroupID] [varchar] (10 ) NOT NULL ,
	[TaxGroupName] [varchar] (50 ) NULL ,
	[TotalPercent] [float] NULL ,
	[Inactive] [bit] NOT NULL ,
	[IsDefault] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
TaxGroupID TaxGroupID [varchar](10) NOT NULL  
TaxGroupName TaxGroupName [varchar](50) NULL  
TotalPercent TotalPercent [float] NULL  
Inactive Inactive [bit] NOT NULL  
IsDefault IsDefault [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsTaxGroups PRIMARY [TaxGroupID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsTerms
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsTerms] (
	[Term] [varchar] (50 ) NOT NULL ,
	[Standard] [bit] NOT NULL ,
	[DayTillNetDue] [smallint] NULL ,
	[Discount] [float] NULL ,
	[DaysTillDiscountExpires] [smallint] NULL ,
	[DayOfMonthNetDue] [smallint] NULL ,
	[DueNextMonthIfWithinDays] [smallint] NULL ,
	[Discount1] [float] NULL ,
	[DayDiscountExpires] [smallint] NULL ,
	[Inactive] [bit] NOT NULL ,
	[upsize_ts] [timestamp] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Term Term [varchar](50) NOT NULL  
Standard Standard [bit] NOT NULL  
DayTillNetDue DayTillNetDue [smallint] NULL  
Discount Discount [float] NULL  
DaysTillDiscountExpires DaysTillDiscountExpires [smallint] NULL  
DayOfMonthNetDue DayOfMonthNetDue [smallint] NULL  
DueNextMonthIfWithinDays DueNextMonthIfWithinDays [smallint] NULL  
Discount1 Discount1 [float] NULL  
DayDiscountExpires DayDiscountExpires [smallint] NULL  
Inactive Inactive [bit] NOT NULL  
upsize_ts upsize_ts [timestamp] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsTerms PRIMARY [Term]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsVendorTypes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsVendorTypes] (
	[VendorType] [nvarchar] (30 ) NOT NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
VendorType VendorType [nvarchar](30) NOT NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsVendorTypes PRIMARY [VendorType]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

Months
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Months] (
	[MonthID] [int] NULL ,
	[Name] [nvarchar] (20 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
MonthID MonthID [int] NULL  
Name 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
   

OpBalWork
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[OpBalWork] (
	[AccountID] [varchar] (50 ) NULL ,
	[AccBalType] [int] NULL ,
	[OpeningBalance] [float] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AccountID AccountID [varchar](50) NULL  
AccBalType AccBalType [int] NULL  
OpeningBalance OpeningBalance [float] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

Users
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Users] (
	[Username] [varchar] (20 ) NOT NULL ,
	[Password] [varchar] (20 ) NULL ,
	[UserID] [varchar] (20 ) NULL ,
	[SecurityID] [varchar] () NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Username Username [varchar](20) NOT NULL  
Password Password [varchar](20) NULL  
UserID UserID [varchar](20) NULL  
SecurityID SecurityID [varchar](1) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_Users PRIMARY [Username]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

vpBillPaymentDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillPaymentDetails] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[FID] [varchar] (50 ) NOT NULL ,
	[textboxAmount] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
FID FID [varchar](50) NOT NULL  
textboxAmount textboxAmount [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_vpBillPaymentDetails PRIMARY [Reference], [FID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsAccounts
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsAccounts] (
	[AccountNumber] [varchar] (10 ) NULL ,
	[AccountName] [varchar] (50 ) NOT NULL ,
	[AccountType] [varchar] (50 ) NULL ,
	[Subaccount] [bit] NOT NULL ,
	[AccountName1] [varchar] (50 ) NULL ,
	[Description] [varchar] (50 ) NULL ,
	[OpeningBalance] [money] NULL ,
	[Date] [datetime] NULL ,
	[Inactive] [bit] NOT NULL ,
	[Balance] [money] NULL ,
	[BalanceType] [smallint] NULL ,
	[Modified] [smallint] NULL ,
	[OpBalID] [int] IDENTITY (, 1 ) NOT NULL ,
	[IsDefault] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
AccountNumber AccountNumber [varchar](10) NULL  
AccountName AccountName [varchar](50) NOT NULL  
AccountType AccountType [varchar](50) NULL  
Subaccount Subaccount [bit] NOT NULL  
AccountName1 AccountName1 [varchar](50) NULL  
Description Description [varchar](50) NULL  
OpeningBalance OpeningBalance [money] NULL  
Date Date [datetime] NULL  
Inactive Inactive [bit] NOT NULL  
Balance Balance [money] NULL  
BalanceType BalanceType [smallint] NULL  
Modified Modified [smallint] NULL  
OpBalID OpBalID [int] NOT NULL  
IsDefault IsDefault [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsAccounts PRIMARY [AccountName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

bChecks
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[bChecks] (
	[CheckID] [int] IDENTITY (, 1 ) NOT NULL ,
	[CheckNo] [varchar] (50 ) NOT NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Payee] [varchar] (50 ) NULL ,
	[Address] [varchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL ,
	[Memo] [varchar] (50 ) NULL ,
	[GroupID] [varchar] (50 ) NULL ,
	[ClearedYN] [bit] NOT NULL ,
	[VoidedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CheckID CheckID [int] NOT NULL  
CheckNo CheckNo [varchar](50) NOT NULL  
Account Account [varchar](50) NULL  
Payee Payee [varchar](50) NULL  
Address Address [varchar](50) NULL  
Date Date [datetime] NULL  
Amount Amount [money] NULL  
Memo Memo [varchar](50) NULL  
GroupID GroupID [varchar](50) NULL  
ClearedYN ClearedYN [bit] NOT NULL  
VoidedYN VoidedYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_bChecks PRIMARY [CheckID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

bTransferFunds
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[bTransferFunds] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[FromAccount] [varchar] (50 ) NULL ,
	[ToAccount] [varchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[ClearedYN] [bit] NOT NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
FromAccount FromAccount [varchar](50) NULL  
ToAccount ToAccount [varchar](50) NULL  
Date Date [datetime] NULL  
Amount Amount [money] NULL  
Memo Memo [nvarchar](50) NULL  
ClearedYN ClearedYN [bit] NOT NULL  
PostedYN PostedYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_bTransferFunds PRIMARY [Reference]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

EmpChecks
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[EmpChecks] (
	[CheckID] [int] IDENTITY (, 1 ) NOT NULL ,
	[CheckNo] [int] NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Payee] [varchar] (50 ) NULL ,
	[Amount] [money] NULL ,
	[Address] [varchar] (255 ) NULL ,
	[Date] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CheckID CheckID [int] NOT NULL  
CheckNo CheckNo [int] NULL  
Account Account [varchar](50) NULL  
Payee Payee [varchar](50) NULL  
Amount Amount [money] NULL  
Address Address [varchar](255) NULL  
Date Date [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_EmpChecks PRIMARY [CheckID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

InventoryAdjustments
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[InventoryAdjustments] (
	[Date] [datetime] NULL ,
	[RefNo] [varchar] (50 ) NOT NULL ,
	[AdjustmentAccount] [varchar] (50 ) NULL ,
	[Customer] [varchar] (50 ) NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[TotalValue] [money] NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Date Date [datetime] NULL  
RefNo RefNo [varchar](50) NOT NULL  
AdjustmentAccount AdjustmentAccount [varchar](50) NULL  
Customer Customer [varchar](50) NULL  
Memo Memo [nvarchar](50) NULL  
TotalValue TotalValue [money] NULL  
PostedYN PostedYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
aaaaaInventoryAdjustment_PK PRIMARY [RefNo]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsEmployees
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsEmployees] (
	[EmployeeName] [varchar] (50 ) NOT NULL ,
	[SalesmanID] [varchar] (10 ) NULL ,
	[Initials] [nvarchar] (30 ) NULL ,
	[TaxID] [nvarchar] (20 ) NULL ,
	[MrMs] [nvarchar] (10 ) NULL ,
	[FirstName] [nvarchar] (20 ) NULL ,
	[MiddleInitial] [nvarchar] (10 ) NULL ,
	[LastName] [nvarchar] (20 ) NULL ,
	[Address1] [nvarchar] (50 ) NULL ,
	[Address2] [nvarchar] (50 ) NULL ,
	[City] [nvarchar] (50 ) NULL ,
	[State] [nvarchar] (10 ) NULL ,
	[Zip] [nvarchar] (10 ) NULL ,
	[Country] [nvarchar] (50 ) NULL ,
	[Phone] [nvarchar] (25 ) NULL ,
	[email] [nvarchar] (30 ) NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Inactive] [bit] NOT NULL ,
	[PasswordTTA] [nvarchar] (20 ) NULL ,
	[YN1099] [bit] NOT NULL ,
	[CommissionYN] [bit] NOT NULL ,
	[CommissionRate] [float] NULL ,
	[Commission] [money] NULL ,
	[Refferal] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
EmployeeName EmployeeName [varchar](50) NOT NULL  
SalesmanID SalesmanID [varchar](10) NULL  
Initials Initials [nvarchar](30) NULL  
TaxID TaxID [nvarchar](20) NULL  
MrMs MrMs [nvarchar](10) NULL  
FirstName FirstName [nvarchar](20) NULL  
MiddleInitial MiddleInitial [nvarchar](10) NULL  
LastName LastName [nvarchar](20) NULL  
Address1 Address1 [nvarchar](50) NULL  
Address2 Address2 [nvarchar](50) NULL  
City City [nvarchar](50) NULL  
State State [nvarchar](10) NULL  
Zip Zip [nvarchar](10) NULL  
Country Country [nvarchar](50) NULL  
Phone Phone [nvarchar](25) NULL  
email email [nvarchar](30) NULL  
Account Account [varchar](50) NULL  
Inactive Inactive [bit] NOT NULL  
PasswordTTA PasswordTTA [nvarchar](20) NULL  
YN1099 YN1099 [bit] NOT NULL  
CommissionYN CommissionYN [bit] NOT NULL  
CommissionRate CommissionRate [float] NULL  
Commission Commission [money] NULL  
Refferal Refferal [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsEmployees PRIMARY [EmployeeName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsItems] (
	[ItemType] [int] NULL ,
	[CategoryID] [varchar] (50 ) NULL ,
	[ItemName] [varchar] (50 ) NOT NULL ,
	[Subitem] [bit] NOT NULL ,
	[ItemName1] [varchar] (50 ) NULL ,
	[PurchaseDescription] [varchar] (50 ) NULL ,
	[Cost] [money] NULL ,
	[COGSAccount] [varchar] (50 ) NULL ,
	[PrefferedVendor] [varchar] (50 ) NULL ,
	[SalesDescription] [varchar] (50 ) NULL ,
	[IncomeAccount] [varchar] (50 ) NULL ,
	[SalesPrice] [money] NULL ,
	[Taxable] [bit] NOT NULL ,
	[AssetAccount] [varchar] (50 ) NULL ,
	[QuantityOnHand] [int] NULL ,
	[TotalValue] [float] NULL ,
	[ReorderPoint] [int] NULL ,
	[ItemWeight] [float] NULL ,
	[Inactive] [bit] NOT NULL ,
	[PictureURL] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ItemType ItemType [int] NULL  
CategoryID CategoryID [varchar](50) NULL  
ItemName ItemName [varchar](50) NOT NULL  
Subitem Subitem [bit] NOT NULL  
ItemName1 ItemName1 [varchar](50) NULL  
PurchaseDescription PurchaseDescription [varchar](50) NULL  
Cost Cost [money] NULL  
COGSAccount COGSAccount [varchar](50) NULL  
PrefferedVendor PrefferedVendor [varchar](50) NULL  
SalesDescription SalesDescription [varchar](50) NULL  
IncomeAccount IncomeAccount [varchar](50) NULL  
SalesPrice SalesPrice [money] NULL  
Taxable Taxable [bit] NOT NULL  
AssetAccount AssetAccount [varchar](50) NULL  
QuantityOnHand QuantityOnHand [int] NULL  
TotalValue TotalValue [float] NULL  
ReorderPoint ReorderPoint [int] NULL  
ItemWeight ItemWeight [float] NULL  
Inactive Inactive [bit] NOT NULL  
PictureURL PictureURL [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsItems PRIMARY [ItemName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsTaxes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsTaxes] (
	[TaxID] [varchar] (10 ) NOT NULL ,
	[Description] [varchar] (50 ) NULL ,
	[TaxPercent] [float] NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
TaxID TaxID [varchar](10) NOT NULL  
Description Description [varchar](50) NULL  
TaxPercent TaxPercent [float] NULL  
Account Account [varchar](50) NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsTaxes PRIMARY [TaxID]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsVendors
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsVendors] (
	[VendorName] [varchar] (50 ) NOT NULL ,
	[Company] [varchar] (50 ) NULL ,
	[MrMs] [varchar] (10 ) NULL ,
	[FirstName] [varchar] (20 ) NULL ,
	[MiddleInitial] [varchar] (10 ) NULL ,
	[LastName] [varchar] (20 ) NULL ,
	[Contact] [varchar] (30 ) NULL ,
	[Address1] [varchar] (50 ) NULL ,
	[Address2] [varchar] (50 ) NULL ,
	[City] [varchar] (50 ) NULL ,
	[State] [varchar] (50 ) NULL ,
	[Zip] [varchar] (10 ) NULL ,
	[Country] [varchar] (50 ) NULL ,
	[Phone] [varchar] (25 ) NULL ,
	[Fax] [varchar] (25 ) NULL ,
	[AltPhone] [varchar] (25 ) NULL ,
	[AltContact] [varchar] (30 ) NULL ,
	[PrintOnCheckAs] [varchar] (30 ) NULL ,
	[AccountNumber] [varchar] (50 ) NULL ,
	[DefaultExpenseAccount] [varchar] (50 ) NULL ,
	[VendorType] [varchar] (50 ) NULL ,
	[Term] [varchar] (50 ) NULL ,
	[PMID] [int] IDENTITY (, 1 ) NOT NULL ,
	[CreditLimit] [money] NULL ,
	[TaxID] [varchar] (20 ) NULL ,
	[Eligible] [bit] NOT NULL ,
	[Email] [varchar] (30 ) NULL ,
	[OpeningBalance] [money] NULL ,
	[OpeningBalanceDate] [datetime] NULL ,
	[Balance] [money] NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
VendorName VendorName [varchar](50) NOT NULL  
Company Company [varchar](50) NULL  
MrMs MrMs [varchar](10) NULL  
FirstName FirstName [varchar](20) NULL  
MiddleInitial MiddleInitial [varchar](10) NULL  
LastName LastName [varchar](20) NULL  
Contact Contact [varchar](30) NULL  
Address1 Address1 [varchar](50) NULL  
Address2 Address2 [varchar](50) NULL  
City City [varchar](50) NULL  
State State [varchar](50) NULL  
Zip Zip [varchar](10) NULL  
Country Country [varchar](50) NULL  
Phone Phone [varchar](25) NULL  
Fax Fax [varchar](25) NULL  
AltPhone AltPhone [varchar](25) NULL  
AltContact AltContact [varchar](30) NULL  
PrintOnCheckAs PrintOnCheckAs [varchar](30) NULL  
AccountNumber AccountNumber [varchar](50) NULL  
DefaultExpenseAccount DefaultExpenseAccount [varchar](50) NULL  
VendorType VendorType [varchar](50) NULL  
Term Term [varchar](50) NULL  
PMID PMID [int] NOT NULL  
CreditLimit CreditLimit [money] NULL  
TaxID TaxID [varchar](20) NULL  
Eligible Eligible [bit] NOT NULL  
Email Email [varchar](30) NULL  
OpeningBalance OpeningBalance [money] NULL  
OpeningBalanceDate OpeningBalanceDate [datetime] NULL  
Balance Balance [money] NULL  
Inactive Inactive [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsVendors PRIMARY [VendorName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

vpBillExpenses
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillExpenses] (
	[Reference] [varchar] (50 ) NULL ,
	[No] [int] NULL ,
	[Account] [varchar] (50 ) NULL ,
	[Amount] [money] NULL ,
	[Memo] [varchar] (50 ) NULL ,
	[Project] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NULL  
No No [int] NULL  
Account Account [varchar](50) NULL  
Amount Amount [money] NULL  
Memo Memo [varchar](50) NULL  
Project Project [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
   

csCustomerCreditItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csCustomerCreditItems] (
	[CustomerCreditNo] [varchar] (50 ) NOT NULL ,
	[No] [int] NOT NULL ,
	[Item] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (50 ) NULL ,
	[Quantity] [float] NULL ,
	[Rate] [money] NULL ,
	[Amount] [money] NULL ,
	[Tax] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
CustomerCreditNo CustomerCreditNo [varchar](50) NOT NULL  
No No [int] NOT NULL  
Item Item [varchar](50) NOT NULL  
Description Description [varchar](50) NULL  
Quantity Quantity [float] NULL  
Rate Rate [money] NULL  
Amount Amount [money] NULL  
Tax Tax [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_csCustomerCreditItems PRIMARY [CustomerCreditNo], [No]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

csInvoiceItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csInvoiceItems] (
	[InvoiceNo] [varchar] (50 ) NOT NULL ,
	[No] [int] NOT NULL ,
	[Item] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (255 ) NULL ,
	[Quantity] [float] NULL ,
	[Rate] [money] NULL ,
	[Amount] [money] NULL ,
	[ItemWeight] [float] NULL ,
	[Shipped] [bit] NOT NULL ,
	[ShippedDate] [smalldatetime] NULL ,
	[TrackingNumber] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
InvoiceNo InvoiceNo [varchar](50) NOT NULL  
No No [int] NOT NULL  
Item Item [varchar](50) NOT NULL  
Description Description [varchar](255) NULL  
Quantity Quantity [float] NULL  
Rate Rate [money] NULL  
Amount Amount [money] NULL  
ItemWeight ItemWeight [float] NULL  
Shipped Shipped [bit] NOT NULL  
ShippedDate ShippedDate [smalldatetime] NULL  
TrackingNumber TrackingNumber [varchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_csInvoiceItems PRIMARY [InvoiceNo], [No]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

csOrderItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csOrderItems] (
	[OrderNo] [varchar] (50 ) NOT NULL ,
	[No] [int] NOT NULL ,
	[Item] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (255 ) NULL ,
	[Quantity] [float] NULL ,
	[Ship] [float] NULL ,
	[Rate] [money] NULL ,
	[Amount] [money] NULL ,
	[ItemWeight] [float] NULL ,
	[ShipDate] [datetime] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
OrderNo OrderNo [varchar](50) NOT NULL  
No No [int] NOT NULL  
Item Item [varchar](50) NOT NULL  
Description Description [varchar](255) NULL  
Quantity Quantity [float] NULL  
Ship Ship [float] NULL  
Rate Rate [money] NULL  
Amount Amount [money] NULL  
ItemWeight ItemWeight [float] NULL  
ShipDate ShipDate [datetime] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_csOrderItems PRIMARY [OrderNo], [No]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

InventoryAdjustmentDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[InventoryAdjustmentDetail] (
	[RefNo] [varchar] (50 ) NULL ,
	[Item] [varchar] (50 ) NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[CurrentQty] [float] NULL ,
	[CurrentValue] [money] NULL ,
	[NewQty] [float] NULL ,
	[NewValue] [money] NULL ,
	[QtyDifference] [float] NULL ,
	[ValueDifference] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
RefNo RefNo [varchar](50) NULL  
Item Item [varchar](50) NULL  
Description Description [nvarchar](50) NULL  
CurrentQty CurrentQty [float] NULL  
CurrentValue CurrentValue [money] NULL  
NewQty NewQty [float] NULL  
NewValue NewValue [money] NULL  
QtyDifference QtyDifference [float] NULL  
ValueDifference ValueDifference [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

lsCustomers
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsCustomers] (
	[Login] [varchar] (50 ) NULL ,
	[Password] [varchar] (50 ) NULL ,
	[CustomerName] [varchar] (50 ) NOT NULL ,
	[Company] [varchar] (50 ) NULL ,
	[MrMs] [varchar] (50 ) NULL ,
	[FirstName] [varchar] (50 ) NULL ,
	[MiddleInitial] [varchar] (50 ) NULL ,
	[LastName] [varchar] (50 ) NULL ,
	[BillingAddress1] [varchar] (50 ) NULL ,
	[BillingAddress2] [varchar] (50 ) NULL ,
	[City] [varchar] (50 ) NULL ,
	[State] [varchar] (50 ) NULL ,
	[Zip] [varchar] (50 ) NULL ,
	[Country] [varchar] (50 ) NULL ,
	[Contact] [varchar] (50 ) NULL ,
	[Phone] [varchar] (50 ) NULL ,
	[Email] [varchar] (50 ) NULL ,
	[Fax] [varchar] (50 ) NULL ,
	[AltPhone] [varchar] (50 ) NULL ,
	[AltContact] [varchar] (50 ) NULL ,
	[Account] [varchar] (50 ) NULL ,
	[CustomerType] [varchar] (50 ) NULL ,
	[Term] [varchar] (50 ) NULL ,
	[Rep] [varchar] (50 ) NULL ,
	[CreditLimit] [float] NULL ,
	[Taxable] [bit] NOT NULL ,
	[TaxItem] [varchar] (50 ) NULL ,
	[ResaleNumber] [varchar] (50 ) NULL ,
	[OpeningBalance] [money] NULL ,
	[OpeningBalanceDate] [datetime] NULL ,
	[Inactive] [bit] NOT NULL ,
	[PasswordCA] [varchar] (50 ) NULL ,
	[Balance] [money] NULL ,
	[ExistingCredit] [money] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Login Login [varchar](50) NULL  
Password Password [varchar](50) NULL  
CustomerName CustomerName [varchar](50) NOT NULL  
Company Company [varchar](50) NULL  
MrMs MrMs [varchar](50) NULL  
FirstName FirstName [varchar](50) NULL  
MiddleInitial MiddleInitial [varchar](50) NULL  
LastName LastName [varchar](50) NULL  
BillingAddress1 BillingAddress1 [varchar](50) NULL  
BillingAddress2 BillingAddress2 [varchar](50) NULL  
City City [varchar](50) NULL  
State State [varchar](50) NULL  
Zip Zip [varchar](50) NULL  
Country Country [varchar](50) NULL  
Contact Contact [varchar](50) NULL  
Phone Phone [varchar](50) NULL  
Email Email [varchar](50) NULL  
Fax Fax [varchar](50) NULL  
AltPhone AltPhone [varchar](50) NULL  
AltContact AltContact [varchar](50) NULL  
Account Account [varchar](50) NULL  
CustomerType CustomerType [varchar](50) NULL  
Term Term [varchar](50) NULL  
Rep Rep [varchar](50) NULL  
CreditLimit CreditLimit [float] NULL  
Taxable Taxable [bit] NOT NULL  
TaxItem TaxItem [varchar](50) NULL  
ResaleNumber ResaleNumber [varchar](50) NULL  
OpeningBalance OpeningBalance [money] NULL  
OpeningBalanceDate OpeningBalanceDate [datetime] NULL  
Inactive Inactive [bit] NOT NULL  
PasswordCA PasswordCA [varchar](50) NULL  
Balance Balance [money] NULL  
ExistingCredit ExistingCredit [money] NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_lsCustomers PRIMARY [CustomerName]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

TimeTracking
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[TimeTracking] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[Employee] [varchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[Customer] [varchar] (50 ) NULL ,
	[ServiceItem] [varchar] (50 ) NULL ,
	[Class] [varchar] (50 ) NULL ,
	[Duration] [float] NULL ,
	[Memo] [nvarchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
Employee Employee [varchar](50) NULL  
Date Date [datetime] NULL  
Customer Customer [varchar](50) NULL  
ServiceItem ServiceItem [varchar](50) NULL  
Class Class [varchar](50) NULL  
Duration Duration [float] NULL  
Memo Memo [nvarchar](50) NULL  

Primary and Unique Keys
Key Name Key Type Keys
aaaaaTimeTracking_PK PRIMARY [Reference]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

vpBillItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillItems] (
	[BillID] [varchar] (50 ) NULL ,
	[No] [int] NULL ,
	[Item] [varchar] (50 ) NULL ,
	[Description] [nvarchar] (50 ) NULL ,
	[Quantity] [float] NULL ,
	[Rate] [money] NULL ,
	[Amount] [money] NULL ,
	[Project] [varchar] (50 ) NULL ,
	[Billable] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
BillID BillID [varchar](50) NULL  
No No [int] NULL  
Item Item [varchar](50) NULL  
Description Description [nvarchar](50) NULL  
Quantity Quantity [float] NULL  
Rate Rate [money] NULL  
Amount Amount [money] NULL  
Project Project [varchar](50) NULL  
Billable Billable [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
   

vpBillPayments
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillPayments] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[Account] [varchar] (50 ) NULL ,
	[ToBePrinted] [bit] NOT NULL ,
	[Vendor] [varchar] (50 ) NULL ,
	[Date] [datetime] NULL ,
	[CheckNo] [nvarchar] (20 ) NULL ,
	[Amount] [money] NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[ClearedYN] [bit] NOT NULL ,
	[LastCheckNo] [int] NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
Account Account [varchar](50) NULL  
ToBePrinted ToBePrinted [bit] NOT NULL  
Vendor Vendor [varchar](50) NULL  
Date Date [datetime] NULL  
CheckNo CheckNo [nvarchar](20) NULL  
Amount Amount [money] NULL  
Memo Memo [nvarchar](50) NULL  
ClearedYN ClearedYN [bit] NOT NULL  
LastCheckNo LastCheckNo [int] NULL  

Primary and Unique Keys
Key Name Key Type Keys
aaaaavpBillPayment_PK PRIMARY [Reference]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

vpBills
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBills] (
	[Date] [datetime] NULL ,
	[Vendor] [varchar] (50 ) NULL ,
	[Reference] [varchar] (20 ) NOT NULL ,
	[Type] [varchar] (20 ) NULL ,
	[Term] [varchar] (50 ) NULL ,
	[DueDate] [datetime] NULL ,
	[VendorInvoice] [nvarchar] (20 ) NULL ,
	[Freight] [money] NULL ,
	[Discount] [money] NULL ,
	[OtherCharges] [money] NULL ,
	[Amount] [money] NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[PayAmount] [money] NULL ,
	[DueAmount] [money] NULL ,
	[PORef] [varchar] (50 ) NULL ,
	[PmtID] [int] IDENTITY (, 1 ) NOT NULL ,
	[PayYN] [bit] NOT NULL ,
	[CheckID] [int] NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Date Date [datetime] NULL  
Vendor Vendor [varchar](50) NULL  
Reference Reference [varchar](20) NOT NULL  
Type Type [varchar](20) NULL  
Term Term [varchar](50) NULL  
DueDate DueDate [datetime] NULL  
VendorInvoice VendorInvoice [nvarchar](20) NULL  
Freight Freight [money] NULL  
Discount Discount [money] NULL  
OtherCharges OtherCharges [money] NULL  
Amount Amount [money] NULL  
Memo Memo [nvarchar](50) NULL  
PayAmount PayAmount [money] NULL  
DueAmount DueAmount [money] NULL  
PORef PORef [varchar](50) NULL  
PmtID PmtID [int] NOT NULL  
PayYN PayYN [bit] NOT NULL  
CheckID CheckID [int] NULL  
PostedYN PostedYN [bit] NOT NULL  

Primary and Unique Keys
Key Name Key Type Keys
PK_vpBills PRIMARY [Reference]

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   

vpPurchaseOrderDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpPurchaseOrderDetails] (
	[ID] [int] IDENTITY (, 1 ) NOT NULL ,
	[PORef] [varchar] (50 ) NULL ,
	[No] [int] NULL ,
	[Item] [varchar] (50 ) NULL ,
	[Quantity] [float] NULL ,
	[ReceivedQty] [float] NULL ,
	[Rate] [money] NULL ,
	[Amount] [money] NULL ,
	[Description] [nvarchar] (255 ) NULL ,
	[Project] [varchar] (50 ) NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
ID ID [int] NOT NULL  
PORef PORef [varchar](50) NULL  
No No [int] NULL  
Item Item [varchar](50) NULL  
Quantity Quantity [float] NULL  
ReceivedQty ReceivedQty [float] NULL  
Rate Rate [money] NULL  
Amount Amount [money] NULL  
Description Description [nvarchar](255) NULL  
Project Project [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
   

vpPurchaseOrders
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpPurchaseOrders] (
	[PORef] [varchar] (50 ) NOT NULL ,
	[Date] [datetime] NULL ,
	[DueDate] [datetime] NULL ,
	[Term] [varchar] (50 ) NULL ,
	[Vendor] [varchar] (50 ) NULL ,
	[Class] [varchar] (50 ) NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[BillTo] [varchar] (50 ) NULL ,
	[ShipTo] [varchar] (50 ) NULL ,
	[ReceiveBy] [datetime] NULL ,
	[VendorMessage] [varchar] (50 ) NULL ,
	[ShipVia] [varchar] (50 ) NULL ,
	[TrackingNumber] [varchar] (50 ) NULL ,
	[ShipToD] [nvarchar] (100 ) NULL ,
	[VendorInvoice] [varchar] (20 ) NULL ,
	[Freight] [money] NULL ,
	[Discount] [float] NULL ,
	[OtherCharges] [money] NULL ,
	[ShippingCharge] [money] NULL ,
	[Total] [money] NULL ,
	[ReceivedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
PORef PORef [varchar](50) NOT NULL  
Date Date [datetime] NULL  
DueDate DueDate [datetime] NULL  
Term Term [varchar](50) NULL  
Vendor Vendor [varchar](50) NULL  
Class Class [varchar](50) NULL  
Memo Memo [nvarchar](50) NULL  
BillTo BillTo [varchar](50) NULL  
ShipTo ShipTo [varchar](50) NULL  
ReceiveBy ReceiveBy [datetime] NULL  
VendorMessage VendorMessage [varchar](50) NULL  
ShipVia ShipVia [varchar](50) NULL  
TrackingNumber TrackingNumber [varchar](50) NULL  
ShipToD ShipToD [nvarchar](100) NULL  
VendorInvoice VendorInvoice [varchar](20) NULL  
Freight Freight [money] NULL  
Discount Discount [float] NULL  
OtherCharges OtherCharges [money] NULL  
ShippingCharge ShippingCharge [money] NULL  
Total Total [money] NULL  
ReceivedYN ReceivedYN [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
   

csCustomerCredits
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csCustomerCredits] (
	[Customer] [varchar] (50 ) NOT NULL ,
	[Class] [varchar] (50 ) NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[BillTo] [nvarchar] (100 ) NULL ,
	[Date] [datetime] NULL ,
	[CreditNumber] [nvarchar] (20 ) NOT NULL ,
	[POID] [nvarchar] (20 ) NULL ,
	[CustomerMessage] [varchar] (50 ) NULL ,
	[Discount] [float] NULL ,
	[Handling] [money] NULL ,
	[Freight] [money] NULL ,
	[SalesTax] [varchar] (50 ) NULL ,
	[Tax] [money] NULL ,
	[TaxTotal] [money] NULL ,
	[Total] [money] NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer Customer [varchar](50) NOT NULL  
Class Class [varchar](50) NULL  
Memo Memo [nvarchar](50) NULL  
BillTo BillTo [nvarchar](100) NULL  
Date Date [datetime] NULL  
CreditNumber CreditNumber [nvarchar](20) NOT NULL  
POID POID [nvarchar](20) NULL  
CustomerMessage CustomerMessage [varchar](50) NULL  
Discount Discount [float] NULL  
Handling Handling [money] NULL  
Freight Freight [money] NULL  
SalesTax SalesTax [varchar](50) NULL  
Tax Tax [money] NULL  
TaxTotal TaxTotal [money] NULL  
Total Total [money] NULL  
PostedYN PostedYN [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
   

csCustomerPayments
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csCustomerPayments] (
	[Reference] [varchar] (50 ) NOT NULL ,
	[Customer] [varchar] (50 ) NULL ,
	[PaymentAmount] [money] NULL ,
	[Date] [datetime] NULL ,
	[PaymentMethod] [varchar] (50 ) NULL ,
	[Memo] [varchar] (50 ) NULL ,
	[CheckNo] [varchar] (20 ) NULL ,
	[CreditCardNo] [varchar] (30 ) NULL ,
	[CardExpires] [datetime] NULL ,
	[NameOnCard] [nvarchar] (30 ) NULL ,
	[CardZipCode] [nvarchar] (20 ) NULL ,
	[CardApproved] [bit] NOT NULL ,
	[UndepFunds] [bit] NOT NULL ,
	[DepositTo] [bit] NOT NULL ,
	[Account] [varchar] (50 ) NULL ,
	[ApplyExistingCredits] [bit] NOT NULL ,
	[Apply] [money] NULL ,
	[TotalToApply] [money] NULL ,
	[TotalApplied] [money] NULL ,
	[UnappliedAmount] [money] NULL ,
	[Deposit] [bit] NOT NULL ,
	[PayAmount] [money] NULL ,
	[ReceivedYN] [bit] NOT NULL ,
	[ClearedYN] [bit] NOT NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Reference Reference [varchar](50) NOT NULL  
Customer Customer [varchar](50) NULL  
PaymentAmount PaymentAmount [money] NULL  
Date Date [datetime] NULL  
PaymentMethod PaymentMethod [varchar](50) NULL  
Memo Memo [varchar](50) NULL  
CheckNo CheckNo [varchar](20) NULL  
CreditCardNo CreditCardNo [varchar](30) NULL  
CardExpires CardExpires [datetime] NULL  
NameOnCard NameOnCard [nvarchar](30) NULL  
CardZipCode CardZipCode [nvarchar](20) NULL  
CardApproved CardApproved [bit] NOT NULL  
UndepFunds UndepFunds [bit] NOT NULL  
DepositTo DepositTo [bit] NOT NULL  
Account Account [varchar](50) NULL  
ApplyExistingCredits ApplyExistingCredits [bit] NOT NULL  
Apply Apply [money] NULL  
TotalToApply TotalToApply [money] NULL  
TotalApplied TotalApplied [money] NULL  
UnappliedAmount UnappliedAmount [money] NULL  
Deposit Deposit [bit] NOT NULL  
PayAmount PayAmount [money] NULL  
ReceivedYN ReceivedYN [bit] NOT NULL  
ClearedYN ClearedYN [bit] NOT NULL  
PostedYN PostedYN [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
   

csInvoices
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csInvoices] (
	[Date] [datetime] NULL ,
	[Customer] [varchar] (50 ) NULL ,
	[ShipToID] [varchar] (50 ) NULL ,
	[Class] [varchar] (50 ) NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[Term] [varchar] (50 ) NULL ,
	[InvoiceNo] [nvarchar] (20 ) NOT NULL ,
	[DueDate] [datetime] NULL ,
	[ShipVia] [varchar] (50 ) NULL ,
	[ShipDate] [datetime] NULL ,
	[POID] [nvarchar] (20 ) NULL ,
	[CustomerMessage] [varchar] (50 ) NULL ,
	[TrackingNumber] [varchar] (30 ) NULL ,
	[Handling] [money] NULL ,
	[Freight] [money] NULL ,
	[Discount] [float] NULL ,
	[SalesTax] [varchar] (10 ) NULL ,
	[Tax] [money] NULL ,
	[TaxTotal] [money] NULL ,
	[Total] [money] NULL ,
	[TotalWeight] [float] NULL ,
	[ShippingCharge] [money] NULL ,
	[ApplyYN] [bit] NOT NULL ,
	[PaidYN] [bit] NULL ,
	[PayAmount] [money] NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Date Date [datetime] NULL  
Customer Customer [varchar](50) NULL  
ShipToID ShipToID [varchar](50) NULL  
Class Class [varchar](50) NULL  
Memo Memo [nvarchar](50) NULL  
Term Term [varchar](50) NULL  
InvoiceNo InvoiceNo [nvarchar](20) NOT NULL  
DueDate DueDate [datetime] NULL  
ShipVia ShipVia [varchar](50) NULL  
ShipDate ShipDate [datetime] NULL  
POID POID [nvarchar](20) NULL  
CustomerMessage CustomerMessage [varchar](50) NULL  
TrackingNumber TrackingNumber [varchar](30) NULL  
Handling Handling [money] NULL  
Freight Freight [money] NULL  
Discount Discount [float] NULL  
SalesTax SalesTax [varchar](10) NULL  
Tax Tax [money] NULL  
TaxTotal TaxTotal [money] NULL  
Total Total [money] NULL  
TotalWeight TotalWeight [float] NULL  
ShippingCharge ShippingCharge [money] NULL  
ApplyYN ApplyYN [bit] NOT NULL  
PaidYN PaidYN [bit] NULL  
PayAmount PayAmount [money] NULL  
PostedYN PostedYN [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
   

csOrders
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csOrders] (
	[Date] [datetime] NULL ,
	[Customer] [varchar] (50 ) NULL ,
	[ShipToID] [varchar] (50 ) NULL ,
	[Class] [varchar] (50 ) NULL ,
	[Memo] [nvarchar] (50 ) NULL ,
	[Term] [varchar] (50 ) NULL ,
	[OrderNo] [varchar] (50 ) NOT NULL ,
	[DueDate] [datetime] NULL ,
	[ShipVia] [varchar] (50 ) NULL ,
	[ShipDate] [datetime] NULL ,
	[POID] [varchar] (50 ) NULL ,
	[CustomerMessage] [varchar] (50 ) NULL ,
	[Discount] [float] NULL ,
	[Freight] [money] NULL ,
	[SalesTax] [varchar] (50 ) NULL ,
	[Tax] [money] NULL ,
	[TaxTotal] [money] NULL ,
	[Total] [money] NULL ,
	[TotalWeight] [float] NULL ,
	[ShippingCharge] [money] NULL ,
	[Handling] [money] NULL ,
	[ApplyYN] [bit] NOT NULL ,
	[Picked] [bit] NOT NULL ,
	[Billed] [bit] NOT NULL ,
	[Printed] [bit] NOT NULL ,
	[Shipped] [bit] NOT NULL ,
	[Backordered] [bit] NOT NULL ,
	[Invoiced] [bit] NOT NULL ,
	[TrackingNumber] [varchar] (30 ) NULL ,
	[CCType] [varchar] (50 ) NULL ,
	[CCName] [varchar] (50 ) NULL ,
	[CCNumber] [varchar] (20 ) NULL ,
	[CCExpDate] [datetime] NULL ,
	[ApprovalNumber] [varchar] (12 ) NULL ,
	[PostedYN] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Date Date [datetime] NULL  
Customer Customer [varchar](50) NULL  
ShipToID ShipToID [varchar](50) NULL  
Class Class [varchar](50) NULL  
Memo Memo [nvarchar](50) NULL  
Term Term [varchar](50) NULL  
OrderNo OrderNo [varchar](50) NOT NULL  
DueDate DueDate [datetime] NULL  
ShipVia ShipVia [varchar](50) NULL  
ShipDate ShipDate [datetime] NULL  
POID POID [varchar](50) NULL  
CustomerMessage CustomerMessage [varchar](50) NULL  
Discount Discount [float] NULL  
Freight Freight [money] NULL  
SalesTax SalesTax [varchar](50) NULL  
Tax Tax [money] NULL  
TaxTotal TaxTotal [money] NULL  
Total Total [money] NULL  
TotalWeight TotalWeight [float] NULL  
ShippingCharge ShippingCharge [money] NULL  
Handling Handling [money] NULL  
ApplyYN ApplyYN [bit] NOT NULL  
Picked Picked [bit] NOT NULL  
Billed Billed [bit] NOT NULL  
Printed Printed [bit] NOT NULL  
Shipped Shipped [bit] NOT NULL  
Backordered Backordered [bit] NOT NULL  
Invoiced Invoiced [bit] NOT NULL  
TrackingNumber TrackingNumber [varchar](30) NULL  
CCType CCType [varchar](50) NULL  
CCName CCName [varchar](50) NULL  
CCNumber CCNumber [varchar](20) NULL  
CCExpDate CCExpDate [datetime] NULL  
ApprovalNumber ApprovalNumber [varchar](12) NULL  
PostedYN PostedYN [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
   

lsProjects
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsProjects] (
	[Customer] [varchar] (50 ) NULL ,
	[ProjectName] [varchar] (50 ) NOT NULL ,
	[Description] [varchar] (255 ) NULL ,
	[ProjectManager] [varchar] (50 ) NULL ,
	[StartDate] [datetime] NULL ,
	[EndDate] [datetime] NULL ,
	[Inactive] [bit] NOT NULL 
) ON [PRIMARY]

Columns
ColumnName Domain Datatype NULL Definition
Customer Customer [varchar](50) NULL  
ProjectName ProjectName [varchar](50) NOT NULL  
Description Description [varchar](255) NULL  
ProjectManager ProjectManager [varchar](50) NULL  
StartDate StartDate [datetime] NULL  
EndDate EndDate [datetime] NULL  
Inactive Inactive [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