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

TABLE: AR.AR_RECEIPTS_REP_ITF

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_RECEIPTS_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
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).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated 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_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORGANIZATION_NAME VARCHAR2 (50)
Set of Books name
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
BATCH_ID NUMBER (15)
Batch ID
BATCH_NAME VARCHAR2 (20)
Batch Name
CASH_RECEIPT_ID NUMBER (15)
Receipt ID
RECEIPT_NUMBER VARCHAR2 (30)
Receipt Number
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Receipt Currency Code
EXCHANGE_RATE NUMBER

Exchange Rate
EXCHANGE_DATE DATE

Exchange Date
EXCHANGE_TYPE VARCHAR2 (30)
Exchange Rate Type
DOC_SEQUENCE_NAME VARCHAR2 (30)
Document Sequence Name
DOC_SEQUENCE_VALUE NUMBER

Document Sequence Value
DEPOSIT_DATE DATE

Deposit Date
RECEIPT_DATE DATE

Receipt Date
RECEIPT_TYPE VARCHAR2 (30)
Receipt Type
RECEIPT_STATUS VARCHAR2 (40)
Receipt Status
MISC_PAYMENT_SOURCE VARCHAR2 (30)
Miscellaneous Transactions Payment Source
TAX_CODE VARCHAR2 (50)
Tax Code for Miscellaneous Transactions
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
ANTICIPATED_CLEARING_DATE DATE

Anticipated Clearing Date
BANK_NAME VARCHAR2 (60)
Remittance Bank Name
BANK_NAME_ALT VARCHAR2 (320)
Remittance Bank Name (Alt)
BANK_BRANCH_NAME VARCHAR2 (60)
Remittance Branch Name
BANK_BRANCH_NAME_ALT VARCHAR2 (320)
Remittance Branch Name (Alt)
BANK_NUMBER VARCHAR2 (30)
Remittance Bank Number
BANK_BRANCH_NUMBER VARCHAR2 (25)
Remittance Branch Number
BANK_ACCOUNT_NAME VARCHAR2 (80)
Remittance Account Name
BANK_ACCOUNT_NAME_ALT VARCHAR2 (320)
Remittance Account Name (Alt)
BANK_ACCOUNT_CURRENCY VARCHAR2 (15)
Remittance Account Currency
RECEIPT_METHOD VARCHAR2 (30)
Payment Method
CASH_RECEIPT_HISTORY_ID NUMBER (15)
Cash Receipt History ID
GL_DATE DATE

General Ledger date
RECEIPT_AMOUNT NUMBER

Receipt Amount
RECEIPT_HISTORY_STATUS VARCHAR2 (40)
Receipt History Status
ACCTD_RECEIPT_AMOUNT NUMBER

Receipt Amount (Functional currency)
FACTOR_DISCOUNT_AMOUNT NUMBER

Factor Discount Amount
ACCTD_FACTOR_DISCOUNT_AMOUNT NUMBER

Factor Discount Amount (Functional Currency)
ACCOUNT_CODE_COMBINATION_ID NUMBER (15)
Account CCID
DEBIT_ACCOUNT VARCHAR2 (240)
General Ledger account
DEBIT_ACCOUNT_DESC VARCHAR2 (240)
General Ledger account description
DEBIT_BALANCING VARCHAR2 (240)
Balancing Segment
DEBIT_BALANCING_DESC VARCHAR2 (240)
Balancing Segment Description
DEBIT_NATACCT VARCHAR2 (240)
Natural Account
DEBIT_NATACCT_DESC VARCHAR2 (240)
Natural Account Description
CUSTOMER_ID NUMBER (15)
Paying Customer ID
CUSTOMER_NAME VARCHAR2 (240)
Paying Customer Name
CUSTOMER_NAME_ALT VARCHAR2 (320)
Payment Customer Name (Alt)
CUSTOMER_NUMBER VARCHAR2 (30)
Paying Customer Number
RECEIVABLE_APPLICATION_ID NUMBER (15)
Receivable Application ID
APPLY_DATE DATE

Application Date
APPLICATION_STATUS VARCHAR2 (20)
Application Status
AMOUNT_APPLIED_TO NUMBER

Amount Applied (in Invoice Currency)
AMOUNT_APPLIED_FROM NUMBER

Amount Applied (in Receipt Currency)
ACCTD_AMOUNT_APPLIED_TO NUMBER

Accounted Amount Applied (from Invoice Currency)
ACCTD_AMOUNT_APPLIED_FROM NUMBER

Accounted Amount Applied (from Receipt Currency)
EARNED_DISCOUNT_TAKEN NUMBER

Earned Discount Taken
UNEARNED_DISCOUNT_TAKEN NUMBER

Unearned Discount Taken
ACCTD_EARNED_DISCOUNT_TAKEN NUMBER

Earned Discount Taken (Functional Currency)
ACCTD_UNEARNED_DISCOUNT_TAKEN NUMBER

