Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse GL ACCOUNT COMPANY Table


Stores mappings of general ledger accounts to company-specific attributes, including posting restrictions and financial statement group classifications used for financial reporting.


Field Name

Description

Data Type

Length

COMPANY_CODE

Company code associated with the general ledger account.

VARCHAR2

4

FINANCIAL_STATEMENT_GROUP

Description of the financial statement group associated with the account for the company.

VARCHAR2

40

FINANCIAL_STATEMENT_GROUP_CODE

Code identifying the financial statement group associated with the account for the company.

VARCHAR2

4

GL_ACCOUNT_KEY

Key identifier for the general ledger account.

VARCHAR2

10

IS_POSTING_BLOCKED_IN_COMPANY

Indicator identifying whether posting is blocked for the account within the company (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the warehouse.

DATE