Wednesday, October 9, 2019

Understanding the AR_PAYMENTS_INTERFACE Table

Hassan Saleem (Oracle Apps Technical) October 09, 2019 Leave a Reply



Column Name
Null?
Type

TRANSMISSION_RECORD_ID
NUMBER(15)
SOURCE:
AR_PAYMENTS_INTERFACE_S.NEXTVAL
DESTINATION:
None
CREATION_DATE
DATE
SOURCE:
CURRENT SYSTEM DATE
DESTINATION:
None
CREATED_BY
NUMBER(15)
SOURCE:
FND_USER.USER_ID
DESTINATION:
AR_BATCHES.CREATED_BY
AR_INTERIM_CASH_RECEIPTS.CREATED_BY
AR_INTERIM_CASH_RECEIPT_LINES.CREATED_BY
LAST_UPDATE_LOGIN
NUMBER(15)
SOURCE:
UNKNOWN
DESTINATION:
None
LAST_UPDATED_BY
NUMBER(15)
SOURCE:
FND_USER.USER_ID
DESTINATION:
None
LAST_UPDATE_DATE
DATE
SOURCE:
CURRENT SYSTEM DATE
DESTINATION:
None
RECORD_TYPE
NOT NULL
VARCHAR2(2)
SOURCE:
AR_TRANS_RECORD_FORMATS.RECORD_IDENTIFIER
DESTINATION:
None
STATUS
VARCHAR2(30)
SOURCE:
FND_MESSAGES.MESSAGE_NAME
DESTINATION:
None
TRANSMISSION_REQUEST_ID
NUMBER(15)
SOURCE:
FND_CONCURRENT_REQUESTS.REQUEST_ID
DESTINATION:
None
TRANSMISSION_ID
NUMBER(15)
SOURCE:
AR_TRANSMISSIONS.TRANSMISSION_ID
DESTINATION:
None
DESTINATION_ACCOUNT
VARCHAR2(25)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_TRANSMISSIONS.DESTINATION
ORIGINATION
VARCHAR2(25)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_TRANSMISSIONS.ORIGIN
DEPOSIT_DATE
DATE
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.DEPOSIT_DATE
GL_DATE
DATE
SOURCE:
DERIVED FROM DEPOSIT DATE, IMPORT DATE OR
ENTERED DATE
DESTINATION:
AR_BATCHES.GL_DATE

AR_INTERIM_CASH_RECEIPTS.GL_DATE

AR_CASH_RECEIPT_HISTORY.GL_DATE
DEPOSIT_TIME
VARCHAR2(8)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
None
TRANSMISSION_RECORD_ COUNT
NUMBER(15)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_TRANSMISSIONS.COUNT
TRANSMISSION_AMOUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_TRANSMISSIONS.AMOUNT
TRANSFERRED_RECEIPT_COUNT
NUMBER
SOURCE:
PROGRAM COUNTS NUMBER OF RECORDS TRANSFERRED
SUCCESSFULLY
DESTINATION:
AR_TRANSMISSIONS.VALIDATED_COUNT
TRANSFERRED_RECEIPT_ AMOUNT
NUMBER
SOURCE:
PROGRAM COUNTS RECEIPT AMOUNTS OF RECORDS
TRANSFERRED SUCCESSFULLY
DESTINATION:
AR_TRANSMISSIONS.VALIDATED_AMOUNT
LOCKBOX_NUMBER
VARCHAR2(30)
SOURCE:
PROVIDED BY BANK OR ENTERED BY USER AT RUNTIME
DESTINATION:
None
LOCKBOX_BATCH_COUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
None
LOCKBOX_RECORD_COUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
None
LOCKBOX_AMOUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
None
BATCH_NAME
VARCHAR2(25)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.LOCKBOX_BATCH_NAME
BATCH_AMOUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.CONTROL_AMOUNT
BATCH_RECORD_COUNT
NUMBER(15)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.CONTROL_COUNT
ITEM_NUMBER
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
None
CURRENCY_CODE
VARCHAR2(15)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.CURRENCY_CODE

AR_INTERIM_CASH_RECEIPTS.CURRENCY_CODE
EXCHANGE_RATE
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.EXCHANGE_RATE

