tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
tCostCentre1.CostCentreCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCostCentre2.CostCentreCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDivision1.DivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDivision3.DivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDivision2.DivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL2.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL3.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL1.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGrossIncAcc.GrossIncAccIsAllCostCentre | l | =,<> |
tGrossIncAcc.GrossIncAccIsAllDivision | l | =,<> |
tGrossIncAcc.GrossIncAccIsAllProject | l | =,<> |
tJournal.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProject2.ProjectCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProject1.ProjectCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
field name | data type | db field | description |
tiCompany_ID | integer | GrossIncAcc.Company_ID | Link to Company |
tiGrossIncAcc_ID | integer | GrossIncAcc.GrossIncAcc_ID | Record ID |
tlGrossIncAccIsAllCostCentre | logical | GrossIncAcc.GrossIncAccIsAllCostCentre | All Cost Centers |
tlGrossIncAccIsAllDivision | logical | GrossIncAcc.GrossIncAccIsAllDivision | All Sub-Accounts |
tlGrossIncAccIsAllProject | logical | GrossIncAcc.GrossIncAccIsAllProject | All Projects |
tiJournal_ID | integer | GrossIncAcc.Journal_ID | Link To Journal |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tiSalesCostCentre_ID | integer | GrossIncAcc.SalesCostCentre_ID | Link To CostCentre (Sales) |
tcSalesCostCentreCode | character | CostCentre1.CostCentreCode | Cost Center: A code that identifies the cost center. |
tiSalesDivision_ID | integer | GrossIncAcc.SalesDivision_ID | Link To Division (Sales) |
tcSalesDivisionCode | character | Division1.DivisionCode | Sub-Account |
tiSalesGL_ID | integer | GrossIncAcc.SalesGL_ID | Link To GL (Sales) |
tcSalesGLCode | character | GL1.GLCode | A code identifying the GL account. |
tiSalesProject_ID | integer | GrossIncAcc.SalesProject_ID | Link To Project (Sales) |
tcSalesProjectCode | character | Project1.ProjectCode | Project |
tiTaxExpenseCostCentre_ID | integer | GrossIncAcc.TaxExpenseCostCentre_ID | Link To CostCentre (Tax Expense) |
tcTaxExpenseCostCentreCode | character | CostCentre2.CostCentreCode | Cost Center: A code that identifies the cost center. |
tiTaxExpenseDivision_ID | integer | GrossIncAcc.TaxExpenseDivision_ID | Link To Division (Tax Expense) |
tcTaxExpenseDivisionCode | character | Division3.DivisionCode | Sub-Account |
tiTaxExpenseGL_ID | integer | GrossIncAcc.TaxExpenseGL_ID | Link To GL (Tax Expense) |
tcTaxExpenseGLCode | character | GL3.GLCode | A code identifying the GL account. |
tiTaxExpenseProject_ID | integer | GrossIncAcc.TaxExpenseProject_ID | Link To Project (Tax Expense) |
tcTaxExpenseProjectCode | character | Project2.ProjectCode | Project |
tiTaxPayableDivision_ID | integer | GrossIncAcc.TaxPayableDivision_ID | Link To Division (Tax Payable) |
tcTaxPayableDivisionCode | character | Division2.DivisionCode | Sub-Account |
tiTaxPayableGL_ID | integer | GrossIncAcc.TaxPayableGL_ID | Link To GL (Tax Payable) |
tcTaxPayableGLCode | character | GL2.GLCode | A code identifying the GL account. |
GrossIncAccCustom | character | calculated | custom fields |
GL1Custom | character | calculated | custom fields |
GL2Custom | character | calculated | custom fields |
GL3Custom | character | calculated | custom fields |
Division1Custom | character | calculated | custom fields |
Division2Custom | character | calculated | custom fields |
Division3Custom | character | calculated | custom fields |
CostCentre1Custom | character | calculated | custom fields |
CostCentre2Custom | character | calculated | custom fields |
Project1Custom | character | calculated | custom fields |
Project2Custom | character | calculated | custom fields |
JournalCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(GrossIncAcc),rowid(CostCentre1),rowid(CostCentre2),rowid(Division1),rowid(Division2),rowid(Division3),rowid(GL1),rowid(GL2),rowid(GL3),rowid(Journal),rowid(Project2),rowid(Project1) |