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

TABLE: AR.AR_ARCHIVE_HEADER

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


The AR_ARCHIVE_HEADER table stores header-level information for transactions that are selected by the Archive and Purge program. Transactions can include invoices, receipts, credit or debit memos, adjustments, guarantees, deposits, chargebacks, and on-account credits. This header-level information is archived for all Archive-Levels and is used for the Archive Detail report. This table stores three types of records:
{{"bul:1"}}TRX - Transactions
{{"bul:1"}}CR - Receipts
{{"bul:1"}}ADJ - Adjustments
{{"bodytext"}}If one of these types is not referenced, the column is null for records of that type.


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
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
TRANSACTION_NUMBER VARCHAR2 (30)
Transaction number from transaction source table
TRANSACTION_DATE DATE

Transaction date from transaction source table
BATCH_NAME VARCHAR2 (50)
Batch name of transaction source
BATCH_SOURCE_NAME VARCHAR2 (50)
Batch source of transaction
SET_OF_BOOKS_NAME VARCHAR2 (30)
Set of books name
AMOUNT NUMBER

Transaction amount
ACCTD_AMOUNT NUMBER

Transaction amount in functional currency
EXCHANGE_GAIN_LOSS NUMBER

Exchange rate gain/loss amount
EARNED_DISCOUNT_TAKEN NUMBER

Amount of earned discount taken
UNEARNED_DISCOUNT_TAKEN NUMBER

Amount of unearned discount taken
ACCTD_EARNED_DISCOUNT_TAKEN NUMBER

Amount of earned discount taken in functional currency
ACCTD_UNEARNED_DISCOUNT_TAKEN NUMBER

Amount of unearned discount taken in functional currency
TYPE VARCHAR2 (30)
Type of cash receipt or adjustment
ADJUSTMENT_TYPE VARCHAR2 (30)
Adjustment type
POST_TO_GL VARCHAR2 (1)
Y or N flag if transactions should be posted to the General Ledger
ACCOUNTING_AFFECT_FLAG VARCHAR2 (1)
Y or N flag if transaction has open receivable balances
REASON_CODE_MEANING VARCHAR2 (80)
Invoicing reason
CASH_RECEIPT_STATUS VARCHAR2 (30)
Status of cash receipt
CASH_RECEIPT_HISTORY_STATUS VARCHAR2 (30)
Status of cash receipt history
BILL_TO_CUSTOMER_NUMBER VARCHAR2 (30)
Customer number for bill-to customer
BILL_TO_CUSTOMER_NAME VARCHAR2 (50)
Name for bill-to customer
BILL_TO_CUSTOMER_LOCATION VARCHAR2 (40)
Location for bill-to customer
BILL_TO_CUSTOMER_ADDRESS1 VARCHAR2 (240)
Address information for bill-to customer
BILL_TO_CUSTOMER_ADDRESS2 VARCHAR2 (240)
Address information for bill-to customer
BILL_TO_CUSTOMER_ADDRESS3 VARCHAR2 (240)
Address information for bill-to customer
BILL_TO_CUSTOMER_ADDRESS4 VARCHAR2 (240)
Address information for bill-to customer
BILL_TO_CUSTOMER_CITY VARCHAR2 (60)
Address information for bill-to customer
BILL_TO_CUSTOMER_STATE VARCHAR2 (60)
Address information for bill-to customer
BILL_TO_CUSTOMER_COUNTRY VARCHAR2 (60)
Address information for bill-to customer
BILL_TO_CUSTOMER_POSTAL_CODE VARCHAR2 (60)
Address information for bill-to customer
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
REMIT_TO_ADDRESS1 VARCHAR2 (240)
Remit-to address information
REMIT_TO_ADDRESS2 VARCHAR2 (240)
Remit-to address information
REMIT_TO_ADDRESS3 VARCHAR2 (240)
Remit-to address information
REMIT_TO_ADDRESS4 VARCHAR2 (240)
Remit-to address information
REMIT_TO_CITY VARCHAR2 (60)
Remit-to address information
REMIT_TO_STATE VARCHAR2 (60)
Remit-to address information
REMIT_TO_COUNTRY VARCHAR2 (60)
Remit-to address information
REMIT_TO_POSTAL_CODE VARCHAR2 (60)
Remit-to address information
SALESREP_NAME VARCHAR2 (240)
Salesrep name
TERM_NAME VARCHAR2 (15)
Payment terms name
TERM_DUE_DATE DATE

