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]
NOT NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsPaymentMethods
PRIMARY
[PaymentMethod]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsShippingMethods




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

ShippingMethod
ShippingMethod
[varchar](50)
NOT NULL
 


AccountNo
AccountNo
[varchar](50)
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsShippingMethods
PRIMARY
[ShippingMethod]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsTaxGroupDetail




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

GrpID
GrpID
[varchar](10)
NULL
 


TaxID
TaxID
[varchar](10)
NULL
 


Description
Description
[varchar](50)
NULL
 


Account
Account
[varchar](50)
NULL
 


TaxPercent
TaxPercent
[float]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsTaxGroups




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

TaxGroupID
TaxGroupID
[varchar](10)
NOT NULL
 


TaxGroupName
TaxGroupName
[varchar](50)
NULL
 


TotalPercent
TotalPercent
[float]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


IsDefault
IsDefault
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsTaxGroups
PRIMARY
[TaxGroupID]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsTerms




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Term
Term
[varchar](50)
NOT NULL
 


Standard
Standard
[bit]
NOT NULL
 


DayTillNetDue
DayTillNetDue
[smallint]
NULL
 


Discount
Discount
[float]
NULL
 


DaysTillDiscountExpires
DaysTillDiscountExpires
[smallint]
NULL
 


DayOfMonthNetDue
DayOfMonthNetDue
[smallint]
NULL
 


DueNextMonthIfWithinDays
DueNextMonthIfWithinDays
[smallint]
NULL
 


Discount1
Discount1
[float]
NULL
 


DayDiscountExpires
DayDiscountExpires
[smallint]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


upsize_ts
upsize_ts
[timestamp]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsTerms
PRIMARY
[Term]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsVendorTypes




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

VendorType
VendorType
[nvarchar](30)
NOT NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsVendorTypes
PRIMARY
[VendorType]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






Months




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

MonthID
MonthID
[int]
NULL
 


Name
Name
[nvarchar](20)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






OpBalWork




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

AccountID
AccountID
[varchar](50)
NULL
 


AccBalType
AccBalType
[int]
NULL
 


OpeningBalance
OpeningBalance
[float]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






Users




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Username
Username
[varchar](20)
NOT NULL
 


Password
Password
[varchar](20)
NULL
 


UserID
UserID
[varchar](20)
NULL
 


SecurityID
SecurityID
[varchar](1)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_Users
PRIMARY
[Username]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpBillPaymentDetails




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NOT NULL
 


FID
FID
[varchar](50)
NOT NULL
 


textboxAmount
textboxAmount
[money]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_vpBillPaymentDetails
PRIMARY
[Reference],  [FID]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsAccounts




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

AccountNumber
AccountNumber
[varchar](10)
NULL
 


AccountName
AccountName
[varchar](50)
NOT NULL
 


AccountType
AccountType
[varchar](50)
NULL
 


Subaccount
Subaccount
[bit]
NOT NULL
 


AccountName1
AccountName1
[varchar](50)
NULL
 


Description
Description
[varchar](50)
NULL
 


OpeningBalance
OpeningBalance
[money]
NULL
 


Date
Date
[datetime]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


Balance
Balance
[money]
NULL
 


BalanceType
BalanceType
[smallint]
NULL
 


Modified
Modified
[smallint]
NULL
 


OpBalID
OpBalID
[int]
NOT NULL
 


IsDefault
IsDefault
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsAccounts
PRIMARY
[AccountName]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






bChecks




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

CheckID
CheckID
[int]
NOT NULL
 


CheckNo
CheckNo
[varchar](50)
NOT NULL
 


Account
Account
[varchar](50)
NULL
 


Payee
Payee
[varchar](50)
NULL
 


Address
Address
[varchar](50)
NULL
 


Date
Date
[datetime]
NULL
 


Amount
Amount
[money]
NULL
 


Memo
Memo
[varchar](50)
NULL
 


GroupID
GroupID
[varchar](50)
NULL
 


ClearedYN
ClearedYN
[bit]
NOT NULL
 


VoidedYN
VoidedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_bChecks
PRIMARY
[CheckID]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






bTransferFunds




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NOT NULL
 


FromAccount
FromAccount
[varchar](50)
NULL
 


ToAccount
ToAccount
[varchar](50)
NULL
 


Date
Date
[datetime]
NULL
 


Amount
Amount
[money]
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


ClearedYN
ClearedYN
[bit]
NOT NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_bTransferFunds
PRIMARY
[Reference]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






EmpChecks




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

CheckID
CheckID
[int]
NOT NULL
 


CheckNo
CheckNo
[int]
NULL
 


Account
Account
[varchar](50)
NULL
 


Payee
Payee
[varchar](50)
NULL
 


Amount
Amount
[money]
NULL
 


Address
Address
[varchar](255)
NULL
 


Date
Date
[datetime]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_EmpChecks
PRIMARY
[CheckID]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






InventoryAdjustments




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Date
Date
[datetime]
NULL
 


RefNo
RefNo
[varchar](50)
NOT NULL
 


AdjustmentAccount
AdjustmentAccount
[varchar](50)
NULL
 


Customer
Customer
[varchar](50)
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


TotalValue
TotalValue
[money]
NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


aaaaaInventoryAdjustment_PK
PRIMARY
[RefNo]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsEmployees




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

EmployeeName
EmployeeName
[varchar](50)
NOT NULL
 


SalesmanID
SalesmanID
[varchar](10)
NULL
 


Initials
Initials
[nvarchar](30)
NULL
 


TaxID
TaxID
[nvarchar](20)
NULL
 


MrMs
MrMs
[nvarchar](10)
NULL
 


FirstName
FirstName
[nvarchar](20)
NULL
 


MiddleInitial
MiddleInitial
[nvarchar](10)
NULL
 


LastName
LastName
[nvarchar](20)
NULL
 


Address1
Address1
[nvarchar](50)
NULL
 


Address2
Address2
[nvarchar](50)
NULL
 


City
City
[nvarchar](50)
NULL
 


State
State
[nvarchar](10)
NULL
 


Zip
Zip
[nvarchar](10)
NULL
 


Country
Country
[nvarchar](50)
NULL
 


Phone
Phone
[nvarchar](25)
NULL
 


email
email
[nvarchar](30)
NULL
 


Account
Account
[varchar](50)
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


PasswordTTA
PasswordTTA
[nvarchar](20)
NULL
 


YN1099
YN1099
[bit]
NOT NULL
 


CommissionYN
CommissionYN
[bit]
NOT NULL
 


CommissionRate
CommissionRate
[float]
NULL
 


Commission
Commission
[money]
NULL
 


Refferal
Refferal
[int]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsEmployees
PRIMARY
[EmployeeName]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsItems




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

ItemType
ItemType
[int]
NULL
 


CategoryID
CategoryID
[varchar](50)
NULL
 


ItemName
ItemName
[varchar](50)
NOT NULL
 


Subitem
Subitem
[bit]
NOT NULL
 


ItemName1
ItemName1
[varchar](50)
NULL
 


PurchaseDescription
PurchaseDescription
[varchar](50)
NULL
 


Cost
Cost
[money]
NULL
 


COGSAccount
COGSAccount
[varchar](50)
NULL
 


PrefferedVendor
PrefferedVendor
[varchar](50)
NULL
 


SalesDescription
SalesDescription
[varchar](50)
NULL
 


IncomeAccount
IncomeAccount
[varchar](50)
NULL
 


SalesPrice
SalesPrice
[money]
NULL
 


Taxable
Taxable
[bit]
NOT NULL
 


AssetAccount
AssetAccount
[varchar](50)
NULL
 


QuantityOnHand
QuantityOnHand
[int]
NULL
 


TotalValue
TotalValue
[float]
NULL
 


ReorderPoint
ReorderPoint
[int]
NULL
 


ItemWeight
ItemWeight
[float]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


PictureURL
PictureURL
[varchar](50)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsItems
PRIMARY
[ItemName]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsTaxes




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

TaxID
TaxID
[varchar](10)
NOT NULL
 


Description
Description
[varchar](50)
NULL
 


TaxPercent
TaxPercent
[float]
NULL
 


Account
Account
[varchar](50)
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsTaxes
PRIMARY
[TaxID]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsVendors




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

VendorName
VendorName
[varchar](50)
NOT NULL
 


Company
Company
[varchar](50)
NULL
 


MrMs
MrMs
[varchar](10)
NULL
 


