| iiDomainID | integer | Domain ID |
| icDomainCode | character | Domain Code |
| iiCompanyID | integer | Company id: redundant paramater that was auto-added by CB-tool and that corresponds with the SharedSet of the lined G/L |
each Domains where
each DomainProperty (inner-join) where
first Currency1 (inner-join) where
first Currency2 (inner-join) where
first GL5 (outer-join) where
first GL1 (outer-join) where
first GL2 (outer-join) where
first GL3 (outer-join) where
first GL4 (outer-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tcCurrencyCode | character | Currency1.CurrencyCode | Currency Code |
| tcDomainPropertyCodePage | character | DomainProperty.DomainPropertyCodePage | Domain Code Page |
| 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 |
| tlDomainPropertyIsStatutory | logical | DomainProperty.DomainPropertyIsStatutory | Statutory Currency Enabled |
| tcDomainPropertyName | character | DomainProperty.DomainPropertyName | Name |
| tcDomainPropertySearchName | character | DomainProperty.DomainPropertySearchName | Search Name |
| tiStatutoryCurrency_ID | integer | Currency2.Currency_ID | Record ID |
| tcStatutoryCurrencyCode | character | Currency2.CurrencyCode | Currency Code |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiCurrency_ID | integer | DomainProperty.Currency_ID | Base Currency |
| tiDomainProperty_ID | integer | DomainProperty.DomainProperty_ID | Record ID |
| tiLng_ID | integer | Domains.Lng_ID | Language |
| tiPrimaryCompany_ID | integer | Domains.PrimaryCompany_ID | Primary Entity |
| tlDomainIsActive | logical | Domains.DomainIsActive | Active |
| tcDomainType | character | Domains.DomainType | Type |
| tlDomainPropertyIsSetupCompl | logical | DomainProperty.DomainPropertyIsSetupCompl | Setup Complete |
| tiIntercoAPGL_ID | integer | DomainProperty.IntercoAPGL_ID | Account Payable GL Account |
| tcIntercoAPGLCode | character | GL1.GLCode | A code identifying the GL account. |
| tlIntercoAPGLIsProjectAccount | logical | GL1.GLIsProjectAccount | Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoAPGLIsIntercoAccount | logical | GL1.GLIsIntercoAccount | If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoAPGLIsDivisionAccount | logical | GL1.GLIsDivisionAccount | Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoAPGLIsCostCentreAccount | logical | GL1.GLIsCostCentreAccount | This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoAPCostCentreProfile_ID | integer | GL1.CostCentreProfile_ID | Link to Profile |
| tiIntercoAPDivisionProfile_ID | integer | GL1.DivisionProfile_ID | Link to Profile |
| tiIntercoAPProjectProfile_ID | integer | GL1.ProjectProfile_ID | Link to Profile |
| tiIntercoARGL_ID | integer | DomainProperty.IntercoARGL_ID | Account Receivable GL Account |
| tcIntercoARGLCode | character | GL2.GLCode | A code identifying the GL account. |
| tlIntercoARGLIsProjectAccount | logical | GL2.GLIsProjectAccount | Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoARGLIsIntercoAccount | logical | GL2.GLIsIntercoAccount | If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoARCostCentreProfile_ID | integer | GL2.CostCentreProfile_ID | Link to Profile |
| tiIntercoARDivisionProfile_ID | integer | GL2.DivisionProfile_ID | Link to Profile |
| tiIntercoARProjectProfile_ID | integer | GL2.ProjectProfile_ID | Link to Profile |
| tlIntercoARGLIsDivisionAccount | logical | GL2.GLIsDivisionAccount | Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoARGLIsCostCentreAccount | logical | GL2.GLIsCostCentreAccount | This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoFAGL_ID | integer | DomainProperty.IntercoFAGL_ID | Fixed Asset GL Account |
| tcIntercoFAGLCode | character | GL3.GLCode | A code identifying the GL account. |
| tlIntercoFAGLIsCDivisionAccount | logical | GL3.GLIsDivisionAccount | Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoFAGLIsCostCentreAccount | logical | GL3.GLIsCostCentreAccount | This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoFACostCentreProfile_ID | integer | GL3.CostCentreProfile_ID | Link to Profile |
| tiIntercoFADivisionProfile_ID | integer | GL3.DivisionProfile_ID | Link to Profile |
| tlIntercoFAGLIsProjectAccount | logical | GL3.GLIsProjectAccount | Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoFAProjectProfile_ID | integer | GL3.ProjectProfile_ID | Link to Profile |
| tlIntercoFAGLIsIntercoAccount | logical | GL3.GLIsIntercoAccount | If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoICGL_ID | integer | DomainProperty.IntercoICGL_ID | Inter Company GL Account |
| tcIntercoICGLCode | character | GL4.GLCode | A code identifying the GL account. |
| tiIntercoICCostCentreProfile_ID | integer | GL4.CostCentreProfile_ID | Link to Profile |
| tiIntercoICDivisionProfile_ID | integer | GL4.DivisionProfile_ID | Link to Profile |
| tiIntercoICProjectProfile_ID | integer | GL4.ProjectProfile_ID | Link to Profile |
| tlIntercoICGLIsProjectAccount | logical | GL4.GLIsProjectAccount | Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoICGLIsIntercoAccount | logical | GL4.GLIsIntercoAccount | If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoICGLIsDivisionAccount | logical | GL4.GLIsDivisionAccount | Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoICGLIsCostCentreAccount | logical | GL4.GLIsCostCentreAccount | This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tiIntercoJEGL_ID | integer | DomainProperty.IntercoJEGL_ID | Manual Journal Entry GL Account |
| tcIntercoJEGLCode | character | GL5.GLCode | A code identifying the GL account. |
| tiIntercoJECostCentreProfile_ID | integer | GL5.CostCentreProfile_ID | Link to Profile |
| tiIntercoJEDivisionProfile_ID | integer | GL5.DivisionProfile_ID | Link to Profile |
| tiIntercoJEProjectProfile_ID | integer | GL5.ProjectProfile_ID | Link to Profile |
| tlIntercoJEGLIsProjectAccount | logical | GL5.GLIsProjectAccount | Project Analysis: This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoJEGLIsIntercoAccount | logical | GL5.GLIsIntercoAccount | If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoJEGLIsDivisionAccount | logical | GL5.GLIsDivisionAccount | Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| tlIntercoJEGLIsCostCentreAccount | logical | GL5.GLIsCostCentreAccount | This field will be calculated by the system based on the value of tcAnalysisType. If the analysis type of the account is Project the value will be true. |
| api annotation: | This field can be left blank as it will be calculated by the system. | ||
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Domains),rowid(DomainProperty),rowid(Currency1),rowid(Currency2),rowid(GL5),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4) |
QadFinancials