CASH
DirectCosts - List of direct costs that can be used in pricing a job. ColumnTypeNotes Code TEXT DirectCostCategory TEXT LastEditDate DATETIME ...
Wed, 8 Jun, 2022 at 3:55 PM
InvoiceHeaders - Main table giving an overview of invoices. ColumnTypeNotes AccountingPeriodDate DATETIME AccountingPeriod WHOLE NUMBER Analysi...
Wed, 8 Jun, 2022 at 3:56 PM
InvoiceLineAnalysis - Accounting nominal code that applies to an invoice, Child table of InvoiceHeaders table. ColumnTypeNotes Amount DECIMAL NUMBER ...
Wed, 8 Jun, 2022 at 3:57 PM
InvoiceLines - Details of items that have been in a specifc invoice. Child table of InvoiceHeaders table. ColumnTypeNotes CompanyNumberInvoiceNoLineNo ...
Wed, 8 Jun, 2022 at 3:57 PM
JobCostingDirectCostAudits - Audit trail of changes made to a jobs direct costs ColumnTypeNotes AuditNo WHOLE NUMBER Comment TEXT DirectCostCod...
Wed, 8 Jun, 2022 at 3:57 PM
JobCostingDirectCosts - Direct costs for a specific job. Child table of JobCostings table. ColumnTypeNotes CompanyNumberJobNumberDirectCostCode TEXT ...
Wed, 8 Jun, 2022 at 3:57 PM
JobCostingInvoices ColumnTypeNotes InvoiceNumber WHOLE NUMBER JobCostingCompanyNumberJobCostingJobNumberInvoiceNumber TEXT Tugger created column c...
Wed, 8 Jun, 2022 at 3:57 PM
JobCostingProducts ColumnTypeNotes CompanyNumberJobNumberProductCodeLineNo TEXT Tugger created column combining: CompanyNumber, JobNumber, ProductCode,...
Wed, 8 Jun, 2022 at 3:57 PM
JobCosting ColumnTypeNotes AcceptedMargin DECIMAL NUMBER AcceptedValue DECIMAL NUMBER ActualCommencementDate DATETIME BalanceToInvoice DE...
Wed, 8 Jun, 2022 at 3:57 PM