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

TABLE: AR.AR_INTERIM_POSTING

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


The AR_INTERIM_POSTING table stores posting information when you use the cash basis accounting method. The Oracle Receivables posting program automatically places records in this table when you post to General Ledger.
.
The primary key for this table is CASH_RECEIPT_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_INTERIM_POSTING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCASH_RECEIPT_ID
Columns
Name Datatype Length Mandatory Comments
CASH_RECEIPT_ID NUMBER (15) Yes Identifier of the cash receipt that was posted
BATCH_SOURCE VARCHAR2 (50)
Name of the payment batch source that was posted
BATCH_NAME VARCHAR2 (20)
Name of the payment batch that was posted
RECEIPT_NUMBER VARCHAR2 (30)
Number of receipt that was posted
RECEIPT_DATE DATE

Date of the receipt that was posted
RECEIPT_AMOUNT NUMBER

Amount of receipt that was posted
TRX_NUMBER VARCHAR2 (30)
Transaction number that was posted
LINE_NUMBER NUMBER

Line number that was posted
AMOUNT_APPLIED NUMBER

Applied amount that was posted
Query Text

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


SELECT CASH_RECEIPT_ID
,      BATCH_SOURCE
,      BATCH_NAME
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      RECEIPT_AMOUNT
,      TRX_NUMBER
,      LINE_NUMBER
,      AMOUNT_APPLIED
FROM AR.AR_INTERIM_POSTING;

Dependencies

[top of page]

AR.AR_INTERIM_POSTING does not reference any database object

AR.AR_INTERIM_POSTING is referenced by following:

SchemaAR
ViewAR_INTERIM_POSTING#