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

Copyright © 2019, 2023, Oracle and/or its affiliates.