MPX Database Definition
SERVER SETTINGS | DATABASE SETTINGS | USERS | TABLES | VIEWS | STORED PROCEDURES

Table Of Contents
Table	Row Count	Reserved	Row Data	Index Size	Table Data
Server Options
Database Options
Database Users
AccountingSetup	205	32	16	16	156.10
AcctRecv	620	280	72	96	451.61
AcctRecvHistory	2990	856	176	240	286.29
April_2005_VP_Mailing	17500	328	312	8	18.74
April_2005_VP_Mailing2	15661	328	280	8	20.94
April_2005_VP_Mailing3	14850	328	264	8	22.09
AuditLog	58608	5256	4840	32	89.68
BackOrderPrint	25949	1544	1496	16	59.50
Backorders	254	32	16	16	125.98
Batches	6799	2008	1184	144	295.34
BatchesRecur	4	24	8	16	6000.00
CanPostCodes	0	0	0	0	0
CDGcat05	4512	136	80	8	30.14
ChargeHistory	10142	2384	1112	416	235.06
Codes	614	152	112	16	247.56
CodeTypes	35	24	8	16	685.71
Dates	2	24	8	16	12000.00
DeliveryMethods	2	24	8	16	12000.00
DMA	279	40	16	24	143.37
DMADefinitions	58812	5504	3328	2088	93.59
dtproperties	0	0	0	0	0
Entity	100358	82160	57024	24472	818.67
EntityACH	0	0	0	0	0
EntityAddresses	88021	28680	22936	4968	325.83
EntityAddressTypes	12	24	8	16	2000.00
EntityAttachments	0	0	0	0	0
EntityAttributeTypes	0	0	0	0	0
EntityCodes	145858	27776	11240	15472	190.43
EntityCorrespond	117747	21704	9768	10728	184.33
EntityCreditCards	43915	13888	10080	2472	316.25
EntityDates	0	0	0	0	0
EntityEmail	60800	10696	7480	2136	175.92
EntityFinancials	2	24	8	16	12000.00
EntityGiftPic	286	136	72	16	475.52
EntityMaritalStatus	5	24	8	16	4800.00
EntityNotes	14533	4368	2912	424	300.56
EntityPhone	83748	19016	10800	7360	227.06
EntityPhoneTypes	9	24	8	16	2666.67
EntityRelationships	18	40	8	32	2222.22
EntityRelationshipTypes	17	24	8	16	1411.76
EntitySalutation	118929	19528	19104	112	164.20
EntitySalutationTypes	2	24	8	16	12000.00
FinanceCodes	13	24	8	16	1846.15
GiftAnnual	24116	2392	1464	888	99.19
GiftComments	131	72	40	32	549.62
GiftDetail	45057	8896	3296	4384	197.44
GiftHeader	44916	28696	16768	7776	638.88
GiftPledge	1557	456	224	80	292.87
GiftRecurring	233	24	8	16	103.00
GiftRelated	2	24	8	16	12000.00
GiftSummary	17078	2824	2400	360	165.36
JournalEntries	453977	53952	53504	224	118.84
JournalEntryExceptions	0	0	0	0	0
letterPriorities	4	24	8	16	6000.00
MediaAgencies	0	0	0	0	0
MediaAirDates	72	24	8	16	333.33
MediaContacts	1	40	8	32	40000.00
MediaEpisodes	72	24	8	16	333.33
MediaNetworkGroups	64	40	8	32	625.00
MediaNetworks	6	24	8	16	4000.00
MediaOutletFormats	38	32	8	24	842.11
MediaOutlets	209	296	80	48	1416.27
MediaPhone	154	48	16	32	311.69
MediaPlacementExceptions	0	0	0	0	0
MediaPlacementRates	54	72	32	40	1333.33
MediaPlacements	246	112	80	32	455.28
MediaPlacementShare	86	56	16	40	651.16
MediaPremiums	71	24	8	16	338.03
MediaPrograms	1	24	8	16	24000.00
MediumSubTypes	8	32	8	24	4000.00
MediumTypes	3	32	8	24	10666.67
Metro	285	40	16	24	140.35
MetroDefinitions	46504	3712	2344	1320	79.82
MotivationCodes	192	56	24	32	291.67
MotivationCrossRef	128	40	8	32	312.50
MotivationGroups	24	24	8	16	1000.00
NoteCodes	14	24	8	16	1714.29
Numbers	0	0	0	0	0
OrderAddresses	203295	20160	19744	136	99.17
OrderAnnual	118453	8912	6584	2288	75.24
OrderComments	12580	3656	2032	272	290.62
OrderDetail	487525	85504	52664	31984	175.38
OrderHeader	254578	222480	157264	60112	873.92
OrderSubscriptions	1007	392	232	16	389.28
OrderSummary	71871	11408	9920	1432	158.73
OrgSettings	63	24	8	16	380.95
Processes	220	264	96	16	1200.00
ProductAccountingSetup	6786	592	376	168	87.24
ProductActivity	664679	99328	75952	23232	149.44
ProductBOM	336	80	16	64	238.10
ProductDiscounts	0	0	0	0	0
ProductHistory	95229	14088	9184	3960	147.94
ProductKeywords	105	40	8	32	380.95
ProductLocation	2128	552	232	112	259.40
ProductPrices	5757	848	264	208	147.30
Products	2335	1360	736	112	582.44
ProjectCategory	0	0	0	0	0
ProjectCodes	44	40	8	32	909.09
ProjectGoals	0	0	0	0	0
Projects	1	24	8	16	24000.00
ProjectStepAttachments	0	0	0	0	0
ProjectStepDtls	0	0	0	0	0
ProjectSteps	0	0	0	0	0
RefNbrs	0	0	0	0	0
Reports	111	48	32	16	432.43
Roles	6	56	24	32	9333.33
SegmentationGroups	104	32	16	16	307.69
SegmentationGrpExceptions	0	0	0	0	0
SegmentationJobs	42	32	16	16	761.90
SegmentationMergeDtls	13	24	8	16	1846.15
SegmentationMergeJobs	1	24	8	16	24000.00
ShippingInfo	0	0	0	0	0
SubscriptionHistory	1462	136	72	16	93.02
Suffixes	7	32	16	16	4571.43
TaskNotification	0	0	0	0	0
Tasks	35	24	8	16	685.71
tblBanks	1	24	8	16	24000.00
tblFields	373	40	32	8	107.24
tblFields_bak0401	279	80	32	8	286.74
tblSavedQueries	11	64	32	32	5818.18
tblSavedReports	111	736	288	16	6630.63
tblSegmentationQueries	104	416	144	16	4000.00
tblServiceDetail	2	24	8	16	12000.00
tblServiceHeader	3	24	8	16	8000.00
tblState	308	40	24	16	129.87
tblTransactions	0	0	0	0	0
tblUPSShipCodes	13	24	8	16	1846.15
tblUser	41	104	72	32	2536.59
tblVersion	2	24	8	16	12000.00
Temp_abc	175	32	16	16	182.86
Temp_ValidateLocAct	368	24	16	8	65.22
TI_AuditLog	9719	584	488	16	60.09
TI_CodesLocation	11	24	8	16	2181.82
TI_ErrorLog	0	24	8	16	0
TI_Header	181	32	16	16	176.80
TI_IE_DomainCodeMap	0	0	0	0	0
TI_IE_DomainCodes	0	0	0	0	0
TI_IE_InboundCodes	0	0	0	0	0
TI_IE_Map_Fields	0	0	0	0	0
TI_IE_TransferErrorLog	0	0	0	0	0
TI_ISA_File1	0	0	0	0	0
TI_ISA_File2	0	0	0	0	0
TI_ISA_File3	0	0	0	0	0
TI_KTAB_Donor_Account	7	40	8	32	5714.29
TI_KTAB_Donor_AlternateAddress	0	0	0	0	0
TI_KTAB_Donor_EMailAddress	1	24	8	16	24000.00
TI_KTAB_Donor_MailListCode	0	0	0	0	0
TI_KTAB_Donor_MailRestrictCode	0	0	0	0	0
TI_KTAB_Donor_MediaCode	6	24	8	16	4000.00
TI_KTAB_Donor_Notes	8	40	24	16	5000.00
TI_KTAB_Donor_OtherCode	0	0	0	0	0
TI_KTAB_Donor_TelephoneNumber	4	24	8	16	6000.00
TI_KTAB_Gift_Detail	0	0	0	0	0
TI_KTAB_Gift_Master	0	40	8	32	0
TI_KTAB_Order_Detail	4	24	8	16	6000.00
TI_KTAB_Order_Master	3	40	8	32	13333.33
TI_KTAB_Pledge_Master	0	0	0	0	0
timezone_crossref	12	16	8	8	1333.33
timezones	74	24	16	8	324.32
Titles	23	24	8	16	1043.48
UserRoles	35	24	8	16	685.71
VersionInfo	32	24	8	16	750.00
VersionLog	365	40	24	16	109.59
ZIPCODES	800883	167560	112848	53152	209.22
MakeActivity
SubscriptionCounts
SubscriptionHistoryInfo
ActivateBatchSubscriptions
ActivateSubscriptions
ActiveAddress
AddBatch
AddEntityAddress
AddNote
AddNoteType
AddPostalCode
AddSavedQuery
AddSuffix
AddTitle
AdjustBatchTotals
AdjustBOMCosts
AdjustInventoryCost
AdjustProduct
AdjustProductHistory
AllocateProduct
AllocBOM
AllocProduct
AttributePledgeGift
AuthenticateUser
BeginEdit
CheckLock
CheckUnlock
ConsumeBOMForMake
ConsumeForMake
ConsumeOrders
ConsumeReceives
CR_C_Code_List
CR_I_Action_Listing
CR_I_BOM_ProductListing
CR_I_Product_Details
CR_I_Product_Details_SUB_BOM
CR_I_Product_Details_SUB_Keywords
CR_I_Product_Listing
CR_I_Product_Price_List
CR_I_Product_Requirements
CR_I_ProductListing
CR_I_ProductListingKeyword
CR_I_ProductLocation
CR_I_Releive_Backorders_SUB_Orders
CR_I_Relieve_Backorders
CR_I_ReorderPointAnalysis
CR_I_StockStatus
CR_M_Media_Agency_Listing
CR_M_Media_DMA_Analysis
CR_M_Media_Income_Analysis
CR_M_Media_Income_Analysis_SUB_Entity_Count
CR_M_Media_Income_Analysis_SUB_Media_Cost_Paid
CR_M_Media_Income_Analysis_SUB_Media_Cost_Share
CR_M_Media_Mailing_Labels
CR_M_Media_Metro_Analysis
CR_M_Media_Outlet_Contracts
CR_M_Media_Outlet_Listing
CR_M_Media_Outlet_Listing_SUB_Agencies
CR_M_Media_Outlet_Listing_SUB_Contacts
CR_M_Media_Outlet_Listing_SUB_Phone
CR_M_Media_Outlets_by_Program
CR_M_Monthly_Media
CR_M_Network_Listing
CR_M_Programs_and_Placements
CR_M_Programs_and_Placements_SUB_Episodes
CR_M_Programs_and_Placements_SUB_Exceptions
CR_M_Translator_Listing
CR_M_Translator_Listing_SUB
CR_O_Letter_Code_Listing
CR_O_Reports_Listing_Report
CR_O_Reports_Listing_Report_SUB
CR_O_User_Activity
CR_P_AccountGiving
CR_P_AccountGivingRelated
CR_P_AccountPledgeList
CR_P_AccountProfile_Main
CR_P_AccountProfile_SUB_AddressList
CR_P_AccountProfile_SUB_AR
CR_P_AccountProfile_SUB_Code_Dates
CR_P_AccountProfile_SUB_Codes
CR_P_AccountProfile_SUB_Correspondence
CR_P_AccountProfile_SUB_ECodes
CR_P_AccountProfile_SUB_EntityFinancials
CR_P_AccountProfile_SUB_GiftDetail
CR_P_AccountProfile_SUB_GiftHistory
CR_P_AccountProfile_SUB_GiftRelated
CR_P_AccountProfile_SUB_GiftSummary
CR_P_AccountProfile_SUB_OrderDetail
CR_P_AccountProfile_SUB_OrderSummary
CR_P_AccountProfile_SUB_Phone
CR_P_AccountProfile_SUB_Pledge
CR_P_AccountProfile_SUB_Relationships
CR_P_AccountProfile_SUB_SalesHistory
CR_P_AccountProfile_SUB_Salutation
CR_P_AccountProfile_SUB_Subscription
CR_P_Address_List
CR_P_Code_Counts_Dates
CR_P_Code_Counts_Media
CR_P_Code_Counts_Notes
CR_P_Code_Counts_Pledges
CR_P_Code_Counts_State_or_Country
CR_P_Code_Counts_UserDefined
CR_P_Code_List
CR_P_DuplicateAccounts_Main
CR_P_DuplicateAccounts_SUB
CR_P_FileCountsbyCode
CR_P_GraphSalesGifts
CR_P_GraphSalesGiftsMonthly
CR_P_MotivationGroupGraphs
CR_P_TestSEG
CR_P_TESTSEG2
CR_P_Zipcode_List
CR_PR_ProjectPerformanceGraph
CR_PR_ProjectPerformanceGraph_Main
CR_PR_ProjectPerformanceGraph_SUB_Detail
CR_PR_ProjectPerformanceGraph_SUB_Gift
CR_PR_ProjectPerformanceGraph_SUB_Order
CR_PR_ProjectPerformanceGraph_SUB_Step
CR_Segmentation
CR_T_AllTasks
CR_T_Annual_Giving_Summary
CR_T_AR_Detail
CR_T_Backorder_Analysis
CR_T_Backorder_Analysis_SUB
CR_T_Batch_Edit_Listing_MAIN
CR_T_Batch_Edit_Listing_SUB_AR
CR_T_Batch_Edit_Listing_SUB_Gift
CR_T_Batch_Edit_Listing_SUB_Order
CR_T_Batch_Edit_SUB_AR
CR_T_Batch_Receipt_Listing
CR_T_Batch_Report
CR_T_Batch_Summary_MAIN
CR_T_Batch_Summary_SUB_AR
CR_T_Batch_Summary_SUB_Gift
CR_T_Batch_Summary_SUB_Order
CR_T_Cash_Receipts
CR_T_ChargeHistory
CR_T_Committed_Supporters
CR_T_CompleteTasks
CR_T_Daily_Donational_Sales
CR_T_Daily_Donational_Sales_SUB
CR_T_Daily_Donor
CR_T_Daily_Gift_Sales_Analysis_MAIN
CR_T_Daily_Gift_Sales_Analysis_SUB_Accounting
CR_T_Daily_Gift_Sales_Analysis_SUB_Accounting_Summary_Gift
CR_T_Daily_Gift_Sales_Analysis_SUB_AR
CR_T_Daily_Gift_Sales_Analysis_SUB_Gift
CR_T_Daily_Gift_Sales_Analysis_SUB_Sale
CR_T_Daily_Gift_Sales_Analysis_SUB_Sales_Accounting
CR_T_Daily_Gift_Sales_Summary_Analysis_MAIN
CR_T_Daily_Gift_Sales_Summary_Analysis_SUB_Accounting
CR_T_Daily_Gift_Sales_Summary_Analysis_SUB_AR
CR_T_Daily_Gift_Sales_Summary_Analysis_SUB_Gift
CR_T_Daily_Gift_Sales_Summary_Analysis_SUB_Sale
CR_T_Detail_Analysis_by_Media
CR_T_Detail_Analysis_by_Motivation
CR_T_Detail_Analysis_by_Project
CR_T_Donor_LifeCycle_Analysis
CR_T_Donor_Ranking
CR_T_Gift_FMV_Addr
CR_T_Gift_Giving
CR_T_Journal_Entry
CR_T_Media_Giving
CR_T_Missionary_Statment_Main
CR_T_Missionary_Statment_SUB
CR_T_Monthly_Gift_Analysis
CR_T_Monthly_Order_Analysis
CR_T_Monthly_YTD_Code
CR_T_Monthly_YTD_Donor
CR_T_Monthly_YTD_Donor_SUB
CR_T_Monthly_YTD_Media
CR_T_Monthly_YTD_Motiv
CR_T_Monthly_YTD_Project
CR_T_Monthly_YTD_SCF
CR_T_Monthly_YTD_Zip
CR_T_Motivation_Giving
CR_T_Motivation_Summary
CR_T_MotivationGiving
CR_T_MOTVTEST
CR_T_New_Pledges_by_Entry_Date
CR_T_OpenTasks
CR_T_Outstanding_Authorization
CR_T_Outstanding_Orders
CR_T_Outstanding_Receipts_and_Packing_Slips
CR_T_Packing_Slip
CR_T_PeriodAnalysis_Code
CR_T_PeriodAnalysis_Donor
CR_T_PeriodAnalysis_Donor_SUB
CR_T_PeriodAnalysis_Media
CR_T_PeriodAnalysis_MissProj
CR_T_PeriodAnalysis_Motivation
CR_T_PeriodAnalysis_Pledge
CR_T_PeriodAnalysis_Project
CR_T_PeriodAnalysis_SCF
CR_T_PeriodAnalysis_Zip
CR_T_PeriodAnalysis_ZipCode
CR_T_Pledge_and_Giving_Summary
CR_T_Product_Summary_Analysis
CR_T_Product_Summary_by_PriceCode
CR_T_Product_Summary_Sub_BOM
CR_T_Project_Giving
CR_T_ProjectGiving
CR_T_Sales_Refund_Listing
CR_T_Sales_Summary_Analysis
CR_T_Sales_Summary_Analysis_SUB_Accounting
CR_T_Sales_Tax_by_County_by_State
CR_T_Segmentation_Job_Listing
CR_T_Transactions_by_Class
CR_TI_Data_Download_Report
CreateSysAdmin
CreateTempTable
DeactivatePerson
DeallocateProduct
DeleteAddress
DeleteBatch
DeleteGift
DeleteGiftPic
DeleteMediaOutlet
DeleteMediaPlacement
DeleteOrder
DeletePayment
DeletePerson
DeletePledge
DeleteProduct
DeleteSavedQuery
DeleteSubscription
Drop_TempSummaryCombinedTables
DropTempTable
DropTmpSummaryTables
EndEdit
EnsureAcctRecvHistory
EnsureProductHistory
ExistsTempTable
FindZips
GetCountries
GetIdentityValue
GetInvJournalFund
GetMPowerUser
GetPledges
GetProcessingInstr
GetProcessList
GetStates
GetTitleByName
InsertProcessList
InvalidateRoleUserRestrictions
MakeAcctRecvHistoryRecord
MakeProduct
MakeProductHistoryRecord
MatchingGiftCheck
MergeAccounts
MigrateQtyConsumed
msp_AddCodeToSegAccts
msp_AddCorrespondenceToSegAccts
msp_Build_GiftAnnual
msp_Build_GiftSummary
msp_Build_GiftSummary_SP1
msp_Build_GiftSummary_SP2
msp_Build_Order_Sum_Ann
msp_execsql
msp_FileExists
msp_get_first_gift
msp_get_first_gift_soft
msp_get_first_sale
msp_Get_GiftSummary_Combined
msp_get_Giving_Summary
msp_get_Giving_Summary_Soft
msp_get_largest_gift
msp_get_largest_gift_soft
msp_get_largest_sale
msp_get_last_gift
msp_get_last_gift_soft
msp_get_last_sale
msp_get_Outstanding_Orders
msp_get_Sales_Summary
msp_REBuild_GiftAnnual_withID
msp_REBuild_GiftSummary_Sp1
msp_REBuild_GiftSummary_Sp2
msp_REBuild_GiftSummary_Sp3
msp_REBuild_GiftSummary_withID
msp_REBuild_Order_Sum_Ann_withID
msp_RebuildAcctBalance
msp_RebuildAcctBalanceByID
msp_RebuildPledgeInfo
msp_RebuildProductBOM
msp_RebuildProductHistory
msp_RebuildProductReal
msp_RepairProductActivity
msp_upd_CanPostCodes
msp_upd_DMA
msp_upd_Metro
msp_upd_PostCodes
msp_upd_UsaPostCodes
msp_ValidateProductActivity
OrderProduct
RebuildAcctRecvHistory
ReceiveProduct
RemoveMediaNetworkOutlet
sayhello
SetIdentityValue
SetProductDefaultPrice
SetProductDefaultPrice2
ShipABOM
ShipAProduct
ShipProduct
TIsp_CascadeDeleteHeader
TIsp_CheckCodeExists
TIsp_DeDupDonorAccount
TIsp_DoInsertCode
TIsp_GetCodeDescription
TIsp_GetHeaderID
TIsp_GetUnMappedCodes
TIsp_GetUserDefinedCodeTypes
TIsp_InitialCounts
TIsp_InsertCode
TIsp_ISA_Import_Duplicated
TIsp_MasterMOP
TIsp_MissingCodeMap
TIsp_MOP_Donor_Account
TIsp_MOP_Donor_AlternateAddress
TIsp_MOP_Donor_MailListCode
TIsp_MOP_Donor_MailRestrictCode
TIsp_MOP_Donor_MediaCode
TIsp_MOP_Donor_Notes
TIsp_MOP_Donor_OtherCode
TIsp_MOP_Donor_TelephoneNumber
TIsp_MOP_Gift_Detail
TIsp_MOP_Gift_Master
TIsp_MOP_Order_Detail
TIsp_MOP_Order_Master
TIsp_MOP_Pledge_Master
TIsp_Move_Table_Data_by_MapFile
TIsp_RemoveDonor
TIsp_RemoveHeaderID
TIsp_Resolve_Donor_Status
TIsp_TI_Import_Duplicated
TIsp_TI_Import_Table_Duplicated
TIsp_Transfer_ISA_to_TI
TIsp_UndoUserDefCodeType
TIsp_UpdateCodeMap
TIsp_UpdateCodeMapMaster
TIsp_UpdateDefaultCodeMapMaster
TIsp_UpdateDefaultCodeValues
TIsp_UpdateHeaderCounts
TIsp_UpdateOrigCodeType
TIsp_UpdateUserDefCodeType
TIsp_ValidateHoldingTank
TIsp_WipeHoldingTank
TransferGift
TransferProduct
UpdateAcctBalance
UpdateAllProductDefaultPrices
UpdateBatchStatus
UpdateGiftAnnual
UpdateGiftSummary
UpdateGiftSummaryTables
UpdateOrderAnnual
UpdateOrderSummary
UpdateOrderSummaryTables
UpdatePrimaryAddress
UpdateProductDfltPrice
UpdateProductDfltPrice2
UpdateProductLocOrderInfo
UpdateProductOrder
UpdateProductReceive
UpdateSavedQuery
UpdateSetting
ValidateZip
WriteAllocInvJournalEntry
WriteBatchInterFundJournalEntry
WriteBatchJournalEntry
WriteGiftJournalEntry
WriteInventoryJournalEntry
WriteInvJournalEntry
WriteOrderGLJournalEntry
WriteOrderJournalEntry
WriteShipInterFundJournalEntry
WriteShipJournalEntry

