[Home] [Help] [Dependency Information]
Object Name: | AR_REMIT_GT |
---|---|
Object Type: | TABLE |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
AR.AR_REMIT_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CASH_RECEIPT_ID | NUMBER | |||
PAYMENT_TYPE_CODE | VARCHAR2 | (30) | ||
MERCHANT_REF | VARCHAR2 | (80) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PAY_FROM_CUSTOMER | VARCHAR2 | (15) | ||
CUSTOMER_SITE_USE_ID | NUMBER | |||
PRV_CASH_RECEIPT_HIST_ID | NUMBER | |||
EXCHANGE_DATE | DATE | |||
EXCHANGE_RATE | NUMBER | |||
EXCHANGE_TYPE | VARCHAR2 | (30) | ||
CR_AMOUNT | NUMBER | |||
CR_ACCTD_AMOUNT | NUMBER | |||
CR_FACTOR_DISCOUNT_AMOUNT | NUMBER | |||
REMMITANCE_CCID | NUMBER | |||
BANK_CHARGES_CCID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | |||
CASH_RECEIPT_HISTORY_ID | NUMBER | |||
CRH_GL_DATE | DATE | |||
CRH_TRX_DATE | DATE | |||
PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | (80) | ||
APPROVAL_CODE | VARCHAR2 | (80) | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | ||
UNIQUE_REF | VARCHAR2 | (32) | ||
CUSTOMER_BANK_ACCOUNT_ID | NUMBER | |||
PAYMENT_TRXN_EXTENSION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CASH_RECEIPT_ID
, PAYMENT_TYPE_CODE
, MERCHANT_REF
, CURRENCY_CODE
, PAY_FROM_CUSTOMER
, CUSTOMER_SITE_USE_ID
, PRV_CASH_RECEIPT_HIST_ID
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_TYPE
, CR_AMOUNT
, CR_ACCTD_AMOUNT
, CR_FACTOR_DISCOUNT_AMOUNT
, REMMITANCE_CCID
, BANK_CHARGES_CCID
, CODE_COMBINATION_ID
, CASH_RECEIPT_HISTORY_ID
, CRH_GL_DATE
, CRH_TRX_DATE
, PAYMENT_SERVER_ORDER_NUM
, APPROVAL_CODE
, RECEIPT_NUMBER
, UNIQUE_REF
, CUSTOMER_BANK_ACCOUNT_ID
, PAYMENT_TRXN_EXTENSION_ID
FROM AR.AR_REMIT_GT;
AR.AR_REMIT_GT does not reference any database object
AR.AR_REMIT_GT is referenced by following:
|
|
|