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 This column is for Oracle Internal use only. 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.