1. Tables and Views for Financials
  2. AR_EXTENSION_ATTRIBUTES

AR_EXTENSION_ATTRIBUTES

This table contains the extension attribute name value pairs that a user can add to Accounts Receivable documents like invoices, credit memos and receipts. The data in this table is loaded using the arp_util.insert_ar_extension_attributes API. For example, the extension attributes loaded for an invoice are processed by the ESS process that generates XML invoices. The attributes are included in the UserArea extension of XML payload.

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

AR_EXTENSION_ATTRIBUTES_PK

EXTN_ENTITY_ID, ENTITY_TYPE_CODE, PROCESS_TYPE_CODE, ATTRIBUTE_NAME

Columns

Name Datatype Length Precision Not-null Comments
EXTN_ENTITY_ID NUMBER 18 Yes Primary key identifer for the extension entity.
ASSOCIATED_EXTN_ENTITY_ID1 NUMBER 18 Primary key 1 identifier for the parent or linked entity
ASSOCIATED_EXTN_ENTITY_ID2 NUMBER 18 Primary key 2 identifier for the parent or linked entity
ENTITY_TYPE_CODE VARCHAR2 30 Yes The document type or sub-type to which the extension attribute belongs. For example, when extension attributes are loaded for an invoice and these attributes need to be included in the XML that is sent to customer, the valid values are INVHEADER, INVLINE, and INVTAX.
PROCESS_TYPE_CODE VARCHAR2 30 Yes Process that picks up the extension attributes. For example, when extension attributes are to be included in the XML payload of an outbound invoice, the valid value is XML.
ATTRIBUTE_NAME VARCHAR2 100 Yes Name of the extension attribute.
ATTRIBUTE_VALUE VARCHAR2 1000 Value of the extension attribute.
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.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
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.

Indexes

Index Uniqueness Tablespace Columns
AR_EXTENSION_ATTRIBUTES_U1 Unique Default EXTN_ENTITY_ID, ENTITY_TYPE_CODE, PROCESS_TYPE_CODE, ATTRIBUTE_NAME