16/09/2008 Database Documentation Database Documentation Agent Table Key Name Data type Required Indexed Default Value AgentID int (auto-number) Yes AgentCode varchar(50) Yes SiteID int Yes CompanyName varchar(100) - ContactFirstName varchar(100) Yes ('') ContactLastName varchar(100) Yes ('') EmailAddress varchar(100) Yes EmailVerified bit Yes ((0)) ContactStreetAddress varchar(100) Yes ('') ContactStreetAddress2 varchar(100) - ('') ContactSuburb varchar(100) Yes ('') ContactState varchar(10) Yes ('') ContactPostCode varchar(10) Yes ('') CountryID nvarchar(10) Yes ('') ContactPhone varchar(100) Yes ('') ContactFax varchar(100) - ('') CommissionPercent decimal (18,10) Yes ((0)) Notes varchar(1000) - IsActive bit Yes ((1)) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ABN varchar(30) - BankBSB varchar(20) - BankName varchar(50) - BankAccountName varchar(50) - BankBranchName varchar(50) - file:///C:/Clients/TheOnlinePrinter/Co… ((1)) 1/21 16/09/2008 Database Documentation SecondContactName varchar(50) - SecondContactEmailAddress varchar(50) - SecondContactPhone varchar(50) - ContactMobile varchar(100) - BankAccountNumber varchar(50) - AgentCategoryID int - AgentCategory Table Key Name AgentCategoryID Data type Required Indexed Default Value int (auto-number) Yes AgentCategoryName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') Data type Required Indexed Default Value BulkPrice Table Key Name BulkPriceID int (auto-number) Yes ProductID varchar(20) Yes Quantity int Yes FrontColourOptionID int Yes BackColourOptionID int Yes PaperTypeID int Yes PageCount int Yes ((1)) Price money Yes ((0)) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ColourChoice Table Key Name ColourChoiceID Data type Required Indexed Default Value int file:///C:/Clients/TheOnlinePrinter/Co… Yes 2/21 16/09/2008 Database Documentation ColourChoiceName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ColourOption Table Key Name ColourOptionID Data type Required Indexed Default Value int Yes ColourOptionName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ContentData Table Key Name ContentDataID Data type Required Indexed Default Value int (auto-number) Yes ParentContentDataID int Yes SortOrder int Yes PageName nvarchar(50) Yes Title nvarchar(100) Yes Heading nvarchar(100) Yes IsVisible bit Yes SiteID int Yes ContentData text Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') MetaKeywords varchar(1000) - MetaDescription varchar(1000) - MenuCaption varchar(100) Yes ('Menu Caption') Footer text Yes ('Footer') IsMenuVisible bit Yes ((1)) file:///C:/Clients/TheOnlinePrinter/Co… ((99999)) ((1)) 3/21 16/09/2008 Database Documentation Currency Table Key Name Data type Required Indexed Default Value CurrencyID varchar(10) Yes CurrencyName nvarchar(50) Yes ConversionFactor float Yes ((1)) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') DeliveryMethod Table Key Name DeliveryMethodID Data type Required Indexed Default Value int (auto-number) Yes DeliveryMethodName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') DesignTemplate Table Key Name Data type Required Indexed Default Value varchar(20) Yes DesignTemplateName varchar(50) Yes DesignTemplateID Notes varchar(1000) - CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FileTransferMethod Table Key Name FileTransferMethodID Data type Required Indexed Default Value int (auto-number) Yes FileTransferMethodName varchar(100) Yes CreateDate Yes file:///C:/Clients/TheOnlinePrinter/Co… datetime =getdate() 4/21 16/09/2008 Database Documentation LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FoldingChoice Table Key Name FoldingChoiceID Data type Required Indexed Default Value int Yes FoldingChoiceName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FoldingCost Table Key Name Data type Required Indexed Default Value ItemCount int Yes FoldingCost money Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FoldingOption Table Key Name FoldingOptionID Data type Required Indexed Default Value int Yes FoldingOptionName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FreightCountry Table Key Name Data type Required Indexed Default Value CountryID nvarchar(10) Yes CountryName nvarchar(50) Yes FreightZoneInternationalID int file:///C:/Clients/TheOnlinePrinter/Co… Yes 5/21 16/09/2008 Database Documentation DeliveryTime int Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FreightPostCode Table Key Name Data type Required Indexed Default Value FreightID int (auto-number) Yes PostCodeStart int Yes PostCodeFinish int Yes ZoneID varchar(10) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy Yes ('Unknown') varchar(50) (0) FreightZoneAust Table Key Name FreightZoneID Data type Required Indexed Default Value varchar(10) Yes FreightZoneName varchar(100) Yes BasicCost money Yes CostPer250Grams money Yes PremiumMultiplier float Yes (1) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') FreightZoneInternational Table Key Name FreightZoneInternationalID Data type Required Indexed Default Value int Yes FreightZoneInternationalName nvarchar(50) Yes LessThan250g money Yes Between250and500g money Yes file:///C:/Clients/TheOnlinePrinter/Co… 6/21 16/09/2008 Database Documentation Between500and1000g money Yes PartKiloThereafter money Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') Job Table Key Name Data type Required Indexed Default Value JobID int (auto-number) Yes ProductID varchar(20) Yes JobStatusID int Yes ItemCount int Yes PaperTypeID int - ProofID int - ProductionSpeedID int Yes DeliveryMethodID int Yes FileTransferMethodID int Yes ContactFirstName varchar(100) - ContactLastName varchar(100) - ContactCompanyName varchar(100) - ContactStreetAddress varchar(100) - ContactSuburb varchar(100) - ContactState varchar(10) - ContactPostCode varchar(10) - ContactPhone varchar(100) - ContactFax varchar(100) - ContactEmail varchar(100) - DeliveryFirstName varchar(100) - DeliveryLastName varchar(100) - DeliveryCompanyName varchar(100) - DeliveryStreetAddress varchar(100) - DeliverySuburb varchar(100) - DeliveryState varchar(10) - file:///C:/Clients/TheOnlinePrinter/Co… 7/21 16/09/2008 Database Documentation DeliveryPostCode varchar(10) - DeliveryPhone varchar(100) - DeliveryFax varchar(100) - DeliveryEmail varchar(100) - PaymentMethodID int - CreditCardName varchar(100) - CreditCardNumber varchar(100) - CreditCardExpiryMonth varchar(2) - CreditCardExpiryYear varchar(4) - JobName varchar(100) - OperatingSystemID int - SoftwareUsedID int - SoftwareUsedOther varchar(100) - SpecialInstructions varchar(1000) - JobNotes varchar(2000) - CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') BackColourOptionID int - FoldingOptionID int - ReprintJobID int - PrintingPrice money Yes (0) ProofPrice money Yes (0) UrgencyPrice money Yes (0) FreightPrice money Yes (0) OrderTotalPrice money Yes (0) AuthorCorrections varchar(1500) - HouseCorrections varchar(1500) - CountryID nvarchar(10) - DeliveryStreetAddress2 varchar(100) - ContactStreetAddress2 varchar(100) - AdminPrice money Yes ((0)) FrontColourOptionID int Yes ((1)) file:///C:/Clients/TheOnlinePrinter/Co… 8/21 16/09/2008 Database Documentation PageCount int Yes ((1)) PlacedByUserID int - DesignOnlineUsed bit Yes ((0)) AgentID int Yes ((1)) SiteID int Yes ((1)) AgentCommission money Yes ((0)) OtherPrice money Yes ((0)) OtherPriceDesc varchar(200) - DesignCount int Yes ((1)) DiscountPrice money Yes ((0)) JobFile Table Key Name Data type Required Indexed Default Value JobFileID int (auto-number) Yes FileName varchar(200) Yes FilePath varchar(500) Yes JobID int - CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') IsProof bit Yes (0) JobStatus Table Key Name JobStatusID Data type Required Indexed Default Value int Yes JobStatusName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy Yes ('Unknown') varchar(50) OperatingSystem Table Key Name file:///C:/Clients/TheOnlinePrinter/Co… Data type Required Indexed Default Value 9/21 16/09/2008 Database Documentation OperatingSystemID int (auto-number) Yes OperatingSystemName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') PaperType Table Key Name PaperTypeID Data type Required Indexed Default Value int (auto-number) Yes PaperTypeName varchar(100) Yes PaperCost money Yes GSM int Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') PaperWeight Table Key Name Data type Required Indexed Default Value GSM int Yes GramsPerA3 float Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') PaymentMethod Table Key Name PaymentMethodID Data type Required Indexed Default Value int (auto-number) Yes PaymentMethodName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') file:///C:/Clients/TheOnlinePrinter/Co… 10/21 16/09/2008 Database Documentation PrintMethod Table Key Name PrintMethodID Data type Required Indexed Default Value int Yes PrintMethodName varchar(100) Yes SetupCost money Yes ColourCost money Yes BlankCost money Yes BlackWhiteCost money Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') Product Table Key Name Default Value Data type Required Indexed ProductID varchar(20) Yes ProductFamily varchar(20) Yes ProductName1 varchar(100) Yes ProductName2 varchar(100) - ProductName3 varchar(100) - ProductName4 varchar(100) Yes NumberPerA3 decimal (18,10) Yes DigitalMaxCopies int Yes QuantityMin int Yes QuantityMax int Yes AdminCost money Yes ProofCost money Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') BackColourOptionDefaultID int Yes FoldingChoiceID int Yes file:///C:/Clients/TheOnlinePrinter/Co… ('unknown') 11/21 16/09/2008 Database Documentation FoldingOptionDefaultID int Yes ProductDescription1 varchar(100) - ProductTypeID varchar(1) Yes ('S') FrontColourChoiceID int Yes ((3)) BackColourChoiceID int Yes ((7)) PageCopies int Yes ((1)) FrontColourDesc1 varchar(50) Yes ('Front') BackColourDesc1 varchar(50) Yes ('Back') DesignOnlineAllowed bit Yes ((1)) ProductGroupID varchar(20) Yes ('unknown') DesignTemplateID varchar(20) - SortOrder int Yes ((0)) DesignOnlineFrontColourChoiceID int Yes ((7)) DesignOnlineBackColourChoiceID int Yes ((7)) PartnerProductID varchar(20) - ShowInMenu bit Yes ((1)) DiscountPercent decimal (10,4) Yes ((0)) DiscountAmount money Yes ((0)) PageTitle1 nvarchar(100) Yes ('New Page') PageTitle2 nvarchar(100) Yes ('New Page') PageTitle3 nvarchar(100) Yes ('New Page') PageTitle4 nvarchar(100) Yes ('New Page') MetaKeywords1 varchar(1000) - MetaKeywords2 varchar(1000) - MetaKeywords4 varchar(1000) - MetaKeywords3 varchar(1000) - MetaDescription1 varchar(1000) - MetaDescription2 varchar(1000) - MetaDescription3 varchar(1000) - MetaDescription4 varchar(1000) - Footer1 text Yes ('Footer') Footer2 text Yes ('Footer') Footer3 text Yes ('Footer') file:///C:/Clients/TheOnlinePrinter/Co… 12/21 16/09/2008 Database Documentation Footer4 text Yes ('Footer') ProductText1 text - ProductText2 text - ProductText3 text - ProductText4 text - FrontColourDesc2 varchar(50) Yes ('Front') FrontColourDesc3 varchar(50) Yes ('Front') FrontColourDesc4 varchar(50) Yes ('Front') BackColourDesc2 varchar(50) Yes ('Back') BackColourDesc3 varchar(50) Yes ('Back') BackColourDesc4 varchar(50) Yes ('Back') ProductDescription2 varchar(100) - ProductDescription3 varchar(100) - ProductDescription4 varchar(100) - DeliveryInfo1 varchar(100) - DeliveryInfo2 varchar(100) - DeliveryInfo3 varchar(100) - DeliveryInfo4 varchar(100) - Dimensions1 varchar(100) - Dimensions2 varchar(100) - Dimensions3 varchar(100) - Dimensions4 varchar(100) - ProductGroup Table Key Name Data type Required Indexed Default Value varchar(20) Yes ProductGroupName1 varchar(50) Yes SortOrder1 int Yes ((0)) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') PageTitle1 nvarchar(100) Yes ('New Page') PageTitle2 nvarchar(100) Yes ('New Page') ProductGroupID file:///C:/Clients/TheOnlinePrinter/Co… 13/21 16/09/2008 Database Documentation PageTitle3 nvarchar(100) Yes ('New Page') PageTitle4 nvarchar(100) Yes ('New Page') MetaKeywords1 varchar(1000) - MetaKeywords2 varchar(1000) - MetaKeywords3 varchar(1000) - MetaKeywords4 varchar(1000) - MetaDescription1 varchar(1000) - MetaDescription2 varchar(1000) - MetaDescription3 varchar(1000) - MetaDescription4 varchar(1000) - Footer1 text Yes ('Footer') Footer2 text Yes ('Footer') Footer3 text Yes ('Footer') Footer4 text Yes ('Footer') Description1 text - Description2 text - Description3 text - Description4 text - ProductGroupName2 varchar(50) Yes ProductGroupName3 varchar(50) Yes ProductGroupName4 varchar(50) Yes SortOrder2 int Yes ((0)) SortOrder3 int Yes ((0)) SortOrder4 int Yes ((0)) ProductionSpeed Table Key Name ProductionSpeedID Data type Required Indexed Default Value int (auto-number) Yes ProductionSpeedName varchar(100) Yes SurchargePercent float Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() file:///C:/Clients/TheOnlinePrinter/Co… 14/21 16/09/2008 Database Documentation ModifiedBy varchar(50) Yes ('Unknown') ProductPaper Table Key Name Data type Required Indexed Default Value ProductID varchar(20) Yes PaperTypeID int Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ProductType Table Key Name ProductTypeID Data type Required Indexed Default Value varchar(1) Yes ProductTypeName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ProfitMargin Table Key Name Data type Required Indexed Default Value ProfitMarginID int (auto-number) Yes ProductID varchar(20) Yes ItemCount int Yes ProfitMarginPercent float Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') Proof Table Key Name Data type Required Indexed Default Value ProofID int (auto-number) Yes ProofName varchar(100) file:///C:/Clients/TheOnlinePrinter/Co… Yes 15/21 16/09/2008 CreateDate Database Documentation datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy Yes ('Unknown') varchar(50) SecurityGroup Table Key Name Data type SecurityGroupID Required Indexed Default Value int (auto-number) Yes SecurityGroupName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') SecurityGroup_User Table Key Name SecurityUserID Data type Required Indexed Default Value int Yes SecurityGroupID int Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') SecurityPermission Table Key Name Data type SecurityPermissionID Required Indexed Default Value int (auto-number) Yes SecurityPermissionName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') SecurityPermission_Group Table Key Name SecurityGroupID Data type Required Indexed Default Value int Yes SecurityPermissionID int Yes file:///C:/Clients/TheOnlinePrinter/Co… 16/21 16/09/2008 Database Documentation CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') SecurityUser Table Key Name Data type Required Indexed Default Value SecurityUserID int (auto-number) Yes UserName varchar(50) Yes PasswordHash varchar(200) Yes EmailAddress varchar(100) Yes CompanyName varchar(100) - Notes varchar(1000) - IsActive bit Yes (1) CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ContactFirstName varchar(100) Yes ('') ContactLastName varchar(100) Yes ('') ContactStreetAddress varchar(100) Yes ('') ContactStreetAddress2 varchar(100) - ('') ContactSuburb varchar(100) Yes ('') ContactState varchar(10) Yes ('') ContactPostCode varchar(10) Yes ('') CountryID nvarchar(10) Yes ('') ContactPhone varchar(100) Yes ('') ContactFax varchar(100) - ('') EmailVerified bit Yes ((0)) AgentID int - ('') Site Table Key Name SiteID Data type Required Indexed Default Value int file:///C:/Clients/TheOnlinePrinter/Co… Yes 17/21 16/09/2008 Database Documentation SiteName varchar(50) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') HostBase varchar(50) Yes ('example.com') HostName varchar(50) Yes ('www.unknown.com') SoftwareUsed Table Key Name Data type SoftwareUsedID Required Indexed Default Value int (auto-number) Yes SoftwareUsedName varchar(100) Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') SortCode varchar(50) Yes ('A') TrimCost Table Key Name Data type Required Indexed Default Value A3SheetCount int Yes TrimCost money Yes CreateDate datetime Yes =getdate() LastModifyDate datetime Yes =getdate() ModifiedBy varchar(50) Yes ('Unknown') ViewBulkPrice Table Key Name Data type Required Indexed Default Value BulkPriceID int (auto-number) Yes ProductID varchar(20) Yes Quantity int Yes FrontColourOptionID int Yes BackColourOptionID int Yes PaperTypeID int (auto-number) Yes file:///C:/Clients/TheOnlinePrinter/Co… 18/21 16/09/2008 Database Documentation PageCount int Yes Price money Yes PaperTypeName varchar(100) Yes FrontColourOptionName varchar(100) Yes BackColourOptionName varchar(100) Yes ViewJobDetail Table Key Name Data type Required Indexed Default Value JobID int (auto-number) Yes ProductName1 varchar(100) Yes ProductName2 varchar(100) - ProductName3 varchar(100) - ProductName4 varchar(100) Yes JobStatusName varchar(100) Yes ItemCount int Yes PaperTypeName varchar(100) - ProofName varchar(100) Yes ProductionSpeedName varchar(100) Yes DeliveryMethodName varchar(100) - FileTransferMethodName varchar(100) - ContactFirstName varchar(100) - ContactLastName varchar(100) - ContactCompanyName varchar(100) - ContactStreetAddress varchar(100) - ContactSuburb varchar(100) - ContactState varchar(10) - ContactPostCode varchar(10) - ContactPhone varchar(100) - ContactFax varchar(100) - ContactEmail varchar(100) - DeliveryFirstName varchar(100) - DeliveryLastName varchar(100) - DeliveryCompanyName varchar(100) - file:///C:/Clients/TheOnlinePrinter/Co… 19/21 16/09/2008 Database Documentation DeliveryStreetAddress varchar(100) - DeliverySuburb varchar(100) - DeliveryState varchar(10) - DeliveryPostCode varchar(10) - DeliveryPhone varchar(100) - DeliveryFax varchar(100) - DeliveryEmail varchar(100) - PaymentMethodName varchar(100) - CreditCardName varchar(100) - CreditCardNumber varchar(100) - CreditCardExpiryMonth varchar(2) - CreditCardExpiryYear varchar(4) - JobName varchar(100) - OperatingSystemName varchar(100) - SoftwareUsedName varchar(100) - SoftwareUsedOther varchar(100) - SpecialInstructions varchar(1000) - JobNotes varchar(2000) - CreateDate datetime Yes LastModifyDate datetime Yes ModifiedBy varchar(50) Yes BackColourOptionName varchar(100) - FoldingOptionName varchar(100) - ReprintJobID int - PrintingPrice money Yes ProofPrice money Yes UrgencyPrice money Yes FreightPrice money Yes OrderTotalPrice money Yes ProductID varchar(20) Yes JobStatusID int Yes ProofID int (auto-number) - ProductionSpeedID int (auto-number) Yes file:///C:/Clients/TheOnlinePrinter/Co… 20/21 16/09/2008 Database Documentation AuthorCorrections varchar(1500) - HouseCorrections varchar(1500) - CountryName nvarchar(50) - DeliveryStreetAddress2 varchar(100) - ContactStreetAddress2 varchar(100) - AdminPrice money Yes FrontColourOptionName varchar(100) Yes DesignOnlineUsed bit Yes SiteName varchar(50) Yes HostBase varchar(50) Yes HostName varchar(50) Yes FileTransferMethodID int (auto-number) Yes DesignCount int Yes DiscountPrice money Yes file:///C:/Clients/TheOnlinePrinter/Co… 21/21