AR_TRX_LINES_TMP_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRX_HEADER_ID | NUMBER | Oracle internal use only | ||
| ACCOUNTING_RULE_DURATION | NUMBER | 18 | Oracle internal use only | |
| TRX_LINE_ID | NUMBER | Oracle internal use only | ||
| LINK_TO_TRX_LINE_ID | NUMBER | Oracle internal use only | ||
| LINE_NUMBER | NUMBER | Oracle internal use only | ||
| REASON_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| INVENTORY_ITEM_ID | NUMBER | Oracle internal use only | ||
| DESCRIPTION | VARCHAR2 | 240 | Oracle internal use only | |
| QUANTITY_ORDERED | NUMBER | Oracle internal use only | ||
| QUANTITY_INVOICED | NUMBER | Oracle internal use only | ||
| UNIT_STANDARD_PRICE | NUMBER | Oracle internal use only | ||
| UNIT_SELLING_PRICE | NUMBER | Oracle internal use only | ||
| SALES_ORDER | VARCHAR2 | 50 | Oracle internal use only | |
| SALES_ORDER_LINE | VARCHAR2 | 30 | Oracle internal use only | |
| SALES_ORDER_DATE | DATE | Oracle internal use only | ||
| ACCOUNTING_RULE_ID | NUMBER | Oracle internal use only | ||
| LINE_TYPE | VARCHAR2 | 20 | Oracle internal use only | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |
| RULE_START_DATE | DATE | Oracle internal use only | ||
| INTERFACE_LINE_CONTEXT | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Oracle internal use only | |
| INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Oracle internal use only | |
| SALES_ORDER_SOURCE | VARCHAR2 | 50 | Oracle internal use only | |
| AMOUNT | NUMBER | Oracle internal use only | ||
| TAX_PRECEDENCE | NUMBER | Oracle internal use only | ||
| TAX_RATE | NUMBER | Oracle internal use only | ||
| TAX_EXEMPTION_ID | NUMBER | Oracle internal use only | ||
| MEMO_LINE_ID | NUMBER | Oracle internal use only | ||
| UOM_CODE | VARCHAR2 | 3 | Oracle internal use only | |
| DEFAULT_USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| DEFAULT_USSGL_TRX_CODE_CONTEXT | VARCHAR2 | 30 | Oracle internal use only | |
| VAT_TAX_ID | NUMBER | 18 | Oracle internal use only | |
| TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | 80 | Oracle internal use only | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_VENDOR_RETURN_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| MOVEMENT_ID | NUMBER | Oracle internal use only | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| WAREHOUSE_ID | NUMBER | Oracle internal use only | ||
| CONTRACT_LINE_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 | |
| INVOICED_LINE_ACCTG_LEVEL | VARCHAR2 | 15 | Oracle internal use only | |
| SHIP_DATE_ACTUAL | DATE | Oracle internal use only | ||
| SOURCE_APPLICATION_ID | NUMBER | 18 | Oracle internal use only | |
| SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| SOURCE_TRX_ID | NUMBER | 18 | Oracle internal use only | |
| SOURCE_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| SOURCE_TRX_LINE_TYPE | VARCHAR2 | 30 | Oracle internal use only | |
| SOURCE_TRX_DETAIL_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| HISTORICAL_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| TAXABLE_FLAG | VARCHAR2 | 1 | Oracle internal use only | |
| TAX_REGIME_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| TAX | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_RATE_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| TAX_CLASSIFICATION_CODE | VARCHAR2 | 30 | Oracle internal use only | |
| RULE_END_DATE | DATE | Oracle internal use only | ||
| INTEREST_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| MEMO_LINE_SEQ_ID | NUMBER | 18 | Oracle internal use only |