Server Settings
Table	Row Count
Server Name	PUDDY
Instance	MSSQLSERVER
Current Date Time	09 Mar 2006 15:23:56:217
User	dbo
Number of connections	347
Language	us_english
Language Id	0
Lock Timeout	-1
Maximum of connections	32767
CPU Busy	100
CPU Idle	37712
IO Busy	46
Packets received	1561162
Packets sent	1608037
Packets w errors	0
TimeTicks	31250
IO Errors	0
Total Read	651275
Total Write	1749130

Back To Top ^

Database Settings
Option	Setting
Name	DGM_MPX_020706
autoclose	False
select into/bulkcopy	False
trunc. log on chkpt	False
torn page detection	True
loading	False
pre recovery	False
recovering	False
Falset recovered	False
offline	False
read only	False
dbo use only	False
single user	False
emergency mode	False
autoshrink	False
cleanly shutdown	False
ANSI null default	False
concat null yields null	False
recursive triggers	False
default to local cursor	False
quoted identifier	False
cursor close on commit	False
ANSI nulls	False
ANSI warnings	False
full text enabled	False
Data Path	C:\Backup\DGM\200602071630_DG.bakDGM_MPX_020706.mdf
Last Backup
Days Since Last Backup

Back To Top ^

Users
Login Name	User Name	Group Name
mpxsql	mpxsql	mpxuser_role

Back To Top ^

Tables

