[Home] [Help] [Dependency Information]
Object Name: | AR_AGING_BUCKETS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_AGING_BUCKETS |
Subobject Name: | |
Status: | VALID |
The AR_AGING BUCKETS table stores information about your aging buckets, used to group and report on open receivables transactions. Each row includes information such as the name, type, and status of your aging bucket. For example, you can define an aging bucket called "Old Past Due Items" that includes an aging bucket line for invoices that are 180 to 270 days past due.
.
You need one row for each aging bucket that you define. Each row has at least one line defined in the AR_AGING_BUCKET_LINES_B table. Oracle Receivables uses the information in the AR_AGING_BUCKETS and AR_AGING_BUCKET_LINES_B tables for your aging reports.
.
The primary key for this table is AGING_BUCKET_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_AGING_BUCKETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AGING_BUCKET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGING_BUCKET_ID | NUMBER | (15) | Yes | Identifier of aging bucket |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
BUCKET_NAME | VARCHAR2 | (20) | Yes | Aging bucket name |
STATUS | VARCHAR2 | (30) | Yes | Status of the aging bucket (Active or Inactive) |
AGING_TYPE | VARCHAR2 | (30) | Yes | Lookup code for aging bucket type in AR_LOOKUPS |
DESCRIPTION | VARCHAR2 | (240) | Aging bucket description | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT AGING_BUCKET_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, BUCKET_NAME
, STATUS
, AGING_TYPE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AR.AR_AGING_BUCKETS;
AR.AR_AGING_BUCKETS does not reference any database object
AR.AR_AGING_BUCKETS is referenced by following:
|
|
|