DW_AC_AR_AGING_BUCKETS_D (Preview)

This table requires activation of Advanced Collections functional area. Stores AR aging bucket definitions sourced from AGING_BUCKETS.

Details

Module: Advanced Collections

Key Columns

AGING_BUCKET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGING_BUCKET_ID NUMBER 38 0 True Identifier of the aging bucket.    
SOURCE_RECORD_ID VARCHAR2 64     This column is for Oracle Internal use only. Source record identifier.    
BUCKET_NAME VARCHAR2 256     Name of the aging bucket.    
DESCRIPTION VARCHAR2 999     Description of the aging bucket.    
AGING_TYPE VARCHAR2 64     Type of aging bucket. DW_AGING_TYPE_LKP_TL AGING_TYPE_CODE
STATUS VARCHAR2 32     Status of the aging bucket. DW_CODE_STATUS_LKP_TL CODE_STATUS_CODE
SET_ID NUMBER 38 0   Reference data set identifier associated with the bucket.    
CREATION_DATE TIMESTAMP       Creation timestamp.    
CREATED_BY VARCHAR2 64     User who created the aging bucket.    
LAST_UPDATE_DATE TIMESTAMP       Last update timestamp.    
LAST_UPDATED_BY VARCHAR2 64     User who last updated the aging bucket.    

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