Generated: 6/5/2007 11:18:19 PM
bCheckDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[bCheckDetails](
	[CheckID] [int] NOT NULL ,
	[InvDate] [datetime] NULL ,
	[InvRef] [nvarchar](20 ) NOT NULL CONSTRAINT [DF_bCheckDetails_InvRef] DEFAULT ( ''),
	[InvOrigAmount] [money] NULL CONSTRAINT [DF_bCheckDetails_InvOrigAmount] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF_bCheckDetails_Amount] DEFAULT (),
	[BillID] [varchar](50 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_bCheckDetails] PRIMARY KEY NONCLUSTERED 
(
	[CheckID] ASC ,
	[InvRef] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_bCheckDetails] NOT NULL  

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

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 (,) 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 CONSTRAINT [DF__Temporary__Amoun__182C9B23] DEFAULT (),
	[Memo] [varchar](50 ) NULL ,
	[GroupID] [varchar](50 ) NULL ,
	[ClearedYN] [bit] NOT NULL CONSTRAINT [DF_bChecks_ClearedYN] DEFAULT (),
	[VoidedYN] [bit] NOT NULL CONSTRAINT [DF_bChecks_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_bChecks] PRIMARY KEY NONCLUSTERED 
(
	[CheckID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_bChecks] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_bChecks_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]

Storage
STORAGE OPTION STORAGE VALUE
   


bTransferFunds
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[bTransferFunds](
	[Reference] [varchar](50 ) NOT NULL ,
	[FromAccount] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__FromA__7B5B524B] DEFAULT (),
	[ToAccount] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__ToAcc__7C4F7684] DEFAULT (),
	[Date] [datetime] NULL ,
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__7D439ABD] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[ClearedYN] [bit] NOT NULL CONSTRAINT [DF_bTransferFunds_ClearedYN] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_bTransferFunds_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_bTransferFunds] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_bTransferFunds] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_bTransferFunds_lsAccounts EY([FromAccount] [dbo].[lsAccounts] EY([FromAccount]
FK_bTransferFunds_lsAccounts1 EY([ToAccount] [dbo].[lsAccounts] EY([ToAccount]

Storage
STORAGE OPTION STORAGE VALUE
   


Commissions
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Commissions](
	[ID] [int] IDENTITY (,) NOT NULL ,
	[EmpName] [varchar](50 ) NULL ,
	[Date] [datetime] NULL ,
	[Amount] [money] NULL CONSTRAINT [DF_Commissions_Amount] DEFAULT (),
	[PaidYN] [bit] NOT NULL CONSTRAINT [DF_Commissions_PaidYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_Commissions] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_Commissions] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Company
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Company](
	[CompanyID] [int] NOT NULL ,
	[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 CONSTRAINT [DF_Company_TrackCCP] DEFAULT (()),
	[UseAN] [bit] NOT NULL CONSTRAINT [DF_Company_UseAN] DEFAULT (()),
	[DefaultCT] [int] NULL ,
	[DefaultIT] [int] NULL ,
	[DefaultSM] [varchar](50 ) NULL ,
	[AgingReportUse] [bit] NOT NULL CONSTRAINT [DF_Company_AgingReportUse] DEFAULT (()),
	[TaxFreight] [bit] NOT NULL CONSTRAINT [DF_Company_TaxFreight] DEFAULT (()),
	[DefaultSalesTax] [varchar](50 ) NULL ,
	[ChargeHandling] [bit] NOT NULL CONSTRAINT [DF_Company_ChargeHandling] DEFAULT (()),
	[HandlingAsPercent] [bit] NOT NULL CONSTRAINT [DF_Company_HandlingAsPercent] DEFAULT (()),
	[HandlingAmount] [float] NULL CONSTRAINT [DF_Company_HandlingAmount] DEFAULT (()),
	[CurrencySymbol] [varchar](10 ) NULL CONSTRAINT [DF_Company_CurrencySymbol] DEFAULT ( '$'),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED 
(
	[CompanyID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
CompanyID CompanyID [int] NOT NULL  
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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_Company] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Custo__5812160E] DEFAULT (),
	[No] [int] NOT NULL CONSTRAINT [DF__TemporaryUps__No__59063A47] DEFAULT (),
	[Item] [varchar](50 ) NOT NULL CONSTRAINT [DF__TemporaryU__Item__59FA5E80] DEFAULT (),
	[Description] [varchar](50 ) NULL ,
	[Quantity] [float] NULL CONSTRAINT [DF__Temporary__Quant__5AEE82B9] DEFAULT (),
	[Rate] [money] NULL CONSTRAINT [DF__TemporaryU__Rate__5BE2A6F2] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__5CD6CB2B] DEFAULT (),
	[Tax] [bit] NOT NULL CONSTRAINT [DF__TemporaryUp__Tax__5DCAEF64] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csCustomerCreditItems] PRIMARY KEY NONCLUSTERED 
(
	[CustomerCreditNo] ASC ,
	[No] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csCustomerCreditItems] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csCustomerCreditItems_lsItems EY([Item] [dbo].[lsItems] EY([Item]

Storage
STORAGE OPTION STORAGE VALUE
   


csCustomerCredits
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csCustomerCredits](
	[Customer] [varchar](50 ) NOT NULL CONSTRAINT [DF__Temporary__Custo__08EA5793] DEFAULT (),
	[Class] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Class__09DE7BCC] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[BillTo] [nvarchar](100 ) NULL ,
	[Date] [datetime] NULL ,
	[CreditNumber] [nvarchar](20 ) NOT NULL ,
	[POID] [nvarchar](20 ) NULL ,
	[CustomerMessage] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__0DAF0CB0] DEFAULT (),
	[Discount] [float] NULL CONSTRAINT [DF_csCustomerCredits_Discount] DEFAULT (),
	[Handling] [money] NULL CONSTRAINT [DF_csCustomerCredits_Handling] DEFAULT (),
	[Freight] [money] NULL ,
	[SalesTax] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__TaxAg__0EA330E9] DEFAULT (),
	[Tax] [money] NULL CONSTRAINT [DF__TemporaryU__Tax%__0F975522] DEFAULT (),
	[TaxTotal] [money] NULL CONSTRAINT [DF__Temporary__TaxTo__108B795B] DEFAULT (),
	[Total] [money] NULL CONSTRAINT [DF__Temporary__Total__117F9D94] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_csCustomerCredits_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csCustomerCredits] PRIMARY KEY NONCLUSTERED 
