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 |
Base Table | Company |
Datatype | [varchar](50) |
Nullable | YES |
Domain | |
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 |
Base Table | lsCustomers |
Datatype | [varchar](50) |
Nullable | YES |
Domain | |
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) |
Base Table | lsVendors |
Datatype | [varchar](30) |
Nullable | YES |
Domain | |
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 |
Base Table | lsEmployees |
Datatype | [nvarchar](30) |
Nullable | YES |
Domain | |
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 |