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 |