DW_NATURAL_ACCOUNT_D

This table contains natural account segment information.

Details

Module:

Key Columns

NATURAL_ACCOUNT_SEGMENT, NTRL_ACNT_SGMNT_VALUESET_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 True Natural account value set identifier.
NATURAL_ACCOUNT_SEGMENT VARCHAR2 256 True Natural account segment code.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of natural account value set identifier and segment code.
NATURAL_ACCOUNT_SEGMENT_ID VARCHAR2 512 Natural account segment identifier, Value is derived by combining natural account value set identifier and segment code.
ACCOUNT_TYPE VARCHAR2 32 Account type code. Possible values are O for Owner's Equity, R for Revenue, A for Asset, E for Expense, or L for Liability.
FINANCIAL_CATEGORY VARCHAR2 32 Account financial category. Possible values are AP, AR, COGS, DEPRECIATION, CASH, and so on.