FirstName
FirstName
[varchar](20)
NULL
 


MiddleInitial
MiddleInitial
[varchar](10)
NULL
 


LastName
LastName
[varchar](20)
NULL
 


Contact
Contact
[varchar](30)
NULL
 


Address1
Address1
[varchar](50)
NULL
 


Address2
Address2
[varchar](50)
NULL
 


City
City
[varchar](50)
NULL
 


State
State
[varchar](50)
NULL
 


Zip
Zip
[varchar](10)
NULL
 


Country
Country
[varchar](50)
NULL
 


Phone
Phone
[varchar](25)
NULL
 


Fax
Fax
[varchar](25)
NULL
 


AltPhone
AltPhone
[varchar](25)
NULL
 


AltContact
AltContact
[varchar](30)
NULL
 


PrintOnCheckAs
PrintOnCheckAs
[varchar](30)
NULL
 


AccountNumber
AccountNumber
[varchar](50)
NULL
 


DefaultExpenseAccount
DefaultExpenseAccount
[varchar](50)
NULL
 


VendorType
VendorType
[varchar](50)
NULL
 


Term
Term
[varchar](50)
NULL
 


PMID
PMID
[int]
NOT NULL
 


CreditLimit
CreditLimit
[money]
NULL
 


TaxID
TaxID
[varchar](20)
NULL
 


Eligible
Eligible
[bit]
NOT NULL
 


Email
Email
[varchar](30)
NULL
 


OpeningBalance
OpeningBalance
[money]
NULL
 


OpeningBalanceDate
OpeningBalanceDate
[datetime]
NULL
 


Balance
Balance
[money]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsVendors
PRIMARY
[VendorName]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpBillExpenses




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NULL
 


No
No
[int]
NULL
 


Account
Account
[varchar](50)
NULL
 


Amount
Amount
[money]
NULL
 


Memo
Memo
[varchar](50)
NULL
 


Project
Project
[varchar](50)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csCustomerCreditItems




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

CustomerCreditNo
CustomerCreditNo
[varchar](50)
NOT NULL
 


No
No
[int]
NOT NULL
 


Item
Item
[varchar](50)
NOT NULL
 


Description
Description
[varchar](50)
NULL
 


Quantity
Quantity
[float]
NULL
 


Rate
Rate
[money]
NULL
 


Amount
Amount
[money]
NULL
 


Tax
Tax
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_csCustomerCreditItems
PRIMARY
[CustomerCreditNo],  [No]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csInvoiceItems




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

InvoiceNo
InvoiceNo
[varchar](50)
NOT NULL
 


No
No
[int]
NOT NULL
 


Item
Item
[varchar](50)
NOT NULL
 


Description
Description
[varchar](255)
NULL
 


Quantity
Quantity
[float]
NULL
 


Rate
Rate
[money]
NULL
 


Amount
Amount
[money]
NULL
 


ItemWeight
ItemWeight
[float]
NULL
 


Shipped
Shipped
[bit]
NOT NULL
 


ShippedDate
ShippedDate
[smalldatetime]
NULL
 


TrackingNumber
TrackingNumber
[varchar](50)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_csInvoiceItems
PRIMARY
[InvoiceNo],  [No]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csOrderItems




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

OrderNo
OrderNo
[varchar](50)
NOT NULL
 


No
No
[int]
NOT NULL
 


Item
Item
[varchar](50)
NOT NULL
 


Description
Description
[varchar](255)
NULL
 


Quantity
Quantity
[float]
NULL
 


Ship
Ship
[float]
NULL
 


Rate
Rate
[money]
NULL
 


Amount
Amount
[money]
NULL
 


ItemWeight
ItemWeight
[float]
NULL
 


ShipDate
ShipDate
[datetime]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_csOrderItems
PRIMARY
[OrderNo],  [No]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






InventoryAdjustmentDetail




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

RefNo
RefNo
[varchar](50)
NULL
 


Item
Item
[varchar](50)
NULL
 


Description
Description
[nvarchar](50)
NULL
 


CurrentQty
CurrentQty
[float]
NULL
 


CurrentValue
CurrentValue
[money]
NULL
 


NewQty
NewQty
[float]
NULL
 


NewValue
NewValue
[money]
NULL
 


QtyDifference
QtyDifference
[float]
NULL
 