(
	[CreditNumber] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csCustomerCredits] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csCustomerCredits_lsCustomers EY([Customer] [dbo].[lsCustomers] EY([Customer]

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 CONSTRAINT [DF_csCustomerPaymentDetails_ToPay_1] DEFAULT (),
	[textboxAmount] [money] NULL CONSTRAINT [DF_csCustomerPaymentDetails_textboxAmount] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csCustomerPaymentDetails] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC ,
	[FID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csCustomerPaymentDetails] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Custo__32AB8735] DEFAULT (),
	[PaymentAmount] [money] NULL CONSTRAINT [DF__Temporary__Payme__339FAB6E] DEFAULT (),
	[Date] [datetime] NULL ,
	[PaymentMethod] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Payme__3493CFA7] DEFAULT (),
	[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 CONSTRAINT [DF__Temporary__CardA__3587F3E0] DEFAULT (),
	[UndepFunds] [bit] NOT NULL CONSTRAINT [DF__Temporary__Undep__367C1819] DEFAULT (),
	[DepositTo] [bit] NOT NULL CONSTRAINT [DF__Temporary__Depos__37703C52] DEFAULT (),
	[Account] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Accou__3864608B] DEFAULT (),
	[ApplyExistingCredits] [bit] NOT NULL CONSTRAINT [DF__Temporary__Apply__395884C4] DEFAULT (),
	[Apply] [money] NULL CONSTRAINT [DF_csCustomerPayments_Apply] DEFAULT (),
	[TotalToApply] [money] NULL CONSTRAINT [DF__Temporary__Total__3A4CA8FD] DEFAULT (),
	[TotalApplied] [money] NULL CONSTRAINT [DF__Temporary__Total__3B40CD36] DEFAULT (),
	[UnappliedAmount] [money] NULL CONSTRAINT [DF__Temporary__Unapp__3C34F16F] DEFAULT (),
	[Deposit] [bit] NOT NULL CONSTRAINT [DF__Temporary__Depos__3D2915A8] DEFAULT (),
	[PayAmount] [money] NULL CONSTRAINT [DF_csCustomerPayments_PayAmount_1] DEFAULT (),
	[ReceivedYN] [bit] NOT NULL CONSTRAINT [DF_csCustomerPayments_ReceivedYN_1] DEFAULT (),
	[ClearedYN] [bit] NOT NULL CONSTRAINT [DF_csCustomerPayments_ClearedYN] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_csCustomerPayments_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csCustomerPayments] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csCustomerPayments] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csCustomerPayments_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]
FK_csCustomerPayments_lsCustomers EY([Customer] [dbo].[lsCustomers] EY([Customer]

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 CONSTRAINT [DF__Temporary__Quant__4222D4EF] DEFAULT (),
	[Rate] [money] NULL CONSTRAINT [DF__TemporaryU__Rate__4316F928] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__440B1D61] DEFAULT (),
	[ItemWeight] [float] NULL CONSTRAINT [DF_csInvoiceItems_ItemWeight] DEFAULT (),
	[Shipped] [bit] NOT NULL CONSTRAINT [DF_csInvoiceItems_Shipped] DEFAULT (),
	[ShippedDate] [smalldatetime] NULL ,
	[TrackingNumber] [varchar](50 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csInvoiceItems] PRIMARY KEY NONCLUSTERED 
(
	[InvoiceNo] ASC ,
	[No] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csInvoiceItems] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csInvoiceItems_lsItems EY([Item] [dbo].[lsItems] EY([Item]

Storage
STORAGE OPTION STORAGE VALUE
   


csInvoices
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csInvoices](
	[Date] [datetime] NULL ,
	[Customer] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__47DBAE45] DEFAULT (),
	[ShipToID] [varchar](50 ) NULL ,
	[Class] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Class__48CFD27E] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[Term] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Terms__4BAC3F29] DEFAULT (),
	[InvoiceNo] [nvarchar](20 ) NOT NULL ,
	[DueDate] [datetime] NULL ,
	[ShipVia] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__ShipV__4CA06362] DEFAULT (),
	[ShipDate] [datetime] NULL ,
	[POID] [nvarchar](20 ) NULL ,
	[CustomerMessage] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__4E88ABD4] DEFAULT (),
	[TrackingNumber] [varchar](30 ) NULL ,
	[Handling] [money] NULL CONSTRAINT [DF_csInvoices_Handling] DEFAULT (),
	[Freight] [money] NULL ,
	[Discount] [float] NULL CONSTRAINT [DF_csInvoices_Discount] DEFAULT (),
	[SalesTax] [varchar](10 ) NULL ,
	[Tax] [money] NULL CONSTRAINT [DF__TemporaryU__Tax%__5070F446] DEFAULT (),
	[TaxTotal] [money] NULL CONSTRAINT [DF__Temporary__TaxTo__5165187F] DEFAULT (),
	[Total] [money] NULL CONSTRAINT [DF__Temporary__Total__52593CB8] DEFAULT (),
	[TotalWeight] [float] NULL CONSTRAINT [DF_csInvoices_TotalWeight] DEFAULT (),
	[ShippingCharge] [money] NULL CONSTRAINT [DF_csInvoices_ShippingCharge] DEFAULT (),
	[ApplyYN] [bit] NOT NULL CONSTRAINT [DF__Temporary__Apply__534D60F1] DEFAULT (),
	[PaidYN] [bit] NULL CONSTRAINT [DF_csInvoices_PaidYN] DEFAULT (),
	[PayAmount] [money] NULL CONSTRAINT [DF_csInvoices_PayAmount] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_csInvoices_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csInvoices] PRIMARY KEY NONCLUSTERED 
