VIEW: AR.AR_ARCHIVE_HEADER#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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