[Home] [Help] [Dependency Information]
Object Name: | FUN_BATCH_DISTS |
---|---|
Object Type: | TABLE |
Owner: | FUN |
FND Design Data: | FUN.FUN_BATCH_DISTS |
Subobject Name: | |
Status: | VALID |
FUN_BATCH_DISTS stores the distribution details if user has chosen to enter distributions using the automatic proration mode. The amounts entered in this case are prorated for the recipients and distributions lines created in FUN_DIST_LINES. Once the distributions have been prorated and created in FUN_DIST_LINES, the data in this table is not used by any other process.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_DIST_ID | NUMBER | (15) | Yes | System generated batch distribution identifier |
LINE_NUMBER | NUMBER | Yes | Line number | |
BATCH_ID | NUMBER | (15) | Yes | Batch identifier |
CCID | NUMBER | (15) | Code combination identifier | |
AMOUNT_CR | NUMBER | Debit amount | ||
AMOUNT_DR | NUMBER | Credit amount | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who 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. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield context |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_DIST_ID
, LINE_NUMBER
, BATCH_ID
, CCID
, AMOUNT_CR
, AMOUNT_DR
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM FUN.FUN_BATCH_DISTS;
FUN.FUN_BATCH_DISTS does not reference any database object
FUN.FUN_BATCH_DISTS is referenced by following:
|
|
|