DW_AR_AGING_BUCKETS_D

This table contains the aging method and aging bucket definitions for Receivables.

Details

Module: Receivables

Key Columns

AGING_BUCKET_LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AGING_BUCKET_LINE_ID NUMBER 38 0 True Aging bucket line identifier.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier for aging buckets.    
AGING_METHOD_NAME VARCHAR2 32     Aging method name.    
AGING_METHOD_DESCRIPTION VARCHAR2 256     Aging method description.    
AGING_BUCKET_NAME VARCHAR2 32     Aging bucket name.    
AGING_BUCKET_SEQUENCE_NUMBER NUMBER 38 0   Aging bucket sequence number.    
AGING_TYPE VARCHAR2 32     Aging type.    
BUCKET_TYPE VARCHAR2 32     Bucket type.    
DAYS_FROM NUMBER       Starting day number for aging bucket.    
DAYS_TO NUMBER       Ending day number for aging bucket.    
OVERDUE_FLAG VARCHAR2 16     Indicates that the aging bucket is overdue.    
ACTIVE_FLAG VARCHAR2 16     Indicates that the aging bucket is active.    

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