1. Tables and Views for Financials
  2. AR_MEMO_LINES_ALL_B

AR_MEMO_LINES_ALL_B

The AR_MEMO_LINES_ALL_B table stores information about standard memo lines for debit memos, on-account credits, debit memo reversals, chargebacks, and invoices. If AutoAccounting is based on standard line items, Oracle Receivables uses this table to obtain the revenue account. . This table also stores the tax code, unit standard price, unit of measure, and standard invoicing and accounting rules for each standard memo line. . The primary key for this table is MEMO_LINE_ID.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

AR_MEMO_LINES_ALL_B_PK

MEMO_LINE_SEQ_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
MEMO_LINE_ID NUMBER 18 Yes Memo line identifier.
NAME VARCHAR2 50 Memo line name.
SET_ID NUMBER 18 Yes Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
LINE_TYPE VARCHAR2 30 Yes Standard memo line type
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
DESCRIPTION VARCHAR2 80 Memo line description.
TAX_CODE VARCHAR2 50 Standard memo line tax code
UOM_CODE VARCHAR2 3 Standard memo line unit of measure
UNIT_STD_PRICE NUMBER Standard memo line unit standard price
INVOICING_RULE_ID NUMBER 18 Standard memo line invoicing rule
ACCOUNTING_RULE_ID NUMBER 18 Standard memo line accounting rule
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Memo Lines (AR_MEMO_LINES)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
TAX_PRODUCT_CATEGORY VARCHAR2 240 Classifies non-inventory products or services for tax purposes
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
MEMO_LINE_SEQ_ID NUMBER 18 Yes Memo line sequence identifier.
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table Foreign Table Foreign Key Column
AR_MEMO_LINES_ALL_B ra_rules INVOICING_RULE_ID
AR_MEMO_LINES_ALL_B ra_rules ACCOUNTING_RULE_ID
hes_fee_attributes_b ar_memo_lines_all_b MEMO_LINE_SEQ_ID
hes_transaction_post_all ar_memo_lines_all_b DISCOUNT_MEMO_LINE_SEQ_ID
hes_transaction_post_all ar_memo_lines_all_b MEMO_LINE_SEQ_ID
vrm_fmv_templ_assignments ar_memo_lines_all_b FROM_PERIOD_ID
hes_credits_all_b ar_memo_lines_all_b MEMO_LINE_SEQ_ID
hes_discount_all_b ar_memo_lines_all_b MEMO_LINE_SEQ_ID
hes_credit_periods_b ar_memo_lines_all_b MEMO_LINE_SEQ_ID

Indexes

Index Uniqueness Tablespace Columns
AR_MEMO_LINES_ALL_B_U1 Unique Default MEMO_LINE_ID, SET_ID, ORA_SEED_SET1
AR_MEMO_LINES_ALL_B_U11 Unique Default MEMO_LINE_ID, SET_ID, ORA_SEED_SET2
AR_MEMO_LINES_ALL_B_U2 Unique Default MEMO_LINE_SEQ_ID, ORA_SEED_SET1
AR_MEMO_LINES_ALL_B_U21 Unique Default MEMO_LINE_SEQ_ID, ORA_SEED_SET2