# DW_AP_AGING_BUCKETS_D

This table contains the AP Aging method and aging bucket definitions.

## Details

Module: Payables

## Key Columns

AGING_PERIOD_LINE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AGING_PERIOD_LINE_ID | NUMBER | 38 | 0 | True | Aging period line identifier. |  |
SOURCE_RECORD_ID | NUMBER | 38 | 0 |  | This column is for Oracle Internal use only. Source record identifier for aging buckets. It is used as the primary key. |  |
AGING_PERIOD_NAME | VARCHAR2 | 64 |  |  | Aging period name. |  |
AGING_PERIOD_DESCRIPTION | VARCHAR2 | 256 |  |  | Aging period description. |  |
AGING_BUCKET_NAME | VARCHAR2 | 16 |  |  | Aging bucket name. |  |
AGING_BUCKET_NUMBER | NUMBER |  |  |  | Aging bucket number. |  |
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. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | CODE
ACTIVE_FLAG | VARCHAR2 | 16 |  |  | Indicates that the aging bucket is active. Values are from the table DW_YESNO_LKP_TL with CODE_TYPE=FA_YESNO. | DW_YESNO_LKP_TL | CODE

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