Results for “ar_memo_lines_all_b_u1”

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

Overview

AR.AR_MEMO_LINES_ALL_B is a Receivables (AR) transaction data table that stores the definition of standard memo lines used across debit memos, on-account credits, debit memo reversals, chargebacks, and invoices. When AutoAccounting derives revenue accounts from standard line items, Oracle Receivables reads this table to obtain the appropriate revenue account. For each standard memo line, the table holds the tax code, unit standard price, unit of measure, and the standard invoicing and accounting rules that govern how the resulting transaction line is billed and posted. The table resides in the APPS_TS_TX_DATA tablespace and is registered in FND Design Data as AR.AR_MEMO_LINES_ALL_B. Its primary key is MEMO_LINE_ID.

From a modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning within a Data Vault style heuristic. The table carries descriptive attributes (tax, pricing, rules, and dates) around an identifier that is referenced by more transactional tables, rather than acting as a central hub or a pure relationship link. This is a modeling suggestion only, not a documented design designation.

Key Information Stored

MEMO_LINE_ID is the surrogate primary key and unique identifier for each standard memo line. AR_MEMO_LINES_ALL_B_U1 is the documented unique index, defined over MEMO_LINE_ID, ORG_ID, and ZD_EDITION_NAME; the multi-column composition of this index makes it a business-key candidate and reflects how Oracle separates lines per operating unit and edition. ORG_ID identifies the organization, and SET_OF_BOOKS_ID identifies the set of books, which is a foreign key to GL_SETS_OF_BOOKS_11I. LINE_TYPE holds the standard memo line type.

Pricing and tax attributes include UNIT_STD_PRICE for the unit standard price, UOM_CODE for the unit of measure, and TAX_CODE for the applicable standard memo line tax code. Accounting and billing behavior is driven by GL_ID_REV, the code combination identifier for the revenue account; INVOICING_RULE_ID and ACCOUNTING_RULE_ID, both foreign keys to RA_RULES, which define the standard invoicing and accounting rules. Validity of each standard line is bounded by START_DATE and END_DATE. Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit tracking, while ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15, together with the GLOBAL_ATTRIBUTE flexfields and TAX_PRODUCT_CATEGORY, support descriptive and localization extensions. ZD_EDITION_NAME supports edition-based redefinition in the 12.2.x code line.

Common Use Cases and Queries

Typical uses include validating standard memo line setup for a given operating unit, tracing which revenue account a transaction line will inherit through AutoAccounting, and reconciling memo line references on invoice, chargeback, and on-account credit lines.

• Retrieving active standard lines for an organization: SELECT memo_line_id, line_type, tax_code, uom_code, unit_std_price FROM ar.ar_memo_lines_all_b WHERE org_id = :org_id AND sysdate BETWEEN start_date AND NVL(end_date, sysdate + 1);
• Joining to RA_CUSTOMER_TRX_LINES_ALL to identify which standard line backs a transaction line: SELECT l.trx_line_id, l.memo_line_id, m.line_type, m.tax_code FROM ra_customer_trx_lines_all l JOIN ar.ar_memo_lines_all_b m ON l.memo_line_id = m.memo_line_id;
• Resolving invoicing and accounting rules through RA_RULES: SELECT m.memo_line_id, m.invoicing_rule_id, ir.name, m.accounting_rule_id, ar2.name FROM ar.ar_memo_lines_all_b m LEFT JOIN ra_rules ir ON m.invoicing_rule_id = ir.rule_id LEFT JOIN ra_rules ar2 ON m.accounting_rule_id = ar2.rule_id;
• Confirming the set of books context via GL_SETS_OF_BOOKS_11I for reporting or migration extract scripts.

Related Objects

The most significant dependent object is RA_CUSTOMER_TRX_LINES_ALL, whose MEMO_LINE_ID column references this table to associate an actual transaction line with a standard memo line. RA_INTERFACE_LINES_ALL also references MEMO_LINE_ID and is central to AutoInvoice processing. Several interface and temporary tables carry the same reference, including AR_TRX_LINES_GT, AR_TRX_LINES_TMP_GT, AR_RDR_PARAMETERS_GT, and JG_ZZ_AR_TMP_ACCOUNT. FUN_TRX_TYPE_AR_MAPS and PON_EMD_FIN_PARAMETERS_ALL also reference MEMO_LINE_ID. On the lookup side, the table depends on GL_SETS_OF_BOOKS_11I via SET_OF_BOOKS_ID and on RA_RULES via INVOICING_RULE_ID and ACCOUNTING_RULE_ID.