Appearance
dbo.primeExportFutureInvoices
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeExportFutureInvoices.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | Supervisor | varchar(255) | yes | Display name of the supervisor | |
| 2 | Assigned | varchar(255) | yes | Display name of the user this job/record is assigned to | |
| 3 | JobNumber | varchar(255) | yes | Human-readable job number/reference used in Prime Ecosystem | |
| 4 | SiteAddress | varchar(255) | yes | Full site/property address for the job | |
| 5 | AccountsReceivableType | varchar(255) | yes | Type/category of accounts-receivable entry | |
| 6 | InvoiceAmountExclTax | decimal(18,4) | yes | Invoice amount excluding tax | |
| 7 | Status | varchar(50) | yes | Current status of this record | |
| 8 | InvoiceProgressPaymentNumber | int | yes | Sequence number of this progress payment invoice | |
| 9 | InvoiceNumber | varchar(50) | yes | Invoice number/reference | |
| 10 | InvoiceInvoicedDate | date | yes | Date the invoice was issued |
Referenced by
Procedures: dbo.spPrimeUpsertExportFutureInvoices