Database Schema 



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 , 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]