PaymentMethod
Base Table lsPaymentMethods
Datatype [nvarchar](20)
Nullable NO
Domain PaymentMethod
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ExternalAccess
Base Table lsPaymentMethods
Datatype [bit]
Nullable NO
Domain ExternalAccess
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Inactive
Base Table lsPaymentMethods
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsPaymentMethods
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsPaymentMethods
Datatype [PK_lsPaymentMethods]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FamilyID
Base Table lsItemFamilies
Datatype [varchar](50)
Nullable NO
Domain FamilyID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsItemFamilies
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PictureURL
Base Table lsItemFamilies
Datatype [varchar](50)
Nullable YES
Domain PictureURL
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsItemFamilies
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsItemFamilies
Datatype [PK_lsItemFamilies]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table lsTerms
Datatype [varchar](50)
Nullable NO
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Standard
Base Table lsTerms
Datatype [bit]
Nullable NO
Domain Standard
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DayTillNetDue
Base Table lsTerms
Datatype [smallint]
Nullable YES
Domain DayTillNetDue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount
Base Table lsTerms
Datatype [float]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DaysTillDiscountExpires
Base Table lsTerms
Datatype [smallint]
Nullable YES
Domain DaysTillDiscountExpires
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DayOfMonthNetDue
Base Table lsTerms
Datatype [smallint]
Nullable YES
Domain DayOfMonthNetDue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DueNextMonthIfWithinDays
Base Table lsTerms
Datatype [smallint]
Nullable YES
Domain DueNextMonthIfWithinDays
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount1
Base Table lsTerms
Datatype [float]
Nullable YES
Domain Discount1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DayDiscountExpires
Base Table lsTerms
Datatype [smallint]
Nullable YES
Domain DayDiscountExpires
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Inactive
Base Table lsTerms
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


upsize_ts
Base Table lsTerms
Datatype [timestamp]
Nullable YES
Domain upsize_ts
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsTerms
Datatype [PK_lsTerms]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CategoryID
Base Table lsItemCategories
Datatype [varchar](50)
Nullable NO
Domain CategoryID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsItemCategories
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PictureURL
Base Table lsItemCategories
Datatype [varchar](50)
Nullable YES
Domain PictureURL
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


familyID
Base Table lsItemCategories
Datatype [varchar](50)
Nullable YES
Domain familyID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsItemCategories
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsItemCategories
Datatype [PK_lsItemCategories]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShippingMethod
Base Table lsShippingMethods
Datatype [varchar](50)
Nullable NO
Domain ShippingMethod
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountNo
Base Table lsShippingMethods
Datatype [varchar](50)
Nullable YES
Domain AccountNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsShippingMethods
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsShippingMethods
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsShippingMethods
Datatype [PK_lsShippingMethods]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ClassName
Base Table lsClasses
Datatype [varchar](50)
Nullable NO
Domain ClassName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Subclass
Base Table lsClasses
Datatype [bit]
Nullable NO
Domain Subclass
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ClassName1
Base Table lsClasses
Datatype [varchar](50)
Nullable YES
Domain ClassName1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Inactive
Base Table lsClasses
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsClasses
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsClasses
Datatype [PK_lsClasses]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerType
Base Table lsCustomerTypes
Datatype [varchar](50)
Nullable NO
Domain CustomerType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsCustomerTypes
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsCustomerTypes
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsCustomerTypes
Datatype [PK_lsCustomerTypes]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CompanyID
Base Table Company
Datatype [int]
Nullable NO
Domain CompanyID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CompanyName
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain CompanyName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


LegalName
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain LegalName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address1
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain Address1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address2
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain Address2
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


City
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain City
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


State
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain State
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Zip
Base Table Company
Datatype [varchar](10)
Nullable YES
Domain Zip
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Country
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain Country
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Phone
Base Table Company
Datatype [varchar](25)
Nullable YES
Domain Phone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Fax
Base Table Company
Datatype [varchar](25)
Nullable YES
Domain Fax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


email
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain email
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


website
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain website
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FirstFiscalMonth
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain FirstFiscalMonth
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PictureURL
Base Table Company
Datatype [char](10)
Nullable YES
Domain PictureURL
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ConfirmDeletion
Base Table Company
Datatype [bit]
Nullable NO
Domain ConfirmDeletion
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1))


UseAN
Base Table Company
Datatype [bit]
Nullable NO
Domain UseAN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1))


DefaultCT
Base Table Company
Datatype [int]
Nullable YES
Domain DefaultCT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DefaultIT
Base Table Company
Datatype [int]
Nullable YES
Domain DefaultIT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DefaultSM
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain DefaultSM
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AgingReportUse
Base Table Company
Datatype [bit]
Nullable NO
Domain AgingReportUse
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


TaxFreight
Base Table Company
Datatype [bit]
Nullable NO
Domain TaxFreight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1))


DefaultSalesTax
Base Table Company
Datatype [varchar](50)
Nullable YES
Domain DefaultSalesTax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ChargeHandling
Base Table Company
Datatype [bit]
Nullable NO
Domain ChargeHandling
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


HandlingAsPercent
Base Table Company
Datatype [bit]
Nullable NO
Domain HandlingAsPercent
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


HandlingAmount
Base Table Company
Datatype [float]
Nullable YES
Domain HandlingAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


CurrencySymbol
Base Table Company
Datatype [varchar](10)
Nullable YES
Domain CurrencySymbol
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('$')


EditStamp
Base Table Company
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table Company
Datatype [PK_Company]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxGroupID
Base Table lsTaxGroups
Datatype [varchar](10)
Nullable NO
Domain TaxGroupID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxGroupName
Base Table lsTaxGroups
Datatype [varchar](50)
Nullable YES
Domain TaxGroupName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TotalPercent
Base Table lsTaxGroups
Datatype [float]
Nullable YES
Domain TotalPercent
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsTaxGroups
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


