dbo.primeAccountsReceivableInvoicesItemAllocation

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.primeAccountsReceivableInvoicesItemAllocation.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	InvoiceItemId	uniqueidentifier	no		Foreign key to the related invoice line item
2	AllocationId	uniqueidentifier	no		Foreign key to primeAllocations

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_AR_InvoiceItemAllocation	CLUSTERED	yes	yes	InvoiceItemId, AllocationId

Relationships (inferred)

From	To	Confidence
dbo.primeAccountsReceivableInvoicesItemAllocation.AllocationId	dbo.primeAllocations.Id	high
dbo.primeAccountsReceivableInvoicesItemAllocation.InvoiceItemId	dbo.primeAccountsReceivableInvoicesItem.Id	high

Referenced by

Views: dbo.vPrimeSalesinvoicesObjectivedb

Procedures: dbo.spEthSyncQueueMissingObjects, dbo.spPrimeUpsertAccountsReceivableInvoice, dbo.spPrimeUpsertAccountsReceivableInvoiceItemAllocation