dbo.primeExportActualInvoicedFYTD

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Supervisor	nvarchar(100)	yes		Display name of the supervisor
2	InvoiceNumber	nvarchar(50)	yes		Invoice number/reference
3	InvoiceAmountExclTax	decimal(18,2)	yes		Invoice amount excluding tax
4	JobNumber	nvarchar(50)	no		Human-readable job number/reference used in Prime Ecosystem
5	Assigned	nvarchar(100)	yes		Display name of the user this job/record is assigned to
6	InvoiceInvoicedDate	date	yes		Date the invoice was issued
7	Status	nvarchar(50)	yes		Current status of this record
8	AccountsReceivableType	nvarchar(100)	yes		Type/category of accounts-receivable entry
9	Client	nvarchar(200)	yes		Display name of the client
10	Insurer	nvarchar(200)	yes		Name of the insurance company
11	LossAdjuster	nvarchar(200)	yes		Name of the loss adjuster overseeing the claim
12	InvoicedTo	nvarchar(200)	yes		Contact/entity the invoice was issued to
13	CaseManager	nvarchar(100)	yes		Display name of the case manager
14	PrimeActualInvoiceID	bigint	no	identity	Identifier of the corresponding invoice in Prime Ecosystem

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeExportActualInvoicedFYTD	CLUSTERED	yes	yes	PrimeActualInvoiceID
UX_primeExportActualInvoicedFYTD_Job_Invoice	NONCLUSTERED	yes		JobNumber, InvoiceNumber

Referenced by

Procedures: dbo.spUpsertPrimeExportActualInvoicedFYTD