dbo.PrimeAccountsPayableInvoices_Depcrecated

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Created By	nvarchar(255)	yes		User/system that created the record
2	Work Order Invoiced Total	decimal(18,2)	yes		Total amount invoiced for work orders on this job
3	Work Order Cost Total Inc Tax	decimal(18,2)	yes		Total cost of work orders including tax
4	Status	nvarchar(100)	yes		Current status of this record
5	Specific Status	nvarchar(100)	yes		Detailed/specific status label beyond the main status
6	Retention	decimal(18,2)	yes		Retention amount/percentage withheld from payment
7	Notes	nvarchar(255)	yes		Free-text internal notes
8	Invoiced Date	date	yes		Date the invoice was issued
9	Invoiced Amount Inc Tax	decimal(18,2)	yes		Invoiced amount including tax
10	Invoiced Amount Inc Tax Inc CIS	decimal(18,2)	yes		Invoiced amount including tax and CIS (Construction Industry Scheme) deduction
11	Invoiced Amount Excl Tax	decimal(18,2)	yes		Invoiced amount excluding tax
12	Invoice Tax Amount	decimal(18,2)	yes		Tax amount on the invoice
13	Invoice Paid Date	date	yes		Date the invoice was paid
14	Invoice Number	nvarchar(100)	yes		Invoice number/reference
15	Invoice Due Date	date	yes		Date the invoice payment is due
16	Invoice Created	datetime2(0)	yes		Timestamp the invoice was created
17	Invoice Amount	decimal(18,2)	yes		Total amount of the invoice
18	Item Code Description	nvarchar(255)	yes		Description of the item code
19	Item Code Code	nvarchar(100)	yes		Item code value
20	Is Synced	bit	yes		Flag indicating whether this record has been synced with Prime Ecosystem
21	Is Active	bit	yes		Flag indicating whether this record is active
22	Has Linked Document	bit	yes		Flag indicating whether a document is linked to this invoice
23	DRC Total	decimal(18,2)	yes		Total Direct Recoverable Cost amount
24	DRC	decimal(18,2)	yes		Direct Recoverable Cost amount
25	CIS Amount Inc Tax	decimal(18,2)	yes		CIS (Construction Industry Scheme) deduction amount including tax
26	Approved By	nvarchar(255)	yes		User who approved this record
27	Approved At	datetime2(0)	yes		Timestamp this record was approved
28	Approval Note	nvarchar(MAX)	yes		Free-text note explaining the approval decision
29	Approval	nvarchar(100)	yes		Approval status or note
30	Account Number Description	nvarchar(255)	yes		Description of the accounting account number
31	Account Number Code	nvarchar(100)	yes		Accounting account number code