AccountingSetup
Column	Type	Length	Precision	Scale	Nullable	Comments
CodeType	varchar	50	50		0
CodeValue	varchar	50	50		0
Type	varchar	50	50		0
Descript	varchar	200	200		1
Category	varchar	50	50		0
Fund	varchar	50	50		0
GLAcct	varchar	50	50		0
CC	varchar	50	50		0
ProjCode	varchar	50	50		1

Indexes
Index Name		Indexed Columns
PK_AccountingSetup		CodeType, CodeValue, Type

Back To Top ^

AcctRecv
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
BatchNbr	bigint	8	19	0	1
Rdate	datetime	8	23	3	0
Type	varchar	1	1		0
Descript	varchar	100	100		1
Status	varchar	1	1		1
Amt	money	8	19	4	0
OrdNbr	bigint	8	19	0	1
ADate	datetime	8	23	3	1
CurrCode	varchar	8	8		1
ConvRate	float	8	53		1
AcctRecvID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_AcctRecv_Entity	AcctRecv	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_AcctRecv		AcctRecvID
IDX_AcctRecv_Ordnbr		OrdNbr
IDX_BatchNbr_Type_AcctRecv		BatchNbr, Type

Back To Top ^

AcctRecvHistory
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
CurrYear	int	4	10	0	0
CurrMonth	int	4	10	0	0
Amt	money	8	19	4	0
AcctRecvHistoryID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_AcctRecvHistory_Entity	AcctRecvHistory	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
AcctRecvHistory
PK_AcctRecvHistory		AcctRecvHistoryID
IDX_AcctRecvHistory		EntityID, CurrYear, CurrMonth

Back To Top ^

April_2005_VP_Mailing
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	1
MotvCode	varchar	50	50		1

Indexes
Index Name		Indexed Columns
April_2005_VP_Mailing

Back To Top ^

April_2005_VP_Mailing2
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	1
MotvCode	varchar	50	50		1

Indexes
Index Name		Indexed Columns
April_2005_VP_Mailing2

Back To Top ^

April_2005_VP_Mailing3
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	1
MotvCode	varchar	50	50		1

Indexes
Index Name		Indexed Columns
April_2005_VP_Mailing3

Back To Top ^

AuditLog
Column	Type	Length	Precision	Scale	Nullable	Comments
AuditTrailID	bigint	8	19	0	0
Descript	varchar	2000	2000		0
AddUserID	bigint	8	19	0	0
AddDate	datetime	8	23	3	0
EntityID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_AuditLog_ChangeDate	AuditLog	AddDate				(getdate())
Foreign Key	FK_AuditLog_tblUser	AuditLog	AddUserID	tblUser	userID	1

Indexes
Index Name		Indexed Columns
PK_AuditLog		AuditTrailID

Back To Top ^

BackOrderPrint
Column	Type	Length	Precision	Scale	Nullable	Comments
BackOrderPrintID	bigint	8	19	0	0
Ordnbr	bigint	8	19	0	0
Bdate	datetime	8	23	3	1
LDate	datetime	8	23	3	1
Pdate	datetime	8	23	3	1
Prtgrp	int	4	10	0	1
Prtstatus	varchar	1	1		1

Indexes
Index Name		Indexed Columns
PK_BackOrderPrint		BackOrderPrintID

Back To Top ^

Backorders
Column	Type	Length	Precision	Scale	Nullable	Comments
BackOrdersID	bigint	8	19	0	0
OrdNbr	bigint	8	19	0	0
BDate	datetime	8	23	3	1

Indexes
Index Name		Indexed Columns
PK_BackOrders		BackOrdersID

Back To Top ^

Batches
Column	Type	Length	Precision	Scale	Nullable	Comments
BatchNbr	bigint	8	19	0	0
BDate	datetime	8	23	3	1
GLDate	datetime	8	23	3	1
Fund	varchar	50	50		1
GlAcct	varchar	50	50		1
CC	varchar	50	50		1
ProjCode	varchar	50	50		1
Category	varchar	50	50		1
CurrCode	varchar	8	8		1
ConvRate	float	8	53		1
ControlAmt	money	8	19	4	1
ActualAmt	money	8	19	4	1
Status	varchar	1	1		1
DefMotvCode	varchar	50	50		1
DefFundId	varchar	50	50		1
DefPldgCode	varchar	50	50		1
DefPayCode	varchar	50	50		1
AddDate	datetime	8	23	3	1
AddSite	varchar	2	2		1
AddUserID	bigint	8	19	0	1
ApplyDate	datetime	8	23	3	1
Type1	varchar	50	50		1
Type2	varchar	50	50		1
ActualNbr	int	4	10	0	1
ControlNbr	int	4	10	0	1
BatchStatus	varchar	12	12		1
ChangeUserID	bigint	8	19	0	1
ChangeDate	smalldatetime	4	16	0	1
BankID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_Batches	Batches	BatchNbr	GiftHeader	BatchNbr	1
Primary Key	PK_Batches	Batches	BatchNbr	OrderHeader	BatchNbr	1

Indexes
Index Name		Indexed Columns
PK_Batches		BatchNbr
IDX_Batches_Status		Status

Back To Top ^

BatchesRecur
Column	Type	Length	Precision	Scale	Nullable	Comments
Type	varchar	50	50		1
DateUsed	datetime	8	23	3	1
CurrCode	varchar	50	50		1
BatchRecurID	bigint	8	19	0	0

Indexes
Index Name		Indexed Columns
PK_BatchesRecur		BatchRecurID

Back To Top ^

CanPostCodes
Column	Type	Length	Precision	Scale	Nullable	Comments
postCode	varchar	10	10		0
city	varchar	40	40		0
provinceD	varchar	40	40		0
province	varchar	2	2		0
_dummy_	varchar	1	1		0
lat	float	8	53		0
lng	float	8	53		0

Indexes
Index Name		Indexed Columns
CanPostCodes

Back To Top ^

CDGcat05
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	1
MotvCode	varchar	50	50		1

Indexes
Index Name		Indexed Columns
CDGcat05

Back To Top ^

ChargeHistory
Column	Type	Length	Precision	Scale	Nullable	Comments
ChargeHistoryID	bigint	8	19	0	0
TransID	bigint	8	19	0	0
TransType	varchar	1	1		0
TDate	datetime	8	23	3	0
Source	varchar	1	1		0
Status	varchar	1	1		0
ChargeType	varchar	50	50		0
Descript	varchar	2000	2000		1
PrtGrp	bigint	8	19	0	0

Indexes
Index Name		Indexed Columns
PK_ChargeHistory		ChargeHistoryID, TransID, PrtGrp
IX_StatusSource		Status, Source

Back To Top ^

Codes
Column	Type	Length	Precision	Scale	Nullable	Comments
DataType	varchar	8	8		0
CodeType	varchar	50	50		0
CodeValue	varchar	50	50		0
Descript	varchar	80	80		1
Code1	varchar	8	8		1
Code2	varchar	8	8		1
Nbr1	int	4	10	0	1
Nbr2	int	4	10	0	1
AddData	char	30	30		1
Amt1	float	8	53		1
AMt2	float	8	53		1
AddMemo	text	16			1
Status	char	1	1		1
Note	varchar	2000	2000		1

Indexes
Index Name		Indexed Columns
PK_Codes		DataType, CodeType, CodeValue
tCodes

Back To Top ^

CodeTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
codeTypesID	bigint	8	19	0	0
CodeType	varchar	50	50		0
Inactive	int	4	10	0	1
Secured	bit	1	1	0	1
Descript	varchar	200	200		1
Note	varchar	2000	2000		1
DataType	varchar	50	50		0

Indexes
Index Name		Indexed Columns
PK_CodeTypes		CodeType, DataType

Back To Top ^

Dates
Column	Type	Length	Precision	Scale	Nullable	Comments
CodeType	varchar	50	50		0
Descript	varchar	2000	2000		1
DataType	varchar	50	50		0
Inactive	bit	1	1	0	0
Reminder	varchar	50	50		0
Secured	bit	1	1	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__Dates__Inactive__3EDC53F0	Dates	Inactive				(0)
Default	DF__Dates__Reminder__3FD07829	Dates	Reminder				('One Time')
Default	DF__Dates__Secured__42ACE4D4	Dates	Secured				(0)

Indexes
Index Name		Indexed Columns
PK_Dates		DataType, CodeType

Back To Top ^

DeliveryMethods
Column	Type	Length	Precision	Scale	Nullable	Comments
Delivery_method_id	bigint	8	19	0	0
Delivery_method	varchar	50	50		0
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK__DeliveryMethods__09A971A2	DeliveryMethods	Delivery_method_id	MediaPlacements	Delivery_method_id	1

Indexes
Index Name		Indexed Columns
PK__DeliveryMethods__09A971A2		Delivery_method_id

Back To Top ^

DMA
Column	Type	Length	Precision	Scale	Nullable	Comments
DMA_Id	bigint	8	19	0	0
DMA_name	varchar	50	50		0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_DMA	DMA	DMA_Id	DMADefinitions	DMA_Id	1

Indexes
Index Name		Indexed Columns
DMA
PK_DMA		DMA_Id

Back To Top ^

DMADefinitions
Column	Type	Length	Precision	Scale	Nullable	Comments
DMA_Id	bigint	8	19	0	0
DMA_zip	varchar	12	12		0
County	varchar	50	50		1
State	varchar	50	50		1
Metro	bit	1	1	0	0
DMA	bit	1	1	0	0
TSA	bit	1	1	0	0
TableId	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_DMADefinitions_DMA	DMADefinitions	DMA				(0)
Default	DF_DMADefinitions_Metro	DMADefinitions	Metro				(0)
Default	DF_DMADefinitions_TSA	DMADefinitions	TSA				(0)
Foreign Key	FK_DMADefinitions_DMA	DMADefinitions	DMA_Id	DMA	DMA_Id	1

Indexes
Index Name		Indexed Columns
PK_DMADefinitions		TableId
IDX_DMA_id_DMA_Zip		DMA_Id, DMA_zip

Back To Top ^

Server: Msg 512, Level 16, State 1, Line 445 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Entity
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
OrgFlag	varchar	50	50		1
Title	varchar	50	50		1
FirstName	varchar	50	50		1
LastName	varchar	50	50		1
Suffix	varchar	50	50		1
Spouse	varchar	50	50		1
AddDate	datetime	8	23	3	1
AddSite	varchar	50	50		1
AddUserId	bigint	8	19	0	1
ChgDate	datetime	8	23	3	1
ChgSIte	varchar	50	50		1
ChgUserId	bigint	8	19	0	1
AltAddrActive	varchar	1	1		1
SoundCode	int	4	10	0	1
LockID	bigint	8	19	0	1
LockBreakID	bigint	8	19	0	1
OrganizationName	varchar	100	100		1
Active	varchar	1	1		1
MiddleName	varchar	20	20		1
Address1	varchar	50	50		1
Address2	varchar	50	50		1
Address3	varchar	50	50		1
City	varchar	50	50		1
State	varchar	50	50		1
PostalCode	varchar	50	50		1
Country	varchar	50	50		1
IncludeOrgName	int	4	10	0	1
DefaultEmail	varchar	350	350		1
DefaultPhone	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__Entity__AcctBal__1C1D2798	Entity	AcctBal				(0)
Default	DF__Entity__Active__787EE5A0	Entity	Active				(1)
Primary Key	PK_Entity	Entity	EntityID	AcctRecv	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	AcctRecvHistory	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityACH	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityAddresses	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityAttachments	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityCodes	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityCorrespond	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityCreditCards	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityDates	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityEmail	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityFinancials	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityNotes	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityPhone	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntityRelationships	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	EntitySalutation	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	GiftDetail	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	GiftHeader	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	GiftRecurring	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	GiftRelated	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	MediaContacts	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	OrderAnnual	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	OrderSubscriptions	EntityID	1
Primary Key	PK_Entity	Entity	EntityID	OrderSummary	EntityID	1

Indexes
Index Name		Indexed Columns
PK_Entity		EntityID
IDX_Entity_PeopleSearch		EntityID, FirstName, LastName, Spouse, OrganizationName, MiddleName, Address1, City, State, PostalCode, Country, DefaultEmail

Back To Top ^

EntityACH
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityACHID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
AchType	varchar	50	50		0
RoutingNbr	varchar	16	16		0
BankNbr	varchar	16	16		0
Bank	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityACH_Entity	EntityACH	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityACH		EntityACHID
IDX_EntityACH_Entity		EntityID

