DW_CUSTOMER_ACCOUNT_D
This table contains details about customer accounts.
Details
Module: Receivables
Key Columns
CUSTOMER_ACCOUNT_ID
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 |