IsDefault
Base Table lsTaxGroups
Datatype [bit]
Nullable NO
Domain IsDefault
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsTaxGroups
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsTaxGroups
Datatype [PK_lsTaxGroups]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CompanyID
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain CompanyID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckNo
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain CheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


Vouchers
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain Vouchers
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


Orders
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain Orders
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


BillPmt
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain BillPmt
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


Invoices
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain Invoices
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


CustCredits
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain CustCredits
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


CustPmt
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain CustPmt
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


Adjustment
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain Adjustment
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


TimeTracking
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain TimeTracking
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


Transfers
Base Table DocNumbers
Datatype [int]
Nullable NO
Domain Transfers
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((1000))


EditStamp
Base Table DocNumbers
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table DocNumbers
Datatype [PK_DocNumbers]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


VendorType
Base Table lsVendorTypes
Datatype [nvarchar](30)
Nullable NO
Domain VendorType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsVendorTypes
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsVendorTypes
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsVendorTypes
Datatype [PK_lsVendorTypes]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EntryNo
Base Table GeneralJournalEntry
Datatype [nvarchar](20)
Nullable NO
Domain EntryNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table GeneralJournalEntry
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TrType
Base Table GeneralJournalEntry
Datatype [int]
Nullable YES
Domain TrType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TrID
Base Table GeneralJournalEntry
Datatype [varchar](50)
Nullable YES
Domain TrID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


SystemGenerated
Base Table GeneralJournalEntry
Datatype [bit]
Nullable NO
Domain SystemGenerated
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table GeneralJournalEntry
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table GeneralJournalEntry
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table GeneralJournalEntry
Datatype [PK_GeneralJournalEntry]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsAccountTypes
Datatype [varchar](50)
Nullable NO
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsAccountTypes
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsAccountTypes
Datatype [aaaaalsAccountType_PK]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountID
Base Table OpBalWork
Datatype [varchar](50)
Nullable YES
Domain AccountID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


AccBalType
Base Table OpBalWork
Datatype [int]
Nullable YES
Domain AccBalType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OpeningBalance
Base Table OpBalWork
Datatype [float]
Nullable YES
Domain OpeningBalance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table OpBalWork
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerMessage
Base Table lsCustomerMessages
Datatype [varchar](50)
Nullable NO
Domain CustomerMessage
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsCustomerMessages
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsCustomerMessages
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsCustomerMessages
Datatype [PK_lsCustomerMessages]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Name
Base Table lsMemorized
Datatype [varchar](50)
Nullable NO
Domain Name
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TrType
Base Table lsMemorized
Datatype [varchar](20)
Nullable YES
Domain TrType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TransID
Base Table lsMemorized
Datatype [varchar](50)
Nullable YES
Domain TransID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsMemorized
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsMemorized
Datatype [PK_lsMemorized]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MonthID
Base Table Months
Datatype [int]
Nullable NO
Domain MonthID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Name
Base Table Months
Datatype [nvarchar](20)
Nullable YES
Domain Name
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table Months
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table Months
Datatype [PK_Months]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


GrpID
Base Table lsTaxGroupDetail
Datatype [varchar](10)
Nullable NO
Domain GrpID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxID
Base Table lsTaxGroupDetail
Datatype [varchar](10)
Nullable NO
Domain TaxID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsTaxGroupDetail
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table lsTaxGroupDetail
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxPercent
Base Table lsTaxGroupDetail
Datatype [float]
Nullable YES
Domain TaxPercent
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsTaxGroupDetail
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsTaxGroupDetail
Datatype [PK_lsTaxGroupDetail]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table csCustomerPaymentDetails
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FID
Base Table csCustomerPaymentDetails
Datatype [varchar](50)
Nullable NO
Domain FID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ToPay
Base Table csCustomerPaymentDetails
Datatype [money]
Nullable YES
Domain ToPay
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


textboxAmount
Base Table csCustomerPaymentDetails
Datatype [money]
Nullable YES
Domain textboxAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csCustomerPaymentDetails
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csCustomerPaymentDetails
Datatype [PK_csCustomerPaymentDetails]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table vpBillPaymentDetails
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FID
Base Table vpBillPaymentDetails
Datatype [varchar](50)
Nullable NO
Domain FID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


textboxAmount
Base Table vpBillPaymentDetails
Datatype [money]
Nullable YES
Domain textboxAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table vpBillPaymentDetails
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpBillPaymentDetails
Datatype [PK_vpBillPaymentDetails]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EntryNo
Base Table GeneralJournalDetail
Datatype [varchar](50)
Nullable NO
Domain EntryNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


