tcBusinessFieldName | tcDataType | tcOperator |
---|---|---|
iiCompanyId | i | |
icDeductionCatCode | c | = |
iiDomain_ID | i | = |
tDeductionCat.DeductionCatCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
iiCompanyId | integer | Company id |
icDeductionCatCode | character | |
iiDomain_ID | integer |
field name | data type | db field | description |
---|---|---|---|
tiDeductionCat_ID | integer | DeductionCat.DeductionCat_ID | Record ID |
tcDeductionCatCode | character | DeductionCat.DeductionCatCode | Deduction Category Code |
tiExpenseJournal_ID | integer | DeductionCatLine.ExpenseJournal_ID | Link to ExpenseJournal |
tcExpenseJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
DeductionCatCustom | character | calculated | custom fields |
DeductionCatLineCustom | character | calculated | custom fields |
JournalCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(DeductionCat),rowid(DeductionCatLine),rowid(Journal) |