AR_CASH_RECEIPTS_ALL.STATUS In Oracle APPS

Thursday, January 3, 2019

AR_CASH_RECEIPTS_ALL.STATUS in Oracle APPS

• The AR_CASH_RECEIPTS_ALL table stores one record for each receipt that you enter.

• Oracle Receivables concurrently creates records in the AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, and AR_RECEIVABLE_APPLICATIONS_ALL tables for invoice-related receipts.

• For receipts that are not related to invoices, such as miscellaneous receipts, Receivables creates records in the AR_MISC_CASH_DISTRIBUTIONS_ALL table instead of the AR_RECEIVABLE_APPLICATIONS_ALL table.

• Receivables associates a status with each receipt. These statuses include:
• APP for applied
• UNAPP for unapplied
• UNID for unidentified
• NSF for nonsufficient funds
• REV for reversed receipt and
• STOP for stop payment

• Receivables does not update the status of a receipt from UNAPP to APP until the entire amount of the receipt is either applied or placed on account.

• A receipt can have a status of APP even if the entire receipt amount is placed on account.

at January 03, 2019 Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

APEX$TASK_PK

  APEX$TASK_PK is a substitution string holding the primary key value of the system of records

• FNDLOAD to Download and Upload XML Publisher Data Template (.xml) Report The XDOLoader utility is a Java-based command line program to load template (RTF, PDF, and XSL-FO), XML, and XSD files to the XML Publis...
• Query to get OM Order Types in Oracle Apps SELECT HAOU.NAME "Operating Unit",          OTTT_H.NAME "Transaction Type",          OTTT_H.DESCRIPTION "Descripti...
• SQL Query To Get Invoice Validation And Accounting Status For The Given Check Number (Doc ID 2975480.1) SELECT aca.check_number       ,aia.invoice_id   ,aia.invoice_num   ,aia.invoice_amount   ,distribution_line_number   ,aida.accrual_p...

Total Pageviews

Search This Blog

• Home

About Me

ERP(Oracle&Python) View my complete profile

Followers

Report Abuse

Labels 11i Vs R12 12.1.3+ Property Manager 12.2 Property Manager 12.2.4 AP Features 12.2.4 Property Manager 12.2.5 CM 12.2.8 FA 12.2.8 Property Manager 12.2.8+ FA 12.2.9 AP Features 12.2.9 FA 12.2.9 Projects Costing 12.2.9 Property Manager Absence Management Accounting Accouting Hub ADF DI Alerts ANC AOL AP AP-SLA-GL API Application-Object-Library-Lookup AR AR-Lockbox Assets Attachment Auto Lockbox AWT Invoice Bank Business Events Business-Classification CHR(10) CLOB CM Contingent Workers Contracts Customer Data Migration DATE DB-Link DBI dbms_xmlgen DFF e-Text EB-Tax Element Email Employee Expenses FA Fast Formulas FND Form Personalization Freight FSM Fusion Fusion Vs EBS R12 Geography GL Grade GRN HRMS Interfaces Interview Questions Inventory Interface Invoice Items jdr_utils Journal KFF Legal Entity Loans Lookups MOAC Multi-Org OAF OLFM OM OPM Oracle Oracle APEX Oracle Forms Oracle Fusion Oracle Fusion HCM Oracle Fusion Inventory Oracle Fusion Payables Oracle Inventory Oracle Payroll Order Management OTBI Patch Payables Payment Performance Rating Calculation PhoneNumber PMS PO PO_TYPE Pricing Profile Options Projects Property Manager QP Queries R12 Receipts Receivables REPLACE Reports Retirement RTF Sales Invoice Schema SO SQL SQL/PLSQL Status Supplier SupplierAddressImportTemplate Suppliers - Oracle Fusion Tables TCA Trial Balance Tuning/DBA/Oracle APPS Unix/Linux UTL_FILE VBCS Workflow XML Publisher XML-Oracle

Blog Archive

• January 2026 (1)
• November 2025 (2)
• September 2025 (3)
• February 2025 (1)
• January 2025 (29)
• December 2024 (27)
• July 2024 (1)
• January 2024 (4)
• November 2023 (1)
• June 2023 (1)
• March 2023 (1)
• February 2023 (1)
• January 2023 (4)
• December 2022 (3)
• November 2022 (2)
• October 2022 (9)
• September 2022 (2)
• August 2022 (16)
• July 2022 (9)
• June 2022 (65)
• May 2022 (4)
• March 2022 (1)
• February 2022 (3)
• January 2022 (12)
• December 2021 (28)
• November 2021 (37)
• October 2021 (36)
• September 2021 (7)
• August 2021 (8)
• July 2021 (15)
• June 2021 (37)
• May 2021 (38)
• February 2020 (3)
• January 2020 (2)
• April 2019 (5)
• March 2019 (5)
• February 2019 (28)
• January 2019 (8)
• December 2018 (2)
• November 2018 (8)
• October 2018 (8)
• September 2018 (51)
• August 2018 (21)
• July 2018 (26)
• November 2017 (39)
• October 2017 (309)