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

TABLE: AR.AR_CASH_REMIT_REFS_INTERIM

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


An interim table used to store the reference information that would be processed in the given run


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CASH_REMIT_REFS_INTERIM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKER_NUMBER
ColumnCASH_RECEIPT_ID
AR_CASH_REMIT_REFS_INTERIM_UK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKER_NUMBER
Columns
Name Datatype Length Mandatory Comments
REMIT_REFERENCE_ID NUMBER (15) Yes Remit Reference Identifier
AUTOMATCH_SET_ID NUMBER (15)
Automatch Set Identifier
CASH_RECEIPT_ID NUMBER (15)
Cash Receipt Identifier
REFERENCE_SOURCE VARCHAR2 (30)
Reference Source
CUSTOMER_ID NUMBER (15)
Customer Identifier
BANK_ACCOUNT_NUMBER VARCHAR2 (30)
Bank Account Number
TRANSIT_ROUTING_NUMBER VARCHAR2 (25)
Transit Routing Number
INVOICE_REFERENCE VARCHAR2 (50)
Invoice Reference Number
MATCHING_REFERENCE_DATE DATE

Match Reference Date
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code
AMOUNT_APPLIED NUMBER

Amount Applied in Transaction Currency
AMOUNT_APPLIED_FROM NUMBER

Amount Applied in Receipt Currency
TRANS_TO_RECEIPT_RATE NUMBER

Exchange rate
TRANSMISSION_ID NUMBER (15)
Transmission Identifier, used in case if the program is called from Lockbox
BATCH_ID NUMBER (15)
Batch Identifier, used in case if the program is called from QuickCash
WORKER_NUMBER NUMBER

Worker Number
CUSTOMER_NUMBER VARCHAR2 (30)
Customer Number
RECEIPT_REFERENCE_STATUS VARCHAR2 (30) Yes Receipt Reference Status
INSTALLMENT_REFERENCE NUMBER

Installment Reference
Query Text

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


SELECT REMIT_REFERENCE_ID
,      AUTOMATCH_SET_ID
,      CASH_RECEIPT_ID
,      REFERENCE_SOURCE
,      CUSTOMER_ID
,      BANK_ACCOUNT_NUMBER
,      TRANSIT_ROUTING_NUMBER
,      INVOICE_REFERENCE
,      MATCHING_REFERENCE_DATE
,      INVOICE_CURRENCY_CODE
,      AMOUNT_APPLIED
,      AMOUNT_APPLIED_FROM
,      TRANS_TO_RECEIPT_RATE
,      TRANSMISSION_ID
,      BATCH_ID
,      WORKER_NUMBER
,      CUSTOMER_NUMBER
,      RECEIPT_REFERENCE_STATUS
,      INSTALLMENT_REFERENCE
FROM AR.AR_CASH_REMIT_REFS_INTERIM;

Dependencies

[top of page]

AR.AR_CASH_REMIT_REFS_INTERIM does not reference any database object

AR.AR_CASH_REMIT_REFS_INTERIM is referenced by following:

SchemaAR
ViewAR_CASH_REMIT_REFS_INTERIM#