Due date of the first payment
PRINTING_LAST_PRINTED DATE

Last day any installment was printed
PRINTING_OPTION VARCHAR2 (20)
Lookup code for INVOICE_PRINT_OPTIONS
PURCHASE_ORDER VARCHAR2 (50)
Purchase order number
COMMENTS VARCHAR2 (240)
Transaction comments
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type
EXCHANGE_RATE_DATE DATE

Exchange rate date
EXCHANGE_RATE NUMBER

Exchange rate
CURRENCY_CODE VARCHAR2 (15)
Currency code
GL_DATE DATE

General Ledger date
REVERSAL_DATE DATE

Date that the cash receipt was reversed
REVERSAL_CATEGORY VARCHAR2 (20)
Identifies the category of the cash receipt reversal
REVERSAL_REASON_CODE_MEANING VARCHAR2 (80)
Indicates reason for the cash receipt reversal
REVERSAL_COMMENTS VARCHAR2 (240)
Comments on reversal
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
RECEIPT_METHOD_NAME VARCHAR2 (30)
Receipt method name
WAYBILL_NUMBER VARCHAR2 (50)
Waybill number
DOCUMENT_SEQUENCE_NAME VARCHAR2 (50)
Document sequence name
DOCUMENT_SEQUENCE_VALUE NUMBER (15)
Document number
START_DATE_COMMITMENT DATE

Commitment start date
END_DATE_COMMITMENT DATE

Commitment end date
INVOICING_RULE_NAME VARCHAR2 (30)
Name of invoicing rule
CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (80)
Customer bank account name
DEPOSIT_DATE DATE

Deposit date
FACTOR_DISCOUNT_AMOUNT NUMBER

Amount of the bank charge and/or factor discount taken by the bank at clearance and/or factoring time
INTERFACE_HEADER_CONTEXT VARCHAR2 (30)
Interface header context
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE2 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE3 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE4 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE5 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE6 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE7 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE8 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE9 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE10 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE11 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE12 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE13 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE14 VARCHAR2 (150)
Interface header attribute value
INTERFACE_HEADER_ATTRIBUTE15 VARCHAR2 (150)
Interface header attribute value
BANK_DEPOSIT_NUMBER VARCHAR2 (30)
Bank deposit number
REFERENCE_TYPE VARCHAR2 (30)
Cash receipt reference type
REFERENCE_ID NUMBER

Cash receipt reference identifier
CUSTOMER_RECEIPT_REFERENCE VARCHAR2 (30)
Customer receipt reference
BANK_ACCOUNT_NAME VARCHAR2 (80)
Remittance bank account name
LEGAL_ENTITY_NAME VARCHAR2 (240)
Name of legal entity
Query Text

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