(
	[InvoiceNo] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csInvoices] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csInvoices_lsCustomers EY([Customer] [dbo].[lsCustomers] EY([Customer]
FK_csInvoices_lsShippingMethods EY([ShipVia] [dbo].[lsShippingMethods] EY([ShipVia]
FK_csInvoices_lsTerms EY([Term] [dbo].[lsTerms] EY([Term]
FK_csInvoices_lsTerms1 EY([Term] [dbo].[lsTerms] EY([Term]

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 CONSTRAINT [DF_csOrderItems_Item] DEFAULT (),
	[Description] [varchar](255 ) NULL ,
	[Quantity] [float] NULL CONSTRAINT [DF_csOrderItems_Quantity] DEFAULT (),
	[Ship] [float] NULL ,
	[Rate] [money] NULL CONSTRAINT [DF_csOrderItems_Rate] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF_csOrderItems_Amount] DEFAULT (),
	[ItemWeight] [float] NULL CONSTRAINT [DF_csOrderItems_ItemWeight] DEFAULT (),
	[ShipDate] [datetime] NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csOrderItems] PRIMARY KEY NONCLUSTERED 
(
	[OrderNo] ASC ,
	[No] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csOrderItems] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csOrderItems_lsItems EY([Item] [dbo].[lsItems] EY([Item]

Storage
STORAGE OPTION STORAGE VALUE
   


csOrders
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[csOrders](
	[Date] [datetime] NULL ,
	[Customer] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Customer] DEFAULT (),
	[ShipToID] [varchar](50 ) NULL ,
	[Class] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Class] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[Term] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Term] DEFAULT (),
	[OrderNo] [varchar](50 ) NOT NULL ,
	[DueDate] [datetime] NULL ,
	[ShipVia] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_ShipVia] DEFAULT (),
	[ShipDate] [datetime] NULL ,
	[POID] [varchar](50 ) NULL ,
	[CustomerMessage] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_CustomerMessage] DEFAULT (),
	[Discount] [float] NULL CONSTRAINT [DF_csOrders_Discount] DEFAULT (),
	[Freight] [money] NULL CONSTRAINT [DF_csOrders_Freight] DEFAULT (),
	[SalesTax] [varchar](50 ) NULL ,
	[Tax] [money] NULL CONSTRAINT [DF_csOrders_Tax] DEFAULT (),
	[TaxTotal] [money] NULL CONSTRAINT [DF_csOrders_TaxTotal] DEFAULT (),
	[Total] [money] NULL CONSTRAINT [DF_csOrders_Total] DEFAULT (),
	[TotalWeight] [float] NULL CONSTRAINT [DF_csOrders_TotalWeight] DEFAULT (),
	[ShippingCharge] [money] NULL CONSTRAINT [DF_csOrders_ShippingCharge] DEFAULT (),
	[Handling] [money] NULL CONSTRAINT [DF_csOrders_Handling] DEFAULT (),
	[ApplyYN] [bit] NOT NULL CONSTRAINT [DF_csOrders_ApplyYN] DEFAULT (),
	[Picked] [bit] NOT NULL CONSTRAINT [DF_csOrders_Picked] DEFAULT (),
	[Billed] [bit] NOT NULL CONSTRAINT [DF_csOrders_Billed] DEFAULT (),
	[Printed] [bit] NOT NULL CONSTRAINT [DF_csOrders_Printed] DEFAULT (),
	[Shipped] [bit] NOT NULL CONSTRAINT [DF_csOrders_Shipped] DEFAULT (),
	[Backordered] [bit] NOT NULL CONSTRAINT [DF_csOrders_Backordered] DEFAULT (),
	[Invoiced] [bit] NOT NULL CONSTRAINT [DF_csOrders_Invoiced] DEFAULT (),
	[TrackingNumber] [varchar](30 ) NULL ,
	[CCType] [varchar](50 ) NULL ,
	[CCName] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_CCName] DEFAULT ( ''),
	[CCNumber] [varchar](20 ) NULL CONSTRAINT [DF_csOrders_CCNumber] DEFAULT ( ''),
	[CCExpDate] [datetime] NULL ,
	[ApprovalNumber] [varchar](12 ) NULL CONSTRAINT [DF_csOrders_ApprovalNumber] DEFAULT ( ''),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_csOrders_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csOrders] PRIMARY KEY NONCLUSTERED 
(
	[OrderNo] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_csOrders] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_csOrders_lsCustomers EY([Customer] [dbo].[lsCustomers] EY([Customer]
FK_csOrders_lsShippingMethods EY([ShipVia] [dbo].[lsShippingMethods] EY([ShipVia]
FK_csOrders_lsTerms EY([Term] [dbo].[lsTerms] EY([Term]

Storage
STORAGE OPTION STORAGE VALUE
   


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

Columns
ColumnName Domain Datatype NULL Definition
OrderNo OrderNo [varchar](50) NULL  
InvoiceNo InvoiceNo [varchar](50) NULL  
EditStamp EditStamp [timestamp] NOT 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](
	[CompanyID] [int] NOT NULL ,
	[CheckNo] [int] NOT NULL CONSTRAINT [DF_DocNumbers_CheckNo] DEFAULT ((1000 )),
	[Vouchers] [int] NOT NULL CONSTRAINT [DF_DocNumbers_Vouchers] DEFAULT ((1000 )),
	[Orders] [int] NOT NULL CONSTRAINT [DF_DocNumbers_Orders] DEFAULT ((1000 )),
	[BillPmt] [int] NOT NULL CONSTRAINT [DF_DocNumbers_BillPmt] DEFAULT ((1000 )),
	[Invoices] [int] NOT NULL CONSTRAINT [DF_DocNumbers_Invoices] DEFAULT ((1000 )),
	[CustCredits] [int] NOT NULL CONSTRAINT [DF_DocNumbers_CustCredits] DEFAULT ((1000 )),
	[CustPmt] [int] NOT NULL CONSTRAINT [DF_DocNumbers_CustPmt] DEFAULT ((1000 )),
	[Adjustment] [int] NOT NULL CONSTRAINT [DF_DocNumbers_Adjustment] DEFAULT ((1000 )),
	[TimeTracking] [int] NOT NULL CONSTRAINT [DF_DocNumbers_TimeTracking] DEFAULT ((1000 )),
	[Transfers] [int] NOT NULL CONSTRAINT [DF_DocNumbers_Transfers] DEFAULT ((1000 )),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_DocNumbers] PRIMARY KEY CLUSTERED 
(
	[CompanyID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
CompanyID CompanyID [int] NOT NULL  
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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_DocNumbers] NOT NULL  

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

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 (,) NOT NULL ,
	[CheckNo] [int] NULL ,
	[Account] [varchar](50 ) NULL ,
	[Payee] [varchar](50 ) NULL ,
	[Amount] [money] NULL ,
	[Address] [varchar](255 ) NULL ,
	[Date] [datetime] NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_EmpChecks] PRIMARY KEY NONCLUSTERED 
(
	[CheckID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_EmpChecks] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_EmpChecks_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]

Storage
STORAGE OPTION STORAGE VALUE
   


GeneralJournalDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[GeneralJournalDetail](
	[EntryNo] [varchar](50 ) NOT NULL CONSTRAINT [DF__Temporary__Gener__37A5467C] DEFAULT (),
	[No] [int] NOT NULL CONSTRAINT [DF__TemporaryUps__No__38996AB5] DEFAULT (),
	[Account] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Accou__398D8EEE] DEFAULT (),
	[Debit] [money] NULL CONSTRAINT [DF__Temporary__Debit__3A81B327] DEFAULT (),
	[Credit] [money] NULL CONSTRAINT [DF__Temporary__Credi__3B75D760] DEFAULT (),
	[Memo] [varchar](50 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_GeneralJournalDetail] PRIMARY KEY NONCLUSTERED 
(
	[EntryNo] ASC ,
	[No] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_GeneralJournalDetail] NOT NULL  

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

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 CONSTRAINT [DF_GeneralJournalEntry_SystemGenerated] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_GeneralJournalEntry_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_GeneralJournalEntry] PRIMARY KEY NONCLUSTERED 
(
	[EntryNo] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_GeneralJournalEntry] NOT NULL  

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

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 ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_GLWorkDetail] PRIMARY KEY NONCLUSTERED 
(
	[GLID] ASC ,
	[No] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_GLWorkDetail] NOT NULL  

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

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 ) NOT NULL ,
	[Item] [varchar](50 ) NOT NULL ,
	[Description] [nvarchar](50 ) NULL ,
	[CurrentQty] [float] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_CurrentQty] DEFAULT (()),
	[CurrentValue] [money] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_CurrentValue] DEFAULT (()),
	[NewQty] [float] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_NewQty] DEFAULT (()),
	[NewValue] [money] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_NewValue] DEFAULT (()),
	[QtyDifference] [float] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_QtyDifference] DEFAULT (()),
	[ValueDifference] [money] NULL CONSTRAINT [DF_InventoryAdjustmentDetail_ValueDifference] DEFAULT (()),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_InventoryAdjustmentDetail] PRIMARY KEY CLUSTERED 