Back To Top ^

EntityAddresses
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityAddressID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
AddressType	varchar	50	50		1
Address1	varchar	50	50		1
Address2	varchar	50	50		1
Address3	varchar	50	50		1
City	varchar	50	50		1
State	varchar	50	50		1
PostalCode	varchar	50	50		1
Country	varchar	50	50		1
ActiveDate	smalldatetime	4	16	0	1
InactiveDate	smalldatetime	4	16	0	1
PrimaryAddress	int	4	10	0	1
Recurrance	int	4	10	0	0
CreateUserID	bigint	8	19	0	1
ModifiedUserID	bigint	8	19	0	1
CreateDate	smalldatetime	4	16	0	1
ModifiedDate	smalldatetime	4	16	0	1
IncludeOrgName	int	4	10	0	1
AlternateName	int	4	10	0	1
Title	varchar	50	50		1
FirstName	varchar	50	50		1
LastName	varchar	50	50		1
Suffix	varchar	50	50		1
DateActivated	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__EntityAdd__Recur__06CD04F7	EntityAddresses	Recurrance				(0)
Foreign Key	FK_EntityAddresses_Entity	EntityAddresses	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityAddresses		EntityAddressID, EntityID
IDX_DateActivation		EntityID, ActiveDate, InactiveDate

Back To Top ^

EntityAddressTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
Type	varchar	50	50		0
Inactive	int	4	10	0	1
TypeID	bigint	8	19	0	0
Descript	varchar	2000	2000		1

Indexes
Index Name		Indexed Columns
PK_EntityAddressTypes		TypeID

Back To Top ^

EntityAttachments
Column	Type	Length	Precision	Scale	Nullable	Comments
AttachID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
Attachment	varchar	2000	2000		1
Descript	varchar	2000	2000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityAttachments_Entity	EntityAttachments	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityAttachments		AttachID
IDX_EntityAttachments_Entity		EntityID

Back To Top ^

EntityAttributeTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityAttributeTypeID	bigint	8	19	0	0
EntityAttributeTypeDescr	varchar	50	50		0
Active	int	4	10	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_EntityAttribute_Active	EntityAttributeTypes	Active				(1)

Indexes
Index Name		Indexed Columns
PK_EntityAttributeTypes		EntityAttributeTypeID

Back To Top ^

EntityCodes
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
CodeType	varchar	50	50		1
CodeValue	varchar	100	100		0
ModifiedUserID	bigint	8	19	0	1
ModifiedDate	datetime	8	23	3	1
EntityCodeID	bigint	8	19	0	0
AddDate	datetime	8	23	3	1
AddUserID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityCodes_Entity	EntityCodes	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
EntityCodes
PK_EntityCodes		EntityCodeID, EntityID
IDX_EntityId_EntityCodes		EntityID, CodeType, CodeValue

Back To Top ^

EntityCorrespond
Column	Type	Length	Precision	Scale	Nullable	Comments
CorrespondID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
Type	varchar	8	8		0
LtrCode	varchar	50	50		0
LDate	datetime	8	23	3	1
Src	varchar	8	8		1
Ref	bigint	8	19	0	1
Status	varchar	1	1		0
PrtGrp	bigint	8	19	0	1
PrtDate	datetime	8	23	3	1
ParaCode1	varchar	50	50		1
ParaCode2	varchar	50	50		1
ParaCode3	varchar	50	50		1
ParaCode4	varchar	50	50		1
PrtJob	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityCorrespond_Entity	EntityCorrespond	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityCorrespond		CorrespondID
IDX_EntityCorrespond_Src_Ref		Src, Ref
IDX_EntityCorrespond_EntityID		EntityID
IDX_EntityCorrespond_LtrCode		LtrCode, Status

Back To Top ^

EntityCreditCards
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityCreditCardID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
NameOnCard	varchar	100	100		0
EntityAddressType	varchar	50	50		0
CreditCardType	varchar	50	50		0
CreditCardNumber	varchar	50	50		0
CardExpDate	varchar	8	8		0
Bank	varchar	50	50		1
CreditCardNote	varchar	2000	2000		1
AddDate	smalldatetime	4	16	0	1
ChgDate	smalldatetime	4	16	0	1
ChgUserID	bigint	8	19	0	1
AddUserID	bigint	8	19	0	1
LastUseDate	datetime	8	23	3	1
CardNumberEncrypted	varbinary	256	256		1	KEY:Description VALUE: Encrypted Credit Card Number

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityCreditCards_Entity	EntityCreditCards	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityCreditCards		EntityCreditCardID
IX_EntityID		EntityID
IX_CardType		CreditCardType

Back To Top ^

EntityDates
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityDatesID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
DateType	varchar	20	20		0
DateValue	datetime	8	23	3	0
Descript	varchar	2048	2048		1
Note	varchar	2048	2048		1
ModifiedUserID	bigint	8	19	0	1
ModifiedDate	smalldatetime	4	16	0	1
AddDate	datetime	8	23	3	1
AddUserID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityDates_Entity	EntityDates	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityDates		EntityDatesID, EntityID

Back To Top ^

EntityEmail
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityEmailID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
EmailAddress	varchar	350	350		1
defaultEmail	int	4	10	0	1
note	varchar	100	100		1
CreateUserID	bigint	8	19	0	1
ModifiedUserID	bigint	8	19	0	1
CreateDate	smalldatetime	4	16	0	1
ModifiedDate	smalldatetime	4	16	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityEmail_Entity	EntityEmail	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityEmail		EntityEmailID, EntityID
IDX_EntityId_EntityEmail		EntityID

Back To Top ^

EntityFinancials
Column	Type	Length	Precision	Scale	Nullable	Comments
FinancialID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
Projected	money	8	19	4	1
ProjectedNote	varchar	1990	1990		1
Capacity	money	8	19	4	1
CapacityNote	varchar	1990	1990		1
Propensity	int	4	10	0	1
Philanthropic	varchar	2000	2000		1
Note	varchar	2000	2000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityFinancials_Entity	EntityFinancials	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityFinancials		FinancialID

Back To Top ^

EntityGiftPic
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityGiftPicID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
Amt	money	8	19	4	1
MotvCode	varchar	50	50		1
ProjCode	varchar	50	50		1
Category	varchar	50	50		1
PldgCode	varchar	50	50		1
PledgeID	bigint	8	19	0	1
Deduct	varchar	1	1		1
Annon	varchar	1	1		1
MediaCode	varchar	50	50		1
SAcctNbr	int	4	10	0	1
ProgramID	bigint	8	19	0	1
PayType	varchar	50	50		1
PayNbr	varchar	20	20		1
CardType	varchar	50	50		1
CardExpire	varchar	5	5		1
RoutingNbr	varchar	20	20		1
BankNbr	varchar	20	20		1
CardNumberEncrypted	varbinary	256	256		1	KEY:Description VALUE: Encrypted Credit Card Number

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityGiftPic_GiftPledge	EntityGiftPic	PledgeID	GiftPledge	PledgeID	1

Indexes
Index Name		Indexed Columns
PK_EntityGiftPic		EntityGiftPicID, EntityID

Back To Top ^

EntityMaritalStatus
Column	Type	Length	Precision	Scale	Nullable	Comments
MaritalStatusID	bigint	8	19	0	0
MaritalStatus	varchar	50	50		0
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_EntityMaritalStatus_Inactive	EntityMaritalStatus	Inactive				(0)

Indexes
Index Name		Indexed Columns
PK_EntityMaritalStatus		MaritalStatusID

Back To Top ^

EntityNotes
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
AttributeTypeDescr	varchar	50	50		1
AttributeValue	varchar	2048	2048		1
NextDate	smalldatetime	4	16	0	1
ModifiedUserID	bigint	8	19	0	1
ModifiedDate	smalldatetime	4	16	0	1
EntityNoteID	bigint	8	19	0	0
NextActionNote	varchar	256	256		1
AddDate	datetime	8	23	3	1
AddUserID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityNotes_Entity	EntityNotes	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityNotes		EntityNoteID
IDX_EntityNotes_Entity		EntityID

Back To Top ^

EntityPhone
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityPhoneID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
PhoneType	varchar	50	50		1
PhoneNumber	varchar	50	50		1
ActiveDate	smalldatetime	4	16	0	1
InactiveDate	smalldatetime	4	16	0	1
Active	int	4	10	0	1
defaultPhone	int	4	10	0	1
Recurrance	int	4	10	0	0
CreateUserID	bigint	8	19	0	1
ModifiedUserID	bigint	8	19	0	1
CreateDate	smalldatetime	4	16	0	1
ModifiedDate	smalldatetime	4	16	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__EntityPho__Recur__07C12930	EntityPhone	Recurrance				(0)
Foreign Key	FK_EntityPhone_Entity	EntityPhone	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityPhone		EntityPhoneID, EntityID
IDX_EntityPhone_PhoneType_PhoneNumber		EntityID, PhoneType, PhoneNumber

Back To Top ^

EntityPhoneTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
PhoneTypeDescription	varchar	2000	2000		1
PhoneType	varchar	50	50		0
InActive	int	4	10	0	1
PhoneTypeID	bigint	8	19	0	0

Indexes
Index Name		Indexed Columns
PK_EntityPhoneTypes		PhoneTypeID

Back To Top ^

EntityRelationships
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
RelationID	bigint	8	19	0	0
Type	varchar	50	50		0
NameKey	varchar	30	30		1
note	varchar	2000	2000		1
EntityRelationshipsID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntityRelationships_Entity	EntityRelationships	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntityRelationships		EntityRelationshipsID
IDX_EntityRelationships_Entity		EntityID

Back To Top ^

EntityRelationshipTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
Type	varchar	50	50		1
Descript	varchar	2000	2000		1
InverseType	varchar	50	50		1
Inactive	int	4	10	0	1
TypeID	bigint	8	19	0	0

Indexes
Index Name		Indexed Columns
PK_EntityRelationshipTypes		TypeID

Back To Top ^

Server: Msg 512, Level 16, State 1, Line 445 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

EntitySalutation
Column	Type	Length	Precision	Scale	Nullable	Comments
EntitySalutationID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_EntitySalutation_Entity	EntitySalutation	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_EntitySalutation		EntitySalutationID, EntityID

Back To Top ^

EntitySalutationTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
Type	varchar	50	50		0
Inactive	int	4	10	0	1
Descript	varchar	2000	2000		1
DefaultSalutation	int	4	10	0	1
TypeID	bigint	8	19	0	0

Indexes
Index Name		Indexed Columns
PK_EntitySalutationTypes		TypeID

Back To Top ^

FinanceCodes
Column	Type	Length	Precision	Scale	Nullable	Comments
CodeType	varchar	50	50		0
CodeValue	varchar	50	50		0
Descript	varchar	2000	2000		1
Code1	varchar	50	50		1
Code2	varchar	50	50		1
Nbr1	int	4	10	0	1
Nbr2	int	4	10	0	1
AddData	varchar	30	30		1
Amt1	float	8	53		1
AMt2	float	8	53		1
GlAcct1	varchar	4	4		1
GLAcct2	varchar	4	4		1
Fund	varchar	1	1		1
GlAcct	varchar	4	4		1
CC	varchar	4	4		1
Fundid	varchar	6	6		1
Subacct	varchar	3	3		1
Inactive	int	4	10	0	1

Indexes
Index Name		Indexed Columns
PK_FinanceCodes		CodeType, CodeValue

Back To Top ^

GiftAnnual
Column	Type	Length	Precision	Scale	Nullable	Comments
GiftAnnualID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
CurrCode	varchar	8	8		0
Deduct	varchar	1	1		0
CurrYear	int	4	10	0	0
Nbr	int	4	10	0	1
Amt	money	8	19	4	1
ConvAmt	money	8	19	4	1
Soft	bit	1	1	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__GiftAnnual__Soft__369C13AA	GiftAnnual	Soft				(0)

Indexes
Index Name		Indexed Columns
PK_GiftAnnual		GiftAnnualID
IDX_GiftAnnual_Entity		EntityID
IDX_GiftAnnual_CurrYear		CurrYear

Back To Top ^

GiftComments
Column	Type	Length	Precision	Scale	Nullable	Comments
Comm	text	16			1
PrintFlag	varchar	1	1		1
GiftRef	bigint	8	19	0	1
GiftCommentID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftComments_GiftHeader	GiftComments	GiftRef	GiftHeader	GiftRef	1

