DW_NATURAL_ACCOUNT_D

This table contains natural account segment information.

Details

Module:

Key Columns

NTRL_ACNT_SGMNT_VALUESET_CODE, NATURAL_ACCOUNT_SEGMENT

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     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.