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