Indexes
Index Name		Indexed Columns
PK_GiftComments		GiftCommentID
IDX_GiftRef_GiftComments		GiftRef
tGiftComments

Back To Top ^

GiftDetail
Column	Type	Length	Precision	Scale	Nullable	Comments
GiftDetailID	bigint	8	19	0	0
GiftRef	bigint	8	19	0	0
Amt	money	8	19	4	1
MotvCode	varchar	50	50		1
ProjCode	varchar	50	50		1
Category	varchar	50	50		1
PledgeID	bigint	8	19	0	1
Deduct	varchar	1	1		1
Annon	varchar	1	1		1
MediaCode	varchar	50	50		1
SAcctNbr	bigint	8	19	0	1
GiftDetailNote	varchar	2000	2000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftDetail_Entity	GiftDetail	SAcctNbr	Entity	EntityID	1
Foreign Key	FK_GiftDetail_GiftHeader	GiftDetail	GiftRef	GiftHeader	GiftRef	1
Foreign Key	FK_GiftDetail_GiftPledge	GiftDetail	PledgeID	GiftPledge	PledgeID	1

Indexes
Index Name		Indexed Columns
IDX_GiftDetail_GiftRef		GiftRef
IDX_GiftDetail_MotvCode		MotvCode
IDX_GiftDetail_ProjCode		ProjCode
PK_GiftDetail		GiftDetailID
IDX_PledgeID_GiftDetail		PledgeID

Back To Top ^

GiftHeader
Column	Type	Length	Precision	Scale	Nullable	Comments
EntityID	bigint	8	19	0	0
GiftRef	bigint	8	19	0	0
Gdate	datetime	8	23	3	1
ApplyDate	datetime	8	23	3	1
BatchNbr	bigint	8	19	0	1
Status	varchar	1	1		1
Amt	money	8	19	4	1
PayCode	varchar	50	50		1
PayType	varchar	50	50		1
PayNbr	varchar	20	20		1
Expire	varchar	8	8		1
ChargeAuth	varchar	8	8		1
RcptNbr	bigint	8	19	0	1
RcptPrint	varchar	1	1		1
PrtGrp	int	4	10	0	1
LtrCode	varchar	50	50		1
LtrPrint	varchar	1	1		1
CurrCode	varchar	50	50		1
ConvRate	float	8	53		1
OrdNbr	bigint	8	19	0	1
ParaCode1	varchar	50	50		1
ParaCode2	varchar	50	50		1
AddUserID	bigint	8	19	0	1
ChgUserID	bigint	8	19	0	1
MediaCode	varchar	50	50		1
RouteNbr	varchar	16	16		1
AddDate	datetime	8	23	3	1
ChgDate	datetime	8	23	3	1
ProgramID	bigint	8	19	0	1
EpisodeID	bigint	8	19	0	1
SecCode	varchar	8	8		1
Bank	varchar	50	50		1
MediaPlacementId	bigint	8	19	0	1
CardNumberEncrypted	varbinary	256	256		1	KEY:Description VALUE: Encrypted Credit Card Number

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftHeader_Batches	GiftHeader	BatchNbr	Batches	BatchNbr	1
Foreign Key	FK_GiftHeader_Entity	GiftHeader	EntityID	Entity	EntityID	1
Primary Key	PK_GiftHeader	GiftHeader	GiftRef	GiftComments	GiftRef	1
Primary Key	PK_GiftHeader	GiftHeader	GiftRef	GiftDetail	GiftRef	1

Indexes
Index Name		Indexed Columns
PK_GiftHeader		GiftRef
IDX_EntityId_GiftHeader		EntityID
IDX_Amt_GiftHeader		Amt
IDX_BatchNbr_GiftHeader		BatchNbr
IDX_MediaCode_GiftHeader		MediaCode
IDX_OrdNbr_GiftHeader		OrdNbr
IDX_GiftHeader_MediaPlacements		Gdate, MediaPlacementId

Back To Top ^

GiftPledge
Column	Type	Length	Precision	Scale	Nullable	Comments
PledgeID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
PldgCode	varchar	50	50		0
Status	varchar	1	1		1
StartDate	datetime	8	23	3	1
EndDate	datetime	8	23	3	1
TotAmtPldg	money	8	19	4	1
AmtPerGift	money	8	19	4	1
NbrPldg	int	4	10	0	1
Freq	varchar	1	1		1
MotvCode	varchar	50	50		1
AmtGiven	money	8	19	4	1
AmtRemain	money	8	19	4	1
NbrGiven	int	4	10	0	1
AddDate	datetime	8	23	3	1
AddSite	varchar	2	2		1
AddUserID	bigint	8	19	0	1
Note	varchar	2000	2000		1
PldgRef	int	4	10	0	1
ChgDate	datetime	8	23	3	1
ChgUserID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftPledge_TblUser_ADD	GiftPledge	AddUserID	tblUser	userID	1
Foreign Key	FK_GiftPledge_TblUser_CHG	GiftPledge	ChgUserID	tblUser	userID	1
Primary Key	PK_GiftPledge	GiftPledge	PledgeID	EntityGiftPic	PledgeID	1
Primary Key	PK_GiftPledge	GiftPledge	PledgeID	GiftDetail	PledgeID	1

Indexes
Index Name		Indexed Columns
PK_GiftPledge		PledgeID
IDX_GiftPledge_Pldgref		PldgRef

Back To Top ^

GiftRecurring
Column	Type	Length	Precision	Scale	Nullable	Comments
BatchRecurID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
GiftRecurID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftRecurring_Entity	GiftRecurring	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_GiftRecurring		GiftRecurID

Back To Top ^

GiftRelated
Column	Type	Length	Precision	Scale	Nullable	Comments
GiftRelatedID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
GiftRef	bigint	8	19	0	1
Amt	money	8	19	4	1
ProjCode	varchar	50	50		1
MotvCode	varchar	50	50		1
PAcctNbr	bigint	8	19	0	1
Category	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_GiftRelated_Entity	GiftRelated	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_GiftRelated		GiftRelatedID

Back To Top ^

GiftSummary
Column	Type	Length	Precision	Scale	Nullable	Comments
GiftSummaryID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
CurrCode	varchar	8	8		0
Deduct	varchar	1	1		0
Soft	bit	1	1	0	0
Amt	money	8	19	4	1
ConvAmt	money	8	19	4	1
Nbr	int	4	10	0	1
FirstDate	datetime	8	23	3	1
FirstAmt	money	8	19	4	1
FirstConvAmt	money	8	19	4	1
FirstGiftRef	int	4	10	0	1
LargeDate	datetime	8	23	3	1
LargeAmt	money	8	19	4	1
LargeConvAmt	money	8	19	4	1
LargeGiftRef	int	4	10	0	1
LastDate	datetime	8	23	3	1
LastAmt	money	8	19	4	1
LastConvAmt	money	8	19	4	1
LastGiftRef	int	4	10	0	1

Indexes
Index Name		Indexed Columns
PK_GiftSummary		GiftSummaryID
IDX_GiftSummary_Entity		EntityID

Back To Top ^

JournalEntries
Column	Type	Length	Precision	Scale	Nullable	Comments
EntryID	bigint	8	19	0	0
RefNbr	bigint	8	19	0	1
JrnSrc	varchar	50	50		1
Descript	varchar	2000	2000		1
Type	char	1	1		1
Status	char	1	1		1
Amt	money	8	19	4	1
Category	varchar	50	50		1
Fund	varchar	50	50		1
GLAcct	varchar	50	50		1
CC	varchar	50	50		1
AddDate	datetime	8	23	3	1
TransDate	datetime	8	23	3	1
RefSrc	varchar	1	1		1
ProjCode	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_JournalEntries_Status	JournalEntries	Status				('A')

Indexes
Index Name		Indexed Columns
PK_JournalEntries		EntryID

Back To Top ^

JournalEntryExceptions
Column	Type	Length	Precision	Scale	Nullable	Comments
EntryID	bigint	8	19	0	0
RefNbr	bigint	8	19	0	1
FieldValue	varchar	50	50		1
FieldEdited	varchar	50	50		1
Message	varchar	2000	2000		1
Resolution	varchar	2000	2000		1
AddDate	datetime	8	23	3	1

Indexes
Index Name		Indexed Columns
PK_JournalEntryErrors		EntryID

Back To Top ^

letterPriorities
Column	Type	Length	Precision	Scale	Nullable	Comments
LetterPriorityID	bigint	8	19	0	0
Type	varchar	2	2		0
CodeType	varchar	50	50		1
ValueList	varchar	2000	2000		1
AMtLow	money	8	19	4	1
AmtHigh	money	8	19	4	1
LtrCode	varchar	50	50		0
AltCode	varchar	50	50		1
note	varchar	2000	2000		1
AdvSrch	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_tblSavedQueries_LetterPriorities	letterPriorities	AdvSrch	tblSavedQueries	savedQueryID	1

Indexes
Index Name		Indexed Columns
PK_letterPriorities		LetterPriorityID

Back To Top ^

MediaAgencies
Column	Type	Length	Precision	Scale	Nullable	Comments
Agency_Id	bigint	8	19	0	0
Name	varchar	100	100		0
Period_4_MaintenanceFee	varchar	10	10		1
PeriodicMaintenanceFee	money	8	19	4	1
Inactive	int	4	10	0	1
EntityID	bigint	8	19	0	1
Notes	varchar	2000	2000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK__MediaAgencies__1332DBDC	MediaAgencies	Agency_Id	MediaPlacements	Agency_Id	1

Indexes
Index Name		Indexed Columns
PK__MediaAgencies__1332DBDC		Agency_Id

Back To Top ^

MediaAirDates
Column	Type	Length	Precision	Scale	Nullable	Comments
EpisodeID	bigint	8	19	0	0
AirDateID	bigint	8	19	0	0
AirDate	datetime	8	23	3	0
Note	varchar	1000	1000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaAirDates_MediaEpisodes	MediaAirDates	EpisodeID	MediaEpisodes	Segment_Id	1
Primary Key	PK__MediaAirDates__671F4F74	MediaAirDates	AirDateID	MediaPremiums	AirDateID	1

Indexes
Index Name		Indexed Columns
PK__MediaAirDates__671F4F74		AirDateID

Back To Top ^

MediaContacts
Column	Type	Length	Precision	Scale	Nullable	Comments
MediaContactID	bigint	8	19	0	0
MediaID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaContacts_Entity	MediaContacts	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_MediaContacts		MediaContactID
IDX_MediaContacts_MediaId		MediaID

Back To Top ^

MediaEpisodes
Column	Type	Length	Precision	Scale	Nullable	Comments
ProgramID	bigint	8	19	0	0
Segment_Id	bigint	8	19	0	0
Name	varchar	100	100		1
EpisodeNbr	int	4	10	0	0
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaEpisodes_MediaPrograms	MediaEpisodes	ProgramID	MediaPrograms	ProgramID	1
Primary Key	PK__MediaEpisodes__531856C7	MediaEpisodes	Segment_Id	MediaAirDates	Segment_Id	1

Indexes
Index Name		Indexed Columns
PK__MediaEpisodes__531856C7		Segment_Id

Back To Top ^

MediaNetworkGroups
Column	Type	Length	Precision	Scale	Nullable	Comments
NetworkID	bigint	8	19	0	0
MediaID	bigint	8	19	0	0
NetworkGroupID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaNetworkGroups_MediaNetworks	MediaNetworkGroups	NetworkID	MediaNetworks	NetworkiD	1
Foreign Key	FK_MediaNetworkGroups_MediaOutlets	MediaNetworkGroups	MediaID	MediaOutlets	MediaCode_Id	1

Indexes
Index Name		Indexed Columns
PK_MediaNetworkGroups		NetworkGroupID
IDX_MediaNetworkGroups_MediaId		MediaID

Back To Top ^

MediaNetworks
Column	Type	Length	Precision	Scale	Nullable	Comments
NetworkiD	bigint	8	19	0	0
Name	varchar	50	50		0
Descript	varchar	2000	2000		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_MediaNetworks	MediaNetworks	NetworkiD	MediaNetworkGroups	NetworkiD	1

Indexes
Index Name		Indexed Columns
PK_MediaNetworks		NetworkiD

Back To Top ^

