Oracle Receivables Transaction
Data
Technical name: 0ORA_FI_AR_1
Use
This InfoSource delivers the line items from accounts receivable accounting from the tables AR_PAYMENT_SCHEDULES_ALL, RA_CUSTOMER_TRX_ALL (Transactions), AR_CASH_RECEIPTS_ALL (Receipts), and HZ_CUST_ACCOUNT from the Oracle Receivables application.
InfoSource Communication Structure
InfoObject |
Description |
Oracle Table |
Oracle Field of Origin |
|
0ORA_ROWID |
Oracle Table: Key ID |
AR_PAYMENT_SCHEDULES_ALL |
PAYMENT_SCHEDULE_ID |
|
0ORA_COMP |
Company |
RA_CUSTOMER_TRX_ALL (Transactions), AR_CASH_RECEIPTS_ALL (Receipts) |
SET_OF_BOOKS_ID |
|
0ORA_TRX_NR |
Transaction Number |
AR_PAYMENT_SCHEDULES_ALL |
TRX_NUMBER |
|
0FI_DOCSTAT |
Item Status |
AR_PAYMENT_SCHEDULES_ALL |
STATUS |
|
0ORA_CUST |
Customer |
HZ_CUST_ACCOUNT
|
ACCOUNT_NUMBER |
|
0PSTNG_DATE |
Posting Date |
AR_PAYMENT_SCHEDULES_ALL |
TRX_DATE |
|
0CLEAR_DATE |
Clearing Date |
AR_PAYMENT_SCHEDULES_ALL |
ACTUAL_DATE_CLOSED |
|
0NETDUEDATE |
Clearing Date |
AR_PAYMENT_SCHEDULES_ALL |
DUE_DATE |
|
0DEB_CRE_DC |
Amount in Foreign Currency with Plus/Minus Sign |
AR_PAYMENT_SCHEDULES_ALL |
AMOUNT_DUE_REMAINING |
|
0ORA_ORI_DC |
Original Amount in Foreign Currency with Plus/Minus Sign |
AR_PAYMENT_SCHEDULES_ALL |
AMOUNT_DUE_ORIGINAL |
|
0DSC_AMT_DC |
Cash Discount Amount in Document Currency |
AR_PAYMENT_SCHEDULES_ALL |
DISCOUNT_TAKEN_EARNED + DISCOUNT_TAKEN_UNEARNED |
|
0DOC_CURRCY |
Sales and Distribution Document Currency |
AR_PAYMENT_SCHEDULES_ALL |
INVOICE_CURRENCY_CODE |
|
0SOURSYSTEM |
Source System ID |
--- |
Set by SAP BW
|