ValueDifference
ValueDifference
[money]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsCustomers




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Login
Login
[varchar](50)
NULL
 


Password
Password
[varchar](50)
NULL
 


CustomerName
CustomerName
[varchar](50)
NOT NULL
 


Company
Company
[varchar](50)
NULL
 


MrMs
MrMs
[varchar](50)
NULL
 


FirstName
FirstName
[varchar](50)
NULL
 


MiddleInitial
MiddleInitial
[varchar](50)
NULL
 


LastName
LastName
[varchar](50)
NULL
 


BillingAddress1
BillingAddress1
[varchar](50)
NULL
 


BillingAddress2
BillingAddress2
[varchar](50)
NULL
 


City
City
[varchar](50)
NULL
 


State
State
[varchar](50)
NULL
 


Zip
Zip
[varchar](50)
NULL
 


Country
Country
[varchar](50)
NULL
 


Contact
Contact
[varchar](50)
NULL
 


Phone
Phone
[varchar](50)
NULL
 


Email
Email
[varchar](50)
NULL
 


Fax
Fax
[varchar](50)
NULL
 


AltPhone
AltPhone
[varchar](50)
NULL
 


AltContact
AltContact
[varchar](50)
NULL
 


Account
Account
[varchar](50)
NULL
 


CustomerType
CustomerType
[varchar](50)
NULL
 


Term
Term
[varchar](50)
NULL
 


Rep
Rep
[varchar](50)
NULL
 


CreditLimit
CreditLimit
[float]
NULL
 


Taxable
Taxable
[bit]
NOT NULL
 


TaxItem
TaxItem
[varchar](50)
NULL
 


ResaleNumber
ResaleNumber
[varchar](50)
NULL
 


OpeningBalance
OpeningBalance
[money]
NULL
 


OpeningBalanceDate
OpeningBalanceDate
[datetime]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 


PasswordCA
PasswordCA
[varchar](50)
NULL
 


Balance
Balance
[money]
NULL
 


ExistingCredit
ExistingCredit
[money]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_lsCustomers
PRIMARY
[CustomerName]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






TimeTracking




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NOT NULL
 


Employee
Employee
[varchar](50)
NULL
 


Date
Date
[datetime]
NULL
 


Customer
Customer
[varchar](50)
NULL
 


ServiceItem
ServiceItem
[varchar](50)
NULL
 


Class
Class
[varchar](50)
NULL
 


Duration
Duration
[float]
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


aaaaaTimeTracking_PK
PRIMARY
[Reference]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpBillItems




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

BillID
BillID
[varchar](50)
NULL
 


No
No
[int]
NULL
 


Item
Item
[varchar](50)
NULL
 


Description
Description
[nvarchar](50)
NULL
 


Quantity
Quantity
[float]
NULL
 


Rate
Rate
[money]
NULL
 


Amount
Amount
[money]
NULL
 


Project
Project
[varchar](50)
NULL
 


Billable
Billable
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpBillPayments




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NOT NULL
 


Account
Account
[varchar](50)
NULL
 


ToBePrinted
ToBePrinted
[bit]
NOT NULL
 


Vendor
Vendor
[varchar](50)
NULL
 


Date
Date
[datetime]
NULL
 


CheckNo
CheckNo
[nvarchar](20)
NULL
 


Amount
Amount
[money]
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


ClearedYN
ClearedYN
[bit]
NOT NULL
 


LastCheckNo
LastCheckNo
[int]
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


aaaaavpBillPayment_PK
PRIMARY
[Reference]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpBills




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Date
Date
[datetime]
NULL
 


Vendor
Vendor
[varchar](50)
NULL
 


Reference
Reference
[varchar](20)
NOT NULL
 


Type
Type
[varchar](20)
NULL
 


Term
Term
[varchar](50)
NULL
 


DueDate
DueDate
[datetime]
NULL
 


VendorInvoice
VendorInvoice
[nvarchar](20)
NULL
 


Freight
Freight
[money]
NULL
 


Discount
Discount
[money]
NULL
 


OtherCharges
OtherCharges
[money]
NULL
 


Amount
Amount
[money]
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


PayAmount
PayAmount
[money]
NULL
 


DueAmount
DueAmount
[money]
NULL
 