MediaOutletFormats
Column	Type	Length	Precision	Scale	Nullable	Comments
Format_id	bigint	8	19	0	0
Format_name	varchar	50	50		0
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_MediaOutletFormats	MediaOutletFormats	Format_id	MediaOutlets	Format_id	1

Indexes
Index Name		Indexed Columns
MediaOutletFormats
PK_MediaOutletFormats		Format_id

Back To Top ^

MediaOutlets
Column	Type	Length	Precision	Scale	Nullable	Comments
MediaCode_Id	bigint	8	19	0	0
MediaCode	varchar	50	50		0
Freq	varchar	20	20		1
FreqUOM	varchar	3	3		1
PowerOut	varchar	50	50		1
PowerUOM	varchar	2	2		1
CityOfLicense	varchar	25	25		1
State	varchar	50	50		1
Country	varchar	50	50		1
Website_URL	varchar	100	100		1
BCalName	varchar	15	15		0
Delivery_method_id	bigint	8	19	0	1
Medium_Id	bigint	8	19	0	0
Medium_subType_Id	bigint	8	19	0	1
Format_id	bigint	8	19	0	1
TimeZone_id	bigint	8	19	0	1
DMA_Id	bigint	8	19	0	1
notes	varchar	6000	6000		1
Inactive	int	4	10	0	1
Address1	varchar	50	50		1
Address2	varchar	50	50		1
Address3	varchar	50	50		1
ZipCode	varchar	50	50		1
AddDate	datetime	8	23	3	1
ChgDate	datetime	8	23	3	1
AddUserID	bigint	8	19	0	1
ChgUserID	bigint	8	19	0	1
EmailAddress	varchar	350	350		1
TagLine	varchar	100	100		1
Translator	bit	1	1	0	0
FlagshipID	bigint	8	19	0	1
Commercial	bit	1	1	0	1
TargetROI	real	4	24		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__MediaOutl__Trans__567ED357	MediaOutlets	Translator				(0)
Default	DF_MediaOutlets_BCalName	MediaOutlets	BCalName				('Gregorian')
Default	DF_MediaOutlets_Commercial	MediaOutlets	Commercial				(0)
Foreign Key	FK_MediaOutlets_MediaOutletFormats	MediaOutlets	Format_id	MediaOutletFormats	Format_id	1
Foreign Key	FK_MediaOutlets_MediumSubTypes	MediaOutlets	Medium_subType_Id	MediumSubTypes	Medium_subType_Id	1
Foreign Key	FK_MediaOutlets_MediumTypes	MediaOutlets	Medium_Id	MediumTypes	Medium_Id	1
Primary Key	PK__MediaOutlets__681373AD	MediaOutlets	MediaCode_Id	MediaNetworkGroups	MediaCode_Id	1
Primary Key	PK__MediaOutlets__681373AD	MediaOutlets	MediaCode_Id	MediaPhone	MediaCode_Id	1
Primary Key	PK__MediaOutlets__681373AD	MediaOutlets	MediaCode_Id	MediaPlacements	MediaCode_Id	1

Indexes
Index Name		Indexed Columns
PK__MediaOutlets__681373AD		MediaCode_Id
IDX_MediaOutlets_Medium_Id		Medium_Id
IDX_MediaOutlets_Medium_subType_Id		Medium_subType_Id

Back To Top ^

MediaPhone
Column	Type	Length	Precision	Scale	Nullable	Comments
MediaPhoneID	bigint	8	19	0	0
MediaCode_Id	bigint	8	19	0	0
PhoneNumber	varchar	50	50		1
Active	int	4	10	0	1
CreateUserID	bigint	8	19	0	1
ModifiedUserID	bigint	8	19	0	1
CreateDate	smalldatetime	4	16	0	1
ModifiedDate	smalldatetime	4	16	0	1
DefaultPhone	bit	1	1	0	1
PhoneType	varchar	50	50		1
InactiveDate	smalldatetime	4	16	0	1
ActiveDate	smalldatetime	4	16	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaPhone_MediaOutlets	MediaPhone	MediaCode_Id	MediaOutlets	MediaCode_Id	1

Indexes
Index Name		Indexed Columns
PK_MediaPhone		MediaPhoneID
IDX_MediaPhone_MediaCode_id		MediaCode_Id

Back To Top ^

MediaPlacementExceptions
Column	Type	Length	Precision	Scale	Nullable	Comments
ExceptionID	bigint	8	19	0	0
PlacementID	bigint	8	19	0	0
ExceptionDate	datetime	8	23	3	0

Indexes
Index Name		Indexed Columns
PK_MediaPlacementExceptions		ExceptionID

Back To Top ^

MediaPlacementRates
Column	Type	Length	Precision	Scale	Nullable	Comments
PlacementID	bigint	8	19	0	0
BeginDate	datetime	8	23	3	0
Rate	money	8	19	4	1
RecurType	varchar	32	32		0
RateID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaPlacementRates_MediaPlacements	MediaPlacementRates	PlacementID	MediaPlacements	PlacementID	1

Indexes
Index Name		Indexed Columns
MediaPlacementRates
PK_MediaPlacementRates		RateID
IDX_MediaPlacementRates_PlacementId		PlacementID

Back To Top ^

MediaPlacements
Column	Type	Length	Precision	Scale	Nullable	Comments
PlacementID	bigint	8	19	0	0
ProgramID	bigint	8	19	0	0
LeadIn	varchar	100	100		1
LeadOut	varchar	100	100		1
Monday	bit	1	1	0	0
Tuesday	bit	1	1	0	0
Wednesday	bit	1	1	0	0
Thursday	bit	1	1	0	0
Friday	bit	1	1	0	0
Saturday	bit	1	1	0	0
Sunday	bit	1	1	0	0
LocalTimeSlot_Begin	int	4	10	0	1
Notes	varchar	4000	4000		1
MediaID	bigint	8	19	0	0
BeginDate	datetime	8	23	3	1
EndDate	datetime	8	23	3	1
Notes2	text	16			1
AgencyID	bigint	8	19	0	1
Contract_type	char	10	10		0
isComplete	bit	1	1	0	0
DeliveryID	bigint	8	19	0	1
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_MediaPlacements_Friday	MediaPlacements	Friday				(0)
Default	DF_MediaPlacements_isComplete	MediaPlacements	isComplete				(0)
Default	DF_MediaPlacements_Monday	MediaPlacements	Monday				(0)
Default	DF_MediaPlacements_Saturday	MediaPlacements	Saturday				(0)
Default	DF_MediaPlacements_Sunday	MediaPlacements	Sunday				(0)
Default	DF_MediaPlacements_Thursday	MediaPlacements	Thursday				(0)
Default	DF_MediaPlacements_Tuesday	MediaPlacements	Tuesday				(0)
Default	DF_MediaPlacements_Wednesday	MediaPlacements	Wednesday				(0)
Foreign Key	FK_MediaPlacements_DeliveryMethods	MediaPlacements	DeliveryID	DeliveryMethods	Delivery_method_id	1
Foreign Key	FK_MediaPlacements_MediaAgencies	MediaPlacements	AgencyID	MediaAgencies	Agency_Id	1
Foreign Key	FK_MediaPlacements_MediaOutlets	MediaPlacements	MediaID	MediaOutlets	MediaCode_Id	1
Foreign Key	FK_MediaPlacements_MediaPrograms	MediaPlacements	ProgramID	MediaPrograms	ProgramID	1
Primary Key	PK_MediaPlacements	MediaPlacements	PlacementID	MediaPlacementRates	PlacementID	1
Primary Key	PK_MediaPlacements	MediaPlacements	PlacementID	MediaPlacementShare	PlacementID	1

Indexes
Index Name		Indexed Columns
PK_MediaPlacements		PlacementID
IDX_MediaPlacements_MediaID		MediaID
tMediaPlacements

Back To Top ^

MediaPlacementShare
Column	Type	Length	Precision	Scale	Nullable	Comments
PlacementID	bigint	8	19	0	0
SharePct_Sales	numeric	5	5	4	0
SharePct_Gifts	numeric	5	5	4	0
ShareMax	money	8	19	4	1
ShareMin	money	8	19	4	1
ShareMaxType	varchar	12	12		1
ShareMinType	varchar	12	12		1
ShareID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaPlacementShare_MediaPlacements	MediaPlacementShare	PlacementID	MediaPlacements	PlacementID	1

Indexes
Index Name		Indexed Columns
MediaPlacementShare
PK_MediaPlacementShare		ShareID
IDX_MediaPlacementShare_PlacementId		PlacementID

Back To Top ^

MediaPremiums
Column	Type	Length	Precision	Scale	Nullable	Comments
PremiumID	bigint	8	19	0	0
ProductID	bigint	8	19	0	0
AirDateID	bigint	8	19	0	0
Qty	int	4	10	0	0
SpeakLine	varchar	200	200		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediaPremiums_MediaAirDates	MediaPremiums	AirDateID	MediaAirDates	AirDateID	1
Foreign Key	FK_MediaPremiums_Products	MediaPremiums	ProductID	Products	ProductID	1

Indexes
Index Name		Indexed Columns
PK_MediaPremiums		PremiumID

Back To Top ^

MediaPrograms
Column	Type	Length	Precision	Scale	Nullable	Comments
ProgramID	bigint	8	19	0	0
Name	varchar	100	100		0
Notes	varchar	2000	2000		1
Length	int	4	10	0	1
MinSec	varchar	10	10		1
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK__MediaPrograms__160F4887	MediaPrograms	ProgramID	MediaEpisodes	ProgramID	1
Primary Key	PK__MediaPrograms__160F4887	MediaPrograms	ProgramID	MediaPlacements	ProgramID	1

Indexes
Index Name		Indexed Columns
PK__MediaPrograms__160F4887		ProgramID

Back To Top ^

MediumSubTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
Medium_Id	bigint	8	19	0	0
Medium_subType_Id	bigint	8	19	0	0
Medium_subType	varchar	50	50		0
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_MediumSubTypes_MediumTypes	MediumSubTypes	Medium_Id	MediumTypes	Medium_Id	1
Primary Key	PK_MediumSubTypes	MediumSubTypes	Medium_subType_Id	MediaOutlets	Medium_subType_Id	1

Indexes
Index Name		Indexed Columns
MediumSubTypes
PK_MediumSubTypes		Medium_subType_Id

Back To Top ^

MediumTypes
Column	Type	Length	Precision	Scale	Nullable	Comments
Medium_Id	bigint	8	19	0	0
Medium_type	varchar	50	50		0
Inactive	int	4	10	0	1
CoverageType	varchar	10	10		0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_MediumTypes_CoverageType	MediumTypes	CoverageType				('ALL')
Primary Key	PK_MediumTypes	MediumTypes	Medium_Id	MediaOutlets	Medium_Id	1
Primary Key	PK_MediumTypes	MediumTypes	Medium_Id	MediumSubTypes	Medium_Id	1

Indexes
Index Name		Indexed Columns
MediumTypes
PK_MediumTypes		Medium_Id

Back To Top ^

Metro
Column	Type	Length	Precision	Scale	Nullable	Comments
Metro_id	bigint	8	19	0	0
Metro_name	varchar	50	50		0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_Metro	Metro	Metro_id	MetroDefinitions	Metro_id	1

Indexes
Index Name		Indexed Columns
Metro
PK_Metro		Metro_id

Back To Top ^

MetroDefinitions
Column	Type	Length	Precision	Scale	Nullable	Comments
Metro_Id	bigint	8	19	0	0
Metro_zip	varchar	12	12		0
County	varchar	50	50		1
State	varchar	50	50		1
Metro	bit	1	1	0	0
DMA	bit	1	1	0	0
TSA	bit	1	1	0	0
TableId	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_MetroDefinitions_DMA	MetroDefinitions	DMA				(0)
Default	DF_MetroDefinitions_Metro	MetroDefinitions	Metro				(0)
Default	DF_MetroDefinitions_TSA	MetroDefinitions	TSA				(0)
Foreign Key	FK_MetroDefinitions_Metro	MetroDefinitions	Metro_Id	Metro	Metro_id	1

Indexes
Index Name		Indexed Columns
PK_MetroDefinitions		TableId
IDX_Metro_id_Metro_Zip		Metro_Id, Metro_zip

Back To Top ^

