VIEW: AR.AR_ARCHIVE_DETAIL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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