bCheckDetails |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[bCheckDetails] ( [CheckID] [int] NOT NULL , [InvDate] [datetime] NULL , [InvRef] [nvarchar] (20 ) NOT NULL , [InvOrigAmount] [money] NULL , [Amount] [money] NULL , [BillID] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CheckID | CheckID | [int] | NOT NULL | |
InvDate | InvDate | [datetime] | NULL | |
InvRef | InvRef | [nvarchar](20) | NOT NULL | |
InvOrigAmount | InvOrigAmount | [money] | NULL | |
Amount | Amount | [money] | NULL | |
BillID | BillID | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_bCheckDetails | PRIMARY | [CheckID], [InvRef] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
Commissions |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[Commissions] ( [ID] [int] IDENTITY (1 , 1 ) NOT NULL , [EmpName] [varchar] (50 ) NULL , [Date] [datetime] NULL , [Amount] [money] NULL , [PaidYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ID | ID | [int] | NOT NULL | |
EmpName | EmpName | [varchar](50) | NULL | |
Date | Date | [datetime] | NULL | |
Amount | Amount | [money] | NULL | |
PaidYN | PaidYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_Commissions | PRIMARY | [ID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
Company |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[Company] ( [CompanyName] [varchar] (50 ) NULL , [LegalName] [varchar] (50 ) NULL , [Address1] [varchar] (50 ) NULL , [Address2] [varchar] (50 ) NULL , [City] [varchar] (50 ) NULL , [State] [varchar] (50 ) NULL , [Zip] [varchar] (10 ) NULL , [Country] [varchar] (50 ) NULL , [Phone] [varchar] (25 ) NULL , [Fax] [varchar] (25 ) NULL , [email] [varchar] (50 ) NULL , [website] [varchar] (50 ) NULL , [FirstFiscalMonth] [varchar] (50 ) NULL , [PictureURL] [char] (10 ) NULL , [ConfirmDeletion] [bit] NOT NULL , [UseAN] [bit] NOT NULL , [DefaultCT] [int] NULL , [DefaultIT] [int] NULL , [DefaultSM] [varchar] (50 ) NULL , [AgingReportUse] [bit] NOT NULL , [TaxFreight] [bit] NOT NULL , [DefaultSalesTax] [varchar] (50 ) NULL , [ChargeHandling] [bit] NOT NULL , [HandlingAsPercent] [bit] NOT NULL , [HandlingAmount] [float] NULL , [CurrencySymbol] [varchar] (10 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CompanyName | CompanyName | [varchar](50) | NULL | |
LegalName | LegalName | [varchar](50) | NULL | |
Address1 | Address1 | [varchar](50) | NULL | |
Address2 | Address2 | [varchar](50) | NULL | |
City | City | [varchar](50) | NULL | |
State | State | [varchar](50) | NULL | |
Zip | Zip | [varchar](10) | NULL | |
Country | Country | [varchar](50) | NULL | |
Phone | Phone | [varchar](25) | NULL | |
Fax | Fax | [varchar](25) | NULL | |
[varchar](50) | NULL | |||
website | website | [varchar](50) | NULL | |
FirstFiscalMonth | FirstFiscalMonth | [varchar](50) | NULL | |
PictureURL | PictureURL | [char](10) | NULL | |
ConfirmDeletion | ConfirmDeletion | [bit] | NOT NULL | |
UseAN | UseAN | [bit] | NOT NULL | |
DefaultCT | DefaultCT | [int] | NULL | |
DefaultIT | DefaultIT | [int] | NULL | |
DefaultSM | DefaultSM | [varchar](50) | NULL | |
AgingReportUse | AgingReportUse | [bit] | NOT NULL | |
TaxFreight | TaxFreight | [bit] | NOT NULL | |
DefaultSalesTax | DefaultSalesTax | [varchar](50) | NULL | |
ChargeHandling | ChargeHandling | [bit] | NOT NULL | |
HandlingAsPercent | HandlingAsPercent | [bit] | NOT NULL | |
HandlingAmount | HandlingAmount | [float] | NULL | |
CurrencySymbol | CurrencySymbol | [varchar](10) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csCustomerPaymentDetails |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csCustomerPaymentDetails] ( [Reference] [varchar] (50 ) NOT NULL , [FID] [varchar] (50 ) NOT NULL , [ToPay] [money] NULL , [textboxAmount] [money] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
FID | FID | [varchar](50) | NOT NULL | |
ToPay | ToPay | [money] | NULL | |
textboxAmount | textboxAmount | [money] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_csCustomerPaymentDetails | PRIMARY | [Reference], [FID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csOrderTracking |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csOrderTracking] ( [OrderNo] [varchar] (50 ) NULL , [InvoiceNo] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OrderNo | OrderNo | [varchar](50) | NULL | |
InvoiceNo | InvoiceNo | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
DocNumbers |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[DocNumbers] ( [CheckNo] [int] NOT NULL , [Vouchers] [int] NOT NULL , [Orders] [int] NOT NULL , [BillPmt] [int] NOT NULL , [Invoices] [int] NOT NULL , [CustCredits] [int] NOT NULL , [CustPmt] [int] NOT NULL , [Adjustment] [int] NOT NULL , [TimeTracking] [int] NOT NULL , [Transfers] [int] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CheckNo | CheckNo | [int] | NOT NULL | |
Vouchers | Vouchers | [int] | NOT NULL | |
Orders | Orders | [int] | NOT NULL | |
BillPmt | BillPmt | [int] | NOT NULL | |
Invoices | Invoices | [int] | NOT NULL | |
CustCredits | CustCredits | [int] | NOT NULL | |
CustPmt | CustPmt | [int] | NOT NULL | |
Adjustment | Adjustment | [int] | NOT NULL | |
TimeTracking | TimeTracking | [int] | NOT NULL | |
Transfers | Transfers | [int] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
GeneralJournalDetail |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[GeneralJournalDetail] ( [EntryNo] [varchar] (50 ) NOT NULL , [No] [int] NOT NULL , [Account] [varchar] (50 ) NULL , [Debit] [money] NULL , [Credit] [money] NULL , [Memo] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EntryNo | EntryNo | [varchar](50) | NOT NULL | |
No | No | [int] | NOT NULL | |
Account | Account | [varchar](50) | NULL | |
Debit | Debit | [money] | NULL | |
Credit | Credit | [money] | NULL | |
Memo | Memo | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_GeneralJournalDetail | PRIMARY | [EntryNo], [No] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
GeneralJournalEntry |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[GeneralJournalEntry] ( [EntryNo] [nvarchar] (20 ) NOT NULL , [Date] [datetime] NULL , [TrType] [int] NULL , [TrID] [varchar] (50 ) NULL , [SystemGenerated] [bit] NOT NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EntryNo | EntryNo | [nvarchar](20) | NOT NULL | |
Date | Date | [datetime] | NULL | |
TrType | TrType | [int] | NULL | |
TrID | TrID | [varchar](50) | NULL | |
SystemGenerated | SystemGenerated | [bit] | NOT NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_GeneralJournalEntry | PRIMARY | [EntryNo] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
GLWorkDetail |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[GLWorkDetail] ( [GLID] [varchar] (50 ) NOT NULL , [No] [char] (10 ) NOT NULL , [Credit] [money] NULL , [Debit] [money] NULL , [Memo] [varchar] (50 ) NULL , [Account] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
GLID | GLID | [varchar](50) | NOT NULL | |
No | No | [char](10) | NOT NULL | |
Credit | Credit | [money] | NULL | |
Debit | Debit | [money] | NULL | |
Memo | Memo | [varchar](50) | NULL | |
Account | Account | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_GLWorkDetail | PRIMARY | [GLID], [No] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsAccountTypes |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsAccountTypes] ( [Description] [varchar] (50 ) NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Description | Description | [varchar](50) | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
aaaaalsAccountType_PK | PRIMARY | [Description] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsClasses |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsClasses] ( [ClassName] [varchar] (50 ) NOT NULL , [Subclass] [bit] NOT NULL , [ClassName1] [varchar] (50 ) NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ClassName | ClassName | [varchar](50) | NOT NULL | |
Subclass | Subclass | [bit] | NOT NULL | |
ClassName1 | ClassName1 | [varchar](50) | NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsClasses | PRIMARY | [ClassName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsCustomerMessages |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsCustomerMessages] ( [CustomerMessage] [varchar] (50 ) NOT NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CustomerMessage | CustomerMessage | [varchar](50) | NOT NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsCustomerMessages | PRIMARY | [CustomerMessage] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsCustomersShipTo |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsCustomersShipTo] ( [CustomerName] [varchar] (50 ) NULL , [ShippingAddress] [varchar] (50 ) NULL , [City] [varchar] (50 ) NULL , [State] [varchar] (10 ) NULL , [Zip] [varchar] (10 ) NULL , [Country] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CustomerName | CustomerName | [varchar](50) | NULL | |
ShippingAddress | ShippingAddress | [varchar](50) | NULL | |
City | City | [varchar](50) | NULL | |
State | State | [varchar](10) | NULL | |
Zip | Zip | [varchar](10) | NULL | |
Country | Country | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsCustomerTypes |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsCustomerTypes] ( [CustomerType] [varchar] (50 ) NOT NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CustomerType | CustomerType | [varchar](50) | NOT NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsCustomerTypes | PRIMARY | [CustomerType] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsItemCategories |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsItemCategories] ( [CategoryID] [varchar] (50 ) NOT NULL , [Description] [varchar] (50 ) NULL , [PictureURL] [varchar] (50 ) NULL , [familyID] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CategoryID | CategoryID | [varchar](50) | NOT NULL | |
Description | Description | [varchar](50) | NULL | |
PictureURL | PictureURL | [varchar](50) | NULL | |
familyID | familyID | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsItemCategories | PRIMARY | [CategoryID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsItemFamilies |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsItemFamilies] ( [FamilyID] [varchar] (50 ) NOT NULL , [Description] [varchar] (50 ) NULL , [PictureURL] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
FamilyID | FamilyID | [varchar](50) | NOT NULL | |
Description | Description | [varchar](50) | NULL | |
PictureURL | PictureURL | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsItemFamilies | PRIMARY | [FamilyID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsMemorized |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsMemorized] ( [Name] [varchar] (50 ) NOT NULL , [TrType] [varchar] (20 ) NULL , [TransID] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Name | Name | [varchar](50) | NOT NULL | |
TrType | TrType | [varchar](20) | NULL | |
TransID | TransID | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsMemorized | PRIMARY | [Name] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsPaymentMethods |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsPaymentMethods] ( [PaymentMethod] [nvarchar] (20 ) NOT NULL , [ExternalAccess] [bit] NOT NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PaymentMethod | PaymentMethod | [nvarchar](20) | NOT NULL | |
ExternalAccess | ExternalAccess | [bit] | NOT NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsPaymentMethods | PRIMARY | [PaymentMethod] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsShippingMethods |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsShippingMethods] ( [ShippingMethod] [varchar] (50 ) NOT NULL , [AccountNo] [varchar] (50 ) NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ShippingMethod | ShippingMethod | [varchar](50) | NOT NULL | |
AccountNo | AccountNo | [varchar](50) | NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsShippingMethods | PRIMARY | [ShippingMethod] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsTaxGroupDetail |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsTaxGroupDetail] ( [GrpID] [varchar] (10 ) NULL , [TaxID] [varchar] (10 ) NULL , [Description] [varchar] (50 ) NULL , [Account] [varchar] (50 ) NULL , [TaxPercent] [float] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
GrpID | GrpID | [varchar](10) | NULL | |
TaxID | TaxID | [varchar](10) | NULL | |
Description | Description | [varchar](50) | NULL | |
Account | Account | [varchar](50) | NULL | |
TaxPercent | TaxPercent | [float] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsTaxGroups |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsTaxGroups] ( [TaxGroupID] [varchar] (10 ) NOT NULL , [TaxGroupName] [varchar] (50 ) NULL , [TotalPercent] [float] NULL , [Inactive] [bit] NOT NULL , [IsDefault] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TaxGroupID | TaxGroupID | [varchar](10) | NOT NULL | |
TaxGroupName | TaxGroupName | [varchar](50) | NULL | |
TotalPercent | TotalPercent | [float] | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
IsDefault | IsDefault | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsTaxGroups | PRIMARY | [TaxGroupID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsTerms |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsTerms] ( [Term] [varchar] (50 ) NOT NULL , [Standard] [bit] NOT NULL , [DayTillNetDue] [smallint] NULL , [Discount] [float] NULL , [DaysTillDiscountExpires] [smallint] NULL , [DayOfMonthNetDue] [smallint] NULL , [DueNextMonthIfWithinDays] [smallint] NULL , [Discount1] [float] NULL , [DayDiscountExpires] [smallint] NULL , [Inactive] [bit] NOT NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Term | Term | [varchar](50) | NOT NULL | |
Standard | Standard | [bit] | NOT NULL | |
DayTillNetDue | DayTillNetDue | [smallint] | NULL | |
Discount | Discount | [float] | NULL | |
DaysTillDiscountExpires | DaysTillDiscountExpires | [smallint] | NULL | |
DayOfMonthNetDue | DayOfMonthNetDue | [smallint] | NULL | |
DueNextMonthIfWithinDays | DueNextMonthIfWithinDays | [smallint] | NULL | |
Discount1 | Discount1 | [float] | NULL | |
DayDiscountExpires | DayDiscountExpires | [smallint] | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
upsize_ts | upsize_ts | [timestamp] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsTerms | PRIMARY | [Term] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsVendorTypes |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsVendorTypes] ( [VendorType] [nvarchar] (30 ) NOT NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
VendorType | VendorType | [nvarchar](30) | NOT NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsVendorTypes | PRIMARY | [VendorType] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
Months |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[Months] ( [MonthID] [int] NULL , [Name] [nvarchar] (20 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
MonthID | MonthID | [int] | NULL | |
Name | Name | [nvarchar](20) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
OpBalWork |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[OpBalWork] ( [AccountID] [varchar] (50 ) NULL , [AccBalType] [int] NULL , [OpeningBalance] [float] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
AccountID | AccountID | [varchar](50) | NULL | |
AccBalType | AccBalType | [int] | NULL | |
OpeningBalance | OpeningBalance | [float] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
Users |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[Users] ( [Username] [varchar] (20 ) NOT NULL , [Password] [varchar] (20 ) NULL , [UserID] [varchar] (20 ) NULL , [SecurityID] [varchar] (1 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Username | Username | [varchar](20) | NOT NULL | |
Password | Password | [varchar](20) | NULL | |
UserID | UserID | [varchar](20) | NULL | |
SecurityID | SecurityID | [varchar](1) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_Users | PRIMARY | [Username] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpBillPaymentDetails |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpBillPaymentDetails] ( [Reference] [varchar] (50 ) NOT NULL , [FID] [varchar] (50 ) NOT NULL , [textboxAmount] [money] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
FID | FID | [varchar](50) | NOT NULL | |
textboxAmount | textboxAmount | [money] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_vpBillPaymentDetails | PRIMARY | [Reference], [FID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsAccounts |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsAccounts] ( [AccountNumber] [varchar] (10 ) NULL , [AccountName] [varchar] (50 ) NOT NULL , [AccountType] [varchar] (50 ) NULL , [Subaccount] [bit] NOT NULL , [AccountName1] [varchar] (50 ) NULL , [Description] [varchar] (50 ) NULL , [OpeningBalance] [money] NULL , [Date] [datetime] NULL , [Inactive] [bit] NOT NULL , [Balance] [money] NULL , [BalanceType] [smallint] NULL , [Modified] [smallint] NULL , [OpBalID] [int] IDENTITY (1 , 1 ) NOT NULL , [IsDefault] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
AccountNumber | AccountNumber | [varchar](10) | NULL | |
AccountName | AccountName | [varchar](50) | NOT NULL | |
AccountType | AccountType | [varchar](50) | NULL | |
Subaccount | Subaccount | [bit] | NOT NULL | |
AccountName1 | AccountName1 | [varchar](50) | NULL | |
Description | Description | [varchar](50) | NULL | |
OpeningBalance | OpeningBalance | [money] | NULL | |
Date | Date | [datetime] | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
Balance | Balance | [money] | NULL | |
BalanceType | BalanceType | [smallint] | NULL | |
Modified | Modified | [smallint] | NULL | |
OpBalID | OpBalID | [int] | NOT NULL | |
IsDefault | IsDefault | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsAccounts | PRIMARY | [AccountName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
bChecks |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[bChecks] ( [CheckID] [int] IDENTITY (1 , 1 ) NOT NULL , [CheckNo] [varchar] (50 ) NOT NULL , [Account] [varchar] (50 ) NULL , [Payee] [varchar] (50 ) NULL , [Address] [varchar] (50 ) NULL , [Date] [datetime] NULL , [Amount] [money] NULL , [Memo] [varchar] (50 ) NULL , [GroupID] [varchar] (50 ) NULL , [ClearedYN] [bit] NOT NULL , [VoidedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CheckID | CheckID | [int] | NOT NULL | |
CheckNo | CheckNo | [varchar](50) | NOT NULL | |
Account | Account | [varchar](50) | NULL | |
Payee | Payee | [varchar](50) | NULL | |
Address | Address | [varchar](50) | NULL | |
Date | Date | [datetime] | NULL | |
Amount | Amount | [money] | NULL | |
Memo | Memo | [varchar](50) | NULL | |
GroupID | GroupID | [varchar](50) | NULL | |
ClearedYN | ClearedYN | [bit] | NOT NULL | |
VoidedYN | VoidedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_bChecks | PRIMARY | [CheckID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
bTransferFunds |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[bTransferFunds] ( [Reference] [varchar] (50 ) NOT NULL , [FromAccount] [varchar] (50 ) NULL , [ToAccount] [varchar] (50 ) NULL , [Date] [datetime] NULL , [Amount] [money] NULL , [Memo] [nvarchar] (50 ) NULL , [ClearedYN] [bit] NOT NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
FromAccount | FromAccount | [varchar](50) | NULL | |
ToAccount | ToAccount | [varchar](50) | NULL | |
Date | Date | [datetime] | NULL | |
Amount | Amount | [money] | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
ClearedYN | ClearedYN | [bit] | NOT NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_bTransferFunds | PRIMARY | [Reference] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
EmpChecks |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[EmpChecks] ( [CheckID] [int] IDENTITY (1 , 1 ) NOT NULL , [CheckNo] [int] NULL , [Account] [varchar] (50 ) NULL , [Payee] [varchar] (50 ) NULL , [Amount] [money] NULL , [Address] [varchar] (255 ) NULL , [Date] [datetime] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CheckID | CheckID | [int] | NOT NULL | |
CheckNo | CheckNo | [int] | NULL | |
Account | Account | [varchar](50) | NULL | |
Payee | Payee | [varchar](50) | NULL | |
Amount | Amount | [money] | NULL | |
Address | Address | [varchar](255) | NULL | |
Date | Date | [datetime] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_EmpChecks | PRIMARY | [CheckID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
InventoryAdjustments |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[InventoryAdjustments] ( [Date] [datetime] NULL , [RefNo] [varchar] (50 ) NOT NULL , [AdjustmentAccount] [varchar] (50 ) NULL , [Customer] [varchar] (50 ) NULL , [Memo] [nvarchar] (50 ) NULL , [TotalValue] [money] NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Date | Date | [datetime] | NULL | |
RefNo | RefNo | [varchar](50) | NOT NULL | |
AdjustmentAccount | AdjustmentAccount | [varchar](50) | NULL | |
Customer | Customer | [varchar](50) | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
TotalValue | TotalValue | [money] | NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
aaaaaInventoryAdjustment_PK | PRIMARY | [RefNo] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsEmployees |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsEmployees] ( [EmployeeName] [varchar] (50 ) NOT NULL , [SalesmanID] [varchar] (10 ) NULL , [Initials] [nvarchar] (30 ) NULL , [TaxID] [nvarchar] (20 ) NULL , [MrMs] [nvarchar] (10 ) NULL , [FirstName] [nvarchar] (20 ) NULL , [MiddleInitial] [nvarchar] (10 ) NULL , [LastName] [nvarchar] (20 ) NULL , [Address1] [nvarchar] (50 ) NULL , [Address2] [nvarchar] (50 ) NULL , [City] [nvarchar] (50 ) NULL , [State] [nvarchar] (10 ) NULL , [Zip] [nvarchar] (10 ) NULL , [Country] [nvarchar] (50 ) NULL , [Phone] [nvarchar] (25 ) NULL , [email] [nvarchar] (30 ) NULL , [Account] [varchar] (50 ) NULL , [Inactive] [bit] NOT NULL , [PasswordTTA] [nvarchar] (20 ) NULL , [YN1099] [bit] NOT NULL , [CommissionYN] [bit] NOT NULL , [CommissionRate] [float] NULL , [Commission] [money] NULL , [Refferal] [int] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EmployeeName | EmployeeName | [varchar](50) | NOT NULL | |
SalesmanID | SalesmanID | [varchar](10) | NULL | |
Initials | Initials | [nvarchar](30) | NULL | |
TaxID | TaxID | [nvarchar](20) | NULL | |
MrMs | MrMs | [nvarchar](10) | NULL | |
FirstName | FirstName | [nvarchar](20) | NULL | |
MiddleInitial | MiddleInitial | [nvarchar](10) | NULL | |
LastName | LastName | [nvarchar](20) | NULL | |
Address1 | Address1 | [nvarchar](50) | NULL | |
Address2 | Address2 | [nvarchar](50) | NULL | |
City | City | [nvarchar](50) | NULL | |
State | State | [nvarchar](10) | NULL | |
Zip | Zip | [nvarchar](10) | NULL | |
Country | Country | [nvarchar](50) | NULL | |
Phone | Phone | [nvarchar](25) | NULL | |
[nvarchar](30) | NULL | |||
Account | Account | [varchar](50) | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
PasswordTTA | PasswordTTA | [nvarchar](20) | NULL | |
YN1099 | YN1099 | [bit] | NOT NULL | |
CommissionYN | CommissionYN | [bit] | NOT NULL | |
CommissionRate | CommissionRate | [float] | NULL | |
Commission | Commission | [money] | NULL | |
Refferal | Refferal | [int] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsEmployees | PRIMARY | [EmployeeName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsItems |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsItems] ( [ItemType] [int] NULL , [CategoryID] [varchar] (50 ) NULL , [ItemName] [varchar] (50 ) NOT NULL , [Subitem] [bit] NOT NULL , [ItemName1] [varchar] (50 ) NULL , [PurchaseDescription] [varchar] (50 ) NULL , [Cost] [money] NULL , [COGSAccount] [varchar] (50 ) NULL , [PrefferedVendor] [varchar] (50 ) NULL , [SalesDescription] [varchar] (50 ) NULL , [IncomeAccount] [varchar] (50 ) NULL , [SalesPrice] [money] NULL , [Taxable] [bit] NOT NULL , [AssetAccount] [varchar] (50 ) NULL , [QuantityOnHand] [int] NULL , [TotalValue] [float] NULL , [ReorderPoint] [int] NULL , [ItemWeight] [float] NULL , [Inactive] [bit] NOT NULL , [PictureURL] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ItemType | ItemType | [int] | NULL | |
CategoryID | CategoryID | [varchar](50) | NULL | |
ItemName | ItemName | [varchar](50) | NOT NULL | |
Subitem | Subitem | [bit] | NOT NULL | |
ItemName1 | ItemName1 | [varchar](50) | NULL | |
PurchaseDescription | PurchaseDescription | [varchar](50) | NULL | |
Cost | Cost | [money] | NULL | |
COGSAccount | COGSAccount | [varchar](50) | NULL | |
PrefferedVendor | PrefferedVendor | [varchar](50) | NULL | |
SalesDescription | SalesDescription | [varchar](50) | NULL | |
IncomeAccount | IncomeAccount | [varchar](50) | NULL | |
SalesPrice | SalesPrice | [money] | NULL | |
Taxable | Taxable | [bit] | NOT NULL | |
AssetAccount | AssetAccount | [varchar](50) | NULL | |
QuantityOnHand | QuantityOnHand | [int] | NULL | |
TotalValue | TotalValue | [float] | NULL | |
ReorderPoint | ReorderPoint | [int] | NULL | |
ItemWeight | ItemWeight | [float] | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
PictureURL | PictureURL | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsItems | PRIMARY | [ItemName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsTaxes |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsTaxes] ( [TaxID] [varchar] (10 ) NOT NULL , [Description] [varchar] (50 ) NULL , [TaxPercent] [float] NULL , [Account] [varchar] (50 ) NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
TaxID | TaxID | [varchar](10) | NOT NULL | |
Description | Description | [varchar](50) | NULL | |
TaxPercent | TaxPercent | [float] | NULL | |
Account | Account | [varchar](50) | NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsTaxes | PRIMARY | [TaxID] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsVendors |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsVendors] ( [VendorName] [varchar] (50 ) NOT NULL , [Company] [varchar] (50 ) NULL , [MrMs] [varchar] (10 ) NULL , [FirstName] [varchar] (20 ) NULL , [MiddleInitial] [varchar] (10 ) NULL , [LastName] [varchar] (20 ) NULL , [Contact] [varchar] (30 ) NULL , [Address1] [varchar] (50 ) NULL , [Address2] [varchar] (50 ) NULL , [City] [varchar] (50 ) NULL , [State] [varchar] (50 ) NULL , [Zip] [varchar] (10 ) NULL , [Country] [varchar] (50 ) NULL , [Phone] [varchar] (25 ) NULL , [Fax] [varchar] (25 ) NULL , [AltPhone] [varchar] (25 ) NULL , [AltContact] [varchar] (30 ) NULL , [PrintOnCheckAs] [varchar] (30 ) NULL , [AccountNumber] [varchar] (50 ) NULL , [DefaultExpenseAccount] [varchar] (50 ) NULL , [VendorType] [varchar] (50 ) NULL , [Term] [varchar] (50 ) NULL , [PMID] [int] IDENTITY (1 , 1 ) NOT NULL , [CreditLimit] [money] NULL , [TaxID] [varchar] (20 ) NULL , [Eligible] [bit] NOT NULL , [Email] [varchar] (30 ) NULL , [OpeningBalance] [money] NULL , [OpeningBalanceDate] [datetime] NULL , [Balance] [money] NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
VendorName | VendorName | [varchar](50) | NOT NULL | |
Company | Company | [varchar](50) | NULL | |
MrMs | MrMs | [varchar](10) | NULL | |
FirstName | FirstName | [varchar](20) | NULL | |
MiddleInitial | MiddleInitial | [varchar](10) | NULL | |
LastName | LastName | [varchar](20) | NULL | |
Contact | Contact | [varchar](30) | NULL | |
Address1 | Address1 | [varchar](50) | NULL | |
Address2 | Address2 | [varchar](50) | NULL | |
City | City | [varchar](50) | NULL | |
State | State | [varchar](50) | NULL | |
Zip | Zip | [varchar](10) | NULL | |
Country | Country | [varchar](50) | NULL | |
Phone | Phone | [varchar](25) | NULL | |
Fax | Fax | [varchar](25) | NULL | |
AltPhone | AltPhone | [varchar](25) | NULL | |
AltContact | AltContact | [varchar](30) | NULL | |
PrintOnCheckAs | PrintOnCheckAs | [varchar](30) | NULL | |
AccountNumber | AccountNumber | [varchar](50) | NULL | |
DefaultExpenseAccount | DefaultExpenseAccount | [varchar](50) | NULL | |
VendorType | VendorType | [varchar](50) | NULL | |
Term | Term | [varchar](50) | NULL | |
PMID | PMID | [int] | NOT NULL | |
CreditLimit | CreditLimit | [money] | NULL | |
TaxID | TaxID | [varchar](20) | NULL | |
Eligible | Eligible | [bit] | NOT NULL | |
[varchar](30) | NULL | |||
OpeningBalance | OpeningBalance | [money] | NULL | |
OpeningBalanceDate | OpeningBalanceDate | [datetime] | NULL | |
Balance | Balance | [money] | NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsVendors | PRIMARY | [VendorName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpBillExpenses |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpBillExpenses] ( [Reference] [varchar] (50 ) NULL , [No] [int] NULL , [Account] [varchar] (50 ) NULL , [Amount] [money] NULL , [Memo] [varchar] (50 ) NULL , [Project] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NULL | |
No | No | [int] | NULL | |
Account | Account | [varchar](50) | NULL | |
Amount | Amount | [money] | NULL | |
Memo | Memo | [varchar](50) | NULL | |
Project | Project | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csCustomerCreditItems |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csCustomerCreditItems] ( [CustomerCreditNo] [varchar] (50 ) NOT NULL , [No] [int] NOT NULL , [Item] [varchar] (50 ) NOT NULL , [Description] [varchar] (50 ) NULL , [Quantity] [float] NULL , [Rate] [money] NULL , [Amount] [money] NULL , [Tax] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CustomerCreditNo | CustomerCreditNo | [varchar](50) | NOT NULL | |
No | No | [int] | NOT NULL | |
Item | Item | [varchar](50) | NOT NULL | |
Description | Description | [varchar](50) | NULL | |
Quantity | Quantity | [float] | NULL | |
Rate | Rate | [money] | NULL | |
Amount | Amount | [money] | NULL | |
Tax | Tax | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_csCustomerCreditItems | PRIMARY | [CustomerCreditNo], [No] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csInvoiceItems |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csInvoiceItems] ( [InvoiceNo] [varchar] (50 ) NOT NULL , [No] [int] NOT NULL , [Item] [varchar] (50 ) NOT NULL , [Description] [varchar] (255 ) NULL , [Quantity] [float] NULL , [Rate] [money] NULL , [Amount] [money] NULL , [ItemWeight] [float] NULL , [Shipped] [bit] NOT NULL , [ShippedDate] [smalldatetime] NULL , [TrackingNumber] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
InvoiceNo | InvoiceNo | [varchar](50) | NOT NULL | |
No | No | [int] | NOT NULL | |
Item | Item | [varchar](50) | NOT NULL | |
Description | Description | [varchar](255) | NULL | |
Quantity | Quantity | [float] | NULL | |
Rate | Rate | [money] | NULL | |
Amount | Amount | [money] | NULL | |
ItemWeight | ItemWeight | [float] | NULL | |
Shipped | Shipped | [bit] | NOT NULL | |
ShippedDate | ShippedDate | [smalldatetime] | NULL | |
TrackingNumber | TrackingNumber | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_csInvoiceItems | PRIMARY | [InvoiceNo], [No] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csOrderItems |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csOrderItems] ( [OrderNo] [varchar] (50 ) NOT NULL , [No] [int] NOT NULL , [Item] [varchar] (50 ) NOT NULL , [Description] [varchar] (255 ) NULL , [Quantity] [float] NULL , [Ship] [float] NULL , [Rate] [money] NULL , [Amount] [money] NULL , [ItemWeight] [float] NULL , [ShipDate] [datetime] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
OrderNo | OrderNo | [varchar](50) | NOT NULL | |
No | No | [int] | NOT NULL | |
Item | Item | [varchar](50) | NOT NULL | |
Description | Description | [varchar](255) | NULL | |
Quantity | Quantity | [float] | NULL | |
Ship | Ship | [float] | NULL | |
Rate | Rate | [money] | NULL | |
Amount | Amount | [money] | NULL | |
ItemWeight | ItemWeight | [float] | NULL | |
ShipDate | ShipDate | [datetime] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_csOrderItems | PRIMARY | [OrderNo], [No] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
InventoryAdjustmentDetail |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[InventoryAdjustmentDetail] ( [RefNo] [varchar] (50 ) NULL , [Item] [varchar] (50 ) NULL , [Description] [nvarchar] (50 ) NULL , [CurrentQty] [float] NULL , [CurrentValue] [money] NULL , [NewQty] [float] NULL , [NewValue] [money] NULL , [QtyDifference] [float] NULL , [ValueDifference] [money] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
RefNo | RefNo | [varchar](50) | NULL | |
Item | Item | [varchar](50) | NULL | |
Description | Description | [nvarchar](50) | NULL | |
CurrentQty | CurrentQty | [float] | NULL | |
CurrentValue | CurrentValue | [money] | NULL | |
NewQty | NewQty | [float] | NULL | |
NewValue | NewValue | [money] | NULL | |
QtyDifference | QtyDifference | [float] | NULL | |
ValueDifference | ValueDifference | [money] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsCustomers |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsCustomers] ( [Login] [varchar] (50 ) NULL , [Password] [varchar] (50 ) NULL , [CustomerName] [varchar] (50 ) NOT NULL , [Company] [varchar] (50 ) NULL , [MrMs] [varchar] (50 ) NULL , [FirstName] [varchar] (50 ) NULL , [MiddleInitial] [varchar] (50 ) NULL , [LastName] [varchar] (50 ) NULL , [BillingAddress1] [varchar] (50 ) NULL , [BillingAddress2] [varchar] (50 ) NULL , [City] [varchar] (50 ) NULL , [State] [varchar] (50 ) NULL , [Zip] [varchar] (50 ) NULL , [Country] [varchar] (50 ) NULL , [Contact] [varchar] (50 ) NULL , [Phone] [varchar] (50 ) NULL , [Email] [varchar] (50 ) NULL , [Fax] [varchar] (50 ) NULL , [AltPhone] [varchar] (50 ) NULL , [AltContact] [varchar] (50 ) NULL , [Account] [varchar] (50 ) NULL , [CustomerType] [varchar] (50 ) NULL , [Term] [varchar] (50 ) NULL , [Rep] [varchar] (50 ) NULL , [CreditLimit] [float] NULL , [Taxable] [bit] NOT NULL , [TaxItem] [varchar] (50 ) NULL , [ResaleNumber] [varchar] (50 ) NULL , [OpeningBalance] [money] NULL , [OpeningBalanceDate] [datetime] NULL , [Inactive] [bit] NOT NULL , [PasswordCA] [varchar] (50 ) NULL , [Balance] [money] NULL , [ExistingCredit] [money] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Login | Login | [varchar](50) | NULL | |
Password | Password | [varchar](50) | NULL | |
CustomerName | CustomerName | [varchar](50) | NOT NULL | |
Company | Company | [varchar](50) | NULL | |
MrMs | MrMs | [varchar](50) | NULL | |
FirstName | FirstName | [varchar](50) | NULL | |
MiddleInitial | MiddleInitial | [varchar](50) | NULL | |
LastName | LastName | [varchar](50) | NULL | |
BillingAddress1 | BillingAddress1 | [varchar](50) | NULL | |
BillingAddress2 | BillingAddress2 | [varchar](50) | NULL | |
City | City | [varchar](50) | NULL | |
State | State | [varchar](50) | NULL | |
Zip | Zip | [varchar](50) | NULL | |
Country | Country | [varchar](50) | NULL | |
Contact | Contact | [varchar](50) | NULL | |
Phone | Phone | [varchar](50) | NULL | |
[varchar](50) | NULL | |||
Fax | Fax | [varchar](50) | NULL | |
AltPhone | AltPhone | [varchar](50) | NULL | |
AltContact | AltContact | [varchar](50) | NULL | |
Account | Account | [varchar](50) | NULL | |
CustomerType | CustomerType | [varchar](50) | NULL | |
Term | Term | [varchar](50) | NULL | |
Rep | Rep | [varchar](50) | NULL | |
CreditLimit | CreditLimit | [float] | NULL | |
Taxable | Taxable | [bit] | NOT NULL | |
TaxItem | TaxItem | [varchar](50) | NULL | |
ResaleNumber | ResaleNumber | [varchar](50) | NULL | |
OpeningBalance | OpeningBalance | [money] | NULL | |
OpeningBalanceDate | OpeningBalanceDate | [datetime] | NULL | |
Inactive | Inactive | [bit] | NOT NULL | |
PasswordCA | PasswordCA | [varchar](50) | NULL | |
Balance | Balance | [money] | NULL | |
ExistingCredit | ExistingCredit | [money] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_lsCustomers | PRIMARY | [CustomerName] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
TimeTracking |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[TimeTracking] ( [Reference] [varchar] (50 ) NOT NULL , [Employee] [varchar] (50 ) NULL , [Date] [datetime] NULL , [Customer] [varchar] (50 ) NULL , [ServiceItem] [varchar] (50 ) NULL , [Class] [varchar] (50 ) NULL , [Duration] [float] NULL , [Memo] [nvarchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
Employee | Employee | [varchar](50) | NULL | |
Date | Date | [datetime] | NULL | |
Customer | Customer | [varchar](50) | NULL | |
ServiceItem | ServiceItem | [varchar](50) | NULL | |
Class | Class | [varchar](50) | NULL | |
Duration | Duration | [float] | NULL | |
Memo | Memo | [nvarchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
aaaaaTimeTracking_PK | PRIMARY | [Reference] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpBillItems |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpBillItems] ( [BillID] [varchar] (50 ) NULL , [No] [int] NULL , [Item] [varchar] (50 ) NULL , [Description] [nvarchar] (50 ) NULL , [Quantity] [float] NULL , [Rate] [money] NULL , [Amount] [money] NULL , [Project] [varchar] (50 ) NULL , [Billable] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
BillID | BillID | [varchar](50) | NULL | |
No | No | [int] | NULL | |
Item | Item | [varchar](50) | NULL | |
Description | Description | [nvarchar](50) | NULL | |
Quantity | Quantity | [float] | NULL | |
Rate | Rate | [money] | NULL | |
Amount | Amount | [money] | NULL | |
Project | Project | [varchar](50) | NULL | |
Billable | Billable | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpBillPayments |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpBillPayments] ( [Reference] [varchar] (50 ) NOT NULL , [Account] [varchar] (50 ) NULL , [ToBePrinted] [bit] NOT NULL , [Vendor] [varchar] (50 ) NULL , [Date] [datetime] NULL , [CheckNo] [nvarchar] (20 ) NULL , [Amount] [money] NULL , [Memo] [nvarchar] (50 ) NULL , [ClearedYN] [bit] NOT NULL , [LastCheckNo] [int] NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
Account | Account | [varchar](50) | NULL | |
ToBePrinted | ToBePrinted | [bit] | NOT NULL | |
Vendor | Vendor | [varchar](50) | NULL | |
Date | Date | [datetime] | NULL | |
CheckNo | CheckNo | [nvarchar](20) | NULL | |
Amount | Amount | [money] | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
ClearedYN | ClearedYN | [bit] | NOT NULL | |
LastCheckNo | LastCheckNo | [int] | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
aaaaavpBillPayment_PK | PRIMARY | [Reference] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpBills |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpBills] ( [Date] [datetime] NULL , [Vendor] [varchar] (50 ) NULL , [Reference] [varchar] (20 ) NOT NULL , [Type] [varchar] (20 ) NULL , [Term] [varchar] (50 ) NULL , [DueDate] [datetime] NULL , [VendorInvoice] [nvarchar] (20 ) NULL , [Freight] [money] NULL , [Discount] [money] NULL , [OtherCharges] [money] NULL , [Amount] [money] NULL , [Memo] [nvarchar] (50 ) NULL , [PayAmount] [money] NULL , [DueAmount] [money] NULL , [PORef] [varchar] (50 ) NULL , [PmtID] [int] IDENTITY (1 , 1 ) NOT NULL , [PayYN] [bit] NOT NULL , [CheckID] [int] NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Date | Date | [datetime] | NULL | |
Vendor | Vendor | [varchar](50) | NULL | |
Reference | Reference | [varchar](20) | NOT NULL | |
Type | Type | [varchar](20) | NULL | |
Term | Term | [varchar](50) | NULL | |
DueDate | DueDate | [datetime] | NULL | |
VendorInvoice | VendorInvoice | [nvarchar](20) | NULL | |
Freight | Freight | [money] | NULL | |
Discount | Discount | [money] | NULL | |
OtherCharges | OtherCharges | [money] | NULL | |
Amount | Amount | [money] | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
PayAmount | PayAmount | [money] | NULL | |
DueAmount | DueAmount | [money] | NULL | |
PORef | PORef | [varchar](50) | NULL | |
PmtID | PmtID | [int] | NOT NULL | |
PayYN | PayYN | [bit] | NOT NULL | |
CheckID | CheckID | [int] | NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_vpBills | PRIMARY | [Reference] |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpPurchaseOrderDetails |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpPurchaseOrderDetails] ( [ID] [int] IDENTITY (1 , 1 ) NOT NULL , [PORef] [varchar] (50 ) NULL , [No] [int] NULL , [Item] [varchar] (50 ) NULL , [Quantity] [float] NULL , [ReceivedQty] [float] NULL , [Rate] [money] NULL , [Amount] [money] NULL , [Description] [nvarchar] (255 ) NULL , [Project] [varchar] (50 ) NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ID | ID | [int] | NOT NULL | |
PORef | PORef | [varchar](50) | NULL | |
No | No | [int] | NULL | |
Item | Item | [varchar](50) | NULL | |
Quantity | Quantity | [float] | NULL | |
ReceivedQty | ReceivedQty | [float] | NULL | |
Rate | Rate | [money] | NULL | |
Amount | Amount | [money] | NULL | |
Description | Description | [nvarchar](255) | NULL | |
Project | Project | [varchar](50) | NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
vpPurchaseOrders |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[vpPurchaseOrders] ( [PORef] [varchar] (50 ) NOT NULL , [Date] [datetime] NULL , [DueDate] [datetime] NULL , [Term] [varchar] (50 ) NULL , [Vendor] [varchar] (50 ) NULL , [Class] [varchar] (50 ) NULL , [Memo] [nvarchar] (50 ) NULL , [BillTo] [varchar] (50 ) NULL , [ShipTo] [varchar] (50 ) NULL , [ReceiveBy] [datetime] NULL , [VendorMessage] [varchar] (50 ) NULL , [ShipVia] [varchar] (50 ) NULL , [TrackingNumber] [varchar] (50 ) NULL , [ShipToD] [nvarchar] (100 ) NULL , [VendorInvoice] [varchar] (20 ) NULL , [Freight] [money] NULL , [Discount] [float] NULL , [OtherCharges] [money] NULL , [ShippingCharge] [money] NULL , [Total] [money] NULL , [ReceivedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PORef | PORef | [varchar](50) | NOT NULL | |
Date | Date | [datetime] | NULL | |
DueDate | DueDate | [datetime] | NULL | |
Term | Term | [varchar](50) | NULL | |
Vendor | Vendor | [varchar](50) | NULL | |
Class | Class | [varchar](50) | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
BillTo | BillTo | [varchar](50) | NULL | |
ShipTo | ShipTo | [varchar](50) | NULL | |
ReceiveBy | ReceiveBy | [datetime] | NULL | |
VendorMessage | VendorMessage | [varchar](50) | NULL | |
ShipVia | ShipVia | [varchar](50) | NULL | |
TrackingNumber | TrackingNumber | [varchar](50) | NULL | |
ShipToD | ShipToD | [nvarchar](100) | NULL | |
VendorInvoice | VendorInvoice | [varchar](20) | NULL | |
Freight | Freight | [money] | NULL | |
Discount | Discount | [float] | NULL | |
OtherCharges | OtherCharges | [money] | NULL | |
ShippingCharge | ShippingCharge | [money] | NULL | |
Total | Total | [money] | NULL | |
ReceivedYN | ReceivedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csCustomerCredits |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csCustomerCredits] ( [Customer] [varchar] (50 ) NOT NULL , [Class] [varchar] (50 ) NULL , [Memo] [nvarchar] (50 ) NULL , [BillTo] [nvarchar] (100 ) NULL , [Date] [datetime] NULL , [CreditNumber] [nvarchar] (20 ) NOT NULL , [POID] [nvarchar] (20 ) NULL , [CustomerMessage] [varchar] (50 ) NULL , [Discount] [float] NULL , [Handling] [money] NULL , [Freight] [money] NULL , [SalesTax] [varchar] (50 ) NULL , [Tax] [money] NULL , [TaxTotal] [money] NULL , [Total] [money] NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Customer | Customer | [varchar](50) | NOT NULL | |
Class | Class | [varchar](50) | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
BillTo | BillTo | [nvarchar](100) | NULL | |
Date | Date | [datetime] | NULL | |
CreditNumber | CreditNumber | [nvarchar](20) | NOT NULL | |
POID | POID | [nvarchar](20) | NULL | |
CustomerMessage | CustomerMessage | [varchar](50) | NULL | |
Discount | Discount | [float] | NULL | |
Handling | Handling | [money] | NULL | |
Freight | Freight | [money] | NULL | |
SalesTax | SalesTax | [varchar](50) | NULL | |
Tax | Tax | [money] | NULL | |
TaxTotal | TaxTotal | [money] | NULL | |
Total | Total | [money] | NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csCustomerPayments |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csCustomerPayments] ( [Reference] [varchar] (50 ) NOT NULL , [Customer] [varchar] (50 ) NULL , [PaymentAmount] [money] NULL , [Date] [datetime] NULL , [PaymentMethod] [varchar] (50 ) NULL , [Memo] [varchar] (50 ) NULL , [CheckNo] [varchar] (20 ) NULL , [CreditCardNo] [varchar] (30 ) NULL , [CardExpires] [datetime] NULL , [NameOnCard] [nvarchar] (30 ) NULL , [CardZipCode] [nvarchar] (20 ) NULL , [CardApproved] [bit] NOT NULL , [UndepFunds] [bit] NOT NULL , [DepositTo] [bit] NOT NULL , [Account] [varchar] (50 ) NULL , [ApplyExistingCredits] [bit] NOT NULL , [Apply] [money] NULL , [TotalToApply] [money] NULL , [TotalApplied] [money] NULL , [UnappliedAmount] [money] NULL , [Deposit] [bit] NOT NULL , [PayAmount] [money] NULL , [ReceivedYN] [bit] NOT NULL , [ClearedYN] [bit] NOT NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Reference | Reference | [varchar](50) | NOT NULL | |
Customer | Customer | [varchar](50) | NULL | |
PaymentAmount | PaymentAmount | [money] | NULL | |
Date | Date | [datetime] | NULL | |
PaymentMethod | PaymentMethod | [varchar](50) | NULL | |
Memo | Memo | [varchar](50) | NULL | |
CheckNo | CheckNo | [varchar](20) | NULL | |
CreditCardNo | CreditCardNo | [varchar](30) | NULL | |
CardExpires | CardExpires | [datetime] | NULL | |
NameOnCard | NameOnCard | [nvarchar](30) | NULL | |
CardZipCode | CardZipCode | [nvarchar](20) | NULL | |
CardApproved | CardApproved | [bit] | NOT NULL | |
UndepFunds | UndepFunds | [bit] | NOT NULL | |
DepositTo | DepositTo | [bit] | NOT NULL | |
Account | Account | [varchar](50) | NULL | |
ApplyExistingCredits | ApplyExistingCredits | [bit] | NOT NULL | |
Apply | Apply | [money] | NULL | |
TotalToApply | TotalToApply | [money] | NULL | |
TotalApplied | TotalApplied | [money] | NULL | |
UnappliedAmount | UnappliedAmount | [money] | NULL | |
Deposit | Deposit | [bit] | NOT NULL | |
PayAmount | PayAmount | [money] | NULL | |
ReceivedYN | ReceivedYN | [bit] | NOT NULL | |
ClearedYN | ClearedYN | [bit] | NOT NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csInvoices |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csInvoices] ( [Date] [datetime] NULL , [Customer] [varchar] (50 ) NULL , [ShipToID] [varchar] (50 ) NULL , [Class] [varchar] (50 ) NULL , [Memo] [nvarchar] (50 ) NULL , [Term] [varchar] (50 ) NULL , [InvoiceNo] [nvarchar] (20 ) NOT NULL , [DueDate] [datetime] NULL , [ShipVia] [varchar] (50 ) NULL , [ShipDate] [datetime] NULL , [POID] [nvarchar] (20 ) NULL , [CustomerMessage] [varchar] (50 ) NULL , [TrackingNumber] [varchar] (30 ) NULL , [Handling] [money] NULL , [Freight] [money] NULL , [Discount] [float] NULL , [SalesTax] [varchar] (10 ) NULL , [Tax] [money] NULL , [TaxTotal] [money] NULL , [Total] [money] NULL , [TotalWeight] [float] NULL , [ShippingCharge] [money] NULL , [ApplyYN] [bit] NOT NULL , [PaidYN] [bit] NULL , [PayAmount] [money] NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Date | Date | [datetime] | NULL | |
Customer | Customer | [varchar](50) | NULL | |
ShipToID | ShipToID | [varchar](50) | NULL | |
Class | Class | [varchar](50) | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
Term | Term | [varchar](50) | NULL | |
InvoiceNo | InvoiceNo | [nvarchar](20) | NOT NULL | |
DueDate | DueDate | [datetime] | NULL | |
ShipVia | ShipVia | [varchar](50) | NULL | |
ShipDate | ShipDate | [datetime] | NULL | |
POID | POID | [nvarchar](20) | NULL | |
CustomerMessage | CustomerMessage | [varchar](50) | NULL | |
TrackingNumber | TrackingNumber | [varchar](30) | NULL | |
Handling | Handling | [money] | NULL | |
Freight | Freight | [money] | NULL | |
Discount | Discount | [float] | NULL | |
SalesTax | SalesTax | [varchar](10) | NULL | |
Tax | Tax | [money] | NULL | |
TaxTotal | TaxTotal | [money] | NULL | |
Total | Total | [money] | NULL | |
TotalWeight | TotalWeight | [float] | NULL | |
ShippingCharge | ShippingCharge | [money] | NULL | |
ApplyYN | ApplyYN | [bit] | NOT NULL | |
PaidYN | PaidYN | [bit] | NULL | |
PayAmount | PayAmount | [money] | NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
csOrders |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[csOrders] ( [Date] [datetime] NULL , [Customer] [varchar] (50 ) NULL , [ShipToID] [varchar] (50 ) NULL , [Class] [varchar] (50 ) NULL , [Memo] [nvarchar] (50 ) NULL , [Term] [varchar] (50 ) NULL , [OrderNo] [varchar] (50 ) NOT NULL , [DueDate] [datetime] NULL , [ShipVia] [varchar] (50 ) NULL , [ShipDate] [datetime] NULL , [POID] [varchar] (50 ) NULL , [CustomerMessage] [varchar] (50 ) NULL , [Discount] [float] NULL , [Freight] [money] NULL , [SalesTax] [varchar] (50 ) NULL , [Tax] [money] NULL , [TaxTotal] [money] NULL , [Total] [money] NULL , [TotalWeight] [float] NULL , [ShippingCharge] [money] NULL , [Handling] [money] NULL , [ApplyYN] [bit] NOT NULL , [Picked] [bit] NOT NULL , [Billed] [bit] NOT NULL , [Printed] [bit] NOT NULL , [Shipped] [bit] NOT NULL , [Backordered] [bit] NOT NULL , [Invoiced] [bit] NOT NULL , [TrackingNumber] [varchar] (30 ) NULL , [CCType] [varchar] (50 ) NULL , [CCName] [varchar] (50 ) NULL , [CCNumber] [varchar] (20 ) NULL , [CCExpDate] [datetime] NULL , [ApprovalNumber] [varchar] (12 ) NULL , [PostedYN] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Date | Date | [datetime] | NULL | |
Customer | Customer | [varchar](50) | NULL | |
ShipToID | ShipToID | [varchar](50) | NULL | |
Class | Class | [varchar](50) | NULL | |
Memo | Memo | [nvarchar](50) | NULL | |
Term | Term | [varchar](50) | NULL | |
OrderNo | OrderNo | [varchar](50) | NOT NULL | |
DueDate | DueDate | [datetime] | NULL | |
ShipVia | ShipVia | [varchar](50) | NULL | |
ShipDate | ShipDate | [datetime] | NULL | |
POID | POID | [varchar](50) | NULL | |
CustomerMessage | CustomerMessage | [varchar](50) | NULL | |
Discount | Discount | [float] | NULL | |
Freight | Freight | [money] | NULL | |
SalesTax | SalesTax | [varchar](50) | NULL | |
Tax | Tax | [money] | NULL | |
TaxTotal | TaxTotal | [money] | NULL | |
Total | Total | [money] | NULL | |
TotalWeight | TotalWeight | [float] | NULL | |
ShippingCharge | ShippingCharge | [money] | NULL | |
Handling | Handling | [money] | NULL | |
ApplyYN | ApplyYN | [bit] | NOT NULL | |
Picked | Picked | [bit] | NOT NULL | |
Billed | Billed | [bit] | NOT NULL | |
Printed | Printed | [bit] | NOT NULL | |
Shipped | Shipped | [bit] | NOT NULL | |
Backordered | Backordered | [bit] | NOT NULL | |
Invoiced | Invoiced | [bit] | NOT NULL | |
TrackingNumber | TrackingNumber | [varchar](30) | NULL | |
CCType | CCType | [varchar](50) | NULL | |
CCName | CCName | [varchar](50) | NULL | |
CCNumber | CCNumber | [varchar](20) | NULL | |
CCExpDate | CCExpDate | [datetime] | NULL | |
ApprovalNumber | ApprovalNumber | [varchar](12) | NULL | |
PostedYN | PostedYN | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |
lsProjects |
Definition | |
Note | |
DDL Code | CREATE TABLE [dbo].[lsProjects] ( [Customer] [varchar] (50 ) NULL , [ProjectName] [varchar] (50 ) NOT NULL , [Description] [varchar] (255 ) NULL , [ProjectManager] [varchar] (50 ) NULL , [StartDate] [datetime] NULL , [EndDate] [datetime] NULL , [Inactive] [bit] NOT NULL ) ON [PRIMARY] |
Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Customer | Customer | [varchar](50) | NULL | |
ProjectName | ProjectName | [varchar](50) | NOT NULL | |
Description | Description | [varchar](255) | NULL | |
ProjectManager | ProjectManager | [varchar](50) | NULL | |
StartDate | StartDate | [datetime] | NULL | |
EndDate | EndDate | [datetime] | NULL | |
Inactive | Inactive | [bit] | NOT NULL |
Primary and Unique Keys |
Key Name | Key Type | Keys |
Foreign Keys |
Name | Field | Parent Table | Parent Field |
Storage |
STORAGE OPTION | STORAGE VALUE |