PORef
PORef
[varchar](50)
NULL
 


PmtID
PmtID
[int]
NOT NULL
 


PayYN
PayYN
[bit]
NOT NULL
 


CheckID
CheckID
[int]
NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys


PK_vpBills
PRIMARY
[Reference]





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpPurchaseOrderDetails




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

ID
ID
[int]
NOT NULL
 


PORef
PORef
[varchar](50)
NULL
 


No
No
[int]
NULL
 


Item
Item
[varchar](50)
NULL
 


Quantity
Quantity
[float]
NULL
 


ReceivedQty
ReceivedQty
[float]
NULL
 


Rate
Rate
[money]
NULL
 


Amount
Amount
[money]
NULL
 


Description
Description
[nvarchar](255)
NULL
 


Project
Project
[varchar](50)
NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






vpPurchaseOrders




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

PORef
PORef
[varchar](50)
NOT NULL
 


Date
Date
[datetime]
NULL
 


DueDate
DueDate
[datetime]
NULL
 


Term
Term
[varchar](50)
NULL
 


Vendor
Vendor
[varchar](50)
NULL
 


Class
Class
[varchar](50)
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


BillTo
BillTo
[varchar](50)
NULL
 


ShipTo
ShipTo
[varchar](50)
NULL
 


ReceiveBy
ReceiveBy
[datetime]
NULL
 


VendorMessage
VendorMessage
[varchar](50)
NULL
 


ShipVia
ShipVia
[varchar](50)
NULL
 


TrackingNumber
TrackingNumber
[varchar](50)
NULL
 


ShipToD
ShipToD
[nvarchar](100)
NULL
 


VendorInvoice
VendorInvoice
[varchar](20)
NULL
 


Freight
Freight
[money]
NULL
 


Discount
Discount
[float]
NULL
 


OtherCharges
OtherCharges
[money]
NULL
 


ShippingCharge
ShippingCharge
[money]
NULL
 


Total
Total
[money]
NULL
 


ReceivedYN
ReceivedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csCustomerCredits




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Customer
Customer
[varchar](50)
NOT NULL
 


Class
Class
[varchar](50)
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


BillTo
BillTo
[nvarchar](100)
NULL
 


Date
Date
[datetime]
NULL
 


CreditNumber
CreditNumber
[nvarchar](20)
NOT NULL
 


POID
POID
[nvarchar](20)
NULL
 


CustomerMessage
CustomerMessage
[varchar](50)
NULL
 


Discount
Discount
[float]
NULL
 


Handling
Handling
[money]
NULL
 


Freight
Freight
[money]
NULL
 


SalesTax
SalesTax
[varchar](50)
NULL
 


Tax
Tax
[money]
NULL
 


TaxTotal
TaxTotal
[money]
NULL
 


Total
Total
[money]
NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csCustomerPayments




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Reference
Reference
[varchar](50)
NOT NULL
 


Customer
Customer
[varchar](50)
NULL
 


PaymentAmount
PaymentAmount
[money]
NULL
 


Date
Date
[datetime]
NULL
 


PaymentMethod
PaymentMethod
[varchar](50)
NULL
 


Memo
Memo
[varchar](50)
NULL
 


CheckNo
CheckNo
[varchar](20)
NULL
 


CreditCardNo
CreditCardNo
[varchar](30)
NULL
 


CardExpires
CardExpires
[datetime]
NULL
 


NameOnCard
NameOnCard
[nvarchar](30)
NULL
 


CardZipCode
CardZipCode
[nvarchar](20)
NULL
 


CardApproved
CardApproved
[bit]
NOT NULL
 


UndepFunds
UndepFunds
[bit]
NOT NULL
 


DepositTo
DepositTo
[bit]
NOT NULL
 


Account
Account
[varchar](50)
NULL
 


ApplyExistingCredits
ApplyExistingCredits
[bit]
NOT NULL
 


Apply
Apply
[money]
NULL
 


TotalToApply
TotalToApply
[money]
NULL
 


TotalApplied
TotalApplied
[money]
NULL
 


UnappliedAmount
UnappliedAmount
[money]
NULL
 


Deposit
Deposit
[bit]
NOT NULL
 


PayAmount
PayAmount
[money]
NULL
 


ReceivedYN
ReceivedYN
[bit]
NOT NULL
 


