tcBusinessFieldName | tcDataType | tcOperator |
---|---|---|
iiCompanyId | i | |
icFromDebtorCode | c | >= |
icToDebtorCode | c | <= |
icCandoDebtorCode | c | can-do |
icFromBRCode | c | >= |
icToBRCode | c | <= |
icCandoBRCode | c | can-do |
iiToAccYearPeriod | i | <= |
iiFromAccYearPeriod | i | >= |
tBusinessRelation.BusinessRelationCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationName1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationName2 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tBusinessRelation.BusinessRelationSearchName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCostCentre.CostCentreCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCostCentre.CostCentreDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency.CurrencyDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency.CurrencyNumberOfDecimals | i | =,>=,>,<>,<=,< |
tDebtor.DebtorCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDHist.DHistBalanceCC | d | =,>=,>,<>,<=,< |
tDHist.DHistBalanceLC | d | =,>=,>,<>,<=,< |
tDHist.DHistBalanceTC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossCredNoteCC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossCredNoteLC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossCredNoteTC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossInvoiceCC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossInvoiceLC | d | =,>=,>,<>,<=,< |
tDHist.DHistGrossInvoiceTC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementCreditCC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementCreditLC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementCreditTC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementDebitCC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementDebitLC | d | =,>=,>,<>,<=,< |
tDHist.DHistMovementDebitTC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoCredNoteCC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoCredNoteLC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoCredNoteTC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoInvoiceCC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoInvoiceLC | d | =,>=,>,<>,<=,< |
tDHist.DHistNettoInvoiceTC | d | =,>=,>,<>,<=,< |
tDHist.DHistYearPeriodFrom | i | =,>=,>,<>,<=,< |
tDHist.DHistYearPeriodTill | i | =,>=,>,<>,<=,< |
tDivision.DivisionCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDivision.DivisionDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL.GLDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal.JournalCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tJournal.JournalDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProject.ProjectCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tProject.ProjectDescription | c | =,>=,>,<>,<=,<,begins,can-do,matches |
iiCompanyId | integer | Company id |
icFromDebtorCode | character | FromDebtorCode |
icToDebtorCode | character | ToDebtorCode |
icCandoDebtorCode | character | CandoDebtorCode |
icFromBRCode | character | FromBRCode |
icToBRCode | character | ToBRCode |
icCandoBRCode | character | CandoBRCode |
iiToAccYearPeriod | integer | |
iiFromAccYearPeriod | integer | From GL Period |
field name | data type | db field | description |
---|---|---|---|
tiBusinessRelation_ID | integer | BusinessRelation.BusinessRelation_ID | Record ID |
tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
tcBusinessRelationName1 | character | BusinessRelation.BusinessRelationName1 | Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers. |
api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
tcBusinessRelationName2 | character | BusinessRelation.BusinessRelationName2 | Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank. |
tcBusinessRelationSearchName | character | BusinessRelation.BusinessRelationSearchName | Search Name: An alternate name for finding the business relation. This field can be useful for sorting and filtering. |
api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
tiCostCentre_ID | integer | CostCentre.CostCentre_ID | Record ID |
tcCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
tcCostCentreDescription | character | CostCentre.CostCentreDescription | Description: a brief description of the cost center. |
tiCurrency_ID | integer | Currency.Currency_ID | Record ID |
tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
tcCurrencyDescription | character | Currency.CurrencyDescription | Currency Description |
tiCurrencyNumberOfDecimals | integer | Currency.CurrencyNumberOfDecimals | Number of Decimals |
tiDebtor_ID | integer | Debtor.Debtor_ID | Record ID |
tcDebtorCode | character | Debtor.DebtorCode | A code (maximum eight characters) that identifies a customer. If the code you specify matches an existing supplier code, a warning message displays. You can choose to ignore the warning, and create the record. However, when a supplier and customer share the same code, they must reference the same business relation. |
api annotation: | If you leave the Customer Code field blank, the system automatically generates a number for the record based on the sequence defined in Customer Autonumber Create. | ||
tdDHistBalanceCC | decimal | DHist.DHistBalanceCC | SC Balance |
tdDHistBalanceLC | decimal | DHist.DHistBalanceLC | BC Balance |
tdDHistBalanceTC | decimal | DHist.DHistBalanceTC | TC Balance |
tdDHistGrossCredNoteCC | decimal | DHist.DHistGrossCredNoteCC | SC Gross Credit Note |
tdDHistGrossCredNoteLC | decimal | DHist.DHistGrossCredNoteLC | BC Gross Credit Note |
tdDHistGrossCredNoteTC | decimal | DHist.DHistGrossCredNoteTC | TC Gross Credit Note |
tdDHistGrossInvoiceCC | decimal | DHist.DHistGrossInvoiceCC | SC Gross Invoice |
tdDHistGrossInvoiceLC | decimal | DHist.DHistGrossInvoiceLC | BC Gross Invoice |
tdDHistGrossInvoiceTC | decimal | DHist.DHistGrossInvoiceTC | TC Gross Invoice |
tdDHistMovementCreditCC | decimal | DHist.DHistMovementCreditCC | SC Activity Credit |
tdDHistMovementCreditLC | decimal | DHist.DHistMovementCreditLC | BC Activity Credit |
tdDHistMovementCreditTC | decimal | DHist.DHistMovementCreditTC | TC Activity Credit |
tdDHistMovementDebitCC | decimal | DHist.DHistMovementDebitCC | SC Activity Debit |
tdDHistMovementDebitLC | decimal | DHist.DHistMovementDebitLC | BC Activity Debit |
tdDHistMovementDebitTC | decimal | DHist.DHistMovementDebitTC | TC Activity Debit |
tdDHistNettoCredNoteCC | decimal | DHist.DHistNettoCredNoteCC | SC Net Credit Note |
tdDHistNettoCredNoteLC | decimal | DHist.DHistNettoCredNoteLC | BC Net to Credit Note |
tdDHistNettoCredNoteTC | decimal | DHist.DHistNettoCredNoteTC | TC Net Credit Note |
tdDHistNettoInvoiceCC | decimal | DHist.DHistNettoInvoiceCC | SC Net Invoice |
tdDHistNettoInvoiceLC | decimal | DHist.DHistNettoInvoiceLC | BC Net to Invoice |
tdDHistNettoInvoiceTC | decimal | DHist.DHistNettoInvoiceTC | TC Net Invoice |
tiDHistYearPeriodFrom | integer | DHist.DHistYearPeriodFrom | From Year GL Period |
tiDHistYearPeriodTill | integer | DHist.DHistYearPeriodTill | To Year GL Period |
tiDivision_ID | integer | Division.Division_ID | Record ID |
tcDivisionCode | character | Division.DivisionCode | Sub-Account |
tcDivisionDescription | character | Division.DivisionDescription | Description |
tiGL_ID | integer | GL.GL_ID | Record ID |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
tcGLDescription | character | GL.GLDescription | A description of the GL account. |
tiJournal_ID | integer | Journal.Journal_ID | Record ID |
tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
tcJournalDescription | character | Journal.JournalDescription | A brief description of the daybook. |
api annotation: | Value for this field defaults to null. | ||
tiProject_ID | integer | Project.Project_ID | Record ID |
tcProjectCode | character | Project.ProjectCode | Project |
tcProjectDescription | character | Project.ProjectDescription | Description |
DebtorCustom | character | calculated | custom fields |
BusinessRelationCustom | character | calculated | custom fields |
DHistCustom | character | calculated | custom fields |
CostCentreCustom | character | calculated | custom fields |
CurrencyCustom | character | calculated | custom fields |
DivisionCustom | character | calculated | custom fields |
GLCustom | character | calculated | custom fields |
JournalCustom | character | calculated | custom fields |
ProjectCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Debtor),rowid(BusinessRelation),rowid(DHist),rowid(CostCentre),rowid(Currency),rowid(Division),rowid(GL),rowid(Journal),rowid(Project) |