DBA Data[Home] [Help] [Dependency Information]


TABLE: AR.AR_ARCHIVE_DETAIL

Object Details
Object Name: AR_ARCHIVE_DETAIL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_ARCHIVE_DETAIL
Subobject Name:
Status: VALID


The AR_ARCHIVE_DETAIL table contains information about transaction lines as well as distribution information. This table contains records about credit memo and receipt applications for a header level archive. Most of this information, however, is archived for header and line as well as header, line, and distribution archives. In addition, this information is only archived for a header, line, and distribution level archive:
{{"bul:1"}}Selected distribution-related columns from the line records.
{{"bul:1"}}One additional record for each account distribution in RA_CUST_TRX_LINE_GL_DIST and AR_MISC_CASH_DISTRIBUTIONS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ARCHIVE_ID VARCHAR2 (15) Yes Identifier of the archive process
TRANSACTION_CLASS VARCHAR2 (20) Yes Transaction class of entity
TRANSACTION_TYPE VARCHAR2 (20)
Transaction type of entity
TRANSACTION_ID NUMBER
Yes Transaction identifier (from source table) of entity
TRANSACTION_LINE_ID NUMBER

Transaction line identifier (from source table) of entity
RELATED_TRANSACTION_CLASS VARCHAR2 (20)
Transaction class of related entity
RELATED_TRANSACTION_TYPE VARCHAR2 (20)
Transaction type of related entity
RELATED_TRANSACTION_ID NUMBER

Transaction identifier (from source table) of related entity
RELATED_TRANSACTION_LINE_ID NUMBER

Transaction line identifier (from source table) of related entity
LINE_NUMBER NUMBER

Line number
DISTRIBUTION_TYPE VARCHAR2 (20)
Distribution type of detail entity. Valid values are: LINE, CM_APP, REC_APP, MCD, ADJ, CRH, REC, REV, TAX, FREIGHT, UNBILL, UNEARN, SUSPENSE
APPLICATION_TYPE VARCHAR2 (30)
Type of application (either CASH or CM)
REASON_CODE_MEANING VARCHAR2 (80)
Line specific reason code meaning
LINE_DESCRIPTION VARCHAR2 (240)
Line description
ITEM_NAME VARCHAR2 (80)
Line item name
QUANTITY NUMBER

Line quantity
UNIT_SELLING_PRICE NUMBER

Selling price per unit
LINE_TYPE VARCHAR2 (20)
Line type. Valid values are: LINE, TAX, FREIGHT
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
AMOUNT NUMBER

Amount
ACCTD_AMOUNT NUMBER

Functional amount
UOM_CODE VARCHAR2 (20)
Unit of measure code
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Code defined by public sector accounting
TAX_RATE NUMBER

Tax rate
TAX_CODE VARCHAR2 (50)
Tax code
TAX_PRECEDENCE NUMBER (15)
Tax precedence for a tax line
ACCOUNT_COMBINATION1 VARCHAR2 (240)
Account reference, concatenated segment values
ACCOUNT_COMBINATION2 VARCHAR2 (240)
Account reference, concatenated segment values
ACCOUNT_COMBINATION3 VARCHAR2 (240)
Account reference, concatenated segment values
ACCOUNT_COMBINATION4 VARCHAR2 (240)
Account reference, concatenated segment values
GL_DATE DATE

General Ledger date
GL_POSTED_DATE DATE

Posted General Ledger date
ACCOUNTING_RULE_NAME VARCHAR2 (30)
Name of accounting rule
RULE_DURATION NUMBER

Duration of accounting rule
RULE_START_DATE DATE

Start date of accounting rule
LAST_PERIOD_TO_CREDIT NUMBER

Last period to credit for unit credit memos against invoices with rules
COMMENTS VARCHAR2 (240)
Line comments
LINE_ADJUSTED NUMBER

Adjusted line amount
FREIGHT_ADJUSTED NUMBER

Adjusted freight amount
TAX_ADJUSTED NUMBER

Adjusted tax amount
RECEIVABLES_CHARGES_ADJUSTED NUMBER

Adjusted receivables charges amount
LINE_APPLIED NUMBER

Line amount applied
FREIGHT_APPLIED NUMBER

Freight amount applied
TAX_APPLIED NUMBER

Tax amount applied
RECEIVABLES_CHARGES_APPLIED NUMBER

Receivables charges amount applied
EARNED_DISCOUNT_TAKEN NUMBER

Amount of earned discount taken towards the application
UNEARNED_DISCOUNT_TAKEN NUMBER

