Results for “remit_print_program_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_RECEIPT_METHOD_ACCOUNTS_ALL is a Receivables (AR) transaction table that stores the account information used by receipt payment methods. Each row associates a receipt method (RECEIPT_METHOD_ID) with a remittance bank account use (REMIT_BANK_ACCT_USE_ID) and records the General Ledger accounts, remittance and factor programs, clearing parameters, and payment-processing attributes applied when receipts are created, remitted, cleared, and reconciled for that combination. In Oracle EBS 12.1.1 and 12.2.2 the table is owned by the AR schema and is a key configuration object in Receivables setup, since it determines how receipt accounting entries are derived.

In a Data Vault modeling sense, the structure suggests a satellite-leaning classification: its composite primary key formed from two parent references and its descriptive account, program, and control attributes are typical of a satellite attached to the receipt method and bank account use hubs, rather than of an independent hub or a pure relationship link.

Key Information Stored

The composite primary key AR_RECEIPT_METHOD_ACCOUNTS_PK is defined on REMIT_BANK_ACCT_USE_ID and RECEIPT_METHOD_ID. A unique index, AR_RECEIPT_METHOD_ACCOUNTS_U1, covers RECEIPT_METHOD_ID, REMIT_BANK_ACCT_USE_ID, and ZD_EDITION_NAME, making this the business-key candidate. The table contains 76 documented columns. The most significant are:

• CASH_CCID, RECEIPT_CLEARING_CCID, UNIDENTIFIED_CCID, UNAPPLIED_CCID, UNEARNED_CCID, and EARNED_CCID – GL_CODE_COMBINATIONS references that drive receipt accounting.
• ON_ACCOUNT_CCID, UNIDENTIFIED_CCID, BANK_CHARGES_CCID, FACTOR_CCID, REMITTANCE_CCID, SHORT_TERM_DEBT_CCID, and BR_REMITTANCE_CCID/BR_FACTOR_CCID – additional accounting and localization references.
• RECEIPT_CLEARING_CCID and CLEARING_DAYS – clearing and float configuration.
• REMIT_PRINT_PROGRAM_ID, REMIT_TRANSMISSION_PROGRAM_ID, FACTOR_PRINT_PROGRAM_ID, and FACTOR_TRANSMISSION_PROGRAM_ID – AP_PAYMENT_PROGRAMS references controlling remittance formatting.
• EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID, BR_STD_RECEIVABLES_TRX_ID, and CLAIM_RECEIVABLES_TRX_ID – AR_RECEIVABLES_TRX_ALL references for earned and unearned discount accounting.
• PRIMARY_FLAG, OVERRIDE_REMIT_ACCOUNT_FLAG, MIN_RECEIPT_AMOUNT, RISK_ELIMINATION_DAYS, START_DATE, and END_DATE – operational flags and date-ranged validity.
• ORG_ID, OLD_BANK_ACCOUNT_ID, and ZD_EDITION_NAME – multi-org context, legacy bank account reference, and edition support.

Common Use Cases and Queries

Typical uses include diagnosing receipt accounting errors, validating receipt method setup, and reporting on GL account assignments. Because many columns resolve to GL_CODE_COMBINATIONS, a common pattern joins the table to GL_CODE_COMBINATIONS on each CCID to obtain concatenated account segments.

• List account assignments for a receipt method:

  SELECT rm.receipt_method_id, rm.remit_bank_acct_use_id,
         gcc.concatenated_segments cash_account
  FROM   ar.ar_receipt_method_accounts_all rm,
         gl.gl_code_combinations_kfv gcc
  WHERE  rm.cash_ccid = gcc.code_combination_id
  AND    rm.receipt_method_id = :p_method_id;

• Identify the clearing account and clearing days configured for remittance processing.
• Audit unearned and earned discount transaction references joined to AR_RECEIVABLES_TRX_ALL.
• Check remittance and factor print program assignments against AP_PAYMENT_PROGRAMS.

Related Objects

The most significant related objects, based on the documented foreign key relationships, are:

• GL_CODE_COMBINATIONS – referenced by CASH_CCID, RECEIPT_CLEARING_CCID, EARNED_CCID, ON_ACCOUNT_CCID, UNAPPLIED_CCID, UNEARNED_CCID, UNIDENTIFIED_CCID, BANK_CHARGES_CCID, FACTOR_CCID, and REMITTANCE_CCID.
• AR_RECEIVABLES_TRX_ALL – referenced by EDISC_RECEIVABLES_TRX_ID, UNEDISC_RECEIVABLES_TRX_ID, and BR_STD_RECEIVABLES_TRX_ID.
• AP_PAYMENT_PROGRAMS – referenced by the remittance and factor print/transmission program columns.
• AP_BANK_ACCOUNTS_ALL – referenced by OLD_BANK_ACCOUNT_ID.
• JL_BR_AR_COLLECTION_DOCS_ALL.BANK_ACCOUNT_ID and JL_BR_AR_REC_MET_ACCTS_EXT_ALL.BANK_ACCOUNT_ID – child tables referencing this table.