RA_CUSTOMER_TRX_LINES_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 | Comments |
|---|---|---|---|
| ACCTD_AMOUNT_DUE_ORIGINAL | NUMBER | Oracle internal use only | |
| ACCTD_AMOUNT_DUE_REMAINING | NUMBER | Oracle internal use only | |
| AMOUNT_DUE_ORIGINAL | NUMBER | Oracle internal use only | |
| AMOUNT_DUE_REMAINING | NUMBER | Oracle internal use only | |
| CHRG_ACCTD_AMOUNT_REMAINING | NUMBER | Oracle internal use only | |
| CHRG_AMOUNT_REMAINING | NUMBER | Oracle internal use only | |
| CUSTOMER_TRX_ID | NUMBER | Oracle internal use only | |
| CUSTOMER_TRX_LINE_ID | NUMBER | Oracle internal use only | |
| DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only |
| FRT_ADJ_ACCTD_REMAINING | NUMBER | Oracle internal use only | |
| FRT_ADJ_REMAINING | NUMBER | Oracle internal use only | |
| FRT_ED_ACCTD_AMOUNT | NUMBER | Oracle internal use only | |
| FRT_ED_AMOUNT | NUMBER | Oracle internal use only | |
| FRT_UNED_ACCTD_AMOUNT | NUMBER | Oracle internal use only | |
| FRT_UNED_AMOUNT | NUMBER | Oracle internal use only | |
| GROUP_ID | VARCHAR2 | 1000 | Oracle internal use only |
| INVENTORY_ITEM_ID | NUMBER | Oracle internal use only | |
| LINE_TYPE | VARCHAR2 | 20 | Oracle internal use only |
| LINK_TO_CUST_TRX_LINE_ID | NUMBER | Oracle internal use only | |
| REASON_CODE | VARCHAR2 | 30 | Oracle internal use only |
| SET_OF_BOOKS_ID | NUMBER | Oracle internal use only | |
| SOURCE_DATA_KEY1 | VARCHAR2 | 150 | Oracle internal use only |
| SOURCE_DATA_KEY2 | VARCHAR2 | 150 | Oracle internal use only |
| SOURCE_DATA_KEY3 | VARCHAR2 | 150 | Oracle internal use only |
| SOURCE_DATA_KEY4 | VARCHAR2 | 150 | Oracle internal use only |
| SOURCE_DATA_KEY5 | VARCHAR2 | 150 | Oracle internal use only |
| BR_LINE_ORIG_AMT | NUMBER | Oracle internal use only | |
| BR_TAX_ORIG_AMT | NUMBER | Oracle internal use only | |
| BR_FRT_ORIG_AMT | NUMBER | Oracle internal use only | |
| BR_CHRG_ORIG_AMT | NUMBER | Oracle internal use only | |
| BR_LINE_REM_AMT | NUMBER | Oracle internal use only | |
| BR_TAX_REM_AMT | NUMBER | Oracle internal use only | |
| BR_FRT_REM_AMT | NUMBER | Oracle internal use only | |
| BR_CHRG_REM_AMT | NUMBER | Oracle internal use only | |
| BR_LINE_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_TAX_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_FRT_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_CHRG_ORIG_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_LINE_REM_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_TAX_REM_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_FRT_REM_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_CHRG_REM_ACCTD_AMT | NUMBER | Oracle internal use only | |
| BR_REF_CUSTOMER_TRX_ID | NUMBER | Oracle internal use only | |
| BR_ADJUSTMENT_ID | NUMBER | Oracle internal use only | |
| LINE_ORIGIN | VARCHAR2 | 30 | Oracle internal use only |
| CM_AMT_DUE_ORIG | NUMBER | Original amount due on the credit memo line. | |
| CM_AMT_DUE_REM | NUMBER | Amount due remaining on the credit memo line. | |
| CM_ACCTD_AMT_DUE_ORIG | NUMBER | Original amount due on the credit memo line in the ledger currency. | |
| CM_ACCTD_AMT_DUE_REM | NUMBER | Amount due remaining on the credit memo line in the ledger currency. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| RA_CUSTOMER_TRX_LINES_GT_N1 | Non Unique | CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID |