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 |