[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CASH_RECEIPTS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_CASH_RECEIPTS_ALL
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
This is the AR_CASH_RECEIPTS_ALL view
which may be used by all products
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_CASH_RECEIPTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CASH_RECEIPT_ID
|
| AR_CASH_RECEIPTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SELECTED_REMITTANCE_BATCH_ID
|
| AR_CASH_RECEIPTS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYMENT_SERVER_ORDER_NUM
|
| AR_CASH_RECEIPTS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACTUAL_VALUE_DATE
|
| AR_CASH_RECEIPTS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CC_ERROR_FLAG
|
| AR_CASH_RECEIPTS_N13 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NVL("ACTUAL_VALUE_DATE","ANTICIPATED_CLEARING_DATE")
|
| AR_CASH_RECEIPTS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
WORK_ITEM_STATUS_CODE
CASH_APPLN_OWNER_ID
WORK_ITEM_REVIEW_DATE
|
| AR_CASH_RECEIPTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAY_FROM_CUSTOMER
CUSTOMER_SITE_USE_ID
|
| AR_CASH_RECEIPTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECEIVABLES_TRX_ID
|
| AR_CASH_RECEIPTS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECEIPT_NUMBER
ORG_ID
|
| AR_CASH_RECEIPTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEPOSIT_DATE
|
| AR_CASH_RECEIPTS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REVERSAL_DATE
|
| AR_CASH_RECEIPTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECEIPT_DATE
|
| AR_CASH_RECEIPTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
CC_ERROR_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CASH_RECEIPT_ID | NUMBER | (15) | Yes | |
| 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). | |
| 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. | |
| AMOUNT | NUMBER | Yes | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| RECEIVABLES_TRX_ID | NUMBER | (15) | ||
| PAY_FROM_CUSTOMER | NUMBER | (15) | ||
| STATUS | VARCHAR2 | (30) | ||
| TYPE | VARCHAR2 | (20) | ||
| RECEIPT_NUMBER | VARCHAR2 | (30) | ||
| RECEIPT_DATE | DATE | Yes | ||
| MISC_PAYMENT_SOURCE | VARCHAR2 | (30) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| DISTRIBUTION_SET_ID | NUMBER | (15) | ||
| REVERSAL_DATE | DATE | |||
| REVERSAL_CATEGORY | VARCHAR2 | (20) | ||
| REVERSAL_REASON_CODE | VARCHAR2 | (30) | ||
| REVERSAL_COMMENTS | VARCHAR2 | (240) | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| EXCHANGE_RATE | NUMBER | |||
| EXCHANGE_DATE | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| REMITTANCE_BANK_ACCOUNT_ID | NUMBER | (15) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CONFIRMED_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | ||
| CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
| DEPOSIT_DATE | DATE | |||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
| RECEIPT_METHOD_ID | NUMBER | (15) | Yes | |
| REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
| SELECTED_FOR_FACTORING_FLAG | VARCHAR2 | (1) | ||
| SELECTED_REMITTANCE_BATCH_ID | NUMBER | (15) | ||
| FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | (30) | ||
| DOC_SEQUENCE_VALUE | NUMBER | (15) | ||
| DOC_SEQUENCE_ID | NUMBER | (15) | ||
| VAT_TAX_ID | NUMBER | (15) | ||
| REFERENCE_TYPE | VARCHAR2 | (30) | ||
| REFERENCE_ID | NUMBER | (15) | ||
| CUSTOMER_RECEIPT_REFERENCE | VARCHAR2 | (30) | ||
| OVERRIDE_REMIT_ACCOUNT_FLAG | VARCHAR2 | (1) | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| ANTICIPATED_CLEARING_DATE | DATE | Anticipated clearing date of receipt | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved For Globalization Functionality | |
| ISSUER_NAME | VARCHAR2 | (50) | Original issuer of the Notes Receivable | |
| ISSUE_DATE | DATE | Date on which the Notes Receivable was originally issued. | ||
| ISSUER_BANK_BRANCH_ID | NUMBER | (15) | Bank and branch which originally issued the notes receivable. | |
| CUSTOMER_BANK_BRANCH_ID | NUMBER | (15) | ||
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_EXCHANGE_RATE | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| MRC_EXCHANGE_DATE | VARCHAR2 | (2000) | No longer in use. Multiple Reporting Currencies columns are obsolete in R12. Accounting information for reporting currency is stored in Subledger Accounting tables in R12. | |
| PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | (80) | Identifies credit card payment authorized by Oracle Payment Server | |
| APPROVAL_CODE | VARCHAR2 | (80) | Payment approval code from credit card issuer | |
| ADDRESS_VERIFICATION_CODE | VARCHAR2 | (80) | Credit card address verification code from Oracle Payment Server | |
| TAX_RATE | NUMBER | Stores tax rate when user has overridden ad hoc tax. | ||
| ACTUAL_VALUE_DATE | DATE | Bank Statement Value Date | ||
| POSTMARK_DATE | DATE | The postmark date of the Receipt. Updated for record type 6. Used for discount calculation | ||
| APPLICATION_NOTES | VARCHAR2 | (2000) | Reference number that could not be matched to a transaction number during AutoLockbox validation. | |
| UNIQUE_REFERENCE | VARCHAR2 | (32) | ||
| PROMISE_SOURCE | VARCHAR2 | (30) | Source that generated this promise to pay | |
| REC_VERSION_NUMBER | NUMBER | (15) | ||
| CC_ERROR_CODE | VARCHAR2 | (80) | Error code from credit card payment processor | |
| CC_ERROR_TEXT | VARCHAR2 | (255) | User-enterable description for credit card error code | |
| CC_ERROR_FLAG | VARCHAR2 | (1) | Y indicates a transaction had a credit card processing error | |
| REMIT_BANK_ACCT_USE_ID | NUMBER | (15) | The identifier of the remittance bank account to which the receipt will be deposited. | |
| OLD_CUSTOMER_BANK_BRANCH_ID | NUMBER | (15) | Identifier of the old default remittance bank branch of the payment batch. | |
| OLD_ISSUER_BANK_BRANCH_ID | NUMBER | (15) | Identifier of the old default remittance bank branch of the payment batch. | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Identifies the legal entity to receive this receipt | |
| PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | Payment extension identifier provided Oracle Payments for automatic receipts like credit card receipts and bank account transfer. | |
| AX_ACCOUNTED_FLAG | VARCHAR2 | (1) | Upgrade flag to indicate the distributions have been upgraded by AX | |
| OLD_CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | Identifier of the old default remittance bank account of the payment batch | |
| CASH_APPLN_OWNER_ID | NUMBER | (15) | ||
| WORK_ITEM_ASSIGNMENT_DATE | DATE | |||
| WORK_ITEM_REVIEW_DATE | DATE | |||
| WORK_ITEM_STATUS_CODE | VARCHAR2 | (30) | ||
| WORK_ITEM_REVIEW_NOTE | VARCHAR2 | (2000) | ||
| PREV_PAY_FROM_CUSTOMER | NUMBER | (15) | Identifier of the customer which was associated with this payment entry previously | |
| PREV_CUSTOMER_SITE_USE_ID | NUMBER | (15) | Identifies the customer's location which was associated with this payment entry previously | |
| WORK_ITEM_EXCEPTION_REASON | VARCHAR2 | (30) | Reserved for future use |
Cut, paste (and edit) the following text to query this object:
SELECT CASH_RECEIPT_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, AMOUNT
, SET_OF_BOOKS_ID
, CURRENCY_CODE
, RECEIVABLES_TRX_ID
, PAY_FROM_CUSTOMER
, STATUS
, TYPE
, RECEIPT_NUMBER
, RECEIPT_DATE
, MISC_PAYMENT_SOURCE
, COMMENTS
, DISTRIBUTION_SET_ID
, REVERSAL_DATE
, REVERSAL_CATEGORY
, REVERSAL_REASON_CODE
, REVERSAL_COMMENTS
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, REMITTANCE_BANK_ACCOUNT_ID
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONFIRMED_FLAG
, CUSTOMER_BANK_ACCOUNT_ID
, CUSTOMER_SITE_USE_ID
, DEPOSIT_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RECEIPT_METHOD_ID
, REQUEST_ID
, SELECTED_FOR_FACTORING_FLAG
, SELECTED_REMITTANCE_BATCH_ID
, FACTOR_DISCOUNT_AMOUNT
, USSGL_TRANSACTION_CODE
, USSGL_TRANSACTION_CODE_CONTEXT
, DOC_SEQUENCE_VALUE
, DOC_SEQUENCE_ID
, VAT_TAX_ID
, REFERENCE_TYPE
, REFERENCE_ID
, CUSTOMER_RECEIPT_REFERENCE
, OVERRIDE_REMIT_ACCOUNT_FLAG
, ORG_ID
, ANTICIPATED_CLEARING_DATE
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, ISSUER_NAME
, ISSUE_DATE
, ISSUER_BANK_BRANCH_ID
, CUSTOMER_BANK_BRANCH_ID
, MRC_EXCHANGE_RATE_TYPE
, MRC_EXCHANGE_RATE
, MRC_EXCHANGE_DATE
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, ADDRESS_VERIFICATION_CODE
, TAX_RATE
, ACTUAL_VALUE_DATE
, POSTMARK_DATE
, APPLICATION_NOTES
, UNIQUE_REFERENCE
, PROMISE_SOURCE
, REC_VERSION_NUMBER
, CC_ERROR_CODE
, CC_ERROR_TEXT
, CC_ERROR_FLAG
, REMIT_BANK_ACCT_USE_ID
, OLD_CUSTOMER_BANK_BRANCH_ID
, OLD_ISSUER_BANK_BRANCH_ID
, LEGAL_ENTITY_ID
, PAYMENT_TRXN_EXTENSION_ID
, AX_ACCOUNTED_FLAG
, OLD_CUSTOMER_BANK_ACCOUNT_ID
, CASH_APPLN_OWNER_ID
, WORK_ITEM_ASSIGNMENT_DATE
, WORK_ITEM_REVIEW_DATE
, WORK_ITEM_STATUS_CODE
, WORK_ITEM_REVIEW_NOTE
, PREV_PAY_FROM_CUSTOMER
, PREV_CUSTOMER_SITE_USE_ID
, WORK_ITEM_EXCEPTION_REASON
FROM AR.AR_CASH_RECEIPTS_ALL;
AR.AR_CASH_RECEIPTS_ALL does not reference any database object
AR.AR_CASH_RECEIPTS_ALL is referenced by following:
APPS
AR_CASH_RECEIPTS
AR_CASH_RECEIPTS_ALL
JAI_AR_CR_ARIUD_T1
|
|
|
|