DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.AR_BR_TRX_BATCH_RPT

Object Details
Object Name: AR_BR_TRX_BATCH_RPT
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_BR_TRX_BATCH_RPT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnBATCH_ID
ColumnTRANSACTION_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

AR.AR_BR_TRX_BATCH_RPT does not reference any database object

AR.AR_BR_TRX_BATCH_RPT is referenced by following:

SchemaAPPS
SynonymAR_BR_TRX_BATCH_RPT