Skip to content

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

VIEW: AR.AR_ARCHIVE_DETAIL#

Object Details
Object Name: AR_ARCHIVE_DETAIL#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ARCHIVE_ID VARCHAR2 (15) Yes
TRANSACTION_CLASS VARCHAR2 (20) Yes
TRANSACTION_TYPE VARCHAR2 (20)
TRANSACTION_ID NUMBER
Yes
TRANSACTION_LINE_ID NUMBER

LINE_NUMBER NUMBER

DISTRIBUTION_TYPE VARCHAR2 (20)
APPLICATION_TYPE VARCHAR2 (30)
REASON_CODE_MEANING VARCHAR2 (80)
LINE_DESCRIPTION VARCHAR2 (240)
ITEM_NAME VARCHAR2 (80)
QUANTITY NUMBER

UNIT_SELLING_PRICE NUMBER

LINE_TYPE VARCHAR2 (20)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
AMOUNT NUMBER

ACCTD_AMOUNT NUMBER

UOM_CODE VARCHAR2 (20)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
TAX_RATE NUMBER

TAX_CODE VARCHAR2 (50)
TAX_PRECEDENCE NUMBER (15)
ACCOUNT_COMBINATION1 VARCHAR2 (240)
ACCOUNT_COMBINATION2 VARCHAR2 (240)
ACCOUNT_COMBINATION3 VARCHAR2 (240)
ACCOUNT_COMBINATION4 VARCHAR2 (240)
GL_DATE DATE

GL_POSTED_DATE DATE

ACCOUNTING_RULE_NAME VARCHAR2 (30)
RULE_DURATION NUMBER

RULE_START_DATE DATE

LAST_PERIOD_TO_CREDIT NUMBER

COMMENTS VARCHAR2 (240)
LINE_ADJUSTED NUMBER

FREIGHT_ADJUSTED NUMBER

TAX_ADJUSTED NUMBER

RECEIVABLES_CHARGES_ADJUSTED NUMBER

LINE_APPLIED NUMBER

FREIGHT_APPLIED NUMBER

TAX_APPLIED NUMBER

RECEIVABLES_CHARGES_APPLIED NUMBER

EARNED_DISCOUNT_TAKEN NUMBER

UNEARNED_DISCOUNT_TAKEN NUMBER

ACCTD_AMOUNT_APPLIED_FROM NUMBER

ACCTD_AMOUNT_APPLIED_TO NUMBER

ACCTD_EARNED_DISC_TAKEN NUMBER

ACCTD_UNEARNED_DISC_TAKEN NUMBER

FACTOR_DISCOUNT_AMOUNT NUMBER

ACCTD_FACTOR_DISCOUNT_AMOUNT NUMBER

INTERFACE_LINE_CONTEXT VARCHAR2 (30)
INTERFACE_LINE_ATTRIBUTE1 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE2 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE3 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE4 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE5 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE6 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE7 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE8 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE9 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE10 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE11 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE12 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE13 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE14 VARCHAR2 (150)
INTERFACE_LINE_ATTRIBUTE15 VARCHAR2 (150)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_RATE_DATE DATE

EXCHANGE_RATE NUMBER

DUE_DATE DATE

APPLY_DATE DATE

MOVEMENT_ID NUMBER

TAX_VENDOR_RETURN_CODE VARCHAR2 (30)
TAX_AUTHORITY_TAX_RATES VARCHAR2 (50)
TAX_EXEMPTION_FLAG VARCHAR2 (1)
TAX_EXEMPTION_ID NUMBER

TAX_EXEMPTION_TYPE VARCHAR2 (30)
TAX_EXEMPTION_REASON VARCHAR2 (80)
TAX_EXEMPTION_NUMBER VARCHAR2 (80)
ITEM_EXCEPTION_RATE VARCHAR2 (80)
ITEM_EXCEPTION_REASON VARCHAR2 (80)
ORIGINAL_COLLECTIBILITY_FLAG VARCHAR2 (1)
LINE_COLLECTIBLE_FLAG VARCHAR2 (1)
MANUAL_OVERRIDE_FLAG VARCHAR2 (1)
CONTINGENCY_CODE VARCHAR2 (30)
EXPIRATION_DATE DATE

EXPIRATION_DAYS NUMBER

OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 (1)
SHIP_TO_CUSTOMER_NUMBER VARCHAR2 (30)
SHIP_TO_CUSTOMER_NAME VARCHAR2 (50)
SHIP_TO_CUSTOMER_LOCATION VARCHAR2 (40)
SHIP_TO_CUSTOMER_ADDRESS1 VARCHAR2 (240)
SHIP_TO_CUSTOMER_ADDRESS2 VARCHAR2 (240)
SHIP_TO_CUSTOMER_ADDRESS3 VARCHAR2 (240)
SHIP_TO_CUSTOMER_ADDRESS4 VARCHAR2 (240)
SHIP_TO_CUSTOMER_CITY VARCHAR2 (60)
SHIP_TO_CUSTOMER_STATE VARCHAR2 (60)
SHIP_TO_CUSTOMER_COUNTRY VARCHAR2 (60)
SHIP_TO_CUSTOMER_POSTAL_CODE VARCHAR2 (60)
TAX_LINE_ID VARCHAR2 (60)
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# references the following:

SchemaAR
TableAR_ARCHIVE_DETAIL
AR.AR_ARCHIVE_DETAIL# is referenced by following:

SchemaAPPS
SynonymAR_ARCHIVE_DETAIL