MotivationCodes
Column	Type	Length	Precision	Scale	Nullable	Comments
MotvCodeID	bigint	8	19	0	0
MotvCode	varchar	50	50		0
MotvGrp	varchar	50	50		1
Descript	varchar	2000	2000		1
Nbr	int	4	10	0	1
MDate	datetime	8	23	3	1
Cost	money	8	19	4	1
NbrResp	int	4	10	0	1
NbrGifts	int	4	10	0	1
NbrSales	int	4	10	0	1
GiftAmt	money	8	19	4	1
SaleAmt	money	8	19	4	1
DefProjCode	varchar	50	50		1
DefPldgcode	varchar	50	50		1
Status	varchar	1	1		1
AddUserID	bigint	8	19	0	1
ChangeUserID	bigint	8	19	0	1
ChangeDate	smalldatetime	4	16	0	1
AddDate	smalldatetime	4	16	0	1
Category	varchar	50	50		1
Campaign	varchar	50	50		1
Kit	varchar	50	50		1
CostPer	money	8	19	4	1
User1	varchar	50	50		1
User2	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_MotivationCodes_AddDate	MotivationCodes	AddDate				(getdate())
Primary Key	PK_MotivationCodes	MotivationCodes	MotvCodeID	MotivationCrossRef	MotvCodeID	1

Indexes
Index Name		Indexed Columns
PK_MotivationCodes		MotvCodeID
IDX_MotvCode_MotivationCodes		MotvCode

Back To Top ^

MotivationCrossRef
Column	Type	Length	Precision	Scale	Nullable	Comments
MotvXrefId	bigint	8	19	0	0
MotvGrpID	bigint	8	19	0	0
MotvCodeID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK__Motivatio__MotvC__26A739B1	MotivationCrossRef	MotvCodeID	MotivationCodes	MotvCodeID	1
Foreign Key	FK__Motivatio__MotvG__25B31578	MotivationCrossRef	MotvGrpID	MotivationGroups	MotvGrpID	1
Unique	IDX_UK_MotivationCrossRef	MotivationCrossRef	MotvCodeID			2
Unique	IDX_UK_MotivationCrossRef	MotivationCrossRef	MotvGrpID			1

Indexes
Index Name		Indexed Columns
PK__MotivationCrossR__23CACD06		MotvXrefId
IDX_UK_MotivationCrossRef		MotvGrpID, MotvCodeID

Back To Top ^

MotivationGroups
Column	Type	Length	Precision	Scale	Nullable	Comments
MotvGrpID	bigint	8	19	0	0
MotvGrp	varchar	50	50		1
Descript	varchar	2000	2000		1
MDate	datetime	8	23	3	1
Cost	money	8	19	4	1
Inactive	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_MotivationGroups	MotivationGroups	MotvGrpID	MotivationCrossRef	MotvGrpID	1

Indexes
Index Name		Indexed Columns
PK_MotivationGroups		MotvGrpID

Back To Top ^

NoteCodes
Column	Type	Length	Precision	Scale	Nullable	Comments
CodeType	varchar	50	50		0
Descript	varchar	2000	2000		1
DataType	varchar	8	8		1
Secured	bit	1	1	0	0
Inactive	int	4	10	0	1

Indexes
Index Name		Indexed Columns
PK_NoteCodes		CodeType

Back To Top ^

Numbers
Column	Type	Length	Precision	Scale	Nullable	Comments
CodeType	varchar	8	8		0
Descript	varchar	80	80		1
DataType	varchar	8	8		0
Secured	bit	1	1	0	0

Indexes
Index Name		Indexed Columns
PK_Numbers		DataType, CodeType

Back To Top ^

OrderAddresses
Column	Type	Length	Precision	Scale	Nullable	Comments
OrderAddressID	bigint	8	19	0	0
OrdNbr	bigint	8	19	0	0
sName	varchar	100	100		1
saddrlines	varchar	2000	2000		1
scity	varchar	50	50		1
sstate	varchar	50	50		1
szip	varchar	100	100		1
scounty	varchar	65	65		1
scountry	varchar	100	100		1
bName	varchar	100	100		1
baddrlines	varchar	2000	2000		1
bcity	varchar	50	50		1
bstate	varchar	50	50		1
bzip	varchar	100	100		1
bcounty	varchar	65	65		1
bcountry	varchar	100	100		1
sTitle	varchar	50	50		1
sFirstName	varchar	50	50		1
sLastName	varchar	100	100		1
sSuffix	varchar	50	50		1
bTitle	varchar	50	50		1
bFirstName	varchar	50	50		1
bLastName	varchar	100	100		1
bSuffix	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_OrderAddresses_OrderHeader	OrderAddresses	OrdNbr	OrderHeader	OrdNbr	1

Indexes
Index Name		Indexed Columns
PK_OrderAddresses		OrderAddressID, OrdNbr

Back To Top ^

OrderAnnual
Column	Type	Length	Precision	Scale	Nullable	Comments
OrderAnnualID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
CurrCode	varchar	50	50		1
CurrYear	int	4	10	0	0
Nbr	int	4	10	0	1
Amt	money	8	19	4	1
ConvAmt	money	8	19	4	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_OrderAnnual_Entity	OrderAnnual	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_OrderAnnualSummary		OrderAnnualID
IDX_OrderAnnual_Entity		EntityID

Back To Top ^

OrderComments
Column	Type	Length	Precision	Scale	Nullable	Comments
OrderCommentsID	bigint	8	19	0	0
OrdNbr	bigint	8	19	0	0
Comm	text	16			1
PrintFlag	varchar	1	1		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_OrderComments_OrderHeader	OrderComments	OrdNbr	OrderHeader	OrdNbr	1

Indexes
Index Name		Indexed Columns
PK_OrderComments		OrderCommentsID
IDX_OrdNbr_OrderComments		OrdNbr
tOrderComments

Back To Top ^

OrderDetail
Column	Type	Length	Precision	Scale	Nullable	Comments
OrderDetailID	bigint	8	19	0	0
OrdNbr	bigint	8	19	0	0
PrcCode	varchar	50	50		1
Price	money	8	19	4	0
PurQty	int	4	10	0	0
FreeQty	int	4	10	0	0
PurStatus	varchar	1	1		1
FreeStatus	varchar	1	1		1
ProductID	bigint	8	19	0	0
ReduceInv	int	4	10	0	0
Category	varchar	50	50		1
ProductLocationID	bigint	8	19	0	1
FairMarketValue	money	8	19	4	1
FreeLocationID	bigint	8	19	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__OrderDeta__Reduc__1293BD5E	OrderDetail	ReduceInv				(1)
Default	DF_OrderDetail_FreeQty	OrderDetail	FreeQty				(0)
Default	DF_OrderDetail_Price	OrderDetail	Price				(0)
Default	DF_OrderDetail_PurQty	OrderDetail	PurQty				(0)
Foreign Key	FK_OrderDetail_OrderHeader	OrderDetail	OrdNbr	OrderHeader	OrdNbr	1
Foreign Key	FK_OrderDetail_ProductLocation	OrderDetail	ProductLocationID	ProductLocation	ProductLocationID	1
Primary Key	PK_OrderDetail	OrderDetail	OrderDetailID	OrderSubscriptions	OrderDetailID	1

Indexes
Index Name		Indexed Columns
PK_OrderDetail		OrderDetailID
IDX_OrdNbr_ProductId_OrderDetail		OrdNbr, ProductID
IX_LocationID		ProductLocationID, FreeLocationID

Back To Top ^

OrderHeader
Column	Type	Length	Precision	Scale	Nullable	Comments
OrdNbr	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
Status	varchar	50	50		1
BatchNbr	bigint	8	19	0	1
Odate	datetime	8	23	3	1
ADate	datetime	8	23	3	1
LDate	datetime	8	23	3	1
BDate	datetime	8	23	3	1
SDate	datetime	8	23	3	1
CDate	datetime	8	23	3	1
RDate	datetime	8	23	3	1
MotvCode	varchar	50	50		1
MediaCode	varchar	50	50		1
TotFunds	money	8	19	4	1
TotCredits	money	8	19	4	1
Amt	money	8	19	4	1
Discount	money	8	19	4	1
Tax	money	8	19	4	1
Postage	money	8	19	4	1
GiftAmt	money	8	19	4	1
Refund	money	8	19	4	1
AmtDue	money	8	19	4	1
GiftRef	int	4	10	0	1
GiftFundId	varchar	6	6		1
GiftPldgCode	varchar	50	50		1
GiftPldgRef	int	4	10	0	1
GiftMotvCode	varchar	50	50		1
InvProcess	varchar	1	1		1
PayCode	varchar	50	50		1
PayType	varchar	50	50		1
PayNbr	varchar	20	20		1
Expire	varchar	8	8		1
ChargeAuth	varchar	8	8		1
CurrCode	varchar	50	50		1
ConvRate	float	8	53		1
LtrCode	varchar	50	50		1
ParaCode1	varchar	50	50		1
ParaCode2	varchar	50	50		1
PrintPack	varchar	1	1		1
PrtGrp	int	4	10	0	1
AddrType	varchar	50	50		1
ComputeTax	varchar	1	1		1
ComputePostage	varchar	1	1		1
PostageCode	varchar	50	50		1
SecondTax	money	8	19	4	1
AddUserID	bigint	8	19	0	1
ChgUserID	bigint	8	19	0	1
RouteNbr	varchar	16	16		1
AddDate	datetime	8	23	3	1
ChgDate	datetime	8	23	3	1
ProgramID	bigint	8	19	0	1
EpisodeID	bigint	8	19	0	1
SecCode	varchar	8	8		1
Pdate	datetime	8	23	3	1
TrackingNbr	varchar	799	799		1
FairMarketValue	money	8	19	4	1
Bank	varchar	50	50		1
RefNbr	bigint	8	19	0	1
ActualShipAmount	money	8	19	4	1
ActualShipWeight	float	8	53		1
VoidAuth	varchar	8	8		1
TransID	bigint	8	19	0	1
MediaPlacementId	bigint	8	19	0	1
CardNumberEncrypted	varbinary	256	256		1	KEY:Description VALUE: Encrypted Credit Card Number

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_OrderHeader_Batches	OrderHeader	BatchNbr	Batches	BatchNbr	1
Primary Key	PK_OrderHeader	OrderHeader	OrdNbr	OrderAddresses	OrdNbr	1
Primary Key	PK_OrderHeader	OrderHeader	OrdNbr	OrderComments	OrdNbr	1
Primary Key	PK_OrderHeader	OrderHeader	OrdNbr	OrderDetail	OrdNbr	1
Primary Key	PK_OrderHeader	OrderHeader	OrdNbr	OrderSubscriptions	OrdNbr	1

Indexes
Index Name		Indexed Columns
PK_OrderHeader		OrdNbr
IDX_EntityID_OrderHeader		EntityID
IDX_Amt_OrderHeader		Amt
IDX_OrderHeader_Status		Status
IDX_BatchNbr_OrderHeader		BatchNbr
IDX_MediaCode_OrderHeader		MediaCode
IDX_MotvCode_OrderHeader		MotvCode
IDX_GiftRef_OrderHeader		GiftRef
IDX_OrderHeader_MediaPlacements		Odate, MediaPlacementId
IDX_ADate_OrderHeader		ADate

Back To Top ^

OrderSubscriptions
Column	Type	Length	Precision	Scale	Nullable	Comments
RenewalEntityID	bigint	8	19	0	0
ProductID	bigint	8	19	0	1
Status	varchar	1	1		1
PurQty	int	4	10	0	1
RemainQty	int	4	10	0	1
MotvCode	varchar	50	50		1
OrdNbr	bigint	8	19	0	1
AddDate	datetime	8	23	3	1
LastDate	datetime	8	23	3	1
SubType	varchar	1	1		0
AddrType	varchar	50	50		1
OrderDetailID	bigint	8	19	0	0
sName	varchar	80	80		1
saddrlines	varchar	2000	2000		1
scity	varchar	50	50		1
sstate	varchar	50	50		1
szip	varchar	50	50		1
scounty	varchar	65	65		1
scountry	varchar	50	50		1
lastUser	bigint	8	19	0	1
note	varchar	2000	2000		1
AddUser	bigint	8	19	0	1
sTitle	varchar	50	50		1
sFirstName	varchar	50	50		1
sLastName	varchar	50	50		1
sSuffix	varchar	50	50		1
SubscriptionID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__OrderSubs__lastU__7D63964E	OrderSubscriptions	lastUser				(0)
Default	DF__OrderSubs__SubTy__405A880E	OrderSubscriptions	SubType				('P')
Foreign Key	FK_OrderSubscriptions_Entity	OrderSubscriptions	RenewalEntityID	Entity	EntityID	1
Foreign Key	FK_OrderSubscriptions_OrderDetail	OrderSubscriptions	OrderDetailID	OrderDetail	OrderDetailID	1
Foreign Key	FK_OrderSubscriptions_OrderHeader	OrderSubscriptions	OrdNbr	OrderHeader	OrdNbr	1
Foreign Key	FK_OrderSubscriptions_Products	OrderSubscriptions	ProductID	Products	ProductID	1
Primary Key	PK_OrderSubscriptions	OrderSubscriptions	OrderDetailID	SubscriptionHistory	OrderDetailID	1