Amount of unearned discount taken towards the application
ACCTD_AMOUNT_APPLIED_FROM NUMBER

Amount of the source converted to base (functional) currency
ACCTD_AMOUNT_APPLIED_TO NUMBER

Amount applied to item converted to base (functional) currency
ACCTD_EARNED_DISC_TAKEN NUMBER

Earned discount equivalent in the functional currency obtained using the exchange rate
ACCTD_UNEARNED_DISC_TAKEN NUMBER

Unearned discount equivalent in the functional currency obtained using the exchange rate
FACTOR_DISCOUNT_AMOUNT NUMBER

Amount of the bank charge and/or factor discount taken by the bank at clearance and/or factoring time
ACCTD_FACTOR_DISCOUNT_AMOUNT NUMBER

FACTOR_DISCOUNT_AMOUNT in the functional currency
INTERFACE_LINE_CONTEXT VARCHAR2 (30)
Interface line context
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
Interface line attribute value
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
Interface line attribute value
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type
EXCHANGE_RATE_DATE DATE

Exchange rate date
EXCHANGE_RATE NUMBER

Exchange rate
DUE_DATE DATE

Due date of the applied/adjusted payment schedule
APPLY_DATE DATE

Application date
MOVEMENT_ID NUMBER

Movement identifier
TAX_VENDOR_RETURN_CODE VARCHAR2 (30)
Warning code returned during supplier calculation of a sales tax rate, used for diagnostics and support. Only applicable if the artaxvdr() returns TAX_SUCCESS
TAX_AUTHORITY_TAX_RATES VARCHAR2 (50)
Tax rates for sales tax
TAX_EXEMPTION_FLAG VARCHAR2 (1)
Tax lines are controlled by the lookup (TAX_CONTROL_FLAG), which allows for Standard tax, Exempt tax and Required tax
TAX_EXEMPTION_ID NUMBER

Tax exemption identifier
TAX_EXEMPTION_TYPE VARCHAR2 (30)
Type of tax exemption
TAX_EXEMPTION_REASON VARCHAR2 (80)
Tax exemption reason
TAX_EXEMPTION_NUMBER VARCHAR2 (80)
Exemption certificate number for item lines with TAX_EXEMPTION_FLAG set to E (exempt)
ITEM_EXCEPTION_RATE VARCHAR2 (80)
Item exception rate
ITEM_EXCEPTION_REASON VARCHAR2 (80)
Item exception reason
ORIGINAL_COLLECTIBILITY_FLAG VARCHAR2 (1)
Indicates original line collectibility
LINE_COLLECTIBLE_FLAG VARCHAR2 (1)
Indicates current line collectibility
MANUAL_OVERRIDE_FLAG VARCHAR2 (1)
Indicates manual adjustment
CONTINGENCY_CODE VARCHAR2 (30)
Revenue Impacting Contingency
EXPIRATION_DATE DATE

Contingency expiration date
EXPIRATION_DAYS NUMBER

