vpBills.FK_vpBills_lsVendors
Relationship Name FK_vpBills_lsVendors
Parent Table [dbo].[lsVendors]
Child Table vpBills

Foreign Keys
Parent Key Child Key
EY([Vendor] EY([Vendor]

vpPurchaseOrders.FK_vpPurchaseOrders_lsShippingMethods
Relationship Name FK_vpPurchaseOrders_lsShippingMethods
Parent Table [dbo].[lsShippingMethods]
Child Table vpPurchaseOrders

Foreign Keys
Parent Key Child Key
EY([ShipVia] EY([ShipVia]

vpPurchaseOrders.FK_vpPurchaseOrders_lsTerms
Relationship Name FK_vpPurchaseOrders_lsTerms
Parent Table [dbo].[lsTerms]
Child Table vpPurchaseOrders

Foreign Keys
Parent Key Child Key
EY([Term] EY([Term]

vpPurchaseOrders.FK_vpPurchaseOrders_lsVendors
Relationship Name FK_vpPurchaseOrders_lsVendors
Parent Table [dbo].[lsVendors]
Child Table vpPurchaseOrders

Foreign Keys
Parent Key Child Key
EY([Vendor] EY([Vendor]

vpBillPayments.FK_vpBillPayments_lsAccounts
Relationship Name FK_vpBillPayments_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table vpBillPayments

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

vpBillPayments.FK_vpBillPayments_lsAccounts1
Relationship Name FK_vpBillPayments_lsAccounts1
Parent Table [dbo].[lsAccounts]
Child Table vpBillPayments

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

vpBillPayments.FK_vpBillPayments_lsVendors
Relationship Name FK_vpBillPayments_lsVendors
Parent Table [dbo].[lsVendors]
Child Table vpBillPayments

Foreign Keys
Parent Key Child Key
EY([Vendor] EY([Vendor]

csOrders.FK_csOrders_lsCustomers
Relationship Name FK_csOrders_lsCustomers
Parent Table [dbo].[lsCustomers]
Child Table csOrders

Foreign Keys
Parent Key Child Key
EY([Customer] EY([Customer]

csOrders.FK_csOrders_lsShippingMethods
Relationship Name FK_csOrders_lsShippingMethods
Parent Table [dbo].[lsShippingMethods]
Child Table csOrders

Foreign Keys
Parent Key Child Key
EY([ShipVia] EY([ShipVia]

csOrders.FK_csOrders_lsTerms
Relationship Name FK_csOrders_lsTerms
Parent Table [dbo].[lsTerms]
Child Table csOrders

Foreign Keys
Parent Key Child Key
EY([Term] EY([Term]

csInvoices.FK_csInvoices_lsCustomers
Relationship Name FK_csInvoices_lsCustomers
Parent Table [dbo].[lsCustomers]
Child Table csInvoices

Foreign Keys
Parent Key Child Key
EY([Customer] EY([Customer]

csInvoices.FK_csInvoices_lsShippingMethods
Relationship Name FK_csInvoices_lsShippingMethods
Parent Table [dbo].[lsShippingMethods]
Child Table csInvoices

Foreign Keys
Parent Key Child Key
EY([ShipVia] EY([ShipVia]

csInvoices.FK_csInvoices_lsTerms
Relationship Name FK_csInvoices_lsTerms
Parent Table [dbo].[lsTerms]
Child Table csInvoices

Foreign Keys
Parent Key Child Key
EY([Term] EY([Term]

csInvoices.FK_csInvoices_lsTerms1
Relationship Name FK_csInvoices_lsTerms1
Parent Table [dbo].[lsTerms]
Child Table csInvoices

Foreign Keys
Parent Key Child Key
EY([Term] EY([Term]

lsCustomers.FK_lsCustomers_lsAccounts
Relationship Name FK_lsCustomers_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table lsCustomers

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

lsCustomers.FK_lsCustomers_lsAccounts1
Relationship Name FK_lsCustomers_lsAccounts1
Parent Table [dbo].[lsAccounts]
Child Table lsCustomers

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

lsCustomers.FK_lsCustomers_lsEmployees
Relationship Name FK_lsCustomers_lsEmployees
Parent Table [dbo].[lsEmployees]
Child Table lsCustomers

Foreign Keys
Parent Key Child Key
EY([Rep] EY([Rep]

lsCustomers.FK_lsCustomers_lsTerms
Relationship Name FK_lsCustomers_lsTerms
Parent Table [dbo].[lsTerms]
Child Table lsCustomers

Foreign Keys
Parent Key Child Key
EY([Term] EY([Term]

csCustomerCredits.FK_csCustomerCredits_lsCustomers
Relationship Name FK_csCustomerCredits_lsCustomers
Parent Table [dbo].[lsCustomers]
Child Table csCustomerCredits

Foreign Keys
Parent Key Child Key
EY([Customer] EY([Customer]

csCustomerPayments.FK_csCustomerPayments_lsAccounts
Relationship Name FK_csCustomerPayments_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table csCustomerPayments

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

csCustomerPayments.FK_csCustomerPayments_lsCustomers
Relationship Name FK_csCustomerPayments_lsCustomers
Parent Table [dbo].[lsCustomers]
Child Table csCustomerPayments

Foreign Keys
Parent Key Child Key
EY([Customer] EY([Customer]

lsProjects.FK_lsProjects_lsCustomers
Relationship Name FK_lsProjects_lsCustomers
Parent Table [dbo].[lsCustomers]
Child Table lsProjects

Foreign Keys
Parent Key Child Key
EY([Customer] EY([Customer]

lsProjects.FK_lsProjects_lsEmployees
Relationship Name FK_lsProjects_lsEmployees
Parent Table [dbo].[lsEmployees]
Child Table lsProjects

Foreign Keys
Parent Key Child Key
EY([ProjectManager] EY([ProjectManager]

TimeTracking.FK_TimeTracking_lsEmployees
Relationship Name FK_TimeTracking_lsEmployees
Parent Table [dbo].[lsEmployees]
Child Table TimeTracking

Foreign Keys
Parent Key Child Key
EY([Employee] EY([Employee]

lsAccounts.FK_lsAccounts_lsAccountTypes
Relationship Name FK_lsAccounts_lsAccountTypes
Parent Table [dbo].[lsAccountTypes]
Child Table lsAccounts

Foreign Keys
Parent Key Child Key
EY([AccountType] EY([AccountType]

EmpChecks.FK_EmpChecks_lsAccounts
Relationship Name FK_EmpChecks_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table EmpChecks

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

InventoryAdjustments.FK_InventoryAdjustments_lsAccounts
Relationship Name FK_InventoryAdjustments_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table InventoryAdjustments

Foreign Keys
Parent Key Child Key
EY([AdjustmentAccount] EY([AdjustmentAccount]

lsTaxes.FK_lsTaxes_lsAccounts
Relationship Name FK_lsTaxes_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table lsTaxes

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

lsVendors.FK_lsVendors_lsAccounts
Relationship Name FK_lsVendors_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table lsVendors

Foreign Keys
Parent Key Child Key
EY([DefaultExpenseAccount] EY([DefaultExpenseAccount]

lsEmployees.FK_lsEmployees_lsAccounts
Relationship Name FK_lsEmployees_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table lsEmployees

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

lsItems.FK_lsItems_lsAccounts
Relationship Name FK_lsItems_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table lsItems

Foreign Keys
Parent Key Child Key
EY([COGSAccount] EY([COGSAccount]

lsItems.FK_lsItems_lsAccounts1
Relationship Name FK_lsItems_lsAccounts1
Parent Table [dbo].[lsAccounts]
Child Table lsItems

Foreign Keys
Parent Key Child Key
EY([IncomeAccount] EY([IncomeAccount]

lsItems.FK_lsItems_lsAccounts2
Relationship Name FK_lsItems_lsAccounts2
Parent Table [dbo].[lsAccounts]
Child Table lsItems

Foreign Keys
Parent Key Child Key
EY([AssetAccount] EY([AssetAccount]

bTransferFunds.FK_bTransferFunds_lsAccounts
Relationship Name FK_bTransferFunds_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table bTransferFunds

Foreign Keys
Parent Key Child Key
EY([FromAccount] EY([FromAccount]

bTransferFunds.FK_bTransferFunds_lsAccounts1
Relationship Name FK_bTransferFunds_lsAccounts1
Parent Table [dbo].[lsAccounts]
Child Table bTransferFunds

Foreign Keys
Parent Key Child Key
EY([ToAccount] EY([ToAccount]

vpBillExpenses.FK_vpBillExpenses_lsAccounts
Relationship Name FK_vpBillExpenses_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table vpBillExpenses

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

vpBillExpenses.FK_vpBillExpenses_lsAccounts1
Relationship Name FK_vpBillExpenses_lsAccounts1
Parent Table [dbo].[lsAccounts]
Child Table vpBillExpenses

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

bChecks.FK_bChecks_lsAccounts
Relationship Name FK_bChecks_lsAccounts
Parent Table [dbo].[lsAccounts]
Child Table bChecks

Foreign Keys
Parent Key Child Key
EY([Account] EY([Account]

InventoryAdjustmentDetail.FK_InventoryAdjustmentDetail_lsItems
Relationship Name FK_InventoryAdjustmentDetail_lsItems
Parent Table [dbo].[lsItems]
Child Table InventoryAdjustmentDetail

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]

vpBillItems.FK_vpBillItems_lsItems
Relationship Name FK_vpBillItems_lsItems
Parent Table [dbo].[lsItems]
Child Table vpBillItems

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]

csInvoiceItems.FK_csInvoiceItems_lsItems
Relationship Name FK_csInvoiceItems_lsItems
Parent Table [dbo].[lsItems]
Child Table csInvoiceItems

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]

vpPurchaseOrderDetails.FK_vpPurchaseOrderDetails_lsItems
Relationship Name FK_vpPurchaseOrderDetails_lsItems
Parent Table [dbo].[lsItems]
Child Table vpPurchaseOrderDetails

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]

csOrderItems.FK_csOrderItems_lsItems
Relationship Name FK_csOrderItems_lsItems
Parent Table [dbo].[lsItems]
Child Table csOrderItems

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]

csCustomerCreditItems.FK_csCustomerCreditItems_lsItems
Relationship Name FK_csCustomerCreditItems_lsItems
Parent Table [dbo].[lsItems]
Child Table csCustomerCreditItems

Foreign Keys
Parent Key Child Key
EY([Item] EY([Item]