tcBusinessFieldName | tcDataType | tcOperator |
iiCompanyId | i | |
tCompany.CompanyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency1.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tCurrency2.CurrencyCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomains.DomainCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomains.DomainIsActive | l | =,<> |
tDomains.DomainPropath | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomainProperty.DomainPropertyCodePage | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomainProperty.DomainPropertyExceptList | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomainProperty.DomainPropertyIsChronolNr | l | =,<> |
tDomainProperty.DomainPropertyIsConsecutNr | l | =,<> |
tDomainProperty.DomainPropertyIsInvCertific | l | =,<> |
tDomainProperty.DomainPropertyIsMaskCC | l | =,<> |
tDomainProperty.DomainPropertyIsMaskCCAll | l | =,<> |
tDomainProperty.DomainPropertyIsMaskDiv | l | =,<> |
tDomainProperty.DomainPropertyIsMaskDivAll | l | =,<> |
tDomainProperty.DomainPropertyIsMaskPrjAll | l | =,<> |
tDomainProperty.DomainPropertyIsMaskProj | l | =,<> |
tDomainProperty.DomainPropertyIsPopupInvNr | l | =,<> |
tDomainProperty.DomainPropertyIsSetupCompl | l | =,<> |
tDomainProperty.DomainPropertyIsStatutory | l | =,<> |
tDomainProperty.DomainPropertyIsTaxValid | l | =,<> |
tDomainProperty.DomainPropertyIsWHT | l | =,<> |
tDomainProperty.DomainPropertyName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomainProperty.DomainPropertyNonChronErr | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomainProperty.DomainPropertySearchName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tDomains.DomainType | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL5.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL4.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL3.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL2.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tGL1.GLCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tLng.LngCode | c | =,>=,>,<>,<=,<,begins,can-do,matches |
field name | data type | db field | description |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
tiCurrency_ID | integer | DomainProperty.Currency_ID | Base Currency |
tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
tcDomainPropath | character | Domains.DomainPropath | Propath |
tcDomainPropertyCodePage | character | DomainProperty.DomainPropertyCodePage | Domain Code Page |
tcDomainPropertyExceptList | character | DomainProperty.DomainPropertyExceptList | Domain Exception List |
tlDomainPropertyIsChronolNr | logical | DomainProperty.DomainPropertyIsChronolNr | Chronological Invoice Numbering |
tlDomainPropertyIsConsecutNr | logical | DomainProperty.DomainPropertyIsConsecutNr | Consecutive Invoice Numbering |
tlDomainPropertyIsInvCertific | logical | DomainProperty.DomainPropertyIsInvCertific | Invoice Certification: activated or not |
tlDomainPropertyIsMaskCC | logical | DomainProperty.DomainPropertyIsMaskCC | Cost Center COA Mask |
tlDomainPropertyIsMaskCCAll | logical | DomainProperty.DomainPropertyIsMaskCCAll | Cost Center All-Range Mask By Default |
tlDomainPropertyIsMaskDiv | logical | DomainProperty.DomainPropertyIsMaskDiv | Sub-Account COA Mask |
tlDomainPropertyIsMaskDivAll | logical | DomainProperty.DomainPropertyIsMaskDivAll | Sub-Account All-Range Mask By Default |
tlDomainPropertyIsMaskPrjAll | logical | DomainProperty.DomainPropertyIsMaskPrjAll | Project All-Range Mask By Default |
tlDomainPropertyIsMaskProj | logical | DomainProperty.DomainPropertyIsMaskProj | Project COA Mask |
tlDomainPropertyIsPopupInvNr | logical | DomainProperty.DomainPropertyIsPopupInvNr | Show Supplier Invoice Number in Pop-up After Save |
tlDomainPropertyIsStatutory | logical | DomainProperty.DomainPropertyIsStatutory | Statutory Currency Enabled |
tlDomainPropertyIsTaxValid | logical | DomainProperty.DomainPropertyIsTaxValid | Tax Validation |
tlDomainPropertyIsWHT | logical | DomainProperty.DomainPropertyIsWHT | Use Withholding Tax |
tcDomainPropertyNonChronErr | character | DomainProperty.DomainPropertyNonChronErr | Action on Non-Chronological Number |
tcIntercoAPGLCode | character | GL1.GLCode | A code identifying the GL account. |
tcIntercoARGLCode | character | GL2.GLCode | A code identifying the GL account. |
tcIntercoFAGLCode | character | GL3.GLCode | A code identifying the GL account. |
tcIntercoICGLCode | character | GL4.GLCode | A code identifying the GL account. |
tcIntercoJEGLCode | character | GL5.GLCode | A code identifying the GL account. |
ttLastModifiedDate | date | Domains.LastModifiedDate | Last Modified Date |
tiLastModifiedTime | integer | Domains.LastModifiedTime | Last Modified Time |
tcLastModifiedUser | character | Domains.LastModifiedUser | Last Modified User |
tcLngCode | character | Lng.LngCode | Language Code |
tiStatutoryCurrency_ID | integer | DomainProperty.StatutoryCurrency_ID | Statutory Currency |
tcStatutoryCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
tiDomain_ID | integer | Domains.Domain_ID | Record ID |
tcDomainCode | character | Domains.DomainCode | Domain |
tcDomainType | character | Domains.DomainType | Type |
tlDomainIsActive | logical | Domains.DomainIsActive | Active |
tlDomainPropertyIsSetupCompl | logical | DomainProperty.DomainPropertyIsSetupCompl | Setup Complete |
tcDomainPropertyName | character | DomainProperty.DomainPropertyName | Name |
tcDomainPropertySearchName | character | DomainProperty.DomainPropertySearchName | Search Name |
DomainsCustom | character | calculated | custom fields |
CompanyCustom | character | calculated | custom fields |
DomainPropertyCustom | character | calculated | custom fields |
Currency1Custom | character | calculated | custom fields |
GL1Custom | character | calculated | custom fields |
GL2Custom | character | calculated | custom fields |
GL3Custom | character | calculated | custom fields |
GL4Custom | character | calculated | custom fields |
GL5Custom | character | calculated | custom fields |
LngCustom | character | calculated | custom fields |
Currency2Custom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Domains),rowid(Company),rowid(DomainProperty),rowid(Currency1),rowid(Currency2),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4),rowid(GL5),rowid(Lng) |