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 This column is for Oracle Internal use only. 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_CUSTOMER_TYPE_LKP_TL with CODE_TYPE=CUSTOMER_TYPE. DW_CUSTOMER_TYPE_LKP_TL CUSTOMER_TYPE_CODE
CUSTOMER_ACCOUNT_CLASS_CODE VARCHAR2 128 Customer account class. Values are from the table DW_CUSTOMER_CLASS_LKP_TL with CODE_TYPE=CUSTOMER_CLASS. DW_CUSTOMER_CLASS_LKP_TL CUSTOMER_CLASS_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.
COLLECTOR_NAME VARCHAR2 32 Collector Name
CREDIT_ANALYST_NAME VARCHAR2 256 Credit Analyst Name