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

TABLE: AR.AR_AUTOREC_INTERIM

Object Details
Object Name: AR_AUTOREC_INTERIM
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_AUTOREC_INTERIM
Subobject Name:
Status: VALID


Temporary table used in the autoreceipts parallel process


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15)
Unique identifier for the interim table used in auto receipts
PAYMENT_SCHEDULE_ID NUMBER (15)
Payment schedule id of the invoice
CUSTOMER_TRX_ID NUMBER (15)
Customer trx id of the invoice
CASH_RECEIPT_ID NUMBER (15)
cash receipt id of the receipt created for the associated invoice
PAYING_CUSTOMER_ID NUMBER (15)
Paying customer id of the receipt
PAYING_SITE_USE_ID NUMBER (15)
Paying site use id of the receipt
PAYMENT_TRXN_EXTENSION_ID NUMBER (15)
Payment trxn extension id of the invoice
DUE_DATE DATE

Due date of the invoice
AMOUNT_DUE_REMAINING NUMBER

Amount due remaining of the invoice
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
Customer bank account id
CUST_MIN_AMOUNT NUMBER

Minimum amount that must be created for each receipt
PAYMENT_CHANNEL_CODE VARCHAR2 (30)
Payment channel code
PAYMENT_INSTRUMENT VARCHAR2 (30)
Payment instrument of the invoice
WORKER_ID NUMBER (15)
Worker id, used for multi worker request
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      CASH_RECEIPT_ID
,      PAYING_CUSTOMER_ID
,      PAYING_SITE_USE_ID
,      PAYMENT_TRXN_EXTENSION_ID
,      DUE_DATE
,      AMOUNT_DUE_REMAINING
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUST_MIN_AMOUNT
,      PAYMENT_CHANNEL_CODE
,      PAYMENT_INSTRUMENT
,      WORKER_ID
FROM AR.AR_AUTOREC_INTERIM;

Dependencies

[top of page]

AR.AR_AUTOREC_INTERIM does not reference any database object

AR.AR_AUTOREC_INTERIM is referenced by following:

SchemaAR
ViewAR_AUTOREC_INTERIM#