Skip to content

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

VIEW: APPS.AR_PAYMENTS_INTERFACE_V

Object Details
Object Name: AR_PAYMENTS_INTERFACE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_PAYMENTS_INTERFACE_V
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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TRANSMISSION_RECORD_ID NUMBER (15)
TRANSMISSION_ID NUMBER (15)
TRANSMISSION_NAME VARCHAR2 (30) Yes
TRANSMISSION_REQUEST_ID NUMBER (15)
CREATION_DATE DATE

TRUNC_CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LOCKBOX_NUMBER VARCHAR2 (30)
BATCH_NAME VARCHAR2 (25)
ITEM_NUMBER NUMBER

CHECK_NUMBER VARCHAR2 (30)
OVERFLOW_SEQUENCE NUMBER

RECORD_TYPE VARCHAR2 (2) Yes
RECORD_TYPE_LOOKUP_CODE VARCHAR2 (30) Yes
STATUS VARCHAR2 (30)
COMMENTS VARCHAR2 (240)
ORIGINATION VARCHAR2 (25)
DESTINATION_ACCOUNT VARCHAR2 (25)
DEPOSIT_DATE DATE

GL_DATE DATE

DEPOSIT_TIME VARCHAR2 (8)
CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_RATE NUMBER

TRANSMISSION_RECORD_COUNT NUMBER (15)
TRANSMISSION_AMOUNT NUMBER

LOCKBOX_BATCH_COUNT NUMBER

LOCKBOX_AMOUNT NUMBER

LOCKBOX_RECORD_COUNT NUMBER

BATCH_RECORD_COUNT NUMBER (15)
BATCH_AMOUNT NUMBER

TRANSFERRED_RECEIPT_COUNT NUMBER

TRANSFERRED_RECEIPT_AMOUNT NUMBER

OVERFLOW_INDICATOR VARCHAR2 (1)
SPECIAL_TYPE VARCHAR2 (20)
RECEIPT_DATE DATE

RECEIPT_METHOD_ID NUMBER (15)
RECEIPT_METHOD VARCHAR2 (30)
REMITTANCE_AMOUNT NUMBER

CUSTOMER_ID NUMBER (15)
CUSTOMER_NUMBER VARCHAR2 (30)
CUSTOMER_SITE_USE_ID NUMBER (15)
BILL_TO_LOCATION VARCHAR2 (40)
TRANSIT_ROUTING_NUMBER VARCHAR2 (25)
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
ACCOUNT VARCHAR2 (30)
AMOUNT_APPLIED1 NUMBER

INVOICE1 VARCHAR2 (50)
INVOICE1_INSTALLMENT NUMBER

INVOICE1_STATUS VARCHAR2 (30)
AMOUNT_APPLIED2 NUMBER

INVOICE2 VARCHAR2 (50)
INVOICE2_INSTALLMENT NUMBER

INVOICE2_STATUS VARCHAR2 (30)
AMOUNT_APPLIED3 NUMBER

INVOICE3 VARCHAR2 (50)
INVOICE3_INSTALLMENT NUMBER

INVOICE3_STATUS VARCHAR2 (30)
AMOUNT_APPLIED4 NUMBER

INVOICE4 VARCHAR2 (50)
INVOICE4_INSTALLMENT NUMBER

INVOICE4_STATUS VARCHAR2 (30)
AMOUNT_APPLIED5 NUMBER

INVOICE5 VARCHAR2 (50)
INVOICE5_INSTALLMENT NUMBER

INVOICE5_STATUS VARCHAR2 (30)
AMOUNT_APPLIED6 NUMBER

INVOICE6 VARCHAR2 (50)
INVOICE6_INSTALLMENT NUMBER

INVOICE6_STATUS VARCHAR2 (30)
AMOUNT_APPLIED7 NUMBER

INVOICE7 VARCHAR2 (50)
INVOICE7_INSTALLMENT NUMBER

INVOICE7_STATUS VARCHAR2 (30)
AMOUNT_APPLIED8 NUMBER

INVOICE8 VARCHAR2 (50)
INVOICE8_INSTALLMENT NUMBER