AR_INTERIM_CASH_RECEIPTS.EXCHANGE_RATE
EXCHANGE_RATE_TYPE
VARCHAR2(30)
SOURCE:
DEFAULTS FROM LOCKBOX DEFINITIONS OR ENTERED BY
USER VIA 'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION
AR_BATCHES.EXCHANGE_RATE_TYPE
AR_INTERIM_CASH_RECEIPTS.EXCHANGE
AR_RATE_TYPE
REMITTANCE_AMOUNT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.AMOUNT
TRANSIT_ROUTING_NUMBER
VARCHAR2(25)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AP_BANK_BRANCHES.BANK_NAME
AP_BANK_BRANCHES.BANK_BRANCH_NAME
AP_BANK_BRANCHES.BANK_NUM
ACCOUNT
VARCHAR2(30)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AP_BANK_ACCOUNTS.BANK_ACCOUNT_NUM
CUSTOMER_BANK_ACCOUNT_ID
NUMBER(15)
SOURCE:
AP_BANK_ACCOUNT_USES.EXTERNAL_BANK_
ACCOUNT_ID
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.CUSTOMER_BANK_
ACCOUNT_ID
AR_CASH_RECEIPTS.CUSTOMER_BANK_ACCOUNT_ID
CHECK_NUMBER
VARCHAR2(30)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.RECEIPT_NUMBER
AR_CASH_RECEIPTS.RECEIPT_NUMBER
SPECIAL_TYPE
VARCHAR2(20)
SOURCE:
PROGRAM DETERMINES THE TYPE
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.SPECIAL_TYPE
CUSTOMER_NUMBER
VARCHAR2(30)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
CUSTOMER_ID
NUMBER(15)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.PAY_FROM_CUSTOMER
AR_CASH_RECEIPTS.PAY_FROM_CUSTOMER
BILL_TO_LOCATION
VARCHAR2(40)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
CUSTOMER_SITE_USE_ID
NUMBER(15)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.SITE_USE_ID
AR_CASH_RECEIPTS.CUSTOMER_SITE_USE_ID
RECEIPT_DATE
DATE
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.RECEIPT_DATE
AR_INTERIM_CASH_RECEIPTS.EXCHANGE_DATE
AR_CASH_RECEIPTS.RECEIPT_DATE
AR_CASH_RECEIPTS.EXCHANGE_DATE
RECEIPT_METHOD
VARCHAR2(30)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
RECEIPT_METHOD_ID
NUMBER(15)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.RECEIPT_METHOD_ID
AR_CASH_RECEIPTS.RECEIPT_METHOD_ID
OVERFLOW_INDICATOR
VARCHAR2(1)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
OVERFLOW_SEQUENCE
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
INVOICE1-8
VARCHAR2(50)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
MATCHING_DATE1-8
DATE
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
RESOLVED_MATCHING_ NUMBER1-8
NUMBER
SOURCE:
PROGRAM DETERMINES IT

DESTINATION:
NONE
RESOLVED_MATCHING_DATE1-8
DATE
SOURCE:
PROGRAM DETERMINES IT

DESTINATION:
NONE
RESOLVED_MATCHING_ INSTALLMENT1-8
NUMBER
SOURCE:
PROGRAM DETERMINES IT

DESTINATION:
NONE
AMOUNT_APPLIED1-8
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_INTERIM_CASH_RECEIPT_LINES.PAYMENT
_AMOUNT
AR_RECEIVABLE_APPLICATIONS.AMOUNT_APPLIED
INVOICE1_STATUS- INVOICE8_STATUS
VARCHAR2(30)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
NONE
COMMENTS
VARCHAR2(240)
SOURCE:
ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_BATCHES.COMMENTS
AR_INTERIM_CASH_RECEIPTS.COMMENTS
ATTRIBUTE_CATEGORY
VARCHAR2(30)
ATTRIBUTE1-15
CHAR(40)
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
AR_INTERIM_CASH_RECEIPTS.ATTRIBUTE1...15
AR_CASH_RECEIPTS.ATTRIBUTE1...15
INVOICE1_INSTALLMENT-
INVOICE8_INSTALLMENT
NUMBER
SOURCE:
LOCKBOX DATA FILE OR ENTERED BY USER VIA
'MAINTAIN LOCKBOX TRANSMISSION DATA'
DESTINATION:
NONE
CUSTOMER_NAME_ALT
VARCHAR2(320)
SOURCE:
LOCKBOX DATA FILE
DESTINATION:
NONE
CUSTOMER_BANK_NAME
VARCHAR2(320)
SOURCE:
LOCKBOX DATA FILE
DESTINATION:
NONE
CUSTOMER_ BANK_BRANCH_NAME
VARCHAR2(320)
SOURCE:
LOCKBOX DATA FILE
DESTINATION:
NONE
REMITTANCE_ BANK_NAME
VARCHAR2(320)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
NONE
REMITTANCE_ BANK_BRANCH_NAME
VARCHAR2(320)
SOURCE:
PROGRAM DETERMINES IT
DESTINATION:
NONE
Table 1 - 23. AR_PAYMENTS_INTERFACE Table (Page 8 of 8)



Tags:
Previous Post
Next Post
Hassan Saleem (Oracle Apps Technical)

Overall 5+ Years Hands-on Experience in RICE COMPONENTS i.e. Reports, Interfaces, Conversions and Enhancements of screens/reports (using Oracle FORMS/Oracle REPORT/ XML Publisher) for standard and customize Oracle Applications. Write, debug, database packages, procedures/Function/Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL) as per business requirement with SQL/PLSQL Tuning, Code Review, Testing, Training and providing Technical support to Clients.

0 comments: