Oracle Receivables : Useful AR Tables Informations 1- RA_CUSTOMER_TRX_ALL 2- RA_CUSTOMER_TRX_LINES_ALL 3- RA_CUST_TRX_LINE_GL_DIST_ALL 4- AR_PAYMENT_SCHEDULES_ALL 5- AR_RECEIVABLES_TRX_ALL 6- AR_RECEIVABLE_APPLICATIONS_ALL RA_CUSTOMER_TRX_ALL This table stores invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information such as customer, transaction type, and printing instructions. You need one row for each invoice, debit memo, commitment, and credit memo you create in Oracle Receivables. Invoices, debit memos, credit memos, and commitments are all distinguished by their transaction types stored in RA_CUST_TRX_TYPES_ALL. If you entered a credit memo, PREVIOUS_CUSTOMER_TRX_ID stores the customer transaction identifier of the invoice you credited. In the case of on account credits, which are not related to any invoice at creation, PREVIOUS_CUSTOMER_TRX_ID is null. If you created an invoice against a commitm...
Comments
Post a Comment