Data Warehouse

COST_ELEMENT_CATEGORY

Cost element category associated with the general ledger account.

VARCHAR2

50

GL_ACCOUNT_ID

Business identifier for the general ledger account.

VARCHAR2

6

GL_ACCOUNT_KEY

Key identifier for the general ledger account.

VARCHAR2

10

GL_ACCOUNT_NAME

Name of the general ledger account.

VARCHAR2

50

GL_ACCOUNT_TYPE_CODE

Code identifying the general ledger account type.

VARCHAR2

4

GL_ACCOUNT_TYPE_DESCRIPTION

Description of the general ledger account type code.

VARCHAR2

30

IS_BALANCE_SHEET_ACCOUNT

Indicator identifying whether the account is a balance sheet account (Y/N).

VARCHAR2

1

IS_EXPENSE_ACCOUNT

Indicator identifying whether the account is an expense account (Y/N).

VARCHAR2

1

IS_FIXED_ASSET_ACCOUNT

Indicator identifying whether the account is a fixed asset account (Y/N).

VARCHAR2

1

IS_FUND_ACCOUNT

Indicator identifying whether the account is a fund account (Y/N).

VARCHAR2

1

IS_IN_MTDC_BASE

Indicator identifying whether the account is included in the MTDC base (Y/N).

VARCHAR2

1

IS_LIABILITY_ACCOUNT

Indicator identifying whether the account is a liability account (Y/N).

VARCHAR2

1

IS_LIQUID_ASSET_ACCOUNT

Indicator identifying whether the account is a liquid asset account (Y/N).

VARCHAR2

1

IS_PRINCIPAL_ACCOUNT

Indicator identifying whether the account is a principal account (Y/N).

VARCHAR2

1

IS_PROFIT_AND_LOSS_ACCOUNT

Indicator identifying whether the account is a profit and loss account (Y/N).

VARCHAR2

1

IS_REVENUE_ACCOUNT

Indicator identifying whether the account is a revenue account (Y/N).

VARCHAR2

1

IS_SETTLEMENT_ACCOUNT

Indicator identifying whether the account is a settlement account (Y/N).

VARCHAR2

1

IS_TRANSFER_ACCOUNT

Indicator identifying whether the account is a transfer account (Y/N).

VARCHAR2

1

LEVEL1_CATEGORY

Level 1 reporting category for the general ledger account.

VARCHAR2

40

LEVEL1_SORT

Sort order for level 1 reporting category.

NUMBER

6

LEVEL2_CATEGORY

Level 2 reporting category for the general ledger account.

VARCHAR2

40

LEVEL2_SORT

Sort order for level 2 reporting category.

NUMBER

6

LEVEL3_CATEGORY

Level 3 reporting category for the general ledger account.

VARCHAR2

40

LEVEL3_SORT

Sort order for level 3 reporting category.

NUMBER

6

LEVEL4_CATEGORY

Level 4 reporting category for the general ledger account.

VARCHAR2

40

LEVEL4_SORT

Sort order for level 4 reporting category.

NUMBER

6

LEVEL5_CATEGORY

Level 5 reporting category for the general ledger account.

VARCHAR2

40

LEVEL5_SORT

Sort order for level 5 reporting category.

NUMBER

6

LEVEL6_CATEGORY

Level 6 reporting category for the general ledger account.

VARCHAR2

40

LEVEL6_SORT

Sort order for level 6 reporting category.

NUMBER

6

LEVEL7_CATEGORY

Level 7 reporting category for the general ledger account.

VARCHAR2

40

LEVEL7_SORT

Sort order for level 7 reporting category.

NUMBER

6

REPORT_TYPE

Description of the report type.

VARCHAR2

40

REPORT_TYPE_CODE

Code identifying the report type for the GL account hierarchy.

VARCHAR2

12

SURCHARGE_BASE_PATTERN_KEY

Key identifying the surcharge base pattern associated with the account.

NUMBER

5