INVOICE8_STATUS VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
CUSTOMER_NAME VARCHAR2 (50)
CUSTOMER_NAME_PHONETIC VARCHAR2 (320)
CUSTOMER_NAME_ALT VARCHAR2 (320)
CUSTOMER_BANK_NAME VARCHAR2 (320)
CUSTOMER_BANK_BRANCH_NAME VARCHAR2 (320)
REMITTANCE_BANK_NAME VARCHAR2 (320)
REMITTANCE_BANK_BRANCH_NAME VARCHAR2 (320)
MATCHING1_DATE DATE

MATCHING2_DATE DATE

MATCHING3_DATE DATE

MATCHING4_DATE DATE

MATCHING5_DATE DATE

MATCHING6_DATE DATE

MATCHING7_DATE DATE

MATCHING8_DATE DATE

MATCH_RESOLVED_USING VARCHAR2 (30)
AMOUNT_APPLIED_FROM1 NUMBER

AMOUNT_APPLIED_FROM2 NUMBER

AMOUNT_APPLIED_FROM3 NUMBER

AMOUNT_APPLIED_FROM4 NUMBER

AMOUNT_APPLIED_FROM5 NUMBER

AMOUNT_APPLIED_FROM6 NUMBER

AMOUNT_APPLIED_FROM7 NUMBER

AMOUNT_APPLIED_FROM8 NUMBER

INVOICE_CURRENCY_CODE1 VARCHAR2 (15)
INVOICE_CURRENCY_CODE2 VARCHAR2 (15)
INVOICE_CURRENCY_CODE3 VARCHAR2 (15)
INVOICE_CURRENCY_CODE4 VARCHAR2 (15)
INVOICE_CURRENCY_CODE5 VARCHAR2 (15)
INVOICE_CURRENCY_CODE6 VARCHAR2 (15)
INVOICE_CURRENCY_CODE7 VARCHAR2 (15)
INVOICE_CURRENCY_CODE8 VARCHAR2 (15)
TRANS_TO_RECEIPT_RATE1 NUMBER

TRANS_TO_RECEIPT_RATE2 NUMBER

TRANS_TO_RECEIPT_RATE3 NUMBER

TRANS_TO_RECEIPT_RATE4 NUMBER

TRANS_TO_RECEIPT_RATE5 NUMBER

TRANS_TO_RECEIPT_RATE6 NUMBER

TRANS_TO_RECEIPT_RATE7 NUMBER

TRANS_TO_RECEIPT_RATE8 NUMBER