SELECT ARCHIVE_ID
,      TRANSACTION_CLASS
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      RELATED_TRANSACTION_CLASS
,      RELATED_TRANSACTION_TYPE
,      RELATED_TRANSACTION_ID
,      TRANSACTION_NUMBER
,      TRANSACTION_DATE
,      BATCH_NAME
,      BATCH_SOURCE_NAME
,      SET_OF_BOOKS_NAME
,      AMOUNT
,      ACCTD_AMOUNT
,      EXCHANGE_GAIN_LOSS
,      EARNED_DISCOUNT_TAKEN
,      UNEARNED_DISCOUNT_TAKEN
,      ACCTD_EARNED_DISCOUNT_TAKEN
,      ACCTD_UNEARNED_DISCOUNT_TAKEN
,      TYPE
,      ADJUSTMENT_TYPE
,      POST_TO_GL
,      ACCOUNTING_AFFECT_FLAG
,      REASON_CODE_MEANING
,      CASH_RECEIPT_STATUS
,      CASH_RECEIPT_HISTORY_STATUS
,      BILL_TO_CUSTOMER_NUMBER
,      BILL_TO_CUSTOMER_NAME
,      BILL_TO_CUSTOMER_LOCATION
,      BILL_TO_CUSTOMER_ADDRESS1
,      BILL_TO_CUSTOMER_ADDRESS2
,      BILL_TO_CUSTOMER_ADDRESS3
,      BILL_TO_CUSTOMER_ADDRESS4
,      BILL_TO_CUSTOMER_CITY
,      BILL_TO_CUSTOMER_STATE
,      BILL_TO_CUSTOMER_COUNTRY
,      BILL_TO_CUSTOMER_POSTAL_CODE
,      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
,      REMIT_TO_ADDRESS1
,      REMIT_TO_ADDRESS2
,      REMIT_TO_ADDRESS3
,      REMIT_TO_ADDRESS4
,      REMIT_TO_CITY
,      REMIT_TO_STATE
,      REMIT_TO_COUNTRY
,      REMIT_TO_POSTAL_CODE
,      SALESREP_NAME
,      TERM_NAME
,      TERM_DUE_DATE
,      PRINTING_LAST_PRINTED
,      PRINTING_OPTION
,      PURCHASE_ORDER
,      COMMENTS
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      CURRENCY_CODE
,      GL_DATE
,      REVERSAL_DATE
,      REVERSAL_CATEGORY
,      REVERSAL_REASON_CODE_MEANING
,      REVERSAL_COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RECEIPT_METHOD_NAME
,      WAYBILL_NUMBER
,      DOCUMENT_SEQUENCE_NAME
,      DOCUMENT_SEQUENCE_VALUE
,      START_DATE_COMMITMENT
,      END_DATE_COMMITMENT
,      INVOICING_RULE_NAME
,      CUSTOMER_BANK_ACCOUNT_NAME
,      DEPOSIT_DATE
,      FACTOR_DISCOUNT_AMOUNT
,      INTERFACE_HEADER_CONTEXT
,      INTERFACE_HEADER_ATTRIBUTE1
,      INTERFACE_HEADER_ATTRIBUTE2
,      INTERFACE_HEADER_ATTRIBUTE3
,      INTERFACE_HEADER_ATTRIBUTE4
,      INTERFACE_HEADER_ATTRIBUTE5
,      INTERFACE_HEADER_ATTRIBUTE6
,      INTERFACE_HEADER_ATTRIBUTE7
,      INTERFACE_HEADER_ATTRIBUTE8
,      INTERFACE_HEADER_ATTRIBUTE9
,      INTERFACE_HEADER_ATTRIBUTE10
,      INTERFACE_HEADER_ATTRIBUTE11
,      INTERFACE_HEADER_ATTRIBUTE12
,      INTERFACE_HEADER_ATTRIBUTE13
,      INTERFACE_HEADER_ATTRIBUTE14
,      INTERFACE_HEADER_ATTRIBUTE15
,      BANK_DEPOSIT_NUMBER
,      REFERENCE_TYPE
,      REFERENCE_ID
,      CUSTOMER_RECEIPT_REFERENCE
,      BANK_ACCOUNT_NAME
,      LEGAL_ENTITY_NAME
FROM AR.AR_ARCHIVE_HEADER;

Dependencies

[top of page]

AR.AR_ARCHIVE_HEADER does not reference any database object

AR.AR_ARCHIVE_HEADER is referenced by following:

SchemaAR
ViewAR_ARCHIVE_HEADER#