Number of days until contingency expires
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 (1)
Overrides AutoAccounting
SHIP_TO_CUSTOMER_NUMBER VARCHAR2 (30)
Number of ship-to customer
SHIP_TO_CUSTOMER_NAME VARCHAR2 (50)
Name of ship-to customer
SHIP_TO_CUSTOMER_LOCATION VARCHAR2 (40)
Location of ship-to customer
SHIP_TO_CUSTOMER_ADDRESS1 VARCHAR2 (240)
Address information for ship-to customer
SHIP_TO_CUSTOMER_ADDRESS2 VARCHAR2 (240)
Address information for ship-to customer
SHIP_TO_CUSTOMER_ADDRESS3 VARCHAR2 (240)
Address information for ship-to customer
SHIP_TO_CUSTOMER_ADDRESS4 VARCHAR2 (240)
Address information for ship-to customer
SHIP_TO_CUSTOMER_CITY VARCHAR2 (60)
Address information for ship-to customer
SHIP_TO_CUSTOMER_STATE VARCHAR2 (60)
Address information for ship-to customer
SHIP_TO_CUSTOMER_COUNTRY VARCHAR2 (60)
Address information for ship-to customer
SHIP_TO_CUSTOMER_POSTAL_CODE VARCHAR2 (60)
Address information for ship-to customer
TAX_LINE_ID VARCHAR2 (60)
Identifies the detail tax line in ZX_LINES
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ARCHIVE_ID
,      TRANSACTION_CLASS
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      TRANSACTION_LINE_ID
,      RELATED_TRANSACTION_CLASS
,      RELATED_TRANSACTION_TYPE
,      RELATED_TRANSACTION_ID
,      RELATED_TRANSACTION_LINE_ID
,      LINE_NUMBER
,      DISTRIBUTION_TYPE
,      APPLICATION_TYPE
,      REASON_CODE_MEANING
,      LINE_DESCRIPTION
,      ITEM_NAME
,      QUANTITY
,      UNIT_SELLING_PRICE
,      LINE_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AMOUNT
,      ACCTD_AMOUNT
,      UOM_CODE
,      USSGL_TRANSACTION_CODE
,      TAX_RATE
,      TAX_CODE
,      TAX_PRECEDENCE
,      ACCOUNT_COMBINATION1
,      ACCOUNT_COMBINATION2
,      ACCOUNT_COMBINATION3
,      ACCOUNT_COMBINATION4
,      GL_DATE
,      GL_POSTED_DATE
,      ACCOUNTING_RULE_NAME
,      RULE_DURATION
,      RULE_START_DATE
,      LAST_PERIOD_TO_CREDIT
,      COMMENTS
,      LINE_ADJUSTED
,      FREIGHT_ADJUSTED
,      TAX_ADJUSTED
,      RECEIVABLES_CHARGES_ADJUSTED
,      LINE_APPLIED
,      FREIGHT_APPLIED
,      TAX_APPLIED
,      RECEIVABLES_CHARGES_APPLIED
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      ACCTD_AMOUNT_APPLIED_FROM
,      ACCTD_AMOUNT_APPLIED_TO
,      ACCTD_EARNED_DISC_TAKEN
,      ACCTD_UNEARNED_DISC_TAKEN
,      FACTOR_DISCOUNT_AMOUNT
,      ACCTD_FACTOR_DISCOUNT_AMOUNT
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE1
,      INTERFACE_LINE_ATTRIBUTE2
,      INTERFACE_LINE_ATTRIBUTE3
,      INTERFACE_LINE_ATTRIBUTE4
,      INTERFACE_LINE_ATTRIBUTE5
,      INTERFACE_LINE_ATTRIBUTE6
,      INTERFACE_LINE_ATTRIBUTE7
,      INTERFACE_LINE_ATTRIBUTE8
,      INTERFACE_LINE_ATTRIBUTE9
,      INTERFACE_LINE_ATTRIBUTE10
,      INTERFACE_LINE_ATTRIBUTE11
,      INTERFACE_LINE_ATTRIBUTE12
,      INTERFACE_LINE_ATTRIBUTE13
,      INTERFACE_LINE_ATTRIBUTE14
,      INTERFACE_LINE_ATTRIBUTE15
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      DUE_DATE
,      APPLY_DATE
,      MOVEMENT_ID
,      TAX_VENDOR_RETURN_CODE
,      TAX_AUTHORITY_TAX_RATES
,      TAX_EXEMPTION_FLAG
,      TAX_EXEMPTION_ID
,      TAX_EXEMPTION_TYPE
,      TAX_EXEMPTION_REASON
,      TAX_EXEMPTION_NUMBER
,      ITEM_EXCEPTION_RATE
,      ITEM_EXCEPTION_REASON
,      ORIGINAL_COLLECTIBILITY_FLAG
,      LINE_COLLECTIBLE_FLAG
,      MANUAL_OVERRIDE_FLAG
,      CONTINGENCY_CODE
,      EXPIRATION_DATE
,      EXPIRATION_DAYS
,      OVERRIDE_AUTO_ACCOUNTING_FLAG
,      SHIP_TO_CUSTOMER_NUMBER
,      SHIP_TO_CUSTOMER_NAME
,      SHIP_TO_CUSTOMER_LOCATION
,      SHIP_TO_CUSTOMER_ADDRESS1
,      SHIP_TO_CUSTOMER_ADDRESS2
,      SHIP_TO_CUSTOMER_ADDRESS3
,      SHIP_TO_CUSTOMER_ADDRESS4
,      SHIP_TO_CUSTOMER_CITY
,      SHIP_TO_CUSTOMER_STATE
,      SHIP_TO_CUSTOMER_COUNTRY
,      SHIP_TO_CUSTOMER_POSTAL_CODE
,      TAX_LINE_ID
FROM AR.AR_ARCHIVE_DETAIL;

Dependencies

[top of page]

AR.AR_ARCHIVE_DETAIL does not reference any database object

AR.AR_ARCHIVE_DETAIL is referenced by following:

SchemaAPPS
SynonymAR_ARCHIVE_DETAIL