(
	[RefNo] ASC ,
	[Item] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
RefNo RefNo [varchar](50) NOT NULL  
Item Item [varchar](50) NOT 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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_InventoryAdjustmentDetail] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_InventoryAdjustmentDetail_lsItems EY([Item] [dbo].[lsItems] EY([Item]

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 CONSTRAINT [DF__Temporary__Adjus__31EC6D26] DEFAULT (),
	[Customer] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__32E0915F] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[TotalValue] [money] NULL CONSTRAINT [DF__Temporary__Total__33D4B598] DEFAULT (),
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_InventoryAdjustments_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [aaaaaInventoryAdjustment_PK] PRIMARY KEY NONCLUSTERED 
(
	[RefNo] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [aaaaaInventoryAdjustment_PK] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_InventoryAdjustments_lsAccounts EY([AdjustmentAccount] [dbo].[lsAccounts] EY([AdjustmentAccount]

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 CONSTRAINT [DF__Temporary__Accou__2B3F6F97] DEFAULT (),
	[Subaccount] [bit] NOT NULL CONSTRAINT [DF__Temporary__Subac__2C3393D0] DEFAULT (),
	[AccountName1] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Accou__2D27B809] DEFAULT (),
	[Description] [varchar](50 ) NULL ,
	[OpeningBalance] [money] NULL CONSTRAINT [DF__Temporary__Openi__2E1BDC42] DEFAULT (),
	[Date] [datetime] NULL ,
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__2F10007B] DEFAULT (),
	[Balance] [money] NULL CONSTRAINT [DF_lsAccounts_Balance] DEFAULT (),
	[BalanceType] [smallint] NULL CONSTRAINT [DF_lsAccounts_D/C] DEFAULT (),
	[Modified] [smallint] NULL CONSTRAINT [DF_lsAccounts_Modified] DEFAULT (),
	[OpBalID] [int] IDENTITY (,) NOT NULL ,
	[IsDefault] [bit] NOT NULL CONSTRAINT [DF_lsAccounts_IsDefault] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsAccounts] PRIMARY KEY NONCLUSTERED 
(
	[AccountName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsAccounts] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsAccounts_lsAccountTypes EY([AccountType] [dbo].[lsAccountTypes] EY([AccountType]

Storage
STORAGE OPTION STORAGE VALUE
   


lsAccountTypes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsAccountTypes](
	[Description] [varchar](50 ) NOT NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [aaaaalsAccountType_PK] PRIMARY KEY NONCLUSTERED 
(
	[Description] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
Description Description [varchar](50) NOT NULL  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [aaaaalsAccountType_PK] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Subcl__24927208] DEFAULT (),
	[ClassName1] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Class__25869641] DEFAULT (),
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__267ABA7A] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsClasses] PRIMARY KEY NONCLUSTERED 
(
	[ClassName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsClasses] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Inact__12FDD1B2] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsCustomerMessages] PRIMARY KEY NONCLUSTERED 
