[Home] [Help] [Dependency Information]
Object Name: | AR_ARCHIVE_HEADER# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ARCHIVE_ID | VARCHAR2 | (15) | Yes | |
TRANSACTION_CLASS | VARCHAR2 | (20) | Yes | |
TRANSACTION_TYPE | VARCHAR2 | (20) | ||
TRANSACTION_ID | NUMBER | Yes | ||
RELATED_TRANSACTION_CLASS | VARCHAR2 | (20) | ||
RELATED_TRANSACTION_TYPE | VARCHAR2 | (20) | ||
RELATED_TRANSACTION_ID | NUMBER | |||
TRANSACTION_NUMBER | VARCHAR2 | (30) | ||
TRANSACTION_DATE | DATE | |||
BATCH_NAME | VARCHAR2 | (50) | ||
BATCH_SOURCE_NAME | VARCHAR2 | (50) | ||
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
AMOUNT | NUMBER | |||
ACCTD_AMOUNT | NUMBER | |||
EXCHANGE_GAIN_LOSS | NUMBER | |||
EARNED_DISCOUNT_TAKEN | NUMBER | |||
UNEARNED_DISCOUNT_TAKEN | NUMBER | |||
ACCTD_EARNED_DISCOUNT_TAKEN | NUMBER | |||
ACCTD_UNEARNED_DISCOUNT_TAKEN | NUMBER | |||
TYPE | VARCHAR2 | (30) | ||
ADJUSTMENT_TYPE | VARCHAR2 | (30) | ||
POST_TO_GL | VARCHAR2 | (1) | ||
ACCOUNTING_AFFECT_FLAG | VARCHAR2 | (1) | ||
REASON_CODE_MEANING | VARCHAR2 | (80) | ||
CASH_RECEIPT_STATUS | VARCHAR2 | (30) | ||
CASH_RECEIPT_HISTORY_STATUS | VARCHAR2 | (30) | ||
BILL_TO_CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
BILL_TO_CUSTOMER_NAME | VARCHAR2 | (50) | ||
BILL_TO_CUSTOMER_LOCATION | VARCHAR2 | (40) | ||
BILL_TO_CUSTOMER_ADDRESS1 | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_ADDRESS2 | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_ADDRESS3 | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_ADDRESS4 | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_CITY | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_STATE | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_COUNTRY | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | ||
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) | ||
REMIT_TO_ADDRESS1 | VARCHAR2 | (240) | ||
REMIT_TO_ADDRESS2 | VARCHAR2 | (240) | ||
REMIT_TO_ADDRESS3 | VARCHAR2 | (240) | ||
REMIT_TO_ADDRESS4 | VARCHAR2 | (240) | ||
REMIT_TO_CITY | VARCHAR2 | (60) | ||
REMIT_TO_STATE | VARCHAR2 | (60) | ||
REMIT_TO_COUNTRY | VARCHAR2 | (60) | ||
REMIT_TO_POSTAL_CODE | VARCHAR2 | (60) | ||
SALESREP_NAME | VARCHAR2 | (240) | ||
TERM_NAME | VARCHAR2 | (15) | ||
TERM_DUE_DATE | DATE | |||
PRINTING_LAST_PRINTED | DATE | |||
PRINTING_OPTION | VARCHAR2 | (20) | ||
PURCHASE_ORDER | VARCHAR2 | (50) | ||
COMMENTS | VARCHAR2 | (240) | ||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
EXCHANGE_RATE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
GL_DATE | DATE | |||
REVERSAL_DATE | DATE | |||
REVERSAL_CATEGORY | VARCHAR2 | (20) | ||
REVERSAL_REASON_CODE_MEANING | VARCHAR2 | (80) | ||
REVERSAL_COMMENTS | VARCHAR2 | (240) | ||
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) | ||
RECEIPT_METHOD_NAME | VARCHAR2 | (30) | ||
WAYBILL_NUMBER | VARCHAR2 | (50) | ||
DOCUMENT_SEQUENCE_NAME | VARCHAR2 | (50) | ||
DOCUMENT_SEQUENCE_VALUE | NUMBER | (15) | ||
START_DATE_COMMITMENT | DATE | |||
END_DATE_COMMITMENT | DATE | |||
INVOICING_RULE_NAME | VARCHAR2 | (30) | ||
CUSTOMER_BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
DEPOSIT_DATE | DATE | |||
FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) | ||
INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
INTERFACE_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
BANK_DEPOSIT_NUMBER | VARCHAR2 | (30) | ||
REFERENCE_TYPE | VARCHAR2 | (30) | ||
REFERENCE_ID | NUMBER | |||
CUSTOMER_RECEIPT_REFERENCE | VARCHAR2 | (30) | ||
BANK_ACCOUNT_NAME | VARCHAR2 | (80) | ||
LEGAL_ENTITY_NAME | VARCHAR2 | (240) |
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#;
|
|
|