[Home] [Help] [Dependency Information]
Object Name: | AR_REMITTED_RECEIPTS_FORMAT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AR.AR_REMITTED_RECEIPTS_FORMAT_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
RECEIPT_CURRENCY | VARCHAR2 | (15) | Yes | |
RECEIPT_AMOUNT | NUMBER | Yes | ||
RECEIPT_FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
RECEIPT_DATE | DATE | Yes | ||
RECEIPT_DEPOSIT_DATE | DATE | |||
MATURITY_DATE | DATE | |||
PAYMENT_METHOD | VARCHAR2 | (30) | ||
RECEIPT_EXCHANGE_RATE | NUMBER | |||
RECEIPT_SELECTED_FOR_FACTORING | VARCHAR2 | (80) | Yes | |
CUSTOMER_NAME | VARCHAR2 | (50) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_SITE_LOCATION | VARCHAR2 | (40) | ||
CUSTOMER_BANK_NAME | VARCHAR2 | (0) | ||
CUSTOMER_BANK_BRANCH_NAME | VARCHAR2 | (0) | ||
CUSTOMER_BANK_BRANCH_NUMBER | VARCHAR2 | (0) | ||
CUSTOMER_BANK_ACCOUNT_NAME | VARCHAR2 | (0) | ||
CUSTOMER_BANK_ACCOUNT_NUMBER | VARCHAR2 | (100) | ||
REMIT_BANK_NAME | VARCHAR2 | (360) | Yes | |
REMIT_BANK_BRANCH_NAME | VARCHAR2 | (360) | Yes | |
REMIT_BANK_BRANCH_NUMBER | VARCHAR2 | (30) | ||
REMIT_BANK_ACCOUNT_NAME | VARCHAR2 | (100) | Yes | |
REMIT_BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
REMIT_BATCH_NAME | VARCHAR2 | (20) | Yes | |
REMIT_BATCH_DATE | DATE | Yes | ||
REMIT_BATCH_REMIT_METHOD | VARCHAR2 | (80) | ||
REMIT_BATCH_MEDIA_REFERENCE | VARCHAR2 | (80) | ||
CLEARING_HOUSE_NAME | VARCHAR2 | (360) | ||
CLEARING_HOUSE_BRANCH_NAME | VARCHAR2 | (360) | ||
CLEARING_HOUSE_BRANCH_NUMBER | VARCHAR2 | (30) | ||
CASH_RECEIPT_ID | NUMBER | (15) | Yes | |
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_BANK_ACCOUNT_ID | VARCHAR2 | (0) | ||
REMIT_BANK_ACCOUNT_ID | NUMBER | (15) | ||
REMIT_BATCH_ID | NUMBER | (15) | Yes | |
CUSTOMER_RECEIPT_REFERENCE | VARCHAR2 | (30) | ||
PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | ||
PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_NUMBER
, RECEIPT_CURRENCY
, RECEIPT_AMOUNT
, RECEIPT_FACTOR_DISCOUNT_AMOUNT
, RECEIPT_DATE
, RECEIPT_DEPOSIT_DATE
, MATURITY_DATE
, PAYMENT_METHOD
, RECEIPT_EXCHANGE_RATE
, RECEIPT_SELECTED_FOR_FACTORING
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_SITE_LOCATION
, CUSTOMER_BANK_NAME
, CUSTOMER_BANK_BRANCH_NAME
, CUSTOMER_BANK_BRANCH_NUMBER
, CUSTOMER_BANK_ACCOUNT_NAME
, CUSTOMER_BANK_ACCOUNT_NUMBER
, REMIT_BANK_NAME
, REMIT_BANK_BRANCH_NAME
, REMIT_BANK_BRANCH_NUMBER
, REMIT_BANK_ACCOUNT_NAME
, REMIT_BANK_ACCOUNT_NUMBER
, REMIT_BATCH_NAME
, REMIT_BATCH_DATE
, REMIT_BATCH_REMIT_METHOD
, REMIT_BATCH_MEDIA_REFERENCE
, CLEARING_HOUSE_NAME
, CLEARING_HOUSE_BRANCH_NAME
, CLEARING_HOUSE_BRANCH_NUMBER
, CASH_RECEIPT_ID
, CUSTOMER_ID
, CUSTOMER_BANK_ACCOUNT_ID
, REMIT_BANK_ACCOUNT_ID
, REMIT_BATCH_ID
, CUSTOMER_RECEIPT_REFERENCE
, PAYMENT_TRXN_EXTENSION_ID
, PAYMENT_CHANNEL_CODE
FROM APPS.AR_REMITTED_RECEIPTS_FORMAT_V;
APPS.AR_REMITTED_RECEIPTS_FORMAT_V is not referenced by any database object
|
|
|