ClearedYN
ClearedYN
[bit]
NOT NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csInvoices




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Date
Date
[datetime]
NULL
 


Customer
Customer
[varchar](50)
NULL
 


ShipToID
ShipToID
[varchar](50)
NULL
 


Class
Class
[varchar](50)
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


Term
Term
[varchar](50)
NULL
 


InvoiceNo
InvoiceNo
[nvarchar](20)
NOT NULL
 


DueDate
DueDate
[datetime]
NULL
 


ShipVia
ShipVia
[varchar](50)
NULL
 


ShipDate
ShipDate
[datetime]
NULL
 


POID
POID
[nvarchar](20)
NULL
 


CustomerMessage
CustomerMessage
[varchar](50)
NULL
 


TrackingNumber
TrackingNumber
[varchar](30)
NULL
 


Handling
Handling
[money]
NULL
 


Freight
Freight
[money]
NULL
 


Discount
Discount
[float]
NULL
 


SalesTax
SalesTax
[varchar](10)
NULL
 


Tax
Tax
[money]
NULL
 


TaxTotal
TaxTotal
[money]
NULL
 


Total
Total
[money]
NULL
 


TotalWeight
TotalWeight
[float]
NULL
 


ShippingCharge
ShippingCharge
[money]
NULL
 


ApplyYN
ApplyYN
[bit]
NOT NULL
 


PaidYN
PaidYN
[bit]
NULL
 


PayAmount
PayAmount
[money]
NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






csOrders




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Date
Date
[datetime]
NULL
 


Customer
Customer
[varchar](50)
NULL
 


ShipToID
ShipToID
[varchar](50)
NULL
 


Class
Class
[varchar](50)
NULL
 


Memo
Memo
[nvarchar](50)
NULL
 


Term
Term
[varchar](50)
NULL
 


OrderNo
OrderNo
[varchar](50)
NOT NULL
 


DueDate
DueDate
[datetime]
NULL
 


ShipVia
ShipVia
[varchar](50)
NULL
 


ShipDate
ShipDate
[datetime]
NULL
 


POID
POID
[varchar](50)
NULL
 


CustomerMessage
CustomerMessage
[varchar](50)
NULL
 


Discount
Discount
[float]
NULL
 


Freight
Freight
[money]
NULL
 


SalesTax
SalesTax
[varchar](50)
NULL
 


Tax
Tax
[money]
NULL
 


TaxTotal
TaxTotal
[money]
NULL
 


Total
Total
[money]
NULL
 


TotalWeight
TotalWeight
[float]
NULL
 


ShippingCharge
ShippingCharge
[money]
NULL
 


Handling
Handling
[money]
NULL
 


ApplyYN
ApplyYN
[bit]
NOT NULL
 


Picked
Picked
[bit]
NOT NULL
 


Billed
Billed
[bit]
NOT NULL
 


Printed
Printed
[bit]
NOT NULL
 


Shipped
Shipped
[bit]
NOT NULL
 


Backordered
Backordered
[bit]
NOT NULL
 


Invoiced
Invoiced
[bit]
NOT NULL
 


TrackingNumber
TrackingNumber
[varchar](30)
NULL
 


CCType
CCType
[varchar](50)
NULL
 


CCName
CCName
[varchar](50)
NULL
 


CCNumber
CCNumber
[varchar](20)
NULL
 


CCExpDate
CCExpDate
[datetime]
NULL
 


ApprovalNumber
ApprovalNumber
[varchar](12)
NULL
 


PostedYN
PostedYN
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE


 
 






lsProjects




Definition
 


Note
 


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






Columns




ColumnName
Domain
Datatype
NULL
Definition

Customer
Customer
[varchar](50)
NULL
 


ProjectName
ProjectName
[varchar](50)
NOT NULL
 


Description
Description
[varchar](255)
NULL
 


ProjectManager
ProjectManager
[varchar](50)
NULL
 


StartDate
StartDate
[datetime]
NULL
 


EndDate
EndDate
[datetime]
NULL
 


Inactive
Inactive
[bit]
NOT NULL
 





Primary and Unique Keys




Key Name
Key Type
Keys





Foreign Keys




Name
Field
Parent Table
Parent Field




Storage




STORAGE OPTION
STORAGE VALUE