field name | data type | db field | description |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiJournal_ID | integer | GrossIncAcc.Journal_ID | Link To Journal |
tiCompany_ID | integer | GrossIncAcc.Company_ID | Link to Company |
tiGrossIncAcc_ID | integer | GrossIncAcc.GrossIncAcc_ID | Record ID |
tiSalesCostCentre_ID | integer | GrossIncAcc.SalesCostCentre_ID | Link To CostCentre (Sales) |
tiSalesDivision_ID | integer | GrossIncAcc.SalesDivision_ID | Link To Division (Sales) |
tiSalesGL_ID | integer | GrossIncAcc.SalesGL_ID | Link To GL (Sales) |
tiSalesProject_ID | integer | GrossIncAcc.SalesProject_ID | Link To Project (Sales) |
tiTaxExpenseCostCentre_ID | integer | GrossIncAcc.TaxExpenseCostCentre_ID | Link To CostCentre (Tax Expense) |
tiTaxExpenseDivision_ID | integer | GrossIncAcc.TaxExpenseDivision_ID | Link To Division (Tax Expense) |
tiTaxExpenseGL_ID | integer | GrossIncAcc.TaxExpenseGL_ID | Link To GL (Tax Expense) |
tiTaxExpenseProject_ID | integer | GrossIncAcc.TaxExpenseProject_ID | Link To Project (Tax Expense) |
tiTaxPayableDivision_ID | integer | GrossIncAcc.TaxPayableDivision_ID | Link To Division (Tax Payable) |
tiTaxPayableGL_ID | integer | GrossIncAcc.TaxPayableGL_ID | Link To GL (Tax Payable) |
tlGrossIncAccIsAllCostCentre | logical | GrossIncAcc.GrossIncAccIsAllCostCentre | All Cost Centers |
tlGrossIncAccIsAllDivision | logical | GrossIncAcc.GrossIncAccIsAllDivision | All Sub-Accounts |
tlGrossIncAccIsAllProject | logical | GrossIncAcc.GrossIncAccIsAllProject | All Projects |
tcSalesGLCode | character | GL1.GLCode | A code identifying the GL account. |
tcSalesDivisionCode | character | Division1.DivisionCode | Sub-Account |
tcSalesCostCentreCode | character | CostCentre1.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcSalesProjectCode | character | Project1.ProjectCode | Project |
tcTaxPayableGLCode | character | GL2.GLCode | A code identifying the GL account. |
tcTaxPayableDivisionCode | character | Division2.DivisionCode | Sub-Account |
tcTaxExpenseGLCode | character | GL3.GLCode | A code identifying the GL account. |
tcTaxExpenseDivisionCode | character | Division3.DivisionCode | Sub-Account |
tcTaxExpenseCostCentreCode | character | CostCentre2.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcTaxExpenseProjectCode | character | Project2.ProjectCode | Project |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(GrossIncAcc),rowid(CostCentre1),rowid(CostCentre2),rowid(Division2),rowid(Division1),rowid(Division3),rowid(GL1),rowid(GL2),rowid(GL3),rowid(Journal),rowid(Project1),rowid(Project2) |