AR_CRH_APP_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
ENTITY_ID | NUMBER | 18 | Oracle internal use only | |
RECEIVABLE_APPLICATION_ID | NUMBER | 18 | Oracle internal use only | |
CASH_RECEIPT_HISTORY_ID | NUMBER | 18 | Oracle internal use only | |
CASH_RECEIPT_HISTORY_STATUS | VARCHAR2 | 30 | Oracle internal use only | |
LINE_ID | NUMBER | 18 | Oracle internal use only | |
AMOUNT | NUMBER | Oracle internal use only | ||
ACCTD_AMOUNT | NUMBER | Oracle internal use only | ||
FROM_AMOUNT | NUMBER | Oracle internal use only | ||
FROM_ACCTD_AMOUNT | NUMBER | Oracle internal use only | ||
THIRD_PARTY_ID | NUMBER | 18 | Oracle internal use only | |
THIRD_PARTY_SITE_ID | NUMBER | 18 | Oracle internal use only | |
THIRD_PARTY_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
FROM_CURRENCY_CODE | VARCHAR2 | 30 | Oracle internal use only | |
FROM_EXCHANGE_RATE | NUMBER | Oracle internal use only | ||
FROM_EXCHANGE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
FROM_EXCHANGE_DATE | DATE | Oracle internal use only | ||
TO_CURRENCY_CODE | VARCHAR2 | 30 | Oracle internal use only | |
TO_EXCHANGE_RATE | NUMBER | Oracle internal use only | ||
TO_EXCHANGE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
TO_EXCHANGE_DATE | DATE | Oracle internal use only | ||
REF_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | 18 | Oracle internal use only | |
CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only | |
REF_CODE_COMBINATION_ID | NUMBER | 18 | Oracle internal use only | |
REF_DIST_CCID | NUMBER | 18 | Oracle internal use only | |
ACTIVITY_BUCKET | VARCHAR2 | 30 | Oracle internal use only | |
SOURCE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
SOURCE_TABLE | VARCHAR2 | 30 | Oracle internal use only | |
RA_POST_INDICATOR | VARCHAR2 | 30 | Oracle internal use only | |
CRH_POST_INDICATOR | VARCHAR2 | 30 | Oracle internal use only | |
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only | |
INVENTORY_ITEM_ID | NUMBER | 18 | Oracle internal use only | |
SALES_TAX_ID | NUMBER | 18 | Oracle internal use only | |
TAX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
BILL_TO_CUSTOMER_ID | NUMBER | 18 | Oracle internal use only | |
BILL_TO_SITE_USE_ID | NUMBER | 18 | Oracle internal use only | |
SOLD_TO_CUSTOMER_ID | NUMBER | 18 | Oracle internal use only | |
SOLD_TO_SITE_USE_ID | NUMBER | 18 | Oracle internal use only | |
SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Oracle internal use only | |
SHIP_TO_SITE_USE_ID | NUMBER | 18 | Oracle internal use only | |
ADDITIONAL_NUMBER_ID1 | NUMBER | Oracle internal use only | ||
ADDITIONAL_NUMBER_ID2 | NUMBER | Oracle internal use only | ||
ADDITIONAL_NUMBER_ID3 | NUMBER | Oracle internal use only | ||
ADDITIONAL_NUMBER_ID4 | NUMBER | Oracle internal use only | ||
ADDITIONAL_NUMBER_ID5 | NUMBER | Oracle internal use only | ||
ADDITIONAL_CHAR_ID1 | VARCHAR2 | 200 | Oracle internal use only | |
ADDITIONAL_CHAR_ID2 | VARCHAR2 | 200 | Oracle internal use only | |
ADDITIONAL_CHAR_ID3 | VARCHAR2 | 200 | Oracle internal use only | |
ADDITIONAL_CHAR_ID4 | VARCHAR2 | 200 | Oracle internal use only | |
ADDITIONAL_CHAR_ID5 | VARCHAR2 | 200 | Oracle internal use only | |
ACCTD_AMOUNT_APPLIED | NUMBER | Oracle internal use only | ||
AMOUNT_APPLIED | NUMBER | Oracle internal use only | ||
EVENT_ID | NUMBER | 18 | Oracle internal use only | |
MFAR_UPG_TRX | VARCHAR2 | 1 | Oracle internal use only | |
SIGNED_RECEIPT_AMOUNT | NUMBER | Oracle internal use only |
Indexes
Index | Uniqueness | Columns |
---|---|---|
AR_CRH_APP_U1 | Unique | LINE_ID |