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] |