CREATE TABLE [dbo].[transactions](

[txID] [int] IDENTITY(1,1) NOT NULL,

[storeNumber] [int] NULL,

[txType] [varchar](10) NULL,

[txStartDate] [datetime] NULL,

[txEndDate] [datetime] NULL,

[txReferrer] [varchar](50) NULL,

[txStatus] [varchar](50) NULL,

[cuID] [int] NULL,

[adrIDShip] [int] NULL,

[adrIDBill] [int] NULL,

[returnfor] [int] NULL,

[txParentID] [int] NULL,

[txRef] [int] NULL,

[txBackorder] [int] NULL,

[txExchange] [int] NULL,

[txExchangeParentID] [int] NULL,

[txHighRiskCheckoutStatus] [varchar](10) NULL,

[QuoteID] [int] NULL,

[ToBePrinted] [tinyint] NULL,

[txEbayCheckout] [tinyint] NULL,

[txStorePickup] [int] NULL,

[txSalesChannel] [varchar](10) NULL,

[txSendToAmazon] [tinyint] NULL,

[txAmazonOrderNum] [varchar](100) NULL,

[txPCMagSentDate] [datetime] NULL,

[txPmtMethod] [varchar](6) NULL,

[txDatePmtReceived] [datetime] NULL,

[txDatePmtFailed] [datetime] NULL,

[txDatePmtCleared] [datetime] NULL,

[PayPalTranID] [varchar](20) NULL,

[HoldOrderShipment] [datetime] NULL,

[HoldOrderShipmentReason] [varchar](500) NULL,

[txNotes] [varchar](2000) NULL,

[PayPalPending] [varchar](50) NULL,

[ResetDate] [datetime] NULL,

[ResetPmtInfoAction] [tinyint] NULL,

[ResetPmtTypesToOffer] [varchar](100) NULL,

[ResetShippingAddressAction] [tinyint] NULL,

[txPaypalReminder1SentDate] [datetime] NULL,

[txPaypalReminder2SentDate] [datetime] NULL,

[NetDollarsPaid] [money] NULL,

[PayPalPaymentType] [varchar](50) NULL,

[checkout_adrID] [int] NULL,

[paypal_adrid] [int] NULL,

[txInvoiceDate] [datetime] NULL,

[txAmazonFeedbackReminderSentDate] [datetime] NULL,

[txAmazonDoNotSendFeedbackFlag] [tinyint] NULL,

[txClarkPhotoSentDate] [datetime] NULL,

[storeQuoteID] [int] NULL,

[txAmazonPaidDate] [datetime] NULL,

[txAmazonCommissionPaid] [money] NULL,

[CGIRemoteAddress] [varchar](100) NULL,

[ebay_adrid] [int] NULL,

[txSubType] [varchar](15) NULL,

[txRefundReason] [varchar](10) NULL,

[PickerMfrGroup] [varchar](15) NULL,

[PickerItemID] [int] NULL,

[InUseByUserID] [int] NULL,

[BingCashBackOrder] [tinyint] NULL,

[BingCashBackProcessDate] [datetime] NULL,

[BingCashBackAmount] [money] NULL,

[EbayMarkedPaidDate] [datetime] NULL,

[txSendToExternal] [tinyint] NULL,

[txExternalOrderNum] [varchar](50) NULL,

[FBA] [tinyint] NULL,

[WebsiteOrderNum] [int] NULL,

[PickerLocGroup] [varchar](10) NULL,

[PickerLocSort] [varchar](3) NULL,

[pickerloc] [varchar](5) NULL,

[EligForSIQ] [tinyint] NULL,

[OrigPayPalTranID] [varchar](20) NULL,

[txCJCancelSentDate] [datetime] NULL,

CONSTRAINT [PK_transactions] PRIMARY KEY CLUSTERED

(

[txID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[transaction_shipping_notes](

[txID] [int] NOT NULL,

[tsnTrackingNumber] [varchar](50) NULL,

[tsnNotes] [varchar](4000) NULL,

[tsnShippingMailSentDate] [datetime] NULL,

[tsnSendShippingMailFlag] [bit] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[transaction_shipping](

[txID] [int] NOT NULL,

[liID] [int] NOT NULL,

[stID] [int] NULL,

[srID] [int] NULL,

[shippingID] [int] NOT NULL,

[shippingCost] [money] NULL,

[shippingNoticeParsed] [bit] NULL,

[shippingNotice] [varchar](2000) NULL,

[ship_typeid] [int] NULL,

[ActualShippingCost] [money] NULL,

[PostmarkDate] [datetime] NULL,

[InsuranceFee] [money] NULL,

[shippingOverrideFlag] [tinyint] NULL,

[AmazonShipType] [varchar](10) NULL,

[ActualDimWt] [int] NULL,

[ActualShippingWeight] [int] NULL,

[HighPriorityFlag] [tinyint] NULL,

[ItemValueOverrideForInsurance] [money] NULL,

[MailInnovationsFlag] [tinyint] NULL,

[ship_cost] [money] NULL,

[insur_cost] [money] NULL,

[EbayMarkedShippedDate] [datetime] NULL,

[ExternalShipType] [varchar](35) NULL,

[ReqSigFlag] [tinyint] NULL,

[ShippingComputer] [tinyint] NULL,

[LateShipment] [datetime] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[transaction_notes](

[tnID] [int] IDENTITY(1,1) NOT NULL,

[txID] [int] NULL,

[txNotes] [varchar](4000) NULL,

[tnStage] [varchar](20) NULL,

[adminID] [int] NULL,

[tnDate] [datetime] NULL,

[tnExported] [datetime] NULL,

CONSTRAINT [PK_transaction_notes] PRIMARY KEY NONCLUSTERED

(

[tnID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[ship_type](

[ship_typeid] [int] NOT NULL,

[carrier] [varchar](10) NULL,

[description] [varchar](50) NOT NULL,

[carrier_sort] [int] NULL,

[ship_type_sort] [int] NULL,

[ratetable] [varchar](50) NULL,

[source] [varchar](50) NULL,

[active] [tinyint] NULL,

[created_datetime] [datetime] NOT NULL,

[created_by] [varchar](75) NOT NULL,

[updated_datetime] [datetime] NOT NULL,

[updated_by] [varchar](75) NOT NULL,

[pickerShipSort] [int] NULL,

[pickerShipName] [varchar](40) NULL,

[RequireSignature] [tinyint] NULL,

[internal_only] [tinyint] NOT NULL,

[discount_pct] [float] NOT NULL,

[base_min] [money] NULL,

[insurance_multiplier] [float] NOT NULL,

[sig_reqd_possible] [tinyint] NOT NULL,

[sig_reqd_for_fraud] [tinyint] NOT NULL,

[isGeneric] [tinyint] NULL,

[CustomerDisplay] [varchar](50) NULL,

CONSTRAINT [IX_ship_type] UNIQUE NONCLUSTERED

(

[ship_typeid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

) ON [PRIMARY]

GO