dbo.primeAccountsReceivableInvoicesItem

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Id	uniqueidentifier	no		Primary key / unique identifier for this record
2	InvoiceId	uniqueidentifier	no		Foreign key to the related invoice
3	Description	nvarchar(4000)	yes		Free-text description
4	Quantity	decimal(19,4)	yes		Quantity of the item
5	Unit	nvarchar(50)	yes		Unit of measure for the quantity
6	Rate	decimal(19,4)	yes		Unit rate/price for the item
7	Subtotal	decimal(19,4)	yes		Subtotal amount before tax
8	IncludeTax	bit	yes		Flag indicating whether the line amount includes tax
9	TaxRate	decimal(10,4)	yes		Tax rate applied
10	Total	decimal(19,4)	yes		Total monetary amount
11	TaxTotal	decimal(19,4)	yes		Total tax amount
12	ItemCode	nvarchar(100)	yes		Item/product code
13	Version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeAcc__3214EC07863ABFEE	CLUSTERED	yes	yes	Id
nci_msft_1_primeAccountsReceivableInvoicesItem_C2EFE5FA7E2D217E66EF9DBF0AD22D31	NONCLUSTERED			InvoiceId

Relationships (inferred)

From	To	Confidence
dbo.primeAccountsReceivableInvoicesItemAllocation.InvoiceItemId	dbo.primeAccountsReceivableInvoicesItem.Id	high
dbo.primeAccountsReceivableInvoicesItem.InvoiceId	dbo.primeAccountsReceivableInvoices.Id	high

Referenced by

Views: dbo.vPrimeSalesinvoicesObjectivedb

Procedures: dbo.spEthSyncQueueMissingObjects, dbo.spPrimeUpsertAccountsReceivableInvoice, dbo.spPrimeUpsertAccountsReceivableInvoiceItem