[Home] [Help] [Dependency Information]
Object Name: | AR_AUTOREM_INTERIM# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
CASH_RECEIPT_ID | NUMBER | (15) | ||
CREATION_STATUS | VARCHAR2 | (30) | ||
ORG_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) | ||
PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) | ||
MERCHANT_REF | VARCHAR2 | (80) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PAY_FROM_CUSTOMER | NUMBER | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | (15) | ||
CASH_RECEIPT_HISTORY_ID | NUMBER | (15) | ||
EXCHANGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
AMOUNT1 | NUMBER | |||
ACCTD_AMOUNT | NUMBER | |||
FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
REMITTANCE_CCID | NUMBER | (15) | ||
BANK_CHARGES_CCID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
CRH_GL_DATE | DATE | |||
CRH_TRX_DATE | DATE | |||
PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | (80) | ||
APPROVAL_CODE | VARCHAR2 | (80) | ||
UNIQUE_REF | VARCHAR2 | (32) | ||
CUSTOMER_BANK_ACCOUNT_ID | NUMBER | (15) | ||
PAYMENT_TRXN_EXTENSION_ID | NUMBER | (15) | ||
AMOUNT2 | NUMBER | |||
BATCH_ID | NUMBER | |||
CURRENT_WORKER | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_NUMBER
, CASH_RECEIPT_ID
, CREATION_STATUS
, ORG_ID
, PARTY_ID
, PAYMENT_CHANNEL_CODE
, MERCHANT_REF
, CURRENCY_CODE
, PAY_FROM_CUSTOMER
, CUSTOMER_SITE_USE_ID
, CASH_RECEIPT_HISTORY_ID
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_TYPE
, AMOUNT1
, ACCTD_AMOUNT
, FACTOR_DISCOUNT_AMOUNT
, REMITTANCE_CCID
, BANK_CHARGES_CCID
, CODE_COMBINATION_ID
, CRH_GL_DATE
, CRH_TRX_DATE
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, UNIQUE_REF
, CUSTOMER_BANK_ACCOUNT_ID
, PAYMENT_TRXN_EXTENSION_ID
, AMOUNT2
, BATCH_ID
, CURRENT_WORKER
FROM AR.AR_AUTOREM_INTERIM#;
|
|
|