No
Base Table GeneralJournalDetail
Datatype [int]
Nullable NO
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Account
Base Table GeneralJournalDetail
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Debit
Base Table GeneralJournalDetail
Datatype [money]
Nullable YES
Domain Debit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Credit
Base Table GeneralJournalDetail
Datatype [money]
Nullable YES
Domain Credit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table GeneralJournalDetail
Datatype [varchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table GeneralJournalDetail
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table GeneralJournalDetail
Datatype [PK_GeneralJournalDetail]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ID
Base Table Commissions
Datatype [int]
Nullable NO
Domain ID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EmpName
Base Table Commissions
Datatype [varchar](50)
Nullable YES
Domain EmpName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table Commissions
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Amount
Base Table Commissions
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PaidYN
Base Table Commissions
Datatype [bit]
Nullable NO
Domain PaidYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table Commissions
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table Commissions
Datatype [PK_Commissions]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


GLID
Base Table GLWorkDetail
Datatype [varchar](50)
Nullable NO
Domain GLID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


No
Base Table GLWorkDetail
Datatype [char](10)
Nullable NO
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Credit
Base Table GLWorkDetail
Datatype [money]
Nullable YES
Domain Credit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Debit
Base Table GLWorkDetail
Datatype [money]
Nullable YES
Domain Debit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Memo
Base Table GLWorkDetail
Datatype [varchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table GLWorkDetail
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table GLWorkDetail
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table GLWorkDetail
Datatype [PK_GLWorkDetail]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


OrderNo
Base Table csOrderTracking
Datatype [varchar](50)
Nullable YES
Domain OrderNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


InvoiceNo
Base Table csOrderTracking
Datatype [varchar](50)
Nullable YES
Domain InvoiceNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table csOrderTracking
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


LoginID
Base Table Users
Datatype [nchar](10)
Nullable YES
Domain LoginID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Username
Base Table Users
Datatype [varchar](20)
Nullable NO
Domain Username
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Password
Base Table Users
Datatype [varchar](20)
Nullable YES
Domain Password
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('')


GroupLevel
Base Table Users
Datatype [nchar](10)
Nullable YES
Domain GroupLevel
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table Users
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table Users
Datatype [PK_Users]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerName
Base Table lsCustomersShipTo
Datatype [varchar](50)
Nullable NO
Domain CustomerName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipingAddressID
Base Table lsCustomersShipTo
Datatype [int]
Nullable NO
Domain ShipingAddressID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShippingAddress
Base Table lsCustomersShipTo
Datatype [varchar](50)
Nullable YES
Domain ShippingAddress
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


City
Base Table lsCustomersShipTo
Datatype [varchar](50)
Nullable YES
Domain City
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


State
Base Table lsCustomersShipTo
Datatype [varchar](10)
Nullable YES
Domain State
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Zip
Base Table lsCustomersShipTo
Datatype [varchar](10)
Nullable YES
Domain Zip
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Country
Base Table lsCustomersShipTo
Datatype [varchar](50)
Nullable YES
Domain Country
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table lsCustomersShipTo
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsCustomersShipTo
Datatype [PK_lsCustomersShipTo]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckID
Base Table bCheckDetails
Datatype [int]
Nullable NO
Domain CheckID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


InvDate
Base Table bCheckDetails
Datatype [datetime]
Nullable YES
Domain InvDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


InvRef
Base Table bCheckDetails
Datatype [nvarchar](20)
Nullable NO
Domain InvRef
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('')


InvOrigAmount
Base Table bCheckDetails
Datatype [money]
Nullable YES
Domain InvOrigAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table bCheckDetails
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


BillID
Base Table bCheckDetails
Datatype [varchar](50)
Nullable YES
Domain BillID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table bCheckDetails
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table bCheckDetails
Datatype [PK_bCheckDetails]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table vpBills
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Vendor
Base Table vpBills
Datatype [varchar](50)
Nullable YES
Domain Vendor
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Reference
Base Table vpBills
Datatype [varchar](20)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Type
Base Table vpBills
Datatype [varchar](20)
Nullable YES
Domain Type
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table vpBills
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DueDate
Base Table vpBills
Datatype [datetime]
Nullable YES
Domain DueDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


VendorInvoice
Base Table vpBills
Datatype [nvarchar](20)
Nullable YES
Domain VendorInvoice
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Freight
Base Table vpBills
Datatype [money]
Nullable YES
Domain Freight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount
Base Table vpBills
Datatype [money]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OtherCharges
Base Table vpBills
Datatype [money]
Nullable YES
Domain OtherCharges
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table vpBills
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table vpBills
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PayAmount
Base Table vpBills
Datatype [money]
Nullable YES
Domain PayAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DueAmount
Base Table vpBills
Datatype [money]
Nullable YES
Domain DueAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PORef
Base Table vpBills
Datatype [varchar](50)
Nullable YES
Domain PORef
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PmtID
Base Table vpBills
Datatype [int]
Nullable NO
Domain PmtID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PayYN
Base Table vpBills
Datatype [bit]
Nullable NO
Domain PayYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


CheckID
Base Table vpBills
Datatype [int]
Nullable YES
Domain CheckID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PostedYN
Base Table vpBills
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table vpBills
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpBills
Datatype [PK_vpBills]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PORef
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable NO
Domain PORef
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table vpPurchaseOrders
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DueDate
Base Table vpPurchaseOrders
Datatype [datetime]
Nullable YES
Domain DueDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Vendor
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain Vendor
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Class
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain Class
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table vpPurchaseOrders
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillTo
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain BillTo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipTo
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain ShipTo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ReceiveBy
Base Table vpPurchaseOrders
Datatype [datetime]
Nullable YES
Domain ReceiveBy
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


VendorMessage
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain VendorMessage
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipVia
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain ShipVia
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TrackingNumber
Base Table vpPurchaseOrders
Datatype [varchar](50)
Nullable YES
Domain TrackingNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipToD
Base Table vpPurchaseOrders
Datatype [nvarchar](100)
Nullable YES
Domain ShipToD
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


VendorInvoice
Base Table vpPurchaseOrders
Datatype [varchar](20)
Nullable YES
Domain VendorInvoice
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Freight
Base Table vpPurchaseOrders
Datatype [money]
Nullable YES
Domain Freight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount
Base Table vpPurchaseOrders
Datatype [float]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OtherCharges
Base Table vpPurchaseOrders
Datatype [money]
Nullable YES
Domain OtherCharges
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShippingCharge
Base Table vpPurchaseOrders
Datatype [money]
Nullable YES
Domain ShippingCharge
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Total
Base Table vpPurchaseOrders
Datatype [money]
Nullable YES
Domain Total
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ReceivedYN
Base Table vpPurchaseOrders
Datatype [bit]
Nullable NO
Domain ReceivedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table vpPurchaseOrders
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpPurchaseOrders
Datatype [PK_vpPurchaseOrders]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table vpBillPayments
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table vpBillPayments
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ToBePrinted
Base Table vpBillPayments
Datatype [bit]
Nullable NO
Domain ToBePrinted
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Vendor
Base Table vpBillPayments
Datatype [varchar](50)
Nullable YES
Domain Vendor
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Date
Base Table vpBillPayments
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckNo
Base Table vpBillPayments
Datatype [nvarchar](20)
Nullable YES
Domain CheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Amount
Base Table vpBillPayments
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table vpBillPayments
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ClearedYN
Base Table vpBillPayments
Datatype [bit]
Nullable NO
Domain ClearedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


LastCheckNo
Base Table vpBillPayments
Datatype [int]
Nullable YES
Domain LastCheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (1)


EditStamp
Base Table vpBillPayments
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpBillPayments
Datatype [aaaaavpBillPayment_PK]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table csOrders
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShipToID
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain ShipToID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Class
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain Class
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table csOrders
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OrderNo
Base Table csOrders
Datatype [varchar](50)
Nullable NO
Domain OrderNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DueDate
Base Table csOrders
Datatype [datetime]
Nullable YES
Domain DueDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipVia
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain ShipVia
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShipDate
Base Table csOrders
Datatype [datetime]
Nullable YES
Domain ShipDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


POID
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain POID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerMessage
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain CustomerMessage
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount
Base Table csOrders
Datatype [float]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Freight
Base Table csOrders
Datatype [money]
Nullable YES
Domain Freight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


SalesTax
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain SalesTax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Tax
Base Table csOrders
Datatype [money]
Nullable YES
Domain Tax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TaxTotal
Base Table csOrders
Datatype [money]
Nullable YES
Domain TaxTotal
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Total
Base Table csOrders
Datatype [money]
Nullable YES
Domain Total
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TotalWeight
Base Table csOrders
Datatype [float]
Nullable YES
Domain TotalWeight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShippingCharge
Base Table csOrders
Datatype [money]
Nullable YES
Domain ShippingCharge
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Handling
Base Table csOrders
Datatype [money]
Nullable YES
Domain Handling
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ApplyYN
Base Table csOrders
Datatype [bit]
Nullable NO
Domain ApplyYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Picked
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Picked
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Billed
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Billed
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Printed
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Printed
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Shipped
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Shipped
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Backordered
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Backordered
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Invoiced
Base Table csOrders
Datatype [bit]
Nullable NO
Domain Invoiced
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TrackingNumber
Base Table csOrders
Datatype [varchar](30)
Nullable YES
Domain TrackingNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CCType
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain CCType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CCName
Base Table csOrders
Datatype [varchar](50)
Nullable YES
Domain CCName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('')


CCNumber
Base Table csOrders
Datatype [varchar](20)
Nullable YES
Domain CCNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('')


CCExpDate
Base Table csOrders
Datatype [datetime]
Nullable YES
Domain CCExpDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ApprovalNumber
Base Table csOrders
Datatype [varchar](12)
Nullable YES
Domain ApprovalNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ('')


PostedYN
Base Table csOrders
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csOrders
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csOrders
Datatype [PK_csOrders]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table csInvoices
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShipToID
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain ShipToID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Class
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain Class
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table csInvoices
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


InvoiceNo
Base Table csInvoices
Datatype [nvarchar](20)
Nullable NO
Domain InvoiceNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DueDate
Base Table csInvoices
Datatype [datetime]
Nullable YES
Domain DueDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ShipVia
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain ShipVia
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShipDate
Base Table csInvoices
Datatype [datetime]
Nullable YES
Domain ShipDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


POID
Base Table csInvoices
Datatype [nvarchar](20)
Nullable YES
Domain POID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerMessage
Base Table csInvoices
Datatype [varchar](50)
Nullable YES
Domain CustomerMessage
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TrackingNumber
Base Table csInvoices
Datatype [varchar](30)
Nullable YES
Domain TrackingNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Handling
Base Table csInvoices
Datatype [money]
Nullable YES
Domain Handling
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Freight
Base Table csInvoices
Datatype [money]
Nullable YES
Domain Freight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Discount
Base Table csInvoices
Datatype [float]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


SalesTax
Base Table csInvoices
Datatype [varchar](10)
Nullable YES
Domain SalesTax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Tax
Base Table csInvoices
Datatype [money]
Nullable YES
Domain Tax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TaxTotal
Base Table csInvoices
Datatype [money]
Nullable YES
Domain TaxTotal
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Total
Base Table csInvoices
Datatype [money]
Nullable YES
Domain Total
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TotalWeight
Base Table csInvoices
Datatype [float]
Nullable YES
Domain TotalWeight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShippingCharge
Base Table csInvoices
Datatype [money]
Nullable YES
Domain ShippingCharge
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ApplyYN
Base Table csInvoices
Datatype [bit]
Nullable NO
Domain ApplyYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PaidYN
Base Table csInvoices
Datatype [bit]
Nullable YES
Domain PaidYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PayAmount
Base Table csInvoices
Datatype [money]
Nullable YES
Domain PayAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table csInvoices
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csInvoices
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csInvoices
Datatype [PK_csInvoices]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Login
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Login
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Password
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Password
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerName
Base Table lsCustomers
Datatype [varchar](50)
Nullable NO
Domain CustomerName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Company
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Company
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MrMs
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain MrMs
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FirstName
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain FirstName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MiddleInitial
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain MiddleInitial
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


LastName
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain LastName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillingAddress1
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain BillingAddress1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillingAddress2
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain BillingAddress2
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


City
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain City
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


State
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain State
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Zip
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Zip
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Country
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Country
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Contact
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Contact
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Phone
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Phone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Email
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Email
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Fax
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Fax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AltPhone
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain AltPhone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AltContact
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain AltContact
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerType
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain CustomerType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Term
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Rep
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain Rep
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CreditLimit
Base Table lsCustomers
Datatype [float]
Nullable YES
Domain CreditLimit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Taxable
Base Table lsCustomers
Datatype [bit]
Nullable NO
Domain Taxable
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TaxItem
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain TaxItem
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ResaleNumber
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain ResaleNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


OpeningBalance
Base Table lsCustomers
Datatype [money]
Nullable YES
Domain OpeningBalance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OpeningBalanceDate
Base Table lsCustomers
Datatype [datetime]
Nullable YES
Domain OpeningBalanceDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (1 / 1 / 2000)


Inactive
Base Table lsCustomers
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PasswordCA
Base Table lsCustomers
Datatype [varchar](50)
Nullable YES
Domain PasswordCA
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Balance
Base Table lsCustomers
Datatype [money]
Nullable YES
Domain Balance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ExistingCredit
Base Table lsCustomers
Datatype [money]
Nullable YES
Domain ExistingCredit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsCustomers
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsCustomers
Datatype [PK_lsCustomers]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table csCustomerCredits
Datatype [varchar](50)
Nullable NO
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Class
Base Table csCustomerCredits
Datatype [varchar](50)
Nullable YES
Domain Class
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table csCustomerCredits
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillTo
Base Table csCustomerCredits
Datatype [nvarchar](100)
Nullable YES
Domain BillTo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table csCustomerCredits
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CreditNumber
Base Table csCustomerCredits
Datatype [nvarchar](20)
Nullable NO
Domain CreditNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


POID
Base Table csCustomerCredits
Datatype [nvarchar](20)
Nullable YES
Domain POID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerMessage
Base Table csCustomerCredits
Datatype [varchar](50)
Nullable YES
Domain CustomerMessage
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Discount
Base Table csCustomerCredits
Datatype [float]
Nullable YES
Domain Discount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Handling
Base Table csCustomerCredits
Datatype [money]
Nullable YES
Domain Handling
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Freight
Base Table csCustomerCredits
Datatype [money]
Nullable YES
Domain Freight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


SalesTax
Base Table csCustomerCredits
Datatype [varchar](50)
Nullable YES
Domain SalesTax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Tax
Base Table csCustomerCredits
Datatype [money]
Nullable YES
Domain Tax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TaxTotal
Base Table csCustomerCredits
Datatype [money]
Nullable YES
Domain TaxTotal
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Total
Base Table csCustomerCredits
Datatype [money]
Nullable YES
Domain Total
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table csCustomerCredits
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csCustomerCredits
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csCustomerCredits
Datatype [PK_csCustomerCredits]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table csCustomerPayments
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table csCustomerPayments
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PaymentAmount
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain PaymentAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Date
Base Table csCustomerPayments
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PaymentMethod
Base Table csCustomerPayments
Datatype [varchar](50)
Nullable YES
Domain PaymentMethod
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table csCustomerPayments
Datatype [varchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckNo
Base Table csCustomerPayments
Datatype [varchar](20)
Nullable YES
Domain CheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CreditCardNo
Base Table csCustomerPayments
Datatype [varchar](30)
Nullable YES
Domain CreditCardNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CardExpires
Base Table csCustomerPayments
Datatype [datetime]
Nullable YES
Domain CardExpires
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


NameOnCard
Base Table csCustomerPayments
Datatype [nvarchar](30)
Nullable YES
Domain NameOnCard
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CardZipCode
Base Table csCustomerPayments
Datatype [nvarchar](20)
Nullable YES
Domain CardZipCode
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CardApproved
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain CardApproved
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


UndepFunds
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain UndepFunds
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


DepositTo
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain DepositTo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Account
Base Table csCustomerPayments
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ApplyExistingCredits
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain ApplyExistingCredits
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Apply
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain Apply
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TotalToApply
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain TotalToApply
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TotalApplied
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain TotalApplied
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


UnappliedAmount
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain UnappliedAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Deposit
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain Deposit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PayAmount
Base Table csCustomerPayments
Datatype [money]
Nullable YES
Domain PayAmount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ReceivedYN
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain ReceivedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ClearedYN
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain ClearedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table csCustomerPayments
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csCustomerPayments
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csCustomerPayments
Datatype [PK_csCustomerPayments]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table lsProjects
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ProjectName
Base Table lsProjects
Datatype [varchar](50)
Nullable NO
Domain ProjectName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsProjects
Datatype [varchar](255)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ProjectManager
Base Table lsProjects
Datatype [varchar](50)
Nullable YES
Domain ProjectManager
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


StartDate
Base Table lsProjects
Datatype [datetime]
Nullable YES
Domain StartDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EndDate
Base Table lsProjects
Datatype [datetime]
Nullable YES
Domain EndDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsProjects
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsProjects
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsProjects
Datatype [PK_lsProjects]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table TimeTracking
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Employee
Base Table TimeTracking
Datatype [varchar](50)
Nullable YES
Domain Employee
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Date
Base Table TimeTracking
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Customer
Base Table TimeTracking
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ServiceItem
Base Table TimeTracking
Datatype [varchar](50)
Nullable YES
Domain ServiceItem
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Class
Base Table TimeTracking
Datatype [varchar](50)
Nullable YES
Domain Class
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Duration
Base Table TimeTracking
Datatype [float]
Nullable YES
Domain Duration
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table TimeTracking
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table TimeTracking
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table TimeTracking
Datatype [aaaaaTimeTracking_PK]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountNumber
Base Table lsAccounts
Datatype [varchar](10)
Nullable YES
Domain AccountNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountName
Base Table lsAccounts
Datatype [varchar](50)
Nullable NO
Domain AccountName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountType
Base Table lsAccounts
Datatype [varchar](50)
Nullable YES
Domain AccountType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Subaccount
Base Table lsAccounts
Datatype [bit]
Nullable NO
Domain Subaccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


AccountName1
Base Table lsAccounts
Datatype [varchar](50)
Nullable YES
Domain AccountName1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Description
Base Table lsAccounts
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


OpeningBalance
Base Table lsAccounts
Datatype [money]
Nullable YES
Domain OpeningBalance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Date
Base Table lsAccounts
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsAccounts
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Balance
Base Table lsAccounts
Datatype [money]
Nullable YES
Domain Balance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


BalanceType
Base Table lsAccounts
Datatype [smallint]
Nullable YES
Domain BalanceType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Modified
Base Table lsAccounts
Datatype [smallint]
Nullable YES
Domain Modified
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OpBalID
Base Table lsAccounts
Datatype [int]
Nullable NO
Domain OpBalID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


IsDefault
Base Table lsAccounts
Datatype [bit]
Nullable NO
Domain IsDefault
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsAccounts
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsAccounts
Datatype [PK_lsAccounts]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckID
Base Table EmpChecks
Datatype [int]
Nullable NO
Domain CheckID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckNo
Base Table EmpChecks
Datatype [int]
Nullable YES
Domain CheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table EmpChecks
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Payee
Base Table EmpChecks
Datatype [varchar](50)
Nullable YES
Domain Payee
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Amount
Base Table EmpChecks
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address
Base Table EmpChecks
Datatype [varchar](255)
Nullable YES
Domain Address
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table EmpChecks
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table EmpChecks
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table EmpChecks
Datatype [PK_EmpChecks]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table InventoryAdjustments
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


RefNo
Base Table InventoryAdjustments
Datatype [varchar](50)
Nullable NO
Domain RefNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AdjustmentAccount
Base Table InventoryAdjustments
Datatype [varchar](50)
Nullable YES
Domain AdjustmentAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Customer
Base Table InventoryAdjustments
Datatype [varchar](50)
Nullable YES
Domain Customer
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table InventoryAdjustments
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TotalValue
Base Table InventoryAdjustments
Datatype [money]
Nullable YES
Domain TotalValue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table InventoryAdjustments
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table InventoryAdjustments
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table InventoryAdjustments
Datatype [aaaaaInventoryAdjustment_PK]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxID
Base Table lsTaxes
Datatype [varchar](10)
Nullable NO
Domain TaxID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table lsTaxes
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxPercent
Base Table lsTaxes
Datatype [float]
Nullable YES
Domain TaxPercent
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table lsTaxes
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsTaxes
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsTaxes
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsTaxes
Datatype [PK_lsTaxes]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


VendorName
Base Table lsVendors
Datatype [varchar](50)
Nullable NO
Domain VendorName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Company
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain Company
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MrMs
Base Table lsVendors
Datatype [varchar](10)
Nullable YES
Domain MrMs
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FirstName
Base Table lsVendors
Datatype [varchar](20)
Nullable YES
Domain FirstName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MiddleInitial
Base Table lsVendors
Datatype [varchar](10)
Nullable YES
Domain MiddleInitial
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


LastName
Base Table lsVendors
Datatype [varchar](20)
Nullable YES
Domain LastName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Contact
Base Table lsVendors
Datatype [varchar](30)
Nullable YES
Domain Contact
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address1
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain Address1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address2
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain Address2
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


City
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain City
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


State
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain State
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Zip
Base Table lsVendors
Datatype [varchar](10)
Nullable YES
Domain Zip
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Country
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain Country
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Phone
Base Table lsVendors
Datatype [varchar](25)
Nullable YES
Domain Phone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Fax
Base Table lsVendors
Datatype [varchar](25)
Nullable YES
Domain Fax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AltPhone
Base Table lsVendors
Datatype [varchar](25)
Nullable YES
Domain AltPhone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AltContact
Base Table lsVendors
Datatype [varchar](30)
Nullable YES
Domain AltContact
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PrintOnCheckAs
Base Table lsVendors
Datatype [varchar](30)
Nullable YES
Domain PrintOnCheckAs
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


AccountNumber
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain AccountNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


DefaultExpenseAccount
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain DefaultExpenseAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


VendorType
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain VendorType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Term
Base Table lsVendors
Datatype [varchar](50)
Nullable YES
Domain Term
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PMID
Base Table lsVendors
Datatype [int]
Nullable NO
Domain PMID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CreditLimit
Base Table lsVendors
Datatype [money]
Nullable YES
Domain CreditLimit
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


TaxID
Base Table lsVendors
Datatype [varchar](20)
Nullable YES
Domain TaxID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Eligible
Base Table lsVendors
Datatype [bit]
Nullable NO
Domain Eligible
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Email
Base Table lsVendors
Datatype [varchar](30)
Nullable YES
Domain Email
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


OpeningBalance
Base Table lsVendors
Datatype [money]
Nullable YES
Domain OpeningBalance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


OpeningBalanceDate
Base Table lsVendors
Datatype [datetime]
Nullable YES
Domain OpeningBalanceDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Balance
Base Table lsVendors
Datatype [money]
Nullable YES
Domain Balance
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Inactive
Base Table lsVendors
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsVendors
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsVendors
Datatype [PK_lsVendors]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EmployeeName
Base Table lsEmployees
Datatype [varchar](50)
Nullable NO
Domain EmployeeName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


SalesmanID
Base Table lsEmployees
Datatype [varchar](10)
Nullable YES
Domain SalesmanID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Initials
Base Table lsEmployees
Datatype [nvarchar](30)
Nullable YES
Domain Initials
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TaxID
Base Table lsEmployees
Datatype [nvarchar](20)
Nullable YES
Domain TaxID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MrMs
Base Table lsEmployees
Datatype [nvarchar](10)
Nullable YES
Domain MrMs
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FirstName
Base Table lsEmployees
Datatype [nvarchar](20)
Nullable YES
Domain FirstName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


MiddleInitial
Base Table lsEmployees
Datatype [nvarchar](10)
Nullable YES
Domain MiddleInitial
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


LastName
Base Table lsEmployees
Datatype [nvarchar](20)
Nullable YES
Domain LastName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address1
Base Table lsEmployees
Datatype [nvarchar](50)
Nullable YES
Domain Address1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address2
Base Table lsEmployees
Datatype [nvarchar](50)
Nullable YES
Domain Address2
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


City
Base Table lsEmployees
Datatype [nvarchar](50)
Nullable YES
Domain City
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


State
Base Table lsEmployees
Datatype [nvarchar](10)
Nullable YES
Domain State
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Zip
Base Table lsEmployees
Datatype [nvarchar](10)
Nullable YES
Domain Zip
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Country
Base Table lsEmployees
Datatype [nvarchar](50)
Nullable YES
Domain Country
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Phone
Base Table lsEmployees
Datatype [nvarchar](25)
Nullable YES
Domain Phone
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


email
Base Table lsEmployees
Datatype [nvarchar](30)
Nullable YES
Domain email
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table lsEmployees
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsEmployees
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PasswordTTA
Base Table lsEmployees
Datatype [nvarchar](20)
Nullable YES
Domain PasswordTTA
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


YN1099
Base Table lsEmployees
Datatype [bit]
Nullable NO
Domain YN1099
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


CommissionYN
Base Table lsEmployees
Datatype [bit]
Nullable NO
Domain CommissionYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


CommissionRate
Base Table lsEmployees
Datatype [float]
Nullable YES
Domain CommissionRate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Commission
Base Table lsEmployees
Datatype [money]
Nullable YES
Domain Commission
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Refferal
Base Table lsEmployees
Datatype [int]
Nullable YES
Domain Refferal
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table lsEmployees
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsEmployees
Datatype [PK_lsEmployees]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ItemName
Base Table lsItems
Datatype [varchar](50)
Nullable NO
Domain ItemName
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ItemName1
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain ItemName1
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ItemType
Base Table lsItems
Datatype [int]
Nullable YES
Domain ItemType
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Subitem
Base Table lsItems
Datatype [bit]
Nullable NO
Domain Subitem
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


CategoryID
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain CategoryID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PurchaseDescription
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain PurchaseDescription
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Cost
Base Table lsItems
Datatype [money]
Nullable YES
Domain Cost
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


COGSAccount
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain COGSAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PrefferedVendor
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain PrefferedVendor
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


SalesDescription
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain SalesDescription
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


IncomeAccount
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain IncomeAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


SalesPrice
Base Table lsItems
Datatype [money]
Nullable YES
Domain SalesPrice
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Taxable
Base Table lsItems
Datatype [bit]
Nullable NO
Domain Taxable
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


AssetAccount
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain AssetAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


QuantityOnHand
Base Table lsItems
Datatype [int]
Nullable YES
Domain QuantityOnHand
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


TotalValue
Base Table lsItems
Datatype [float]
Nullable YES
Domain TotalValue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


ReorderPoint
Base Table lsItems
Datatype [int]
Nullable YES
Domain ReorderPoint
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


ItemWeight
Base Table lsItems
Datatype [float]
Nullable YES
Domain ItemWeight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


PictureURL
Base Table lsItems
Datatype [varchar](50)
Nullable YES
Domain PictureURL
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Inactive
Base Table lsItems
Datatype [bit]
Nullable NO
Domain Inactive
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


EditStamp
Base Table lsItems
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table lsItems
Datatype [PK_lsItems]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table bTransferFunds
Datatype [varchar](50)
Nullable NO
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


FromAccount
Base Table bTransferFunds
Datatype [varchar](50)
Nullable YES
Domain FromAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ToAccount
Base Table bTransferFunds
Datatype [varchar](50)
Nullable YES
Domain ToAccount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Date
Base Table bTransferFunds
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Amount
Base Table bTransferFunds
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table bTransferFunds
Datatype [nvarchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ClearedYN
Base Table bTransferFunds
Datatype [bit]
Nullable NO
Domain ClearedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


PostedYN
Base Table bTransferFunds
Datatype [bit]
Nullable NO
Domain PostedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table bTransferFunds
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table bTransferFunds
Datatype [PK_bTransferFunds]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillID
Base Table vpBillExpenses
Datatype [int]
Nullable NO
Domain BillID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Reference
Base Table vpBillExpenses
Datatype [varchar](50)
Nullable YES
Domain Reference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


No
Base Table vpBillExpenses
Datatype [int]
Nullable YES
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Account
Base Table vpBillExpenses
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Amount
Base Table vpBillExpenses
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Memo
Base Table vpBillExpenses
Datatype [varchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Project
Base Table vpBillExpenses
Datatype [varchar](50)
Nullable YES
Domain Project
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


EditStamp
Base Table vpBillExpenses
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpBillExpenses
Datatype [PK_vpBillExpenses]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckID
Base Table bChecks
Datatype [int]
Nullable NO
Domain CheckID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CheckNo
Base Table bChecks
Datatype [varchar](50)
Nullable NO
Domain CheckNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Account
Base Table bChecks
Datatype [varchar](50)
Nullable YES
Domain Account
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Payee
Base Table bChecks
Datatype [varchar](50)
Nullable YES
Domain Payee
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Address
Base Table bChecks
Datatype [varchar](50)
Nullable YES
Domain Address
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Date
Base Table bChecks
Datatype [datetime]
Nullable YES
Domain Date
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Amount
Base Table bChecks
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Memo
Base Table bChecks
Datatype [varchar](50)
Nullable YES
Domain Memo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


GroupID
Base Table bChecks
Datatype [varchar](50)
Nullable YES
Domain GroupID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ClearedYN
Base Table bChecks
Datatype [bit]
Nullable NO
Domain ClearedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


VoidedYN
Base Table bChecks
Datatype [bit]
Nullable NO
Domain VoidedYN
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table bChecks
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table bChecks
Datatype [PK_bChecks]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


RefNo
Base Table InventoryAdjustmentDetail
Datatype [varchar](50)
Nullable NO
Domain RefNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Item
Base Table InventoryAdjustmentDetail
Datatype [varchar](50)
Nullable NO
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table InventoryAdjustmentDetail
Datatype [nvarchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CurrentQty
Base Table InventoryAdjustmentDetail
Datatype [float]
Nullable YES
Domain CurrentQty
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


CurrentValue
Base Table InventoryAdjustmentDetail
Datatype [money]
Nullable YES
Domain CurrentValue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


NewQty
Base Table InventoryAdjustmentDetail
Datatype [float]
Nullable YES
Domain NewQty
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


NewValue
Base Table InventoryAdjustmentDetail
Datatype [money]
Nullable YES
Domain NewValue
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


QtyDifference
Base Table InventoryAdjustmentDetail
Datatype [float]
Nullable YES
Domain QtyDifference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


ValueDifference
Base Table InventoryAdjustmentDetail
Datatype [money]
Nullable YES
Domain ValueDifference
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


EditStamp
Base Table InventoryAdjustmentDetail
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table InventoryAdjustmentDetail
Datatype [PK_InventoryAdjustmentDetail]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


BillID
Base Table vpBillItems
Datatype [varchar](50)
Nullable NO
Domain BillID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


No
Base Table vpBillItems
Datatype [int]
Nullable YES
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Item
Base Table vpBillItems
Datatype [varchar](50)
Nullable YES
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Description
Base Table vpBillItems
Datatype [nvarchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Quantity
Base Table vpBillItems
Datatype [float]
Nullable YES
Domain Quantity
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Rate
Base Table vpBillItems
Datatype [money]
Nullable YES
Domain Rate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Amount
Base Table vpBillItems
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Project
Base Table vpBillItems
Datatype [varchar](50)
Nullable YES
Domain Project
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


Billable
Base Table vpBillItems
Datatype [bit]
Nullable NO
Domain Billable
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value ((0))


EditStamp
Base Table vpBillItems
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpBillItems
Datatype [PK_vpBillItems]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


InvoiceNo
Base Table csInvoiceItems
Datatype [varchar](50)
Nullable NO
Domain InvoiceNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


No
Base Table csInvoiceItems
Datatype [int]
Nullable NO
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Item
Base Table csInvoiceItems
Datatype [varchar](50)
Nullable NO
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Description
Base Table csInvoiceItems
Datatype [varchar](255)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Quantity
Base Table csInvoiceItems
Datatype [float]
Nullable YES
Domain Quantity
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Rate
Base Table csInvoiceItems
Datatype [money]
Nullable YES
Domain Rate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table csInvoiceItems
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ItemWeight
Base Table csInvoiceItems
Datatype [float]
Nullable YES
Domain ItemWeight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Shipped
Base Table csInvoiceItems
Datatype [bit]
Nullable NO
Domain Shipped
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShippedDate
Base Table csInvoiceItems
Datatype [smalldatetime]
Nullable YES
Domain ShippedDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


TrackingNumber
Base Table csInvoiceItems
Datatype [varchar](50)
Nullable YES
Domain TrackingNumber
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table csInvoiceItems
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csInvoiceItems
Datatype [PK_csInvoiceItems]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


ID
Base Table vpPurchaseOrderDetails
Datatype [int]
Nullable NO
Domain ID
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


PORef
Base Table vpPurchaseOrderDetails
Datatype [varchar](50)
Nullable YES
Domain PORef
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


No
Base Table vpPurchaseOrderDetails
Datatype [int]
Nullable YES
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Item
Base Table vpPurchaseOrderDetails
Datatype [varchar](50)
Nullable YES
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Quantity
Base Table vpPurchaseOrderDetails
Datatype [float]
Nullable YES
Domain Quantity
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ReceivedQty
Base Table vpPurchaseOrderDetails
Datatype [float]
Nullable YES
Domain ReceivedQty
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Rate
Base Table vpPurchaseOrderDetails
Datatype [money]
Nullable YES
Domain Rate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table vpPurchaseOrderDetails
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Description
Base Table vpPurchaseOrderDetails
Datatype [nvarchar](255)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Project
Base Table vpPurchaseOrderDetails
Datatype [varchar](50)
Nullable YES
Domain Project
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table vpPurchaseOrderDetails
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table vpPurchaseOrderDetails
Datatype [PK_vpPurchaseOrderDetails]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


OrderNo
Base Table csOrderItems
Datatype [varchar](50)
Nullable NO
Domain OrderNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


No
Base Table csOrderItems
Datatype [int]
Nullable NO
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Item
Base Table csOrderItems
Datatype [varchar](50)
Nullable NO
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Description
Base Table csOrderItems
Datatype [varchar](255)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Quantity
Base Table csOrderItems
Datatype [float]
Nullable YES
Domain Quantity
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Ship
Base Table csOrderItems
Datatype [float]
Nullable YES
Domain Ship
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Rate
Base Table csOrderItems
Datatype [money]
Nullable YES
Domain Rate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table csOrderItems
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ItemWeight
Base Table csOrderItems
Datatype [float]
Nullable YES
Domain ItemWeight
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


ShipDate
Base Table csOrderItems
Datatype [datetime]
Nullable YES
Domain ShipDate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


EditStamp
Base Table csOrderItems
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csOrderItems
Datatype [PK_csOrderItems]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CustomerCreditNo
Base Table csCustomerCreditItems
Datatype [varchar](50)
Nullable NO
Domain CustomerCreditNo
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


No
Base Table csCustomerCreditItems
Datatype [int]
Nullable NO
Domain No
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Item
Base Table csCustomerCreditItems
Datatype [varchar](50)
Nullable NO
Domain Item
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Description
Base Table csCustomerCreditItems
Datatype [varchar](50)
Nullable YES
Domain Description
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


Quantity
Base Table csCustomerCreditItems
Datatype [float]
Nullable YES
Domain Quantity
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Rate
Base Table csCustomerCreditItems
Datatype [money]
Nullable YES
Domain Rate
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Amount
Base Table csCustomerCreditItems
Datatype [money]
Nullable YES
Domain Amount
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


Tax
Base Table csCustomerCreditItems
Datatype [bit]
Nullable NO
Domain Tax
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value (0)


EditStamp
Base Table csCustomerCreditItems
Datatype [timestamp]
Nullable NO
Domain EditStamp
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value  


CONSTRAINT
Base Table csCustomerCreditItems
Datatype [PK_csCustomerCreditItems]
Nullable NO
Domain CONSTRAINT
Definition  

Domain Restrictions
Check Name  
Check Expresion  
Bound Rule  
Rule Value  
Bound Default  
Default Value