AR_LINE_APP_DETAIL_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 | Not-null | Comments |
|---|---|---|---|---|---|
| ACCTD_AMOUNT | NUMBER | Oracle internal use only | |||
| REF_ACCOUNT_CLASS | VARCHAR2 | 30 | Oracle internal use only | ||
| AMOUNT | NUMBER | Oracle internal use only | |||
| APP_LEVEL | VARCHAR2 | 150 | Oracle internal use only | ||
| BASE_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | ||
| ACTIVITY_BUCKET | VARCHAR2 | 30 | Oracle internal use only | ||
| CCID | NUMBER | Oracle internal use only | |||
| CCID_SECONDARY | NUMBER | Oracle internal use only | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| DET_ID | NUMBER | Oracle internal use only | |||
| FROM_ACCTD_AMOUNT | NUMBER | Oracle internal use only | |||
| FROM_AMOUNT | NUMBER | Oracle internal use only | |||
| FROM_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | ||
| GROUP_ID | VARCHAR2 | 150 | Oracle internal use only | ||
| GT_ID | NUMBER | 18 | Oracle internal use only | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LEDGER_ID | NUMBER | Oracle internal use only | |||
| LINE_ID | NUMBER | Oracle internal use only | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| REF_CUSTOMER_TRX_ID | NUMBER | Oracle internal use only | |||
| REF_CUSTOMER_TRX_LINE_ID | NUMBER | Oracle internal use only | |||
| REF_CUST_TRX_LINE_GL_DIST_ID | NUMBER | Oracle internal use only | |||
| REF_DET_ID | NUMBER | Oracle internal use only | |||
| REF_LINE_ID | NUMBER | Oracle internal use only | |||
| SE_GT_ID | VARCHAR2 | 30 | 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 | ||
| SOURCE_ID | VARCHAR2 | 30 | Oracle internal use only | ||
| SOURCE_TABLE | VARCHAR2 | 30 | Oracle internal use only | ||
| SOURCE_TYPE | VARCHAR2 | 30 | Oracle internal use only | ||
| TAXABLE_ACCTD_AMOUNT | NUMBER | Oracle internal use only | |||
| TAXABLE_AMOUNT | NUMBER | Oracle internal use only | |||
| TAX_INC_FLAG | VARCHAR2 | 1 | Oracle internal use only | ||
| TAX_LINK_ID | NUMBER | Oracle internal use only | |||
| TO_CURRENCY | VARCHAR2 | 30 | Oracle internal use only | ||
| REF_MF_DIST_FLAG | VARCHAR2 | 15 | Oracle internal use only | ||
| TAX_CODE_ID | NUMBER | 18 | Tax rate code identifier. | ||
| LOCATION_SEGMENT_ID | NUMBER | 18 | Location segment identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_LINE_APP_DETAIL_GT_N1 | Non Unique | GT_ID, REF_CUSTOMER_TRX_ID, REF_CUSTOMER_TRX_LINE_ID, REF_CUST_TRX_LINE_GL_DIST_ID |
| AR_LINE_APP_DETAIL_GT_N2 | Non Unique | TAX_LINK_ID, REF_CUSTOMER_TRX_ID, GT_ID |