(
	[CustomerMessage] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF__Temporary__Credi__1DE57479] DEFAULT (),
	[Taxable] [bit] NOT NULL CONSTRAINT [DF__Temporary__Taxab__1ED998B2] DEFAULT (),
	[TaxItem] [varchar](50 ) NULL ,
	[ResaleNumber] [varchar](50 ) NULL ,
	[OpeningBalance] [money] NULL CONSTRAINT [DF__Temporary__Openi__20C1E124] DEFAULT (),
	[OpeningBalanceDate] [datetime] NULL CONSTRAINT [DF_lsCustomers_OpeningBalanceDate] DEFAULT (/ 1 / 2000 ),
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__21B6055D] DEFAULT (),
	[PasswordCA] [varchar](50 ) NULL ,
	[Balance] [money] NULL CONSTRAINT [DF_lsCustomers_Balance] DEFAULT (),
	[ExistingCredit] [money] NULL CONSTRAINT [DF_lsCustomers_ExistingCredit] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsCustomers] PRIMARY KEY NONCLUSTERED 
(
	[CustomerName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsCustomers] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsCustomers_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]
FK_lsCustomers_lsAccounts1 EY([Account] [dbo].[lsAccounts] EY([Account]
FK_lsCustomers_lsEmployees EY([Rep] [dbo].[lsEmployees] EY([Rep]
FK_lsCustomers_lsTerms EY([Term] [dbo].[lsTerms] EY([Term]

Storage
STORAGE OPTION STORAGE VALUE
   


lsCustomersShipTo
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsCustomersShipTo](
	[CustomerName] [varchar](50 ) NOT NULL ,
	[ShipingAddressID] [int] NOT NULL ,
	[ShippingAddress] [varchar](50 ) NULL ,
	[City] [varchar](50 ) NULL ,
	[State] [varchar](10 ) NULL ,
	[Zip] [varchar](10 ) NULL ,
	[Country] [varchar](50 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsCustomersShipTo] PRIMARY KEY CLUSTERED 
(
	[CustomerName] ASC ,
	[ShipingAddressID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
CustomerName CustomerName [varchar](50) NOT NULL  
ShipingAddressID ShipingAddressID [int] NOT 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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsCustomersShipTo] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Inact__5629CD9C] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsCustomerTypes] PRIMARY KEY NONCLUSTERED 
(
	[CustomerType] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF__Temporary__Inact__60A75C0F] DEFAULT (),
	[PasswordTTA] [nvarchar](20 ) NULL ,
	[YN1099] [bit] NOT NULL CONSTRAINT [DF_lsEmployees_1099YN] DEFAULT (),
	[CommissionYN] [bit] NOT NULL CONSTRAINT [DF_lsEmployees_CommissionYN] DEFAULT (),
	[CommissionRate] [float] NULL ,
	[Commission] [money] NULL CONSTRAINT [DF_lsEmployees_Commission] DEFAULT (),
	[Refferal] [int] NULL CONSTRAINT [DF_lsEmployees_Refferal] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsEmployees] PRIMARY KEY NONCLUSTERED 
(
	[EmployeeName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsEmployees] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsEmployees_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]

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 ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsItemCategories] PRIMARY KEY NONCLUSTERED 
(
	[CategoryID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsItemCategories] NOT NULL  

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

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 ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsItemFamilies] PRIMARY KEY NONCLUSTERED 
(
	[FamilyID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


lsItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsItems](
	[ItemName] [varchar](50 ) NOT NULL ,
	[ItemName1] [varchar](50 ) NULL ,
	[ItemType] [int] NULL ,
	[Subitem] [bit] NOT NULL CONSTRAINT [DF__Temporary__Subit__43A1090D] DEFAULT (()),
	[CategoryID] [varchar](50 ) NULL ,
	[PurchaseDescription] [varchar](50 ) NULL ,
	[Cost] [money] NULL CONSTRAINT [DF__TemporaryU__Cost__4589517F] DEFAULT (()),
	[COGSAccount] [varchar](50 ) NULL ,
	[PrefferedVendor] [varchar](50 ) NULL ,
	[SalesDescription] [varchar](50 ) NULL ,
	[IncomeAccount] [varchar](50 ) NULL ,
	[SalesPrice] [money] NULL CONSTRAINT [DF__Temporary__Sales__4865BE2A] DEFAULT (()),
	[Taxable] [bit] NOT NULL CONSTRAINT [DF__Temporary__Taxab__4959E263] DEFAULT (()),
	[AssetAccount] [varchar](50 ) NULL ,
	[QuantityOnHand] [int] NULL CONSTRAINT [DF__Temporary__Quant__4B422AD5] DEFAULT (()),
	[TotalValue] [float] NULL CONSTRAINT [DF__Temporary__Total__4C364F0E] DEFAULT (()),
	[ReorderPoint] [int] NULL CONSTRAINT [DF__Temporary__Reord__4D2A7347] DEFAULT (()),
	[ItemWeight] [float] NULL CONSTRAINT [DF_lsItems_ItemWeight] DEFAULT (()),
	[PictureURL] [varchar](50 ) NULL ,
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__4E1E9780] DEFAULT (()),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsItems] PRIMARY KEY NONCLUSTERED 
(
	[ItemName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
ItemName ItemName [varchar](50) NOT NULL  
ItemName1 ItemName1 [varchar](50) NULL  
ItemType ItemType [int] NULL  
Subitem Subitem [bit] NOT NULL  
CategoryID CategoryID [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  
PictureURL PictureURL [varchar](50) NULL  
Inactive Inactive [bit] NOT NULL  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsItems] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsItems_lsAccounts EY([COGSAccount] [dbo].[lsAccounts] EY([COGSAccount]
FK_lsItems_lsAccounts1 EY([IncomeAccount] [dbo].[lsAccounts] EY([IncomeAccount]
FK_lsItems_lsAccounts2 EY([AssetAccount] [dbo].[lsAccounts] EY([AssetAccount]

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 ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsMemorized] PRIMARY KEY NONCLUSTERED 
(
	[Name] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF__Temporary__Exter__15DA3E5D] DEFAULT (),
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__16CE6296] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsPaymentMethods] PRIMARY KEY NONCLUSTERED 
(
	[PaymentMethod] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF_Projects_Inactive] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsProjects] PRIMARY KEY NONCLUSTERED 
(
	[ProjectName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsProjects] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsProjects_lsCustomers EY([Customer] [dbo].[lsCustomers] EY([Customer]
FK_lsProjects_lsEmployees EY([ProjectManager] [dbo].[lsEmployees] EY([ProjectManager]

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 CONSTRAINT [DF__Temporary__Inact__6D9742D9] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsShippingMethods] PRIMARY KEY NONCLUSTERED 
(
	[ShippingMethod] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF_lsTaxes_Inactive] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsTaxes] PRIMARY KEY NONCLUSTERED 
(
	[TaxID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsTaxes] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsTaxes_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]

Storage
STORAGE OPTION STORAGE VALUE
   


lsTaxGroupDetail
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsTaxGroupDetail](
	[GrpID] [varchar](10 ) NOT NULL ,
	[TaxID] [varchar](10 ) NOT NULL ,
	[Description] [varchar](50 ) NULL ,
	[Account] [varchar](50 ) NULL ,
	[TaxPercent] [float] NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsTaxGroupDetail] PRIMARY KEY CLUSTERED 
(
	[GrpID] ASC ,
	[TaxID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
GrpID GrpID [varchar](10) NOT NULL  
TaxID TaxID [varchar](10) NOT NULL  
Description Description [varchar](50) NULL  
Account Account [varchar](50) NULL  
TaxPercent TaxPercent [float] NULL  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsTaxGroupDetail] NOT NULL  

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

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 CONSTRAINT [DF_lsTaxGroups_Inactive] DEFAULT (),
	[IsDefault] [bit] NOT NULL CONSTRAINT [DF_lsTaxGroups_IsDefault] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsTaxGroups] PRIMARY KEY NONCLUSTERED 
(
	[TaxGroupID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsTaxGroups] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Stand__078C1F06] DEFAULT (),
	[DayTillNetDue] [smallint] NULL CONSTRAINT [DF__Temporary__DayTi__0880433F] DEFAULT (),
	[Discount] [float] NULL CONSTRAINT [DF__Temporary__Disco__09746778] DEFAULT (),
	[DaysTillDiscountExpires] [smallint] NULL CONSTRAINT [DF__Temporary__DaysT__0A688BB1] DEFAULT (),
	[DayOfMonthNetDue] [smallint] NULL CONSTRAINT [DF__Temporary__DayOf__0C50D423] DEFAULT (),
	[DueNextMonthIfWithinDays] [smallint] NULL CONSTRAINT [DF__Temporary__DueNe__0D44F85C] DEFAULT (),
	[Discount1] [float] NULL CONSTRAINT [DF__Temporary__Disco__0E391C95] DEFAULT (),
	[DayDiscountExpires] [smallint] NULL CONSTRAINT [DF__Temporary__DayDi__0F2D40CE] DEFAULT (),
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__10216507] DEFAULT (),
	[upsize_ts] [timestamp] NULL ,
CONSTRAINT [PK_lsTerms] PRIMARY KEY NONCLUSTERED 
(
	[Term] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
CONSTRAINT CONSTRAINT [PK_lsTerms] NOT NULL  

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

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 CONSTRAINT [DF__Temporary__Defau__7EF6D905] DEFAULT (),
	[VendorType] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Vendo__7FEAFD3E] DEFAULT (),
	[Term] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Terms__00DF2177] DEFAULT (),
	[PMID] [int] IDENTITY (,) NOT NULL ,
	[CreditLimit] [money] NULL CONSTRAINT [DF__Temporary__Credi__01D345B0] DEFAULT (),
	[TaxID] [varchar](20 ) NULL ,
	[Eligible] [bit] NOT NULL CONSTRAINT [DF__Temporary__1099E__02C769E9] DEFAULT (),
	[Email] [varchar](30 ) NULL ,
	[OpeningBalance] [money] NULL CONSTRAINT [DF__Temporary__Openi__03BB8E22] DEFAULT (),
	[OpeningBalanceDate] [datetime] NULL ,
	[Balance] [money] NULL CONSTRAINT [DF_lsVendors_Balance] DEFAULT (),
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__04AFB25B] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsVendors] PRIMARY KEY NONCLUSTERED 
(
	[VendorName] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_lsVendors] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_lsVendors_lsAccounts EY([DefaultExpenseAccount] [dbo].[lsAccounts] EY([DefaultExpenseAccount]

Storage
STORAGE OPTION STORAGE VALUE
   


lsVendorTypes
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[lsVendorTypes](
	[VendorType] [nvarchar](30 ) NOT NULL ,
	[Inactive] [bit] NOT NULL CONSTRAINT [DF__Temporary__Inact__7C1A6C5A] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_lsVendorTypes] PRIMARY KEY NONCLUSTERED 
(
	[VendorType] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


Months
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Months](
	[MonthID] [int] NOT NULL ,
	[Name] [nvarchar](20 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_Months] PRIMARY KEY CLUSTERED 
(
	[MonthID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
MonthID MonthID [int] NOT NULL  
Name Name [nvarchar](20) NULL  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_Months] NOT NULL  

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

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 CONSTRAINT [DF_OpBalWork_AccountID] DEFAULT (),
	[AccBalType] [int] NULL CONSTRAINT [DF_OpBalWork_AccBalType] DEFAULT (),
	[OpeningBalance] [float] NULL CONSTRAINT [DF_OpBalWork_OpeningBalance] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL 
) ON [PRIMARY]
END 

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

Primary and Unique Keys
Key Name Key Type Keys

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 CONSTRAINT [DF__Temporary__Emplo__74794A92] DEFAULT (),
	[Date] [datetime] NULL ,
	[Customer] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__756D6ECB] DEFAULT (),
	[ServiceItem] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Servi__7755B73D] DEFAULT (),
	[Class] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Class__7849DB76] DEFAULT (),
	[Duration] [float] NULL CONSTRAINT [DF__Temporary__Durat__793DFFAF] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [aaaaaTimeTracking_PK] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [aaaaaTimeTracking_PK] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_TimeTracking_lsEmployees EY([Employee] [dbo].[lsEmployees] EY([Employee]

Storage
STORAGE OPTION STORAGE VALUE
   


Users
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[Users](
	[LoginID] [nchar](10 ) NULL ,
	[Username] [varchar](20 ) NOT NULL ,
	[Password] [varchar](20 ) NULL CONSTRAINT [DF_Users_Password] DEFAULT ( ''),
	[GroupLevel] [nchar](10 ) NULL ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_Users] PRIMARY KEY NONCLUSTERED 
(
	[Username] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
LoginID LoginID [nchar](10) NULL  
Username Username [varchar](20) NOT NULL  
Password Password [varchar](20) NULL  
GroupLevel GroupLevel [nchar](10) NULL  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_Users] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field

Storage
STORAGE OPTION STORAGE VALUE
   


vpBillExpenses
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillExpenses](
	[BillID] [int] NOT NULL ,
	[Reference] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Bill#__634EBE90] DEFAULT (()),
	[No] [int] NULL CONSTRAINT [DF__TemporaryUps__No__6442E2C9] DEFAULT (()),
	[Account] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Accou__65370702] DEFAULT (()),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__662B2B3B] DEFAULT (()),
	[Memo] [varchar](50 ) NULL ,
	[Project] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__681373AD] DEFAULT (()),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpBillExpenses] PRIMARY KEY CLUSTERED 
(
	[BillID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
BillID BillID [int] NOT NULL  
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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_vpBillExpenses] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpBillExpenses_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]
FK_vpBillExpenses_lsAccounts1 EY([Account] [dbo].[lsAccounts] EY([Account]

Storage
STORAGE OPTION STORAGE VALUE
   


vpBillItems
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBillItems](
	[BillID] [varchar](50 ) NOT NULL CONSTRAINT [DF__Temporary__Bill#__59C55456] DEFAULT (()),
	[No] [int] NULL CONSTRAINT [DF__TemporaryUps__No__5AB9788F] DEFAULT (()),
	[Item] [varchar](50 ) NULL CONSTRAINT [DF__TemporaryU__Item__5BAD9CC8] DEFAULT (()),
	[Description] [nvarchar](50 ) NULL ,
	[Quantity] [float] NULL CONSTRAINT [DF__Temporary__Quant__5CA1C101] DEFAULT (()),
	[Rate] [money] NULL CONSTRAINT [DF__TemporaryU__Rate__5D95E53A] DEFAULT (()),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__5E8A0973] DEFAULT (()),
	[Project] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__607251E5] DEFAULT (()),
	[Billable] [bit] NOT NULL CONSTRAINT [DF__Temporary__Billa__6166761E] DEFAULT (()),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpBillItems] PRIMARY KEY CLUSTERED 
(
	[BillID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

Columns
ColumnName Domain Datatype NULL Definition
BillID BillID [varchar](50) NOT 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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_vpBillItems] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpBillItems_lsItems EY([Item] [dbo].[lsItems] EY([Item]

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 ,
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpBillPaymentDetails] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC ,
	[FID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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

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

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 CONSTRAINT [DF__Temporary__Accou__55009F39] DEFAULT (),
	[ToBePrinted] [bit] NOT NULL CONSTRAINT [DF__Temporary__ToBeP__55F4C372] DEFAULT (),
	[Vendor] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Vendo__56E8E7AB] DEFAULT (),
	[Date] [datetime] NULL ,
	[CheckNo] [nvarchar](20 ) NULL ,
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__57DD0BE4] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[ClearedYN] [bit] NOT NULL CONSTRAINT [DF_vpBillPayments_ClearedYN] DEFAULT (),
	[LastCheckNo] [int] NULL CONSTRAINT [DF_vpBillPayments_LastCheckNo] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [aaaaavpBillPayment_PK] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [aaaaavpBillPayment_PK] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpBillPayments_lsAccounts EY([Account] [dbo].[lsAccounts] EY([Account]
FK_vpBillPayments_lsAccounts1 EY([Account] [dbo].[lsAccounts] EY([Account]
FK_vpBillPayments_lsVendors EY([Vendor] [dbo].[lsVendors] EY([Vendor]

Storage
STORAGE OPTION STORAGE VALUE
   


vpBills
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpBills](
	[Date] [datetime] NULL ,
	[Vendor] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Vendo__6EC0713C] DEFAULT (),
	[Reference] [varchar](20 ) NOT NULL ,
	[Type] [varchar](20 ) NULL ,
	[Term] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Terms__6FB49575] DEFAULT (),
	[DueDate] [datetime] NULL ,
	[VendorInvoice] [nvarchar](20 ) NULL ,
	[Freight] [money] NULL CONSTRAINT [DF_vpBills_Freight] DEFAULT (),
	[Discount] [money] NULL CONSTRAINT [DF_vpBills_Discount] DEFAULT (),
	[OtherCharges] [money] NULL CONSTRAINT [DF_vpBills_OtherCharges] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__70A8B9AE] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[PayAmount] [money] NULL CONSTRAINT [DF_vpBills_PayAmount] DEFAULT (),
	[DueAmount] [money] NULL ,
	[PORef] [varchar](50 ) NULL ,
	[PmtID] [int] IDENTITY (,) NOT NULL ,
	[PayYN] [bit] NOT NULL CONSTRAINT [DF__Temporary__PayYN__719CDDE7] DEFAULT (),
	[CheckID] [int] NULL ,
	[PostedYN] [bit] NOT NULL CONSTRAINT [DF_vpBills_PostedYN] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpBills] PRIMARY KEY NONCLUSTERED 
(
	[Reference] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_vpBills] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpBills_lsVendors EY([Vendor] [dbo].[lsVendors] EY([Vendor]

Storage
STORAGE OPTION STORAGE VALUE
   


vpPurchaseOrderDetails
Definition  
Note  
DDL Code
CREATE TABLE [dbo].[vpPurchaseOrderDetails](
	[ID] [int] IDENTITY (,) NOT NULL ,
	[PORef] [varchar](50 ) NULL ,
	[No] [int] NULL CONSTRAINT [DF__TemporaryUps__No__42E1EEFE] DEFAULT (),
	[Item] [varchar](50 ) NULL CONSTRAINT [DF__TemporaryU__Item__43D61337] DEFAULT (),
	[Quantity] [float] NULL CONSTRAINT [DF__Temporary__Quant__44CA3770] DEFAULT (),
	[ReceivedQty] [float] NULL CONSTRAINT [DF_vpPurchaseOrderDetails_ReceivedQty] DEFAULT (),
	[Rate] [money] NULL CONSTRAINT [DF__TemporaryU__Rate__45BE5BA9] DEFAULT (),
	[Amount] [money] NULL CONSTRAINT [DF__Temporary__Amoun__46B27FE2] DEFAULT (),
	[Description] [nvarchar](255 ) NULL ,
	[Project] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Custo__47A6A41B] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpPurchaseOrderDetails] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_vpPurchaseOrderDetails] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpPurchaseOrderDetails_lsItems EY([Item] [dbo].[lsItems] EY([Item]

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 CONSTRAINT [DF__Temporary__Vendo__4B7734FF] DEFAULT (),
	[Class] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__Class__4C6B5938] DEFAULT (),
	[Memo] [nvarchar](50 ) NULL ,
	[BillTo] [varchar](50 ) NULL ,
	[ShipTo] [varchar](50 ) NULL ,
	[ReceiveBy] [datetime] NULL ,
	[VendorMessage] [varchar](50 ) NULL ,
	[ShipVia] [varchar](50 ) NULL CONSTRAINT [DF__Temporary__ShipV__503BEA1C] DEFAULT (),
	[TrackingNumber] [varchar](50 ) NULL ,
	[ShipToD] [nvarchar](100 ) NULL ,
	[VendorInvoice] [varchar](20 ) NULL ,
	[Freight] [money] NULL CONSTRAINT [DF_vpPurchaseOrders_Freight] DEFAULT (),
	[Discount] [float] NULL CONSTRAINT [DF_vpPurchaseOrders_Discount] DEFAULT (),
	[OtherCharges] [money] NULL CONSTRAINT [DF_vpPurchaseOrders_OtherCharges] DEFAULT (),
	[ShippingCharge] [money] NULL ,
	[Total] [money] NULL CONSTRAINT [DF__Temporary__Total__51300E55] DEFAULT (),
	[ReceivedYN] [bit] NOT NULL CONSTRAINT [DF__Temporary__Recei__5224328E] DEFAULT (),
	[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_vpPurchaseOrders] PRIMARY KEY NONCLUSTERED 
(
	[PORef] ASC 
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END 

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  
EditStamp EditStamp [timestamp] NOT NULL  
CONSTRAINT CONSTRAINT [PK_vpPurchaseOrders] NOT NULL  

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

Foreign Keys
Name Field Parent Table Parent Field
FK_vpPurchaseOrders_lsShippingMethods EY([ShipVia] [dbo].[lsShippingMethods] EY([ShipVia]
FK_vpPurchaseOrders_lsTerms EY([Term] [dbo].[lsTerms] EY([Term]
FK_vpPurchaseOrders_lsVendors EY([Vendor] [dbo].[lsVendors] EY([Vendor]

Storage
STORAGE OPTION STORAGE VALUE