InvoiceLines - Details of items that have been in a specifc invoice.
Child table of InvoiceHeaders table.
Column | Type | Notes |
---|---|---|
CompanyNumberInvoiceNoLineNo | TEXT | Tugger created column combining: CompanyNumber, InvoiceNo, LineNo |
CompanyNumber | WHOLE NUMBER | |
CostPrice | DECIMAL NUMBER | |
Description | TEXT | |
Discount | DECIMAL NUMBER | |
InvoiceNo | WHOLE NUMBER | |
LineCode | TEXT | |
LineNo | WHOLE NUMBER | |
LineType | TEXT | |
OnPaidInvoiceCreateCallForSystem | WHOLE NUMBER | |
Price | DECIMAL NUMBER | |
Quantity | DECIMAL NUMBER | |
RenewalSiteChargeNo | WHOLE NUMBER | |
SequenceNo | WHOLE NUMBER | |
ServiceFromDate | DATETIME | |
ServiceToDate | DATETIME | |
SiteChargesSystemNo | WHOLE NUMBER | |
StockUpdated_YN | TEXT | |
UnitOfMeasure | TEXT | |
Value | DECIMAL NUMBER | |
VatCode | WHOLE NUMBER | |
VatRate | DECIMAL NUMBER | |
Deleted | BINARY |