This table contains the AP Aging method and aging bucket definitions.
Module: Payables
AGING_PERIOD_LINE_ID
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.