DW_CUSTOMER_ACCOUNT_D

This table contains details about customer accounts.

Details

Module: Receivables

Key Columns

CUSTOMER_ACCOUNT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_ACCOUNT_ID NUMBER 38 0 True Customer account identifier. It is used as primary key.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier. Value is same as the customer account identifier.    
ACCOUNT_NAME VARCHAR2 256     Customer account name.    
PARTY_ID NUMBER 38 0   Party identifier.    
CUSTOMER_ACCOUNT_TYPE_CODE VARCHAR2 128     Customer account type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=CUSTOMER_TYPE. DW_CODE_VALUES_LKP_TL CODE
CUSTOMER_ACCOUNT_CLASS_CODE VARCHAR2 128     Customer account class. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=CUSTOMER_CLASS. DW_CODE_VALUES_LKP_TL CODE
ACTIVE_FLAG VARCHAR2 16     Indicates an active account.    
STATUS VARCHAR2 16     Indicates an active/inactive account. DW_CODE_STATUS_LKP_TL CODE_STATUS_CODE
ACCOUNT_NUMBER VARCHAR2 32     Customer account number.    
TAX_CODE VARCHAR2 64     Tax code.    
AUTOPAY_FLAG VARCHAR2 16     Indicates an autopayment.    
HOLD_BILL_FLAG VARCHAR2 16     Indicates a bill on hold.    
ACCOUNT_TEMINATION_DATE DATE       Account termination date.    
ACCOUNT_ESTABLISHED_DATE DATE       Date when customer account is created.    
ACCOUNT_TERMINATION_DATE DATE       Account termination date.    

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