Unearned Discount Taken (Functional Currency)
APPLIED_CUSTOMER_TRX_ID NUMBER (15)
Applied Transaction ID
TRX_NUMBER VARCHAR2 (30)
Applied Transaction Number
TRX_CURRENCY_CODE VARCHAR2 (15)
Applied Transaction Currency Code
TRX_DATE DATE

Applied Transaction Date
TRX_AMOUNT NUMBER

Applied Transaction Amount
ACCTD_TRX_AMOUNT NUMBER

Applied Transaction Amount (Functional Currency)
RECEIPT_GAIN_LOSS NUMBER

Exchange Rate Gain/Loss
MISC_PERCENT NUMBER

Miscellaneous Distribution Percentage
MISC_AMOUNT NUMBER

Miscellaneous Distribution Amount
BATCH_SOURCE VARCHAR2 (50)
Batch Source
RELATED_CUSTOMER VARCHAR2 (50)
Related customer
ON_ACCOUNT_AMOUNT NUMBER

Receipt amount that was applied on account
UNAPP_AMOUNT NUMBER

Unapplied receipt amount
CLAIM_AMOUNT NUMBER

Receipt amount that was applied against claim investigation
PREPAY_AMOUNT NUMBER

Receipt amount that was applied against a prepayment
TOTAL_UNRESOLVED_AMOUNT NUMBER

Total unresolved receipt amount
FORMAT_CURRENCY_CODE VARCHAR2 (15)
Currency code used for formatting amounts on the Unapplied Receipts Register
ACTIVITY_NAME VARCHAR2 (50)
Name of Receivables Activity
ACCOUNT_NUMBER VARCHAR2 (30)
Bank Account Number
ACCOUNTING_FLEXFIELD VARCHAR2 (2000)
Concatenated Accounting Segments
APPLICATION_REF_TYPE VARCHAR2 (80)
Application reference type
APPLICATION_REF_NUMBER VARCHAR2 (30)
Application reference number
AMOUNT_APPLIED NUMBER

Amount Applied
REMIT_BATCH_NAME VARCHAR2 (20)
Name of Remittance Batch
Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      BATCH_ID
,      BATCH_NAME
,      CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      RECEIPT_CURRENCY_CODE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_TYPE
,      DOC_SEQUENCE_NAME
,      DOC_SEQUENCE_VALUE
,      DEPOSIT_DATE
,      RECEIPT_DATE
,      RECEIPT_TYPE
,      RECEIPT_STATUS
,      MISC_PAYMENT_SOURCE
,      TAX_CODE
,      REFERENCE_TYPE
,      ANTICIPATED_CLEARING_DATE
,      BANK_NAME
,      BANK_NAME_ALT
,      BANK_BRANCH_NAME
,      BANK_BRANCH_NAME_ALT
,      BANK_NUMBER
,      BANK_BRANCH_NUMBER
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NAME_ALT
,      BANK_ACCOUNT_CURRENCY
,      RECEIPT_METHOD
,      CASH_RECEIPT_HISTORY_ID
,      GL_DATE
,      RECEIPT_AMOUNT
,      RECEIPT_HISTORY_STATUS
,      ACCTD_RECEIPT_AMOUNT
,      FACTOR_DISCOUNT_AMOUNT
,      ACCTD_FACTOR_DISCOUNT_AMOUNT
,      ACCOUNT_CODE_COMBINATION_ID
,      DEBIT_ACCOUNT
,      DEBIT_ACCOUNT_DESC
,      DEBIT_BALANCING
,      DEBIT_BALANCING_DESC
,      DEBIT_NATACCT
,      DEBIT_NATACCT_DESC
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NAME_ALT
,      CUSTOMER_NUMBER
,      RECEIVABLE_APPLICATION_ID
,      APPLY_DATE
,      APPLICATION_STATUS
,      AMOUNT_APPLIED_TO
,      AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_AMOUNT_APPLIED_FROM
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      APPLIED_CUSTOMER_TRX_ID
,      TRX_NUMBER
,      TRX_CURRENCY_CODE
,      TRX_DATE
,      TRX_AMOUNT
,      ACCTD_TRX_AMOUNT
,      RECEIPT_GAIN_LOSS
,      MISC_PERCENT
,      MISC_AMOUNT
,      BATCH_SOURCE
,      RELATED_CUSTOMER
,      ON_ACCOUNT_AMOUNT
,      UNAPP_AMOUNT
,      CLAIM_AMOUNT
,      PREPAY_AMOUNT
,      TOTAL_UNRESOLVED_AMOUNT
,      FORMAT_CURRENCY_CODE
,      ACTIVITY_NAME
,      ACCOUNT_NUMBER
,      ACCOUNTING_FLEXFIELD
,      APPLICATION_REF_TYPE
,      APPLICATION_REF_NUMBER
,      AMOUNT_APPLIED
,      REMIT_BATCH_NAME
FROM AR.AR_RECEIPTS_REP_ITF;

Dependencies

[top of page]

AR.AR_RECEIPTS_REP_ITF does not reference any database object

AR.AR_RECEIPTS_REP_ITF is referenced by following:

SchemaAPPS
SynonymAR_RECEIPTS_REP_ITF