dbo.ethinvoicedataObjectivedb

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Date	date	yes		Invoice date this row of exported invoice data relates to.
2	State	varchar(3)	no		Australian state of the job ('VIC' or 'QLD').
3	Id	uniqueidentifier	yes		Prime Ecosystem job (primeJobs.id) the invoice belongs to.
4	JobNumber	varchar(50)	yes		Human-readable job number of the job the invoice belongs to.
5	AddressLine1	nvarchar(255)	yes		First line of the job site address.
6	AuthorisedTotalIncludingTax	money	yes		Total authorised works value for the job, including tax.
7	AuthorisedTotalIncludingTaxSplit	money	yes		AuthorisedTotalIncludingTax divided evenly across the job's invoice rows, when a job has multiple invoices.
8	InvoiceId	uniqueidentifier	yes		Prime Ecosystem accounts receivable invoice (primeAccountsReceivableInvoices.id) this row represents.
9	Client	nvarchar(255)	yes		Name of the contact/client the invoice was issued to.
10	Subtotal	decimal(19,4)	yes		Invoice subtotal amount before tax.
11	Estimator	nvarchar(200)	yes		Full name of the Prime Ecosystem user assigned as estimator on the job.
12	JobStatus	varchar(100)	yes		Current Prime Ecosystem status name of the job (e.g. 'Closed', 'Quote Submitted - Awaiting Approval').
13	InvoiceNumber	nvarchar(50)	yes		Invoice number, or 'EMPTY' when no invoice exists for this date/job/state combination.
14	Total_Recieved	decimal(20,4)	yes		Amount received (subtotal excluding tax) for Authorised Works/Allocations/Excess invoices that have been Paid or Sent; null otherwise.
15	Forecasted_Receivable	decimal(20,4)	yes		Amount expected to be received (subtotal excluding tax) for Authorised Works/Allocations/Excess invoices not yet Cancelled or Pending; null otherwise.
16	InvoiceStatus	varchar(20)	yes		Invoice status (e.g. 'Paid', 'Sent', 'Pending', 'Cancelled'), or 'empty' when no invoice exists for this row.
17	Type	varchar(50)	yes		Accounts receivable type of the invoice (e.g. 'Authorised Works', 'Allocations', 'Excess'), or 'False' when no invoice exists for this row.
18	Received	decimal(20,4)	yes		Invoice subtotal excluding tax (subtotal minus tax total); 0 when no invoice exists for this row.
19	Budget	int	yes		Fixed budget/target invoicing figure assigned to the state for reporting comparisons.

Referenced by

Procedures: dbo.spEthinvoicedataObjectivedb