USSGL_TRANSACTION_CODE VARCHAR2 (30)
USSGL_TRANSACTION_CODE1 VARCHAR2 (30)
USSGL_TRANSACTION_CODE2 VARCHAR2 (30)
USSGL_TRANSACTION_CODE3 VARCHAR2 (30)
USSGL_TRANSACTION_CODE4 VARCHAR2 (30)
USSGL_TRANSACTION_CODE5 VARCHAR2 (30)
USSGL_TRANSACTION_CODE6 VARCHAR2 (30)
USSGL_TRANSACTION_CODE7 VARCHAR2 (30)
USSGL_TRANSACTION_CODE8 VARCHAR2 (30)
APPLICATION_NOTES VARCHAR2 (2000)
ORG_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      TRANSMISSION_RECORD_ID
,      TRANSMISSION_ID
,      TRANSMISSION_NAME
,      TRANSMISSION_REQUEST_ID
,      CREATION_DATE
,      TRUNC_CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LOCKBOX_NUMBER
,      BATCH_NAME
,      ITEM_NUMBER
,      CHECK_NUMBER
,      OVERFLOW_SEQUENCE
,      RECORD_TYPE
,      RECORD_TYPE_LOOKUP_CODE
,      STATUS
,      COMMENTS
,      ORIGINATION
,      DESTINATION_ACCOUNT
,      DEPOSIT_DATE
,      GL_DATE
,      DEPOSIT_TIME
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      TRANSMISSION_RECORD_COUNT
,      TRANSMISSION_AMOUNT
,      LOCKBOX_BATCH_COUNT
,      LOCKBOX_AMOUNT
,      LOCKBOX_RECORD_COUNT
,      BATCH_RECORD_COUNT
,      BATCH_AMOUNT
,      TRANSFERRED_RECEIPT_COUNT
,      TRANSFERRED_RECEIPT_AMOUNT
,      OVERFLOW_INDICATOR
,      SPECIAL_TYPE
,      RECEIPT_DATE
,      RECEIPT_METHOD_ID
,      RECEIPT_METHOD
,      REMITTANCE_AMOUNT
,      CUSTOMER_ID
,      CUSTOMER_NUMBER
,      CUSTOMER_SITE_USE_ID
,      BILL_TO_LOCATION
,      TRANSIT_ROUTING_NUMBER
,      CUSTOMER_BANK_ACCOUNT_ID
,      ACCOUNT
,      AMOUNT_APPLIED1
,      INVOICE1
,      INVOICE1_INSTALLMENT
,      INVOICE1_STATUS
,      AMOUNT_APPLIED2
,      INVOICE2
,      INVOICE2_INSTALLMENT
,      INVOICE2_STATUS
,      AMOUNT_APPLIED3
,      INVOICE3
,      INVOICE3_INSTALLMENT
,      INVOICE3_STATUS
,      AMOUNT_APPLIED4
,      INVOICE4
,      INVOICE4_INSTALLMENT
,      INVOICE4_STATUS
,      AMOUNT_APPLIED5
,      INVOICE5
,      INVOICE5_INSTALLMENT
,      INVOICE5_STATUS
,      AMOUNT_APPLIED6
,      INVOICE6
,      INVOICE6_INSTALLMENT
,      INVOICE6_STATUS
,      AMOUNT_APPLIED7
,      INVOICE7
,      INVOICE7_INSTALLMENT
,      INVOICE7_STATUS
,      AMOUNT_APPLIED8
,      INVOICE8
,      INVOICE8_INSTALLMENT
,      INVOICE8_STATUS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CUSTOMER_NAME
,      CUSTOMER_NAME_PHONETIC
,      CUSTOMER_NAME_ALT
,      CUSTOMER_BANK_NAME
,      CUSTOMER_BANK_BRANCH_NAME
,      REMITTANCE_BANK_NAME
,      REMITTANCE_BANK_BRANCH_NAME
,      MATCHING1_DATE
,      MATCHING2_DATE
,      MATCHING3_DATE
,      MATCHING4_DATE
,      MATCHING5_DATE
,      MATCHING6_DATE
,      MATCHING7_DATE
,      MATCHING8_DATE
,      MATCH_RESOLVED_USING
,      AMOUNT_APPLIED_FROM1
,      AMOUNT_APPLIED_FROM2
,      AMOUNT_APPLIED_FROM3
,      AMOUNT_APPLIED_FROM4
,      AMOUNT_APPLIED_FROM5
,      AMOUNT_APPLIED_FROM6
,      AMOUNT_APPLIED_FROM7
,      AMOUNT_APPLIED_FROM8
,      INVOICE_CURRENCY_CODE1
,      INVOICE_CURRENCY_CODE2
,      INVOICE_CURRENCY_CODE3
,      INVOICE_CURRENCY_CODE4
,      INVOICE_CURRENCY_CODE5
,      INVOICE_CURRENCY_CODE6
,      INVOICE_CURRENCY_CODE7
,      INVOICE_CURRENCY_CODE8
,      TRANS_TO_RECEIPT_RATE1
,      TRANS_TO_RECEIPT_RATE2
,      TRANS_TO_RECEIPT_RATE3
,      TRANS_TO_RECEIPT_RATE4
,      TRANS_TO_RECEIPT_RATE5
,      TRANS_TO_RECEIPT_RATE6
,      TRANS_TO_RECEIPT_RATE7
,      TRANS_TO_RECEIPT_RATE8
,      USSGL_TRANSACTION_CODE
,      USSGL_TRANSACTION_CODE1
,      USSGL_TRANSACTION_CODE2
,      USSGL_TRANSACTION_CODE3
,      USSGL_TRANSACTION_CODE4
,      USSGL_TRANSACTION_CODE5
,      USSGL_TRANSACTION_CODE6
,      USSGL_TRANSACTION_CODE7
,      USSGL_TRANSACTION_CODE8
,      APPLICATION_NOTES
,      ORG_ID
FROM APPS.AR_PAYMENTS_INTERFACE_V;

Dependencies

[top of page]

APPS.AR_PAYMENTS_INTERFACE_V references the following:

SchemaAPPS
SynonymAR_PAYMENTS_INTERFACE
SynonymAR_TRANSMISSIONS
SynonymAR_TRANS_RECORD_FORMATS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES

APPS.AR_PAYMENTS_INTERFACE_V is not referenced by any database object