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