[Home] [Help] [Dependency Information]
Object Name: | AR_BR_TRX_BATCH_RPT |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_BR_TRX_BATCH_RPT |
Subobject Name: | |
Status: | VALID |
The AR_BR_TRX_BATCH_RPT table contains data that is populated by the Bills Receivable Transaction Batches window and the Bills Receivable Batch Creation concurrent program for bills receivable. Oracle Receivables uses this data as the source for the Automatic Transactions Batch report.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_BR_TRX_BATCH_RPT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
BATCH_ID TRANSACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created 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_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
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). | |
REQUEST_ID | NUMBER | (15) | Yes | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
BATCH_ID | NUMBER | (15) | Yes | Batch ID that bills receivable is included in |
BR_CUSTOMER_TRX_ID | NUMBER | (15) | Identifier of bills receivable transaction | |
BILL_NUMBER | VARCHAR2 | (20) | Bills receivable transaction number | |
BR_AMOUNT | NUMBER | Amount of bills receivable | ||
BR_CURRENCY | VARCHAR2 | (15) | Currency of bills receivable | |
BATCH_STATUS | VARCHAR2 | (20) | Status of batch when row was created | |
MATURITY_DATE | DATE | Maturity date of the bills receivable | ||
DRAWEE_ID | NUMBER | (15) | Drawee identifier | |
DRAWEE_CONTACT_ID | NUMBER | (15) | Drawee contact identifier | |
DRAWEE_SITE_USE_ID | NUMBER | (15) | Site use identifier | |
DRAWEE_BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier | |
TRANSACTION_ID | NUMBER | (15) | Identifier of included transaction | |
AMOUNT_ASSIGNED | NUMBER | Amount of included transaction assigned to the bills receivable | ||
RECEIPT_METHOD_NAME | VARCHAR2 | (30) | Receipt method name | |
RECEIPT_CREATION_RULE_CODE | VARCHAR2 | (30) | Grouping rule code | |
BR_MIN_ACCTD_AMOUNT | NUMBER | Minimum accounted amount | ||
BR_MAX_ACCTD_AMOUNT | NUMBER | Maximum accounted amount | ||
LEAD_DAYS | NUMBER | Lead days |
Cut, paste (and edit) the following text to query this object:
SELECT CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, BATCH_ID
, BR_CUSTOMER_TRX_ID
, BILL_NUMBER
, BR_AMOUNT
, BR_CURRENCY
, BATCH_STATUS
, MATURITY_DATE
, DRAWEE_ID
, DRAWEE_CONTACT_ID
, DRAWEE_SITE_USE_ID
, DRAWEE_BANK_ACCOUNT_ID
, TRANSACTION_ID
, AMOUNT_ASSIGNED
, RECEIPT_METHOD_NAME
, RECEIPT_CREATION_RULE_CODE
, BR_MIN_ACCTD_AMOUNT
, BR_MAX_ACCTD_AMOUNT
, LEAD_DAYS
FROM AR.AR_BR_TRX_BATCH_RPT;
AR.AR_BR_TRX_BATCH_RPT does not reference any database object
AR.AR_BR_TRX_BATCH_RPT is referenced by following:
|
|
|