Indexes
Index Name		Indexed Columns
PK_OrderSubscriptions		OrderDetailID

Back To Top ^

OrderSummary
Column	Type	Length	Precision	Scale	Nullable	Comments
OrderSummaryID	bigint	8	19	0	0
EntityID	bigint	8	19	0	0
CurrCode	varchar	50	50		1
Amt	money	8	19	4	1
ConvAmt	money	8	19	4	1
Nbr	int	4	10	0	1
FirstDate	datetime	8	23	3	1
FirstAmt	money	8	19	4	1
FirstConvAmt	money	8	19	4	1
FirstOrdNbr	int	4	10	0	1
LargeDate	datetime	8	23	3	1
LargeAmt	money	8	19	4	1
LargeConvAmt	money	8	19	4	1
LargeOrdNbr	int	4	10	0	1
LastDate	datetime	8	23	3	1
LastAmt	money	8	19	4	1
LastConvAmt	money	8	19	4	1
LastOrdNbr	int	4	10	0	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_OrderSummary_Entity	OrderSummary	EntityID	Entity	EntityID	1

Indexes
Index Name		Indexed Columns
PK_OrderSummary		OrderSummaryID
IDX_OrderSummary_Entity		EntityID

Back To Top ^

OrgSettings
Column	Type	Length	Precision	Scale	Nullable	Comments
OrgSettingID	bigint	8	19	0	0
OrgName	varchar	50	50		0
OrgValue	varchar	2000	2000		1

Indexes
Index Name		Indexed Columns
PK_OrgSettings		OrgSettingID

Back To Top ^

Processes
Column	Type	Length	Precision	Scale	Nullable	Comments
ProcessID	bigint	8	19	0	0
UserID	bigint	8	19	0	0
ModuleName	varchar	50	50		1
ViewName	varchar	50	50		1
ViewID	varchar	50	50		1
Ordinal	int	4	10	0	0
DisplayName	varchar	30	30		1

Indexes
Index Name		Indexed Columns
PK_Processes		ProcessID

Back To Top ^

ProductAccountingSetup
Column	Type	Length	Precision	Scale	Nullable	Comments
AcctID	bigint	8	19	0	0
ProductID	bigint	8	19	0	0
Type	varchar	50	50		0
Descript	varchar	200	200		1
Category	varchar	50	50		0
Fund	varchar	50	50		0
GLAcct	varchar	50	50		0
CC	varchar	50	50		0
ProjCode	varchar	50	50		1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_ProductAccountingSetup_Products	ProductAccountingSetup	ProductID	Products	ProductID	1

Indexes
Index Name		Indexed Columns
PK_ProductAccountingSetup		AcctID
IDX_ProductID_ProductAccountingSetup		ProductID

Back To Top ^

ProductActivity
Column	Type	Length	Precision	Scale	Nullable	Comments
ActivityID	bigint	8	19	0	0
ProductID	bigint	8	19	0	0
LocCode	varchar	50	50		0
TDate	datetime	8	23	3	0
Type	varchar	50	50		0
Qty	int	4	10	0	0
Descript	varchar	2000	2000		1
UnitCost	money	8	19	4	1
AddDate	datetime	8	23	3	0
AddUserID	bigint	8	19	0	0
Category	varchar	50	50		1
TargetProductID	bigint	8	19	0	1
TargetLocation	varchar	50	50		1
QtyConsumed	int	4	10	0	1
EstDeliveryDate	datetime	8	23	3	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_ProductActivity_Products	ProductActivity	TargetProductID	Products	ProductID	1
Foreign Key	FK_ProductActivity_Products1	ProductActivity	ProductID	Products	ProductID	1
Foreign Key	FK_ProductActivity_tblUser	ProductActivity	AddUserID	tblUser	userID	1

Indexes
Index Name		Indexed Columns
PK_ProductActivity		ActivityID, ProductID, LocCode, Type
IDX_ProductActivity_ProductID		ProductID

Back To Top ^

ProductBOM
Column	Type	Length	Precision	Scale	Nullable	Comments
BOMID	bigint	8	19	0	0
Qty	int	4	10	0	0
ProductID	bigint	8	19	0	0
ComponentID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_ProductBOM_Products	ProductBOM	ProductID	Products	ProductID	1
Foreign Key	FK_ProductBOM_Products1	ProductBOM	ComponentID	Products	ProductID	1

Indexes
Index Name		Indexed Columns
PK_ProductBOM		BOMID
IDX_ProductID_ComponentID		ProductID, ComponentID
idx_ProductBOM_ComponentID		ComponentID

Back To Top ^

ProductDiscounts
Column	Type	Length	Precision	Scale	Nullable	Comments
DiscountID	bigint	8	19	0	0
PrcCode	varchar	50	50		0
UpperLimit	money	8	19	4	0
Rate	float	8	53		1

Indexes
Index Name		Indexed Columns
PK_ProductDiscounts		DiscountID

Back To Top ^

ProductHistory
Column	Type	Length	Precision	Scale	Nullable	Comments
ProductHistoryID	bigint	8	19	0	0
ProductID	bigint	8	19	0	0
LocCode	varchar	50	50		0
CurrYear	int	4	10	0	0
CurrMonth	int	4	10	0	0
QtyBeg	int	4	10	0	0
QtyAll	int	4	10	0	0
QtyOrd	int	4	10	0	0
QtyRec	int	4	10	0	0
QtyTrn	int	4	10	0	0
QtyAdj	int	4	10	0	0
QtyShp	int	4	10	0	0
QtyBck	int	4	10	0	0
QtyAct	int	4	10	0	0
AvgCst	money	8	19	4	0
ReOrder	int	4	10	0	0
nextdeliverydate	datetime	8	23	3	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF_ProductAvailability_AvgCst	ProductHistory	AvgCst				(0)
Default	DF_ProductAvailability_QtyAct	ProductHistory	QtyAct				(0)
Default	DF_ProductAvailability_QtyAdj	ProductHistory	QtyAdj				(0)
Default	DF_ProductAvailability_QtyAll	ProductHistory	QtyAll				(0)
Default	DF_ProductAvailability_QtyBck	ProductHistory	QtyBck				(0)
Default	DF_ProductAvailability_QtyBeg	ProductHistory	QtyBeg				(0)
Default	DF_ProductAvailability_QtyOrd	ProductHistory	QtyOrd				(0)
Default	DF_ProductAvailability_QtyRec	ProductHistory	QtyRec				(0)
Default	DF_ProductAvailability_QtyShp	ProductHistory	QtyShp				(0)
Default	DF_ProductAvailability_QtyTrn	ProductHistory	QtyTrn				(0)
Foreign Key	FK_ProductAvailability_Products	ProductHistory	ProductID	Products	ProductID	1
Unique	IDX_UK_ProductHistory	ProductHistory	CurrMonth			4
Unique	IDX_UK_ProductHistory	ProductHistory	CurrYear			3
Unique	IDX_UK_ProductHistory	ProductHistory	LocCode			2
Unique	IDX_UK_ProductHistory	ProductHistory	ProductID			1

Indexes
Index Name		Indexed Columns
PK_ProductAvailability		ProductHistoryID
IDX_UK_ProductHistory		ProductID, LocCode, CurrYear, CurrMonth

Back To Top ^

ProductKeywords
Column	Type	Length	Precision	Scale	Nullable	Comments
ProdKeywordID	bigint	8	19	0	0
Keyword	varchar	50	50		0
ProductID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_ProductKeywords_Products	ProductKeywords	ProductID	Products	ProductID	1

Indexes
Index Name		Indexed Columns
PK_ProductKeywords		ProdKeywordID
IDX_ProductKeywords_ProductID		ProductID

Back To Top ^

ProductLocation
Column	Type	Length	Precision	Scale	Nullable	Comments
ProductLocationID	bigint	8	19	0	0
LocCode	varchar	50	50		0
LocActual	varchar	50	50		1
Note	varchar	2000	2000		1
ProductID	bigint	8	19	0	0
Allocated	int	4	10	0	0
OnHand	int	4	10	0	0
OnOrder	int	4	10	0	0
EstDeliveryDate	datetime	8	23	3	1
Backordered	int	4	10	0	0
Inactive	bit	1	1	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Default	DF__ProductLo__Backo__3D53FE31	ProductLocation	Backordered				(0)
Default	DF__ProductLo__Inact__1F0617E9	ProductLocation	Inactive				(0)
Default	DF_ProductLocation_Allocated	ProductLocation	Allocated				(0)
Default	DF_ProductLocation_OnHand	ProductLocation	OnHand				(0)
Default	DF_ProductLocation_OnOrder	ProductLocation	OnOrder				(0)
Foreign Key	FK_ProductLocation_Products	ProductLocation	ProductID	Products	ProductID	1
Primary Key	PK_ProductLocation	ProductLocation	ProductLocationID	OrderDetail	ProductLocationID	1
Primary Key	PK_ProductLocation	ProductLocation	ProductLocationID	SubscriptionHistory	ProductLocationID	1

Indexes
Index Name		Indexed Columns
PK_ProductLocation		ProductLocationID
IDX_ProductLocation_ProductID_LocCode		ProductID, LocCode

Back To Top ^

ProductPrices
Column	Type	Length	Precision	Scale	Nullable	Comments
ProductPriceID	bigint	8	19	0	0
PriceCode	varchar	50	50		0
Price	money	8	19	4	1
Note	varchar	2000	2000		1
ProductID	bigint	8	19	0	0

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Foreign Key	FK_ProductPrices_Products	ProductPrices	ProductID	Products	ProductID	1

Indexes
Index Name		Indexed Columns
PK_ProductPrices		ProductPriceID
IDX_ProductPrices_ProductID		ProductID

Back To Top ^

Products
Column	Type	Length	Precision	Scale	Nullable	Comments
ProductID	bigint	8	19	0	0
ProdCode	varchar	50	50		0
Descript	varchar	2000	2000		1
Desc2	varchar	50	50		1
Type	varchar	50	50		0
Designation	varchar	50	50		0
Category	varchar	50	50		1
Weight	float	8	53		1
Inactive	int	4	10	0	1
Class	varchar	50	50		1
PreferredVendor	varchar	50	50		1
PreferredVendorID	bigint	8	19	0	1
MinReorderQty	int	4	10	0	1
LeadTime	int	4	10	0	1
ProjectedCost	money	8	19	4	1
ActualCost	money	8	19	4	1
FairMarketValue	money	8	19	4	1
AddUserId	bigint	8	19	0	1
AddDate	datetime	8	23	3	1
ChgUserID	bigint	8	19	0	1
ChgDate	datetime	8	23	3	1
Note	varchar	2000	2000		1
DefaultPrice	money	8	19	4	1

Constraints
Constraint Type	Contraint Name	Table	Column	FK Table	FK Column	Key No.	Default
Primary Key	PK_Products	Products	ProductID	MediaPremiums	ProductID	1
Primary Key	PK_Products	Products	ProductID	OrderSubscriptions	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductAccountingSetup	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductActivity	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductBOM	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductHistory	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductKeywords	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductLocation	ProductID	1
Primary Key	PK_Products	Products	ProductID	ProductPrices	ProductID	1
Primary Key	PK_Products	Products	ProductID	SubscriptionHistory	ProductID	1

Indexes
Index Name		Indexed Columns
PK_Products		ProductID
IDX_Products_ProdCode		ProdCode

Back To Top ^

ProjectCategory
Column	Type	Length	Precision	Scale	Nullable	Comments
ProjectCategoryID	bigint	8	19	0	0
SubAcct	varchar	3	3		1
ActiveDonor	bit	1	1	0	1
ActiveAcct	bit	1