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   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_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE
ACTIVE_FLAG VARCHAR2 16     Indicates that the aging bucket is active. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=FA_YESNO. DW_CODE_VALUES_LKP_TL CODE

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